SUMMARY:

• Over 8.5 years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP and Client/Server applications.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture
• Extensive testing ETL experience using Informatica 9.0/8.6/ 8.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• Experienced in different Databases like Oracle, DB2, Teradata, Sybase & SQL Server 2008
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Informatica, Data Stage & Ab Initio and SSIS
• Good expertise in using TOAD, SQL*Plus and SQL Advantage.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Designed data models using Erwin.
• Worked on Gathering Business requirements, Functional requirements and Creating BRD
• Solid Back End Testing experience by writing and executing SQL Queries.
• Worked on New version of QC which is ALM in developing Test cases
• Co-ordinate testing efforts between onsite and offshore teams.
• Performed Black Box, White Box & Grey Box testing
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experience in UNIX shell scripting and configuring cron-jobs for Informatica sessions scheduling
• Expertise in Working on Java Environment and performed testing on Different applications
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica
• Extensively used Ready API/SOAP UI for testing web services/APIs
• Experience in testing and writing SQL and PL/SQL statements.
• Experience in SharePoint Apps
• Experience in writing test cases to test the application manually and automated using Quick Test Pro/UFT
• Experience in Business Intelligence in generating various reports using Cognos and BO.
• Experience in Working on Unified Functional testing Tool for creating Automated Scripts
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Expertise in utilizing Oracle utility tool SQL*Loader and expertise in Toad for developing Oracle applications.
• Worked Extensively on Agile Environment and created different iterations and stories
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Worked on QTP as Automation Lead. Created Different scenarios and tested using Automation tools
• Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts.
• Experience in Performance Tuning of sources, targets, mappings and sessions.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Experience in all phases of Software Development life cycle.
• Application Data warehousing experience in Banking, Financial, Trading, Retail and Consumer.
• Performed Unit, Integration and System Testing.
• Good analytical and problem solving skills.
• Team player with excellent Organization and Interpersonal skills and ability to work independently and deliver on time.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.6/9.1/ 8.1/7.1/6.2/5.1 (Power Mart/Power Center) (Designer, Workflow Manager, Workflow Monitor,MDM,IDD), Data Stage 8.1, 9.1,Ab Initio (GDE 1.15, Co>Op 2.15)

Data Modeling: Erwin 4.0/3.5, Star Schema Modelling, Snow Flake Modelling

Databases: Oracle 10g/9i/8i, MS SQL Server 2012/2008/2005/2000, DB2, Teradata, Sybase 12.5

OLAP Tools: Cognos 8.0/7.0/6.0, Microstrategy, Business Objects,Qliksense

Languages: SQL, PL/SQL, Java, Unix Shell Script, PERL, Visual Basic, XML,Java Script,HTML

Tools: Toad, SQL* Loader, Teradata SQL Assistant, WinSQL, BI Studio, Red Gate SQL compare 8.0,DB Visualizer,SOAP UI,Ready API 1.9,Beyond Compare,TIBCO 8.3,TFS, Hermes JMS,SPLUNK

Operating Systems: Windows 2003/2000/NT, AIX, Sun Solaris, Linux

Testing Tools: UFT 12.01,QTP 11.0/9.0, Quality Center 9.2,11.0, HP ALM 12.01,HP Qc 11, Test Director, Bugzilla

Rational Tools: RUP, Rational Rose,, Rational Clear Case, Clear Quest, Test Manager, Robot, Rational Requisite Pro

Tracking Tools: JIRA 6, Version one, Rally

Methodologies: Agile Methodology, Waterfall methodology, Scrum

PROFESSIONAL EXPERIENCE:

Confidential, Hanover, MD

Integration/Web service Manual & Automation QA

Responsibilities:

• Developed test plans based on test strategy. Created and executed test cases based on test strategy and test plans & ETL Mapping document.
• Involved in Executing Test cases on Web services/API using Ready API & SOAP UI
• Worked with Business users and Assisted in UAT
• Worked on HTML, XML & JSON and processed them as inputs for Web services
• Tested WSDL, WADL end points to connect to applications
• Checked CLE Logs, Splunk logs to determine the errors in the workflow
• Used SOAP, REST calls to test APIs across different applications
• Tracked the progress of Different tickets assigned using JIRA, Version one
• Used HP ALM for writing test cases, parameterize them and added test configurations. Executed test cases in test Lab
• Used Hermes JMS for Dropping the Messages in Queue, Topics and checked the final XML Message in End Queue
• Worked on TIBCO Admin interphase for E2E Integration testing
• Automated the projects in ready API using Inbuilt Ready API steps
• Passed Request XMLs in SOAP UI pro as XMl/JSON payloads and verified the Response in the tool
• Scheduled Automated scripts in Test environment using Bamboo tool
• Worked on Different steps in Ready API Like Adding Assertions, JDBC requests, Groovy scripting and Data source looping
• Raised Bugs in JIRA & version one and retested them as part of project efforts

Front Office ETL Manual & Automation Test Lead / QA

Responsibilities:

• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Involved in Creating BRD for Business requirements and passing it through the team
• Involved in understanding the ETL mapping document and Source to Target mappings(STTM)
• Involved in the review of ETL Code used for data movement from Source to Target. Deeply involved in review of Mappings, Sessions and Workflows
• Worked on Autosys Jobs and Scheduling for Data Movement across the environments
• Planned issues and Tracked defects using testing tools
• Prepared the test plans and test cases for different functionalities involved in the DB.
• Walk troughed test Plan and test cases with Business users and project team to finalize the testing approach
• Worked with Business users and Assisted in UAT
• Extensively Used Business objects,Qliksense for report testing
• Used complex SQL language in extracting data from different domains spread across the DB
• Used Quality Centre as the test management tool for the maintenance of the test cases and to track the defects.
• Responsible for the entire QA process and developed Testing approach across all the domains like Accounts, securities, Contacts, issuers
• Extracted Data from Oracle,Syabase and other platforms using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes
• Using Quality Centre as the repository for the requirements.
• Worked with Different Back end Teams who provide data like Vision, Hinet, EGL,IDW
• Involved in data profiling of the incoming data
• Performed the Smoke, Functional testing, Ad Hoc testing and Regression testing of the application.
• Involved in creating the test design techniques and testing specifications for the ETL process.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Developer.
• Designed and tested UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with ETL and Reporting system and also to successfully implement business logic.
• Worked on SharePoint testing and code reviews.
• Performed UAT while Upgrading different Testing tools like ALM and UFT
• Worked closely with End users in Explaining the testing process and Approach across Domains
• Created Audits for known defects across QUAL/SIT environment
• Written several PL/SQL stored procedures. Tested the output of Stored Procedures vs. ETL output
• Performed the tests in both the QUAL,SIT, QA and contingency/backup environments
• Worked as Test lead on Agile Environment by creating iterations, stories and tested the applications, Data Bases
• Coordinated with Scrum Master, Manager, Dev, LOB and UAT and tested different Domains using Agile methodology
• Worked on RDBMS in designing and testing Different types of data models
• Worked with Informatica session log files for data reconciliation and verifying the data conditions.
• Conducted defect review meetings with the development team members
• Involved in peer review of test cases, Test Pool meetings and Impact analysis
• Involved in testing the applications in Target host in IBM Mainframe environment
• Involved in prod support if needed
• Involved in Automating Internal Domains using UFT and ran the VB scripts using scheduler
• Involved in understanding Logical and Physical Data model using Erwin Tool.
• Extensively used Informatica to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata to Teradata.
• Worked on Data Governance and Data security in the Day to Day flow of data to the DB
• Worked on testing different Tables and Views in the Database
• Involved in Data conditioning of SCD data to test different scenarios
• Involved in Analyzing issues raised by Users across the data
• Data migration of raw data to excel documents for clients
• Involved with discussion with Business for supporting functional specifications.
• Involved in creating the test design techniques and testing specifications for the ETL process.
• Tested data warehouse ETL process using SSIS (Integration Service)
• Prepared extensive set of validation test cases to verify the data
• Tested different type of reports including detailed, summary reports, KPI’s and on demand ad-hoc reports.
• Tracked the progress of Different tickets assigned using JIRA

