Senior Manager Third Party
Resume:
Vivek Gupta
Oracle Technical Lead
Contact +917****-*****, 982**-***** **********.*.*****.**@*****.***
Profile
IT professional with 16 years of experience in application development, implementation and support projects. Expert in oracle technologies like Oracle SQL & PL/SQL, Oracle Forms 6i & 10g and Reports 6i & 10g.
Currently working as Technology Lead at Zouma Pvt Ltd, Noida responsible for Works closely with business stakeholders to receive new requirements, assess, plan and estimate, prepare roadmap proposals, provide status on iterative releases, and make design decisions throughout the development lifecycle (SDLC).
•IT professional with 16 years of experience in core Oracle11g database programming & Oracle Applications (11i & R12) development, implementation, data migration/integration and support projects. In-depth knowledge of Oracle SQL, PL/SQL programming concepts, designing data-models (E-R diagrams), building business extensions (using Reports 6i & 10g, Workflow Builder 2.6 and Forms 6i & 10g).
•Experience encompassing wide range of skills on technical (RICEW components) and in business & systems analysis spanning over several industries/functional areas (Process Manufacturing, Supply Chain, Travel Services, HRMS and Order Invoicing).
•Extensive knowledge on various phases of project life cycle (SDLC) – Requirement Gathering, Analysis, Design, Development, Customizations/Enhancements and Implementation of various modules of business applications –Manufacturing, Services, HRMS and Payroll.
•Accountable for the overall planning, execution and success of complex technical projects, as well as, planning for the resources and tools to deliver against the approved roadmap.
•Drive all technical aspects of the development including technical requirements definition, design, implementation, unit testing, and integration. Oversee detailed designs, implementation, and test plan reviews to ensure high quality deliverables.
•Gathers technical requirements with the larger team to define high level architecture, collaborate with senior developers across the team on design solutions. Review and approve the detailed designs.
•Proficient in analysing and translating business requirements to technical requirements and architecture.
•Good knowledge of Order-To-Cash (OTC) and Procure-To-Pay (PTP).
•Strong database skills and development knowledge.
•Experience in leading and managing teams.
•Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
Skill Set
Development Tools: Oracle SQL, PL/SQL, Reports 6i & 10g, Forms 6i & 10g, Workflow Builder 2.6, Toad, WINSCP and Putty
ERP Tools: Oracle Applications R12, 11.5.10
RDBMS: Oracle 10g, 11g, FoxPro, Microsoft Access 2000
Languages: Oracle SQL, PL/SQL, UNIX scripting, XML
O/S: Windows NT/2000 Server
•Projects Experience
Organization: - Zouma Creative Studio Pvt Ltd, Gurgaon, India
Designation: - Senior Manager
Role: - Module / Team Lead
Duration: - July-2023 – Present
As Oracle Apps Technical Consultant, my job profile includes: - • Gather and analyse business requirements from core users
•Responsible for the design and development of RICEW components
•Writing Stored Procedures, Functions, Packages & Triggers using SQL Plus and PL/SQL
•Performing AOL/Setups/Configuration tasks in Oracle Applications with the use of Application Developer/System Administrator
•Create Concurrent Programs/Request Sets to address new/custom business functionalities
•Create/Manage AOL components – Value Sets, lookups, Profiles, FND MESSAGES
•Create/Modify/Personalize Oracle Forms 6i & 10g – registration in the application (Form – Function – Menu – Responsibility)
•Extensions (Forms) development activities –
Organization : - IRIS Software, Noida, India
Designation : - Technology Lead
Role : - Module / Team Lead
Duration : - Aug-2022 – Aug- 2023
I directly manage the relationship with the Business Analysts team to gather new requirements and enhancement requests, assess and provide estimates and provide a product roadmap for 2-3 years. Additionally, my other priorities include:
•Building a high-performance team, manage attrition, backup plans, and ensuring a thorough training curriculum for new team members.
•Responsible for extended support to Operations team and End-User trainings.
•Supporting Account team by addressing queries on new proposals with prospective customers.
Organization: - NIIT Technologies Limited, Gr. Noida
Designation: - Technology Specialist
Role: - Module Lead
Duration : - Jun-2018 – Aug-2022 (4 year – 2 month)
NIIT Technologies is an IT Solutions Partner providing customers solutions for IT needs specializing in Oracle Applications enhancements and support projects. I joined NIIT Technologies in Jun 2018 and was for post-production, enhancement and support projects.
As Oracle Apps Technical Consultant, my job profile includes: -
• Gather and analyse business requirements from core users
•Responsible for the design and development of RICEW components
•Writing Stored Procedures, Functions, Packages & Triggers using SQL Plus and PL/SQL
•Performing AOL/Setups/Configuration tasks in Oracle Applications with the use of Application Developer/System Administrator
•Create Concurrent Programs/Request Sets to address new/custom business functionalities
•Create/Manage AOL components – Value Sets, lookups, Profiles, FND MESSAGES
•Create/Modify/Personalize Oracle Forms (6i & 10g) – registration in the application (Form – Function – Menu – Responsibility)
•Extensions (Forms 6i & 10g) development activities –
•Custom Forms for Revenue Accounting.
•Sales Check.
•Sales Prorate.
•Refund
•Flown
•Developed .jsp pages for different schemes.
•Create new reports (XML & BI Publisher Report) and register in the application.
•Created PL/SQL Packages and register in the application as scheduled concurrent program.
•Developed (WebADI) for uploading scheme data into the oracle system in the specific layout.
Organization: - Path Infotech Ltd, Noida
Designation: - Oracle Applications Technical Consultant
Role: - SCM Sr. Technical Consultant at Electronic goods manufacturing client in Noida
Duration : - Feb-2016 – Jun-2018 (2 year – 4 month)
Path Infotech is an IT Solutions Partner providing customers solutions for enterprise IT needs specializing in Oracle Applications enhancements and support projects. I joined Path Infotech in Feb 2016 and was moved to onsite at electronic goods manufacturing client using Oracle R12 (release 12.1.3) for post-production, enhancement and support activities.
As Oracle Apps Technical Consultant, my job profile includes:- • Gather and analyse business requirements from core users
•Responsible for the design and development of RICEW components
•Writing Stored Procedures, Functions, Packages & Triggers using SQL Plus and PL/SQL
•Performing AOL/Setups/Configuration tasks in Oracle Applications with the use of Application Developer/System Administrator
•Create Concurrent Programs/Request Sets to address new/custom business functionalities
•Create/Manage AOL components – Value Sets, lookups, Profiles, FND MESSAGES
•Create/Modify/Personalize Oracle Forms 6i & 10g – registration in the application (Form – Function – Menu – Responsibility)
•Extensions (Forms) development activities –
•Scheme Registration Form
•Flat Scheme
•Target Scheme
•Growth Scheme
•Slab Scheme
•Scheme Modification (Includes modification in the existing scheme, scheme extension, scheme termination).
•Region Master
•AM BM Mapping
•Developed .jsp pages for different schemes.
•Create new reports (XML & BI Publisher Report) and register in the application.
•Created PL/SQL Packages and register in the application as scheduled concurrent program.
•Developed (WebADI) for uploading scheme data into the oracle system in the specific layout.
Organization: - LONAR Consulting, Pune
Designation: - Oracle Applications Technical Consultant
Role: - SCM Sr. Technical Consultant at Wire & Cables manufacturing client in Mumbai
Duration: - Feb-2015 – Feb-2016 (1 year)
LONAR is an IT Solutions Partner providing customers solutions for enterprise IT needs specializing in Oracle Applications implementation and support projects. I joined LONAR in Mar 2015 and was moved to onsite at wires and cables manufacturing client using Oracle R12 (release 12.1.3) for post-production, enhancement and support activities.
As Oracle Apps Technical Consultant, my job profile includes: - • Gather and analyse business requirements from core users
•Responsible for the design and development of RICEW components
•Writing Stored Procedures, Functions, Packages & Triggers using SQL Plus and PL/SQL
•Performing AOL/Setups/Configuration tasks in Oracle Applications with the use of Application Developer/System Administrator
•Create Concurrent Programs/Request Sets to address new/custom business functionalities
•Create/Manage AOL components – Value Sets, Profiles, FND MESSAGES
•Create/Modify/Personalize Oracle Forms – registration in the application (Form – Function – Menu – Responsibility)
•Extensions (Forms 6i & 10g) development activities – •Supplier Conversion Form
•Price List Upload Form
•Lot Rewinding/Split Form
•Barcode Print Form
•IRISO Form
•Development of custom workflows –
•Order Header Workflow (OEOH) – to send decision notification before order booking activity
•Lot WIP Completion Notification to Quality Users
•Create new reports (XML & Report Builder) and register in the application
•Create HOST programs for the Item-Assignment functionality to load data files to application
•Create SQL/Loader programs for the data conversion objects – Items, Item Categories and Suppliers
Organization: - Idealogic Software Solutions Pvt. Ltd., Indore
Designation: - Software Developer
Duration : - Jul-2012 – Feb-2015 (2 year – 8 month)
Idealogic Software Solutions is an IT organization specialized in delivering software solutions for Travel & Tour organizations. The organization has dozens of clients primarily spread across India, US and Malaysia.
Idealogic is mainly engaged in developing & management of Websites and Database operations.
As Oracle Software Developer, my job profile includes: -
•Designing and develop the various enhancements on the existing software solutions and new requirements given by the client.
•Requirement Gathering: taking requirements from the clients for enhancements and bug fixes.
•Writing PL SQL Packages/Procedures/Functions/Triggers to complete the development on new components.
•Create or modify Oracle D2K reports based on various requirements. Created many complex reports including Customer Travel History, Print Itinerary report.
•Using UTL_FILE utility performed the data migration for various travel information like maps & routes, foreign currency exchange rates and others from external sources (.dat files) to Oracle.
•Used SQL LOADER to upload the information into the database tables.
•Create/modify Oracle 10g Forms to interface between customers and various travel options.
•Automating data extraction along with designing, developing and testing the SQL queries which meet business objectives.
•Used UTL_MAIL and UTL_SMTP packages to send emails to establish various alert mechanisms for customers and timely reporting. Also, used extended the program in various other modules/business functions like Online Booking and Tickets/Itinerary Shipments & Tracking.
•Testing for the new services configured for websites and required database support.
•Providing technical support in case of any downtime under guidance of website administrators.
•Timely application & database Backup & Restoration, when needed. Call logging, ticket management and maintenance support for client.
Organization: -Navjivan Natural Products, Indore
Designation: - Software Engineer
Duration : - Nov 2004 to May 2009 (4 years - 6 months)
Navjivan Natural Products is a well-known brand in the field of manufacturing quality organic products, soil conditioners, quality liquid fertilizer and pesticides. The organization has its manufacturing unit setup at Devguradia Industrial Area, Indore. Navjivan Natural Products has multiple softwares being used for various business operations like manufacturing, sales, invoices, customer & supplier management, employees HRMS and Payroll system.
With organization having majority of these operations (primarily HRMS, Customers Order Management, and Invoicing) supported via Oracle based applications, some other use standalone applications built in MSAccess and MS-Excel (Accounting functions). During my 4.5 years at Navjivan, I worked on multiple areas of the business including supporting Oracle software.
The Job Profile Includes: -
•Coordinating the team and modules which helps to integration of the project.
•Using Oracle Based Application to generate Reports on the basis of requisite data, which helps Client in their Decision Making in Purchasing, Inventory, Invoicing and Payments activities.
•Create/Design & deliver monthly, weekly & daily dashboards for auditing activities/operations.
•Responsible for working with IT teams for automating day to day operational workflows in Oracle.
•Support in testing and implementing new patches.
•Purchase Returns Report: Developed report for all the purchase returns account with their billing amounts, date of transaction and Item Number.
•Inventory Items Reports: Created a report to display a list of Lot controlled items, Serial controlled items and items with no lot control.
•Open Invoices Report: Developed this very critical and important report to list out all the open invoices still not fully/partially paid by Customers.
•Created complex reports including Print Paycheck report for the client to also perform DML (INSERT to custom table to maintain actual salary payments) operations to maintain pay details for various contractors/employees.
EDUCATION QUALIFICATION
•B.B.A. from Manav Bharti University, Solan, H.P. in 2012
•B.Sc. from University of Technology and Science (UTS), Raipur in 2004
•Passed Higher Secondary Certificate Exam from M.P. Board
•Passed Senior Secondary Exam from M.P. Board
PERSONAL PROFILE
Date of Birth: 19th Aug 1981
Marital Status: Married
Nationality: Indian
Sex : Male
Languages Known: English, Hindi
Contact this candidate