Candidates About

 

Manish Singh

 

PROFESSIONAL SUMMARY

 

•          Over 13+ years of Software Testing and application support, with specialization in Data warehouse (ETL and Report testing) and MDM testing.

•          Expertise in working on projects involving Data warehousing (DW) and Business Intelligence (BI) testing using different tools like Informatica, MSBI and Cognos. Informatica IDQ, Informatica Analyst, Control-M

•          Extensive Experience in Quality Center which includes Uploading Requirement, Preparation of Test cases and uploading, Execution of Test Cases, Logging & tracking Defects, Preparation of Metrics and Preparing Status reports for test design Phase and Execution Phase.

•          Exceptional communications and interpersonal skills with well-developed personal interaction skills.

•          Highly motivated, organized, able to work independently and able to switch between projects quickly.

•          Good knowledge of SDLC and Software Testing Life cycle.

•          Experience, interest and expertise make me suitable for a position in the field of Software Testing and Quality Assurance, and interested in working for an organization that provides excellent growth prospects.

•          Proficient in writing SQL queries.

•          Perform a test coverage traceability analysis to ensure that all requirements and supporting specifications are tested through the Test Cases with duplicates, invalid, and out-of-scope scenarios removed.

•          Good exposure in all phases of software development lifecycle covering requirement capture, analysis, estimation, software integration, implementation and production support.

•          Adequate exposure to status reporting, escalation and executing project as per plan.

•          Good experience in ETL Testing, Report Testing, Database Testing, System Testing, UAT Testing, Performance Testing and Regression Testing.

•          Expertise in working in Unix environment.

•          NSE certified in Finance Marketing (NCFM).

•          Having Informatica and MSBI external certification.

•          Scaled Agile Certified SAFe 4.0 Practitioner.  

 

TECHNICAL SKILLS

 

Operating Systems:                            Windows and Unix

Languages:                                         SQL, PL/SQL, Basics Unix Shell Scripting

Database:                                            Oracle 10g, Oracle 11g, SQL Server 2005, SQL Server 2008

Data Warehousing Tools:                  Informatica PowerCenter 8.6, ODI, Micro strategy, MSBI, Control-M, Cognos, Informatica IDQ, Informatica Analyst

Testing Tools:                                     LoadRunner, AppScan, Toad, SQL developer, Putty, Xmanage, Informatica DVO, iCEDQ

Configuration Tools:                          Visual Source Safe

Project Management Tool:                Microsoft Office Project Web Access, Microsoft Project 2013

Quality/Defect Management Tool:    Mercury Quality Center, ALM, JIRA, BMC Service Desk Express and BMC Remedy

Agile Tools:                                        Rally, PMF, VersionOne

 

EDUCATIONAL QUALIFICATION

 

Bachelor of Technology (B.Tech) in Information Technology from Dr. A.P.J. Abdul Kalam Technical University (Formally UP Technical University), Lucknow, UP, India in 2004.

 

CERTIFICATIONS AND TRAININGS

 

•          NSE certificate in “Finance Marketing”.

•          Certificated in “Informatica Power Center 8 Mapping Designer”.

•          Certificated in “ISTQB-BCS Certified Tester Foundation Level”.

•          Certificated in “Microsoft SQL Server 2008 – Business Intelligence Development and Maintenance”.

•          Certificated in “Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008”.

•          SAFe 4 Certified Practitioner from SCALED AGILE

 

PROFESSIONAL EXPERIENCE

 

Project 1: MDM – Provider (Sept. 2015 – Till Date)

HealthFirst, NYC, NY

September 2014 – Till date

Sr. Associate; Lead ETL and MDM Quality Analyst

•          Tools: Informatica Data Quality 9.6, Informatica Analyst, Control-M, Informatica Power Center 9.5, HP ALM, PMF, VersionOne, SOAP UI, PostMan

•          Test Automation: Informatica DVO, Platinum, iCEDQ and Micro based automation.

•          Methodology: Agile

•          Databases: SQL Server 2012, Oracle

•          Operating Systems: Windows XP

•          Domain: HealthCare

 

MDM – Provider project is aimed to enhance and enrich the Data Quality for MDM. The project involves migration of SQL Data to Oracle database. The project is executed in different sprint and tracked using PMF and VersionOne tool.  The current Provider and member data is stored in multiple systems without a single source of truth. This has led to continuous data and information challenges for strategic data-driven initiatives and ongoing processing challenges in the operational environment. Data sent from one application to another application is often changed as it is passed in order to accommodate system limitations. When this altered data is sent further downstream to other applications, the traceability back to the original data becomes difficult or impossible. The impact is seen when a pended claim requires hours of research and countless resources in order to determine the root cause. For the client to meet the future business and technical needs, the provider data has to have a common identifier across all client systems.

Additionally, provider and member data is not standardized and structured across the various systems like MHS. For example, the inability to have consistent and conformed Provider specialty taxonomy prevents to consistently report on Providers by Specialty. This leads to inefficiencies and increased costs. Also, from member side there are issues with Data Quality (e.g. Bad Addresses) which cause returned mail and have a financial impact.

 

