SUMMARY:

• Over 10 + years of Professional experience in various roles as an ETL Test Lead, Database Tester, Oracle Forms and Report Developer and QA/Business Analyst.
• Possess specific experience in the Banking (Home Mortgage), Financial, Educational Institutions, Health Care with Experience in EDI Eligibility (HIPAA 834, 837, 270, and 271) and Facets, EPIC, and Practice Fusion, Manufacturing, Agricultural, Aviation and Financial Domains.
• As a QA Lead, I am comfortable working on multiple products, confident in my ability to see beyond the fix and motivated to work collaboratively across product groups and Manage to ensure that wherever product has been developed under my supervision has quality oriented.
• Developing QA Team with main goal to improve the learning curve by Spreading best practices, I have learn along my whole career in diversified fields - Oracle Developer, Forms and reports, ETL Test Lead, Data Warehouse Testing, Industrial Engineering QA Management and Mechanical Engineering background.
• Worked with SIT Engineers, IDO’S, SME’s, and BDO’s. Program Managers, Agile Scrum Masters, Enterprise Architecture EA, Software Engineering SE, Project Managers PM, Delivery Managers DM, and other offshore Team members.
• Decision making by not being overwhelmed by stress and not hesitating to recognize a mistake soon - as it is much better than trying to work around for years the issue by taking innovative (or risky) initiatives.
• Managed Planning, prioritization of all the test-related tasks and used proven project management tools such as the V-Cycle or Scrum methodology in previous projects.
• Taking the responsibility of certain designs if people have not the required competencies
• Code reviewing and Involved in Writing the test strategies, Reviewing the test plans
• Contributed the department and organization reputation by accepting ownership for accomplishing new and different requests; exploring opportunities to add value to job accomplishments.
• Hands on expertise in Data warehouse (DW) concepts and DW Automation tools.
• Involved in the QA ETL processes using Data stage, Informatics and Ab initio.
• Extensive knowledge of entire Software development life cycle (SDLC) and involved in different stages of SDLC on different projects.
• Planning and implementing projects and Working in a fast-paced environment while solving crises.
• Extensive testing ETL experience using Informatica 9, 8.6, 8.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager), Data Stage, SSIS.
• Extensive experience in testing and implementing Extraction, Transformation and Loading of data from heterogeneous sources into Data warehouse using ETL Tools.
• Proficient in different Databases like Oracle, SQL Server, DB2, Sybase and Teradata.
• Experience in testing and writing SQL and PL/SQL scripts with tools like TOAD, SQL Developer and Rapid SQL.
• Lead QA offshore team for DuPont- Field Experience Reporting Project. Created Test Strategy, Test Plan and Test Cases.
• Successfully implemented the KANBAN concept- A Dependency Tracker at BCBSNC- A logical work flow with DEPENDENCY check among current user stories in each Sprint.
• Worked on different Projects On and Off-Shore Teams.
• Validated Reports created using Business Objects and Cognos Reports test cases and develop Traceability matrix.
• Experience managing PV/QA teams on initiatives of at least 3 people Proven ability to manage disconnected teams at multiple locations
• Capable of adapting to a rapidly evolving environment Strong people management, interpersonal communication and collaboration skills

TECHNICAL SKILLS:

ETL /BI Tools.: AbInitio, Informatica, Datastage, SSIS,SSAS, SSRS, Datanomics

Database/Tools: GreenPlum, ORACLE 11i, DB2 10.5, TERADATA, EssBase, Sybase

Job Schedulers: Control - M

Reporting Tools: Tableau, Cognos 10.2.1, SAP Business Objects. Crystal Reports

Languages: PL/SQL, SQL, VB Scripts, Java Scripts, C, HTML, XML.

Testing Tools: RTC, JIRA, TSF, MTM, HP ALM, LISA-DevTest, QuerySurge

Methodologies: Waterfall, Iterative, Agile, SDLC, STLC,

Operating System: MS-DOS, MS -Windows, NT, and exposure to UNIX and Linux.

Applications: GuideWire, Ellucian Banner, Moodle and Facets

PROFESSIONAL EXPERIENCE:

Confidential, Saint Louis Park, MN

Implementation Partner

• Analyzed Business Requirements and Functional Systems Design Specifications to create test strategies and test cases
• Executed test cases against IVR, CTI, and Call Routing applications
• Specified test data requirements and work with enterprise data team to obtain necessary test plan data
• Performed release validation and regression testing post production installations - typically occurring outside of standard business hours; some weekend and/or evening hours are required
• Work with Business Consultants and End Users to confirm issues identified during testing
• Serve as UAT point of contact; represent WFVC UAT on project teams and project and release meetings
• Managing the off-Shore QA team of 6 testers and reporting the status to the QA director.

Confidential, Merrillville, IN

V3 Enterprise Corp

• Coordinate the project and manage QA offshore team of Confidential, a healthcare application (www. Confidential .com) The Application is tested for both Android and iOS.
• Reorganized the team in Hyderabad, India to establish and implement efficient SDLC processes and fostered the transition to an agile methodology. Spearheaded this project with an initial budget of $1M.

Confidential, Madison, WI

BI QA Lead

