NehaSingh_CV

c

Neha Singh Mobile: +91-9867399240/7208817100

Email: [email protected]

Objective:

I am seeking opportunity to work in a dynamic and progressive organization to obtain a role in business, which will enables me to utilize my skills and expansive knowledge to make a notable contribution.

Summary:

2 years & 8 months of experience in manual testing. 1 year & 5 months of professional work experience in Design and Development

using ETL tool, Informatica in Healthcare and Manufacturing Domain. Profound knowledge of Software Testing Life Cycle (STLC). Good Knowledge in different types of Manual Testing - System & Functional

testing, Regression testing, Smoke & Sanity Testing, Integration testing and UI testing.

Worked closely with Business Analyst to understand the change requests for every release and also worked with development team to narrow down the issues found in application.

1 year of hands on in using Informatica Power Center (9.1.0). Worked in developing ETL program for supporting Data Extraction,

transformations and loading using Informatica Power Center. Developed mappings in Informatica to load the data from various sources into the

Data warehouse different transformations like Source Qualifier, Expression, Lookup, Aggregate, Update Strategy and Joiner.

Self-motivated, delivering commitments within the established timelines, having the courage to raise issues and proactively working towards the issues to resolve them and remove barriers in a timely manner.

Knowledge in developing SQL with relational databases like SQL Server, Oracle 11g.

Skills: Domain Health Care and ManufacturingETL Tools Informatica Power Center 9.1.0Databases SQL Server 2008/Oracle 11gOperating System Windows, 2000/2003 server

Major Assignments: (June - 2015) To (Present) - TATA CONSULTANCY SERVICESProject: SAP CAMERON SERVICESClient Ingersoll Rand Role: ETL Informatica Developer

c



Description:

Ingersoll-Rand Inc. is an Irish-American global diversified industrial company formed in 1905 by the merger of Ingersoll-Sergeant Drill Company and Rand Drill Company. Ingersoll Rand advances the quality of life by creating comfortable, sustainable and efficient environments. At Ingersoll Rand, we're committed to meeting the world's growing critical need for clean and comfortable air, safe and fresh food, energy efficiency and sustainable business practices.

The main objective of the Project is to bring in the Data from Cameron Source System to our Ware-House.

Job Responsibilities :

Team –Size: 5

Developed ETL programs using Informatica to implement the business requirements.

Communicated with business customers to discuss the issues and requirements. Worked on different types of transformations like source qualifier, expression,

filter, aggregator, rank, update strategy, lookup, sequence generator, joiner. Used debugger in identifying bugs in existing mappings by analyzing data flow and

evaluating transformations. Designed workflows with many sessions with decision, assignment task, event wait,

and event raise tasks, used Informatica scheduler to schedule jobs. Effectively used Informatica parameter files for defining mapping variables,

workflow variables. Extensively used ETL to load data from Flat Files, Relational databases to SQL

Server. Involved in Requirement Gathering and Business Analysis. Developed data Mappings between source systems and warehouse components

using Mapping Designer. Setup folders, groups, users, and permissions and performed Repository

administration using Repository Manager. Created, launched & scheduled sessions. Involved in the Performance Tuning of Database and Informatica. Improved

performance by identifying and rectifying the performance bottle necks. Knowledge of Data warehousing concepts, Star schema and Snow-flake schema.

(May-2014) To (May-2015) -TATA CONSULTANCY SERVICESProject: ADSMClient PfizerRole: System Tester

c



Description:

Application Development support and Maintenance (ADSM) offers development, supports and maintenance services in .Net, Java and Drupal. Project mainly focuses on maintenance of web based marketing applications. Project has Quality Assurance team for providing defect free deliverables. This is a project where I test sites developed for Health Care Professionals providing information about the products.

All the micro sites follow a specific format and have to be exactly the same with the exception of content and body. A specific layout needs to be followed for maintaining consistency at all times. It includes Functional, Sanity, Smoke, Regression and UI testing as well.

Job Responsibilities:

Team –Size: 8

Effectively communicated with developers to understand requirements and bugs. Expertise in following components of STLC:

Test planning and management Requirement Analysis

Documentation: Performing crucial role in designing and reviewing the following documents: Test Plan Functional Test Cases Traceability Matrix Test Summary Report

Test Execution: Involved in performing following types of testing: Functional Testing

UI & Cross Browser Compatibility Testing Testing Tools : Bugzilla, Jira, QAfied

(April-2013) To (May-2014) - TATA CONSULTANCY SERVICESProject: EngageClient PfizerRole: System Tester

Description:

Engage system was based on Food and Drug Administration (FDA) rules & regulations. It is one that automates the process of organizing US HCP Consulting Engagement from start to finish.

Engage application was a combined Development & Testing project based on .Net Technology. It was large, complex & workflow based application. Development of

c



Engage application was based on Agile Methodology where functional requirements and processes update rapidly.

Job Responsibilities:

Team –Size: 14

Effectively communicated with developers to understand requirements and bugs. Expertise in following components of STLC:

Test planning and management Requirement Analysis

Documentation: Performing crucial role in designing and reviewing the following documents: Test Plan Functional Test Cases Traceability Matrix Test Summary Report

Test Execution: Involved in performing following types of testing: Functional Testing

Educational Qualifications:

Qualification University / Institute Year MarksB. Tech (Telecommunication Engineering)

SIR MVIT, Bangalore

2008-12 76.29%

12th DAV Public School, Patna (C.B.S.E)

2007 84.2%

10th DAV Public School, Patna (C.B.S.E)

2005 86.4%

Awards & Achievements:

Year Awards & Achievements2014 Awarded with “On the spot award and Best Team” often for hard

work and dedication towards assignments. 2015 Received Service and Commitment award.2015 & 2016 Appreciated by the Client for Prompt Response and Quick delivery.

Personal Dossier:

Interests: Watching movies, Listening to music and cooking

c



Home Address: Justice Dharampal Path, House No-21C/211, Road No. 21, Rajeev Nagar, Patna, Bihar Current Location: Mumbai-IndiaDate of Birth: 17-09-1989

Declaration:

The above information is true to the best of my knowledge. I take myself as a competent and sincere candidate in handling the job successfully.

PLACE: MUMBAI NEHA SINGH

NehaSingh_CV

Documents

Transcript of NehaSingh_CV