We provide IT Staff Augmentation Services!

Sr. Etl Ab Initio Test Analyst Resume

3.00/5 (Submit Your Rating)

Wilmington, DE

PROFESSIONAL SUMMARY:

  • Over 7+ years of IT experience in the Analysis, design and testing of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
  • Experience in Data Analysis, Data Validation, Data Profiling, Data Verification, Data Loading and testing DWH application.
  • Experienced in complete Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Bug Life Cycle (BLC)
  • Extensive experience in Black Box Testing Functional Testing, Integration Testing, System Testing, Regression Testing, Performance Testing, UAT Testing, Manual Testing etc., on Enterprise Applications.
  • Worked on various Domains like Banking, retail and Finance.
  • Expertise in OLTP/OLAP System Study, Analysis and E - R modeling, developing Database Schemas like Star flake schema and Snowflake schema used in relational, dimensional and multidimensional modeling
  • Strong working experience in the Data Analysis, Design, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
  • Involved in preparation of Test Cases and to ensure detailed test process wrote Test Scripts
  • Involved in preparation of test data to test the functionality of Informatica Sources Mappings, Targets
  • Worked with both V-Model and Agile Methodology.
  • Proficient in warehouse designs based on Ralph Kimball (Bottom-Up) and Bill Inman (Top-Down) methodologies.
  • Adept in writing complex SQL queries.
  • Extensive Backend testing Experience on Database.
  • Expertise in Defect management, Bug tracking, Bug Reports and generating the Graphs using Test Management Tools such as Quality Center, Test Director
  • Involved in preparation of Weekly and Status reports.
  • Worked with wide variety of sources like Relational Databases, Flat Files, TeraData and DB2.

TECHNICAL SKILLS:

Testing Tools: Quality Center 10, Test Director 8.0

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake

ModelingDatabases: Oracle 9i/8i, DB2, TeraData, MS Access 2003, TOAD, DB2

ETL: Ab initio, Informatica Power Center 9.X/8.x

Programming: SQL, PL/SQL

Operating Systems: Windows95/98/2000/XP/2007, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, DE

Sr. ETL Ab initio Test Analyst

Responsibilities:

  • Worked with Business analysts to understand Business/System requirements in order to transform business requirements into functional test cases.
  • Responsible for reviewing Functional specs, user documentation and use cases and developing manual test cases out of it.
  • Responsible for planning and directing Quality Assurance and Software change control policies.
  • Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types
  • Coordinated in setting up Test Environments and Test Plan needs with team members.
  • Developing various Test Scripts, Test Execution using Quality Center based on the Functional Specifications.
  • Worked with ETL group for understating Ab Initio graphs for dimensions and facts.
  • Extensively used Ab Initio for extraction, transformation and loading process.
  • Experience in ETL Data Warehousing, database testing using Ab Initio for ETL process.
  • Created test plans and performed unit testing for the Ab Initio graphs
  • Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc
  • The reports that were created in Business Objects were testing by running the SQL statements
  • Executed Test Cases using positive and negative data in Quality Center’s Test Lab and reported results and defects using Quality Center’s Defects tool.
  • Involved in validating the Data mart tables as per the business logic applied to the staging tables.
  • Executed the test scripts against TeraData source and validated the rules according to mapping documentation.
  • Worked with Testing of Flat File and source data.
  • Developed SQL queries for Back-end testing/Database testing and participated in end to end testing.
  • Validated the source system data with the staging data using SQL and Pl/SQL scripts.
  • Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability
  • Expertise with System Testing, Functional Testing, Regression Testing.
  • Prepared Traceability Matrix with requirements versus test cases.
  • Tested several UNIX shell scripting for File validation and also PL/SQL programming
  • Involved in identifying the defects and developed Defect Tracking report using Mercury Quality Centre which involved Bug life cycle.
  • Provided daily and weekly status reports.

Environment: ALM 11, Abinitio Co>os3.0.3.6, GDE3.0.2.2, Business Objects XIR3, Erwin, Ms Excel, Oracle 11g, SQL, PL/SQL, SOAP UI, Teradata utilities, TOAD 8.0, UNIX, Windows 2003

Confidential, Providence, RI

Sr. ETL Ab initio Test Analyst

Responsibilities:

  • Analyzed the Business Requirements and Rules and worked with Business Analysts and Business Users in preparing Test Plans.
  • Gone thru the Functional Specifications and implemented their technical aspect in System and Integration testing (SIT).
  • Developed Test cases, Test scripts from the data mapping documents, functional Specification documents and mapped the test cases with the requirements for generating the Requirement Traceability Matrix (RTM).
  • Reviewing the project and coordinating with onsite Clients, onsite Project Leads and local reporting managers.
  • Running the Ab Initio Graphs in UNIX Environment by writing UNIX Shell Scripts and UNIX Commands.
  • Used Ab Initio components like Sort, Rollups, Merge and created common XFRs during the data transformation phase prior to creating load ready files.
  • Worked with Compatability Testing for Browser, Operating, Mobile & Printing options for Web Apps
  • Good experience in web related technologies including HTML, XML, SOAP, JavaScript, ASP, VB, VB.NET,ASP.NET
  • Based on the business requirements, created Test Plan, Test Cases, and Test Script documents to test the Business Objects reports
  • Created several Ad-hoc reports in Business Objects XI R2 to validate the data.
  • Involved in testing the Business Objects performance & connectivity across different domains.
  • Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, and System (End to End), UI Testing, Browser Compatibility, Backend (Database) Testing.
  • Scheduling shell script jobs, creating instances of jobs, verifying logs according to client requirement using Autosys server.
  • Involved in maintaining the test environments; with activities like requesting data loads, data base backups, restarting the servers, requesting the deployments, troubleshooting issues.
  • Exclusively tested the inbound and outbound batch jobs.
  • Involved in testing the functionality of ETL workflows.
  • Worked with the UNIX shell scripts.
  • Used HP Quality Center as test management tool.
  • Tested Business Objects Reports according to the business requirements.
  • Prioritized the test cases based on the projected metrics and project deadlines.
  • Worked with Developers on Defects until the test case is passed.
  • Generated reports using SOAPUI.
  • Extensively worked on the Console application and to bring the output of the console application to in corporate in to the web application.
  • Tested the outgoing links from all the web pages from specific domain.
  • Extensively written SQL to confirm the data transfer from source to target.
  • Involved in testing informatica workflows, and also involved in Data Migration.
  • Tested the PL/SQL procedures, functions, packages according to the requirements.
  • Verified test results (querying the database using the SQL) documenting the defects.
  • Involved in testing the UI screens, reports which was used by the internal business team.
  • Prepared Test Scenarios by creating Mock data based on the different test cases.
  • Attended Bi-Weekly Defect Review and Defect Status meetings. Provided updates to Team Lead on testing activities.

