Summary


Information Systems Professional with over 10 years of PowerBuilder experience. Areas of experience include a Database Management, Development, Full Cycle Testing and Support for HR, Banking, Sales, Purchasing, Rebates, Invoicing and other financial applications. Strong technical and analytical skills provide ability to work both independently or as a team member.


Employment

February, 2008 -  November, 2009
Software Engineer Consultant

Debugging and troubleshooting the InOrder application. Designing, programming, coding and documenting addition parts for the application. Creating stored procedures and other database objects to increase speeding and consistency of the application.

2005 -  2007

April, 2008 -  February, 2009
Analyst/Programmer Consultant

Maintenance and extension development of the SLIM application. Eliminate the existing bugs and errors. Create the ability to allow users to make choices of targeting the Database through INI file. Create an additional tab page for Resources with all functionality. Develop number of the reports by user requirements.

Environments : SQL 2005, PowerBuilder 11.1

The Northern Trust Bank May2007 March 2008
Chicago, Illinois
Analyst/Programmer Consultant

As a member of the Price Scrubber team in the Pricing Department worked on the system that was responsible for maintaining and ensuring that all assets have the most accurate price by evaluating it against predetermined criteria and scrubbing rules. Responsibilities included creating, tuning and maintaining stored procedures, triggers, sequences and other oracle objects, using temporary tables to increase stored procedure performance, creating detailed Exception process and number of reports for business users. Developed and maintained the PowerBuilder applications to apply new client s requirements and enhancements. Created test plan and test cases for each requirement. Application have over 700 users, handles 200K asset items.

Environments : Oracle 9i, PL/SQL, PowerBuilder 9.0, Unix Shell Scripts, PVCS, Database Artisan.

December, 2005 -  May, 2007
Analyst/Programmer Consultant

As a member of the Supplier Incentive System team was working on maintaining and enhancing of the application for tracking and invoicing vendors for purchase and sales by capturing the volume for each product, rate of the agreement, rebates and vendor billing. Responsibilities included creating packages, procedures, triggers, sequence and other oracle objects to apply current and new company rules and market requirements, using SQL Loader to insert daily/weekly data into tables, tuning procedures to decrease loading time of data into the Oracle tables. Creating Unix scripts to run the packages and adding jobs to schedule for daily execution.
Created PowerBuilder objects using object oriented techniques and PowerBuilder Foundation Class Libraries to extend the current application. Used third-party tool OLE objects into PowerBuilder application to create number of Excel reports like Cross Analysis Report, Purchasing Analysis Report, Inventory Report.

Environments : PowerBuilder 9.0, Oracle 10G, PL/SQL, Shell Script, TOAD.

August, 1996 -  December, 2005
Database Administrator

Education

Training

Advanced Computer Training Certificate Program , Chicago , Illinois - 2008 .
Coursework included ASP . NET , C# . Net , SQL Server 2005 .
Advanced Computer Training Certificate Program , Glenview , Illinois 2006 .
Coursework included QA and Testing for Web Applications/ QTP/Software Quality Assurance .
FACT , Inc Certificate Program Glenview , Illinois 2000 .
Coursework included Oracle Backup and Recovery/Performance and Tuning .
B.I.R. Training Center Certificate Program , Chicago , Illinois 1994 .
Coursework completed : C under UNIX Platform , Oracle , SQL Plus and PowerBuilder .
Completed intensive training in Financial , Statistical and Engineering Architecture , St.Petersburg , Russia 1993 .


Skills


PLATFORMS : .NET Framework, Sun Ultra Enterprise Server, IBM PC, IBM 360/370, various Windows NT Servers, HP, AIX, DOS OS/MVS, Unix Sun Solaris, Windows. DATABASES : Oracle 8.1.7 9i, 10G, Sybase 12.5 Sql Server 4.x 2000, 2005, 2007, Sybase SQL, Anywhere WATCOM, Access, MySQL. LANGUAGES : PowerBuilder 8.0 11.1 PL/SQL, SQL, Transact SQL, SQL*Plus, Shell Scripts, Info Marker 5 - 8, PowerBuilder Foundation Class Library, Quick Test Pro QTP, XML, HTML, ASP.NET, C# .NET, Microsoft Visual Studio .NET. TOOLS/UTILITIES : ISQL, WISQL, Oracle Enterprise Manager, SQL Navigator, TOAD, SQL Loader, Import, Export, Server Manager, Database Artisan, Rapid SQL, CAST, Sybase Server Manager, Sybase Central, Quest Central, PVCS, FTP and Extra Attachmate. DATA MODELING TOOLS : Erwin, ERStudio 6.6., Power Designer and Visio.


Miscellaneous

As a member of IS department work on 2 different teams, management support team and asset management team supported applications for Senior Management and HR like Employee Tracking System, Employee Evaluation and Compensation, Employee Training. Other applications include Automated Invoice Management System. Responsibilities included : Developed full system life cycles starting with design, documentation, development, testing and implementation.
Provided daily maintenance support of applications. This includes assisting clients with application usage, working with clients to resolve application problems and application troubleshooting and debugging PowerBuilder 10.05. Provided 24x7 supports.
Created PowerBuilder Projects, PowerBuilder Dynamic Libraries PBD, Dynamic Link Libraries DLL, PowerBuilder Resource files. Distribute the applications to the users.
Created Multiple Document Interface MDI and Single Document Interface SDI applications like Career development and Training applications.
Managed security segments of the applications in order to ensure that only authenticated application/users have access to confidential information.
Created pipelines in order to update information on different servers and databases.
Used PFC objects and services. Customized the PFC according to Company requirements and standards.
Used the Linkage Service to establish master or detail relationships in application development process.
Automated all manual procedures. It saved the company time and money, decrease a transaction round trip time and improves the data accuracy.
Created additional windows in existing applications to check current integrity and consistency of the data.
Daily, weekly and monthly maintenance of Sybase or MS SQLServer or MySQL or Oracle databases in production and development environments.
Designed and created new databases. Monitored database activity. Created user logins.
Installed software, servers, clients and established connectivity between clients and servers.
Backed up databases using Windows NT Scheduler.
Created Contingency plan. Restored databases.
The responsibilities included tuning and creating stored procedures, logins and passwords for users, analyzing and creating tables, archive tables, triggers, defaults and grants.
Developed, supported and maintained the PowerBuilder applications for trade, secondary marketing, commissions and human resources departments.
Environments : PowerBuilder 5.5 - 10.05, Oracle 9, PLSQL, Sybase 10 - 11.5 SQL Server 2000, My SQL, Database Artisan, Unix-Shell Scripting, Windows NT, SQL Navigator, TOAD, PVCS.