Environment: SQL Server 2008,2012, SSIS, XML, XSD, XSLT, XML Spy 2010,, SHELL SCRIPTING, Informatica 9.0, Informatica 9.6, Teradata V2R6, HP ALM 12.01, HP QC 11, QTP 9, UFT 12.01, Oracle 10g, Erwin 4.0, UNIX, TOAD, Red Gate 8.0,JIRA 6.1, DB Visualizer, Data Stage 9.1

ETL Manual Tester/ Lead

Responsibilities:

• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Involved in understanding the ETL mapping document and Source to Target mappings.
• Prepared the test plans and test cases for different functionalities involved in the application.
• Used Quality Centre as the test management tool for the maintenance of the test cases and to track the defects.
• Extracted Data from SQl server & Iseries using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes
• Involved in Source to Target Data Movement & testing Using Informatica and Oracle DB
• Using Quality Centre as the repository for the requirements.
• Performed the Smoke, Functional testing, Ad Hoc testing and Regression testing of the application.
• Establish and organize Offshore Development Teams.
• Involved in creating the test design techniques and testing specifications for the ETL process.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Developer.
• Designed and tested UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with ETL and Reporting system and also to successfully implement business logic.
• Worked on SharePoint testing and code reviews.
• Experience in Working on SharePoint cloud
• Experience in Customer management system and dealt with application that interacts with customers
• Written several PL/SQL stored procedures. Tested the output of Stored Procedures vs. ETL output
• Performed the tests in both the SIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Tested different Java Based Applications in Java Environment
• Worked as Test lead on Agile Environment by creating iterations, stories and tested the applications
• Coordinated with Scrum Master, Manager, Dev, LOB and UAT and tested Different Bank Applications using Agile methodology
• Worked on Data stage 8.1 for different transformations and Loads and finally tested the output in the application
• Worked on RDBMS in designing and testing Different types of data models
• Defects were tracked, analyzed, and documented using Quality Center
• Worked with Informatica session log files for data reconciliation and verifying the data conditions.
• Conducted defect review meetings with the development team members
• Involved in peer review of test cases, Test Pool meetings and Impact analysis
• Involved in testing the applications in Target host in IBM Mainframe environment
• Involved in prod support if needed
• Involved in Automating Confidential Internal Applications

Environment: SQL Server 2008,2012, SHELL SCRIPTING, Teradata V2R6, HP ALM 12.01, HP QC 11, QTP 9, UFT 12.01, Oracle 10g, Erwin 4.0, UNIX, TOAD, Red Gate 8.0,JIRA 6.1, DB Visualizer, Data Stage 9.1

Sr. SQL/ETL/BA/Java & Unix Tester

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Tested several UNIX shell scripting for File validation, Data Parsing, Cleanup and job scheduling.
• Involved in understanding Logical and Physical Data model using Erwin Tool.
• Involved in writing Test Plan, Developed Test Cases and supported all environments for testing.
• Reported bugs and tracked defects using Quality Center.
• Extensively used Informatica to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata to Teradata.
• Worked on a Business Intelligence reporting system that was primarily functioning on Oracle Applications OLTP environment with Business Objects for Business Intelligence reporting
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Responsible for testing Business Reports developed by Business Objects XIR2
• Extensively used Informatica to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata to Teradata.
• Customer management system experience
• Conducted Weekly Onsite-Offshore Status Meetings.
• This work will include loading of historical data onto the Teradata platform, as well as reference data and metadata.
• Recorded and Executed Test cases Using QTP as Automation tool
• Worked as Automation Lead
• Created test cases in Java & Unix environment and Executed Test scripts
• Tested new Data migration tool used in the mapping of data to new system.
• Data migration of raw data to excel documents for clients
• Involved with discussion with Business for supporting functional specifications.
• Involved in creating the test design techniques and testing specifications for the ETL process.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Developer.
• Designed and tested UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with ETL and Reporting system and also to successfully implement business logic.
• Worked as Test lead on Agile Environment by creating iterations, stories and tested the applications
• Worked on Web applications installed in Java
• Written several PL/SQL stored procedures. Tested the output of Stored Procedures vs. ETL output.
• Tested data warehouse ETL process using SSIS (Integration Service)
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS Packages
• Prepared extensive set of validation test cases to verify the data
• Tested different type of reports including detailed, summary reports, KPI’s and on demand ad-hoc reports.
• Involved in full cycle of code management and reported defects and initiated Change requests using Rational Clear Quest.
• Data Sets provided by the Business Analyst which are the expected results.
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
• Performed the tests in both the SIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Defects were tracked, analyzed, and documented using Quality Center

