PROFESSIONAL SUMMARY:

• Over 15 years of experience in leading the development and maintenance of critical systems for various industries - Retail, Supply Chain, Manufacturing and others.
• Extensive experience Oracle Technology in the areas of implementation, migration, customization and technical support.
• Good domain knowledge in various functional areas of the Retail, Manufacturing Industry, Supply chain) and supporting corporate functions like Finance, HR and training.
• Proficiency in OM,AP, AR and Inventory modules of Oracle Applications and Oracle R12/ Oracle 11g/11i/10g/9i, PL/SQL and Forms & Reports 10g/9i/6i and Discoverer.
• Strong experience in leading the requirement gathering, technical design, development, testing, go-live and 24 X 7 production support.
• Expertise in handling large volumes of data including extraction, cleansing, messaging, loading and data migration for mission critical data.
• Widely worked and developed several workflows in UC4 scheduling tool for automating the workload of several processed like EP, Allocations and PMM.
• Strong analytical skills with excellent interpersonal and communication skills.

PROFESSIONAL EXPERIENCE:

Confidential

Lead Programmer Analyst

Responsibilities:

• Mapped business processes and implemented solutions for various Retail processes by interacting with business owners of Store Systems, allocations teams, HR, Payroll, and IT infrastructure teams.
• Ensured 24/7 Retail applications availability and supported needs of 500+ stores across USA
• Conducted Project / team meetings and guided the team until implementation.
• Point of contact for Business teams for Production issues, 11i projects, development, customization, testing, debugging and support of Retail Systems like PMM, Allocations, EP, ADP and Lawson HCM cloud.
• Analyzed and created detailed project plan for newer concepts like Bulk as pack of 1 and ASN for allocations, submitted to the manager for ROI.
• Customized the interfaces for EP, allocations, Lawson cloud and PMM
• Developed in Oracle, Infor Process flows, Shell Scripting, FTP/SFTP Scripting and Lawson BI modules including Infor Process flow and also scheduling the Retail business in UC4 tool
• Mass Mutual (401K) process.
• Involved in gathering the requirement from Payroll.
• Created the functional and Technical plan
• Developed the Interface for Mass Mutual using Oracle (SQL and PL/SQL), SQL * Loader and UC4.
• Released / Implemented this bug-free project to ADP
• Worked on the older SQL Server database to extract the required auditing report.
• Daily and weekly Activities include the following
• Recovering the missing poslogs for PMM from Store Systems
• Analyzing the reason for any blocked UC4 workflow and fixing them as required
• Helped Store Systems, Payroll and Accounting by analyzing the error in adhoc run of the reports if any and fixed / advised as required
• Analyzed the vertex data for Ecom sales and match it to the PMM Sales by loading them in separate Staging table.
• Customized the Infor Process flows for Lawson HR, PO imports and receipts.
• Retriggered the items in Inventory so that DC can bridge them through PKMS
• Updated the Size scaling and produced the report for footwear as required
• Worked with DW Team while resolving the backed / wrong dated poslogs.
• Analyzed and fixed the issue with data like date of Hire, Rate Info for ADP payroll

Confidential

Senior Data Analyst

Responsibilities:

• Worked and followed 100% agile methodologies to deliver required functionality as requested by the Client.
• Working closely with the Team to keep pace with development requirements
• Automated various Systems via UNIX shell scripts and packages to generate reports, alerts and GPS data exports.
• Modeled ERD schema designs to maintain the database using Toad ERD tool.
• Created a System to automatically scan OTA code updates to GPS devices and avoid costly mistakes.
• Utilized the established technical knowledge base as the foundation for the implementation approach Technologies used O racle PL/SQL, Unix scripting, SQL * loader and Java application base
• Analyzed and provided solutions / design for newer concepts like Update Rate, odometer, engine hours and there by improve the application based functionality.
• Actively Participated in Scrum meetings, Sprint planning and other agile based meetings in the project which helped to complete the tasks on time.
• Worked / Created and have also kept track of Jira tickets related to my application
• Developed workflows to support business processes.

Confidential

Technical Project Manager

Responsibilities:

• Mapped business processes and implemented solutions for various functionalities of Oracle Financial modules of Confidential .
• Closely communicated with the Onsite / offshore team for understanding and delivering the functional needs of the client
• Electronic Invoice - A custom AR invoice feed to third party print vendor, ESPP - Employee stock purchase project
• Involved in Requirement gathering and Functional Requirement document Preparation like BR100, MD50, MD60, MD70
• Lead of a 10 member team by providing Technical support and also preparing project plans for ROI to the client
• Responsible for quick analysis and resolution of critical issues
• Worked extensively on a solution to implement manual ad-hoc Wire payments using Oracle Workflow, AME and Oracle Forms.
• Worked on supporting the business on activities encompassing the entire O2C and P2P cycles
• Utilized technical knowledge base as the foundation for the implementation approach using technologies like Oracle 11i, Oracle Forms/reports, interfaces, oracle workflows and extensions using PL/SQL, Reports, Unix, SQL * Loader and Pro*C
• Made us of Pivot table for distributing the work load with the offshore team
• Communicating with the Client / User for the purpose of clarifying and guiding requirements and questions related to development and testing activities
• Developed Training documents for Team members and users.
• Working in BMC Remedy to create and Keep track of the tickets.

