SUMMARY

• Senior ETL Tester having 8 years of experience in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis, and developing design specifications.
• Strong understanding of relational database software development and integration techniques, tools, and methodologies.
• Experience in writing complex SQL Queries, created materialized views.
• Strong understanding of logical and physical database designs and dimensional modeling schemas like Star and Snowflake schema.
• Expertise in Data Modeling using tools like Erwin, ER/Studio and MS Visio along with the hands - on experience in using Forward Engineering and Reverse Engineering functionality.
• Expert in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Experience in Data Modeling for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Proficient in designing, modeling, creating, and maintaining Oracle database.
• Experience in Performance Tuning, SQL Tuning, Table Space Partitioning, creation of indexes for faster database access and better query performance.
• Experience in languages like JAVA and Python.
• Proficient in Rational tools including Rational Rose, and Requisite Pro. Excellent skills in Business Analysis, Data Analysis, Data Mapping, Requirement Analysis, Business Modeling and Use Case Development using UML methodology
• Thorough knowledge of Software Development Life Cycle (SDLC), understanding various phases like Requirement gathering, Analysis/Design, Development and Testing knowledge of Rational Unified Process (RUP).
• Adept in streamlining Business processes by recognizing and avoiding bottlenecks, thereby reducing Cycle time, and improving system efficiency and employee productivity.
• Extensive experience involving Business Process Re-Engineering, Software Re-Engineering using RUP methodology and ERP Systems Implementation and Continuous Improvement techniques.
• Excellent system, process, and quality validation skills.
• Excellent business communications skills in writing System Requirements document, Systems Design Specification and System Requirement Change Request.
• Excellent documentation skills in creating BRD and translating it into detailed Functional Specifications Document and Data Models.
• Experience in conducting Joint Application Development (JAD) sessions with end-users, expert team, development and QA team for project meetings, walkthroughs, and customer interviews.

TECHNICAL SKILLS

Database Systems: SQL Server (2005/2000/7.0 ), Access 2003, Oracle (9i/8i/7.x), IBM DB2/UDBa, MySQL.

Data Modeling Tools: ER/Studio, ERwin, Oracle Designer, Power Designer, and Visio

Data warehousing: Microsoft OLAP Service, Data Marts

Data Mining: SAS Enterprise Miner and Knowledge Seeker

Reporting: Crystal Reports and SQL Server 2000/2005 reporting services

ETL Tools: Informatica 8.1/7.x/6.x/5. x., Data Stage, XSD, SAS

Database Development: T-SQL and PL/SQL

Testing Tool: QTP, Quality Center

Office Applications: MS Office (Word, Excel, PowerPoint)

Web Development: HTML, XML and FrontPage

Operating Systems: Windows (Me, XP), Solaris, Linux, Unix

Programming Languages: C#, Visual Basic.NET, Java and C++, Perl

PROFESSIONAL EXPERIENCE

Confidential

Sr ETL Tester

Responsibilities:

• Created and executed automated test scripts using Selenium WebDriver using JAVA.
• UsedJAVAas a programming language and Visual Studios as IDE for automating the Test Suite with Selenium WebDriver.
• Responsible for Data modeling and Mapping through data analysis to extract data elements from various OLTP’s using ETL technique and utilized Business Intelligence Tool for report generation.
• GeneratedCognosreport and validate the data using SQL queries in Teradata and Oracle data bases.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Responsible for Regression testing and smoke testing of Trade flow applications involve Investment instruments like Treasury Securities, Bonds, Mutual Funds, Money Markets, Derivatives (OTC and ETF), Equities.
• Performed Smoke Testing to make sure all the Test Channels and Test Environment is working as desired
• Performed root cause analysis regarding any bugs/issues found causing the defect.
• Maintained the Selenium & JAVA Automation Code and resources in source controls like TFS for improvements and new features.
• Responsible for testing of the electronic and Fix messaging trading platform in Investment industry.
• Conducted backend testing using SQL queries to validate data for database and Used SQL queries for retrieving data from database for executing user specific test cases.
• Involved in designing and implementing of hybrid automation framework to be used with Selenium Web driver.
• Performed system integration testing for equities (equity stocks, futures, options), equity derivatives and fixed income.
• Responsible for analyzing requirements and create test plan and test cases for application with the Fixed Income securities (Treasuries, Bonds, Mutual Funds) for Investment.
• Developed and Designed ETL test cases, scenarios, and scripts to ensure quality Data warehouse / BI applications.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Created test cases for ETL mappings and design documents for production support.
• Involved in the review of data map and creation of ETL SQL queries.
• Extensively used SQL for data validation and back end testing for various scenarios.
• Validated ETL- Transformation, Data Cleansing, Lookups, and Business Rules.
• Analyzed and aligned all databases during ETL testing to properly extract all pertinent enterprise information into the application.
• Developed reports and dashboards using Microsoft Power BI stack - Power Pivot, power query.
• Tested a number of complex ETL mappings and reusable transformations for daily data loads.
• Done the API testing Using UI tool creating customers and validate in Back end and front-end systems.
• Reviewed the automation scripts and created Continuous Integration Jobs in Jenkins (CI/CD).
• Performed BDD (Behavior Driven Development) using Cucumber Features, Scenarios and Step Definitions in Gherkins format.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Used Java script and Python as client library for Selenium WebDriver to design and developed Automation test Framework using TestNG.
• Created and executed automated test scripts using Selenium WebDriver using JAVA and Python.
• Worked on SOAP UI to test multiple APIs before it’s been implemented in Compass to make sure the new APIs built were working correctly.
• UsedJAVAas a programming language for automating the Test Suite with Selenium WebDriver.
• Created complex Crystal reports by invoking stored procedures against Oracle database
• Created very complex Crystal reports with up to 27 sub reports all linked with parameters
• Tested mapping for extracting, cleansing, transforming, integrating, and loading data using Informatica ETL Tool.
• Involved in writing, implementing and documenting the Test Plan, Test Strategies, Test Cases, Test scripts.
• Performed Functional, Negative, Positive, Integration, Regression, and End to End, Ad-hoc and User Acceptance Testing.
• Created test scripts usingGroovy scriptto automate web services inSOAP UI.
• Involved in writing unique XPath using Firebug and Fire path to identify web elements.
• Prepared Test Matrix to keep track of the requirements and the test cases.
• Enhanced the automated test framework (Selenium WebDriver and JAVA) by adding reusable functions and methods
• Worked closely with Development team on ETL process, data infrastructure, data modeling, business intelligence reporting and dashboards.

Environment: Java, Selenium WebDriver, TestNG, Maven, AB initio, Eclipse, Quality Center, SQL, Agile and Windows, Reporting, Cucumber, Jenkins, ETL, Informatica

Confidential

ETL Tester

Responsibilities:

