SUMMARY

• Over 6 years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Expert in writing SQL queries and has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Extensive testing ETL experience using Informatica 8.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager), AutoSys, Control M and Maestro.
• Worked in various Healthcare areas like Enrollment , Benefits , Claims , Medicare , and EDI X12 .
• Extensively Worked on HIPAA EDI X12 transaction sets 270 / 271 , 835 , 834 , 837 I / P , 997 etc.
• Hands on experience in configuration of claims adjudication systems, i.e., Facets, NASCO, QNXT.
• Experienced working for Data Migration, Data Extraction, Data Cleansing, Data Profiling, Data Consolidation, Data Standardization and Data Quality for various business data feeds.
• Proficient in using testing tools such as Quality Center, Win Runner, Load Runner and Quick Test Professional for web - based and client server applications.
• Hands on experience on ETL Micro Strategy tools in ETL process development, testing and in maintaining ETL codes.
• Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Ab Initio & Informatica
• Solid Back End Testing experience by writing and executing SQL Queries.
• Extensively worked in all phases of testing includes Integration, System, Regression, Load, Stress and User Acceptance Testing (UAT).
• Experience in UNIX shell scripting and configuring cron-jobs for ETL Loads
• Extensive experience with Reporting Tools like OBIEE, Cognos, Business Objects
• Experienced in running SQL, T- SQL, MDX using Toad and MS SQL Server 2000/2005/2008
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Data Stage
• Expertise in Testing complex Business rules by creating mapping and various transformations
• Experience in testing XML files and validating the data loaded to staging tables.
• Experience in testing and writing SQL and PL/SQL statements.
• Excellent Communication, Analytical and Interpersonal skills.
• Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming.
• Experienced working with Excel Pivot and VBA macros for various business scenarios.
• Team player with excellent Organization and Interpersonal skills and ability to work independently and deliver on time.

TECHNICAL SKILLS

ETL Tools: SSIS 9.0,Informatica 8.6.1/ 8.1/7.1/6.2/5.1 (Power Mart/Power Center) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect), Data stage 8.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 2005/2000, DB2, Teradata V2R6

OLAP Tools: Cognos 8.0/7.0/6.0, Business Objects XIR3/XIR2/6.x/5.x, SSRS 9.0 Micro Strategy OLAP Suite (8 & 7i),

Languages: SQL, PL/SQL, Visual Basic, XML, C, C++

Tools: Toad, SQL* Loader, SQL Assistant,

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

Testing Tools: QTP 10/9.2, Quality Center 10, Test Director

Rational Tools: RUP, Rational Clear Case, Clear Quest, Test Manager, PVCS, Rational Requisite Pro, IBM Rational Manual Tester

Workflow Tools: MS-Project, MS-Excel, MS-PowerPoint, MS-Word.

Job Schedulers: Control M, AutoSys, Maestro

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr DWH Tester/SQL Tester/BI Tester/ETL Tester

Responsibilities:

• Prepared data mapping document for various data feeds for ETL to write and develop the data extraction routines.
• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Coordinated between offshore and onsite team and managed multiple OLAP and ETL projects for various testing needs.
• Extensively used Informatica for extraction, transformation and loading process
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Performed extensive data validations against Data Warehouse
• Logging and tracking defects on a release basis using HP Quality Center.
• Tested and validated the Report Net reports by running similar SQL queries against the source system(s).
• Created and implemented Micro Strategy reports by creating projects, schema objects and public objects, Attributes, hierarchies, metrics, filters, and templates.
• Did extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.
• Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
• Performed MS SQL Server T- SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Trained the users before UAT on how to test and document the test results. Also, assisted the users during UAT. Took part in Triage Meetings with the required parties after defect analysis to prioritize defect resolution.
• 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.
• Tested Micro Strategy reports and written test cases using HP Quality Center.
• Tested and validated the cube data, ensuring that the data is correct by comparing the data results to comparable source system reports or by querying individual transactions and forms.
• Tested all the reports by running queries against the warehouse-using TOAD. Also compared those queries with the Micro Strategy SQL engine generated queries.
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Conditional testing of constraints based on the business rules
• Analyzed the Requirement Traceability Matrix, Daily Test Status reports, Weekly defects report, and Risk analysis by communicating with the Business Team.
• Defects were tracked and prioritized using Quality Center and analyzed the variation between expected result and actual result.
• Designing and creating new reports, Freeform sql reports in Micro Strategy
• Designed and prepared scripts to monitor uptime/downtime of different system components
• Extracted certain column of data from a number to files using PERL.