Confidential

Sr. Software Engineer

Responsibilities:

• Delivering Banner functionality as requested by the client and directed by the Team Lead
• Working closely with the Team Lead to learn and keep pace with development requirements
• Utilizing the established technical knowledge base as the foundation for the implementation approach by learning Banner and also developing the requirement using oracle 11i, Forms and Reports.
• Worked on web-based tracking system (JIRA) to create, address and close tickets
• Using Talend to perform data migration activities.

Sr. Software Engineer

Confidential

Responsibilities:

• Provided an solution architecture for the requirement involving Oracle
• Developed applications using coding and UI guidelines which included:
• SQL Scripts, Stored Procedures, Triggers and Views.
• Development/Enhancement/Fixing the reported bugs in Oracle Forms and Reports as per user requirement.
• Coding as per the coding standards of the company and Tuning the SQL queries as per the requirement of the client
• Learnt and adapted new technology (JAVA) to solve the issues in one of the applications.
• Providing Technical Support to the Team as and when required.

Confidential

Tech Lead and Module Leader

Responsibilities:

• Prepare Function based and also Complexity point estimates for all the projects to accurately forecast project delivery dates.
• Written detailed Functional and Technical requirement plans of SIS system
• Provided an solution architecture for the SIS System involving Oracle
• Completed the design for the system according to their design standards
• Guided a team of developers to develop applications using coding and UI guidelines which included:
• SQL Scripts, Stored Procedures, Triggers and Views.
• Development/Enhancement/Fixing the reported bugs in Oracle Forms and Reports as per user requirement.
• Coding as per the coding standards of the company and Tuning the SQL queries as per the requirement of the client
• Learnt and adapted new technology (JAVA) to solve the issues in one of the applications.
• Lead of a 10 member team by providing Technical support and also preparing project plans for ROI to the client

Confidential, Rochester, NY

Oracle Applications consultant

Responsibilities:

• Involved in the analysis and design for streamlining of Order flow thereby increasing the efficiency of order fulfillment process.
• Participated in the focus group to improve the shipping accuracy to end customers.
• Automated the Auto Lockbox process using PL/SQL Procedure and Unix Shell Scripts
• Implemented Chase Paymentech Credit Card Process for Multi Language support
• Converted the Optio reports into XML reports.
• Involved in personalization of Oracle Forms as per the requirement of the client.
• Performed the setups for Order Management and procurement.
• Involved in modifying the Custom.pll to customize the LOV of a form.
• Involved in customizing Order Header and Order Line Workflows.
• Created Concurrent Requests as per the requirement.
• Created Periodic alerts and schedule the alerts in order to fire and send mail as required.
• Involved in modifying the dependencies program to enable/disable the dependency of an item.
• Created Profile options to remove the hard coded value in the program.
• Wrote technical design documents for conversions, extensions, interfaces, and reports.
• Involved in debugging and fixing the issues encountered in the Workflow.
• Helped in designing custom data models that integrated with Oracle Applications.
• Developed and modified reports, interfaces, oracle workflows and extensions using PL/SQL, Reports and Pro*C under Oracle 9i, Oracle 9iAS.
• Involved in developing / modifying the Oracle reports for any issues / enhancement.

Confidential

Oracle Technical Lead

Responsibilities:

• Mapping, Development, Testing, Implementation of the Oracle Inventory to TCE from Oracle Applications.
• Interacted with business users to create solution design documents.
• Designed and defined inventory key flex field structure, inventory structure, organization setup, organization calendar, items and exceptions.
• Developing new reports to find the exception records.
• Developed the Aging Report for the client requirements.
• Transferred the locator data to the Oracle Apps using Front end Data Loader.
• Identifying the customizations as required.
• Developed and maintained custom forms and associated packages, triggers, table handlers, and workflows.
• Responsible for providing the data extract/mapping from legacy system (BPCS) as per the requirement of Oracle Application.
• Developed outbound interface for Inventory item using UTL file.
• Customized the existing Purchase Order report in XML reports.
• Tuning the queries for better performance.
• Prepared common validations rules as part of conversion programs to increase data accuracy before migration to oracle.
• Wrote UNIX shell scripts to automate the deployment process.
• Interacting with the customers at onsite to get the requirements and develop/ modify the new/ existing programs with good customer satisfaction.