SUMMARY

• More than 8 years of IT experience in Software Testing, ETL, Data Analysis, Design, Development, Implementation, Testing and trouble shooting of DW.
• Developed and executed test plans, test cases, test processes, and methods.
• Experienced Software Professional with in depth understanding of all phases of SDLC, focusing on translating business requirements into viable technical solutions.
• Expertise in DWH technologies like Teradata concepts and loading utilities.
• Worked with Dimensional Data warehouses in Star and Snowflake Schemas, created slowly growing target mappings, Type1/2/3 dimension mappings.
• Excellent technical writing skills with hands on experience creating Business Requirements, Functional Specifications, Mapping Documents, E-R Diagrams, Test Plans, Test Scripts and Status Reports.
• Collaborate with development and integration teams to ensure tests are appropriately integrated.
• Experience working with huge volumes of data(EDW), analyzing record sets for Data Quality, Data Validation and Metrics using SQL and / or PL/SQL
• Proficiency in customization & implementation of ETL processes and Web applications
• Proven ability to coordinate medium sized project from initial conceptualization through implementation
• Experience working with various software development methodologies including Agile, Iterative and Waterfall
• Excellent knowledge in Teradata and Oracle Database Systems and Unix Platform
• Extensive domain knowledge of the latest Web Industry concepts like AJAX and Social Networking, financial services sector and CRM
• Dynamic team player who is consistently motivated toward success and completion of projects with an ability to work independently
• A quick learner who can swiftly adapt to new challenges.
• Prepared Regression Test Plans, Requirements Traceability Metrics (RTM), positive and negative test scenarios, detailed oriented Test Scripts, Test Kickoff documents, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use.

SKILLS
Languages: C/C++, .NET, JAVA, SOAP, SQL, PL/SQL.
RDBMS & Tools: Teradata(EDW), Oracle, Microsoft Access , TOAD,PUTTY ,WIN-SCP.
ETL Tools: Informatica, Teradata utilities (Fast export, Fast load, Mload)
Testing Tools: IBM DOORS, QTP, HP LoadRunner, JUnit
Platforms: MS Windows, DOS, Unix, Mac OS X, Linux
Web Authoring Tools: MS FrontPage, Dreamweaver, ASP Script, CSS, XML & HTML

PROFESSIONAL EXPERIENCE

Confidential,Aug 2011 – Present
ETL TESTER
San Mateo, CA
The project was at Abbot Diabetes Care a healthcare company. I was involved in testing a clinical Datamart(EDW) and producing the 6 different reports on the basis of patients e-metric system.

Responsibilities & Accomplishment:

• Develop and execute functional/system test cases to ensure that Datamart meets functional and design specifications.
• Expertise in DWH technologies like Teradata concepts and loading utilities.
• Tested the SQL queries on clinical DATA MART and Reviewed and collect medical information for creating Reports on lab results. The application was originally created for Windows and MAC platforms.
• Report product bugs, bug isolation, verify fixed bugs and issue resolution.
• Executed Medical Protocols to emulate Doctor-Patient scenarios to validate data accepting by device.
• Extensively used ETL to load data from XML source feed from vendor and Flat Files to Staging area using Informatica Power Center 8.5.1 Worked with pre and post sessions, and knowledge of identifying facts and dimensions tables.
• Coordinate execution activities at EDW level such as documentation requirements, technical reviews by Agile Lifecycle System, and verification, approval activities.
• Successfully completed ETMS training on FDA software validation and verification processes and procedures.
• Analyze data using SQL, Excel, UNIX and data testing tools.
• Produce test scenarios and repeatable test cases/scripts through all parts of the development lifecycle, execute and sign-off for a high volume of data and regular release schedule for successful project delivery.
• Verify the implemented ETL code against the corresponding mapping document. Confirm the data loads from source files into the target tables(DataWarehouse).
• Provide feedback to design reviews and test tool selections/improvements.
• Verified the logs to identify the errors occurred during the ETL execution.
• Written several complex SQL queries for data verification and data quality checks.
• Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests.

Confidential,July 2008 – Aug 2011
DATABASE TESTER
WALNUT CREEK ,CA
Confidential,is one of the leading divisions in GE, USA. This Orders Fulfillment project has a two-source system one is from Oracle application and another one is from Teradata The aim of the project is providing summary level orders information to the business users from the fact table.

