SUMMARY:

• Software professional with 10+ years of IT experience and works primarily in Business Intelligence, Data warehouse ETL Development and Testing.
• Working extensively in Development & testing of BI Data warehouses, Acquisition, Integration, and Distribution of data, reporting of data using MSRA, OLAP Cubes, and ETL processing through Informatica and MS Batch jobs system, Metal systems.
• Experience in Writing Complex T - SQL Queries, Dynamic-queries, sub-queries, Complex joins, heavy stored procedures, Triggers and Functions.
• Experience in SQL Server Installation, Configuration, Performance Tuning & Monitoring.
• Working Experience on Agile Software Development model.
• Well exposed to Agile Sprint cycle includes Userstory review, Story points estimation, Active Participation in Backlog Refinement sessions & Sprint planning meetings, Giving Userstory Demo, One box env preparation and Using it for Active Sprints.
• Working Experience with Operations team to trouble shoot live prod issues and providing resolutions.
• Well exposed to all stages of Software Development, Testing, Defect Life Cycle.
• Good exposure in working on Requirements analysis, Data Analysis, Effort estimation, Techspec/test plan preparation, Coding, creating & executing test scripts, Automation of test cases, and preparing Project status reports.
• Good Domain and working Experience on Confidential MSSales and MSCloud projects.
• Extensive Working experience on Functional, Data warehouse & ETL testing, Unit testing, System Integration, Regression, Reports testing, GUI, Installation testing, Backend testing and Ad-hoc testing.
• Extensive experience in debugging, analysis and timely resolution of Prod/UAT issues which involves the functional, data issues, SQL server issues.
• Working extensively on the SQL server 2016/2014/2012 database design and development within a high volume, transaction-oriented environments.
• Good technical knowledge in MS SQL Server development including Integration Services, Confidential Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Good SQL Server Administration skills including backup recovery, database maintenance, Database creation, Tables, indexes.
• Experienced in implementing the business rules by creating transformations
• Experience in using the SQL Server Agent for scheduling jobs and alerts.
• Extensive knowledge of SQL, T SQL programming.
• Good exposure in projects with the Onsite - Offshore model.
• Data modeling experience using Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Good exposure to Big Data Concepts.
• Experience working on tools such as MTM, MS VSTF, Informatica ETL tool, MS Release Manager, MSBatch, Rally, Quality Center, QTP, Rational Test Manager, Rational Clear Quest, Rational Clear Case.
• Experience working on varied domain applications such as Confidential Finance Business Intelligence Data warehousing applications, Confidential oracle based order processing applications, Citigroup Chordiant based Credit cards CSR web applications, Beltone Hearing Aids product based fitting software applications.

TECHNICAL SKILLS:

Database:  MS SQL Server 2016/2014/2012/2008, Oracle

Operating Systems:  Windows 2008/2003/2000 Server, Windows NT 5.0 /4.0, Windows XP/Vista/2000/2003

Programming Languages:  SQL, TSQL, C, Java

ETL Tools:  Informatica (Power Center 8.x,9.x), SSIS

Data modeling tools:  Erwin

Database Tools:  VSTF, OLAP Services, SSRS, TOAD, Visio, Octopus, MSRA, SQL Profiler, SQL Query Analyzer, MSBatch, Release Manager

Test Tools:  MS Test Manager(MTM), Rally, Quality Center, QTP(Automation), Rational Test Manager, Rational Clear Quest, Rational Clear Case, Rational Manual Tester Knowledge on Big Data Technologies like Hadoop, Spark, Scala

PROFESSIONAL EXPERIENCE:

Confidential, Redmond

Software Development & Test Engineer

Responsibilities:

• Userstory review, Story points estimation, Active Participation in Backlog Refinement sessions & Sprint planning meetings, Giving Userstory Demo, One box env preparation and Using it for Active Sprints.
• Created complex stored procedures in order to process the huge amounts of data with given business rules.
• Worked on Extensive performance tuning of the warehouse processing in order to meet the SLA times.
• Worked on major initial Dual reporting phases to create complete new set of system(jobs) for NRS process.
• Worked on new sql server release functional/performance impacts for MSSales systems.
• Analysis of business and Functional requirements, and created system requirements and data mapping requirement specifications
• Analysis/Review of existing system and code and identify the portions that needs changes and create a design based on requirements.
• Responsible for Creating Design/Techspec, Test Plan/Test Cases.
• Responsible for Developing, testing and reviewing of ETL mapping and transformation specifications based on the business requirements from the business teams
• Developing/Testing of ETL Processes, PL/SQL procedures for complex business logic/rules
• Responsible for developing advanced SQL/T-SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements
• Tested various Reusable ETL Transformations which facilitate Daily, Weekly, Monthly, Future & Restatement Loading of Data
• Executed Functional testing, data validation, data reconciliation with defect correction, regression testing and involved in manual, web testing, automation and performance testing
• Conducted Unit Testing, Functional testing, Regression testing, System Integration testing, ETL Testing, Automation Testing and Data Validation Testing
• Performed OLAP Cubes testing, MSRA reports testing
• Automation test scripts preparation and execution using VSTS 2015
• Work on trouble shooting issues and able to identify problems in applications and advocate for solutions, work with project team
• Responsible for individual ownership of requirements throughout the life cycle of the project
• Techspec/Test Plan review with all project stakeholders, Coordinating with PM/SD/Biz teams for Issue resolution for requirements
• Test Execution, Defects tracking, Test Results Reporting
• Build preparation, Dev/Test environments preparation, Build deployments, UAT/Prod issues analysis/resolution
• Worked with Product teams on major sql server versions performance issues for resolutions.