Environment: Informatica 8.6.1, XML, XSLT, PERL, Micro Strategy, SQL Server 2008, QTP, Quality Center 10.0, DTS, T-SQL, SQL, Teradata V2R6, TOAD, Teradata SQL Assistant 6.0, Oracle 10g, PL/SQL, IBM DB2, MS Access/Excel/Visio, UNIX Shell Scripting

Confidential, Charlotte, NC

DWH/ETL/SQL Tester /BI Backend Tester

Responsibilities:

• Analyzed the Functional requirements using Scenarios & DDD(Detailed Design Document)
• Involved in Manual and Automated testing using QTP.
• Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios).
• Used Micro Strategy tool reporting and data analysis of data stored in relational database, multi dimensional and flat files.
• Defects tracking, review, analyze and compare results using Quality Center.
• Extracted data from files and upload to Teradata tables using Teradata utilities FASTLOAD using Informatica
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning
• Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.
• Developed UNIX Shell scripts to automate repetitive database processes
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Used SQL plus as a query analyzer to run queries against the warehouse to get a better understanding of the SQL produced by Micro Strategy, which greatly enabled in better data quality
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files
• Extracted data from flat files and RDBMS tables and upload into targets Oracle tables. Used Informatica as the ETL tool to extract the data from sources and loading it into targets.
• Involved in Test Scheduling and milestones with the dependencies
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Performed validation tests to ensure that the developed functionality meets the specifications prior to UAT testing.
• Used standard testing techniques to test the data validity before deploying the Micro Strategy Reports to Users.
• Tested jobs and used Informatica as an ETL tool to load the final loads. Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs
• Did testing of SOA end to end, Service by service and Interface by Interface
• Tested SOA application interface and communication paths.
• Tested data feeds from XML to Database.
• Development of test plan, test case and test scripts in Quality Center after for functional, system integration, Usability, security testing.
• Tested several different types of reports including Report Layout, Naming Conventions, Totals, Sub-Totals, Drilling options, prompts, metric calculations, drill maps and security filters using Micro Strategy
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Generated XML data files using XML Spy.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: SOAP, SOAPUI, Web Services, Informatica 8.6, Micro Strategy, QTP 9.2, SQL Server 2005, Quality Center 9.2, PERL, Oracle 10g, Java, TOAD, Unix AIX 5.2,VB Script, XML, XSLT, XML Spy, SQL, PL/SQL, MS Excel, Shell Scripting, OLAP, Teradata V2R6

Confidential, New York City, New York

DWH Tester

Responsibilities:

• Developed business data feeds document for data mapping needs for ETL and BI purpose to migrate the data
• Written complex SQL queries for querying data against different data bases for data verification process.
• Written extensive PERL scripts for various needs including text processing, data parsing and database connectivity.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Extensively used SQL programming in backend and front-end functions, procedures, and packages.
• Tested different types of reports, like Master/Detail, Cross Tab and Charts (for trend analysis).
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• Setting up, monitoring and using Job Control System in Development/QA/Prod.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.
• Created UAT test cases and scenarios based on Use Cases, and made sure those UAT test cases meets the business requirements.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Effectively communicate testing activities and findings in oral and written formats.
• Reported bugs and tracked defects using Test Director 6.5.
• Extensively used Informatics power center for extraction, transformation and loading process.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Worked on issues with migration from development to testing.
• Responsible for testing Business Reports developed by Business Objects XIR2
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.

Environment: PERL, UNIX Shell Scripting, Informatica Power Center 7.1/6.2 (Power Center Designer, workflow manager, workflow monitor), MS Excel, Mercury Test Director 6.5, QTP 7.2, SQL *Loader, XML, Cognos 7.0, Oracle8i, SQL Server 2000, Erwin 3.5, Windows 2000, TOAD 7, Business Objects XIR2, Teradata V2R4