• Automating the QA stories using Selenium Web driver, Python at sprint level and Regression level using Selenium framework.
• Tested web services by generating XML SOAP requests and validated the corresponding XML SOAP responses.
• Integrated Automation scripts (Selenium & Python) in Continuous Integration tools (Jenkins) for nightly batch run of the Script.
• Responsible fortestingall new and existingETL Data warehouse components.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Worked with the components of Data Warehousing like components model,ETL tools.
• Tested the different sources such as Flat files, Mainframes Legacy Flat Files, DB2 and Oracle to load into the OracleData warehouse.
• Created and executed automated test scripts using Selenium using Python.
• Attended daily Standup meeting with team members of Web team and developers to evaluate the project progress.
• Worked on distributed test automation execution on different environment as part of Continuous Integration Process using Selenium in Python.
• Created test cases, test plans, tested API's using rest assured, wrote Junit test cases, executed code coverage, wrote automation scripts using Selenium WebDriver with Python.
• Tested theETLAb Initio graphs and otherETLProcesses (Data warehouseTesting)
• Actively participated in the weekly Project Status Meetings.
• Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and Documenting the test results.
• Tested theETLgraphs and otherETLProcesses (DW Testing).
• Performed Data Validation of the data flow from the front-end to the back-end by executing SQL scripts.
• Performed Data Profiling of current state of data in the Data warehouse by doing Data Analysis using advanced SQL Queries and Microsoft Excel, finding Gaps in Data and formulating solutions for the same
• Reported bug/issue and prepared document as per requirement using HP ALM
• Created and maintained automated regression test cases in Selenium using Python
• Involved in testing of services usingSOAP/RESTservices usingSOAP UI, Groovy Script.
• Designed and published visually rich and intuitive Tableau dashboards and Crystal Reports for executive decision making.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Worked with the components of Data Warehousing like components model,ETL tools.
• Tested the different sources such as Flat files, Mainframes Legacy Flat Files, DB2 and Oracle to load into the OracleData warehouse.
• Tested theETLAb Initio graphs and otherETLProcesses (Data warehouseTesting)
• Actively participated in the weekly Project Status Meetings.
• Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and Documenting the test results
• Tested theETLgraphs and otherETLProcesses (DW Testing).
• Performed Data Profiling of current state of data in the Data warehouse by doing Data Analysis using advanced SQL Queries and Microsoft Excel, finding Gaps in Data and formulating solutions for the same
• Validated the response for the Restful APIs using custom assertions using Postman
• Performed Web Services testing for REST API Calls.Performed API Testing using Rest Client and SOAP UI.

Environment: HP ALM/Quality Center, Agile, Python,, AWS, ETL, Hadoop, UAT, SOAP UI, Cucumber, AB Initio, Agile, Selenium WebDriver, Java, TestNG, SQL, Oracle, Windows, MS Office, Jenkins, Postman,, Crystal reports, Tableau

Confidential, Baltimore, MD

QA Analyst/ETL tester

Responsibilities:

• Gathered the business requirements by conducting a series of meetings with business users.
• Created logical data model from the conceptual model and its conversion into the physical database design.
• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models.
• Used Sybase Power Designer tool for relational database and dimensional data warehouse designs.
• Created reports using SQL Server Reporting Services (SSIS).
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed, and sent to an external entity.
• Responsible for creating mapping documents required for the ETL team.
• Developed SSIS Packages to transfer the data between SQL Server database and files.
• Created SQL, PL/SQL, SQL Loader control files, functions, procedures, and UNIX Shell scripts.
• Been a part of Architecture and modeling team and have used SOA (Service Oriented Architecture)
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, analyze using OLAP tools).
• Experience on Extraction Transformation and Loading (ETL) process using SSIS
• Conduct data mapping sessions and write the required business requirements documentation including use cases.
• Created entity-relationship diagrams, functional decomposition diagrams and data flow diagrams.
• Used Star Schema and Snowflake Schema for data marts / Data Warehouse.
• Prepared the Joins/Filter logic documents that would help the ETL design team perform the Joins on the tables that are in the form of flat files before loading them to FDS or any downstream systems.
• Used DOORS to link requirements to test cases, business rules, design items to maintain traceability.
• Created documentation and test cases, worked with users for new module enhancements and testing.
• Used SQL Server 2005 tools like Management Studio, Query Editor, Business Intelligence Development Studio (BIDS) including SSIS and SSRS.
• Created job schedules to automate the ETL process
• Normalized the database up to 3NF to put them into the star schema of the data warehouse.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data
• Worked with business analyst to design weekly reports using Cognos Report Net.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
• Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
• Reduced labor-intensive manual processes like job entry, approval, and invoicing by exposing well-defined SOA interface allowing B2B integration with Financial Clients
• Worked on building load rules and transformation logic for Extraction, Transformation and Loading (ETL) of the data into the data warehouse.