SUMMARY:

• Over 8+ years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mar Design, ETL, OLAP, Client/Server applications.
• Experienced SQL Data Analyst / Data Reporting Testing/Analyst with strong background in design, development, and support of online databases and information products as well as data analysis / reporting / processing.
• 4+ years of experience in RDBMS technologies like Oracle 8.x/9.x/10g, DB2 8.0/7.0/6.0, MS SQL Server 2000/7.0/6.5 , Dbase, Excel and MYSQL. SQL Developer, TOAD, SQL Plus, Win SQL, Quest Central for DB2. Good at working with SQL Assistant 7.1 in Teradata environment.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Created ETL test data for all ETL mapping rules to test the functionality of the Ab Initio graphs
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Business/Data Requirements Gathering and Documentation; OLTP and DSS
• Data Discovery, Analysis, Verification, Mapping, and Documentation
• Worked with SAS and Mainframe environment.
• Experience in testing Business Report developed in Business Objects XIR2 and Cognos.
• Expert hand on knowledge of SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/ETS, SAS/ODS and SAS/SQL.
• Experience in testing Cognos Reports, Business Objects Reports, SSRS Reports and Micro Strategy Reports.
• Experience in Functional testing, GUI Testing, Regression Testing and Automation testing
• Tested the ETL Ab Initio graphs and other ETL Processes (Data Warehouse Testing).
• Experienced in running SQL queries using Toad and SQL Server.
• Expertise in ETL process using Informatica (Power Mart/Power Center)
• Experience with writing test cases for  FACETS interfaces and tracking/explaining bugs to development teams
• Extensive experience in manual testing the ETL and Business Intelligence Applications.
• Strong working experience on data warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Developing and Delivering System Documentation and Training; Testing and Auditing
• Excellent problem solving, interpersonal, and communication skills.
• Experience in Performance Tuning of SQL and Stored Procedures.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Application Data warehousing experience in Financial, Banking, Pharmaceutical and Insurance.
• Extensive experience in manual testing the ETL and Business Intelligence Applications.

TECHNICAL SKILLS:

ETL Tools: Informatica 8.1/7.1./6.2/6.1/5.1 , Data Stage, Ab Initio,SSIS

QA/Test Management Tools: HP ALM/HP Quality center 10, Test Director 7.5, HP QTP 10

Database Management: Oracle 8i/9i/10g, SQL Server 2000/2005, MySQL, ODBC, DB2, TOAD 8.5, MS Access, Teradata V2R5/V2R6

Reporting Tools: OBIEE, Business Objects 5.1 /6.1/XIR2, Cognos 8.0 Series, Micro strategy

Operating Systems: Window 2003 Server, Windows 2000 Advanced Server, Windows 98, Windows XP, Linux and UNIX(AIX).

Version control: Visual Source safe, WINCVS,PVC

Web Programming: HTML, XML,JSP, Java Script

Programming languages: C/C++, PL/SQL, VB 6.0, ABAP

SAS Tools: SAS 8/9.1, Base SAS, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ACCESS, SAS/ETS, SAS/ODS, TORA, MINITAB, SPSS, STATISTICA

PROFESSIONAL EXPERIENCE:

Confidential, Reston VA

ETL/QA Tester

Responsibilities:

• Conducted source - system data analysis to understand current state, quality and availability of existing data.
• Designed & Created Test Cases based on the Business requirements.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment for testing the business rules imposed on data movement.
• Involved with Design and Development team to implement the requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Validated that design meets requirements and function according to technical and functional specifications.
• Used HP Quality Center 9.2 to state requirements, business components, test cases, and test runs for every iterations, defects. Also link defects with requirements.
• Involved in recording change requests on the Change Request Form (Remedy) Participated in meetings.
• Performed all aspects of verification and validation
• Worked with other members of the QA and Development teams and business team in improving the processes, methods,
• Designed Source to Targets mapping.
• Data Quality Analysis to determine cleansing requirements
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Generate data requirements and system specifications in an organized fashion for business solutions and for the developers to follow on.
• Used TOAD & SQL Navigator GUI tools for Querying Database.
• Used Dbeaver for querying AWS Redshift database with PostgreSQL and MySQL connections.
• Participated in walkthrough and defect report meetings periodically.
• Documented and reported various bugs during Manual Testing.
• Involved in running the ETL loads in development server
• Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
• Developed PL/SQL procedures & triggers.
• Retesting the resolved defects/issues after the developers fix the defects
• Involved in preparing test data for UAT and participated in UAT signoff
• Created Logical Data Model as a blended configuration of Conceptual Model elements along with material deemed essential and/or useful from the source-system analysis.
• Developed the strategies for analyzing the data for ETL Team
• Updated the status of the testing to the QA team and SDLC team, and accomplished tasked for the assigned work to the Project Management team regularly.
• Worked on and managed the testing activities for multiple projects at any one given time
• Developed test plan, test cases and tested data movement from Enterprise data warehouse to Analytical data store in AWS Cloud.
• Worked with columnar database such as AWS Redshift and involved in Analytical Data Store (ADS)
• Involved in Proof of concept for different technologies (Compared performance and scalability)
• Performed Web Services testing using SOAP UI and tested XML files using Soap UI
• Created test scripts for the application which uses SOA, Web services, SOAP
• Strong Backend ETL testing experience
• Worked in a fast paced Agile methodology
• Involved in stand up, sprint planning, sprint demo and retro meetings for Agile methodology
• Strong usage of HP Quality center management tool for a centralized control over entire project
• Managed and created traceability between requirements, tests, defects and build management systems task using DOORS
• Strong verbal and written communication skills

