We provide IT Staff Augmentation Services!

Sr. Quality Professional Resume

California

PROFESSIONAL SUMMARY

  • Have 8+yrs (Including 2+yrs of Lead experience)of 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.
  • Extensive testing ETL experience using Ab Initio (GDE 1.14, Co > Op 2.14) & Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
  • Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
  • Expertise in utilizing Oracle utility tool SQL*Loader and expertise in Toad for developing Oracle applications.
  • Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes
  • Application Data warehousing experience in Banking, Pharmaceutical and Insurance.
  • Performed Unit, Integration and System Testing.
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
  • Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
  • Designed data models using Erwin.
  • Experience in developing various OLAP Models & Meta-Outlines using Essbase Integration Services (EIS) and generated scripts to automate building outlines in Essbase.
  • Did Front-End Web Testing using QTP and HP Quality Center.
  • Strong Knowledge of relational database design.
  • Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.
  • Solid time management and multitasking skills, which help in conducting project meetings, reviews, walkthroughs, and customer interviews according to the varied needs of the people involved
  • Excellent written and oral communication skills and a team-player with a results-oriented attitude

Technical Skills:

Hardware Pentium 4, IBM AS/400 Mid Range machine
Operating Systems Windows XP, Window 2000, MS-Dos, OS/400, UNIX
Languages & Software Java2.0, C, COBOL 400, RPG 400, CL 400, SQL, J2EE, EJB
1x, 2.0, Applets, Servlets, HTML
Domains Banking, Financial, Brokerage, Telecom, Service Oriented,Healthcare
ETL Tools Ab Initio (GDE 1.14, Co>Op 2.14), Informatica 9.1/8.1, Initiate 9.7
Middleware Web Logic, IBM’s Web Sphere, Java Web Server, Enterprise viewer, Inspector
Others MS Project, Visio, MS Office, MS Excel
BI Tools MicroStrategy 8.0.2, Administration, Crystal Reports,BO
Tools Erwin 3.5.2, PVCS, Rational Clear Case,HP Quality center 10.0, TOAD, WinSQL
Databases Oracle 9i/10g, DB2 8.0, MS SQL Server 2000/2005, Teradata V2R6

PROFESSIONAL EXPERIENCE

Confidential, California
SR. Quality Professional
Project Description:

Confidential program objective is to build a “single of truth” that meets the core needs of Health Plan and Regional Analytic and Reporting functions vis-à-vis Market Strategy & Analysis (MSA), Regional Market Planning (RMP), Decision Support Systems (DSS), National Pricing System (NPS), Customer Analysis Reporting (CAR) and Database Marketing. It provides consistent, non-volatile and time variant data tracking and control within the MDW as repository of 3 multiple data sources including Foundation System (SC,NC), Common Membership (CO,NW,HI,OH,GA) and The Membership System (MA) regions. It also provides secure, auditable reporting/analytics infrastructure for controlling access and authorization rights to Membership data for business and downstream users. It ensures robust, scalable and reliable data quality controls before bringing data into target MDW from disparate sources, staging and conforming layers.

Responsibilities:
  • Working as part of Membership and Claims data ware house SIT team
  • Involved in Providing Quality assurance for System, Integration and Regression testing cycles
  • Responsible for providing the testing status in team meeting as a member of the SIT team
  • Involved in using the Extensive SQL queries to verify the Mapping from Source to Target
  • Responsible for coordinating with Business and date creation team to get the data created in time to meet the deliverables on time
  • Establishing and documenting a tailored strategy quality plan in collaboration with the project manager, for the performance of quality assurance activities for assigned project or task.
  • Developing and maintaining quality assurance documentation for projects and tasks to include quality metrics. Ensuring documentation complies with established software development standards, policies and procedures or best practices.
  • Conducting assessments and evaluations through analysis and interpretation of objective and subjective evidence to verify compliance to established standards and applicable quality plan. Determines level of process and product quality. Develops written reports of findings; escalates unresolved issues to appropriate level.
  • Evaluating work products to independently assess quality and report’s findings. Researching alternative solutions to problems, determining proper approaches and making verbal and/or written recommendations to appropriate parties. Assisting in implementing recommendations as approved.
  • Gathering uses and independently analyzing defect metrics data. Presenting analysis findings to the appropriate level verbally and through the preparation of periodic written reports. Providing recommendations regarding possible approaches to resolving defects.
  • Participating in special projects, external audits and process improvements in support of quality assurance initiatives.
  • Assisting management in defining and maintaining an effective and efficient quality program including developing and presenting associated training and familiarization to affected staff.
  • Updating the Release Trackers regarding the progress of the Testing tasks
  • Extensively used QC for uploading Requirements, Test cases and mapping the requirements to the test cases
  • Executed the Test cases in Test lab and Tracked the Defect Life cycle.
  • Reviewed the test summary, Exit criteria and out of scope items before providing Signoff for the projects
  • Making sure that the documents are uploaded at designated paths for audit purposes and future visibility.

