Project Manager Engineer

Bhutwala, Jyotindra(Jack) *** Devon Brook Dr

Phone: 678-***-****(Cell) Woodstock, GA 30188

678-***-****(Home)

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

SUMMARY

1Experienced Software developer with over 20 years of IT industry experience

as a software developer, Business Analyst, Project manager,

Consultant/Application Architecture in development of Software using

Client/Server technology with VB6, PL/SQL, Crystal Reports, Oracle 8i,

Oracle 9i, Oracle 10g, Oracle 11g,Business Objects Xi, Centura Gupta, SQL

server and MS Access as well as Mainframe. OCP certified

2Worked with Manufacturing companies, Electric Utility and Telecom software

companies for developing application software using various languages and

databases.

3Involved in various phases of Software Development Life Cycle i.e. Analysis,

Design, Implementation, Testing and user Training.

4Able to work independently, willing to take challenge in an environment of

change with the highest level of integrity and intense desire to meet client’s

need.

5Team Player, with good technical, Analytical and Communicational Skills.

SKILL SUMMARY

Operating Systems: Windows NT4. Windows 98, Windows XP, Unix, Mainframe-MVS

Databases: Oracle 8i, Oracle 9i, Oracle10g, Oracle 11g, MS Access, APEX3.2

Program Methodology: Analysis by YOURDON

Programming Languages: PL/SQL, Visual Basic 6 (VB6), MS Access, VBA, VB.net

Crystal Report writer 8.5, Business Objects Xi, Wise for Windows, Install Shield, ASP,

Java, Visual C++, C, VB Net, Centura 2000/Gupta SQL Windows, Power Builders,

Oracle Developer 2000, DB4, ABAP for reporting and data extract, COBOL

Database tools: Visio for ER Diagrams, PLSQL developer, SQL Navigator, TOAD

Source Control – CMVC, Clearcase, Remedy, Panvalet, Starteam.

Scheduling Systems – Artemis, Primavera, Open Plan, MS Project, Project/2

PROFESSIONAL EXPERIENCE

Yamaha Corp. Oct 2006-Jan 2009

Kennesaw, GA

Software Consultant for Data warehouse support using PLSQL.

Worked as a Satellite Office DBA person. Responsible for setting up tables, sequence,

triggers, stored procedures, functions and Packages to process data received in text file

format, required data transformation and business logic as defined by the end user.

Developed over 50 stored procedures, 5 Packages which included Error tables log using

Pragma Autonomous Transact, Pragma Exception Init and Pragma Restrict References.

Also developed triggers to check the status of processes and log them into error logs.

Also developed dynamic stored procedures using DBMS_SQL package to load data

from different databases with filter on tables. Also developed stored procedure using

UTL_File package to extract data from text file and to create output file in Oracle

directory. Developed stored procedures to keep track of all operations on daily basis and

report them in Dataware house. Set up procedures to do ETL work on data coming from

different servers using Oracle 10g. Automated processes using Unix Shell scripts, Cron

jobs and FTP. Developed document to save source of all stored procedures in PDF

format.

Extensive use of Toad to setup tables, sequences, Store procedures, Packages. Also

verified functionality of procedures using Toad validation utility.

Setup Universe using Business objects, different schemas and develop reports using

Business Objects. Data extract from SAP using ABAP.

Skills Used: Oracle 10g, PL/SQL, Business Objects Xi, Unix, TOAD, ABAP

Ciba Vision Atlanta GA Apr 2006-May 2006

Consultant

Enhance Supply Chain Management application using VB6 and VB.net, PLSQL stored

procedures in Oracle 9i. Set up tables, triggers and procedure to extract data from VB net

application. Enhance MS ACCESS application to interface with Oracle Database using

VBAccess and embedded stored procedures.

Skills Used: Oracle 9i, PLSQL, MS Access, VBA, VB6, VB.net, Unix

Georgia Pacific, Atlanta, GA Feb 2006-Apr 2006

Consultant

Provide support and enhancement of data ware house projects. Develop Dimension, fact

tables and Materialized views using SQL Scripts. Develop stored procedure to aggregate

selected fields, set up triggers and generate drilled down reports using Oracle reports and

built in triggers and PLSQL language. Develop forms using Oracle forms 6i for Supply

Chain Management using PLSQL embedded triggers..

Skills Used: Oracle 8i, Oracle 9i, SQL scripts, PLSQL, Unix, Oracle reports

Ross-Group Inc. June 2005 –Sep 2005

PL/SQL Developer

Develop interface with systems to convert data from csv file to Oracle 9i tables using

PL/SQL stored procedure, triggers, Sequence, Forms 6i, Reports 6i.. Enhance reports as

per the client needs using embedded stored procedure to filter data from various tables.

Convert Oracle reports into Crystal reports.

Skills Used: Oracle 9i, PL/SQL, SQL Scripts, Oracle Reports, MS EXCEL

VeriSign, Savannah, GA Oct 2002-Apr 2005

PL/SQL Developer

Develop maintenance table using Java, PL/SQL using Oracle 8i database. Worked with

TOAD utility, Stored procedure and triggers and SQLPLUS to support Switch