Environment: MS SQL server 2016/2014/2012 , Visual Studio 2015/2010/2008 , V STF 2015, MTM, SSMS, SSAS, SSIS, MSRA, OLAP Cubes, MSBatch 3.0, Release Manager

Confidential, Redmond

Technical Dev & Test Lead

Responsibilities:

• Understanding business and functional requirements
• Development, Testing and reviewing of ETL mappings and transformation specifications
• Tested Informatica mappings which have ETL transformation logic
• Development & Testing execution of ETL Processes, PL/SQL procedures, packages for complex business logic/rules
• Conducted Unit testing, Smoke testing, Functional testing, Regression testing, Integration testing, ETL Testing, and Data Validation Testing
• Performed MSRA reports testing
• Tested the performance bottle necks at sources, targets, mappings, and sessions
• Test Plan and test case preparation & review with all project stakeholders
• Test Execution, Defects tracking, Test Results Reporting
• Test environment preparation, Build deployments, UAT/Prod issues analysis/resolution
• Automation test scripts preparation and execution using VSTS 2012
• Handling offshore team by assigning the requirements & Issue clarification & Coordination with client for offshore deliverables
• Handling Onsite-Offshore team meetings
• Ownership of complex components/modules in the project such as Seller source system, BIPublisher etc.

Environment: Visual studio, .Net, SQL server, Informatica, VSTF 2012, MTM, SSMS, SSIS, MSRA, Informatica

Confidential, San Jose

Test Analyst

Responsibilities:

• Understanding business and functional requirements
• Test Plan preparation, Test case preparation and execution
• Test data preparation and conditioning
• Performing Functional, system testing, Regression testing, Backend testing and Oracle applications testing
• Review of Test cases and given test case walkthrough with the client
• Trace and classify the issues and tracking for timely resolution
• Clarifying the issues by interacting with the client
• Preparing the Defect report and Test results report and report it to the clients

Environment: Windows-OS, JAVA/J2EE, Web Services, Wrapper API, Oracle database, Oracle R11 or R12 ERP applications, TOAD, Rally.

Test Ware:Rally, TOAD, Oracle R11 or R12 ERP applications, Confidential IWE.

Confidential, San Jose

Test Analyst

Responsibilities:

• Understanding business and functional requirements
• Test case preparation and execution
• Test data preparation and conditioning
• Performing Functional, GUI, Backend, system testing, Regression testing
• Review of Test cases
• Trace and classify the issues and tracking for timely resolution
• Clarifying the issues by interacting with the client
• Onsite/offshore coordination activities
• Cross functional coordination activities.
• Development of tools to validate order processing system.

Environment: Windows-OS, JAVA/J2EE, TIBCO, Oracle database, Oracle 11i ERP, TOAD

Test Ware: HP Quality Center, TOAD, Confidential Live link and EDM.

BELTONE, Chicago

Test Engineer

Responsibilities:

• Analyzing the requirements and change requests
• Developed Test Cases and Test Scripts
• Participated in test scripts walkthroughs
• Conducted both Manual Testing and Automated Testing
• Performed Functional and Regression Testing of the Application
• Preparing the bug report and report it to the clients
• Interaction with client for Requirements clarifications and Defect tracking
• Participated in Bug Review Meetings
• Performed Backward Compatibility testing, Product testing
• Forecasting the key areas where we can expect maximum defects
• Performed Automation of test cases using QTP tool.

Environment: VC, NOAH2 and NOAH3, Windows XP/98/2000/Vista.

Test Ware: MS-Office, HP Quick Test Professional.

Confidential , Jacksonville

Test Engineer

Responsibilities:

• Analyzing usecase requirements.
• Preparing Test Scripts using Rational Manual Tester.
• Implementing Test Scripts using Rational Test Manager.
• Preparing Test Conditions for the Test Scripts.
• Test Assets Repository using Rational Clear Case.
• Preparing Test Bed Pull and Data Entry Requirements to execute the scripts.
• Test Data conditioning
• Performing Functional, GUI, System Integration, Regression, Shakedown and Ad-hoc testing
• Defect Reporting and Tracking using Rational Clear Quest.
• Extensively performed Manual Testing.
• Updating the deliverables based on the Project Change Requests (PCR’s).
• Preparing Self Check lists for Deliverables
• Interaction with Onsite team for clarifications on usecase requirements
• Interaction with client for Defect tracking
• Involved in Automation Testing using HP Quick Test Professional
• Coordinating Onsite - Offshore team meetings
• Coordinating the installation activities of the project related software’s to implement in all the machines
• Coordinating the key work activities of the project for timely completion by the team
• Writing Test scripts, Executing Test scripts and Defect tracking using HP Quality Center (HP Mercury Tool)

Environment: Java/J2EE (Chordiant Application), TIBCO, Mainframes, Oracle.

Test Ware: IBM- Rational Manual Tester, Test Manager, Clear Quest, Clear Case, Functional Tester, HP Quality Center and HP Quick Test Professional.