Confidential, VA
BI/ETL Tester/ LEAD

Responsibilities:
  • Played an effective role in coordinating with customer/ business team in order to deliver the expected output for the release.
  • Played key role in integration projects for integrating the ING and HSBC compliance data to Capital one
  • Worked on Risk management tools like Actimize, Bridger to screen any fraudulent activities going on in a financial institution.
  • Effectively coordinated the work between offshore and onsite teams
  • Played an effective role in SDLC Cycle
  • Reviewed and gave inputs in preparing and approving BR,SR and DR’s for the projects
  • Tested many enhancements as part of Business as usual
  • Maintained Regression suites and housekeeping of Quality center for best documentation practices.
  • Played an effective role in Conducting Value add on meeting as part of the team to better serve the organization.
  • Performed System, integration and regression testing and assisted UAT and Performance testing
  • Prepared Test plan/BAS for the projects and Monthly releases
  • Worked in co-ordination with IT and Business teams in assessing the data flow through the components and analyzing any rejects
  • Maintained Issue trackers to clearly track the issues encountered during Testing and defect fix phases.
  • Clearly reported and documented the Test artifacts
  • Prepared system, integration and regression test cases and reviewed the same with team and maintained Requirements Traceability
  • Effectively presented the Results to the team and provided sign off on timely basis.
  • Prepared Performance testing assessments forms and coordinated with Performance testing Team in determining if the performance testing is needed or not.
  • Effectively communicated the testing status on Daily scrum meetings as part of agile methodolog
Environment: Informatica Power Center 9.0(Power Center Designer, workflow manager, workflow monitor, MSTR 8.1.1, Erwin 4.0, Oracle 9i/10g, HP Quality Center,SQL Plus, SQL, PL/SQL, MS Excel Add-in, XML, XSLT, XSD, Test Cases, Test Plan, Traceability Matrix, UNIX, Shell Scripting, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, TPUMP, BTEQ), Teradata SQL Assistant 6.0
.
Confidential, VA
BI/ETL Test lead

Responsibilities:
  • Played an effective role in end to end SDLC and STLC
  • Successfully managed a group of Quality analysts.
  • Analyzed and Reviewed the Business, system and data requirements with the team.
  • Developed test Plan, Test strategy, Test scenarios and test scripts as per the requirements and design
  • Coordinated Offshore and onsite team and delivered the services on time effectively to accommodate the release time lines.
  • Performed Sanity, system, Integration, Regression Testing
  • Supported Performance, Load and UAT testing
  • Created requirements traceability matrix for the test cases developed
  • Reviewed Test plan and Test cases with the team
  • Used Quality center for documenting the test cases
  • Executed the Test cases in Test lab and Logged the defects and linked the same with the respective Test cases
  • Effectively communicated the Defect status within the team for clear idea on issues affecting the release timeline
  • Developed Shell scripts and successfully executed the scripts
  • Performed Positive and negative Testing for all the data fields
  • Testes various Load jobs to load the data into tables
  • Reviewed LDM, PDM and tested the Tables for their DML’S and Load properties
  • Tested complex Transformations in ETL process
  • Had excellent command on Unix scripting SQL queries
  • Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
  • Used SQL in extensively querying the Teradata database in Unix environment
  • Presented the Test results to team to review and get approval
  • Created Gold regression suites for use in Future enhancements and defect fixes
  • Created and Maintained Master run books for future use
  • Conducted inter and intra domain Knowledge sharing sessions to effectively manage Resources effectively
  • Effectively provided the Testing documents like BAS/Test plan, Performance assessment document (PAA), Test cases and Test results to the Project management team for Pre and post release Documentation
  • Reviewed the test entrance and exit criteria’s with in the Software testing life cycle for smooth delivery of the testing services
  • Proved as an excellent team leader
  • Worked on IBM’S Initiate software and had hands on experience handling Work bench, Enterprise viewer and Inspector
  • Had excellent knowledge on Meta data managing tools like initiate which will manage customer data from various sources and lines of business

Environment: Ab Initio (GDE 1.14, Co>Op 2.14), EME, Data Profiler, Rational Clear Quest, VB Script, Quality center 10.0, IBM’S Initiate tools, Work bench, Enterprise viewer, Inspector, Erwin 4.0, Oracle 9i/10g, SQL Plus, SQL, PL/SQL, MS Excel Add-in, XML, XSLT, XSD, UNIX, Shell Scripting, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, TPUMP, BTEQ), Teradata SQL Assistant 6.0


