SUMMARY:

• Experienced professional in Information Technology (IT) and Software Industry with extensive experience in Business / IT Analysis, ETL development, Performance Testing, QA Automation.
• Hands on experience with Agile - Scrum methodology.
• Strong knowledge of Software Development Life Cycle (SDLC) and experienced with analysis, design, development and testing of custom web applications.
• Good understanding of Relational Database Management Systems (RDBMS)
• Experience using Oracle, Oracle Utilities and ETL tools such as Oracle Warehouse Builder (OWB).
• Experience with Business Intelligence tools such as Business Objects (BO), BIRT and Data Warehouse
• Experience using IBM Cúram for Benefits administration.
• Strong knowledge in VuGen(load runner) scripting using C and in AWR reports, Analysis Report, DB Utilization and CPU Utilization and Oracle System Tables
• Experienced in HP QTP Automation using VB script and Descriptive Programming.
• Strong experience in developing Test Plans and Test cases using business requirements and design documents and specifying Testing Overview, Approach, Strategy, Scope, Roles and Responsibilities.
• Plan, Design, Build and Maintain complex test automation frameworks (Data-Driven, Keyword, and Hybrid).
• Hands-On Team Leader with strong focus on Documentation, Communication, Process and Constant improvements.
• Shown Flexibility, quick learner, proactive attitude and amazing team player.
• High efficient in Complex, Agile, Dynamic, Onshore-Offshore project environments.
• Implemented web applications using ASP, VBScript, Java, JSP, JavaScript, HTML, Perl, and Oracle.
• Ability to successfully work under tight deadlines
• Excellent interpersonal and customer relational Skills. Proven communication, presentation Skills and Leadership Qualities

TECHNICAL SKILLS:

Languages: C, C++, PERL, JAVA, SQL, PL/SQL, SPARQL, VBScript, JavaScript

ERP: Oracle 12 Applications, CRM, Order Management

RDBMS: Oracle, OWB, Toad, SQL, PL/SQL, SPARQL and DB2

Web Technologies: HTML, CSS, XML, ASP, Java Script, Java Servlets, JSP, FrontPage

Packages: MS-Office, MS-Word, MS-Excel, MS-Visio and MS-Access

GUI Tools: Oracle Developer and Visual Basic

Testing Tools: HP Load Runner, Fiddler, QTP, SOAP UI, HP Quality Center, Test Director, CDETS, Jiri, Dina Trace, IT CAM, Site Scope, BSM, and HP Analysis.

PROFESSIONAL EXPERIENCE:

Confidential

Business and Technology Analyst

• As B&T application analyst, involved in analyzing the data from different source
• Implemented Project using Agile methodology to achieve timely and reliable delivery
• Created SQL scripts to analyses the data is obtained as per business requirement
• Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Oracle Warehouse Builder (OWB).
• Performed Unit testing and System Testing on developed ETL Mapping/Session/Workflow and actively involved in team code reviews.
• Worked with different sources such as SQL, Flat files.
• Deployed and executed all the mappings and process flows using Control Center manager. 
• Made changes to tables to meet business requirements. 
• Designed and Developed Coding for Procedures functions and Packages.
• Worked independently and completed assigned project responsibilities under limited supervision and aggressive deadlines.
• Worked as Performance test engineer to ensure that application is performing as per the business SLA.
• Has exposure in the SDLC and Agile. Delivery methodology.
• Strong exposure on performance using Load Runner, Performance Center and APM tools.
• Strong knowledge on profiling components subjected as part of system under Performance consideration using tools like AWR, HP Open View, IBM Workbench Assistant, Site scope and Fiddler.
• Extensive knowledge in creating VuGen scripts for Java applications
• Created scripts for Business Scenarios
• Conducted Load Testing, Stress test and collated the Test Results
• Created delta reports and graphs to generate overall report in comparison to the last build
• Prepared overall Pager Report with pass/fail transactions, Throughput, DB graphs, CPU Utilization graphs and Delta run graphs.
• Provided recommendations based on the Test Results.
• Experienced in writing and executing SQL queries, Oracle session tables to monitor the performance testing process.
• Collaborating with onsite Development team to resolve performance defects (e.g., sifting the application server logs to identify the reasons contributing towards the response time peaks observed during the test).
• Maintained performance data and ensured that troubleshoot was performed and forecasted need.
• Worked as Interface tester to test interfaces that NCFAST connects to and also working on soapUI to test web services.
• Experience with working with Message Sets/WSDLs/ SOAP nodes 
• SOAP UI testing to test web services and RHFUtil to test web sphere MQ.
• Worked as Automation lead in building a complex dynamic framework for Curam application.
• Build QTP Function Library (QFL) to handle complex Curam Application work flow.
• Built a complete repository of reusable keyword functions using descriptive programming.
• Worked closely with the Business team to review the conditions and rules, captured thoroughly to implement the functionality as per business requirement specifications
• Worked with the QA team, to review the test scripts and data sheets, and to make sure that the test cases captured all functionality as per business requirement specifications.
• Worked on running batches in putty using ant scripts commands.
• Proficient in HP Quality center and played as a role of project admin.
• Proficient in Microsoft Excel
• Critical thinker who is self-starter and willing to take initiative and work with little or no supervision. 
• Automated test scripts as per functionality

Confidential

Business Analyst

• Worked closely with the Business team to ensure that the requirements are captured thoroughly to implement the functionality as per business requirement specifications.
• Worked with the QA team, to review the test scripts, and to make sure that the test cases captured all functionality as per business requirement specifications.
• Performed SQL queries to get data from the TAC Skills Manager.
• Worked on Sparql queries to access RPM data.
• Covered 100% testing of BAT, UAT and Data validation test cases and uploaded them in to Quality Center and performed BAT, UAT and Data validation testing manually.
• Proficient in Quality Center- Test plan, Test lab, Defects.
• Performed BAT testing, Data validation for different environments using Oracle SQL and SparQL. Raised defects in Quality Center and communicated with various team members for getting defects fixed.
• Created UAT scenarios and worked with Biz team for completing user acceptance testing.
• Proficient in the use of Microsoft excel, especially validating the data for different type of databases RPM (Ontology) and TSM (Oracle SQL).
• Participated in ERMO release cycles in Waterfall model.

IT Analyst

Confidential

• Analyzed the business requirements and created functional specification documents.
• Worked with the IT development team, to make ensure that the application design/development is implemented as per requirements.
• Worked with the QA team, to review the test scripts, and to make sure that the test cases capture all functionality as per functional requirement specifications.
• Performed regression and progression testing, and documented issues in Quality Center and CDETS, and communicated with various team members for getting defects resolved.
• Created UAT scenarios and worked with business for completing user acceptance testing.
• Participated in ERMO release cycles in Waterfall model.

Confidential

Developer

• Analyzed the business requirements and developed use cases.
• Developed the class diagrams and sequence diagrams.
• Designed database table structure, and constraints.
• Implemented Java Mail API and used Servlets. 
• Prepared script and build files to automate the processes. 
• Interacted closely with the end users, audit and the technical team to meet the requirements. 
• Lead the team in gathering the requirements for other software's like payable at par and check protect system. 
• Documented all current procedures, Application Migration, Business process flow and training manuals.