SUMMARY

• Over 16+ years of hands - on experience in Software Development Life Cycle including Requirement Analysis, Prototyping, Design, Extensive Development, Testing, Deployment, Production Support and Maintenance of ERP applications.
• Expert in Oracle 8i/9i/10g/11g, Advanced PL/SQL and SQL & Korn Unix Shell Scripting.
• Experience working with In-house ERP packages such as Confidential, Computron on various modules like GL, AP, Inventory, Sales, Manufacturing, Warehousing, HR and Payroll module which is similar to Oracle Apps.
• Exposure to working in retail product JDA application in modules like Fulfillment, Replenishment and Order Management.
• Architected simple and complex SQL queries, Stored Procedures, Triggers, Functions, Packages, Joins, Views, Materialized Views and Indexes
• Engineered design and creation of PL/SQL objects, Oracle Forms 6i/9i/10g and Oracle Reports 6i/9i/10g.
• Proficient in Oracle, Teradata Tools such as SQL Plus, TOAD, SQL Developer, & SQL Navigator, SQL Assistant
• Extensively worked on programming batch jobs/schedulers using Korn Shell Scripting with complex file manipulation techniques, looping, ftp, mail triggering events and generating statistics report all happening concurrently.
• Experience in Data Conversion across different Relational Database Systems.
• Involved in Extraction, Transformation and Loading (ETL) of large volume of data into Data Warehouse using Informatica 9.5.1, PL/SQL packages.
• Well-versed with Database design, Entity Relationship Diagrams (ERD), Data Modeling and exposure to dimensional Modeling
• Involved in Data Analysis, Data Correction & Data Quality Management in ETL.
• Strong experience in Performance Tuning involving SQL Tuning, running before and after change tests, validating runtimes and coordinating movement of performance changes to Production.
• Designed Online Transaction Processing (OLTP) for various client modules worked on OLAP Data warehousing databases.
• Domain knowledge Life sciences and Pharmaceutical Industry, Health Insurance, Finance, Purchase-to-Pay, and Order-to-Cash, Manufacturing.
• Experience in all models of projects such as Development, Customization, Maintenance, Production Support, Onshore-Offshore model projects etc.
• Good team player with excellent work ethics, self-motivated and quick leaner.
• Also has experience working as a Team Lead/Onshore Coordinator managing offshore team belonging to multiple locations/time zones.
• Also involved in the development of sophisticated web application projects in a three-tier architecture using server side components (EJB) and Core Java.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Korn Shell Scripting, XML, HTML, Java 1.3, C++

RDBMS: Oracle 8i/9i/10g/11g OLTP, Teradata 14.0.

DBMS Tools: Oracle Forms/Reports 6i/9i/10g, Toad, SQLPlus, SQL developer, SQL Navigator

Methodologies: SDLC, SCRUM/Agile, V-Model, Waterfall, Data Conversion, Data Modeling Logical / Physical

ETL Tools: Informatica Power Center 8.x/9/x and exposure to Data Warehouse Star/ Snowflake Schema, FACT & Dimension Tables, OLAP

ERP: In-house products Confidential (3i-infotech), Computron ( Confidential )

Retail Product: JDA Fulfillment, Replenishment and Order Management

Data Modeling Tools: Oracle Designer, Erwin

Unix Shell Script Tools: Putty, Ultraedit, WSFTP-Pro, M-Remote

GUI tools: Excel, PowerPoint, MSWord, MSVisio, Sharepoint, Microsoft Project

Version Control: Harvest, Serena Dimensions, VSS, SVN, Omniworks

Job Scheduling tools: Mainframe ESP, Tivoli, Control-M & Autosys

Operating Systems: Unix (Sun Solaris), Linux, Windows Vista/XP/NT

Middleware: RMI, EJB 1.1

Web Servers: Java Web Server, Apache Tomcat, Weblogic 5.1.0 and JRUN

Quality Tool: Clear Quest

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Onshore Production Support/Development Specialist Cum Coordinator

Responsibilities:

• I was playing the key role of Sustain Team Production Support Specialist working and resolving as to the day-to-day MDM application Incidents and Service Requests involving P1 thru P5 priorities. The role is so critical in the sense all P3 tickets has to be solved on the same day itself.
• Has met 100% SLA for the Tickets logged.
• It also involves daily monitoring of CONTROL-M batch jobs which runs on different servers such as DS Servers, Weblogic Servers & Informatica Servers.
• There are various types of jobs that caters the MDM application such as ETL, MATCH, SURV, S2P, MIAS queue jobs etc.
• Trouble shooting involves reviewing the ticket information in HP Service Center and analyzing the CONTROL-M script logs, DBQ logs, identifying the error viz like deadlock, bad character, duplicate primary key and sending it to the corresponding Functional Team for validation of the bad files and then re-processing the jobs upon receiving the corrected file.
• Apart from this there are also adhoc loads/updates/deletes called Ondemand jobs that needs to be performed on MDM which comes as user request for which we need to prepare Driver Table script, Backup Script, Validation Script and finally Delete/Update/Inserts scripts then logging in into ETL servers connecting to Teradata Database and executing it. This involves mass load/delete.
• There are also various customized solutions we work on such ICF load where the input file will be sent we need to prepare the control file and put in to the Landfiles directory from the where ETL job picks it up.
• This support is complex in the sense we need to know Teradata PL/SQL, Unix shell scripting and Informatica, Control M scheduler as well in order resolve the day-to-day ticket like multi-technology integrated support.
• We also do Causal Analysis Report and document the already resolved frequently occurring tickets in the form of Runbook for entire use of the team.
• As part of Continuous Improvement activities we will also do development work requiring enhancements,fixes needed for the Incidents/Service Requests and also for permanent rectification of frequently occurring tickets, developing monitoring jobs etc in PL/SQL procedures, Shell scripting and Informatica Workflows.
• For CRs Creating detailed design document and coordinating on assignments with offshore team.
• Conduct Handover meetings on tickets and task assignments and preparing/presenting status reports to client.
• Completely driving the Sustain Team and problem solving of any issues encountered in the development cycle.

Environment: Teradata, Teradata view point, Advanced PL/SQL, SQL Assistant, Borland Star Team, Control-M Scheduler, Linux Shell Scripting, HP Service Center, mRemote, WinScp, TIBCO Tool

Confidential, Pittsburgh, PA

Onshore Senior Oracle Developer/Coordinator

Responsibilities:

• Participate in project/ CR (Change Request) related discussions
• Involved in implementation of the Corporate Releases of Confidential for Project/CR releases.
• Analyze, Build and Testing of multiple system components of REGS/IMART applications.
• Involved in Performance Tune of SQL queries through explain plan and creating relevant indexes.
• From the business requirements developed Logical & Physical Data models using Erwin Data modeler
• Worked with SME’s and business managers to understand the source system.
• Prepare design documents specifying the variousfunctional/business logics, pros and cons of the different approaches with suggestions of the best approach.
• Design an end-to-end PL/SQL packages involving complex data load from external tables / remote Materialized views/sources, validating the data load, pulling the structure to REGS application and performing complex revenue rate calculations by using various lookups and loading the estimated vs actual billing amounts to Settlement tables and finally ftp-ing the generated GL endeavor files to Mainframe folders for People soft to pick-up.
• Prepared reusable Settlement process flow/setup/execution self-user guide for faster development and standardization.
• Creating detailed design document and coordinating on assignments for offshore team.
• Conduct weekly meetings on assignments and preparing/presenting status reports to client.
• Completely tracking the delivery and problem solving of any issues encountered in the development cycle.

Environment: Oracle 11g, Advanced PL/SQL, SQL Navigator, Harvest, Mainframe Scheduler, Linux Shell Scripting, Clear Quest, Putty, WSFTP Pro, UltraEdit

Confidential, Auburn Hills, MI

JDA Oracle Application Developer

Responsibilities:

• Contribute as overall PL/SQL expert/SME on the project and contribute to solutions across several functional areas of the project.
• Creation of custom PL/SQL (Oracle 11.2) routines for extensions/reports to implement business rules and business process integration requirements.
• Analyzing complex functional designs, defining technical approach, documenting approach accurately in technical designs, and building high quality PL/SQL routines

Environment: JDA OM, Oracle 11g, Advanced PL/SQL, Toad, SQL Developer, Autosys Scheduler, Dimensions.

Confidential, Woonsocket, RI

JDA Oracle Performance Tuning Specialist

Responsibilities:

• Technical Tuning of JDA extensions such that the extensions that run as part of JDA batch perform optimally in order to meet the CVS business SLAs.
• Oracle SQL Tuning by running explain plan, create partitions/indexes and gather statistics, using bulk collect etc.
• Benchmarking of extension run times before and after the performance change.
• Packaging and coordinating the code migration of changed extensions to production.
• Documenting the changes made.
• Apart from this also involved in Production Batch Support for extensions involving monitoring / recommending work around / solution for resumption of the Batch.
• Have worked so for two releases Wave 0 and Wave 1 bringing down the Batch to complete 3-4 hours before SLA by continuous identification and validation/implementation of performance changes on an ongoing basis which has been well received by the Client IT Lead.

Environment: Oracle 11g, Advanced PL/SQL, Toad, CONTROL-M Scheduler, SVN Version Control, Unix Shell Scripting.

Confidential, Houston, Texas

Application Support/Maintenance

Responsibilities:

• I was basically responsible for driving and leading the support and maintenance of PDD, Mariner & Portfolio Manager applications in the form of Remedy / SWIFT tickets and Enhancements from onshore Houston, Texas.
• Involved in the creation of Monthly SLA reports Remedy / SWIFT.
• Create detailed requirements document, screen mockups for Offshore for new requirements.
• Request for database refresh of development and QA environments, when required.
• Yearly Funding and Budget data upload.
• Disk space management in Production server.
• Assign / review & testing of SWIFT tickets from offshore team.

Environment: Oracle 11g, Advanced PL/SQL, Toad, Omniworks, Dimensions

Confidential

Data Conversion Developer/Lead

Responsibilities:

• I was part of MDM / Greenstone & Chargebacks Release were my primary responsibilities include creating estimation, create and update plan activities, & driving the completion of conversion deliverables from end to end viz. organizing requirement analysis / FD meetings, preparing schedule for TD / development / Mock conversions / conducting demos / UAT sign-off and finally deployment for production release.
• Also extensively involved in the creation of Contracting, Membership, Product and Chargeback PL/SQL packages using ETL approach of reading the data from legacy database/files, writing mapping/conversion logics/lookups, data cleansing and loading to staging and validating the data, loading unprocessed records to log table for analysis and then finally triggering the load from staging to target CARS application.
• On the performance front, was involved to larger extent on performance tuning the Data Conversion Packages using Oracle hints, indexing, gather statistics, rewriting the code to use bulk collect etc to make the program run faster

Environment: Oracle 11g, Advanced PL/SQL, Toad, Unix Korn Shell Scripting, Dimensions, VSS, Clear Quest, Microsoft Project, Microsoft Visio, Sharepoint

Confidential

Accounts Payable Module Lead

Responsibilities:

• I was playing the key role of Accounts Payable Module Lead having subject matter expertise (SME) as to the day-to-day/monthly/year-end activities of the Confidential in Computron.
• Has met 100% SLA for the Tickets logged.
• User guide/Reference in place for resolved tickets.
• Completed Causal Analysis Report for the AP module and identified/resolved frequently occurring tickets.
• Trained and equipped resources on AP functionality.
• Had an opportunity to work at onsite New York on projects related to Computron Application for about 6 months (2008). Project responsibilities includes discussion with the customer on requirement understanding, analysis of impact, preparation of functional/technical spec, review and coordination for production release and support.

Environment: Oracle 9i, Advanced PL/SQL, Toad, Unix Korn Shell Scripting, C++, Dimensions, Tivoli Batch Scheduler, SharePoint.

Confidential

