PROFESSIONAL SUMMARY

• Overall, 17 years of professional experience as QA Analyst with about 9+ years in Pharmaceutical Industry as QA Manager and about 7+ years of IT experience in ETL Testing/ Developer of Data Warehouse systems, ETL processes, Business Intelligence and maintenance of the Test Strategies.
• Test Plans, Test Result documents and Defect reports. Also, worked on Web application Security testing viz., User Authentication and Authorization, User Roles, Groups and Access, PII, PCI.
• Extensively worked on various ETL tools: DataStage, Informatica Power Center, Ab Initio.
• Testing of full lifecycle on Data warehouses and Business Data marts with Star Schemas, Snowflake
• Very good experience in writing SQL queries with database languages such as SQL and PL/SQL which includes writing Stored Procedures, Functions, Views and Cursors.
• Experience in various stages of System Testing Life Cycle (SDLC) and approaches like Waterfall, Agile Scrum.
• Extensive experience in manual testing the ETL and Business Intelligence Applications, XML Validations.
• Expertise on HP ALM, qTest, Jira in creating new defects with appropriate priorities, severities, assigning to the concerned teams and then defect tracking and retest and closing the defect, using BRDs.
• Vast Experience on Webservices Testing using SOAP UI.
• Extensively worked with different data sources, non - relational databases such as Flat files, XML files, legacy systems like mainframes and other relational sources such as Oracle, Teradata and SQL Server.
• Well experienced on Live analysis of Test Cases using Dash Boards in ALM, linear, bar graphs, pie charts.
• Experience in transformation logic testing for Data Analysis, Data Profiling, Data Cleansing, Transformation, Consolidation, Integration testing using various sources (Oracle, MS SQL Server, XML and Flat files, Teradata.
• Experience in creating mappings, mapplets and reusable Transformations using Informatica Power Center Designer, Parameter Files.
• Expertise in testing the database with Change Data Capture (CDC) Techniques like slowly changing dimensions (type1, 2 and 3).
• Working knowledge in Dimensional and Relational Data Modeling experience in Star Schema/Snowflake modeling, FACT & Dimensions tables, Cubes, Dash Boards, Physical & logical data modeling.
• Expertise in doing Unit Testing and Data Validation for Developed Informatica Power Center Mappings.
• Excellent Analytical, Communication skills, working in a team and ability to communicate effectively at all levels of the development process.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, UNIX Shell Script

Tools: QC ALM, Jira, Soap UI, Informatica (Power Center 8.6, 9.x) (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Ab Initio, Erwin 8.6, DataStage, Clear quest.

Databases: Oracle 10g, 11g, MS SQL Server, Teradata, XML Publisher, DB2, Netezza, SAS.

Operating Systems: Windows NT/ XP/ Vista, LINUX, UNIX, DOS, Windows OS.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Sr. ETL Tester/Analyst

Responsibilities:

• Involved in Data Migration from diverse databases using DataStage as the ETL tool to create the Data Warehouse project.
• Key communication and coordination between Confidential PMO, scrum dev teams and the QA Resources.
• Created jobs in DataStage as per the business requirements.
• Writing queries to test the Actimize Application to support impact of user interface views
• Working on data related to Accounts, Members and the related Transactions on different types of LOBs like Banking, Insurance, Debit Cards, Credit Cards, Brokerage etc.
• Develop and execute detail ETL related functional, Integration and Regression test cases, and documentation on PDT, on Millions of records, to find the missing records.
• Involved in validating the CDC data (Change Data Capture) test cases with respect to flags and timestamps.
• Strong in SQL Scripts/queries in Oracle, DB2, Teradata, SQL server and Netezza data base systems.
• Engage in peer reviews during design, coding and testing and Creating Requirement Traceability Metrics.
• As part of Application testing involved in testing the configuration as per Confidential requirements.
• Creating Alert Generation mechanism with ERCM, CDD & SAM module workflow and Policy Manager Usage
• Working on testing the Transaction Monitoring (TM/SAM) source and use of funds. Identifies, analyzed and monitored relationships of address, phone number and IP address.
• Involved in the live analysis of test execution status on weekly basis for Defect Triage meetings, Sprint daily Stand-up Meetings, Sprint Planning Meetings.
• Performed QA tasks such as writing Test Plans, Requirements, Cases, execution, reports, etc. in qTest and Jira.
• Participating in scrum test planning meetings, leadership team meetings, project status meetings, design reviews, scrum team meetings, status and stand-up meetings and walk-troughs.
• Write, execute and debug complex SQL queries to perform data completeness, correctness, data transformation, Metadata, transformation rules, S2T mapping verification etc.
• Analyzed the AML (Anti Money Laundering) risks associated with the client from a technical perspective.
• Plan test scenarios to address QA Testing during the ETL Development phase, configure and integrate of various data sources like Oracle, Netezza, and MS SQL Server, Flat file into the staging area and design ETL processes.

Environment: Oracle 12c, DB2, Netezza, SAS source System, qTest, DataStage, JIRA.

Confidential, Dallas, TX

ETL/Web Services Tester.

Responsibilities:

• Involved in Migration of Maintenance Project using Ab Initio Testing.
• Involved in business requirement gathering for integration of their domestic and international travel reservation systems.
• Involved in Certification (End-to-End) testing of central reservation system predominantly on the backend database testing by writing complex SQL queries, PL/SQL Stored Procedures, minus queries from source to target and vice versa.
• Involved in preparing detailed and reviewed Test cases to cover all the requirements and S2T Mapping documents by the Data Modeling Architect.
• Analyzed Documents to develop and Execute Test scripts and documented Test Cases corresponding to business rules using HP ALM.
• Good experience on Functional Testing, Integration Testing, on different environments UAT, PDT.
• Involved in Regression testing by validating CDC data (Change Data Capture) test cases with respect to flags and timestamps.
• Involved in Web Services testing using SOAP UI for generating various reports.
• Experienced in the use of agile approaches, including Agile Scrum.
• Generating the SQL queries for Automation Reports on multiple tables using multiple Join Conditions.
• Involved in the various types of testing, Integration testing, functional testing and Performance Testing and Regression Testing.
• Experienced in Unit Testing on the in-pod user stories to validate data against individual transformations.
• Involved in various types of database testing using Teradata, Oracle, raw data files and XML files.
• Working with UNIX commands to transfer the required files to validate the source data against the Database.
• Generating reports using Crystal Reports for minimum business requirements.
• Involved in the live analysis of test execution status on weekly basis for team meetings report submission.
• Involved in the daily Defect Review meetings to explain on the defects raised by our team members.

Environment: Oracle11g, Teradata 15.0, PL/SQL, HP ALM 12.50, Ab Initio, XML, SOAP UI 5.0, ClearQuest and JIRA.

Confidential

Jr. ETL developer /UI Tester

Responsibilities:

• Gathered business requirements, validated the technical design document and created source to target mapping documents.
• Worked with creating mappings using Informatica Power Center Designer using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups, Dynamic and Persistent Cache, Mapplets, reusable transformations.
• Worked on validating the Dimension tables with SCD (Type1 and Type2) changes along with the FACT tables.
• Involved in developing and enhancing meta-data and engaged in peer reviews.
• Helped Production Support team during the Scheduled runs.
• Created UNIX shell scripts and batch files to invoke the SQL scripts which are run daily.
• Documented and build Test Plans which encompass the business requirements specific to each application.
• Worked with testing team in implementing HP Quality Center Business Process Testing.
• Experienced in the use of agile approaches, including Agile Scrum, Team meetings & QA Test Reviews.
• Involved in writing and validating the data on Incremental extract test cases with respect to various audit columns, i.e., Version number, Effective Flags and Effective Timestamps.
• Experience in testing user identity management viz., their access, groups, roles, permissions, PII compliance to validate against the security requirements.
• Involved heavily in writing SQL queries to pull the required information from Database using Oracle.

Environment: Jira, Quality Center, Oracle 11g, Informatica, SQL, PL/SQL, UNIX, Softerra LDAP Browser, Telnet.

Confidential

QA Analyst

Responsibilities:

• Testing of various Products at different phases of Drug manufacturing and Certificate of Analysis of Finished Drug Products
• Performing Method development and Method Validations using various Instruments and FDA guidelines.
• Responsible for writing Analytical test reports, Certificate of analysis, Standard Operating Procedures (SOPs), Method validation protocols.
• Generating the QC Reports on Certification and giving the results to the QA team for Documentation.
• Responsible for conducting preventive maintenance and calibration for laboratory instruments
• Knowledge of cGMP and FDA guidelines.
• Software handled: Empower Software by HP, Millenniums by Water, Total Chrome by Agilent, Chemstations, Chem-draw and Scientific websites.
• Computer knowledge: Oracle and Microsoft Office (Word, Excel, Access and Power point)

Confidential

Junior Scientist

Responsibilities:

• Discovery Research is a division in Reddy’s Laboratories who develops new Drugs on anti-inflammatory Anti-Cancer and Antidiabetic drugs.
• Worked on Analytical Research department in analysis the sample drugs and reporting the critical elements and product purity and impurity percentages.
• Worked in VALIDATING using the Precision, Accuracy, Regression, Robustness, Linearity and Range.