Resume

Sign in

PL/SQL Developer

Location:
Morrisville, North Carolina, United States
Posted:
April 30, 2018

Contact this candidate

Resume:

BHUPENDRA PATEL

SUMMARY

Over ** years of Information Technology Experience in developing various software & training.

Six and half years of extensive experience RDMS systems like Oracle Workgroup Server 11g/8.0/7.3/7.1, SYBASE System 10.x, 11.x, SQL Server 7.0, 2000

Strong experience in ETL development tool Informatica PowerCenter 8.6, 9.1.

Strong experience in ETL development tool IBM DataStage 9.1, 11.3.

One and half years of experience with Sybase SQL Server 4.2 and SQL Anywhere 7.0

Hands on experience with DATA MODELING TOOLS such as ERWin & Turbo Analyst.

Extensive knowledge of Client/Server Architecture Concepts, Object Oriented Analysis (OOA) and Object Oriented Design Methodologies (OOD), Distributed Computing.

Knowledge of Oracle Database Administration, SYBASE SQL Server Database Administration such as backup and recovery, user permission, fine-tuning and performance.

Two years of experience with Visual Studio, VB 6.0 & Classic ASP.

Extensive knowledge of Allaire’s ColdFusion Studio 4.5, Macromedia’s Flash 4.0.

Provided corporate PowerBuilder & MS Word, MS Excel training to various organizations.

Expert in usage of advanced features of PowerBuilder like PFC, NVOs, n-Tier, MDI, Dynamic Data Windows, Tab Controls, Tree View controls and Inbound OLE Automation.

Extensive knowledge in Financial Accounting Software, Stock Transfer, Non-Banking Finance - Hire Purchase & Lease System, Claims Management.

TECHNICAL SKILLS

.Net Framework 3.5/4.0

C# .Net, LINQ, Entity Framework/ADO.net, WCF Services

4GL/DBMS

Oracle 11g, 9i/8.0/7.3 on Windows NT, Sybase, SQL Server, SQL Anywhere, Access

ETL TOOLS

IBM Datastage 9.1, 11.3, Informatica PowerCenter 8.6, 9.1

DATABASE FRONT ENDS

PowerBuilder 12/11.59.0, 8.0, 7.0, 6.5, 5.0/4.0/3.0, EA Server/Jaguar CTS 3.5

WEB PROGRAMMING

HTML 4.0, JavaScript, PowerDynemo, ColdFusion 4.5, Flash 4.0

SYSTEMS AND LANGUAGES

C & C++, Windows SDK, Visual Basic, MS HELP Compiler 3.1, Clipper 5.0

OPERATING SYSTEMS

Windows NT 4.0, Novell Netware 4.10, Windows 95, Windows 3.11, DOS 6.22, SCO-UNIX 4.0

HARDWARE

Pentium, SUN Workstation

EXPERIECNE

06-17 to Present BCBS, TN, USA, Datastage Specialist

EDW/CDW,P@W: DB2, Sybase, DataStage 9.1, AIX, KSH, Clear Case, RTC/UCD, Workload Scheduler

Responsibilities:

Datastage package load job using various stages including DB, Transformer, Look-up, Joins

Create sequence job using activities like job, loop, nested condition, sequencer, variables.

Generic datastage job to upload of different file types, CDC, S2T mappings, metadata

Write unix shell csh/ksh scripts to create batch jobs.

02-15 to 6/17 United Health Care, NC, USA, ETL Developer

HDE/OHR: Oracle 11g, PL/SQL, SQL Server 2008, DataStage 9.1 & 11.3, UNIX, KSH, CVS, Tivoli

Responsibilities:

Create schema, design and write PL/SQL packages, procedures, function and triggers.

Datastage package load job using various stages including Java, CFF, XML, Pivot, SCD.

Create datastage extract to CSV job for downstream OHR dashboard application.

Create sequence job using activities like job, loop, nested condition, sequencer, variables.

