SYNOPSIS:

Over 13 years of Experience in different capacities, primarily in the areas of Testing, Application Development, Maintenance & Support and Quality. Have exposure to domains like Banking and Financial, Telecom, Healthcare, Retail.

EXPERIENCE SUMMARY:

• Has over 13 years of experience in applications Development, Maintenance, support and Testing.
• Progressive experience in Development, Testing, Quality process and Implementation for various applications of DWH systems.
• Knowledge of Quality processes.
• Expertise in ETLTesting, SQL, PL/SQL, UNIX, Autosys,PRO*C, WORKDAY
• Involved in DWH Testing using INFORMATICA.
• Flexible enough to adapt to new environments.
• Sound knowledge in analysis of functional issues.

AREAS OF EXPERIENCE:

Industries: TelecomHealthcareBankingRetailMortgage

Languages: PRO*CRDBMSSQLOracleDB2PL/SQL

Operating Systems: Windows Advanced Server, UNIXTesting

Management Tool/Defect Tracking Tools: HP - ALMService nowJIRASource Safe

Tools: VSSSupport toolsInformatica power center

Remedy: User, Lotus,HP-ALM,Notes, Reflection-X,Control-M.Jenkins,SOAP -UIWorkday/PRISM

PROFESSIONAL EXPERIENCE:

Confidential

Software Development Engineer in Test (SDET)

Tools: ETL, Informatica, Data warehouse, Oracle SQL, PL/SQL, AutoSys, UNIX, JIRA Jenkins, Workday/PRISM

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 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 to 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.

Confidential

ETL Testing

Tools: & Environment: Oracle 11i, UNIX, AutoSys, service Now

Responsibilities:

• Application Testing
• 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.

Confidential

Application Test Lead

Tools: Informatica Power Center, Service now

Responsibilities:

• Design execute and review requirements, test cases and test results.
• Runs and validates UNIX Autosys jobs as required.
• 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.
• Maintained and defect tracking Using Service now.

Confidential

ETL Tester

Tools: Informatica Power Center, HP-ALM,SOAP UI

Responsibilities:

• 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

Confidential

Team Lead

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

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.

Confidential

Production Support Analyst

Tools: & 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

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.

Analyst Programmer

Confidential

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

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.
• Prepare test cases and test plan.