Professional Summary:

• Over 6 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, Client/Server applications.
• Experienced SQL Data Analyst / Data Reporting Analyst with strong background in design, development, and support of online databases and information products as well as data analysis / reporting / processing.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading
• Expertise in Oracle Business Intelligence EE OBIEE 10.x Administration, Presentation Services and Siebel Analytics Admin Tool, Analytic Web and Scheduler .
• Extensively worked with OBIEE to build Physical Model, Business Model and presentation layer and established relationships.
• Automated and scheduled multiple ETL jobs using UNIX Shell Scripting.
• 6 years of solid experience in preparing Test Plans, Test scenarios, test scripts and test cases.
• 3 years of Hands on experience in Financial and Banking Domain Personal, Business, IRA accounts and Investment products. Money Market, Savings, Credit cards and Loans.
• 2 years of experience in IBM Mainframes CICS, IMS, FileAid, ISPF, QMF, TSO, COBOL and JCL.
• Comprehensive know-how of QA methodologies like Capability Maturity Model CMM Rational Unified Process RUP .
• Good understanding of ETL Test Processes and Test Methodologies.
• Proficient in Data Warehouse testing like Control Mechanism of batch loads, Error/ rejected records processing, testing of SCD implementations and process dependencies.
• 6 years of experience in writing SQL Queries for different Databases such as DB2, Oracle, Teradata and SQL server T-SQL .
• 5 years of experience using Rational Tools, Mercury Test Director and HP Quality Center.
• 3 years of experience using Mercury Quick Test Professional.
• Well versed with Manual and Automated Testing methodologies and principles.
• Extensively worked with all phases of testing including creation of Test plans, Test Strategy, Test case specifications, Test execution, Defect tracking, Resolution, Documenting and Reporting.
• Excellent experience in various industries such as Health care, Banking, Insurance, Resorts and Financials.
• Strong Technical abilities in Analyzing and Setup Testing environments and software's.
• 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.

Technical Skills:

Operating Systems: Windows 2000/NT/XP/Vista, UNIX Linux, Sun Solaris, IBM AIX

Databases: Oracle 8.1/9i/10g,PL/SQL,SQL Server 2000/2005, Siebel, Sybase 12.3, Teradata V2R6

ETL Tools: Informatica 6.1, 7.1, 8.1, Ab Initio GDE 1.14, Co>Op 2.14 and Data Stage 6.x/7.x/8.x

Reporting Tools: Cognos 7.3/8.0 Series, Business Objects 5.0/6.5/XI R2/R1

Query Tools: PL/SQL, Toad 7.4/8.3.6, SQL Query Analyzer, SQL Plus

Scripting Languages: XML, HTML, XHTML, Shell Scripting, PERL

Languages: C/C , SQL, PL/SQL, JAVA 1.5, XSLT, Java Script

Application Development: Visual Basic 6.0, Oracle9i/10g

Packages: MS-Office, Visual Studio. 2005

Modeling Tools: Star-Schema Snowflake-FACT and Dimension Tables, Erwin 4.0, ER studio

Scheduler Tools: Autosys, Appworx, Tidal, Control-M

Work Summary

Confidential

Sr. OBIEE Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Defined data requirements and elements used in XML transactions.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Reviewed Informatica mappings and test cases before delivering to Client.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Write SQL queries to validate that actual test results match with expected results
• Responsible for monitoring data for porting to current versions.
• Checked the reports for any naming inconsistencies and to improve user readability.
• Compared the actual result with expected results. Validated the data by reverse engineering methodology ie backward navigation from target to source.
• Supported the entire Testing Phase of the project by creating and executing manual test cases to support OBIEE
• Worked on OBIEE Add-Inns for MS Office applications Excel and PowerPoint.
• Worked on OBI Publisher importing data from multiple data sources and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation service
• Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results.
• Involved in validating the reports layouts in OBIEE based on Report Layout Document
• creation and execution of test cases on Oracle Reports and OBIEE
• created and tested Validation of reports in BOXI and OBIEE created and tested Validation of reports in BOXI and OBIEE
• Experienced in writing UNIX script
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
• Developed SQL Stored Procedures and Queries for Back end testing.
• Validating the reporting objects in the reporter against the design specification document.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Validating the Archive process to purge the data that meet the defined business rules.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Involved in all testing phases: Unit Testing, System Testing, Regression Testing, Integration Testing, and Quality Assurance Testing.
• Validated the ETL Scripts in the Target Database Oracle for creating the cube before migrating it to SQL Server.
• Designed and developed Test Plans and Test Cases and executed them Validated the OLAP cubes generated in SQL Server Environment.
• Well versed with Unix Shell Scripting.
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Written several complex SQL queries for validating and verifying the data across different databases including SQL Server 2005 and Oracle 10g.
• Prepared test plans/test schedules with inputs from Project manager and development team
• Responsible for reporting and escalating data issues arising from project or daily support.
• Assisted in creating test data and test cases and execute function system tests as needed.
• Worked closely with bottler lead to ensure data required to be sent to bottling community is validated, cleansed, corrected where necessary, and documented.
• Developed/revised training documentation and procedure manuals.
• Responsible for running and analyzing quality check reports to ensure system is functioning properly
• Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.