Environment: Business Objects XIR 2/6.5.1/6.0/5.1. x/4.0, SQL, PL/SQL, SQL Server 2008, SSIS, XML, XSD, XSLT, XML Spy 2010,, KORN SHELL SCRIPTING, Informatica 8.6, Teradata V2R6 (SQL Assistant, Fast Load, Multi Load, Java, TPUMP, BTEQ, FEXPORT), HP Quality Center 10, Oracle 10g, Erwin 4.0, UNIX, TOAD, WinSQL, IBM DB2 9.1

UAT/Data Warehouse Tester

Responsibilities:

• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Involved in understanding the ETL mapping document and Source to Target mappings.
• Prepared the test plans and test cases for different functionalities involved in the application.
• Used Quality Centre as the test management tool for the maintenance of the test cases and to track the defects.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes
• Using Quality Centre as the repository for the requirements.
• Performed the Smoke, Functional testing, Ad Hoc testing and Regression testing of the application.
• Establish and organize Offshore Development Teams.
• Involved in Extensively during UAT testing of various functionalities along with the implementation team, resolved the issues and problems. Used Test director for bug tracking.
• Involved in Testing Cubes for Dataware house
• Written several UNIX scripts for invoking data reconciliation.
• Execute and analyze complex test cases and compare the results with expected results and product requirements.
• Tested ad hoc and canned reports for Business objects.
• Tested Business Objects reports and Web Intelligence reports.
• Worked in Agile environment By creating iterations and Stories. Raised defects and retested the applications
• Managed user accounts and security using Business Objects Supervisor
• Tested the universes and reports in Business Objects 6.0
• Tested database integrity referential integrity and constrains during the database migration testing process.
• Worked on Java Environment and performed E2E testing
• Tested different kinds of schemas and RDBMS
• Responsible for the management, design, and continuous development of the Data Migration.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Used Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Responsible for different Data mapping activities from Source systems to Teradata
• Performed Regression Testing of the affected test cases to confirm that the defect has been resolved when defect corrections are delivered in a build.
• Tested different detail, summary reports and on demand reports.
• Written several PL/SQL stored procedures. Tested the output of Stored Procedures vs. ETL output.
• Involved in backend testing for the front end of the application using SQL Queries in SQL Server data base.
• This work will include loading of historical data onto the Teradata platform, as well as reference data and metadata.
• Involved in Designing Logical and Physical Data model using Erwin Tool Responsible for different Data mapping activities from Source systems to Teradata.
• Handling the daily status meetings with QA team and business people in prioritizing the defects as per the business need.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Experience in loading from various data sources like Oracle, DB2, SQL Server, Fixed Width and Delimited Flat Files, MS Access, COBOL files & XML Files.
• Tested Transformed data from various sources like excel and text files in to reporting database to design most analytical reporting system.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Written Test Plans and Test Cases on Mercury’s Test Director Tool.
• Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director.
• 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.
• Tested UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.

Environment: Informatica 8.1/7.1/6.2/5.1, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, BTEQ), Teradata SQL Assistant 7.0, SQL Server 2005/2008, Mercury Test Director 8.0, QTP 8.0, SQL *Loader, Business Objects XIR 2/6.5.1/6.0/5.1. x/4.0, Oracle 9i, Erwin 3.5, Windows 2000, TOAD 7, Shell Scripting, PERL, IBM AIX 5.2, TOAD, WinSQL, SQLPlus, XSD, XML, VSAM FILES, MVS, COBOL II, ISPF, JCL

