SUMMARY:

• A motivated Senior ETL QA Lead Consultant with 15+ years of experience in end - to-end software development life cycle activities including requirement analysis, design, development, implementation, maintenance, configuration, testing, documentation, and production support in Federal Government, Financial Services and Banking. In depth participation in design reviews, requirement analysis and running workshops with both development team and client. Demonstrates excellent communication and interpersonal skills while delivering solutions.
• Very good experience in using BAE Applied Intelligence compliance, ETL and fraud tools (Norkom / Detica) software on various modules: AML (Anti Money Laundering), EIM (Enterprise Investigation Management), WLM (Watch List Management - OFAC Sanctions, PEP, World-Check Premium Plus, Factiva Dow Jones and Acuity), KYC (Know Your Customer), CDD (Customer Due Diligence), SM (Scenario Manager).
• Strong development and testing experience in using Ab Initio ETL and DataStage ETL.
• Worked in diversified areas for Application Configuration Testing and ETL Development, Production deployment activities include build install, application server profile setup, data loads and environment testing.
• Extensively used ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Ab Initio ETL and tested graphs in backend.
• Expert level skills in providing Azure Cloud solutions for public and hybrid clouds.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Access, and flat files to load the data into Data Warehouse to perform the ETL testing activities.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ETL QA Lead

Responsibilities:

• Responsible for Product Deployment, QA Analysis, Test Scenarios, Test Plans, Test Scripts, configuration risks, client installations, UNIT Testing, SIT, UAT, PIV, CRs Testing, Regression Testing, Task effort estimations, Resource Allocations and Bug Fixes for Client Staging and BAE AML product deliveries.
• Worked with customers to analyze and gather business requirements as well as architect and implement security software for detection, investigation, enterprise-level software applications.
• Led a QA team and delegated work to the team members, monitored team performance through timely feedbacks, thereby, ensuring overall team productivity and quality.
• Served as a technical point person for customers, providing them with answers and solutions to their technical questions, database setups, performance tuning and issues.
• Excellent experience in data cleansing, validation, and data quality practices during the data preparation process by using SQL Server, Quest, DMT.
• Collaborated with engineering and QA teams, mentored team members throughout the project software lifecycle to ensure the delivery of high-quality software according to established timelines.
• Headed multiple daily or weekly application UAT and Production release projects, from business approvals to final system sanity checks also Provided technical competence and guidance on system architecture using installation instructions and roll out plans.
• Extensively used ETL engine process to test source to target mappings and data loads including Type2 and Type3.
• Monitored and maintained Jira system to ensure all new and repetitive bugs and issues are addressed, researched, fixed, and closed.
• Developed relations with business community and the outsourced service providers.
• Acted as a key point contact for customers, provided answers and solutions to technical questions, data issues, QA defect clarifications, defect resolution details and documentation preparation.
• Created and deployed builds from environments to environments, providing release notes with approval from development and QA teams.

Confidential, Minnesota

Sr. ETL (Ab Initio/DataStage) QA Lead

Responsibilities:

• Prepared project estimates, Resource Plans, Test Strategies, System Test Plans, Test Cases, Test Scripts, Test Summaries, and post implementation documents.
• Involved in the migration of the code in QA environment with QA team and completed rigorous unit testing of each graph in SIT/UAT Environment followed by PI.
• Worked with development team during technical design to maximize test support and Involved in Test Inspection and executed the test scripts for the connectivity to back end and positive and negative testing.
• Used functions while editing test scripts to minimize code redundancy and to improve the performance.
• Worked with extensively with Ab Initio GDE to run various Plans, graphs to compare the Conversion project results between DataStage and Ab Initio outputs.
• Utilized QC to track test requirements, test plans and defects and communicated within the teams to resolve the valid defects.
• Designed Parallel Partitioned Ab Initio graphs using GDE Components for high volume data warehouse to unload the data from Datawarehouse and to load the data into Datawarehouse.
• Worked with Autosys to perform the data loads in Ab Initio targets to compare the loads.
• Conducted Data Scrubbing (Data Cleansing using flow watchers, Generate Records and Sampling components.
• Involved in peer review of test cases/scripts in Quality Center by analyzing the DDD docs.

Confidential, New York / New Jersey, USA

Sr. Ab Initio ETL QA Tester

Responsibilities:

• Analyzed entire Business requirements and Specifications.
• Developed and Tested Ab Initio ETL graphs using the GDE 1.15/1.14 with components partition by round robin, partition by key and sort, rollup, sort, scan, reformat, join, merge, gather and PBE components.
• Involved in development and execution of Test Cases and scenarios for all the testing stages.
• Wrote the Test cases for Enterprise Data Warehousing (EDW) Tables and Data mart Staging Tables.
• Performed System, Regression, Functional testing, and performance tests to enhance existing tests.
• Documentation of complete Graphs and its Components.
• Verified the logs to confirm all the relevant jobs are completed properly and timely.

Confidential, New Jersey, USA

Ab Initio ETL Developer

Responsibilities:

• Responsible for Performance baseline testing to ensure the ETL application performs at above expected levels.
• Formulated Test plans from Business Requirements and Functional Specifications documents.
• Developed ETL graphs to load the data into target tables by using various components such as by Round robin, Join, Rollup, Sort, Filter by expression, Gather, Merge, Join with DB etc.
• Used Data Parallelism, Pipeline Parallelism and Component Parallelism in Graphs, where huge data files are partitioned into multi files and each segment is processed simultaneously.
• Manually performed Functional testing that includes Security, Unit, System testing.
• Created and maintained a library of test scripts for regression testing of core applications.
• Trained team members on business best practices and POC’s.
• Provided development progress to the Team Lead and Project Manager.
• Delivering work to meet client expectations and project deadlines.
• Trained and assisted off-shore QA team to perform QA, UAT and PI activities for the project.

TECHNICAL SKILLS:

AML Tools: BAE AI/Norkom compliance modules

ETL Tools: Ab Initio, DataStage, Informatica

BIG Data Cloud: Hadoop, Hive, Mongo DB, AWS (EC2, S3, IAM), Azure, Tableau

Testing Tools: Jira, Clear Quest, Microsoft MTM, Test Director, Quality Center 10, Spira Team, SOAP UI, Postman

RDBMS Tools: Oracle 10g/9.x/8.x, DB2, Teradata 13, SQL Server 2008/2005

BI Reporting Tools: Business Objects, SSIS, SSRS, Command and Control

Web Technologies: HTML, DHTML, XML

Management Skills: SVN, EME, VISIO, PVCS 9.0, MIS, O&F, OOSD, SAD