SUMMARY:

• Around 8+ years of IT experience in Quality Assurance for ETL, Backend, Web based, Client/Server applications using ETL, Manual and Automated testing tools
• Around 5 years of experience in Data Analyzing and supporting data extraction, transformations and loading processing, in a corporate - wide-ETL datawarehouse systems
• Expert in testing the cubes in various subject areas and report dashboards for data analytics
• Proficient in gathering and analyzing the Business Requirements, documenting System Requirement specification, Functional Requirement specifications, Requirements Traceability Matrix
• Experience in Travel, Insurance, Healthcare, Retail and Public Services
• Experience in Defining Testing Methodologies; Test Estimation, Requirements Review, creating Test Plans and Test Cases, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC)
• Strong working experience in validating DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using SSIS, Informatica and Data Stage and Pentaho
• Written test cases to test the application and tracking defects in Quality Center 9.0 and 11.0(ALM)
• Expertise in understanding Business Requirements, Functional Requirements, decomposing into HLD’s and ETL Specifications into Test Cases for positive and negative test conditions
• Experience in testing and writing SQL statements
• Expertise in multiple testing techniques including functional, regression, integration, system, parallel, data base, performance, smoke, User acceptance testing
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema
• Expertise in using data centric testing for data migration
• Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse
• Used Visual Studio Test Professional 2010 to configure or record manual tests
• Solid Back End Testing experience by writing and executing SQL Queries
• Involved in Developing Data Marts for specific Business aspects like Marketing & Finance.
• Involved in working on reporting services like SSRS/Business Objects/Crystal Reports and SQL Server Analysis services SSAS
• Performed backend testing for Database integrity by executing complex PL/SQL queries for validating the data in the backend database tables
• Experience using query tools for PostGreSQL, MS SQL Server, Oracle, DB2 to validate reports and troubleshoot data quality issues
• Expertise in working in Agile (Scrum), Waterfall, Spiral methodologies
• Involved in using agile management tools like MINGLE,JIRA
• Expertise in subversion control and version control tools like TFS
• Involved in standalone and distributed GUI-based applications and SOA Web Services
• Experienced in executing UNIX shell scripts for monitoring batch jobs
• Involved in testing both .NET and web based components

TECHNICAL SKILLS:

ETL Tools: Pentaho, SSIS, Informatica 6.1, 7.1, 8.1, 8.6.1,9.1,9.5,9.6.1,DVO

Testing Tools: QTP, Mercury Quality Center, ALM Rational Clear Quest, Microsoft Test Manager 2012,Team Foundation Server 2010/2012

Microsoft Office: Office, Word, Excel, Office Timeline, Power Point

BI Tools: Jasper, Cognos, Business Objects 5.0/6.5/XI R3/R2/R1, SSRS, SSAS, Crystal Reports, MDM

Operating Systems: Windows7, Windows XP, Windows NT, Windows 95/98/2000, UNIX

RDBMS: PostGreSQL, Oracle 8.1/9i/10g/11g, PL/SQL, SQL Server 2000/2005/2008/2010/ , Azure, DB2, Siebel, SQL*Plus, SQL*Loader, Rapid SQL,

Scheduling: Autosys, Tidal, Opcon

Programming Languages: .Net,VB,C#

Repository Tools: GitHub

Environment: UNIX, MVS, HP-UX, IBM AIX 4.2/4.3, Novell NetWare, Win 3.x/95/98, NT 4.0, Sun-Ultra, Sun-Spark, MS Visual Studio 2010 Professional, Visual Studio Test Professional 2010, Sun Classic, and SCO

PROFESSIONAL EXPERIENCE:

Confidential, Miami, Fl

Senior ETL Data Quality Analyst

Responsibilities:

