SUMMARY:

• Open for new opportunities to significantly reduce corporate data validation / testing costs while guaranteeing data quality and building strong relationship with stakeholders.
• Over 13 years of experience in Web Analytics , SAS , MDM , CRM , ETL , Reporting , Enterprise Data Warehousing, SAP BW, Data Integration, PeopleSoft data validation, Web services testing and Rest soap API testing with SOAP UI
• Track record of going above call of duty and help out Business Analysts with technical requirement gathering and help out the Data architects with source to target document.
• Proven track record of initiating multimillion dollar Capex initiatives and finishing in time and under budget with emphasis on total data quality
• Ability to lead and supervise data validation team and roll up sleeves and jump in hands on
• Ability to navigate the validation efforts around blocking and complex situation and meet project deadline and deliverables
• Ability to negotiate among cross functional teams and diverse project group
• Hands on basic development skills in Data warehousing tools.
• Experienced in materializing BI testing efforts from conception to implementation for new BI projects and provide Production support post implementation
• Specialized in White Box and Black Box Testing (code level)
• Experienced in testing from the requirement phase to implementation phase of the SDLC
• Strong in data modeling concept like Enterprise Entity and Attribute relationship
• Strong in writing SQL queries for data validation, data quality and data completeness
• Experienced in UNIX environment and Good knowledge of shell scripting
• Ability to work with minimum or no supervision and meet project dead line
• Quick in learning new enterprise environment and enterprise system architecture
• Accurate in estimating testing effort, timeline and cost
• Strong analytical, Problem Solving, troubleshooting and leadership skills

TECHNICAL EXPERTISE:

Testing Methodologies: RUP, Agile, Scrum, XP and Waterfall

Testing Types: Integration, Data migration cross platform, Web Analytics, Data validation, Data profiling, ETL and Report testing

Training: Informatica ETL, SSIS, SSAS SSRS development, Omniture Site Catalyst

Database skills: Oracle 11g, Microsoft SQL server 2012, Teradata, SAS, DB2, Netezza

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Data Quality Analyst/Data Analyst

• Responsible for coordination of call center Production data quality issues and resolutions for customer care team
• Responsible for verifying production call center data from 12 vendors for completeness and accuracy and follow up with them for correction
• Responsible for verifying production data load from staging to reporting database
• Responsible for resolution of production defect queue and quick resolution
• Follow up with end users and update them of defect resolution status
• Responsible for creating adhoc report request with Oracle business intelligence
• Responsible for creating Call Center Management user account and reset password
• Responsible for creating call center agent skills in CMS
• Responsible to resolution of different reporting issues

Confidential, Atlanta, GA

Sr. Data Quality Analyst consultant/BA

• Engaged in data quality initiatives of Omniture Site Catalyst Web Analytic platform conversion project from Web Trend.
• Responsible to requirement gathering and creation of wire frame
• Validated Jason tags, server calls and tested REST API with SOAP UI embedded in 7 Manheim websites including IOS, Android phones and Tablets
• Worked closely data architects and project managers in an Agile environment
• Created business requirements and validate that it is transformed into technical specification document and perform a thorough gap analysis and recommend fixes
• Analyzed different data sources and create data flow document for Data validation
• Validated BI data from multiple consumer facing websites and mobile devices is captured in the “Adobe Cloud” and FTP to Manheim as data warehouse feed
• Validated Employee Management life cycle via Oracle Access Management Server
• Validated Employee Application access via Oracle Identity Management web services
• Strong Knowledge of Oracle fusion middleware server and it’s architecture
• Experienced with Role based application access testing through impersonation

Environment: Java, java script, Webtrend, Omniture Site catalyst, Microsoft BI Stack.

Confidential,  Atlanta,  GA

Sr. Data Quality Analyst/BI/ETL

Role:

• Reviewed and analyzed business requirement and functional requirement doc and make appropriate recommendations if applicable
• Responsible for analyzing the technical specification doc, data model and prepare the test strategy, test plan, test cases and test scripts.
• Responsible for estimating the QA work efforts and the respective timeline
• Provided QA expertise throughout the SDLC from initiation to implementation
• Validated Jason Tags, server calls and Rest API with SOAP UI embedded in website
• Worked closely with ETL Lead, DBA, BI BA and Project Manager on project deliverables
• Responsible for testing the accuracy of the web analytics piece of the BI application
• Checked for accuracy of many data feeds and Soap feed extracted to and from the EDW database
• Verified web strings in the Apache web log are parsed and loaded in the staging tables
• Responsible for data profiling of the source stage tables and make sure they conform to the acceptable company standard
• Developed complex SQL mimicking the actual Informatica ETL mapping to test the ETL transformation rules and the data load into the target fact tables in different databases
• Tuned test SQL to optimize the performance on a billion rows table
• Tested the financial revenue share report derived from the Fact tables of the EDW
• Responsible for integration testing of many internal CRM applications
• Tested multiple reports developed with Micro - Strategy and SAS
• Performed post production regression testing after deployment
• Responsible for first line of defense on all production ETL and reporting issues
• Worked closely with the ETL developers, Report developers and DBAs during code migration to QA and Production from Development Environment

Environment: J2EE/Java, Apache web server, Oracle, Microsoft BI stack, Netezza, Sun UNIX, Informatica, and Micro strategy, SAS, Open source reporting server.

Confidential, Atlanta, GA

Lead ETL QA / Reporting Analyst

• Followed Q4M methodologies and processes in all levels of SDLC
• Analyzed and review System, Functional, Technical Requirement Documentations
• Created test strategy document based on analysis of System Requirement Document
• Created test plan, test cases and test scripts based on the System Requirement
• Tested the data extracted from mainframe and loaded in the Teradata EDW with BTEQ
• Tested conversion and consolidation of data within multiple divisions of Confidential ’s EDW
• Tested 50 + different Merchandising reports extracted from Enterprise Data Warehouse with Business Object and Cognos
• Created UAT test cases and scripts for the project stake holders
• Wrote complex SQL queries to validate data in different system
• Navigated different CICS screen to validate data as a source
• Tested integration between multiple system and validated the data flow
• Participated in daily bug meeting with the development lead and resolve testing issues

Environment: Mainframe, Teradata, DB2, Oracle, Business Object, Cognos and Windows

Confidential, Bakersfield, CA

SR ETL QA Analyst

• Worked closely with the Microsoft Services Consulting development team
• Followed Agile/scrum development methodology without any formal documentations
• Tested the Web Report Portal MINERVA based on the business logic and business rules
• Performed data profiling on the source databases to check for data inconsistencies
• Imported different source data with link server into the testing environment for testing
• Executed very complex SQL queries to validate and verify data set per business rules
• Verified the ETL load of Microsoft SQL server SISS Packages from different data sources and made sure it is loaded in the Minerva Cube as per the business logic
• Verified that the data extracted from the Minerva Cube with Microsoft Analysis Service are displayed accurately in the reporting web portal
• Tested corporate web portal developed with C sharp and Microsoft dot net
• Open defects and track resolution on Microsoft Team Foundation Server
• Discussed project progress and issues in the daily scrum meeting with the development team, program manager, scrum master
• Responsible for testing different out going extract files created in XML for different corporate ERP applications

Environment: Microsoft SQL Server 2005, MSDN, Microsoft Integration Services and Microsoft Analysis services, Oracle, Dot net, XML, C sharp and UNIX

Confidential, Alpharetta, GA

Lead ETL QA Analyst 

• Worked closely with the Deloitte consulting team
• Prepared test strategy, test plan and test scripts based on the design documents
• Tested interfaces of Apple Computer with Cingular Business Intelligence database
• Tested the revenue sharing joint venture application of Apple computer and AT&T
• Performed data profiling in the source databases and checked for data anomalies
• Performed data analysis based on the business logic in business Intelligence database coming from the various front end ERP applications through Informatica mappings
• Tested Extract files, extracted from Business Intelligence Database for other ERP front end and back end applications
• Created database object model with MS Visio to track data movement in the ERP apps
• Executed complex SQL queries based on the business logic and validated target database and Extract files
• Tested Business Object reports generated from business intelligence database
• Opened bugs in Mercury Quality center
• Participated in the bug report meetings and updated test lead with resolution

