ERP DEVELOPMENT ARCHITECTURE MANAGER/TECHNICAL LEAD
Focused and detail-oriented professional offering exceptional troubleshooting skills and a talent for architect, design and developing innovative solutions to unusual and difficult problems. Strong strategic thinker and team builder.
Wide experience in the field of Information Technology, with 16+ years in oracle, over 9 years' experience with Oracle E-Business Suite/Applications involving architecture, design, development, deployment. Experience in managing off-shore team for project development with team based management style. Experienced with Q2C and P2P cycle. Managed and implemented small/medium scale projects. Implementation experience using AIM and Hybrid (AIM + Custom) Methodology. Good understanding and experience on database administration activities.
Oracle EBS R12 (12.1.3) -- Product Information Management (PIM/APC), Order Management (OM/OE/ONT), Configurator (CZ), Shipping Execution (WSH), Purchasing (PO), Oracle Process Manufacturing (OPM), Inventory (INV). Oracle Applications Framework (OAF), Application development Framework (ADF), General Ledger (GL), Accounts payables (AP), Account Receivables (AR).
Databases: Oracle 7.x/8i/9i/10g/11g
Middleware: Oracle SOA 11g (11.1.1) and 12c (12.1.3), Oracle WebLogic 12, 12.1.3.
Operating Systems: Windows 2000/NT/XP, HP-UX, Red Hat Linux, Oracle ExaData/ExaLogic (X3/X4).
Languages: SQL, PL/SQL, C, JavaMiddleware: Oracle SOA 11g (11.1.1) and 12c (12.1.3), Oracle WebLogic 12, 12.1.3.
Tools: Oracle Forms3.0/4.5/6i/10g, PL/SQL, SQl*Plus, Report 2.5/3.0/6i/10g, SQL*Loader, TOAD, Serena Team track, Oracle Discoverer, Quest Stat 4.5/5.5, XML Publisher, Oracle JDeveloper 10g, Oracle Workflow Builder, HP-PPM, BMC Remedy.
Version Control : PVCS, SVN, DimEx
Languages: SQL, PL/SQL, C, Java
TRAINING & CERTIFICATION
Oracle Product Information Management (PIM) fundamentals from Oracle University.
Oracle e-Business Suite System Administration Fundamentals (Oracle Online Training).
ERP Development Architecture Manager/Technical Lead07/2014 to 02/2016Ingersoll Rand IRDavidson, NC
As a technical manager/lead, lead a team of 6 off-shore and on-site resources, managing team budget, resource hiring, mentoring.
Drove continual improvement to system architecture by refactoring solutions.
Architect and design Integrations, common development frameworks and utilities used by RICE (Reports, Interfaces, Conversions, and Enhancements or Extension) development teams.
Define procedures, standards and guidelines for RICE development teams.
Provide architectural and technical direction to RICE teams on complex RICE solutions.
Collaborate with functional and technical team architecting system interfaces, designing custom solutions, producing documentation.
Conducted design and code review sessions to ensure adherence to defined standards and global principles.
Coordinating with DBA team to design and develop post-clone automation.
ERP Technical Lead10/2002 to 06/2014ATI Allvac ATI Specialty MaterialsMonroe, NC
Aligned technical solutions and technology footprint with strategic priorities.
Define policies, processes, procedures and standards for development team.
Lead off-shore and on-site development team.
Lead the Quest Stat implementation.
Collaborated with functional and technical team to identify functional gaps, solution estimation, architecting and designing custom solutions, Solution delivery, producing documentation, and providing production support.
Design and implement the code migration process.
Order Management (OM/OE/ONT): Worked with functional and technical team to design and implement various custom processes such as Quote approval process, Quote/Order attachment process, line split at quote level, mass update of pricing, schedule ship date update process, cross reference mapping process between APC and Configurator.
Product Information Management (PIM/APC): Worked with functional and technical team on Functional Setups.
Design and implement custom data retrieval process with the goal of improving performance issues.
Design and implement automation of item creation (creating and implementing ECOs in various inventory orgs, creating an item when an ECO has been approved) process.
Various mass update processes.
Configurator (CZ): Worked with technical and functional team to design the model for quote process which interacts with the external systems.
Configurator performance tuning.
Shipping Execution (WSH): Worked with functional and technical team to Design interfacing with external vendors like KEWILL (for customer and export compliance and Best Transport.
Streamline custom miscellaneous shipment process.
JIT (Just In Time): JIT is an ERP package to handle business processes for Payroll, HR and Finance.
Environment: Oracle (7.2): PL/SQL, SQL, Toad, Oracle Forms 3.0, Oracle reports 2.5 Responsibilities Lead the technical team to analyze the application, conduct design sessions with business, propose solutions and implement.
Lead architect in designing external system interfaces with JIT.
JIT Production Support and enhancement.
06/2001 to 09/2002Hartford LifeWindsor, Connecticut
01/2000 to 05/2001Alliant/Atlantic Food ServicesManassas, Virginia
08/1999 to 12/1999First Nationwide Mortgage CoFrederick, MD
03/1999 to 07/1999General Binding CorporationBrook, IL
08/1998 to 03/1999Penske Truck Leasing CoReading, Pennsylvania
04/1998 to 08/1998Aurora Loan Services IncDenver, Colorado
Sr. System Analyst. Systems Analyst, Programmer Analyst09/1995 to 03/1998Group Ashima
Environment Oracle 8i, SQL, PL/SQL, Sun Solaris (UNIX), SQL*Plus, SQL*Loader, SQL Navigator, SQLab Tuner, SQL, Impact, Forms 4.5/5.0/6i, Reports 2.5/6i, PVCS Version Manager, Informatica 5.1, ERWin, MS Access, Designer 2000, UNIX Shell Script, C, Korn Shell, Windows NT, Cognos BI, TOAD Responsibilities Analyze the system, collect requirements from the business and convert them into specifications.
Design and implement solution, perform unit and regression testing, do application tuning and document the entire process.
Data modeling with the aid of ERWin.
UNIX shell scripts.
Loaded data using SQL*Loader / Informatica from different non-oracle sources into the Oracle Database.
Design and implemented complex Oracle Packages, Stored procedures, Functions and Triggers using PL/SQL.
Develop/Modify forms in Forms 5.0/6i.
Converted forms and reports to 6i/Cognos BI.
Created reports using Ingres Report Writer, Pro*C, SQL, C etc.
UNIX shell Scripting.
Database tuning and maintenance.
Master of Science: Computer Applications1995D.D.I.T Nadiad, Gujarat, India
Bachelor of Science: Statistics1992St. Xavier College Ahmedabad, Gujarat, India