• Identifying the business requirements for multiple projects in each release and participated in meetings with SME and Business Analysts.
• Testing different kind of reports data for analytics app of Confidential health care SAAS clients
• Writing advanced SQL scripts to test different report dashboards in data analytics projects
• Performed system testing, regression testing, integration testing and documented results using Quality Center.
• Creating and monitoring Automated jobs using Pentaho tool, validated data between source and target datawarehouse and report the issues to developer
• Running the cubes and testing data for different subject areas of health care providers and clients
• Participated in fact and dimension table implementation in Star Schema model based on requirements.
• Tested various types of cubes or mdm data based on different subject areas such as appointments, encounters and health claims, denials writing mdx queries and views on pentaho tool
• Conducted various management activities by analyzing and verifying test results, providing status reports
• Analyzed and validated different type of data related to claims, remittance requests, patient and appointments
• Expertise in understanding and testing MIPS-Advanced Care Information transitional measures and Eligible Professional measures
• Analyzing the graphs and data generated from the key performance indicators, revenue and practice performances for monthly, daily and yearly data of different clients and matching it against the data source
• Troubleshooting the issues raised by the different clients and responding or creating defects accordingly
• Created check and balance monthly, yearly and daily jobs to validate the data from sources for different DWH facts and dimensions tables
• Identifying duplicate records and invalid orphan keys in the target data warehouse before data gets processed
• Providing reports in excel to the sales and marketing team requested based on business needs

Environment: Pentaho 5.0,PostGreSql9.4,GitHub,Jira,Zephyr,T-SQL,SQL,PL/SQL, Unix,Charles, Opcon Scheduling, Windows7, MS Office, Visio, MS Excel

Confidential, Fl

ETL Data Analyst

Responsibilities:

• Understanding technical specifications and business requirements and translated to test artifacts
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules
• Created weekly status reports and defect tracking dashboard reports to the management team
• Worked on different projects related to gratuity, pricing, promotion and guest operation projects
• Presented DWH testing road map timelines to the management team using Power point office timeline tool
• Used V-lookup and H-lookup in excel in comparing different sets of data extracting from CRM and revenue management data warehouse systems
• Worked with BI team to extract the data generated from Hyperion Tools and analyse the data necessary for performing Regression scenarios and resolve issues in production that impacted business
• Created Test input requirements and prepared the test data for Data Driven testing
• Collected requirements and tested several business reports
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• 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
• Interacting with senior peers or subject matter experts to learn more about the data
• Extensively written test scripts for back-end validations
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Created ETL execution scripts for automating jobs.
• Performed extensive DATA validation using SQL queries and back-end testing
• Tested the different sources such as Flat files, Main Frame Legacy Flat Files to load into the Oracle data warehouse
• Used workflow manager for session management, database connection management and scheduling of jobs.

Environment: Informatica PowerCenter 9.6.1,Toad, Oracle 10g, Quality Center 10.0, T-SQL,SQL,PL/SQL, Unix, Opcon Scheduling, Windows7, MS Office, Visio, MS Project Timeline, MS Visual Studio 2012 Professional, Power point Office Timeline, Visual Studio Test Professional 2012, Microsoft Test Manager, Team Foundation Server, Rational Clear Quest

Confidential, Libertyville, IL

Senior ETL Data Quality Analyst

Responsibilities:

