PROFESSIONAL SUMMARY:

• 10+ years of experience in IT industry mainly in Architect, Design, Development, Implementation, Testing and Documentation of business applications using Oracle technologies.
• Proficient in writing Stored Procedures, Functions, Packages, Cursors and Triggers using Oracle PL/SQL.
• Experience in writing and tuning of complex SQL statements using joins, sub queries and inline views.
• Experience in PL/SQL Programming using Dynamic SQL, Collections, Bulk techniques, Ref Cursors, Object types, Record types to improve performance.
• Expertise in using Exception Handling in PL/SQL programming.
• Hands on experience in using Oracle tools and utilities for Extraction, Transformation and Loading (ETL) like TOAD and SQL*Loader.
• Developed SQL*Loader control programs and PL/SQL validation scripts to transfer flat file data into oracle database.
• Proficient in Oracle 11g/10g/9i/8i, PL/SQL back end applications development using TOAD and PL/SQL Developer.
• Experience in requirement gathering, analysis, database design, software programming, testing, documentation, deployment, maintenance and up gradation of applications.
• Experienced in Tuning Queries for better performance with large volume of data using EXPLAIN PLAN and other utilities.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production.
• Experience in developing Custom Interface programs both inbound and outbound to import/export data/reports from various sources using PL/SQL, SQL*Loader.
• Experience in Software Development Life Cycle (SDLC) including Analysis, Design, Development, Implementation, Testing and Post Production Support using Oracle Applications
• Experience of Data Reconciliation using PL/SQL queries and Unix Shell Scripting.
• Experience in generating Unix Scripts for fetching data from relational DB.
• Experience in creating Recurring Alerts using Unix Scripting and PL/SQL in Production and Reporting environment.
• Demonstrated ability to identify root causes/ debugging of problems and troubleshoot, considering both long and short - term impact of proposed solutions and developed workable solutions
• Migration of data from Legacy application to New application by Requirement Gathering, Module Designing, Analyzing data flow, Developing PL/SQL Procedures, Functions, Packages and Testing .
• Involved in writing Technical Design Documents, Solution Design Documents and Unit Test Case documents. Was actively involved in production Go-Live activities and also rendered services during maintenance by resolving issues with less turnaround time.
• Experience in providing technical support to end users related to Application Support, Release/Deployment, Change Management etc
• Experience in providing on call support for triages, coordinating with various support teams and communicating to business and users in accordance.
• Strong understanding of Data Warehouse Concepts,Data Models, Data Marts and ETL.
• Experience in creating ETL mappings in Informatica using Transformations.
• Strong Data Analytical skills ,well versed with analytical functions.
• Experience performing root cause analysis and communicates to business accordingly .
• Experience of working in Finance and Telecom Domain.
• Experience of working in onshore- offshore model for many projects.
• Experience of leading a team of five members, assigning work, status report, mentoring and evaluation.
• Proficiency in end-to-end development of various Interfaces from requirement analysis to system study, designing, coding, testing, debugging, documentation and implementation.
• Possess excellent interpersonal, communication and analytical skills with demonstrated abilities in customer relationship management.
• Endowed with a Proactive attitude couples with capabilities of thinking out of the box, generating new design solutions and ideas.

TECHNICAL SKILLS:

ApplicationDevelopment Tools: Confidential WebSphere Application Server,Intellij Idea, TIBCO Suite Active MQ

ETL Tool: Informatica

Databases / DB Tools: Oracle 9i/10g/11g client, TOAD, SQL Developer

Programming Languages: SQL, PL/SQL,C, Java, HTML,Unix, Shell scripting,Python

Desktop Tools: MS Office suite 2003, 2007 and 2010, MS SharePoint, Star Team, Jira, Webtrax, Remedy

Methodologies: Water fall, Familiar with Agile

Operating Systems: Windows NT, Windows 98/2000/XP/Vista/7, UNIX,Linux

PROFESSIONAL EXPERIENCE:

Sr. PL/SQL Developer/Production Support Lead

Confidential, Richardson, Tx

Responsibilities:

• Developing scripts for all the data requests from client where based on business logic, we need to provide the data to customers.
• Providing Technical support to end users for any Application Related or Data Related issues.
• Using Incident Management techniques for tracking any issue, resolving issue, updating tickets and closing them.
• Following Change Management Practices for changes in existing code, processes, bug fixes.
• Analyzing and resolving any production issue related to CSM
• Quantifying the impacted base for any particular issue and doing clean up in production data base to mitigate production issue impacts
• Providing Support for Production Outages, on call support for triage issues and communicating to business and end users accordingly.
• Application Monitoring and Operational Readiness to identify any issue proactively and work to resolve it with in SLA.
• Providing support on Release/Deployment time.
• Providing Support for any Billing related issue prior bill cycle releases
• Monitoring batch jobs which affect the data flow from CSM to TLG and vice - versa
• Creating Alerts in PL/SQL on production servers and scheduling them for better monitoring
• Business meeting with client for enhancement of CSM (Customer Service Management) application.
• Ensuring the enhancement to be completed in time frame and testing
• Providing support for quarterly Release of new projects in existing CSM application
• Co-ordination between multiple internal team for issue resolution for better client experience
• Handling all the post release issues.
• Identify Root Cause of issues, document RCA and provide a permanent fix for the issue
• Uses standard, recommended production practices for smooth operation.