Responsibilities:

•          Design, develop and execute test strategies/plan, Setting up the testing environment, debug and troubleshoot, perform impact and gap analysis and give inputs for status reporting, issue resolution, defect tracking and defect triage activities.

•          Creating Requirement Traceability Matrix.

•          Providing Story points based estimation.

•          Documenting all the testing needs & status and reporting the project management on regular basis or on need.

•          Performing ETL testing, MDM testing, WebServices testing, Regression testing and Integration testing.

•          Responsible for providing inputs to the daily testing and defect status reports

•          Working with business/Program team in developing End-to-End test cases

•          Develop and execute test scripts to validate the user stories as per acceptance criteria.

•          Assisting the UAT users in identifying the test data and providing clarifications on technical design related queries

•          Coordinating with offshore team to accomplish the tasks as per the project plan.

•          Defect Triage meeting with Downstream systems.

•          Data Analysis to discover useful information, suggesting conclusions, and supporting decision-making for Downstream systems.

•          Data Analysis to find the trend of data based on requirement from Downstream System.

•          Data profiling to see the data quality is at threshold value.

•          Automation using Platinum ( inhouse ) tool

 

Project 2: TogetherRx – Data Migration (May 2014 – Aug. 2015)

Walgreens, Pittsburgh, PA

May 2014 – August 2015

Sr. Associate; Lead - Quality Analyst

•          Tools: SQL developer, SSIS, SSRS, Toad, HP ALM

•          Methodology: Agile

•          Test Automation: Platinum, iCEDQ and Micro based automation.

•          Databases: Oracle

•          Operating Systems: Windows XP

•          Domain: HealthCare

 

TogetherRx project is aimed at updating the current front end application ScriptMed from version 1.0 to version 6.0. As part of this upgrade data is migrated from old environment to the new after applying cleansing, de duping and new transformations to meet the new application requirements. The project involves data migration from ScriptMed v1 application to ScriptMed v6 application environment. The project involves migrating data 5 different location. The QA activities involve validating that the data is cleansed to remove the irrelevant data based on the business rules, the rules for de-duplication has been applied properly and then validating that the data has been migrated to the new environment as per the business requirements.

 

Responsibilities:

•          As a Technical lead - Quality Analyst team for TogetherRx project, involved in the critical data migration part of TogetherRx project. My responsibilities includes,

•          Analyzing the requirements document, business/technical specification document and come up with business test scenarios.

•          Creating Requirement Traceability Matrix.

•          Providing Story points based estimation.

•          Performing ETL testing, Regression testing and Integration testing.

•          Manage, plan, administer and execute Quality Assurance (QA) system test activities.

•          Design, develop and execute test strategies/plan, Setting up the testing environment, debug and troubleshoot, perform impact and gap- analysis and give inputs for status reporting, issue resolution, defect tracking and defect triage activities

•          Documenting all the testing needs & status and reporting the project management on regular basis or on need

•          Responsible for providing inputs to the daily testing and defect status reports

•          Working with business/Program team in developing End-to-End test cases

•          Assisting the UAT users in identifying the test data and providing clarifications on technical design related queries

•          Coordinating with offshore team to accomplish the tasks as per the project plan.

 

Project 3: EDT Platform and WTRIS (Sept. 2013 – May 2014)

NIIT Technologies INC, Phoenix, AZ

September 2013 – May 2014

Test Consultant; Lead QA and Business Analyst (Onsite)

•          Tools: SQL Server 2010, SSIS, SSRS, JIRA, VISIO, HP ALM

•          Methodology: Agile

•          Test Automation: Micro and Batch jobs based automation.

•          Databases: SQL Server

•          Operating Systems: Windows XP

•          Domain: Banking and Finance

 

Wilmington Trust Retirement and Institutional Services Company (WTRIS) is dedicated to designing and delivering professional solutions that increase their business partners' competitive advantages. WTRIS is serving the retirement industry and expertise to meet the needs of TPAs, consultants, and registered investment advisors.

Lead Requirements Gathering and Quality Assurance activities at client site to understand the current business of client. This involved analysis of complete analysis of extended day trading process (manual), extensive analysis of business processes and IT systems, identification of client problem areas, create As-Is and To-Be process maps and hence propose automation opportunities.

a. Straight through Processing including As of Day trades for 401k Plan to NSCC

b. Cash reconciliation between Accounting and Settlement Platforms

c. Position reconciliation between Accounting and Settlement Platforms

d. SDR Compliance and Reporting

e. B50 – Fund Add Process

f. B52 – Fund re-registration Process

g. Synchronization of master data for Fund and Fund Account and create a golden source.

h. Validation and control of data across various systems

Agile framework was used to implement the automation activities.

 

Responsibilities:

•          Located at client site for direct interaction on requirement gathering, user story definition, and approval and QA activities.