Confidential, Charlotte NC
BI/ETL Tester

Responsibilities:
  • Interacted with clients to determine User requirements and goals.
  • Participated in analysis of Business and functional requirements
  • Wrote SQL queries to test the application for data integrity and verified the contents of the data table.
  • Developed Test Plan and overall Test Strategy for the Application.
  • Developed Test cases , Test plans, and Test procedures using MS Word and MS Excel
  • Developed Test Cases and Test Scripts for System and UAT Testing.
  • Performed Positive and Negative Testing for this application.
  • Extensively used SQL queries to check storage and accuracy of data in database table
  • Performed basic testing of security features using manual testing
  • Responsible for creating Test Strategy for the Data Warehouse
  • Involved in creating the design and technical specifications for the ETL process of the project.
  • Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplet Designer and Transformation Developer.
  • Worked on trimming the SQL and optimizing the SQL by using various VLDB settings in the MSTR to avoid the cross join and removing multiple passes.
  • Extensively used various types of transformations such as Expression, Joiner, Update strategy, Look up, filter for developing mappings
  • Development of mappings as per the technical specifications approved by the client.
  • Created reusable transformations and mapplets to use in multiple mappings.
  • Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
  • Performed Black box testing, Functional testing, Integration testing, Regression testing, System Testing in Testing environment
  • Developed Test Cases and Test Scripts for System and UAT Testing.
  • Performed Positive and Negative Testing for application.
  • Responsible for communicating Defect Status Reports to business in project meetings.
  • Participated and Organized weekly meetings and walkthroughs to improve the testing efforts.
  • Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
  • Worked with Agile Methodology
  • Extensive user of Clear Quest for defect tracking, process automation, reporting and lifecycle traceability for better visibility and control of the SDLC
  • Strong Windows operating-system background, with understanding of the key drivers and influences on performance
  • Conduct performance-tests, Create test reports and present test results to project-team
  • Involved in automation of test cases using QTP.
  • Reported bugs and tracked defects using Rational Clear Quest.
  • Tested web forms from test to production using Export and Import.
  • Tested various business rule and data load rule files.
  • Involved in the production support team for planning cycle after production implementation. Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
  • Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
  • Written several UNIX scripts for invoking data reconciliation.
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Used SQL for Querying the Oracle database in UNIX environment
  • Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
  • Developed and optimized the calculation scripts in order to calculate the data present in the Essbase cubes
  • Created and maintained test scripts in Rational Clear Quest and co-ordinate with the ETL group and other developers.
  • Synchronized the dimensions of development planning with production planning
  • Troubleshooting the planning web forms with user testing
  • Involved in integration/system testing and backup/restore testing for all components
  • Involved in the production support team for planning cycle after production implementation.
  • Verify development of rule-set test scenarios, test cases, expected results and analysis of XML test scripts
  • Maintain defect management in Clear Quest while supporting UAT sessions

Environment: Informatica Power Center 6.2 (Power Center Designer, workflow manager, workflow monitor, MSTR 8.1.1, Erwin 4.0, Oracle 9i/10g, SQL Plus, SQL, PL/SQL, MS Excel Add-in, XML, XSLT, XSD, Test Cases, Test Plan, Traceability Matrix, UNIX, HP Quality Center, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, TPUMP, BTEQ), Teradata SQL Assistant 6.0

Confidential, Warren, NJ
BI/ETL Test Engineer

Responsibilities:
  • Implement the strategic plan for support of future company information requirements.
  • Involved in predefining data mapping from ETL & BI to the relational source, and running ad-hoc queries for providing optimized reports.
  • Created Test Strategy for Enterprise Data Warehouse in ETL framework, including Business Intelligence.
  • Involved in developing Unix Korn Shell wrappers to run various Ab Initio Scripts.
  • Tested several data validation graphs developed in Ab Initio environment
  • Tested graphs for extracting, cleansing, transforming, integrating, and loading data using Ab Initio ETL Tool.
  • Involved in Business analysis and requirements gathering.
  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
  • Worked with Agile Methodology.
  • Involved in the Meetings scheduled in order to discuss the documented Defects logged by the testing team using Clear Quest.
  • Fully documented and replicated defects for Developers, enabling them to fix Defects faster and meet Production Deadlines.
  • Participated in load testing exercises and tested dashboards and assisted development team with testing activities.
  • Did front-end testing and functional testing using Quick Test Pro.
  • Used Quality Center for Requirement Gathering and Test Case, Test Case Execution and Defect Tracking
  • Preparation of technical specifications and Source to Target mappings.
  • Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
  • Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
  • Highly experienced in various features of MicroStrategy like managing multiple projects, project migration and defining standards, procedures for development, production environment and maintenance of these environments to ensure the security
  • Provided technical guidance and support to end-users by developing the documentation required.
  • Worked on Excel Add-in Tools to generate various reports to analyze the business
  • Created users, user groups in the Planning application for accessing the various application elements.
  • Worked with ETL group for understating mappings for dimensions and facts.
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • Designing and creation of complex mappings using SCD Type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
  • 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.
  • 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.

