Sr SAS Developer & Analyst

Rohit Chaube

Email: ***********@*****.***

Cell Phone: 662-***-****

Home Phone: 512-***-****

• Software professional with 7+ years experience in Oracle Application Supply Chain Management, Database, Parallel Computing and Load Balancing for cluster computing

• Senior PL/SQL Oracle Apps Developer with more than 4+ years of experience with Oracle E-business suite Applications R12,11.5, 10/11i, PL/SQL

• Expertise in various stages of Software Development Life Cycle (SDLC) – gathering & analyzing the requirements, converting specifications into functional & technical design documents, code development, quality assurance and product documentation.

• Extensive experience in Oracle 11i and Oracle R12 E-business suite modules including Order management/Order Entry (OM/OE), Oracle Inventory (INV), Oracle Purchasing (PO), Oracle Work in Process (WIP), Oracle Bill of Material, Oracle General Ledger (GL), Oracle Receivables(AR) and Oracle Process Manufacturing (OPM),

• Expert writing optimized queries in SQL/PLSQL/Trigger, Dynamic SQL, stored procedures and packages

• Experienced in deployment and maintenance of the application in production environment.

• Experience in RDBMS 11g/10g (Express and Standard edition), used tools like TOAD, SQL Navigator, PL/SQL Developer and SQL Developer.

• Experience in Project Implementation going Live and Live Support.

• Involved in the Agile Methodology of Software Development.

• Worked on Reporting Tool Oracle Reports and Birt

• Ability and confidence to pick up new technology and skills or work as soon as possible.

• Quality Assurance – designing test cases and testing the ERP software

• Exceptional problem solving and analytical skills, excellent verbal, written, communication and presentation skills

ERP Modules Oracle E-business suite 11i and R12 – General Ledger (GL), Account receivables (AR), Order management/Order Entry (OM/OE), Inventory (INV), Purchasing (PO), Work in Process (WIP), Process Manufacturing (OPM), Bill of Material

SQL Tools TOAD, SQL Navigator, SQL Developer

Languages PL/SQL, C/C++, Java, HTML, Javascript

Databases Oracle 11g/10g/9i, MS-Access

Operating Systems Windows XP/NT/2000/98/95, UNIX, LINUX

Configuration Tools WinCVS, Salesforce

Development Tools Eclipse, TextPad, EditPlus

Reporting Tool Oracle Reports, Birt

TAKE Supply Chain, (formerly ClearOrbit), Austin, TX August 2006 to current

Position: Senior Software Engineer

TAKE Supply Chain, a software and services company that delivers world-class supply chain management and life sciences solutions throughout global markets. TAKE Supply Chain extends enterprise systems with proven software solutions for returns management, supplier collaboration, mobile data collection and barcode/RFID printing.

TAKE Supply Chain Products:

Gemini, a simplified interface for Mobile and Desktop Automation application extending the ERP to provide nimble, concise transactions that enable Oracle E-Business Suite to conduct receiving, inventory, production and shipping transactions through radio-frequency handheld terminals.

Extended Process Control (X.PC), a fully integrated application that provides manufacturers and distributors with real-time, reliable, low-cost sharing of information on all outbound shipments and purchase orders to vendors.

Connect, is the Connected Pro Series technology platform that provides manufacturers the unique ability to integrate the Enterprise Resource Planning (ERP) system directly to industrial devices to drive significant supply chain efficiency improvements.

Projects Worked

Client Applied Materials

Website http://www.appliedmaterials.com/

Product: Gemini, Extended Process Control, Connect

Technologies Involved: Oracle 10g, PL/SQL, Textpad, Eclipse IDE

Responsibilities

• Enhancements of the existing PO Receiving transaction, adding new transaction Receive Spot-buy to meet highly complex business requirements of cascading PO Receiving, guided put away and cross-docking

• Extended Oracle and X.PC (Extended Process Control), received functionality by mining and optimized Oracle APIs if required

• Initiated to redesign, develop and deploy migration tables to export existing data to be used by X.PC. A crucial piece for project going live

• Responsible for Integration testing in Dev and QA environment

• Involved in the Agile Methodology of Software Development

Client Smith Medical

Website http://www.smiths-medical.com/

Product: Gemini, Connect

Technologies Involved: Oracle 10g, PL/SQL, TOAD, Textpad

Responsibilities

• Enhancements of existing, and creating new Gemini transactions

• Worked on Receiving, Shipping, Inventory and WIP transactions

• Responsible for Integration testing, UAT in Dev, QA and client testing environment.

• Take lead role in working directly with the client to resolve open issues

