PROFESSIONAL HIGHLIGHTS:

Client-Server systems analysis and development also experienced in database development and administration. Responsibilities included database installation, migration and upgrades, database monitoring, backup, recovery and Performance tuning. Data modeling experience using Platinum Erwin and PowerDesigner.

TECHNICAL SKILLS:

• SQL Server 7.5 2008 R2
• Sybase 10/11/ASE 11.9/11.x ASA 12.0
• Oracle 8.x/7.3/6.0
• PowerBuilder 4.0-12
• . PocketBuilder 2.5
• SQL
• T-SQL
• PL/SQL
• Pro C
• UNIX Shell Scripts
• C
• Cobol
• Platinum Erwin
• SQR
• Rapid SQL
• HP-UNIX
• Sun Solaris 10.2
• SCO Unix
• Windows NT/2K/XP
• Novell Netware
• MS-DOS

PROFESSIONAL SUMMARY:

Confidential

Database Administrator

Employee

• Administered six production servers and two Development Servers
• Supported applications for 3 clients
• Managed several users accesses appropriate privileges.
• Monitored and enhanced several Batch processes.
• Developed a C tool to monitor the Batch processes.
• Coordinated and implemented patches, migrations upgrades and installations.

Technical Environment: MS SQL SERVER 2008, SYBASE ASA 12.0, PowerBuilder 12.0, VisualStudio 2010, C

.Confidential

PowerBuilder Programmer

• Contracted through TEKSystems
• Production Support for application developed for Lackland AirForce Base and NCBC Gulfport NAVY .
• Developed New Application for an auto wheels reseller and a shipping company, was involved in entire Development LifeCycle of the Projects.
• The Applications supported were Inventory Maintenace Reporting Application.
• Developed new Windows, DataWindows, Menus, UserObjects in view of changed functionality and new user requirements.
• Extensively used PocketBuilder to install application in Intermec, Motorola Symbol Pocket PC's
• Developed PocketBuilder Applications in Windows Mobile 5.0,6.0 and Windows CE 5.0, 6.0

Technical Environment: MS SQL SERVER 2008 R2, PowerBuilder 11.5, 12.0, PocketBuilder 2.5

Confidential

PowerBuilder Programmer

• Contracted through CIBER
• Production Support for 35 BRANCHES of ThyssenKrupp Materials NA geographically spread over from Seattle to Montr al and Vancouver and Wichita.
• Supported 19 PowerBuilder 10.5 application.
• The Applications supported were Inside sales application, EDI monitoring application, reporting application among others.
• Developed new Windows, DataWindows, Menus, UserObjects in view of changed functionality and new user requirements.
• Monitored and implemented changes to SQL JOBS.

Confidential

PowerBuilder Programmer

• Contracted through Great Lakes IT Solution, LLC.
• Migration of 14 PowerBuilder Applications from ver. 7.0 to 10.5.
• Completed Impact Analysis of the impending change to the VIN number pattern on all the application and implemented the required changes.
• Enhancement of Windows, DataWindows, Menus, UserObjects in view of changed functionality and new user requirements.
• Migrated 12 PowerBuilder Applications from 7.0 to 10.5 and implemented coded enhancements t to PowerBuilder.
• Tuned procedure performance by enforcing the use of indexes and tuning the SQLs in the procedures.
• Researched the slow retrieval of customer letters and dealer reports and tuned for better performance.
• Implemented triggers to enforce business rules.

Technical Environment: Oracle 10g, PowerBuilder 10.5

Confidential

PowerBuidler Programmer

• Extensively involved in enhancement of the existing application.
• Worked with a team of Systems Analysts, Business Analysts and Testers.
• Enhanced to Windows, DataWindows, Menus, UserObjects.
• Coded Enhancements to PowerBuilder Applications.
• Tuned Stored Procedure performance.
• Tuned Performance of Reports.
• Implemented triggers to enforce business rules.
• Redesigned Windows as per new user requirements and implemented TAB controls to ease of use and unclutter the screen.

Technical Environment: Sybase ASE 12.0, Oracle 10g, PowerBuilder 10, PFC

Confidential

PowerBuilder Programmer

• PMS Project Management System is system used by the finance department of Great River Energy.
• Provided production support and extensively enhanced the existing application.
• Migrated nine PowerBuilder Applications from 6.5 to 10.5.
• Worked with the user team and gathered requirements from the user group directly.
• Enhanced to Windows, DataWindows, Menus, UserObjects
• Coded Enhancements to PowerBuilder Applications.
• Tuned Stored Procedure performance, wrote triggers.
• Redesigned Windows, fixed reports.
• Documented changes to guide users.