Environment: Informatica 8.6, Korn Shell Scripts and Perl Scripts, SQL, PL/SQL, Teradata V2R6, Autosys, Flat Files, Quick Test Pro 8.0, OBIEE 11.1/10.1.3.3, UNIX, Shell Scripts, Mercury Quality Center, Oracle 10g, Rational Robot, Rational Clear Quest, Rational Test Manager, Rational Functional Tester, Rational Manual Tester, Rational Clear Case, IBM Mainframes, CICS, Sybase, Oracle, SQL Plus, Access, SOAP, XML, XML Spy, SQL, TSO/ISPF

Confidential

ETL /BI Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
• Gap Analysis between the HIPAA Transactions 837P and 837I and Facets system
• Involved in the configuration of Facets system for the HIPAA changes
• Defined data requirements and elements used in XML transactions.
• Reviewed and approved database modifications
• Tested the database schema with help of data architects using ERWIN
• Involved in the testing of Data Mart using Power Center
• Identified and Documented additional data cleansing needs and consistent error patterns that could diverted by modifying ETL code.
• Tested the reports generated by OBIEE and verified and validated the reports using SQL.
• Extensively tested several OBIEE reports for data quality
• Report testing: Extensive experience with Reporting Tools like OBIEE
• Performed front-end testing on OBIEE Executive Dashboard portal
• Interacted with Users to understand the bugs in Business Reports generated from OBIEE
• Tested all OBIEE Dashboards according to the requirement
• Published defect reports and defect metrics on daily basis.
• Prepared release notes with help from developers for every release
• Participated in discussions with the business owners regarding rating test cases/results.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Wrote several UNIX scripts for invoking data reconciliation.
• Experience in creating UNIX scripts for file transfer and file manipulation writing UNIX scripts to perform certain tasks and assisting developers with problems and SQL optimization
• Converted SQL queries results into PERL variable and parsed the same for multiple reasons.
• 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.
• Involved in functional testing the Web application using Quick Test Pro.
• Validated the data in the reports by writing simple to complex SQL queries in the transactional system
• Tested different detail, summary reports and on demand reports.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Processed a query to update a field in an Oracle database, to ensure that debt payments are allocated.
• 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.
• Worked in multiple source data extraction and data transition from existing production system to test environment.
• Performed User Acceptance Testing and Regression testing.
• Did Unit Testing for all reports and packages.
• Tested the entire data reconciliation process for multiple source and target systems.
• Involved in System Analysis, Design and Development of the OLAP application
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Tested reports using variety of parameters.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio

Environment: Informatica Power Center 6.2/7.x, PowerConnect, Flat files, Erwin 4.0, MS SQL Server 2005, Oracle 9i, SQL, PL/SQL, IBM DB2 8.0, Teradata V2R5, OBIEE 11.1/10.1.3.3,COBOL , UTL FILE, TSO, ISPF, OS/z, JCL, Mainframes, Toad, Unix Shell Scripting, Windows XP/2000.

Confidential

SQL Tester/Developer

Responsibilities:

• Participated and Performed System Integration testing by developing Sub graphs and Integrated with Extraction and Load Graphs.
• Used TestDirector to Report bugs and Data Quality Issues on each check sum and field validation Tests completed.
• Involved in testing HIPAA EDI Transactions and mainly focused on 837 and 835.
• Communicated and Discussed with Developers about the status of each Data Quality Issues
• Ran SQL Statements manually to execute Record Counts on Each Table Loaded into System and Compared with Source Table.
• Involved in testing the efficiency of healthcare delivery by using HIPAA
• Created Testing Audit Table and ran the graphs to store the end results of each test in SAT Audit Table Schema .
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Tested the SAS jobs in batch mode through UNIX shell scripts
• Tested and Automated SAS jobs running on a daily, weekly and monthly basis using Unix Shell Scripting
• Modifying the existing Shell Scripts with Ultra Edit utility.
• Interacted with end users to obtain specific system requirements and for User Acceptance Tests UAT .
• Written various Autosys JIL Scripts to activate the UNIX scripts in production i.e. Jil scripts for the Box and Commands.
• Detailed repeatable end to end test cases for application, interviewed developers to gain detailed information on complex calculations and backend exception processing in order to validate the back end utilizing SQL Plus
• Involved in requirements gathering and analysis in support of data warehousing efforts and data quality analysis for cleansing and developed ETL specifications.
• Written UNIX AWK Scripts to manipulate test data and input files.
• Responsible to find out different DDL Issues and Report to DBA's using Test Director.
• Participated in bug triage meetings with developers to validate the severity of the bug and responsible for tracking of the bug life cycle using TestDirector.
• Designed test data using MS Excel sheet, created data driven test for testing the application with positive and negative inputs.
• Perform data driven testing and validated the test results.
• Created various User Defined Functions for script enhancements and to verify the business logic.
• Create various test Batch jobs to run and monitor group of jobs with DataStage Director.
• Written Complicated SQL queries in DB2 for Update Dimension Tables, Export Data from Target tables etc.
• Wrote complex SQL scripts in DB2 for testing data quality and validation.
• Execute the Unix Shell Scripts to Know the Backend Batch Jobs Status

Environment: Ascential Data Stage 6.x/7.x, Oracle 9i, Autosys, IBM DB2, Syncsort, Erwin 4.0, Business Objects 5.x, IBM AIX-UNIX 5.0, Windows NT, Shell Scripting, SQL, PL/SQL, Test Plan, Test Cases, Test Scripts, COBOL, VSAM Files, TSO, MVS, ISPF, JCL, XML, XSLT, XSD, XML Spy.

Confidential

SQL/ETL/SQL Analyst

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 LOB's.
• 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.
• Use 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.
• Tested Business Objects reports and Web Intelligence reports.
• Managed user accounts and security using Business Objects Supervisor
• 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.
• Used Mercury Quality Center to document issues found during the test automation process, suggested appropriate solutions and prioritized defects for resolution in coordination with the development team.
• 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.
• Scripts have been written for both Batch mode which will write results to the individual called test and Interactive non-batch mode which will write to the main test.
• 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, Autosys, SQL, Business Objects 6.1,T-SQL, SQL Server 2000, Teradata V2R6, Test Director, Clear Quest, MS Office Suite, IE, ASP, Crystal Reports, , HTML, JAVA, JSP, JavaScript Windows NT/XP/2000.

Confidential

Programmer/QA Engineer

Responsibilities:

• Understanding the ETL Design specifications which helps as LLD for the development of the mappings
• Creating the mappings according to the ETL Design specifications.
• Responsible for Extraction, Transformation Loading data from source to staging and staging to IDW Tables.
• Involved in interacting with end-users and generated various reports according to end-user requirements and archiving the reports
• Developed Macros to convert the reports to Excel and used Broadcast Agent to send the Excel reports to End-Users
• Created Stored Procedures/Functions/Packages.
• Involved in testing and validating the data.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Applied business and application knowledge to design the data loads for consistency and integrity.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Developed Interfaces using UNIX Shell Script to automate the bulk load update Processes.
• Migrating universes and reports from development to Production domain.
• Involved in the development of Informatica mappings and also tuned for better performance
• Carry out the Unit test for the mappings developed.

Environment: Environment: Oracle 8.0, DB2, Informatica Power Mart 5.x/6.x, SQL, PL/SQL, COGNOS BI, SQL Loader, UNIX Shell Scripts, PERL, XML, XSLT, XSD, XML Spy, SUN Solaris, Windows NT.