Informatica Mdm System Analyst
Resume:
Objective:
Innovative Professional with **+ years of experience as a Senior IT Quality Analyst/Team Leader now seeking a professional position in a progressive challenging environment where my technical experience and strong analytical skills would add value. I am a self-motivated team player; adaptable to change with excellent problem-solving skills.
Processional Summary:
Overall 12+ years of experience in Software Testing.
Having 2.5 years of experience in Data Warehousing Testing.
Skilled in Software Development Life Cycle (SDLC) and Testing Life Cycle (TLC) processes.
Proficient in extrapolating User Stories to requirements and development of Test Strategies.
Experienced in documenting Test Plans and Test Scripts.
Experienced in performing Functional, System, Regression, GUI testing, Cross browser, Back-End testing and User Acceptance Testing (UAT) for Client/Server and Web Based applications.
Experienced in Microsoft .NET applications.
Experienced in Database testing using T-SQL and SQL Server, ORACLE 11g and TOAD.
Experienced in Data Warehousing and ETL.
Hands-on experience in running jobs in SSIS, Informatica MDM and Tivoli Workload Scheduler(TWS) tools.
Hands-on experience on using Microsoft Team Foundation Server (TFS) and Visual Source Safe(VSS) for configuration management
Experienced in Bugzilla, Mercury - HP Quality Center and HP ALM.
Knowledgeable in UNIX shell scripting, FTP/SFTP and file management in UNIX environments.
Hands-on experience in Agile methodology.
Knowledge on Performance Testing using HP Load Runner.
Technical/Software Skills:
Testing Management Tools
Quality Center 10.0, HP ALM 11.0
Bug Tracking Tools
Bugzilla, Jira
Databases
SQL Server 2005/2008/2012, Oracle 11g, Teradata 14.00
Database Tools
Toad for Oracle 10.6
Web Servers
IIS 6.0/7.0
Operating Systems
Windows Server 2k/2k3, Windows XP/Vista/7/8/10, UNIX
Source Control
Microsoft Team Foundation Server, Visual Source Safe, GitHub,
Automation Tools
VSTS, HP Load Runner
Academics & Professional Certifications:
Bachelor of Engineering (B.E.), Computer Science
Accredited Integration Specialist (AIS) - HP QUALITY CENTER 9.2
M16 HP QUICK TEST PROFESSIONAL 9.2 SOFTWARE
Professional Experience:
Project : Home Care Registry OCT 2016 to Till date
Role : System Analyst
Client : Data Warehouse Labs Inc.
Description:
The Home Care Services Consumer Protection Act (AB 1217) project is focused on ensuring that California’s elder and dependent adults have the available resources to locate a HCA who has been registered and cleared of any criminal background. This system provides HCOs and HCAs the ability to register online and renew online by a unique identifier and allowing the public to search for HCAs who have been cleared by DOJ and FBI.
Responsibilities:
Responsible for managing and planning test team activities.
Worked with Business Analysts and Developers on testing of requirements.
Reviewing requirements and making test plan changes accordingly.
Responsible for creating test specifications and testing data for coverage of requirements.
Performed data validation testing by writing SQL queries.
Managed Test Cases, Test Plans, Defect Tracking using HP ALM.
Involved in change management process.
Followed Agile methodology.
Prepared Test summary reports and shared with the stakeholders.
Environment:
Visual Studio .Net 2013, ASP.Net, C#.Net, SQL Server 2012, Windows Services, TFS, HP ALM,
Agile methodology.
Project : Unified Data Warehouse (UDW) Jul 2014 to Jul 2015
Role : Senior IT Quality Analyst
Client : United Healthcare Services/Optum Global Services (OGS), U.S.A.
Description:
The primary objective of the Unified Data Warehouse (UDW) was to provide a single, consolidated analytics environment to create the foundation for delivering world-class business intelligence capabilities to all UnitedHealth Group business segments. STAGE, Source Repository and BASE.
Responsibilities:
Responsible for managing and planning test team activities.
Worked with Business Analysts and Developers on testing of requirements.
Responsible for creating test plans, test specifications and testing data for coverage of requirements.
Performed data validation testing by writing SQL queries in TERADATA.
Prepared Test summary reports and shared with the stakeholders.
Involved in writing Production test scripts.
Involved in production deployment and Business verification testing.
Environment: Teradata, HP ALM 11, Tivoli Workload Scheduler (TWS), UNIX, Agile methodology, TFS
Project : GER (Global entity repository) Nov 2011 to Oct 2013
Role : Test Lead/Test Engineer
Client : Infosys Pvt Ltd., Price Water Coopers (PwC), U.S.A.
Description:
GER (Global entity repository) focused on implementing full service MDM (Master data management) platforms that provides a solution for effectively managing entity data on network wide basis.
Responsibilities:
Managed Project and Team assignments.
Reviewing requirements and making test plan changes accordingly.
Managed Test Cases, Test Plans, Defect Tracking using - HP Quality Center, HP ALM.
Performed – Regression, Functional and User Acceptance Testing.
Performed Performance Testing using VSTS tool.
Involved in writing Production test scripts.
Involved in change management process.
Followed Agile methodology.
Involved in production deployment and Business verification testing.
Environment: TOAD for Oracle 10.6, Quality Center 10.0, HP ALM 11.0, SSIS and Informatica MDM, TFS
Project : Sulprice Dec 2008 to Nov 2011
Role : Software Engineer
Client : Valtech/Sulzer Chemtech Ltd, Winterthur Switzerland
Description:
Sulzer Chemtech develops solutions that optimize the performance of industrial processes and plants through greater energy efficiency, higher product quality, and increased capacity.
Responsibilities:
Participated in the whole software development cycle of the project.
Reviewing requirements and Responsible for creating Test scenarios and Test Cases.
Participated in Test Plans.
Performed – Regression Testing, Functional Testing and System Testing.
Submitted bugs and enhancements as needed using Bugzilla (Bug Tracking Tool).
Used SQL Server Management Studio.
Environment: ASP.net, VB.Net, Visual Studio, MS SQL Server 2008, VSS, Bugzilla.
Project : SMP June 2008 to Dec 2008
Role : Software Engineer
Client : ADEA Technologies Pvt Ltd., Sulzer Chemtech Ltd, Winterthur Switzerland
Description:
Sulzer Mixing Program (SMP) is a Web based application. The Application permits users in designing, pricing and order processing of Mixing and Reaction Technology products. It also uses SAP system to transmit data from SMP to SAP server.
Responsibilities:
Participated in the whole software development cycle of the project.
Participated in Test Plans.
Responsible for creating Test scenarios and Test Cases.
Performed – Regression Testing, Functional Testing and System Testing.
Submitted bugs and enhancements as needed using Bugzilla (Bug Tracking Tool).
Environment: ASP.net, C#.Net, Visual Studio, MS SQL Server 2008, VSS, Bugzilla.
Contact this candidate