Write unix shell csh/ksh scripts to create batch jobs for scheduled run on TWS.

Perform performance tuning, query plans, bitmap index and list/range/hash table partitions.

Create, test and monitor work flows & schedule on Tivoli with dsjob.

07-07 to 02-15 Credit Suisse AG, NC, USA, AVP/SR Database Developer

DMPLS: Oracle 11g, PL/SQL, Sybase 12, T-SQL, DB2, Informtica PowerCenter 9.1, UNIX

GPL/BIRT/MAART: Visual Studio 10/08, Tortoise SVN, BOXI 3, Crystal Reports 10, Control-M

Responsibilities:

Design and write PL/SQL packages, procedures, function and triggers.

Write unix shell and perl scripts to create batch job and schedule on Control-M.

Provide primary and secondary production support for above applications.

Create various source/target objects, mappings with expr, filter, lookup, union, join, router

Create work flow design, mapping/sessions, parameters, develop, test and deploy.

Schedule and release GPL application modules for Web, Edit PNL and GPL remote services.

Create .Net console application to extract & generate feed file from Web Service.

08-03 to 06-07 Nationwide Insurance, Columbus, OH, USA, SR App IT Specialist

ENTRACK: PowerBuilder 8.0. PFC, Oracle 9i, PL/SQL, SQL*Loader, Tomcat/Javascript

SHIELD: Visual Studio 6.0, ASP, HTML, SA – Fileup 3.18, SQL Server 2000, T-SQL

Responsibilities:

Migrated ENTRACK application from PowerBuilder 6.5 to 8.0, Oracle Client from 7.3 to 9i.

Enhanced existing features of an application, started using PB Native Source Control.

Developed automated script for creating and deploying new application build.

Developed advanced reporting interface for dynamically report generation.

Migrating application from Windows NT to Windows 2003 Servers.

Maintained SHIELD web-site and provided production support.

07-02 to 07-03 FirstEnergy Corp, Akron, OH, USA, SR Application Developer

FE Claims System: PowerBuilder 8.0. PFC, Sybase, TSQL, DB Artisan, Web-Methods ActiveX

FE Circuit Billing System: PowerBuilder 8.0, PFC, Sybase, TSQL, UNIX

FE Cars System: PowerBuilder 8.0, PFC, Oracle 8, PL/SQL

Responsibilities:

Convert accounting interface of these systems from Oracle STARS/WARS System to SAP.

Create several new batch applications for user security, up-loading data. Generates PDF reports & notifies admin group about the status through Lotus Notes e-mail with attachments.

Provide several enhancements to Claim system by adding new account types.

Prepare database SQL scripts to convert production database to new system.

6-01 to 7-02 Aquila Inc, Omaha, NE, USA

EnergyWorks – Risk, Power and Gas Management System:

PowerBuilder 7, 6.5, PFC, SQL Server 2000, Oracle 8i, Windows NT, TOAD 6.3, Visual Source Safe 6.0

This PowerBuilder application was developed based on the n-tier architecture where the business logic resides in one set of non-visual objects and the rest of the application logic is completely dependent on another set of non-visual objects.

Responsibilities:

Involved in the development/maintenance of RiskWorks, GasWorks, PowerWorks sub-systems, consist for 6 SQL server databases & 3 Servers, one each for development, testing & production.

Implemented currency filter and currency conversion for all the reports.

Provide production support activities like data migration, generating/exporting historical data, running nightly calc process, bug fixing, coordinating with emergency patch releases.

Involved in writing Stored Procedures and data migration SQL script.

Involved in unit testing and documentation.

Involved in SQL-Server to Oracle 8I Migration.

2-00 to 6-01 Trane Company, LaCrosse, WI, USA

FALCON Claims Management System, TaxQueue System, Customer & Riskman System:

PowerBuilder 7.0, 6.5, PFC, Oracle 8.0, PL/SQL, EA Server/Jaguar 3.5, TOAD 6.1, UML 1.4

SQL Server 7.0, MS Access, UNIX, Windows NT

Responsibilities:

Application Maintenance, Migration, Develop/Re-develop particular functionality.

Prepare Class/Object Diagrams, Sequence & Activity Diagrams, STD Diagram

Develop state full, stateless Jaguar CTS Packages of Components namely standard, shared and service, define client interfaces, implement, deploy and debug the component. Component included processing business rules, data retrieval, data updates, datawindow synchronization, asynchronous processing, developing connection objects and handling transactions.

Build and Deploy application for Development, Test and Production

Optimize application modules & SQL queries for speed and performance

Develop batch utilities in Stored Procedures, Functions and Packages

Migration of an application to PowerBuilder version 7.0

12-97 to 2-00 FirstEnergy Corp, Akron, USA

Lead Level Development in Following Systems:

FE Claims System: PowerBuilder 6.5, 5.0 PFC, Sybase, TSQL, DB Artisan, UNIX

Responsibilities:

Extensively used PFC, Tab Controls, TreeView, DataWindow Controls, Data Stores

Prepare the Application FrameWork, Menu and TabPage Level Security

Visual and non-visual UserObjects, Generic Objects for DataWindow, Sheet & Report Window

Windows objects uses mainly tab, datawindow, datastore, popup menus

PB Reports and Reports in MS Word either single or Batch Reports using OLE Automation.

Prepared Class Diagrams OOD, documenting application design, framework with functionality

Wrote Stored Procedures and Triggers

Client: Ohio Edison / FirstEnergy Corp, Akron, US through Arthur Anderson, Chicago, US

Software: PowerBuilder 5.0, PFC, Windows 95, Oracle 7.3, PL/SQL, SQL*Loader, UNIX

Application: Value Based Management System:

Responsibilities:

Extensively used PFC, Tab Controls and Treeview Controls.

User objects (Visual and Non-Visual), Developed generic object – Treeview.

Wrote numerous window objects which uses mainly Treeview, Datawindow, Datastores, popup menus, tab pages and ListView. Prepare test plans & do unit testing for the objects developed.

Wrote Stored Procedures, Triggers and Functions.

07-96 to 12-97 Client-Server Software Pvt. Ltd., India

Hire Purchase & Lease System: PowerBuilder 5.0, PFC, Windows 95, Windows NT

Database: Oracle 7.1, PL/SQL, SQL*Loader, Sybase, T-SQL, Novell Netware 4.2

Client: Anagram Finance Limited

Responsibilities:

Design and development of the module

Extensively used PFC, Tab Controls and Treeview Controls.

Used object oriented and advanced PowerBuilder features including MDI, Inheritance, Dynamic data windows, Drop Down Datawindow, User objects (Visual and Non - Visual), Pipeline, Dropdown menus, DDE and OLE.

Developed generic objects and Ancestor windows using a template oriented Class Object Library.

Wrote numerous triggers, procedures for conversion, data manipulation, replication and remote procedure calls to maintain system integrity and store procedures to enhance performance.

Developing test plans and testing of the system.

Certification Exam Package

Developed package for conducting project trainees’ test using PowerBuilder 5.0 on Windows & Oracle Workgroup 7.1 on Novell Netware 4.0.

Questionnaires Builder - Build questions repository,

Examination conducting application - generates any 50 questions from the repository, Applicant passes through all the Objective Questions.

Result Viewer - Online get the score of Applicant, Browse through all true, false and not appeared questions for any Applicant.

09-94 to 07-96 T M Systems, Ahmedabad, India

Software: PowerBuilder 4.0, Sybase SQL Server NLM, TSQL

Platform: Windows 3.1, Novell Netware 4.10

Client: Well-Pack Papers & Containers Ltd

