SUMMARY:

• Over 12 years of excellent work experience in Data warehouse systems as a resource of QA and Developer .
• Over 5 years of Testing experience using Sql Server 2008, Hadoop (HDFS, HIVE, Mongo DB), OBIEE 11g and Informatica 9.1.
• Over 7 years of excellent work experience as SQL Developer, SSIS & DBA on Data warehouse applications using Sql server 2000/2005/2008 .
• Independently developed scalable and reusable processes of regression automation frameworks using SSIS, Informatica and Query Surge.
• Strong Experience on designing and developing Automation Regression suites for ETL.
• Experience in Advance Test Driven Development (Providing Unit Test Cases before code migration to QA) and Strong experience in handling the large projects and leading small QA team.
• Excellent work experience with, writing SQL queries, Store Procedures and Triggers performance tuning with the queries and tuning the database with major Relational Databases MS SQL Server 2000/2005/2008 , Oracle, and DB2.
• Had good experience in developing Data Warehousing application using MSBI technologies and good knowledge on star schema design.
• Excellent experience as ETL Tester and developer and had experience in ETL tools like DTS/SSIS/Informatica.
• Proficient in designing and developing Test scripts using Sql for Automation regression testing.
• Strong on experience in Hadoop Testing using HIVE queries, Python and Mongo DB Sql.
• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/2005.
• Agile Development: Understand and practice QA functions in an agile development cycle using Scrum process. Conduct early project scoping and collaborate with cross - functional teams in identifying testability goals across n-tier platforms.
• Testing Optimization of procedures including Execution Plans, Statistics, and SQL Server Profiler. Performance tuning that includes Indexes, applying the tuning techniques to increase the performance.

TECHINICAL PROFICIENCY:

Languages: VB,ASP,C

Technologies: Data warehousing in SQL & Oracle, OBIEE, HADOOP

Tools: DTS,SSIS Informatica, Micro strategy

Operating Systems: Windows NT4, Windows XP

Databases: SQL Server 2000/2005/2008

Domain Knowledge: Real Estate, Gaming, Banking sector, Tour operating sales on Airlines industry,Policy and claim management in Insurance sector.

PROFESSIONAL EXPERIENCE:

Confidential

Technology: Oracle 12c, Informatica Power Center 9.6.0, SQL Developer/ Toad

Lead QA Consultant

Responsibilities:

• Understanding and validating customer Master & Counter Party data to meet various regulatory reporting requirements.
• Validating functionality to meet Confidential . Confidential requirements (in addition to European Union, 5G, and Matisse Confidential requirements) for Confidential and Confidential .
• Developed automated regression scripts for (Data Quality and Health Checks) using PL/Sql for Customer Master and Counterparty.
• Validating rules to populate and identify unique customer across multiple source systems.
• Developed Test plan & Test strategies to address any data quality issues with well-defined control points.
• Validated APPIAN BPM tool for splitting and merging Customers in TRN BCDM Confidential data.
• Have worked closely with the Requirement Analyst, development team, and right from Sprint planning that helped in capturing design & requirement issues earlier in the life cycle.
• Experience in Advanced Test Driven Development.
• Developed customized scripts for validating Transformation of data loads from STG, DATASTORE, to ODS and EDR for multiple source systems.

Confidential

Technology: Sql Server 2008, SSRS, SSIS. Oracle 11g, Informatica Power Center 8.6.1, SQL Developer/ Toad, Hadoop, HIVE, Python, MongoDB, Micro strategy, OBIEE.

BI-QA Lead

Responsibilities:

• Confidential for QA Informatica Cloud environment for all deployment’s and Testing. As part of Informatica cloud POC, involved with dev team and Installed & configured Informatica cloud for QA environment.
• Work closely with the developers and Business Analysts, formulating test plans, preparing test cases, executing the test scripts and fully documenting and reporting the results
• Automated the Validation of data integrity at various levels of Enterprise Data Warehouse starting from the source data system through the end user reports.
• Validating Instrumentation data from Confidential and its various websites using HADOOP (HDFS, HIVE, MongoDB, Fiddler, Ruby,Python,and Query surge). I have automated this process using SSIS package to speed up the validation process.
• Need to make sure that Daily Data load completes on QA servers for our Data warehouse system without any failure.
• Working as Lead QA by coordinating QA team members at onsite and offshore for all test cases and reviewing of test plan, and responsible for all QA & Production releases.
• Successfully handling all major projects like Leapfrog, Renov8 by leading the team and providing necessary environment for specific test cases for instrumentation.
• Weekly Interacting with Development team and Manager to build scope for automation frameworks and communicate proactively on the issues reported.
• Review test cases for team members and driving them to create regression suits for specific requirements for EDW system.
• Own and execute OBIEE QA deployments (Informatica changes, Oracle database changes, DAC patches, Catalogue & RPD changes) and creating deployment document for QA & Production.
• In OBIEE, Automated Agent Finance Commission, broker Finance Commission and Management Summary Detail reports validation using PL/SQL.
• Manage and executes QA test cases for highly visible projects independently and SME for QA Automation and execution process.

Confidential, Santa clara, CA

Technology: Sql Server 2005,SSRS and SSIS. Oracle 11g, Informatica Power Center 8.6.1

ETL Developer

Responsibilities:

• Migrated all facts and dimensions from Sql server 2005 to Oracle 11g using Informatica power center 8.6.1
• Developed Informatica mappings and transformations from Sql server 2005 to Oracle 11g.
• Migrated existing Akamai, BestBuy and Prodea business process from SSIS to Informatica.
• Involved in deploying Informatica objects from Dev to Qa and Qa to Production.
• Created parameter file to read and write for the purpose of incremental load.
• Created custom properties on Informatica server to load write bulk data.

Confidential

Technology: Sql Server 2000/2005,SSRS and SSIS, Crystal Reports, Business Objects.

Lab Systems Engineer

Responsibilities:

• Restore the databases in sql server 2000 which gets from Casino, I’ll install the clients and check for the open dates in database/application. If open dates found we sent the drive back to the casino and audit those dates and again receive fresh backup.
• We check the existing versions of the database and project manager send the VTO software to which version to upgrade the database.
• I will make the checklist and scripts used while upgrading the databases, the installer might be failed due to culprit data or schema errors.
• We write a pre scripts to run the installer successfully.
• Comparing the pre reports and post reports after the upgrade, if required I will right post script to match from pre to post.
• After providing the checklist to the field team, providing go live support.

Confidential

Technology: Sql Server 2000, MS-DTS, Analysis services, ASP

Production Support

Responsibilities:

• Maintaining Confidential DW production servers. Making sure all the packages run successfully and monthly backup. Checking pre-source a/c?s balance and post-source a/c balance.
• Creating detailed specification and impact analysis for new enhancements
• Implementing change requests as per the client requirements.
• Creating Adhoc reports based on client requirement.
• Working with off-shore in development for phase2.
• Troubleshooting DTS packages, stored procedures

Confidential

Technology: Sql Server,MS-DTS, SAND Analytical Server, Brio Intelligence, ndl script, awk script Roles:

Production support

Responsibilities:

• Making sure the batch work (daily data load) is successful.
• Ensuring that we have a successful backup of the whole Datawarehouse system. (System state, SQL and SAND Nucleus databases)
• Developing and implementing Data Warehouse solutions (via meetings with client, fact finders etc
• Generating Sales report Using Brio.
• Creating detailed technical specifications for development work and discussing with the management and the client.
• Dealing with user queries via iheat, infra, telephone, email, face to face

Confidential

Technology: MS-Sql 2000 DTS, Cognos ReportNet, MS SQL Server2000, T-Sql Sol.

Responsibilities:

• Identifying dimension attributes & Fact measures. Investigating PL/Sql source code for calculating earned premium, claim amount.
• Taking care of unique records while initial load in transformation and cleansing routines phase.
• Creating mapping documents for transformations for DTS.
• Capturing error records in DTS by using global variables & ADO connections in pre completion task.
• Creating cubes. The schema contains two cubes one is Sales Cubes & Claims Cubes.