Environment: Teradata, UNIX, informatica, Oracle, Telegance, Care, Amdocs and XML

Confidential,  Atlanta,GA

Callidus / ETL QA Analyst

• Tested 3rd party Callidus Sales Incentive Compensation Application for the Confidential Human Resource Department
• Prepared test strategy, test plan and test scripts based on the Work Requests and Design Documents and Detail Design Documents
• Walked through the user acceptance test results with the business
• Responsible for Level 2 production support for production issues
• Tested incoming data feed from different data marts including HR’s People Soft and Siebel CRM
• Confirmed that data is parsed, transformed and loaded per business logic in the Oracle data warehouse through the Informatica mappings
• Tested the accuracy of custom reports generated by the Actuate report server
• Tested the out going payout file sent to the human resource dept.
• Opened up bugs with Mercury Quality center

Environment: Oracle, Teradata, UNIX Sun Solaris, Informatica, People Soft, Siebel, Brio, Actuate Server, Java, Callidus True Comp

Confidential,  Alpharetta, GA

Lead ETL QA Analyst

• Developed Test Strategy from Use Cases, Requirement Documents and Software Specification Documents.
• Created Test Plan, Test Cases and Test Scripts in Rational Test Manager
• Install and Configured Oracle client, Toad, Win-SCP, Ultra Edit and Rumba in all QA environment
• Test incoming EBCIDIC nightly batch Files from TSYS TS2 platform and certify that they were loaded in ESC Loyalty’s Oracle Platform via the ESC-Loyalty’s credit card Reward engine
• Test real time Data packets coming from TSYS TS2 platform in XML format, per XSD and make sure they get loaded in the ESC Loyalty Oracle platform via the ESC-Loyalty’s Credit Reward Engine
• Test nightly outgoing Reward files to TSYS TS2 platform in EBCIDIC format
• Test Program configuration of the ESC-Loyalty’s Java based Reward Engine
• Test initial conversion account load and historic transaction load via ETL from TSYS TS2 Platform
• Test the cron jobs and see it they are running according to the schedule
• Test account activity history report created by IBM Hyperion application
• Work as a client UAT and production support
• Helped other junior analysts with directions

Environment: CICS mainframe, Oracle, Informatica, Teradata, Solaris, Windows XP, Java, Jboss, XSD, XML

Confidential,  Atlanta,  GA

Lead ETL/Integration Tester

• Wrote Test Plan, Test Cases and developed Test Strategy based on the FSD and Use Cases
• Wrote complex SQL queries to validate the Informatica ETL load in Oracle Database
• Wrote DML script to create test conditions in the Database
• Tested the Tidal job scheduler to verify if the job scheduler ran as scheduled in Unix environment
• Tested file transfers with the FDR (Credit Card Clearing house), TSYS, Equifax, and Certegy
• Tested loan funding process with ACH processor
• Tested Business Object reports
• Tested User Interface on Java based company website
• Updated project related documents in VSS and CVS
• Reported bugs in Compu Ware Track Record
• Coordinated project meetings if showstoppers ware detected
• Participated in Technical team meetings in all development life cycle from requirement gathering to QA sign off.
• Helped other analysts with technical questions and solutions

Environment: Oracle, SQL-Server, FDR (CICS Mainframe), Informatica, Unix, Windows XP, Mainframe, Business Object, Java, Dot Net and C sharp, XML

Confidential

ETL QA Analyst

• Worked along with EDW team to create test scripts for validating data loaded
• Executed, tracked and worked with QA to mitigate testing
• Executed test scripts according to the test plan and document all test results
• Participated in review meetings to discuss test script and test results
• Used SQL queries to check the Oracle database and automated the trade’s history data
• Validated data at each transformation throughout the ETL process. Documented consistent error patterns. Tested different transformations created by using Informatica

Environment: ETL Informatica Powercenter 6.1, Business Objects 6.5, PL/SQL, Oracle8i, Solaris 7, Windows NT, Test Director 7.0, Toad.