SUMMARY

Twelve years of Total IT experience and Technical proficiency in Data Warehousing teamed with Business Analysis, Application Design, Data Modeling, Development, Testing and Documentation. Extensive experience in designing, analyzing and developing ETL, gathering and reviewing requirements, creating testing artifacts, Metrics, and Defect Reports.

Over 8 years of experience in Quality Analysis, Quality Assurance, and Testing.

Over 6 years of experience in an FDA regulated Quality System environment

Over 4 years of experience in data Extraction, Transformation and Loading data using Informatica Power Center 7.1.3/6.1,6.2/5.1.2 Designer, Workflow Manager, Workflow Monitor

Comprehensive knowledge of QA Methodology and Processes

Excellent Knowledge in Dimensional Data Modeling Star Schema, Snow-flake Schema, FACT and Dimension tables , Logical and Physical Data Modeling using Erwin.

Extensive experience with Data migration, Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.

Trained in multiple SDLC methodologies and have significant expertise in software testing. Strong skills in manual testing. Proficient in Functional Testing, DB Testing, Black Box /White Box Testing, Acceptance Testing, Stress and Performance Testing.

Proficient in multiple OS environments including UNIX, Linux, Windows

Actively participated in all aspects of project work including Business Analysis, Development, Testing, and User Training Support

Team player and self-starter with a professional attitude. Have excellent analytical, communication, problem solving, time management and prioritization skills

Comprehensive understanding of ETL standards, flows, methodologies, procedures, and documentation.

TECHNICAL SKILLS:

WORK EXPERIENCE:

QA Lead / SSRS Developer

FMH provides complete farm insurance solutions for America's heartland, and secures the financial future of farmers and mutuals with Federal and Private crop insurance, Farm Ranch insurance, and Reinsurance products. The CloudNet project is a refactoring and upgrade of the insurance management application used to create insurance policies, file claims and resolve them, manage agents' payouts, and communicate with FDA.

QA Responsibilities:

• Lead the QA team of the Claims Department for the CloudNet project
• Implemented an assessment on the whole QA department to identify shortcomings and suggest solutions to upper management, then implemented them
• Created QA Processes and artifacts to standardize the QA methodology across all QA teams
• Selected, Interviewed, Managed, and Mentored Quality Assurance analysts
• Lead all testing activities and created project testing artifacts including: Test Plan, Test Specifications, Test Cases, Progress Reports, Bug Reports
• Provided estimates and resource needs for project planning activities
• Lead the Bug Scrub meetings to prioritize and route all defects
• Reviewed and imported the Business Requirements Documents into the Test Track Pro Requirements tracking module
• Tracked requirements traceability to test cases to ensure proper testing coverage
• Lead the daily status report meetings for the Claims team which included resolving issues and ensuring timely conclusion of tasks.

Development Responsibilities:

• Designed, Coded and Tested Multiple SSRS Reports pertaining to the QA process including: QA Metrics Report, Productivity Report, Traceability Report, Defect Analysis Report, Defect Burn down Report, Project Progress Projection Model Report.
• Designed and coded an automated tool to upload requirements into the requirements tracking tool

Environment: Sql Server 2008 R2 SSRS, Oracle 11g, Test Track Pro, Windows 7, SharePoint

CONFIDENTIAL

QA Lead / ETL Tester/ Developer/Business Analyst

InputAccel, CaliberRM, SilkCentral, ATMS Plateau , SQL LIMS, SAP, CATSWeb, Quality System Reporting Portal.

Abbott Vascular, a division of Abbott, is one of the world's leading vascular care businesses. Abbott Vascular is uniquely focused on transforming the treatment of vascular disease and improving patient care by combining the latest medical device innovations with world-class pharmaceuticals, investing in research and development and advancing medicine through training and education.

QA Responsibilities:

• Selected, Interviewed, Hired, Managed, and Mentored multiple groups of Quality Assurance analysts and testers for multiple projects
• Managed all testing activities throughout all project phases and created all testing artifacts including: Departmental Test Plan, Project Test Plans, Test Specifications, Installation Verifications, Release Validations, Test Cases, Progress Reports, Bug Reports, and Test Summary Reports
• Provided estimates and resource needs for project planning activities
• Created work breakdown structures and defined and prioritized tasks to fulfill specific objectives within narrow deadlines.
• Designed and implemented targeted solutions to solve specific software engineering best practices issues
• Administered SilkCentral test manager and CaliberRM for the Quality and SAP departments and provided user support and training, and tool customizations as required.
• Involved in requirement gathering and review meetings as a Quality Team representative for in-house applications
• Reviewed and analyzed requirements to guaranty feasibility and testability.
• Analyzed the source data to ensure data integrity and cleanness while migrating legacy systems
• Designed complex SQL queries to manually test multiple hierarchies in the SSRS ad-hoc reporting environment and the dimensional environment
• Tracked the requirements traceability to test cases to ensure proper testing coverage
• Coordinated the business analysis, requirements collection and Use-Case design between the on-shore BA and Off-shore QA teams
• Managing the Off-shore team's test case development and design of the test strategy to meet requirements.
• Piloted the implementation and transition between Rational Test manager and Borland SilkCentral Test Manager
• Reviewed and validated test artifacts to fulfill strict FDA and GMP regulations and in-house SDLC processes.
• Designed the data dictionary to ensure proper migration from different data models and hierarchies
• Coordinated the training and User Acceptance Testing with the business team
• Coordinated with multiple other application owners to schedule and run tests over multiple platforms and domains
• Tested the Dev, QA and Prod environments to ensure settings conformity per FDA regulations
• Gathered application performance metrics and designed automated tests to ensure the new application performs as expected
• Tested multiple applications utilizing a wide variety of technologies and techniques: Back-End testing, Data Migration Validation, Data integrity testing, sampling, white box testing, black box testing, performance testing, User acceptance testing, formal validation, BI reports testing, ETL validation, test automation

Development Responsibilities:

• Designed, Implemented and Deployed multiple C .NET and aspx applications and utilities
• Implemented and Configured Off-The-Shelf applications such as EMC InputAccel, CaliberRM, SilkCentral Test Manager
• Designed and Implemented reports using multiple technologies including: Eclipse BIRT, Crystal Reports, Cognos, Sql Server Reporting Services
• Designed and Implemented multiple ALM utilities to automate or facilitate SDLC processes

Business Analysis Responsibilities:

• Lead the BA team in gathering requirements, documenting business processes, and designing user case scenarios
• Conducted Requirements gathering session, requirement review sessions, Hazard Risk Analyses, Traceability and Coverage analyses
• Created and Managed all project required SDLC documentation including: Requirements Plans, Requirement Specifications, Requirement Traceability Matrices, Hazard Risk Analyses, Function Based Assessments, Implementation Plans, Configuration Management Plans, Production Support Plans, and Backup Specifications.
• Conducted User Training efforts and created User Manuals.

Environment: MS Sql Server 2005 Database Engine / SSIS / SSRS, Oracle 10g/9i, TOAD, Fogbugz, Rational Test Manager, SilkCentral Test Manager, Windows 7/NT/XP pro, windows server 2003, HPUX, Perforce, CaliberRM, EMC InputAccel, Plateau, SQL LIMS, Cognos, Informatica, .NET aspx, C , BIRT, Crystal Reports

CONFIDENTIAL

Sr. QA Analyst / DW Tester

CONFIDENTIAL is the world leader in delivering innovation in communications, mobility, information and entertainment. We provide superior broadband, video and other wireless and wireline services to consumers, businesses, governments and wholesale customers across the globe.

Responsibilities:

• Analyzed the business requirement specs for each report to develop the manual test scripts and design specification documentation
• Involved in both ETL, warehouse and reports validation.
• Analyzed the Source to Staging and Stage to Warehouse documents to come up with test plans for tables data validation.
• Developed the SQL queries to validate each transformation rule using AQT.
• Involved in implementing a standard Software Development Life Cycle.
• Performed all phases of testing: System, Integration, Regression, and Performance testing.
• All defects detected were tracked, analyzed and documented using Test Director.
• Performed analysis of software quality and testing progress to provide status to project team, by coordinating with offshore.
• Executed shell scripts to refresh the QA DB in order to reflect the changes made to the mapping workflows.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Extensively used ERwin 4.0 for data modeling and Dimensional Data Modeling.
• Used SQL to query the DB and created/modified SQL scripts to validate back-end data Integrity test using TOAD.
• Involved in validation of Customer Record Uploading, Usage Records uploading, Billing End-to-End run and Export customer record using Amdocs Ensemble.
• Interacted with the Business Users for user acceptance testing.
• Involved in Upgrading Informatica 6.2 to Informatica 7.1.2 testing
• Tested Informatica Mappings and Sessions for optimum performance. Also helped in tuning systems and network.
• Created PL/SQL triggers.
• Logged defects and submitted change requests using defects module of Test Director
• Maintain Development, Test and Production mapping migration Using Repository Manager.

Environment: Informatica PowerCenter, PowerMart,Teradata, Oracle 10g/9i, SQL, PL/SQL SQL Plus, Explain Plan, TOAD, Erwin 3.5.2/4.0/4.1, Teradata Utility Pack BTEQ, Windows NT 4.0, Sun Solaris Unix 9

CONFIDENTIAL

ETL QA Engineer / Informatica Administrator

CONFIDENTIAL . is a large diversified news and information company. The company's 90 daily newspapers in the USA have a combined daily paid circulation of approximately 7.3 million. They include CONFIDENTIAL TODAY, the nation's largest-selling daily newspaper, with a circulation of approximately 2.3 million, In addition, Gannett owns nearly 1,000 non-daily publications and CONFIDENTIAL WEEKEND, and the firm owns and operates 23 television stations. The goal of Project was to merge two old data marts into one integrated architecture and also incorporate data from SAP Supply chain management system which was deployed to replace old legacy systems. This standardized ETL processing and consolidated reporting and downstream systems feed into a single source of data.

Responsibilities:

• Assumed the role of administrator of the whole system, granted access rights and configured the system to work properly.
• Analyzed the business requirement document and the system requirement document to come up with a detailed Test Plan.
• Executed test cases manually to check GUI and Functional features of the application.
• Collected and documented test data for functional testing as documented in test plan.
• Developed automation scripts for Functionality and Regression testing using Robot.
• Developed scripts manually for different modules and worked with Robot for developing automation scripts.
• Retrieved, modified and executed UNIX shell scripts.
• Performed Cross Browser testing of the application.
• Conducted Oracle database testing by developing SQL Queries.
• Defects were tracked and prioritized using Test Director and analyzed the variation between expected and actual results.
• Analyzed defects status using Test Director and interacted with developers to fix defects/bugs of the application.

Environment: Test Director , SQL, IBM DB2, Informatica PowerCenter, Embarcadero Rapid SQL 7.3.3,MS SQL Server, Seapine Surround SCM 4.0,Mercury Quality Center 8.2, Test Director ,DataDirect Connect ODBC 5.1, Solaris 9, WindowsXP

CONFIDENTIAL

Informatica Developer ETL Developer ETL Analyst

CONFIDENTIAL is one of the nation's largest financial holding companies. They offer a wide-range of financial and banking services to seven states and selected services to customers on a national level. The sales, commission and internal revenue analysis data Mart was integrated for Business Analysis and it was integrated with Global Data Warehouse.

Responsibilities:

• Analyzed and reviewed high level business requirements and transformed them into concise functional requirements and technical specifications
• Designed and developed Informatica Mapping for data load and data cleansing
• Extracted, transformed data from various sources such as Flat files, MS SQL Server and transferred data to the target data warehouse Oracle9i and Flat files
• Worked on Informatica Power Center tools-Source analyzer, Warehouse Designer, Mapping Designer and Transformation developer
• Conducted manual unit testing on basic functionalities of the application.
• Tested SQL Statements against Oracle database for performance tuning and optimization.
• Designed and developed complex aggregate, join, look up transformation rules business rules to generate consolidated fact/summary data identified by dimensions using Informatica ETL tool
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate one time, Weekly, Monthly and Yearly Loading of Data
• Utilized the Aggregate, Join, Router, Look up and Update transformations to model various standardized business processes
• Developed the Informatica scripts in order to populate the Global repository from the local repository
• Worked with Scheduler and Cron jobs to run the Informatica session on daily basis and to send an email after the completion of loading
• Optimize SQL queries for better performance. Experience in SQL DML, DDL and DCL statements
• Designed and developed Unit test plan, System test plan and File layouts.
• Prepared test input data for the negative and positive test scenarios.
• Performed analysis of software quality and testing progress to provide status to project team.
• Identified the business critical processes that stress the web and database server.
• Assisted in implementing a standard Software Development Life Cycle.

Environment: Test Director, Oracle 8i, SQL, PL/SQL, SQL Plus, Informatica PowerCenter 5.1, Informatica PowerMart 4.7, Erwin 3.0, SQL Server 7.0, Business Objects 4.1, Windows 2000, UNIX.

CONFIDENTIAL

Oracle/PL-SQL Developer

CONFIDENTIAL Group is one of the nation's leading foodservice distributors, delivering food and food-related products to more than 41,000 restaurants and institutional customers across the Confidential. The project involved the creation and maintenance of a database to keep track of the various departments and their revenues, Inventory. The project involves Design and Development of an Intranet based application to maintain Inventory, Sales, revenues and Product catalog

Responsibilities:

• Involved in the gathering of requirements needed for the database. Interacted with various department personnel to gather the requirements
• Create various tables to maintain details about the various departments.
• Created indexes on columns to improve the query performance
• Created triggers, stored procedures.
• Created sequences for parameters in the table.
• Developed PL/SQL scripts to load data to interface tables.
• Design Development of user interface using Developer/2000 and Designer/2000.
• Design Development of reports using Reports 3.0.
• Developed PL/SQL Packages to upload daily, monthly balance data into system.
• Production Support - Retrieving and loading data from banks.
• Preparing documentation for User Support.
• Prepared Roles for System User to give security to the system.
• Involved in the User acceptance test which include series of Interviews Interaction with Users.
• Administered databases and handled large volume of data.

Environment: Oracle 8.x/7.x, MS-SQL Server 7.0/6.5, Pl/Sql, SQL Loader, TOAD, Developer/2000, T-SQL, Designer/2000, UNIX and Windows NT.

CONFIDENTIAL

IT-Intern

CONFIDENTIALCorporation is a CONFIDENTIAL, Va.-based company that controls a major freight railroad, CONFIDENTIALCompany. The railway operates approximately 21,200 route miles in 22 eastern states, the District of CONFIDENTIALserves all major eastern ports and connects with rail partners in the West and CONFIDENTIAL linking customers to markets around the world. This company wanted to automate their entire railway wagon lease and rental system. Developed Front-end and back-end. Visual Basic was used for front-end and Oracle as the back-end.

Responsibilities:

• Interacted with users to understand the business requirement.
• Developed the ER-model and normalized it to the 3NF.
• Checked the model for entity integrity and referential integrity.
• Worked thoroughly on PL/SQL, Tables, Views, Synonyms, and Indexes.
• Analyzed the existing Stored Procedures, Functions, Triggers and Cursors. Worked thoroughly on performance issues.
• Worked extensively on Exception handling. Used SQLERRM and SQLCODE to trouble-shoot PL/SQL code.
• Worked on Visual Basic as the front-end and Oracle as the back-end.
• Designed the front end with many buttons, texts, labels, drop boxes and other front-end Tools and set up the ODBC connection.
• Environment: Oracle 7.3, SQL Plus and PL/SQL and Visual Basic.