PROFILE SUMMARY:

** +years of experience in ETL Testing, Datawarehousing, Oracle PL/SQL,UNIX,Workday and PRO*C Technologies, Experience in IT industry in various roles, has proficiency in development, implementation, enhancement, support & testing of Oracle for several markets driven international organizations.

Experienced in all phases of the software development life-cycle (SDLC) with specific focus on the Develop, Test, support, build and release of quality software. Experienced in Waterfall, Agile/Scrum.

Hands on experience in Testing Extract, Transform and Load (ETL) within a complex enterprise

data warehouse environment in support of government financial users and analytical applications for Client/Server, Web applications and Middleware Applications.

Experience in functional domain knowledge of Mortgage, Asset Management, Banking & Finance, Telecom and Retail.

Experienced in testing Enterprise-wide apps resided on multiple databases like ORACLE, DB2, SQL SERVER Experienced in conducting walkthrough meetings with the Business Leaders, Analysts, SMEs and DEV team to get a clear understanding of the business and the applications being used

Experienced in Functional Testing, testing Lifecycle, Test execution, Testing Techniques, Test architecture

Testing, Maintenance and Augmentation for various applications in Data warehousing, metadata repositories, data migration for performing Front-end GUI and BI testing/System Integration Testing.

Experience in ETL Tools Informatica for Database Testing and UNIX Automated and scheduled runs the ETL jobs using UNIX Shell, Autosys.

Extensive experience in writing SQL to validate the database systems and for backend database testing.

Experienced in testing of XML files using Xpath and Query, also involved in API testing using SOAPUI and Expertise in Testing Complex Business rules by creating various transformations using Informatica

Experienced in working with HP Quality Center/ALM 11.0, JIRA, Service now, Clear Quest for Test Management and defect tracking.

Experienced in RDBMS technologies like Oracle,DB2, MS SQL,Excel,SQL Server.

Development of Re-usable objects like General Procedures, Functions, Packages, Triggers and various PLSQL validations.

Create database objects such as tables, views, synonyms, indexes, sequences as well as custom packages tailored to business requirements and writing in database level Procedures and Functions and programming using Oracle, UNIX, PRO*C, Pl/SQL.

Run the Workday integration and load the data into PRISM Tables.

Validate the data in the cloud DB Redshift and validate the counts between redshift in Dbeaver and Integration database.

Develop the tune the queries using Hints/performance techniques for validation in performance environment and ensure the data correctness.

Proficiency in Support Tools like Remedy User, Control-M,Reflection-X,Lotus-Notes,Hyperion.

Involved in Production support and Analysis and issue resolution for various user related queries and production tickets management

Compare the data between source and Target systems by using Alteryx and DTF Tools.

Experience in using version control tools like SVN/GIT Hub/VSS.

Worked on Jenkins for continuous integration and for End-to-End automation for all build and deployments.

Experience in PRO*C Programming.

Develop automation scripts with the use of SOAP web services, fetch data with the use of SQL queries and validations updated in excel sheets (Results).

Creation of sessions, configuring and executing workflows to extract the data from various sources, transformed data and loading into the Datawarehouse

Run the Autosys Jobs and verify the data correctness in different Environments.

Responsible for manage defects from defect discovery to resolution Management.

Advocate test-first approach and testing best practices.

Collaborate with developers on architecture and design, evaluate and improve processes to enhance software quality.

Working with Product Owners, Business Process Engineers and Technical Solution Engineers to understand the End-to-End application functionality and capability, analyzing and reviewing business requirements and technical specifications of End-to-End applications. Collaborating with Application team SMEs to determine system requirements and functionalities with respect to the business scenarios.

Involving in setting up the test environment and test data to meet appropriate project requirements to start the test execution.

Providing organizational, problem-solving and operational support to production support team for testing bug fixes once the pre-production code migrated into production environment.

Communicate with Stake holders on status, issues, risks and plans.

Writing the architecture/technical design document and development as per business requirements

Studying and understanding the functional specification documents.

Customizing applications to meet the customer business requirements.

Suggest improvements in server/client applications for customer.

strong experience in troubleshooting and fixing of issues during System Integration Testing & User Acceptance Testing phases.

Resolving fire calls within stipulated time period to maintain SLA.

Monitoring of Stream processing and completion.

Responsible for Issue Resolution within SLA limits.

