SUMMARY

• 8 years of IT experience in Analysis, Design, development, testing and Implementation of ETL & Business Intelligence solutions using DWH, ETL, OLAP, Client/Server applications in different domains Banking, Insurance and Payments.
• Experienced in RDBMS technologies like Oracle 8.x/9.x/10g, DB 2 8.0/7.0/6.0 , MS SQL Server 2005, Excel and MYSQL.
• Involved in every aspect of SDLC and extensively followed AGILE and WATER FALL methodologies.
• Excellent experience in developing Business Intelligence Applications using Business Objects and Crystal Reports.
• Experienced in Functional testing,testing Lifecycle,testing execution,testing Techniques,test architecture.
• Extensive knowledge in Dataware housing concepts as well as Dimmensional modelling concepts like star and snow flake schemas.
• Automated and scheduled the ETL jobs using UNIX Shell Scripting, AutoSys and ESP
• Excellent understanding and expertise in writing complex SQL (DDL,DML and DCL)queries to perform back - end testing.
• Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Abinitio.
• Worked with many ETL tools like Informatica Power Center 7.1.3/8.2/8.6.1/9. x, Ab Initio.
• Have solid experience on database query tools such as TOAD, SQL Navigator, Teradata SQL Assistant, Rapid SQL, and SQL Plus, ESB, SOAPUI.
• Experiecnced in testing of XML files using Xpath and Xquery,also involved in API testing using XQuery.
• Expertise in Testing complex Business rules by creating mapping and various transformations using Informatica.
• Experienced in testing Enterprise wide apps resided on multiple databases like ORACLE, DB2, and MS ACCESS
• Experienced in conductiong walkthrough meetings with the Business Leaders, Analysts, SMEs and DEV team to get a clear uanderstanding of the business and the applications being used in house.
• Experienced in business requirements analysis, reviewing test Plans & preparation of test Cases
• Experienced in working with HP Quality Center/ALM 11.0,CLM, JIRA and Rational Requisite Pro and Clear Quest for Test Management and defect tracking.
• Extensive experience in manual testing and written VB scripts to test the ETL, UI, API and Business Intelligence Applications.

TECHNICAL SKILLS

ETL Tools: Informatica 9.x/8.x, Abinitio3X, Data Stage 7.5,SSIS

Testing Tools: ALM11.0,Quality Center, Load Runner, QTP, Win Runner, JIRA, SoapUI,IBM Clear Quest

Database: Oracle 8i/9i/10g, SQL Server 2005, MySQL, DB2, TOAD 8.5, MS Access,Teradata V2R5/V2R6

Reporting Tools: Business Objects 5.1/XIR2, Cognos 8.0, Crystal Reports, Micro strategy

Operating Systems: Window 2003 Server, Windows 98, Windows XP, Linux and UNIX(AIX).

Version control: Visual Source safe, WINCVS,PVC

Languages: HTML, XML,PL/SQL, VB 6.0, VB script, Java, Visual C++

Scheduling tools: AutoSys, ESP, Control-M, Oozie

Hadoop ecosystem: Pig, sqoop, Zookeeper, Solr, Hive

PROFESSIONAL EXPERIENCE

Confidential, CA

Test lead/IT QA Analyst

Responsibilities:

• Participated in knowledge transfer/ Issue Resolution sessions with Business, Dev leads
• Provide technical expertise, while deciding the tools, techniques and processes
• Provide guidance for Test Planning and Test Execution along with defect root cause Analysis and reporting
• Build and execute data masking algorithms to ensure data privacy in reference data
• Identifying the test Cases that can be automated and lead the effort for automating the product.
• Extensivley used UNIX environment to mock the data files,and execute ETL mappings from the backend
• Performed Report Testing using OBIEE by writing SQL queries to validate the data on the report and compare with the DWH data.
• Created various stored procedures for dropping and recreating indexes /referential integrity’s on target tables during test phases to make loads fast.
• Involved in preparing test data/ Test script for UAT and participated in UAT signoff
• Written VB scripts for creating the Data scenarios using QTP
• Performed white box testing on various ETL graphs and made sure the functionality is working as expected and communicated the findings if any Via DEV-QA work shops
• Executing data refresh routines, on need basis, prepare and share periodic status reports
• Overall monitoring of the testing progress, reporting test results and defects detected

Environment: ALM/HP Quality Center 11, Informatica Power Center 9.1/8.6, SQL, Xquery, Xpath,Teradata utilities,TOAD 8.0, UNIX, XML, Oracle 10g

Confidential - Foster City, CA

Sr. Level Quality Assurance Analyst

Responsibilities:

• Document steps of existing, internal analysis process and propose more efficient, effective tools and applications.
• Developed and Designed Test Cases based on the Business Rules and Mapping Documents.
• Validated the source data coming from various databases like oracle, db2 etc using complex SQL queries.
• Aggregated the data at source and compared with the Target to validate Transformations.
• Testing XML files sent by Acquirers to make sure the File gets loaded/rejected at the appropriate situations.
• Testing internal file transfer apllications, also tested Web Services graphs using Soap UI
• Utilized Trillium for Address Enrichment/Geo coding of Merchants, that resides in the Data repository.
• Validated the data being successfully transformed from XML/Pipe - Delimited/.dat files are being loaded into the testing area as expected .
• Tested the reports like Drilldown, Drill Up and Pivot reports generated from OBIEE
• Attended daily status call with Offshore/Onshore leads to review assigned tasks and solve any impediments.
• Written Test Results and Test finding documents once the QA life cycle has been completed
• Documented and reported various bugs during the Testing process.
• Updating status of the testing to QA managers and updating assigned work status to the Project Management team regularly thru aplications like JIRA.

Environment: OBIEE, Ab-initio,DB2, Toad for DB2 4.0,Trillium Software,SQL developer, ALM 11.0,IBM Rational Clear quest, SQL, UNIX, ALM 11.0,Micro strategy9.3, JIRA

Confidential - Bloomington, IL

Quality Analyst

Responsibilities:

• Involved in complete project software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC)
• Performed Integration Testing of different modules, tested User Interface inconsistency and application functionality
• Analyzed Business Requirements and Developed the Test Plan, Test Scripts and Test Cases
• Running test scripts, logging and tracking defects using Quality Center.
• Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.
• Generate complex reports using Cognos application.
• Preparation of test data for various levels of testing, Loading new or modified data into back-end SQL server database.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Cognos Analysis Studio

Environment: ETL, SQL Server Integration Services, Quality Center 9.0, DB2, SQL Server Import Export Wizard, Cognos Series 7.0, Oracle10g, C#, SQL Server 2005, Erwin 7.1, Windows XP, TOAD for Oracle.

Confidential - Caledonia MI

QA Analyst

Responsibilities:

• Involved in identifying data from BRD to Develop LDM, PDM by studying Data Flow diagrams and State Transition Diagrams.
• Used MS Visio to develop and desing test databases, involved in creation of test tables, writing stored procedures and Triggers.
• Extensively involved in developing data dictionarires also created test tables and various database objects.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Involved in performing validation of datasets, tables and triggers by performing White Box Testing and code walk-through.
• Performed Data Profiling to improve search abilities by using tags and aliases.
• Developed test reports and participated in testing prioritization and archived test results and user signoff
• Performed execution of test cases manually to verify the expected results.
• Developed user interface screens using VB, ADO to connect to backend and stored procedures to manipulate data.
• Involved in testing, implementation & maintenance.

Environment: MS Visio, Crystal Reports 9.0, Metadata Repository, Visual Basic 6.0, SQL Server 2000, SQL, T-SQL, UNIX and Windows NT.