Environment: Ab Initio (GDE 1.14, Co>Op 2.14), EME, Data Profiler ,MicroSrategy 8.0.2, Quality Center 8.2, Oracle 9i/8i, XML, XSLT, Rational Clear Quest, Clear Case, Agile, Quick Test Pro 9.0, UNIX Shell Scripting, UNIX, IBM AIX 5.3, Windows 2003, SQL, PL/SQL, TOAD, Teradata V2R6 (MLOAD, FLOAD, FEXPORT, BTEQ), Erwin 4.0, Teradata SQL Assistant 6.0

Confidential ,OH
ETL/Web Tester

Responsibilities:
  • Member of the warehouse design team, assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
  • Extensively used Informatica power center for ETL process.
  • Preparation of ETL mapping specifications.
  • Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplet Designer and Transformation Developer.
  • Designed mappings for dimensions and facts.
  • Extensively used various types of transformations such as Expression, Joiner, Update strategy, Look up, filter for developing mappings
  • Development of mappings as per the technical specifications approved by the client.
  • Created reusable transformations and mapplets to use in multiple mappings.
  • Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
  • Did lot of Web Testing using Quick Test Pro.
  • Tested both conditional formatting and threshold level testing for several reports developed in Micro strategy.
  • Involved in Unit testing and integration testing of Informatica mappings.
  • Implemented Error handling logic to capture the invalid data.
  • Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
  • Used workflow manager for session management, database connection management and scheduling of jobs.
  • Creating the catalogs and analyzing the joins.
  • Tested several business reports including Score Cards, KPI's, Summarized, Master-Detailed and Drill Down reports developed by Microstregy
  • Maintained various versions of the documents generated during the project using Rational Clear Case
  • Logged bugs that would enhance the usability of the application using Rational Clear Quest
  • Designed and implemented basic SQL queries for QA testing and report/ data validation
  • Assisted the QA team in designing the test plan and test cases. Performed User Acceptance Testing

Environment: Informatica Power Center 6.2 (Power Center Designer, workflow manager, workflow monitor, QTP, MicroSrategy 8.0.2, VB Script, SAS/SQL, SAS/ETL, UNIX, Korn, SQL, PL/SQL, Shell Scripting, Oracle8, SQL Server 2000, Windows 2000. UNIX Shell Scripting UML, RUP

Confidential , Bangalore
ETL Engineer

This application is developed for Confidential is the leader in global banking services and is the global franchise of Confidential. Confidential is the first financial services company in the United States to bring together banking, insurance and investments under one umbrella. Citibank focuses on technological innovation, seamlessly delivering value to customers across multiple-platforms.

Responsibilities:
  • Worked with the Center Business Management Team to support the Service and Sales departments with daily, cyclical and monthly reports.
  • Responsible for validating the ETL process of loading data from the source systems correctly into the target system.
  • Involved in validating the ETL mappings from various systems(CRM,OLTP) to transaction history/reporting database
  • Involved in system testing, data integrity testing and ETL testing.
  • Written and implemented System level Test plan, test cases and test scripts.
  • Responsible for data validations for initials/re-load and delta/incremental loads.
  • Involved in validating the Informatica mappings from OLTP servers/databases into the staging tables using Informatica Power Center 6.2.
  • Involved in validating the ETL lookup transformations.
  • Responsible for validating the no. of records for the update transformations
  • Responsible for validating the ETL process of loading data from the source systems correctly into the target system.
  • Developed several PL/SQL code and written several stored procedures
  • Interacted with Solutions analysts, system staff, ETL developers and the data load staff.
  • Involved in implementing the data integrity validation checks through constraints and triggers.
  • Facilitated training on customer service reporting platform to new management personnel.
  • Involved in Data modeling, normalization, de-normalization, physical database design and relational models, database procedures, functions, packages and triggers for enforcing the business rules using PL/SQL.
  • Expertise in Understanding the complete information flow, database objects creation, normalization.
Environment: Informatica 6.2/5.1, Toad, SQL, Test Director, Sun Solaris 5.8, PL/SQL, Windows NT 4.0, Erwin, Test Cases, Test Plan, Test Scripts, Stored Procedures, IBM AIX 5.0, Oracle 8i.

Hire Now