Environment: Informatica Power Center 9.1 and 9.5, Oracle 11G, Teradata V2R6 Teradata SQL Assistant, AWS Redshift, Dbeaver, MySQL AWS RDS, SQL, Flat files, PL/SQL,C#,VB.NET,JAVA,J2EE, TOAD, Data Flux, Transact-SQL, Windows NT 4.0, XML Files, Data Files, VSAM Files, MVS, JCL, Copy Books, QTP 9.2, Quality Center 9.2, UNIX Shell Scripting, IBM Relational Clear Quest.

Confidential, Herndon, VA

Sr. ETL/SQL Tester

Responsibilities:

• Responsible for gathering test requirements and scoping out the test plan.
• Responsible for creating Test Plan and scope of testing.
• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
• Used Quality Center to track and report system defects
• Involved in writing the Test cases and Test scripts based on Source to Target Mapping documents and Data Model diagrams. Developed Traceability Matrix in DOORS.
• Created Test Cases in Quality Center, executed Test Cases, and reported defects.
• Maintained various versions of the documents generated during the project using Rational Clear Case
• Created and maintained test reports, identified bugs and reported findings using Quality Center
• Involved in rebuild testing of the BI Reports from Cognos to Crystal Reports.
• Executed the Test cases for Crystal Reports and Cognos.
• Day-to-day Cognos administration activities like monitoring Scheduled jobs like Cube refresh,
• Integration and system testing
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables
• Wrote SQL queries for each Test case and executed in SQL Developer to validate the data between Enterprise Data Warehousing and Data Mart Staging Tables
• Tested ETL to perform data transfers from OLTP to OLAP, different server locations and heterogeneous sources like Oracle, DB2 Excel, XML, CSV, flat file, Text Format Data.
• Coordinated with the Developers regarding the Defects raised and Retested them against the application.
• Created and executed SQL queries in ORACLE and DB2 using TOAD and WinSQL
• Performed high-end data analysis using my strong database skills and SQL.
• Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica
• Worked in creating UNIX scripts for file transfer and file manipulation.
• Participated in meetings with business and product management staff, business rules management developers and project managers for business rule application project planning, requirement and scope discussion
• Assisted with the development of tools and processes to support development integration testing
• Strong usage of Mercury Quality center management tool for a centralized control over entire project.
• Defect management, bug tracking and bug Reporting using Quality Center.

Environment: Informatica Power Center 9.1,Oracle 11i,IBM DB2, SQL, PL/SQL, XML, MS Office suite, Unix, Shell Scripting, MS Suite, Cognos, HP Quality Center 10, Silk test Suite, WinSQL, Ultra Editor, Putty, XML Spy 2011

Confidential, Wilmington, DE

ETL/ BI Tester

Responsibilities:

• Conducted source-system data analysis to understand current state, quality and availability of existing data.
• Designed & Created Test Cases based on the Business requirements.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment for testing the business rules imposed on data movement.
• Involved with Design and Development team to implement the requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Validated that design meets requirements and function according to technical and functional specifications.
• Executed the Batch job in Autosys and validated the data.
• Tested whether the reports developed in Cognos are as per company standards.
• Worked with business team to test the reports developed in Cognos
• Used PERL for automating all the types of modules at a time and Responsible for testing the reports according to client’s requirement using Cognos.
• Used HP Quality Center 9.2 to state requirements, business components, test cases, and test runs for every iterations, defects. Also link defects with requirements.
• Involved in recording change requests on the Change Request Form (Remedy) Participated in meetings.
• Metadata graphs from legacy source system to target database fields and involved in creating Ab Initio DMLs.
• Experienced at testing ETL's and flat file data transfers without relying on GUI layer
• Performed all aspects of verification and validation
• Worked with other members of the QA and Development teams and offshore team in improving the processes, methods, effectiveness and efficiency
• Designed Source to Targets mapping.
• Data Quality Analysis to determine cleansing requirements
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Validated the data transformations developed by DB2 stored procedures and Informatica.
• Generate data requirements and system specifications in an organized fashion for business solutions and for the developers to follow on.
• Involved in developing Unix Korn Shell wrappers to run various Ab Initio Scripts
• Used TOAD & SQL Navigator GUI tools for Querying Database.
• Participated in walkthrough and defect report meetings periodically.
• Documented and reported various bugs during Manual Testing.
• Involved in running the ETL loads in development server
• Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
• Hands on experience with working on Autosys jobs and MQ’s. MQ’s are used for intermediate storage where the messages are stored for temporary purpose.
• Developed PL/SQL procedures & triggers.
• Retesting the resolved defects/issues after the developers fix the defects
• Involved in preparing test data for UAT and participated in UAT signoff
• Created Logical Data Model as a blended configuration of Conceptual Model elements along with material deemed essential and/or useful from the source-system analysis.
• Developed the strategies for analyzing the data for ETL Team
• Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly.