Data Stage ETL Lead Tester/BA

Responsibilities:

• Reviewing the business requirements for Data Warehouse ETL process and working with business and requirements team for gaps found during the review.
• Developed a detailed Test Plan, Test strategy, Test Data Management Plan, Test Summary Report based on Business requirements specifications.
• Wrote extensive SQL and PL/SQL scripts to test the ETL flow, Data Reconciliation, Initialization, and Change Data Capture, Delta Processing.
• Prepared a UAT Plan and set up UAT environment.
• Prepared Execution procedure document format to prepare the Test cases based on mapping document.
• Defined and ran jobs using the AutoSys Graphical User Interface (GUI) and Job Information Language (JIL), monitoring and managing AutoSys jobs and alarms.
• Ran jobs using the AutoSys to load the data from Source to Target.
• Executed DataStage jobs to test the ETL processes.
• Developed Strategies for Data Analysis and Data Validation.
• Used the DataStage Designer to develop various jobs processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
• Used the DataStage Director to schedule jobs, testing and debugging its components and monitoring of results
• Utilized Cognos 7.3 Series for building the Reports.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Worked with DataStage Manager for importing metadata from repository, new job Categories and creating new data elements.
• Validated the Data in the Warehouse using SQL queries
• Tested the Reports generated by the BI tools (Micro Strategy, Hyperion) and validated the data on the Reports
• Validated test cases for Source to Target mappings (STM).
• Validated data flow from Source through to FACT tables and Dimension tables using complex queries(left outer Joins, sub queries etc)
• Validated data model for landing zone, staging zone and Warehouse tables for column length and data type consistencies
• Validated FK failures and data integrity checks for all the tables.
• Validated Business codes, Error process and Purge process.
• Extensively used UNIX shell scripts and compared the files in SAS to make sure the extracted data is correct.
• Involved in developing scenarios of testing and maintaining testing standards
• Involved in Business functionality review meetings and Use-Case Analysis
• Participation in requirement / Use Case analysis, risk analysis and configuration management.
• Developed the templates for User/Customer Training and documentation.
• Participated in developing and implementing End-End testing manually.
• Used Share point for Document Management and Dimensions for version control.
• Involved in setting up QA environment for testing the applications.
• Used Quality Center and Test Director for defect tracking and reporting
• Assisted Team members in knowledge transfer
• Involved in Regression, UAT and Integration testing
• Coordinated with Different project teams to set up common test environment and common Integration for different applications
• Conducted defect review meetings with the development team members
• Involved in peer review of test cases, Test Pool meetings and Impact analysis
• Involved in testing the applications in Target host in IBM Mainframe environment
• Used QMF for writing and executing DB2 queries in the host

Environment: Datastage 7 (Designer, Director, Manager),Windows XP, Cognos 7.3 Series, Oracle10G, TOAD for Oracle, SQL Developer, Embarcadero Rapid SQL 7.5,IBM DB2 8.1,Sybase,DART (Desktop Asset Request & Tracking), Rational ClearCase v7,Telelogic DOORS 8.3, UNIX, Reflections, Telnet, Mercury Quality Center, PVCS (Dimensions), MS Project, Hyperion Performance Suite 8.5. AutoSys Jobs, SAS, Mainframe, Micro Strategy

QA Lead

Responsibilities:

• Involved in Data Analysis, Database Designing.
• Involved in creation of tables, writing stored procedures, Triggers, PL/SQL packages.
• Developed user interface screens using VB, ADO to connect to backend and stored procedures to manipulate data.
• Handling user defined exceptions.
• Developed PL/SQL scripts for data loading.
• Analysis of Physical Data Model for ETL mapping.
• Identification of various Data Sources and Development Environment.
• Writing Triggers enforcing Integrity constraints, Stored Procedures for Complex mappings, and cursors for data extraction.

Environment: Informatica 6.2, BO 6.5, Oracle 9i, Windows XP, Flat files, VSAM Files, XML Files, XSD, IBM AIX 5.1, PERL, Shell Scripting, Autosys