This project, Share Transfer Manager, involved system analysis, design & programming using PowerBuilder 4.0, Sybase SQL Server NLM, Platform - Windows 3.1, Novell Netware 4.1. Online Attractive Help Support developed using MS-Help Compiler 3.1.

Data Entry Forms Reports

Allotted Shares Register for all entries

Transfer of Shares Mailing Labels

Splitting of Share Signature Specification Chart

Transmission of Shares List of Holders who’s holding is above the specified shares

Duplication of Share City-wise & Category-wise holding chart

Change of Address Share History, Top 10 Holders, Holdings of a Share Holder

Dividend Warrant Printing, Dividend Allotment & Register

Responsibilities:

Inheritance and User Objects were used

Identified and coded various stored procedures and triggers

Involved in the business design of Memos

Developed various screens using PowerBuilder 4.0

Used DDE to print the memos

Extensive reports were provided

Developed On-Line help for all the applications

Yogi Seeds & Fertilizers Ltd. - Financial A/C System

Software: PowerBuilder 4.0, Sybase SQL Server 4.2, MS Office, Turbo Analyst

Platform: Windows 95, Novell Netware 3.11

This project, Financial Account System, involved requirement gathering, system analysis, database design & programming using PowerBuilder 4.0, Sybase SQL Server NLM, Platform - Windows 3.1, Novell Netware 4.1. Online Attractive Help Support developed using MS-Help Compiler 3.1.

Application Modules:

Daybook, Bank Book Printing, Outstanding Payables and Receivables

Sales, Purchases, Journal, Bank and Cash Entries

Trading, P & L Account, Ledger Printing, Stock Summary and Statement of Account

Balance Sheet - Vertical & Horizontal with Schedules

Anagram Finance Limited: Car Book & Allotment

Role was for case study & database design using Sybase SQL Server 4.2, TSQL, Turbo Analyst. This application was developed for keeping the booking details throughout the nation, region wise. It tracks the pending list of customers in priority list through Prospect Details, vehicles on stock through Purchase Order, pending bookings with various dealers - car model wise. Difference payment report for suppliers through Purchase Invoice and Purchase Order.

12-93 to 05-94 MADHU TEXTILES, Ahmedabad, India

Software: Micro focus COBOL 85 & 74, Programmer Analyst

This project, multi-user Payroll System involved understanding user requirements, preparing data flow diagrams, flow charts, system specification, system analysis, system design and programming. Other responsibilities involved user support, installation and implementation of software and hardware.

Application Modules:

Attendance Register, Leave calculation

Monthly Salary Slip & Summary Printing, Income tax calculations

Bonus & Gratuity calculation, Load, LIC, HRA, DA

10-92 to 12-93 COMPU-SERVER CORPORATION, India

Hardware: DOS LAN 2.11, Software: CLIPPER 87 & 5.2

This project involved design & development of a full-fledged package, multi-user system for doing a job work for State Bank of India, Corporate Service Branch, Ahmedabad. It required voluminous data entry of public issue application checks, dividend warrants, refund checks, preparing branch-wise, company-wise detail and summary reports. Next project involved design & development of a full-fledged multi-user Financial Account System. Application Modules: Day Book, Bank Book, Receivables & Payables, Sales, Purchases, Journal Entries, Trading & PL Account, Balance Sheet

EDUCATION

B. S. GUJ. Agriculture University, Anand (1985 - 89)

Diploma in Computer Application, Apple Ind., Ltd., Ahmedabad

UNIX & C, CCIT, Ahmedabad (1990)

Diploma in Client/Server Technology, STG International Ltd., New Delhi (5/94 - 7/94)

Diploma in Object Oriented Technology, C++, OOPs, OOD, STG International Ltd., New Delhi

Windows SDK Programming, NIIT Limited, New Delhi (1 Week)

Informatica Power Center – Online training (3 weeks)

IBM Cognos Report Framework – Online training (3 weeks)



Contact this candidate