SUMMARY:

• Over 7+ years of IT experience as ETL Application Production Supports Sr & Data analyst /System Analyst / Reports / DWH / Backend QA Analyst for Data Warehouse/ETL/Business Intelligence projects and testing financial applications and knowledge like secured deposit, data analyzing SF(single Family and MF(Multi Family) Loan ID in Production.
• Exclusive experience in all aspects of Software Test Life Cycle including System Analysis, Testing efforts Design, Development, Execution, Reporting and Closure Documentation.
• In depth knowledge of Testing methodologies, Concepts, Phases, and Types of testing, developing Test Plans, Test Scenarios, Test Cases, Test Procedures, Test Reports and documenting test results accordingly after analyzing Business Requirements Documents (BRD), Functional Requirement Specifications (FRS), Mapping documents and Technical Specs.
• Expert in writing complex SQL Queries to check the integrity of data to perform database testing.
• Experience in writing and executing Test Plans and Test Cases from Requirements and Design documents.
• Used ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Informatica Power Center, Ab Initio and Data Stage.
• Experience in testing Cognos, Crystal, BOXI and Excel reports along with the data validation for the reports.
• Have solid experience on database query tools such as command editor, SQL Navigator, Teradata SQL Assistant and SQL Plus.
• Experience in testing MS Windows and UNIX environments.
• Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL. 
• Experience on UNIX commands and file management using vi editor.
• Experienced in Functional testing, System testing, Load testing, Integration testing, Regression testing, GUI Testing, Black box testing, White box testing, Boundary testing.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing. 
• Understanding of Data Models, Data Schemas, ETL and created extensive store procedures, SQL queries to perform back-end data warehousing testing.
• Strong analytical, dynamic trouble-shooting and requirement traceability skills.
• Experience in testing reconciles (initial) and delta (daily) ETL loads.
• Performed testing based on Transformation Rules using STM (Source-to-Target) Mapping document.
• Extensively worked with batch scheduling tool Autosys to run and monitor the ETL workflow jobs.
• Have experience working in 24x7 EDW execution support.
• Analyzing bugs, interacting with QA/Dev teams in fixing errors.
• Experienced in interacting with SMEs, Business Analysts, IT leads, UAT Users and developers.

TECHNICAL SKILLS:

ETL tools: Informatica Power Center 9.1/8.X/7.X, Ab Initio, Data stage, SSIS, Replication server, info sphere Replication server

Databases: Oracle 8i/9i/10g, MS SQL, DB2, Teradata V2R6/V2R5, SQL Server 2003/2005/2008 ,DB2data management studio, postgresql

Methodologies: Waterfall, Agile/Scrum, RUP, Compass

Reporting Tools: Cognos, Business Objects BOXI, QlikView, Crystal Reports

Test Management Tools: HP Quality Center 10.0/9.0/8.2 , Rally, TFS

Data Access Tools: TOAD, SQL Navigator, Oracle SQL Developer, data management

Programming Languages: SQL, PL/SQL, Java,.NET3.5

Modeling Tools: MS Visio, Rational Rose 6.0

Requirement Tools: Rational Requisite Pro, DOORS

Version Control Tools: Rational Clear Case, Win CVS, SharePoint

Scheduling Tools: Autosys, Informatica Job Scheduler

Incident/Defect Management Tools: BMC Remedy, Clear Quest, Quality Center, TFS, Rally, Bugzilla

Operating Systems: MS DOS, Win 98/2000/XP, UNIX, Linux

Other Tools: Web Services, Win SCP, PuTTY, Compare IT, Text Pad

PROFESSIONAL EXPERIENCE:

ETL Production Supports /Data analyst / System analyst

Responsibilities:

• Grand Application access
• Provide second tier support for applications developed by PRA IT
• Respond to production issues/emergencies during business hours and off hours according to agreed upon SLA’s
• Report and communicate production issues to the appropriate individuals
• Perform root cause analysis and provide technical solutions to production related application errors
• Monitor routine and critical processes and workflows and proactively identify problem trends (Job Watcher process)
• Assist with application implementations and configuration
• Assist with documenting technical and business processes including technical guides
• testing financial applications and knowledge like secured deposit, data analyzing SF(single Family and MF(Multi Family) Loan ID in Production.
• Design and create data reports and reporting tools to help business executives in their decision making, 
• Perform statistical analysis of business data.
• Restore client data from various external sources ( Vartica, Beryl and HTLM, Oracle) to our file system.
• Large volume data conversion, data cleansing, production report generation, and upholding scheduled data delivery standards.
• Perform Data validation and massaging to ensure accuracy and quality of data.
• Data mapping to Replication Process one to many and many to one relationship.
• Validated the Scripts in the Target Database (DB2, oracle and my SQL) for creating the cube before migrating it to HPDM.
• Create new ID and access to all server environments.
• Create data analysis matrix, Unit matrix, Understanding clients’ information needs, business objectives and market sectors and implementing appropriate data analysis strategies
• Participated in frequently held Defect Meetings which included Project
• Submitted Final Test Report; required documentation for the project within assigned time frame.
• Creating Procedure document
• Used Workflow Manager for Workflow and Session Management, Database Connection Management and Scheduling of jobs.

Environment/Tools: Oracle 9i, MS SQL Server 2005,HPDM,DB2,Oracle, Informatica Power Center 10.00, Manual Testing, workflow Processing, Rational Rose, Rational Clear Case, Rational Clear Quest, Cognos, MS Office Suite, Data molding tools, HP Quality center.

Palo Alto, CA

ETL consultant /Data analyst / System analyst

Responsibilities:

• Documenting the types and structure of the business data (logical modeling) and create data Physical model workflow order.
• Analyzing and mining business data to identify patterns and correlations among the various data points, 
• Mapping and tracing data from system to system in order to solve a given business or system problem, 
• Design and create data reports and reporting tools to help business executives in their decision making, 
• Perform statistical analysis of business data.
• Restore client data from various external sources ( Vartica, Beryl) to our file system.
• Large volume data conversion, data cleansing, production report generation, and upholding scheduled data delivery standards.
• Perform Data validation and massaging to ensure accuracy and quality of data.
• Data mapping to Replication Process one to many and many to one relationship.
• Validated the Scripts in the Target Database (DB2) for creating the cube before migrating it to HPDM.
• Create new ID and access to all server environments.
• Create data analysis matrix , Unit matrix, Understanding clients’ information needs, business objectives and market sectors and implementing appropriate data analysis strategies
• Create dashboard report in report generation tools in Qlikview mapping BAD and BRD doc and create design.
• Gather, document, and distribute technical requirements.
• Participated in frequently held Defect Meetings which included Project
• Submitted Final Test Report; required documentation for the project within assigned time frame.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables. 
• Used Workflow Manager for Workflow and Session Management, Database Connection Management and Scheduling of jobs.

Environment/Tools: Oracle 9i, MS SQL Server 2005,HPDM,DB2, Informatica Power Center 8.1/7.1, Manual Testing, workflow Processing, Rational Rose, Rational Clear Case, Rational Clear Quest, Cognos, MS Office Suite, Qlikview,Data molding tools, HP Quality center.

Bloomington, IL

DataBase Tester/ETL consultant /System analyst

Responsibilities:

• Validated the ETL Scripts in the Target Database (DB2) for creating the cube before migrating it to SQL Server.
• Involved in prioritizing the requirements according to business needs and putting all the requirements in Test link.
• Prepared Test Strategy document, System Test Plan, Performance Test Plan, Traceability matrix and Test Summary Reports
• Involved in developing test cases to test DB2 scripts (Bteq , multiload, fast load).Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly
• Extracted data from Oracle and upload to DB2 tables using DB2 utilities FASTLOAD. Extensively Built external mapping to transfer data from SQL Server database to DB2 Data Warehouse. This includes writing SQL Statements.
• Coordinated in implementing ETL using complex stored procedures on SQL 2005 Server.
• Acted as first point of contact for all critical issues related to data mapping and data sourcing
• Responsible for testing Initial and daily loads of ETL jobs.
• Data filing and QlikView Dashboard Design & Development and create Architect workflow.
• Point of contact for the client data testing, data accuracy and accuracy of functionality.
• Coordinating with source system owners, day-to-day ETL progress monitoring and maintenance of daily Informatica batch schedule run on a nightly basis.
• Defects were identified, provided documentation to the development team for debugging.
• Performed Regression testing of the fixed issues in the new build until no new issues are identified.
• Analyzed the business/system requirements specifications, and prepared Test Plan and Test Cases for Functional, Integration, Regression, SIT, End-End and UAT Testing
• Participated in project planning, release, daily stand up meetings.
• Customer process relation
• Data mapping and Data replication process.
• Index fax and email document in Captiva tools, Citrix.
• Create work flow process application Diagram and data processing diagram (Visio-basic)
• Involved in maintaining the test environments, like requesting data loads, data base backups, requesting the deployments, trouble shooting issues for QA team.

Environment/Tools: MS Project, DB2, Oracle 9i, Informatica Power Center, Business Intelligence tool: Micro strategy, Claims Processing, Manual Testing, Autosys, MS, Test link , Trac, Captiva, Shovel data tools , postgresql , DB2 management studio

Boston, MA

Sr Backend Tester / ETL Analyst / Report QA Analyst

Responsibilities:

• Analyzed the business/system requirements specifications, and prepared Test Plan and Test Cases for Functional, Integration, Regression, SIT, End-End and UAT Testing
• Participated in project planning, release, daily stand up meetings.
• Participated in frequently held Defect Meetings which included Project Management, QA, Development, and Business Line teams and submitted weekly defect and test status updates during the Defect Management meetings.
• Testing Qlikviw step and reporting through the client server.
• Prepared the test bed for testing by preparing mockup data’s for various scenarios.
• Developed QA methodologies, test design & strategy, test data
• Managed/coordinated/supported offshore resources and transferring knowledge to/ monitoring of QA team members.
• Identified tests to be automated and automated them using Mercury QTP.
• Reviewing test findings and managing defects
• Error checking and testing of the ETL procedures and programs using Informatica session logs.
• Focused on Data Quality issues/problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Used Workflow Manager for Workflow and Session Management, Database Connection Management and Scheduling of jobs.
• Exclusively involved in execution of Autosys jobs, PL/SQL batch programs and responsible for reporting the defects to development team.
• Utilized TOAD for querying and analysis of Oracle databases.
• Extensively performed backend testing on databases by writing complex SQL queries.
• Executed the Batch Jobs in UNIX as background process.
• DW was tested for the row counts and errors after each transaction loads.
• Tested various SSIS and SSRS packages according to the Business requirements.
• Involved in maintaining the test environments, like requesting data loads, data base backups, requesting the deployments, trouble shooting issues for QA team.
• Tracked and executed the User Acceptance Test (UAT) Cases with respect to the requirements to determine the feature coverage.
• Responsible for testing Initial and daily loads of ETL jobs.
• Point of contact for the client data testing, data accuracy and accuracy of functionality.
• Coordinating with source system owners, day-to-day ETL progress monitoring and maintenance of daily Informatica batch schedule run on a nightly basis.
• Defects were identified, provided documentation to the development team for debugging.
• Performed Regression testing of the fixed issues in the new build until no new issues are identified.
• Involved in testing the batch programs by using Autosys tool.
• Participated in frequently held Defect Meetings which included Project Management, QA, Development, and Business Line teams and submitted weekly defect and test status updates during the Defect Management meetings.
• Submitted Final Test Report; required documentation for the project within assigned time frame.
• Participated in weekly Test Status meetings to discuss Test Deliverables, Milestones, and Project-Level Issues & Risks.
• Involved in getting final signoffs from Test Managers and Business. 

Environment/Tools: Oracle 11g, Informatica Power Center 9.1, Clear Case, Clear Quest, Cognos, TOAD, MS Visio, SQL Server 2010, HP Quality Center 10.0, Rational RequisitePro, DB2, QTP, Erwin, XML, Flat files, Win SCP, Autosys, SSIS, SSRS, SSAS, SQL scripts, PL/SQL, Batch processing, BOXI Reports, PuTTY, UNIX, Windows 7.