Status Reporting.

Documentation, generation of metrics and graphical representation.

Experience in running web scale services on Amazon Web Services

Experience in continuous Integration tools such as Jenkins.

Have delivered large-scale solutions, coordinated projects with both Onshore and Offshore teams.

Provided guidance for Test Planning and Test Execution along with defect root cause Analysis and reporting

Created/Developed de-normalized structures based on the requirements and to improve the query performance for end users.

Interacted with test leads and architects to develop and establish Quality Assurance standards and best practices Performed Black Box testing of different applications and products for multiple projects.

TECHNICAL SKILLS:

Cloud Technologies

Red-Shift

Build/Automation Tools

Jenkins

Scripting Languages

Unix Shell, AutoSys

Operating Systems

Sun Solaris 7/8/9/10, Windows Server 2003/2008R2/2012/2016.

Web/App Server

Apache, WebSphere Application Server,

Databases

SQL Server, Oracle, WORKDAY, Prism, Toad, SQL Developer

Project Tracking/

Bug Tracking Tools

Service NOW, JIRA, Remedy, IBM Clear Quest, Bugzilla, HP Quality Centre.

Version Control Tools

GIT, Tortoise SVN, VSS

Networking

TCP/IP, LDAP

Monitoring Tools

REMEDY User

WebTechnologies

/Programming Languages

XML, HTML, C, SQL, PLSQL, PRO*C, SOAP UI

Support Management Tools

Remedy User, Lotus, HP-ALM, Notes, Reflection-X,Control-M

BI Reporting Tools

Informatica, Hyperion

PROFESSIONAL EXPERIENCE:

Client: Fannie Mae VA, SQA Concepts MAR 2019- Till Date

Role: SDET(Software Developer in Test)

Responsibilities:

•Evaluate user requests for new or modified computer program to determine feasibility, cost and

time required, compatibility with existing systems, and computer capabilities.

•Coordinate and include approved reengineering and business process review modifications

into the business system requirements and design.

•Enhance or modifying applications accordingly, providing technical expertise to project team

covering database, middleware, client server and web technologies.

•Adapt ETL processes to accommodate changes in source systems and new business user requirements.

•Develop the complex SQL’s and PL/SQL procedures to verify the data correctness.

•Creation of sessions, configuring and executing workflows to extract the data from various sources, transformed data production.

•Involve in Defect Tracking and Bug Reporting with the use of tools like JIRA.

•Run the workday integration and load the data into workday/PRISM Tables.

•Validate the data in the Cloud DB Redshift and validate the data load and correctness.

•Develop and tune the queries using Hints/Performance techniques for validation in performance environment.

•Drive a team to devise/ configure integration tests, to ensure the newly built modules are integrated properly

•Develop automation scripts with the use of SOAP web services, fetch data

with the use of SQL queries and validations updated in excel sheets (i.e results).

•Analysis on Defects and providing possible solutions for business needs.

in Informatica and loading into the Datawarehouse

•Run and Validate UNIX and Autosys job as required.

•Responsible for Implementation and running of test automation frame work through Jenkins and validate the source and target data.

•Prepare test scenarios and execution and responsible for review with product owners for the deliverables.

•Test/Defect management and Certifying the test results with Client Prior application to be migrated.

Environment/Tools: Amazon Web Services (AWS)-Redshift, SVN, GIT,Jenkins Jira, shell,

ETL, Informatica, Data warehouse, Oracle SQL, PL/SQL, AutoSys, UNIX, JIRA,

Workday/PRISM,Informatica

Client: Freddie Mac VA, Hexaware Technologies. Nov 2016 – Feb 2019

Role: ETL Tester

Responsibilities:

•Primarily responsible for timely delivery and quality of the deliverables.

•Perform GUI testing.

•Create and run SQL statements to validate data correctness

•Communicate with stake holders on status,issues,risks and plans.

•Defect tracking through Service now.

•Primarily responsible for timely delivery and quality of the deliverables.

•Perform GUI testing.

•Create and run SQL statements to validate data correctness

•Communicate with stake holders on status,issues,risks and plans.

•Defect tracking through Service now.

•Create high level and low-level docs for the mappings created.

•Design execute and review requirements, test cases and test results.

•Runs and validates UNIX jobs as required.

•Created sessions, configured and executed workflows to extract data from various sources,

