SUBHAMAY BHATTACHARYYA email: [CONTACT] / [CONTACT] Cell# *** Visa Status: H1-B Summary Software Professional with more than 17 years of experience. Over 12+ years of extensive experience as Oracle Application Technical Developer / Architect in implementation, upgrade and customization of Oracle e-Business Suite Applications (R12, 11i). This includes system study, design, development of RICE / CEMLI components, post implementation maintenance and support of Oracle EBS. Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operational costs. A seasoned developer cum technical-lead in very large Oracle Application implementation engagements. Extensive experience in implementation, Data Migration, Customization, Production Support of various modules in Oracle Applications with major focus in Order Management (OM), Inventory (INV), General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Purchasing (PO), Bills of Material (BOM), Warehouse Management System (WMS), Advanced Supply Chain Planning (ASCP), Service Contract (OKS), Services (CS). Proficient in development of interfaces to integrate Oracle Applications with Legacy and Third Party Applications. Strong experience in designing and developing complex CEMLI objects based on functional specifications (MD50) and translating it into technical specification (MD70) and code development. Having strong experience in Oracle e-Business implementation and support projects. Having experience in working for Fortune 500 clients. Proficiency in development of technical design documents using AIM Methodology. Good experience in integrating Oracle e-Business Applications with legacy and third party applications. Extensive experience in writing SQL, PL/SQL and Unix Shell Scripting. Having experience in working on Web ADI / XML / Application Tuning and performance enhancement. Having excellent experience in working on Oracle Custom Forms and Form Personalization and working knowledge of APEX. Strong experience in developing complex interfaces both host and PL/SQL type. Having strong experience in developing BI Publisher Reports. Very good exposure to very complex Data Conversion various modules like OM/AP/AR/INV. Experienced in Customizing Oracle Forms with Forms Personalization. Experienced in developing new reports / enhancing existing reports by using Oracle XML Publisher (BI Publisher). Extensively used TCA (Trading Community Architecture) to create customers in AR using Customer Open Interface and TCA APIs. Having exposure in developing Oracle Workflow and Business Events. Expertise in version control software like Tortoise CVS. Experience in code migration using HP PPM as well as automated shell scripts. Good experience in using Oracle SQL*Loader. Write technical design documents for conversions, extensions, interfaces, and reports. Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs). Having very good experience in writing codes in Microsoft VB Script and Visual Basic. Good exposure to ETL Tool like BODI (Business Objects Data Integrator). Experience on Data Conversion Tool BackOffice Exposure to scheduling tool like CA Autosys. Education Master in Computer Application (MCA) from National Institute of Technology, Rourkela, India. (NIT is one of the institutes of national importance in India). Bachelor of Science (B.Sc.) with Mathematics as major from St. Xavier’s College (University of Calcutta, India) Technical Skills RDBMS: Oracle 8/8i/9i/11g. ERP: Oracle e-Business Suite. Oracle EBS Modules: SCM (OM/INV/BOM/WIP/Advanced Pricing), Financial (AP/AR/GL), CRM (Quotes, Service Contracts, Field Service), ASCP. Oracle EBS Tools: SQL, PL/SQL, Developer Form SQL*Loader, Oracle Workflow, Forms 6i, UNIX Shell Scripting, Data Loader, FNDLOAD, Web ADI. Software Methodologies: Waterfall, Agile SCRUM Operating System: Windows XP, Vista, Red Hat Linux, Solaris, HP UX. Programming Languages: SQL, PL/SQL, Unix Shell Scripting, Documentation: AIM. Version Control tools: Tortoise CVS. Professional Experience Principal Consultant - Jan *** till date Genpact LLC, Cincinnati, OH Client GE Aviation, Cincinnati, OH *** *** Project GE Aviation Engine Modernization Project Location Cincinnati, OH Responsibilities Worked as a conversion lead from onsite liaising between the onsite business team and the offshore technical team. Resolving any disconnect on the mapping at Oracle End. Guiding the offshore team on the conversion methods and approach. Genpact L...

See full