•          Requirement Analysis/Gathering and liaising with business and technical teams.

•          Performing ETL testing, Regression testing and Integration testing.

•          Creating Requirement Traceability Matrix.

•          Providing Story points based estimation.

•          Prepare QA strategy and QA Plan.

•          Writing/Reviewing test scenarios.

•          Writing/Reviewing/executing test cases.

•          Test Management and Planning.

•          Functional/Regression/Performance/Smoke/Integration Testing

•          Deployment of deliverables

•          Query Resolution of offshore team.

•          Reporting and Status tracking.

 

Project 4: SPTC (Jul. 2011 – Sept. 2013)

NIIT Technologies Ltd., India

July 2011 – September 2013

Lead- Test Consultant

•          Tools: SSIS, SSRS, SSAS, VISIO, VB.NET, VB6, SQL 2000, SQL 2005, SQL 2008, Informatica, PVCS Tracker, BMC Magic, LoadRunner, SoapUI and AppScan

•          Methodology: Agile

•          Test Automation: Micro Based test automation

•          Databases: SQL Server 2010

•          Operating Systems: Windows XP

•          Domain: Banking and Finance

 

SPTC is basically involved in activities for Managing Assets and Managing Funds for its clients. SPTC processes transfers for 80+ banks. Transfers processed by SPTC include Receipts (processed using A2T2 and Free Receipts applications) and Deliveries (processed using DTS [ACATS] and Depository Delivery [NON-ACATS] applications).

 

Responsibilities:

•          As a Project Lead, am handing a team of 6 QA and 8 Dev team members responsible for delivery, deadline and quality of Development as well as maintenance projects of 22 different applications of SPTC suite.

•          Prepare Release Milestone Calendar.

•          Prepare Project Plan.

•          Creating Requirement Traceability Matrix.

•          Providing Story points based estimation.

•          Performing ETL testing, Regression testing and Integration testing.

•          Performance Optimization of SQL Scripts.

•          Defines and generates the traceability matrix

•          Review and approve all test cases prior to execution

•          Reviewing QA Strategy, Test Cases and Defects.

•          Conflict Management.

•          Performing Test execution.

•          Build Verification.

•          Sanity testing of a deliverable builds.

•          Defining Product release game plan and prepare Product Readiness document.

•          Coordinating with Business, Architects,  DBA, Information Security, Support and on-site Counterpart to get the quality product delivered on time

•          Providing Support for the application

 

Project 5: Investment Management Unit (Oct. 2010 – Jul. 2011)

NIIT Technologies Ltd., India

October 2010 – July 2011

Test Consultant (QA Lead)

•          Tools: SSIS, SSRS, SSAS, VISIO, VB.NET, VB6, SQL 2000, SQL 2005, SQL 2008, Informatica, PVCS Tracker, BMC Magic, XML, AppScan, LoadRunner, Mercury Quality Center.

•          Databases: SQL Server 2010

•          Methodology: Agile

•          Test Automation: Micro Based test automation

•          Operating Systems: Windows XP

•          Domain: Banking and Finance

 

Responsibilities:

•          Being a QA Lead I handed a team of 5 QA members responsible for Quality of below listed applications:

•          IMU BI – This is a Data warehouse for IMU and is used to generate reports used by IMU business team for reporting different types of returns.

•          Bonaire – This is Report application used by SEI for calculating Fees for the manager.

•          IMU MQ – This is an application to enable Managers to enter their Monthly & quarterly returns for their sub portfolios and composites.

•          Wealth SSRS reports – SSRS Reports for High Net Worth clients

•          BlackRock project – BlackRock Green Package is a third party application for portfolio risk management. NIIT team is involved in the development of the interfaces to and from this application.

•          Bonaire Advisor – Development of interfaces.

•          Canada Factsheet – Development of SSRS reports.

•          IT Advantage fee Cube – Development of Cubes using SSAS and underlying data using SSIS.

•          Compliance Portal – Development of Portal interfaces

•          Performing ETL testing and Report Testing, Regression testing and Integration testing.

•          Define QA Strategy.

•          Defines and generates the requirement traceability matrix

•          Providing testing effort estimation.

•          Review and approve all test cases prior to execution

•          Manages content within the Quality Center environment (requirements, test plan, test lab and defects)

•          Work closely with development to understand requirements and design for the purposes of scoping the project level test plans

•          Design test cases associate to change requests (regression testing)

•          Analyzing the Source to Target mapping (STM) documentation.

•          Test Plan and Test Estimation preparation.

•          Prepared detailed test cases on the basis of Source to Target mapping (STM) documentation.

•          Reviewing and testing for completeness and correctness of data.

•          Coordinated with development team and onsite team for bug fixes.

•          Created Defect report for all releases.

•          Reviewing SPs for performance

•          Support of application after GA production release.

  

Project 6: BSARA- BLADELOGIC (Jul. 2009 – Oct. 2010)

Globallogic, India

July 2009 – October 2010

<span st