transformed data, and loading into datawarehouse.Responsible for design,coding and

automation of Test scripts using Jenkins.

•Preparing and using test data/cases to verify data accuracy.

•Executing Testing Processes as per proper standards in ETLTesting.

•Defect tracking and Source to Target loading and validating the same.

•Create and run SQL statements to validate data correctness

•Communicate with stake holders on status, issues, risks and plans

• Written shell scripts for end to end build and deployment automation

Environment/Tools: Informatica Power Center, HP-ALM,SOAP UI, Oracle 11i, UNIX, AutoSys, Service Now

Client: Brown Brothers Harriman & Co, NJ,Hexaware Technologies. Nov 2010 – Nov 2016

Role: PL/SQL Developer/Production Support Analyst/BI/ETL Tester

Responsibilities:

Created sessions, configured and executed workflows to extract data from various sources,

transformed data, and loading into data warehouse.

Performed Data verification in Database by running of respective workflows.

Testing ETL Test components and Create, design and execute test plans and test cases

Extensive experience in ETL/ Data warehouse backend testing

Defect tracking and Source to Target loading and validating the same.

Preparing and using test data/cases to verify data accuracy.

Send daily updates to customer.

Working with team to resolve bugs related to day one ETL mappings before production.

Runs and validates Unix jobs as required.

Analysis and issue resolution for various user related queries.

Post production support and handling change requests.

Production support for Portfolio Accounting in support Phase.

Environment/Tools: Informatica Power Center/SQL, Oracle, Unix.

Client: Northern Trust Chicago IL, Hexaware Technologies. Jun 2010 – Nov 2010

Role: PL/SQL Developer/Production Support Analyst

Responsibilities:

Involved in database level Programming.

Resolving fire calls within stipulated time period to maintain SLA.

Monitoring of Stream processing and completion

Status Reporting.

Documentation, generation of metrics and graphical representation

Interaction with clients through conference calls

Study of requirements and system.

Environment: Technical - PLSQL Developer, Operating System - Unix, Support Tools - Remedy User, Communication tools - Reflection Languages - C++, SQL,

Unix Shell Scripting, Other Tools - Lotus Notes 6.5

Client: ICICI DIRECT-MUMBAI,IND, Hexaware Technologies. Aug 08- Mar 09

Role: PL/SQL /PRO*C Developer Oct09 -Apr 10

Responsibilities:

Created database objects such as tables,views,synonyms,indexes, sequences and database links as well as custom packages tailored to business requirements

Written complex sqls using joins, sub queries and correlated sub queries.

Involved in database programming and developed Stored Procedures

Developed Pro*c programs.

Client: TATA COMMUMICATIONS-MUMBAI,IND, Hexaware Technologies. Mar 2009 – Oct 2009

Role: PL/SQL /PRO*C Developer

Responsibilities:

Analyzed the user requirements.

Development of Re-usable objects like General Procedures, Functions, Packages, Triggers and various PLSQL validations.

Quality processes such as documenting the change requests and tracking them.

Technical & Project reviews with client, coding, testing and Implementation.

Developing Analysis Documents/Impact Analysis based on the requirement study.

Code Production, testing, packaging, implementation and post implementation verification.

User data requests, updating and escalations.

Environment: Oracle 10g, PL/SQL,PRO*C

Client: Food Lion LLC, Soft value Solutions. Aug 2007 – Aug 2008

Role: PL/SQL /PRO*C Developer

Responsibilities:

Coordinated with team members in business requirements analysis, system analysis, design and development of the application.

Created database objects such as tables, views, synonyms, indexes, sequences as well as custom packages tailored to business requirements.

Developed Pro*c programs and Involved in Writing database level Procedures and Functions. Perform unit and integration testing and prepared test cases and test plan

Environment: Oracle 9i, Sun Solaris 5.9,Pl/sql,Pro *C.

Client: Managed care, Soft value Solutions. May 2006 – May 2007

Role: PL/SQL /PRO*C Developer

Responsibilities:

Analyzing the Business requirements provided by the users.

Created database objects such as tables, views, synonyms, indexes, sequences as well as custom packages tailored to business requirements

Involved in database programming like writing database level Procedures and Functions.

Environment: Oracle 9i, Sun Solaris 5.9,Pl/sql,Pro *C.

Education:

Bachelor’s in Information Technology from JNTUH. 2006

Contact this candidate