• Participate in the full lifecycle for multiple data project: analysis, design, documentation, development and testing.
• Collaborate with Project Managers, business partners, and developers to coordinate project schedules and timelines.
• Analyze data using SQL, Excel, Unix and data testing tools.
• Verify the implemented ETL code against the corresponding mapping document. Confirm the data loads from source files into the target tables.
• Worked with Dimensional Data warehouses in Star and Snowflake Schemas, created slowly growing target mappings, Type1/2/3 dimension mappings.
• Designed and developed Experience with Informatica Power Center Mapping, Data Cleansing, Matching, Data Profile, Change Data Capture and Power Exchange, Metadata Repository
• Examine sample record sets for consistency, data corruption and over all data quality.
• Work with business partners, analysts, developers and project managers to develop test plans, produce test scenarios and repeatable test cases/scripts through all parts of the development lifecycle, execute and sign-off for a high volume of data and regular release schedule for successful project delivery.
• Coordinate Testing with remote teams based in Singapore, SINGAPORE and London, UK.
• Assign Testing Tasks for Asia and EU domiciled projects to Singapore based QA Engineer. Verify test results and review the same with San Francisco based Development Team.
• Support the London based Team on iShares EU projects.
• Execute and sign off on test scripts. Work closely with Ops Manager to update Release Grids.
• Create/Update Test plans (including estimating and maintaining a testing schedule).
• Identify, research, report, track and verify software defects proactively and comprehensively.
• Understand market, static and reference data.
• Validated Rebranding for all Internal Products, Data Applications, Datamarts and Services from Barclays branding to BlackRock branding for the BGI Acquisition project.

Confidential,July 2005 – Aug 2008
QA TESTER/ENGG.
SAN FRANCISCO, CA

• Participated in initial feasibility Analysis for IT Ascent for Credit Tickler Application rewrite.
• Analyzed the current requirements and proposed enhancements for the application.
• Performed Functional Point Analysis and classified the functionalities as Complex, Medium or Simple. Performed preliminary analysis on the data sources to identify any interfacing issues.
• Identified Risks and potential Roadblocks associated while rewriting an application from current Client - Server Model to Web Based Model.
• Created Work Flow for the Covenant Creation and Default Handling functionalities.
• Evaluated Serena Business Mash up Tool for this Project. Evaluated other tools to reduce development time and costs associated with it.
• Participated in the development of Enhancement for the current Commercial and Mortgage Securities Association (CMSA) Application.
• Analyzed the Relational Model between various associated tables. Analyze the data model that is current in place.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Analyzed the Test Data used for Unit and Integration Testing.
• Verified the Code and Stored Procedure to make sure that all Business Requirements are covered.
• Provided deliverables like Work Flows and Designs to the Developers.
• Extraction of test data from tables and loading of data into SQL tables.
• Extensively written test scripts for back-end validations and Ensured that the mappings are correct.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Analyzed a Post Production / Deployment issue with Watch List Enhancement.
• Wrote test case scripts; executed and documented detailed results and summary reports.
• Executed systems and data quality testing to ensure all development deliverables are production ready.
• Used Unix commands and utilities to monitor server side activities and performance.
• Designed and Created test plan, test scenarios and test cases for Data warehouse and ETL testing.
• Responsible to translate business requirements into quality assurance test cases.
• Review of test scenarios, test cases and Data warehouse Test Results.
• Developed test scripts using SQL queries to validate data.

Confidential,Feb 2000 – Mar 2005

Confidential,is the world\'s biggest food and beverage company. Data was received on a daily basis order and stored on the main server. The module name of the project where Informatica was used is called as Management Functionality Reporting.
Responsibilities:

• Developed various Sessions, Batches for all Mappings for loading from Source flat files, tables to Target tables(EDW).
• Worked on performance tuning for ETL processes.
• Created complex mappings using Unconnected, Lookup, and Aggregate transformations for populating target table in efficient manner.
• Extraction, Transformation and Load was performed using Informatica Power Center to build the data Marts.
• Worked on enhancements on existing Teradata Data warehouse according to business changes.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata
• Developed whole framework for ETL using PL/SQL to move data from legacy systems
• Modified or enhanced existing ETL processes to include additional client migration requirements

EDUCATION/CERTIFICATIONS