SUMMARY

• Over 7+ 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
• Automated and scheduled multiple ETL jobs using UNIX Shell Scripting.
• Well versed in Business Objects(XI R2, 6.X and 5.X) including Central Management Console, Central Configuration Manager, Desktop Intelligence, Import Wizard, WebI XIR2, Application Foundation/Performance Manager (Dashboards), Supervisor, Designer, Reporter, Web Intelligence, Info View, ZABO, Broadcast Agent Publisher
• 7 years of solid experience in preparing Test Plans, Test scenarios, test scripts and test cases.
• 6 years of Hands on experience in Financial and Banking Domain - Personal, Business, IRA accounts and Investment products. Money Market, Savings, Credit cards and Loans.
• 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.
• 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 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 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: Business Objects(XI R2, 6.X and 5.X) including Central Management Console, Central Configuration Manager, Desktop Intelligence, Import Wizard, WebI XIR2, Application Foundation/Performance Manager (Dashboards), Supervisor, Designer, Reporter, Web Intelligence, Info View, ZABO, Broadcast Agent Publisher

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

Others: Visual Source Safe, File Zilla, MKS Tool kit, XML Spy 2008 (UNIX scripts)

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Data Warehouse 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.
• 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.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Involved in testing the Business Objects performance & connectivity across different domains.
• Tested complex objects to the universe to enhance the report functionality.
• 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
• Tested the universes and reports in Business Objects 6.0
• Created reports using Business Objects functionalities like Slice & Dice, Drill Mode, @Functions,Cross Tab, Master/Detail and Formulas etc.
• 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.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• 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: Business Objects(XI R2, 6.X and 5.X) including Central Management Console, Central Configuration Manager, Desktop Intelligence, Import Wizard, WebI XIR2, Korn Shell Scripts and Perl Scripts, SQL, PL/SQL, Teradata V2R6, Autosys, Flat Files, Quick Test Pro 8.0, Business Objects XIR2, 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

Confidential, Monterey Park, CA

DWH/QA/ETL / 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.
• 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.
• Primary tester for Business Objects reports migration from 6.5 to XI version and created Business Objects reports for defect tracking.
• Tuned the universe for better performance.
• Responsible for knowledge transition, documentation of every aspect of Universe and Report creation
• Created reports using Business Objects functionalities like Slice & Dice, Drill Mode, @Functions, Cross Tab, Master/Detail and Formulas etc.
• The reports that were created in Business Objects were testing by running the SQL statements
• Coordinated the test data, Business Objects environment and UAT of reports
• Performed manual functional and E-2-E integration testing of Business Objects reports
• Published defect reports and defect metrics on daily basis.
• Applied a wide range of Business Intelligence Solutions, using the functionality inherent in the Business Objects release XI suite (Crystal, Webi, Universe Designer, etc.)
• 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
• Tested complex reports with multiple data providers/different universes and databases (Oracle, SQL server, DB2).
• 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.
• Responsible for different Data mapping activities from Source systems to Teradata
• 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 and tested the entire data reconciliation process for multiple source and target systems.
• Worked with all kinds of Teradata Utilities including MLOAD, FLOAD, FEXPORT, TPUMP and BTEQ. Used Teradata SQL Assistant for retrieving the data.
• 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 and Worked on issues with migration from development to testing.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio

Environment: Business Objects(XI R2, 6.X and 5.X) including Central Management Console, Central Configuration Manager, Desktop Intelligence, Import Wizard, WebI XIR2, 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 V2R6 (MLOAD, FLOAD, FEXPORT, TPUMP, BTEQ), COBOL, UTL FILE, TSO, ISPF, OS/z, JCL, Mainframes, Toad, Unix Shell Scripting, Windows XP/2000

Confidential, New York

BI /SQL Tester

Responsibilities:

• Participated and Performed System Integration testing by developing Sub graphs and Integrated with Extraction and Load Graphs.
• Used Test Director to Report bugs and Data Quality Issues on each check sum and field validation Tests completed.
• 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.
• 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 SSRS report functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Ad hoc, Dashboards etc
• Tested all formats of SSRS reports including Excel, PDF, CSV, XML, TIFF and many other
• 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)..
• 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, SSIS/DTS, MS SQL SERVER 2005/2008, SSRS, SSAS, 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 2008

Confidential, San Francisco, CA

Business Object Developer /Tester

Responsibilities:

• Involved in Full project life cycle (requirement gathering to implementation and support).
• Prepared Business/Technical Requirements, Design Templates, Development Standards documents and Detailed Design documents.
• Defined data model requirements to meet reporting, analysis & specific Business Intelligence needs.
• Designed the ETL process to populate the ware house using Informatica 7.1, using ETL methodologies for supporting Data Extraction, Transformation and Loading utilizing Data Integrator 6.x.
• Understand complex technical specification documents to Create, Test and Execute Data Integrator jobs using Data Integrator Designer to transfer data from source to target.
• Worked with several functionalities of the designer to map data from source (flat files) to a target (Index Profile).
• Involved in creating Test Matrix for various work streams for traceability purposes.
• Involved in writing Test cases for all the links and various data files based on ETL Mapping document.
• Used QuickTestPro generated various scripts for performing functional testing.
• Written test cases to test the application manually in Quality Center and automated using Quick Test Pro.
• Involved in installation of Business Objects XI R2 and assisted in creating users and assigning them appropriate access rights.
• Migrated old Business Objects reports & crystal reports to BO XI.
• Developed the complex universes by using advanced features in Business Objects like Aggregate Awareness, Derived Tables, Cascading Prompts and Custom Hierarchies.
• Worked on resolving join path problems such as Loops and Traps by creating aliases and contexts.
• Created object level and row level securities in designer
• Created reports using Business Objects functionalities like Slice and Dice, Drill up/down, CrossTab, Master/Detail, Formulas and variables etc.
• Generated pictorial views in the form of 2D, 3D & Pie Charts from existing Reports and Chart Wizard etc.
• Implemented and given training session to train Power Users/Managers in BO functionality and to use the reports Design & Developed dashboards and deploy them across the organization to monitor the performance.
• Created periodical reports: daily, weekly, monthly, quarterly, annual reports for different types of claims and for different Business Units
• Created complex reports using cascading prompts using both full client and thin client.
• Setting up the users, folders, categories and assigning Privileges.
• Created event based schedules of the reports and built an emailing mechanism to indicate success/failure of the schedule.
• Created and facilitated presentations and demonstrations for Business Intelligence tools and ETL tools.
• Scheduled the reports using the customized script and sent the reports to e-docs.
• Closely worked with business end users on production support related issues.

Environment: Business Objects XIR2 Enterprise Suite, Business Objects SDK (Designer, Desktop Intelligence, Informatica Power Center 7.1 CMS, CMC, Web Intelligence), Crystal Reports XI, JSP, Windows 2003, SQL Server, DB2, Oracle9i, SQL, PL/SQL, TOAD, Control-M, Teradata V2R4, MLOAD, FLOAD, FEXPORT, TPUMP, BTEQ

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.

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