• Manage the testing team for Business Intelligence Center (BIC) for Agency Performance Project, Confidential (Financial and Non- Financial) Project and Catalyst Claims Project as a QA Manager in implementing new GuideWire Claim Center replacing the legacy System and Business Objects Reporting tools.
• Acted as a focal point and leader to all quality related programs - Directed QA activities to ensure maximum quality and effectiveness.
• Supervised and guided quality managers and departments to establish quality standards as per industry and market requirement.
• Directed employees to ensure highest standard of quality so that the organization meets both internal and external requirements - Ensured that all quality standards are met by all departments, by explaining the importance of maintaining quality standards.
• Worked in coordination with other departments in implementing the quality standards and benchmarks - Developed new matrices and benchmarks of quality standards, directed towards improving performance of departments.
• Evaluated and compared performance of different departments to establish quality standards - Worked closely with human resources departments to develop performance improvement programs and appraisals.
• Procured QA software tools, developed QA procedures and established quality assurance methodologies/standards in order to clarify the quality objectives of the organization.

Confidential, Johnston, IA

QA ETL Lead

• Tested the ETL process to automate the testing process and also load the test data into the testing tables.
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Tested different detail, summary reports and on demand reports developed by Report Studio.
• Reported debugging using Informatica and tracked defects using Quality Center.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Worked in Agile technology with Scrum and waterfall models.
• Created and Developed Reports and Graphs using ALM.
• Written test plans and estimated time frames for functional IT, UAT phases
• Involved in data warehouse testing by checking ETL procedures/graphs.
• Performed the tests in both the SIT, QA and contingency/backup environments

Confidential, Chicago, IL

Product Verification Lead

Responsibilities:

• Lead the CCTI Production Hardware Refresh Project and IE 11 Upgrade Project’s PV initiatives including managing team of 2 QA resources on each project.
• Contributed to the testing effort with the PV Manager to evaluate and enhance SDLC standards, technologies and approaches.
• Report testing: Extensive experience with Reporting Tools like OBIEE
• Identified the unused PV schema Index and created Drop index Script to the data services team for Space Reclamation Project.
• Created Test cases for the community users (UAT) to each application for IE 11 Upgrade Project.
• Created root-cause defect report and a test execution progress report at the end of each task/ticket.
• Acted as subject matter expert (SME) knowledge on Quality Assurance software, tools, and best practices Development and execution of a regression test
• Involve in Development and execution of functional & system tests Test planning for new feature development
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Performed front-end testing on OBIEE Executive Dashboard portal
• Involve in Development and execution of test cases and Participated in training and mentoring other PV team members.
• Work closely with cross-functional teams in Washington, DC, Chicago office and other Project teams, and HP clients to develop work estimates, project schedules, execute test plans and cases, provide status, and deliver high quality products.
• Organize and Lead the scrum meeting every morning for the project sprint.

Confidential, Durham, NC

ETL QA Lead

Responsibilities:

• Analyzed business requirements to identify testable requirements.
• Wrote SQL queries to validate that actual test results match with expected results check the naming standards, data integrity and referential integrity.
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Tested mapping for extracting, cleansing, transforming, integrating, and loading data using Informatica ETL Tool.
• Worked as ETL Tester responsible for the requirements gathering / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Involved in Implementing Agile (Scrum) methodologies for the complex project modules.
• Tested and worked on creating open document reports for business.
• Preparation of technical specifications and Source to Target mappings
• Designed, updated and reviewed Test Cases.
• Involved in coordinating the Black box testing for the data warehouse by checking ETL procedures/mappings.
• Involved in Integration testing, Functional testing and Regression testing.
• Validated data in source and target databases using SQL scripts..
• Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.Written several SQL statements to confirm successful data transfers between source and target.
• Worked with data profiling, data scrubbing and data cleansing.Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports
• Executed complex SQL queries & validated data against source tables and DataMart tables.
• Data mismatches & issues reported to Business Analyst as Defects.
• Tested the reports like Drilldown, Drill Up and Pivot reports generated from OBIEE
• Closely worked with the developers to resolve the issues and defects.
• Used database tool, Toad to analyze data and execute SQL queries.
• Involved in Daily/Weekly Project status Meetings
• Control M tool is used to promote the jobs in QA environment. Maintain batch jobs including creation/scheduling and modification of Batch Jobs

Confidential, Warrenville, IL

ETL QA/ Data Warehouse Test Lead

Responsibilities:

• The quality objectives taken to ensure complete Data Consolidation Testing involves in checking the Transformation Rules and Data validation for each Table/Subject Area for each University.
• SQL Queries against the SQL Server and the Oracle Databases to Validate the Source data which have to load into the IDR (Integrated Database Repository)
• Analyzed the specifications in the user Requirements Document, Functional Requirement and Technical Requirement Documents for the purpose of preparation of Test Plans.
• Executing back-end data-driven test efforts with a focus on data transformations between various universities and the IDR data warehouse.

Confidential, Naperville, IL

Owner/ Consultant

• Install and implement EMR, Web-Based Practice fusion to achieve meaningful use. Other features include Lab Integration, secured messaging, document management, Reporting and e-Prescribing system which automatically populate scripts directly from imported patient charts.

Confidential, Naperville, IL

QA Analyst

• Involved in testing insurance application where customers can get insurance quote online. Reviewed functional/design specifications, and other relevant documents to extract test requirements. Translate requirements, designs and functional specs into test plans.