Oracle Data
Resume:
AMIT BASU
adkqod@r.postjobfree.com:adkqod@r.postjobfree.com
Over 15+ years of IT experience in Oracle Applications (11i & R12). Experienced in implementing and post deployment support of Oracle Applications.
Highest Education Level Bachelor’s degree in Engineering
Current Location Denver CO, USA
Visa Status H1B
Technologies /Tools:
Oracle Applications: Oracle Applications 12.x/11i/11.x/10.7, GL, AP, AR, FA, Cash Management, PO, OM, SCM, INV, HR and Systems Administration.
Software: Oracle 9i/8i/8.x, Reports 6i/3.0/2.5, PL/SQL, Bi Publisher
Programming Languages: SQL, and PL/SQL
Resume Details
Senior Analyst with a proven track record of managing and delivering complex IT projects. Over 15+ years of IT experience specializing in maximizing the functionality of Oracle 11i and Release12i E-Business Suite. Possesses both functional and technical knowledge of complex Financial, SCM and HR systems. Extensive experience in Implementation, Migration, Customization, Production support of various modules in Oracle Applications with major focus on Financials - GL, AP, AR, Cash Management, Fixed Assets, Order Management, Inventory, HR and Purchasing. Experienced in Procure to Pay (P2P), Order to cash (O2C) life cycles and Supply Chain business flows.
Professional Experience:
Arrow Electronics, Denver, CO, USA Senior Analyst: Feb2013 – Present
Arrow Electronics is an American Fortune 500 company headquartered in Centennial, Colorado. The company specializes in distribution and value-added services related to electronic components and computer products.
I am involved in the following activities:
Involved in the Development and Implementation of various B2B Interfaces in Financials, OM, SCM modules and delivering end-to-end B2B business solutions as required by Arrow’s trading partners.
On boarded various EDI and RosettaNet trading partners to enable Arrow to exchange messages with them.
Involved in the EDI Implementation for US and Canadian Customers for various EDI formats like 850, 855, 856, 832, 845 & 810 Invoice transactions.
Developed an integration plan for data from a legacy system, set-up invoices, debit and credit memos, customized dunning letter and the statement cycle in the Accounts Receivable module.
Analyze and research EDI transaction error resolutions.
Develop, map, test and implement EDI documents.
Monitor daily EDI processes for successful execution.
Provide technical and business support for EDI and RosettaNet partners.
Involved in various Arrow’s initiatives for onboarding new Partners and Suppliers using B2B API technologies. Built various APIs to process data and ensure seamless functioning of various systems. Usage of custom-built APIs ensured seamless communication between various applications providing ease of doing business and benefitting Arrow’s Partners.
Built new APIs to enable Arrow to send Invoice, ASN, Order Status, Pricing and Inventory data to its Resellers in a timely manner providing a better turnaround time for Partners.
Involved in building Dashboard & B2B Tracker applications for providing important metrics related to EDI and API transactions. This is helping Business in identifying what is working and what can be improved based on the numbers provided by the metrics generated.
Provide support during month-end, quarter-end and year-end closing to ensure smooth closure during these critical times.
The J.M. Smucker Company, OH, USA Lead: July 2011 to Feb 2013
Lead for upgrade of Oracle Application from 11.5.9 to R12 Procure to Pay (P2P), Financials, SCM and OPM. Managed a team of 8 consultants.
Key Accomplishments:
Worked on the development of custom Interfaces, Data Conversions, BI Publisher Reports in AR, PO, AP and GL.
Designed solutions to enhance standard Oracle flows for order to cash, procure to pay, inventory, credit card transactions and GL accounting processes for this rapidly growing specialty retailer that handles over 3,000 transactions per day. Implemented automatic bank reconciliation functionality in CM and auto lock box functionality in AR.
Involved in Customer Conversions to load Customer details into HZ tables using TCA APIs.
Reviewed all implementation deliverables both functional and technical. Provided feedback to Program Management Office (PMO), stakeholders, and system implementers. Deliverables covered all phases of the systems lifecycle including requirements, gap-fit analysis, design documents, interface design, data conversion, User training, and User Acceptance test plans.
Managed post-implementation P2P production support.
AIM Documentation.
Oxygen, FL, USA Tech Lead: May 2008 to June 2011
Key Accomplishments:
Involved in the implementation of Oracle EBS Financial modules in GL, AP, AR, Cash Management and Fixed Assets (Oracle Release 11i).
Reviewed all implementation deliverables both functional and technical. Provided feedback to the Program Management Office (PMO), and stakeholders. Deliverables covered all phases of the systems lifecycle including project plan, requirements, gap-fit analysis, design documents, interface design, data conversion, User training, and User Acceptance test plans.
Developed User training guides, led User training sessions.
Darigold, Seattle, USA Tech Lead: Aug 2007 – May 2008
Managed the Oracle upgrade from 11.5.10.2 (11i) to R12 (12.0.X). Module - Oracle HR
The Project involved migration of existing Darigold’s regional instances into a single global instance in a multi organization structure. The project was to upgrade from 11.5.10.2 (11i) to R12 (12.0.X). The regional instances already had minimal HR modules implemented but in a single global instance all local regions would share single instance and would have all Oracle modules implemented.
I was involved in the following activities:
Gather technical requirements and detailed interface and conversion specifications, including data mapping.
Implemented the following in Core HR Area for EMEA Business Group. Set up work structures, key flex fields, segments, and value sets. Created EIT’s for capturing additional personal and assignment details.
Set up of absence types, elements, and links to be used in the PTO plans for their vacation, holiday, and sick plans.
Complete application setups (Elements, Links, Payment Methods, Lookup Types, Global Values, etc.)
Create and/or modify Oracle FAST FORMULAS used to facilitate to calculate the employee PTO accruals.
Designed and implemented Payroll set-up the creation of the earning and deduction elements and the necessary links for eligible criteria, define payroll, Payment method, registered the concurrent programs to their corresponding request group.
Created custom menus, responsibilities, and security profiles to be used in the functional areas (Core HR, Payroll, Absence Management)
Set up of security profiles, responsibilities so that different users have different menu structures and functions.
Implemented Oracle HRMS modules Core HR, Advance Benefits, OTL and Oracle Payroll. Assisted in Business process mapping and prototyping, gap analysis, solution design, HRMS setup, testing and user training.
Worked cross-functionally with IT and LOB teams to ensure effective execution of Oracle HCM software such as Oracle HCM Fusion & Taleo Applications.
Expertise in the following Oracle HRMS modules and concepts. Core HR, Oracle Payroll, Oracle Time and Labor (OTL), Approval Management Rules (AME), Personalization, Oracle Benefit and Fast Formulas.
Worked on Fusion Workforce Deployment (Global HR) and Workforce Development (Talent Management).
Involved in the design of RICE components (Reports, Interfaces, Customizations and Extensions) as per business needs.
Involved in the design of new fast formula for new salary, bonus, and loan elements.
Prepared functional and technical specification documents.
Performed unit testing and integration testing.
Involved in Defect resolution.
Coordinated with the offshore development team based out of India.
Understand the existing setups and new payroll requirements.
Create new elements and their setup.
Was involved in the Setups of all organizations, locations, elements, element links, costing, job titles, payrolls, bank details, cost centers, worker’s compensation codes/rates, Global Values, Application Utility Lookups, Security Profiles and reports within the Oracle HRMS module for all applicable localizations, Setup HR related Descriptive Flex Fields, Key Flex Fields, Validation Sets, Special Information Types, Security Profile attachments, users, responsibilities, request sets and menus under the System Administrator responsibility.
Was involved in moving employees from old payment method to new oracle Direct Deposit to pay through bank.
Developed customer specific reports and preparing MD050 for the same.
Resolved post-go live issues and providing support at client location.
Involved in gathering the customer requirement to implement new functionality in OTL.
Created new elements and their setup to run payroll.
Involved in the setup of new absence types in oracle self-service module.
Gathered requirement to develop custom interface to support OTL module.
Oracle Consulting, Senior Analyst May 2004 – June 2007
Client: Network Rail, UK
Key Accomplishments:
●Managed the implementation of Oracle EAM Plant Maintenance for Network Rail, UK.
●Established precise implementation project plans to ensure all critical path/project milestones were completed on schedule. Monitored project budget, milestone and earned value and reported status to client executives and senior management.
AIM documentation.
Client - Oracle Corporation, Bangalore India
Key Accomplishments:
Responsible for managing the development of Localization Reports using BI Publisher for Release 12i. The project was part of Oracle Development team initiative to make the country specific localization Reports Release 12 Compliant.
Deliverables covered all phases of the systems lifecycle including requirements, gap-fit analysis, BR-100s, interface design, data conversion and test plans.
Client: Tech Lead, Sydney Airport, Australia
Key Accomplishments:
Managed the Implementation of Oracle Release 11i – Financials and SCM for Sydney Airport, Australia.
Managed a team of 6 resources to configure, customize, test and deploy on a tight schedule (3 months from inception to go-live).
Client: Tech Lead, Bunnings Warehouse, Australia
Bunnings Warehouse is Australia's largest household hardware chain, with stores in Australia and New Zealand. The chain is owned by Wesfarmers Limited. Bunnings was founded in Western Australia.
Bunnings embarked on a broad initiative to improve retail planning and optimization by implementing various Oracle Retail systems. I was engaged to lead the project teams for several streams on this successful project.
Overall lead of a large cross-functional team organized into four execution teams enabling a large and complex implementation from inception to roll-out
Functional areas included merchandise financial planning, size optimization, demand forecasting, inventory optimization, and integration with existing Oracle retail systems
Carefully managed stakeholder communications and interactions in a politically charged environment
Responsible for overall analysis, design, build (including offshore), quality assurance and eventually roll-out
Manage and lead the execution of large scale back-end systems projects
Iterate and drive the improvement of the customer facing store interfaces
Implemented support and operational processes to increase reliability and efficiency
Client: Senior Analyst, DHL, Australia
Key Accomplishments:
●Managed the Data Migration from legacy systems to the base tables in Oracle Applications for different modules like Account Receivables, General Ledger, Account Payables and Cash Management.
●Responsible for the Conversion of Financial data from legacy systems into Oracle EBS.
●System administration.
●Modules implemented: General Ledger (GL), Payables (AP), Receivables (AR), Purchasing (PO), Assets (FA) and Project Costing/Billing.
Client: Tech Lead, Qantas Airlines, Australia
Key Accomplishments:
●Managed the Data Migration from legacy systems to the base tables in Oracle Applications for different modules like Account Receivables, General Ledger, Account Payables and Cash Management. There were around 80 interfaces, inbound and outbound interfaces, which were built as part of the implementation process. General Ledger, Accounts Payables, Accounts Receivables, Fixed Assets and Cash Management modules were implemented.
●AIM documentation.
●Coordinated a team of 17 IBM resources to develop, execute and validate test scripts and test data and document test results. Fostered an atmosphere of accountability and recognition among team, significantly improving on-time delivery.
General Electric, USA Senior Analyst, June 2003 – May 2004
Client: GE Plastics, USA & GE Global Research, USA
Key Accomplishments:
●Modules implemented EBS Financials and SCM.
●Managed the full scope of implementing Oracle E-business Suite. Developed and implemented an aggressive project plan while managing client expectations.
●Managed Interfaces and Data Conversion in various EBS modules.
●Developed and delivered Oracle Financials and Procurement user training courses.
KPIT Cummins, USA Analyst, Nov 2002 – Jun 2003
Key Accomplishments:
Implementation of Oracle HRMS for Cummins USA. I was involved in the development and support of custom interfaces and data conversions.
Zensar Technologies, Analyst, Oct 2000 – Nov 2002
Involved in the upgrade of Oracle EBS from 10.7 to 11i for one of Zensar’s client.
Contact this candidate