Environment: Ab Initio 2.14, Cognos, Oracle 10G, IBM DB2, Autosys, Teradata V2R6 Teradata SQL Assistant, SQL, Flat files, HP Quality Center 9.2, PL/SQL.C#,VB.NET, Unix Shell Scripting, JAVA,J2EE, Putty.

Confidential, Buffalo, New York

ETL/BI Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Data migration - Includes migration of data from legacy environment to Oracle System.
• Involved in Data Validation using SQL queries.
• Responsible for creation of data extracts, data structures, reports, graphs, and other reporting objects.
• Identify issues, information and behaviors during the adoption of a proprietary information management system.
• Utilized Access database to collect data from multiple database sources using ODBC methods. Developed procedures for exporting information in Excel format in development server.
• Inserted charts that displayed trends, historical inventory and sales levels in the Access application in real time.
• Clearly communicated and documented test results and defect resolutions during all phases of testing.
• Responsible to check whether the interface and the extensions properly integrate with the facets application.
• Experience with Autosys job scheduler including jil scripting, virtual machines and custom calendars.
• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Performed Black-box testing, White-box testing, System Testing, Data Integrity Testing and end to end testing
• Implemented SDLC, QA methodologies and concepts in the Project
• Involved in Developing Test Plans and Developed Test Cases/Test Strategy with input from the assigned Business Analysts
• Developed UNIX batch jobs.
• Developed test scripts based upon business requirements and processes. Processed transactions from system entry to exit. Tested functionality across applications and workflows.
• Involved in developing Unix Shell wrappers to run various SQL Scripts.
• Developed JIL’s for AutoSys for job settings and job scheduling.
• Extensively created UNIX shell scripts for scheduling and running the required jobs.
• Involved in testing the designing and development of data warehouse environment.
• Worked with appropriate business and technology leads to determine the acceptable range for test results and performance
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Coordinated component, system testing with the appropriate technical groups and Release Management and documented test procedures and findings.
• Reconciled test results from different tests and different groups. Assessed readiness and deviation of product/project performance based upon test results and product specifications.
• Effectively coordinated with the development team.
• Created critical scenarios for each change request and defect request.

Environment: Windows NT, UNIX Shell Scripting, HP Quality Center 8.2, Facets, IBM AIX, Oracle 10g, TOAD, SSIS, Business Objects XIR3, IBM UDB DB2, Autosys 11, Crystal Reports, XML, MVS, COBOL, Flat Files.

Confidential, Seattle, WA

SQL/ BI Tester

Responsibilities:

• Created Test Case documents in MS Excel template from the Test Plan and the Business Requirements documents.
• Testing ETL sessions and PL/SQL scripts for multiple feeds and multiple LOBS’.
• Exported Manual Test Cases from MS Excel template directly to Mercury Test Director and executed 100% of the Test Cases in Test Director with Pass/Fail/Blocked status.
• 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.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Used Business Objects OLAP Intelligence to natively access and analyze OLAP servers. OLAP Intelligence tool helps to Slice, dice, and drill directly on multidimensional sources and deliver workflows via the Web, Windows, and Microsoft Excel.
• Tested ad hoc and canned reports for Business objects.
• Ran UNIX shell scripts to count the records for EDW source to staging tables.
• Ran SQL queries to verify the number of records and validated the referential integrity rules as per the design specifications.
• Coordinated execution of User Acceptance Testing, regression and integration testing with multiple departments.
• Identified appropriate test data in relevant source systems and incorporated this data into test scripts.
• Performed Functional, Regression, Data Integrity, System, Compatibility, and User Acceptance Testing including GUI testing.
• Executed test cases for data validation, link verification and content verification.
• Involved in backend testing with SQL, check the data integrity and referential integrity.
• Performed the back end testing by using SQL Queries and verified the data integrity.
• Coordinated with the developers to resolve defects.
• Involved in documentation in order to maintain and run scripts for future enhancements.

Environment: Informatica Power Center 7.1, Autosys, SQL, PL/SQL, Shell Scripting, PERL, Business Objects 6.1,T-SQL, SQL Server 2000, Teradata V2R5, Test Director 7.5, Clear Quest, MS Office Suite, ASP, Crystal Reports, HTML, JAVA, JSP, JavaScript, UNIX, Windows NT/XP/2000