engineering applications. Conversion of ISAM tables to oracle tables using

Java.Production support for Switch Engineering. Involved in software enhancement for

processing call records for Nortel, Motorola, Ericssion and Nokia switches and

provisioning using C and Zortec Cobol under Unix and Windows environment. Worked

under GSM as well as CDMA, TDMA specification including number portability, Push

To Connect, provisioning of accounts and phone numbers.

Skill Used: Oracle 8i database, SQL using SQLPLUS, PLSQL C, COBOL, TOAD,

UNIX

SCHLUMBERGERSEMA, Atlanta, GA Oct 1997- May 2002

Senior Software Engineer

Provided software support for Customer Care and Billing Systems (BSCS) in Windows

& UNIX environments using Centura 2000, C, Oracle 8, PL/SQL and VB6. Enhanced

BSCS –iDenmarket Module, International Roaming Module, Service Provider module,

Reference data module, Contract module, Resource Admin module using Centura 1.5.1

and Report writer in Windows NT.

1Developed interface between BSCS and Oracle Financial Software.

2Developed scripts to modify Oracle Database tables and triggers using SQLPLUS.

3Developed Stored Procedure using PL/SQL to expedite the application processing.

4Enhanced Customer Interface System using Stored procedures, PROC and, VC++,

C in Unix Batch environment. Developed Shell scripts to transfer data from one

server to other server.

5Developed custom reports using VB6 and Crystal reports 7 for internal use to keep

track of defect log, and hours worked on different projects.

SKILL USED: Oracle 8, Crystal reports, PLSQL, SQL Navigator,Gupta SQL

SOUTHERN COMPANY SERVICES, Atlanta, GA Aug 1981- Oct 1997

Senior Software Engineer (1987-1997)

Developed and maintained software for Power Delivery and Transmission departments at

Georgia Power Company in Windows environments.

1Developed interface between Work Management System and Project Management

System using Centura/Gupta SQL Windows and Oracle Stored Procedure.

2Developed Work Management System to estimate jobs, generate Bill of Materials,

and to interface with Scheduling system for CPM and Resource Scheduling

Artemis system using PL/SQL

3Developed Time Keeping system to keep track of Employee callout and overtime

worked to negotiate Labor Union Contracts using Clipper, SQL Windows and

Oracle 7.

4Perform software evaluation for Project Management systems (Artemis, Primavera,

Openplan) and submitted recommendation to the management for approval.

Skills Used: Oracle 7 database, SQL GUPTA, PLSQL, SQL Report Writer, Clipper,

Fortran, DB4

Liaison Engineer (1981-1987)

Acted as Liaison Engineer to develop, enhance and support Civil and Structural

Engineers’ need.

1Developed pre and post processors to process Structural Analysis results from

STRUDL, NASTRAN using FORTRAN and Tektronix Graphics Software.

2Involved in analysis of various drafting systems and making recommendations to the

management for the best system CALMA at that time.

3Assisted Planning Engineers to develop CPM and Resource Schedules for Power

Plant Design, Nuclear Plant Outages and Power Delivery Systems using

Mainframe software – Project/2 and PC software MS Project and Quest.

4Developed interface between Scheduling and Graphics software to generate Bar

charts and CPM schedules on various Graphics devices.

5Enhanced Cable Routing system for tracking cable layouts in Fossil and Nuclear

Plant using COBOL language.

Skills Used: FORTRAN,COBOL, CALCOMP PLOTTER

CONSULTING EXPERIENCE

MERIK INC., Atlanta, GA July 2001- June 2004

Software Consultant

Developed specifications for Roof Analysis Systems. Converted DOS/EXCEL based

system into Window based system to perform Roof Analysis for a budget of $13,000.

1Completed Roof Analysis systems (DS4, LC4) using VB6, ASP, Crystal Report

Writer 8.5, Install Shield and Help Writer within Budget.

2Define specs for reports, analyze, developed data tables and their relations.

3Build MS Access database using the ER diagram

4Defined reports using Crystal Report IDE windows. Set up special rules to display

various fields.

5Tested reports from Crystal report windows in preview mode and then interfaced

them with Application developed using VB6.

SKILLS USED: MS ACCESS Database, VISUAL Basic 6.0, Crystal Reports, Wise

for Windows, GUPTA SQL CENTURA, MS EXCEL

P & P Enterprises Dec 2008-

Consultant

Developed application using APEX 3.0+ on laptop. Completed OCP exam.

Skills Used:Oracle11g, APEX3.2

EDUCATION

MS – Structural Engineering, Tennessee Tech University, Cookeville, TN

BS – Civil Engineering, Birla Engineering College, Gujarat, India

PROFESSIONAL DEVELOPMENT

Introduction to Telecom Market, 1999

Seven Habits of Successful Managers 1995

Completed two levels of Toastmaster’s Club 1993, Effective Writing Courses 1993

Certified Professional Manager, Harrisonburg Virginia, 1990

Business Objects November 2006

Oracle Certified Professional for PLSQL Developer Oralce11g 1z0-146(OCP) 2010

REFERENCES

Will be provided upon request

Contact this candidate