Technical Environment: Sybase ASE 11.5, Oracle 10g rel 2 10.2.0.3 , PowerBuilder 6.5 10.5

Confidential

PowerBuilder Programmer

• Coded Enhancements to PowerBuilder Applications.
• Migrated version 7.0 to version 9.0.
• Coded enhancements to Stored Procedure.
• Enhancements to Windows, DataWindows, Menus, UserObjects
• Database design using Platinum Erwin.
• Performance tuning of Procedures, Created Indexes
• Unit Testing and integration testing before production Install
• SOX Compliant Documentations.

Technical Environment: Sybase ASE 11.5, PowerBuilder 9.0, ClearCase Source control, Windows XP

Confidential

Systems Analyst

• Coded Enhancements to PowerBuilder Applications due to a change in structure of key database table.
• Upgraded Software, Migrated version 7.0 to version 9.0.
• Coded enhancements to Stored Procedure.
• Performance tuned SQL Queries used in Application.
• Enhanced to Windows, DataWindows, Menus, UserObjects

Technical Environment: Oracle 9i, PowerBuilder 9.0, ClearCase Source control, Windows XP

Confidential

Systems Analyst

• Coded Enhancements to PowerBuilder Applications Appointment Management System,
• Freight Management System also was involved extensively in day to day production support to those applications.
• Supported and implemented Enhancements to Truckmate Management System developed in PowerBuilder which connected to both Sybase and DB2 UDB in UNIX.
• Participated in technical design and review phase.
• Designed and developed Windows, DataWindows, Menus, UserObjects.
• Coded DB2 Stored Procedures as Data Source for DataWindow object.
• Implemented inheritance, encapsulation and polymorphism.
• Extensively used PFC for development of PowerBuilder objects.
• Documentations of already developed PowerBuilder Applications.
• Prepared Technical Documentation as well as User Manual.

Technical Environment: Sybase ASE 11.0, DB2 UDB, PowerBuilder 8.0/9.0, Windows XP, Unix

Confidential

Systems Analyst

• Performed day to day maintenance of AMS application developed in PowerBuilder
• Implemented SOX Compliance Documentations.
• Accessed Mainframe data files and transferred those files using FTP software into UNIX environment,
• Used BCP Utility to load data from legacy systems into Sybase tables.
• Managed couple of COBOL programs supporting MQ series.

Technical Environment: FTP, Unix, BCP Utility, Cobol, MQ Series, SYBASE ASE 11.5, PowerBuilder 6.5/7.0/8.0, Windows XP

Confidential

Programmer Analyst

• SAP Office Management Application was developed to automate and co-ordinate various modules developed in PowerBuilder as front-end tool and SYBASE as back-end database.
• This application facilitated the administration of the day to day functions of the business which includes Management of Employee, Customer and Infrastructure Relationship.
• Participated in technical design and review phase.
• Reviewed, recommended, and implemented database changes.
• Monitored production database performance and took corrective action.
• Planned and executed data conversion.
• Developed database backup/recovery procedures, database disaster recovery plans.

Technical Environment: Sybase ASE 12.0, Windows 2000

Confidential

Programmer Analyst

• Confidential is Infrastructure management application which supported ORACLE, SYBASE, SQL SERVER and SQL Anywhere Databases.
• Worked on Peregrine FacilityCenter Application for release of 7.1 versions.
• Maintained Logical Database model using Erwin.
• Worked on data structure, data type and restoring the database.
• Wrote Shell scripts to build data migration for export and import of data.
• Additional responsibilities includes System Administration role for FacilityCenter.
• Managed 24 databases in 8 servers.

Technical Environment: Oracle 8.x, 7.0, SYBASE ASE 11.5/11.9/12, SQL Server 7.5, 2000, PowerBuilder 6.0, Platinum ERwin 3, Java, Perl

Confidential

Programmer

• The Maturity Bill Application is a system developed to process the loan recovery data. Worked on Logical and physical data model apart from Developing and analyzing Stored procedures and triggers.
• Used Erwin to monitor and maintain structural changes in database.
• Designed triggers to implement business rules.
• Designed and implemented integrity constraints by enforcing primary and foreign keys, unique index on newly added tables.
• Performed Performance tuning and analysis.