Support/Customization Oracle Developer

Responsibilities:

• Orders (shipments) that have been initiated to "participants (PAX)".
• Returns of those shipments (or parts thereof).
• Coordinate the support and customization activities in the form of design and development of intermediate database tables and reports to support auditing the automated accounting operations.

Environment: Oracle Apps Forms/Reports 10g, Oracle 10g, TOAD.

Confidential

GL Module Lead

Responsibilities:

• Carrying out complete design of the requirement by creation of Forms/Reports, tables, constraints, triggers, procedures, packages, functions, and views etc.
• Managing sub-teams by assigning appropriate work and getting them done.

Environment: Oracle Forms/Reports 4.5/6i/9i, Oracle 9i, TOAD.

Confidential

Oracle Customization Developer

Responsibilities:

• Confidential, Inc - Involved in the comprehensive development of taxation module for US geography in conjunction with payroll module.
• Confidential, Oman - Involved in the customization development of Purchase Order Forecasting and automatic SO Generation Module.
• Confidential, Ghana - Involved in the customization development of Allocation and Over-Allocation of stock through Sales Order.
• Confidential, Nigeria - Involved in writing the pulling logic from Sales Order to Invoice. The purpose of this customization is to generate invoices using Sales Order as the base transaction. The entire details of the sales order including item details, expense info, discount info etc will be pulled into Invoice Transaction.
• As part of Customization, carrying out necessary design of the requirement by creation of tables, constraints, triggers, procedures, packages, functions, and views etc

Environment: Oracle Forms/Reports 4.5/6i/9i, Oracle 9i, TOAD.

Confidential

Oracle Maintenance and Implementation Support

Responsibilities:

• Confidential, Chennai - Involved in the implementation support of manufacturing module of Confidential &S. This is basically a manufacturing firm, which has its head office in chennai and manufacturing units located at Pondicherry and Pudukottai.
• Confidential Ltd, Bangalore - Involved in the Implementation Support of Confidential Limited. This is one of the biggest sugar manufacturing industry in India.
• Confidential LLC, Dubai - Confidential is a leading computer software and hardware distributors in Middle East. Involved in solving crucial issues such as apportioning of discount in Purchase Order, Comparison of Quotation, Pending Inspections, and Itemwise pending enquiries etc.
• Medical Stores Department, Tanzania - Medical Stores Department is the largest pharmaceutical distribution firm in Tanzania.Involved in the implementation support of Warehouse Module wherein the medicines are stores in batches in a large warehouse.
• As part of the maintenance team need to be proactive in solving the issues reported by the implementers/users of techno-functional in nature. Visits to client place for solving very crucial issues where the issue could not be simulated in the development center.

Environment: Oracle Forms/Reports 4.5/6i/9i, Oracle 9i, TOAD.

Confidential

Java Developer

Responsibilities:

• Be-there is an Event Registration System (ERS) where Events are Organised & placed. The Customer can Place an Event in the Website & the Subevents for the particular Main Event can also be organized. Other than the Event Handling the Customer can arrange for Housing, Travel arrangements & Even Rent-A-Car Facility for their Clients.
• Confidential is an Integrated B2X market place for the selling of excess inventory. The main component of this project is core dynamic engine, core offering engine and the customer side web interface. It has the supplier side web interface, where the suppliers can upload their excess inventory to get maximum value for their excess inventory. It has the Customer side web Interface, which can be configured according to Channel's Requirement.
• This is a prototype for AbuDhabi Supermarket. This is basically a typical website development with the site map, press release where you can download pdfs and word documents from webserver, news scroller, add banner where you can choose and add banner from a set of banners available into the rotating banner at the top of the website, feedback form and product catalogue.
• Developing entity beans, session beans and incorporating XML/XSLT in JSP for Event registration module.
• Deployment of entity beans and session beans in Weblogic Server.

Environment: Java 1.3 (JFC, I/O Streams, AWT, Applet, Swing), HTML, Javascript. Middleware - RMI & EJB1.1. Application Servers - Weblogic 5.1.0, JRUN