• Involved in writing test strategies, cases and scripts based on functional and business requirements
• Involved proactively working with the Networking and Server teams to resolve testing issues
• Developed technical documentation and giving presentations to diverse types of audiences like technical staff, business users and management.
• Worked on Agile management tools like TFS work bench and enterprise software to track the story and product delivery requirements.
• Translated the functional requirements into technical mapping specifications
• Involved in test planning, writing test cases and defect tracking using Microsoft Test Management tool
• Worked on different projects like Customer Payments, Payment services, Canada Insurance Import/Extract, PTMS, Quick Fund/Net Fund dealer payments and different cloverleaf data warehousing ODS, dimension and fact tables
• Involved in writing SQL queries using RapidSql programming tool which is used across all platforms including Oracle, Microsoft SQL Server, Sybase
• Developed SQL scripts for verification of data at extraction phase to ensure, transformation phase and loading phase of the data to ensure correctness of the data and also verifying the ETL mapping rules
• Involved in preparing test data for negative and positive test cases and executed test cases for data validation, data quality, data completeness, data integrity
• Extensively used Informatica PowerCenter 9.1.1 to load data sourcing from Source to Target databases
• Extensively worked with Informatica - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor
• Created and executed test cases for various user stories using Quality Center/ALM in Test lab
• Expertise in executing Informatica workflows and testing the output based on the requirement criteria
• Involved in data masking and creating data subsets using test data management tools
• Performed data verification, data validation, data quality, data correctness and data transformation on the input data(text files, xml files) before loading into target database
• Extensively used Informatica Power Center 9.5.1 to load data from various sources like flat files and RDBMS tables into Targets like xml files, flat files and RDBMS tables.
• Tested the format of the reports according to the specifications provided and also compared data in the reports with the backend Datamart through SQL and also using excel for data comparison
• Experience in handling data coming from various sources like Relational, XML and flat files
• Tested the service contract for each release and the mode of data that goes through XML
• Worked on Visual studio test case manager to execute test results and post it to the team foundation server
• Worked on web services testing using the service endpoints and based on the passed parameters
• Validated data flow from Source through to FACT tables and Dimension tables using complex queries (left outer Joins, sub queries, etc.)
• Good knowledge on applying rules using Informatica ILM workbench for data masking transformation into targets.
• Involved in end to end testing of the entire process flow starting from source database to target Datamart in the reports with the backend Datamart through SQL and also using excel for data comparison
• Tested the BI reports developed in Business objects after designing the reporting test cases for functional testing and data validation of the developed reports
• Used Master Data Management (MDM) technology, tools to create and maintain consistent and accurate lists of Master data
• Involved in testing the Biz talk applications hitting the web services for validating the data coming from different sources like Relational, XML and flat files
• Used UNIX shell scripts and compared the files in .csv format to make sure the extracted data is correct.
• Coordinated with developers in performance tuning of mappings and sessions.
• Documented dependencies of workflows and load process along with logic in specification documents and test results.
• Wrote complex SQL queries to validate EDW data versus EDM source data including identification of duplicate records and quality of data based on Mapping/Transformation rules.
• Involved in peer review of test cases, Test Pool meetings, Impact analysis and test estimate meetings
• Used Microsoft Test Manager and TFS for defect tracking and reporting

Environment: Oracle SQL\PL-SQL, RapidSql, MySQL Server2008/2010,Windows7, MS Office, Visio, MS Visual Studio 2012 Professional, Visual Studio Test Professional 2012, Microsoft Test Manager, TFS, XML, CSV Files, XML Files, subversion, Informatica Power Center9.5.1,Unix,SOAPUI 5.0,BusinessObjects

Confidential, Oakbrook Terrace, IL

Quality Assurance Analyst

Responsibilities:

• Involved in Working directly with the team of testing specialists on assigned projects.
• Using Agile Project Management tool - MingleBI/TFS to determine the Stories in BI and DI projects respectively and derive the test details
• Preparing and Maintaining the Test strategy, test design, test cases, and traceability for applications under test
• Involved in raising defects, bug tracking and assigning to respective developer
• Responsible for the full life-cycle of the test phase of a project from its kick off until delivery and readiness to be deployed to Production
• Involved in the preparation of Technical design documents, Source to target (S2T) document
• Tested source data for data correctness, data completeness and data integrity
• Worked in various projects like Punch Card, Gift Card, Inventory, Customer Platform Service (CPS), BI/DI data warehouse enhancements
• Perform test task estimation, test execution, Regression testing, Functional testing, cross team integration testing where possible
• Involved in understanding the logic behind the stored procedure and running package from SQL Server Management Studio
• Working with the teams closely to progress the testing toward realistic achievable milestones.
• Involved in scheduling and executing the jobs during integration/functional testing
• Escalate information as deemed necessary and provide regular status reports on the same
• Create and execute manual and automated tests, document testing practices, and communicate results/recommendations to team
• Involved in testing of the ETL solutions developed using SQL Server Integration Services (SSIS) 2005 / 2008 and SQL / T-SQL.
• Develop and maintain the manual and automated test scripts, functions / SQL code
• Actively participate in team processes and use of methodologies, including customized flavors of Agile
• Used data centric testing when validating data between old Datawarehouse and new Datawarehouse enhancements project according to business rules
• Involved in testing on Filezilla and CoreSFTP in transferring flat files from local to remote server
• Involved in helping my team mates in understanding the architecture and testing methodology
• Involved in testing the jobs or package which calls the .dll services
• Develop complex SQL queries using querying tools and SQL/T-SQL and relational database manipulation
• Responsible for testing of business intelligence reporting solutions developed using SQL / T-SQL and Reporting Services SSRS and micro strategy
• Involved in testing data generated from cubes into Datawarehouse tables and reports
• Create test data and maintain the manual and automated test scripts, functions / SQL code
• Effectively communicating with developers and other QA engineers and understand effectively how the business works with the associated data
• Involved in giving presentations and demo to UAT executing test scripts satisfying acceptance criteria.

Environment: SSIS, SSRS, SSAS, TFS, Mingle, MS SQL Server2008/2010, SQL\PL-SQL, Windows7, MS Office, Visio, MS Visual Studio 2010 Professional, Visual Studio Test Professional 2010, XML, CSV Files, XML Files, Filezilla, Putty, CoreSFTP, subversion

Confidential, Dallas, TX

Datawarehouse ETL Analyst

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center
• Involved in testing the metric features and CHASE portal websites related to web services and .NET applications
• Tested mappings with the Design Documents and also performed testing for various sample data
• Involved in the post implementation validation of UNO CHASE and HELOC-MSP to VLS CONVERSION projects
• Worked on creating test cases and executed test scripts based on test strategy and test plans based on ETL mapping document
• Designed and developed UNIX shell scripts as part of the ETL process, automated the process of loading, pulling the data
• Wrote data conversion and data migration scripts for ETL process
• Involved in data centric testing when migrating the data between different environments and validating data according to business rules, domain comparison
• Facilitated meetings with business users, Project Managers, and IT personnel
• Performed system testing, regression testing, integration testing and documented results
• Worked with ETL group and data analysts for understating mappings for dimensions and facts
• Wrote complex SQL queries for data validation to verify the ETL transformations and business Rules
• Responsible for testing packages using ETL to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Involved in preparation of technical specifications and Source to Target mappings
• Wrote complex SQL queries in Oracle using Case Logic, set operators, sub queries, correlated and inline queries
• Involved in testing SSRS and business objects reports
• Used Quality Center to track and report system defects
• Conducted various management activities by analyzing and verifying test results, providing status reports
• Reviewed and tested database modifications as per Physical Data Model
• Validating the load process of ETL to make sure the target tables are populated according to the data mapping provided that satisfies the transformation rules
• Used Microsoft excel and Word to document the test status reports and the test data
• Involved in testing data mapping and conversion in a server based data warehouse
• Involved in converting Informatica code into SQL queries and generating reverse engineered STTS
• Involved in the preparation of Traceability Matrix document

Environment: Informatica8.6.1,Oracle,Quality Center 10.0, MSSQL Server 2005/2008, SQL\PL-SQL, Unix, Putty, SSRS, Windows 2000/XP, MS Office, Visio, XML, CSV Files,.NET, XML Files

Confidential, Jersey City, NJ

ETL QA

Responsibilities:

• Involved in creating source target mappings based on the Technical Design requirements
• Involved in Business analysis and requirements gathering
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements
• Developed ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document
• Tested user interface.Net applications using SQL queries including connection pooling and metric features
• Involved in database testing and various features including functional, globalization, performance, integration and security
• Tested design strategy of the Extract, Transform and Load for various DW tables
• Involved in testing the trading and brokerage applications using QTP
• Tested mappings with the Design Documents and also performed testing for various sample data
• Tested various mappings transformations like Filter, Joiner, Sequence Generator and Aggregator and perform query overrides in Lookup transformation as and when required to improve the performance of the mappings
• Co-ordinate with team members for effective management for all project requirements and responsible for deliverables and receivables during all project phases
• 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
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Extensively used ETL tool for extraction, transformation and loading process using Data stage
• Understanding of ETL jobs like slowly changing dimension, merge, union all and merge join
• Worked with ETL group for understating mappings for dimensions and facts
•  Performed testing for integration and unit testing of standalone and distributed GUI-based applications and SOA Web Services
• Extracted data from various sources like flat files and SQL Server
• Developed UNIX scripts as part of the ETL process
• Validated cube and query data from the reporting system back to the source system
• Used different sources for Input
• Applied appropriate validation rules and created graph parameters to check the validations are correct so that the graph should stop.
• Involved in developing UNIX Korn Shell wrappers to run various dependency graphs
• Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers
• Created different user defined functions for applying appropriate business rules
• Written test cases and completed unit test documentation
• Involved in pager rotation program to support 24 x 7 production support

Environment: Data Stage, JIRA, Unix, DB2,WinSQL, Putty, MSSQL Server 2005 SQL\PL-SQL, Windows 2000/XP, MS Office, Visio, Perl, Shell Scripts, XML, XSD

Confidential, Texas 

Programmer Analyst

Responsibilities:

• Involved in all phases of Software Development Life cycle from software requirements such as Analysis phase to design, Development, Integration, Regression, Functionality and Usability Testing and Maintenance
• Works with operational staff to analyze business requirements, define solutions, write technical specifications and give time estimates or proposed projects
• Develops programming solutions according to technical specifications while adhering to policies and standards for the integrity and safety of our data
• Develop maintainable code and re-useable business components
• Designed Windows forms using Data Grid, Validation, Login Controls, User Controls
• Designed Custom classes for Data Validations
• Used Atalasoft controls for building capture applications, document processing and .Net Imaging
• XML files are created for each document and converting into Tiff and grouped to PDF
• Involved in creating Zip files using PGP Encryption
• Performed testing for integration, functional and unit testing of standalone and distributed GUI-based applications and SOA Web Services
• Extracted data from various sources like flat files and SQL Server
• Worked on SQL Server and have strong skill set in writing SQL queries
• Recommend and implement performance optimizations in existing and new business processes
• Design new systems or enhancements to existing systems, modify, code, debug, test, and document moderately complex application systems
• Determine source data (input), processing requirements (output), output formats, timing and cost estimates.
• Advise users regarding program techniques and design
• Creating the test case and working on the test executions with different no of Service request made by the user
• Reporting the issues to the Automation team in case of any coding issue
• Maintain program libraries, users' manuals, or technical documentation

Environment: .Net framework 3.5, C#, VB.NET, Testing Tools, AtalasoftDotImage, Visual Studio 2008/10, SQL Server 2005/2008,XML,MS Visio, subversions, SSRS

Confidential

DWH tester

• Reviewed and tested database modifications as per Physical Data Model
• Developed SQL queries/Unix Shell Scripts for data validation.
• Conducted Validation and Verification of bug fix.
• Involved in the preparation of Traceability Matrix document
• Design and build efficient SQL queries, analyze query cost comparison, use indexes efficiently
• Work with internal customers to understand requirements for ETL processes for various data structures including data marts, data warehouses, flat files, and OLTP sources.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Written several shell scripts using UNIX Korn shell for file transfers, error log creations and log file cleanup process.
• Reviewed Informatica mappings and test cases before delivering to Client.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Used Toad software for querying oracle
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Used Clear Quest to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.

Environment: Informatica 8.1, Mercury Quality Center, SQL *Loader, Business Objects, Oracle 9i, DB2, TOAD, Citrix