Environment: Ab Initio (GDE 1.14, Co>Op 2.14), Business Objects XIR2, HP Quality Center 11, TOADOracle 11g, Soap UI, DB2, PL/SQL, UNIX, Putty, Flat files, Session Logs

Confidential, Charlotte, NC

Sr. ETL QA Ab initio Test Analyst

Responsibilities:

  • As an ETL Tester I was involved in analyzing the existing system process.
  • Designed and created Documentation for the proposed system by creating Technical documentation, mapping documents, Functional Documents.
  • Enhanced the Legacy Technical Specifications to meet the Enhanced System specs.
  • Designed and maintained logical and physical enterprise data warehouse schemas.
  • Worked on Star schema loaded data using Fact Tables (Rebate Utilization, AMP Utilization Table, etc.) to the staging tables (I calculate).
  • As testing all data issues I have used SQL scripts to get issues resolved.
  • Created naming conventions and system standards for lookup (Connected and unconnected) transformation and target tables.
  • 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
  • Experienced in writing complex SQL queries for testing data in oracle targets.
  • Worked on issues with migration from development to testing.
  • Prepared test data to validate ETL rules wherever necessary.
  • Extensively used Ab Initio tool to extract, transform and load the data from Oracle to DB2.
  • Developed and documented data Mappings/Transformations, and Ab Initio testing as per the business requirement. Involved in the development of Ab Initio graphs and also tuned them for better performance.
  • Designed, developed and deployed new Data Marts along with modifying existing support additional business requirements
  • Worked on Source Analyzer, Power Center designer, Workflow manager, Mapping Designer.
  • Loaded data from source tables (Contract Pharmacy, Pharmacy Name, Pharmacies (vw), ProviderXRef (vw)) to the target table named Pharmacy Name.
  • Performed Regression Testing as and when the Bugs got fixed and check whether the application is free from builds.
  • Writing test plans to in corporate the testing needs of the data warehouse using Test Director.
  • Writing test cases for the data extracts to make sure the vendors are sending the correct data files.
  • Maintained Source definitions, Transformation rules and Target definitions.
  • Improved Performance for complex jobs by using Transformations Source Qualifier, Aggregator.
  • Involved in developing and maintaining Modeling standards, Operation procedures and new development areas.
  • Implemented Scheduled jobs in UNIX Environment and EDW scheduler.
  • Worked on testing with Complex Mappings by importing Procedures/functions to build business rules to load data.
  • As a testing process created Database scripts, Procedures, Database Constraints.
  • Designed developed and tested processes for validating and conditioning data and maintained test documents (UAT), System Testing and integration Testing.
  • Tuning was implemented as a part of the ETL testing with use of hints, parallel hints.
  • Translated business-reporting (OLTP REPORTS) requirements into Data Warehouse Architectural design.
  • Performed Performance tuning and solved data quality issues raised in loading the data form Source to Target.

Environment: Ab initio, Business Objects 5.0/6.5, Oracle 10g, SQL, PL/SQL, MS Access 2003, SOAP UIUNIX, TOAD

Confidential, Kansas, MO

ETL QA DWH Tester

Responsibilities:

  • Review the functional requirements and ensure the testability, SOX compliance for the same
  • Developed the test strategy for ensuring QA of Pinnacle points advance reporting
  • Review the mapping documents and develop test cases and test scripts accordingly
  • Ran SQL queries to verify the number of records from Source to Target and validated the referential integrity, Time variance, Missing records, and Nulls/Defaults/Trim spaces rules as per the design specifications.
  • Extensively used ETL and Informatica to load data from flat files (Price Group, Balancing File, etc.) MS Access.
  • Used Informatica Workflow Monitor to monitor workflows and review session log.
  • Involved in testing informatica workflows, and also involved in Data Migration.
  • Written complex SQL queries for several business scenarios to validate the data across source and target system
  • Involved in extensive DATA validation using SQL queries and back-end testing.
  • Developed SQL queries to verify the data loaded into the target tables.
  • Work as part of the team in execution and defect life cycle process
  • Develop QA progress report, bug reports, analyze risks on a daily, weekly and monthly basis
  • Responsible for coordinating off-shore and On-shore Test resources.
  • Performed Unit, Integration, and Regression and UAT Test phases.
  • Tracked QA process, reported defects and status of the defects in Mercury Quality center.

Environment: Informatica 8.6.1, Cpgnos 8.0 DB2, SQL, PL/SQL, XML, UNIX, TOAD, Quality Center 10

We'd love your feedback!