Environment: Toad, Windows XP, LINUX, UNIX, Webtrax, i-Track, Oracle DB,i-Track

Sr. PLSQL Developer

Confidential, Oaks, PA

Responsibilities:

• Developed PL/SQL programs to dump the data from staging tables into Base Table.
• Created Custom tables, Views and Indexes
• Created Technical design (HLDs and LLDs) to move the data from staging environment to dev environment and then to production environment as Lead Developer.
• Developing code as per HLD and LLD per business requirement following the standard coding practices.
• Leading team of five members, assigning them modules for development, bug fixes and communication with client on behalf of team.
• Evaluation of team members, filling their feedback forms, one to one discussion also is part of my role.
• Used best practice or standards document for all design and development work.
• Developed complex PLSQL Packages to migrate the data form one environment to another.
• Used TOAD, PL/SQL developer tools for faster application design and developments.
• Experience includes coding Interface Programs using PL/SQL procedures to load data into the interface tables from legacy systems.
• Developed packages, Stored Procedures and Stored Functions using Toad and SQL Developer.
• Written complex SQL statements using joins and sub queries.
• Development and Testing of advanced SQL and dynamic PL/SQL code.
• Worked on business designs to create Technical designs suitable for coding.
• Documentation of Technical Design document (TDD) which includes all the components developed as part of the requirement - packages, procedures, table creation scripts etc.
• Developed different modules for migrating data for a single client for example account, end client, third party, inheritance beneficiaries, fees, statements etc.
• Developed different modules for migration of data from staging to dev and then from dev environment to production like another dev environment and then finally to production environment.
• Used Star Team to check in - check out the code.
• Developed the code as per standard coding rules and done peer code review as per process.
• Prepared detailed Unit Test Cases, execution of test plans and maintained Defect logs.
• Resolving all the issues raised during testing.
• Ramping up new resources by training them and mentoring the team.

Environment: SQL Developer, Windows XP, Star team, Control M, Toad, MS Excel

PLSQL Developer

Confidential, Oaks, PA

Responsibilities:

• Created PL/SQL stored procedures, functions and packages for generating reports in required format.
• Developed PL/SQL programs to dump the data from staging tables into Base Table.
• Involved in testing the Data Integrity of the new tables.
• Worked on designing the flow charts and ER diagrams to illustrate the relationships between the data.
• Used TOAD, PL/SQL developer tools for faster application design and developments.
• Developed packages, Stored Procedures and Stored Functions using SQL Developer.
• Written complex SQL statements using joins and sub queries.
• Development and Testing of advanced SQL and dynamic PL/SQL code.
• Performance Tuning of existing inbound and outbound packages and bug fixing.
• Developed several stored procedures, functions and packages extensively involving with the collections and records such as PL SQL records, PL SQL tables, VARRAYs, TABLE index by binary integer, sorting the PL SQL Tables.
• Handled the data errors with appropriate exception handling and printing the corresponding SQLERRM and SQLCODE
• Documentation of Technical Design document (TDD) which includes all the components developed as part of the requirement - packages, procedures, table creation scripts etc.
• Preparation of Unit Test Cases, Defect logs and Issue Log
• Providing Knowledge Transfer to the newly joined team members.

Environment : SQL Developer, Windows XP.

PL/SQL Developer

Confidential

Responsibilities:

• Optimizing PL/SQL code and SQL queries by using Explain Plan, Analyze, Indexes and Hints.
• Tune SQL statements using hints for maximum efficiency and performance
• Data loaded from flat files to database using SQL Loader utility of Toad.
• Involved in development, deployment of application as per the user requirements.
• Involved in the process of collecting the requirements from users.
• Working closely with business team by attending face to face meetings for new enhancements or requirements in existing application.
• Developing solution for the new enhancements required by business, testing and implementing across the circle.
• Analyzed, designed and developed Premium Number process and PAC process after multiple brain storming sessions with client and team and implementing the same resulting revenue increase.
• Managed all inventory of sim and mobile in ePOS database implementing PAC process.
• Monitoring of all daily scheduled processes and activities using PL/SQL queries, procedures, functions and scripts on daily basis to ensure smooth operations.
• Handle interface between ePOS and BSCS using PL/SQL queries.
• Providing support to business users for i-Reporting reports whenever any issue is raised or proactively handled the data load issues.
• Providing custom reports using PL/SQL scripts, procedures and queries to MIS users.
• Doing data reconciliation of BSCS and HLR using PL/SQL scripts, procedures, packages, functions, queries and UNIX scripts.
• Resolving all tickets logged in BMC Remedy in given SLA and analyzed the type of issues logged and provide permanent solution to repeated issues.
• Initiating RFC (Request for change) process of change management for any kind of change in production application and implementing the changes as approved in RFC.
• Informing and supervising monthly down time of applications Confidential time of reconciliation or any change implementation.
• Providing training to business users for new functionalities added in applications so that they can use them easily.
• Creating training documents for new changes and processes to be followed by business users.
• Leading team of five members, assigning them modules for development, bug fixes and sending reports.
• Evaluation of team members, their feedback forms, one to one discussion also is part of my role.