• Designed barcode labels using Bartender label software, configuring in Connect, testing the label printing feature in Oracle Applications

• Worked closely with deployment team and making sure a timely delivery of product

• Involved in the Agile Methodology of Software Development

• Worked on designing functional specifications and detailed documentation

• Providing crucial go live and live support

Gemini R12a/12b

Technologies Involved: Oracle 10g, PL/SQL, Textpad

The latest Gemini suite release to correspond to changes with Oracle Release12 (R12) compatibility

Responsibilities

• Took the lead role to analyze Oracle R12 new features like Secondary quantity, Parent/Child lot, and Grade control on Lot-controlled items

• Understood the single data model used for both Discrete and process manufacturing for Oracle R12 to be used in same set of Inventory, shipping and receiving transactions.

• Designed the functional specification to add new Oracle R12 changes and include new features like material status control.

• Analyzed and mined Oracle public API, to add the code changes for new Oracle R12 features.

Development Resource, Product Support team

Clients: Los Almost National Laboratory, World Wide Technology. Inc, General Electric Healthcare, SunOpta, BAE Systems, NCH Corp, Welch Foods Inc, Blue Bell Creamery , Smith Medical, Wah Chang and others

Technologies Involved: Oracle 9i/11i/R12, PL/SQL, Oracle 10G, Java, Eclipse IDE

Responsibilities:

• Involved in monitoring the issues raised in Salesforce

• Worked on resolving issues related with Gemini, Connect and Extended Process Control (X.PC)

• Involved in client interactions for understanding production issues

• Involved in the Agile Methodology of Software Development.

• Involved in understanding of the business flow of live sites and suggesting fixes

• Design Analysis, identified potential bottle-necks; re-designed components for better performance.

• Creating the stored procedures and optimizing SQL queries.

• Participated in code reviews and code walkthroughs to identify and achieve performance improvements.

• Created configuration files necessary for deploying the application in different environments.

• Responsible for preparing the documentation which include Business Requirements Documents, Test specification, User Friendly and various other documents.

Quality Assurance

Product: Extended Process Control (X.PC), Connect, HP Quality center

Technologies Involved: Oracle 11i, Java, PL/SQL, Textpad, Java, Eclipse IDE

Responsibilities

• Created and executed test plans based on functional documents for XPC new features like Invoicing, Engineering Quality Collaborator, Web Labels, Reports and Quick Search.

• Created and executed test plans for Connect 57d new features like Copy My Pages Dashboard, Single Sign On, On-Demand Reports, Folders and Saved Searches.

• Worked closely with development team to resolve the open issues

• Worked on proof reading product release notes and took initiative to include screenshots in the release notes.

• XPC 5.6d and Connect 5.7 compatibility testing with Internet Explorer 8

Mississippi State University, MS July 2003 to August 2006

High Performance Computing Collaboratory, (formerly Engineering Research Center),

Position: Graduate Research Assistant

Technology Used: C/C++, Message Passing Interface(MPI), MATLAB and Simulink, Latex

• Combining different loop scheduling – factoring, fractiling, weighted factoring, adaptive weighted factoring, static, self-scheduling and fixed size chunking and load balancing strategies are GET, GIVE strategies

• Designing and developing MPI based dynamic load balancing library a combination of loop scheduling strategies and load balancing techniques

• Extensive comparison of existing load balancing libraries

• Exhaustive research and testing large scientific applications like N-body Simulation, Automatic Quadrature Routine(AQR),

• Poster presentation of library design at IEEE International Conference on High Performance Computing, Goa, India, December 2005

• Conference presentation of results and findings at ISPDC 2007 and IPDPS 2008

• 4th Annual Research Symposium, MSU: Best poster presentation (April 2006)

• Exhaustive polishing of verbal, presentation skills for conference presentation

Company: Indian Railways, Mumbai, India

Website: www.wr.indianrail.gov.in

Duration: Jan 2002-May 2002

Designation: Trainee Network Engineer

• Learning the installation and maintenance of Intranet network and the fiber optic network on Western railway

• Web page designing for the organization

Company: Bhabha Atomic Research Center(BARC), Mumbai, India

Website: http://www.barc.ernet.in/

Duration: Aug 2000-May 2001

Designation: Trainee

• Design and implementing algorithms to solve the various pulse processing errors like pulse pile up, base line errors and noise to be implemented as part of designing a digital Multi-channel analyzer

Master of Science - Computer Engineering GPA: 3.53

Mississippi State University, Mississippi, USA

Graduation, December 2007

Bachelors of Technology – Electronics Engineering GPA: 3.48

Mumbai University, Mumbai, India.

Graduation, August 2001

Contact this candidate