SUMMARY:

• Software professional having ~14 years of IT experience in software development life cycle - analysis, design, development, testing (system and performance testing) and implementation.
• I have vast experience in handling/executing multiple performance engineering and automation assignments .
• Extensive experience in handling onsite and offshore teams.
• Expertise in assessing project performance requirements and creating performance strategy/plan document.
• Strong expertise in HP Quality Centre, HP Performance Centre and performance testing using Load Runner and Jmeter.
• Expertise in performance testing various protocols (i.e. Web Http/Https, Citrix, Web Services, TruClient and Mobile ).
• Performance Tested Mobile applications using Loadrunner mobile/Emulator protocol.
• Experience in setting up Jmeter test suites in CI/CD pipeline using Jenkins.
• Provided support in the performance testing using JMeter task includes developing test plan, test script and reports.
• Develop scenario based testing for the JMeter scripts.
• Create, schedule and run the scenarios using JMeter and generate necessary graphs.
• Created and executed JMeter scripts for performance testing of APIs and WebSphere MQ testing
• Expertise in performance testing of RPA (Robotic Process Automation) - Blueprism business processes.
• Selenium and QTP for Creating Automation Script.
• Proficient with Tread dump analysis, heap dump analysis, Garbage Collection Analysis .
• Proficient with code profiling at client and server side.
• Proficient with identifying database and application level bottlenecks, oracle database tuning and PL/SQL (Queries, Procedures, Functions and Packages) performance tuning.
• Proficient in shell scripting in linux and unix operating system .
• Strong Expertise in Database bottleneck identification using explain plan, AWR reports, data dictionary tables/views, ASH, database top 5 events, wait events etc.
• Expertise in application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, SQL developer and SQL*LOADER.
• Used different tools like Introscope, DynaTrace tools & OEM, ASH, AWR report etc. for synthetic monitoring, runtime/browser diagnostics and to analyze test results.
• Proficient in Data Modelling using normalizing Techniques.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Proficient in Oracle Supplied Packages such as DBMS SQL,DBMS JOB and UTL FILE.
• I have over 1.5 years of experience as Business Analyst in SOA project where my role was to gather, analyse and finalize business requirements. Helping offshore team in creating LLD & HLD based upon the business requirements. Creating and executing Test Cases in Quality Centre for UAT/HOAT. Coordination with Confidential onshore and offshore team. Created testing tools that were used by business user during UAT.

TECHNICAL SKILLS;

Languages: SQL, PL/SQL, Shell Programming, Delphi 7, Delphi 8, .NET 2.0 3.0

Operating Systems: Sun Solaris 9.0, Windows(2000/ NT/ XP)

Database: Oracle 9i,/10g

Tools: Web(http/html), SOAP over http, JSON over http, citrix, web services., HP Performance centre 9.1/10/11/12, HP Load Runner 8.0/9.0/9.1/10/11/11.5/12 , Jmeter - MQ Testing via JMX, API testing., Running the Jmeter test scripts using Jenkins,Selenium and QTP for Creating Automation Script., SOAPUI, Fiddler, Wireshark, Postman, Google Lighthouse,Introscope, Dynatrace, SiteScope,SQL Developer, Toad, Oracle SQL *Plus, Various OS and database monitoring tools ex. SAR, prstat, vmstat, iostat, statspack/AWR, perfmon., Putty, VSS

Middleware: IBM Messaging Queue (MQ)

WORK EXPERIENCE:

Senior Performance Engineer

Confidential

Responsibilities:

• Working on multiple digitization projects.
• Estimation for testing projects.
• Worked with product teams to identify business critical transactions / identify enhancements
• Preparing the Performance Test Plan & Performance Test Strategy.
• Experience in setting up Jmeter test suites in CI/CD pipeline using Jenkins.
• Provided support in the performance testing using JMeter task includes developing test plan, test script and reports.
• Develop scenario based testing for the JMeter scripts.
• Create, schedule and run the scenarios using JMeter and generate necessary graphs.
• Created and executed JMeter scripts for performance testing of APIs and WebSphere MQ testing
• Expertise in performance testing of RPA (Robotic Process Automation) - Blueprism business processes.
• Extensive experience in Oracle DB performance tuning.
• Getting involved in identifying database and application level bottlenecks.
• Identifying and tuning problematic Database SQLs using SAR, AWR reports, explain plan etc..
• Coordinated with Architects & Development teams to identify the business.
• Preparing the performance scripts with various Load Runner protocols.
• Creating Performance metrics, Dashboard and reports for deep dive analysis and executive summary for higher management
• Setup new scenarios which are identified during the planning phase.
• Executed all the test case scenarios, which have been identified in the test plan (SOAK test, Endurance test, Load test and ensure SLAs are being met.
• Used different tools like Introscope, DynaTrace tools & OEM, ASH, AWR report etc. for synthetic monitoring, runtime/browser diagnostics and to analyze test results.
• Used Dynatrace smart business transactions for debugging issues specific to user set & ADK for application profiling.
• Participated in troubleshooting the Performance Bottlenecks seen during the test with Dev / Environment support.
• Executed combined tests with other performance teams to meet SLA.
• Created Exit review with test results and report performance improvements obtained to stakeholders.

Senior Performance Engineer (Database tuning)

Confidential

Responsibilities:

• Digitization Program - Managed multiple initiatives (Home Financing, Needs Navigator, E-Sign, Mobile Document Capture) from Intake, Assessment, Test Strategy, planning, scripting, execution, analysis to closure and involve in the providing technical consultancy for the AUT
• Extensive experience in handling multiple performance testing projects.
• Extensive experience in handling onsite and offshore teams.
• Performance Tested Mobile applications using Loadrunner mobile/Emulator protocol.
• Using Selenium for creating Automation scripts.
• Extensive experience in Oracle DB performance tuning.
• Interaction with banking project(e.g. branch image capture, ATM Image Capture,Day2,Online Banking etc.) teams and understanding the performance test requirements.
• Assess the banking project performance requirements and creating performance strategy/plan document.
• Performing POC(Proof of Concept) and creating baseline loadrunner scripts that are used by the Performance Team.
• Creating shell/Java scripts for creating data.
• Getting involved in identifying database and application level bottlenecks.
• Identifying and tuning problematic Database SQLs using SAR, AWR reports, explain plan etc..
• Used different tools like Introscope, DynaTrace tools & OEM, ASH, AWR report etc. to analyze test results.

Tools: /Software: Performance Centre 11, SOAPUI, JavaScript, WebSphere mq, shell scripting,wireshark,fiddler,SAR,prstat,AWR,perfmon,intrascope

LoadRunner protocols: Web(http/html), SOAP over http, JSON over http, citrix, web services.

Oracle Database Tuning Project Lead

Confidential

Responsibilities:

• Preparation of WorkLoad Profile and test plans.
• Coordinating with the application team and reviewing the performance specific test cases.
• Generated AWR reports from Oracle database and analysed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.
• Used Explain Plan and creation of new indexes to improve the performance of SQL statements
• Identify database and application level bottlenecks and help the application team in tuning the application.
• Provided tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database like adding enough spaces to database.
• Regular discussions with client.
• Team interaction, performance management.

Business Analyst

Confidential

Responsibilities:

• Involved in various activities of new application requirement like information gathering, analyzing the information gathered, documenting the functional/business requirement.
• Interacted closely with client to gather, analyze and finalize the business requirements.
• Getting detailed understanding of requirements and helping in finalizing the BRS document.
• Creating Detailed Requirement Specification document.
• Clarified various queries raised by offshore team.
• Involved in Test data set-up for the functional flow and prepare the data for statistical analysis.
• During SIT and UAT worked closely with SOA Integration Solution (SIS), Jrule and SMDS team.
• Created testing tools using PL/SQL (implementing business rules) those were used by business users during UAT.
• I was involved in various SPT specific tasks like creation of non-functional requirement document and workload profile. Also, during performance testing, I was involved with the performance testing team in identifying application specific bottlenecks which eventually helped the team in tuning the application.
• Coordination with on-shore and off-shore team.

Database Tuning Project Lead

Confidential

Responsibilities:

• Preparation of Work Load Profile and test plans.
• Coordinating with the application team and reviewing the performance specific test cases.
• To identify database and application level bottlenecks and help the application team in tuning the application.
• Generated AWR reports from Oracle database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, and database growth.
• Regular discussions with client.
• Team interaction, performance management.

Technology: Oracle 10g, HP Performance Center 9, HP LoadRunner 9, WebSphere MQ, JavaScript,shell scripting, SAR, prstat, awr, perfmon

Software/Database Project Lead (Reporting Solution Development)

Confidential

Responsibilities:

• Responsible for complete end to end design of new Reporting Solution.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Loaded Data into Oracle Tables using SQL Loader.
• Experience with Oracle Supplied Packages such as DBMS SQL,DBMS JOB and UTL FILE.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Close interation with client to gather and analyze business requirements.
• Impact Analysis and all other design documents for the new requirement.
• Design lead for all new enhancements to the application.
• Key role while ensuring smooth transition of application to Confidential .
• Analyze, monitor and review Project deliveries.
• Client Interaction on regular basis
• Managing Knowledge Transfer Process and Induction Plan
• Team interaction, performance management.
• Tracking and Mitigating the risks
• Study and Analyze clients business processes and requirements.
• Performance Tuning
• Database administration - Server Health Check

Lead Performance Engineer

Confidential

Responsibilities:

• Preparation of Work Load Profile and test plans.
• Providing to the offshore team to build up their competency in performance testing tool (Load Runner).
• Coordinating with the application team and reviewing the performance specific test cases.
• Prepare Test Data.
• Executing performance test.
• To identify database and application level bottlenecks and help the application team in tuning the application.
• Regular discussions with client.
• Team interaction, performance management.
• Technology: Oracle 10g, HP Performance Center 9, HP LoadRunner 9, WebSphere MQ, JavaScript,shell scripting, SAR, prstat, awr, perfmon

Software/Database Developer

Confidential

Responsibilities:

• Involved in the Design and Analysis for application migration to delphi 2009 from Delphi 7/8 and preparing the required Design documents (ex. LLD,HLD etc.).
• Planning of migration strategy.
• Coordinating with clients for getting the required inputs.
• Application Performance Testing & tuning.

Technology: ASP.NET 2.0, Oracle, Delphi, shell scripting, Loadrunner, COM+, WebSphere MQ

Lead Performance Engineer

Confidential

Responsibilities:

• Performance testing for various client applications.
• Acquiring competency in Performance Centre tool and providing to my team.
• Preparation of Workload Profile and test plans.
• Coordinating with the application team and reviewing the performance test specific test cases.
• Preparing Test Data.
• Executing performance test for applications.
• Identify database and application level bottlenecks and help the application team in tuning the application.
• Regular discussions with application team and client.
• Team interaction, performance management.

Technology: Oracle 10g, HP Performance Center 9, HP LoadRunner 9, WebSphere MQ, JavaScript,shell scripting, SAR, prstat, awr, perfmon

Software/Database Developer

Confidential

Responsibilities:

• Part of application offshore support team.
• Development of web application on ASP.NET.
• Testing the application for various enhancements.
• Data modeling using normalizing Techniques.
• Creating Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Database Administration.
• Writing Unix scripts for backup/recovery and export utility.
• Application and database tuning.
• Application Performance Testing using Loadrunner.

Technology: ASP.NET 2.0, Oracle, shell scripting, Loadrunner, COM+, WebSphere MQ