Environment : PL/SQL, Toad, Windows XP, UNIX, BMC Remedy, Tera -data, DWH

PL/SQL Developer

Confidential

Responsibilities:

• Development, Support, Testing and enhancement of business critical PL/SQL scripts for collection.
• Developed Database Objects like PLSQL Packages/ Procedures/ Triggers/ Views/ Tables.
• Optimizing PL/SQL code and SQL queries by using Explain Plan, Analyze, Indexes and Hints.
• Tune SQL statements using hints for maximum efficiency and performance, create and maintain/modify PL/SQL packages, mentor others with the creation of complex SQL statements.
• Developed major enhancements required for business process in Order to Cash and Procure-to-Pay cycles
• Developed a custom shell FTP program used for transferring the bank statements from Citi Bank server to Oracle.
• Customized Move Order Pick slip Report
• Customized pack slip Report
• Developed Sales Order Acknowledgment.
• Responsible for Unit testing, Issue resolution during QA testing and UAT.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team
• Used TOAD for faster application design and developments
• Independently handled and supported the CNCS application and resolved all operational issues.
• Many Oracle batches were fine tuned using indexes, hints on PL/SQL scripts and altering logic approach to double fold the performance.
• Reduced execution time of PL/SQL scripts fetching reports of all customers for collection for a particular bill cycle from 8 hours to 4 hours.
• Streamlined Dunning and allocation processes of CNCS application.
• Provided support for DMS and FILENET application to business users and being SPOC for these.
• SPOC in Delhi circle for all business users and central Filenet team for launch of Filenet in place of DMS application for document scanning and storing.
• Handled data migration from DMS application to Filenet application using a Java utility and maintained records in excel sheets and completed in time.
• Ensured smooth launch of Filenet application by doing pre-launch testing, post- testing, and educating users well in advance, getting opened all network ports and login credentials for all existing users.
• Supported for OSSAPPS application for issuing bulk requests to BSCS instead of single request Confidential a time.
• PL/SQL scripts are developed to issue bulk command to billing system for users for barring, unbarring, payment and adjustments as a batch.
• Monitored these batched and ensured smooth execution and a report is generated using PL/SQL queries.
• Resolving all tickets logged in BMC Remedy in given SLA and analyzed the type of issues logged and provide permanent solution to repeated issues.
• Initiating RFC (Request for change) process of change management for any kind of change in production application and implementing the changes as approved in RFC.
• Created user education manual for how to use new application Filenet in place of DMS and provided training.

Environment: Toad, Oracle, BMC Remedy,SAS Reporting

PL/SQL Developer

Confidential

Responsibilities:

• Monitoring all pending commands using PL/SQL queries and scripts.
• Resolving all discrepancies/failed commands from BSCS to HLR or vice versa using SQL queries, PL/SQL scripts, update data in production tables.
• Doing Billing and Rating process which includes generating mobile bills of customer of any cycle using PL/SQL queries and UNIX scripts.
• Doing bill audits for all bill cycles before bill runs to ensure accurate bills and help understand the CRM team understand the billing of any particular customer using KV and RA Modules of BSCS along with SQL queries.
• Involved with EBP and Billing Operations team to ensure timely generation of CG bills for audit and bill cycle run.
• Configuring new rate plans, promos and free units in BSCS as per client requirement by updating data using DML queries and PL/SQL scripts.
• Support and maintenance of CRM application with the vendor and cross checking in BSCS using SQL queries.
• Analysis and resolution of any charging related concern using lookup tables, configuration tables and SQL queries.
• Providing logs of all activities of EMG application for prepaid numbers to business users as required for example, caller tune, net pack.
• Configuration of prepaid product in EMG and Top up database using DML queries.
• Generating hourly report of status of commands to billing system using PL/SQL script
• Generated alert to email status of hourly report to all concerned using PL/SQL procedure and function.
• Created new keywords like Confidential by creating new tables, configuring all details in billing server, EMG and Top-up server and generating report using PL/SQL queries, procedures and scripts.
• Resolving all tickets logged in BMC Remedy related to billing system discrepancies, pending commands, EMG etc as per SLA.
• Involved in the complete life cycle of software development for new enhancements: Analysis, Design, Development, Testing and Implementation
• Created Functions, Stored Procedures, Views, Sequences and Synonyms Confidential the back end using SQL and PL SQL.
• Involved in pre live testing in test environment, code upload and UAT in production environment after go live.
• Resolved discrepancies in systems by checking HLR status and billing system using UNIX commands and resolving the same by correcting the status in BSCS using DML queries.