Summary:

• 9 years of IT experience in Software Development/Maintenance Support Projects
• Technical areas of experience related to Oracle PL/SQL, Informatica, UNIX Shell Scripting
• Experienced in complete life cycle Implementation of PL/SQL Development
• Experienced in working in Agile methodology
• Extensively worked with Oracle PL/SQL Stored Procedures, Functions, Packages, Triggers and
• involved in Query Optimization
• Expertise in working with DWH and ETL Concepts
• Expertise in using UNIX and writing UNIX shell scripts
• Expertise in handling Production Support projects
• Good exposure to Development, Testing, Production support, Debugging, Implementation and Documentation
• Strong Team building and mentoring skills and excellent Team leadership capability
• Experience Summary CenturyLink Inc. Monroe, LA Jan 2012 Till Date Accenture Services Pvt. Ltd. Bangalore, India Dec 2009 - Jan 2012 HP Invent, Bangalore, India Bhilwara Infotech Pvt. Ltd. Nov 2006 - Feb 2009
• Maintenance Software Development Pvt. Ltd. Chennai, India Jun 2001 - Jul 2002
• Business Soft Skills
• Strategic Planning
• Managed Multi-Vendors for HP
• Metric Driven dash boards
• Rich Client Interactions
• Good Presentation Skills
• Good Training Skills
• Products Tools Worked:
• Database: Oracle 9i/10g/11g
• Languages: SQL, PL/SQL, Unix Shell Script
• DWH Tools: Informatica, Lavastorm BRE
• Domain Knowledge: Pharma R D, Pharma CRM, Financial Domain-Banking, Telecom
• Reporting Tools: webFocus
• Version Control Tools: IBM Rational Clear Case, Dimensions
• Operating Systems: Unix ksh , Linux
• Service Desk Tools: Open View Service Desk, HP Service Desk, BMC Remedy, Unicenter Service Desk
• EDI/Gentran Tools: Apache Web Server, EDIFACT ANSI X12, EDI XML File Formats.

Project Experience:

Client : Confidential

Oracle PL/SQL Developer

Duration: Confidential

Domain : Telecom Revenue Assurance Domain

Tools : Lavastorm BRE, Oracle 11g, webFocus reporting tool, Linux Shell Scripting

Description:

As a part of the Business Support Systems BSS group, I provide application and databases support for all the applications which provides Revenue Assurance to CenturyLink.

Responsibilities

• Provide Data Integration Support by integrating data from all the different systems using the Lavastorm Business Rule Editor Lavastorm BRE and load the data in DWH tables
• Create and maintain Databased objects like DbLinks, Materialized Views for fetching data from different databses
• Create and maintain Database Partitions for the daily CDR loads
• Create adhoc PL/SQL blocks for User requirements
• Create revenue reports for end users using webFocus tool
• Performance tune SQL queries for faster execution time
• Perform unit testing to verify successful loads in the DWH tables

Client : Confidential

Oracle PL/SQL Developer

Duration: Confidential

Domain : Finance - Core Banking

Description

The project involved provding Oracle Database Support to NAGe Bank Technical Operations based in Ireland and Scotland.

Responsibilities

• Create User, roles and priviledges and tablespaces for new projects
• Provide the Project Playbooks and the Component Release Notes CRN's for new projects and Change Requests
• Deliver the components using the Version control Clearcase tool
• Create PL/SQL code for implementing the application logic
• Transfer data from Prod to Development environment using SQL Loader and Datapump
• Provide Performance Tuning Support to the Client Sql queries

Client : Confidential

Oracle PL/SQL Developer

Duration: Confidential

Domain : Pharma CRM

Description

The project involved extracting XML data and inserting them into different tables in the same schema. The XML data was stored as CLOB object and Oracle built-in XML functions were used to capture the data.

Responsibilities

• Created the required PL/SQL package for the Migration of XML data to Oracle tables
• Took part in the Unit testing of the Project
• Took part in defect fixing during the Integration Testing Phase of the Project
• Created and maintained the following project documents - Interface Migration Checklist - Design Document - Source to Target Matrix for the project - Error Log - Change request log

Pfizer PMI CFI Project

Client : Confidential

Oracle PL/SQL Developer

Duration: Confidential

Domain : Pharma R D

Description

The Post Merger Integration PMI of Pfizer and Wyeth resulted in the migration of Wyeth's Compound and Structure information into the Pfizer system.

Responsibilities

• Created data flow diagrams and Pseudo codes for the proposed data migration plan
• Took part in the Analysis and Design phase of the Project and created the Source to Target Matrix document
• Created Oracle PL/SQL programming blocks to implement the data migration
• Performed exhaustive data profiling to cleanse the unfit data from the data migration
• Created and performed Unit test scripts in the Staging environment

Additional Responsibilities

• Maintained the Engagement Business Sheet EBS Report for multiple projects
• Created a custom made delivery model by combining the Accenture Delivery Methodology ADM and the Client delivery model
• Took Oracle SQL and PL/SQL Sessions for the fresher's batch from Oracle and DWH team

World Wide Integration Solutions WWIS

Client : Confidential

Oracle PL/SQL Developer

Duration: Confidential

Domain : Banking, Retail Communication

Description

World Wide Integration Solutions WWIS provides enterprise-wide, cost-effective solutions enabling seamless integration, business flexibility, and rapid deployment for all HP integration activities. WWIS manages the integration suite used to integrate between HP applications and to connect HP to its external partners for the exchange of business documents. The following applications are mission critical and their availability time metrics is 99.9 .

Applications Supported

• Gentran/Application Integrator AI EDI Translation Server
• Cyclone AS2 gateway
• Web Methods XML gateway
• HP Service Bus
• Supply Chain Information Brokerage SCIB

Responsibilities

• Developed Procedures and Packages to validate Business Rules
• Developed queries for data analysis for the above mentioned applications
• Maintained Oracle 9i databases for the above mentioned applications
• Implement EDI setups in Gentran Translation Server and web Methods XML gateway
• Proactively monitor the data flow for all the applications to make sure everything is running smoothly
• Monitor all the health-check alerts and the connectors for connectivity issues
• Identify and resolve EDI translation errors using the EDI maps
• Worked with Technology Partners in developing and implementing AS2 certificate for the Cyclone and web Methods gateways
• Worked in conjunction with geographically separate teams all over the world
• Trained HP Business Users and Technology Partners in using the application interfaces with the aid of video PowerPoint presentations

Client: Confidential

Oracle PL/SQL Developer.

Responsibilities

• Gathered requirements and prepared functional requirements and technical specification documents
• Developed PL/SQL code for the Application logic
• Implemented the connection between the Oracle 8i database and the front-end Clarion application
• Developed and designed GUI screens to output the results
• Created test cases and test plans from the functional requirement documents. Performed unit testing and user acceptance testing