SUMMARY:

• Over 18 years of extensive experience in Information Technology including:
• Analysis, design, development, testing, and Quality Assurance of database applications
• Installation, server configurations, and troubleshooting
• Seventeen years of experience with PowerBuilder
• Six years of experience with Informatica/ETL
• Three years of experience with ASP.NET 3.0/3.5
• Eight years of experience in creating stored procedures using Sybase SQL Server
• Four years of experience with Microsoft SQL Server
• Eight years of experience with Sybase SQL Server
• Five years of experience with Korn Shell Scripts
• Six years of experience with UNIX operating system
• Five years of experience with PL/SQL
• Five years of experience with Oracle DBMS excellent communication and interpersonal skills

TECHNICAL SKILLS:

Hardware: IBM PCs, UNIX, SUN Work Stations, DEC VAX 8650, Ultrix 3.1

Operating Systems: Sun OS, VAX/VMS, Windows

GUI Development Tools: PowerBuilder, Developer 2000, Oracle Forms, PowerTool

Languages: C, C++, C#, SQL

Web Technologies: ASP.NET3.0/3.5, HTML, DHTML, JavaScript, XML, XSL & AJAX.

Scripts: Korn Shell, Power

Databases: Sybase, Oracle, SQL Server, Terradata

Oracle Tools: SQL*Plus, SQL*Forms, SQL*Menu, PL/SQL, Pro*C

Datawarehouse Tools: InformaticaPowerCenter ETL

PROFESSIONAL EXPERIENCE:

Confidential, NY

Lead Programmer

Responsibilities:

• Resolved the Claims subsystem issues
• Removed the redundancy of fields on several screens
• Created a Single Data Entry screen for Assumed Risk for the users to insert, update, and delete the Contract, Contract Layer, Accounting Term, Claim Term, Premium Term, Underwriting Term, Underwriting Term Risk Share, Underwriting Term Assumed Information data from this screen. This screen makes it easy for the users to access all the fields at one place as opposed to an inconvenient way of navigating through various tabs.

Environment: PowerBuilder 12.5, Microsoft SQL Server 2008

Confidential, DE

Lead Programmer

Responsibilities:

• Implemented the new requirements and modifying existing code to reflect changing compliance requirements
• Coordinated with offshore resources for implementation, testing, query resolution
• Performed unit testing on all modules developed to ensure the functionality specified in the requirements is accurately reflected in the functionality of the application
• Supported System Integration Testing and User Acceptance Testing
• Coordinated with Change control team and handling change management activities
• Troubleshooting and supporting Post - Production Issues.

Environment: PowerBuilder 12.1, Sybase v12, Oracle 9i

Confidential, NJ

Lead PowerBuilder Programmer

Technologies used: Oracle 9i, Sybase v12, PowerBuilder v10.5

Responsibilities:

• Requirement gathering and analysis/gap analysis of existing application
• Implementing the new requirements and modifying existing code to reflect changing compliance requirements
• Coordinating with offshore resources for implementation, testing, query resolution
• Carrying out Testing and supporting User Acceptance Testing
• Coordination with Change control team and handling change management activities
• Troubleshooting and supporting Post-Production Issues.

Confidential, New York City

Lead PowerBuilder Programmer

Responsibilities:

• Worked with SBS Operations & Technology staff to quickly take over the hosting and maintenance of the PBMFR (Project Budget & Monthly Financial Reports) system from DYCD (Department of Youth & Community Development)
• Gathered requirements and develop functionality according to pre-defined business needs using PowerBuilder
• Designed and created tables to populate the budget and monthly financial reports data
• Coded the stored procedures using PL/SQL to email the budget reports and to validate the contracts and the customers
• Worked with the infrastructure team and the users to make sure the system transition, hosting, and maintenance is smooth
• Performed unit testing on all modules developed to ensure the functionality specified in the requirements is accurately reflected in the functionality of the application
• Provided recommendations and strategy for conversion of the PBMFR system
• Communicated regularly with the Contract and Grant Management team, as well as other developers and stakeholders; provide updates and clarifications on a daily basis
• Developed technical documentation and provide SBS with a comprehensive knowledge transfer at the completion of the contract
• Develop the Business Development Division Contractor application in .NET technology using C#
• Involved in web page design and coding
• Extensively used .NET controls like Master Page templates, Menu controls, grid view controls and file upload controls in the Web Forms
• Used Java Script for client side validation
• ASP.NET Authentication modes were used
• Responsible for developing the interfaced pages using Master Pages, Style sheets, AJAX in ASP. NET 3.0.
• Played a key role in writing stored procedures using SQL Server 2005 & 2008
• Compiled User Documentation for the project as a Lead Documenter.

Environment: ASP.NET 3.0, C#, AJAX, Web Services, Microsoft Excel & SQL Server 2005/2008

Confidential, NY

Lead PowerBuilder Programmer

Responsibilities:

• Responsible for writing non-visual user objects using Powerbuilder for interfacing the system with the databases (Sybase and DB2). These objects use OCX controls to interact with DB2 and make OCI calls to interact with Sybase.
• Responsible for database design, creation of tables and writing stored procedures using Sybase. Responsible for prototyping, designing user interface screens, preparing layout and report generation using Powerbuilder. Preparation of test plans. Responsible for analysis of the existing product, maintenance of bug history of the product, second level supporting providing bug fixes for low level problems. Responsible for new releases with enhancements, weekly status reporting and tracking. Made changes in modules developed using C language and communication modules.
• Responsible for database design, creation of tables in Sybase and designing of screen prototypes using Powerbuilder design environment and coding using the PowerScript language, preparation of test plan procedures and testing.
• Created and maintained mappings for the data migration from all the databases in NY, Hong Kong, London and Asia to a central depository in New York. Involved in creation and maintenance of all the ETL mappings using InformaticaPowerCenter as a front end and SQL Server, Oracle, and Sybase as the back end. Created mappings to re-format the files for the compatibility with the depository database in Sybase. Responsible for the complete application development lifecycle.
• Involved in coding a Java program to create a data file of all the trades with all the attributes (such as book, counterparty, debit quantity, credit quantity, number of trades, total number of trades, total debit quantity, total credit quantity) compatible to the system in London. The file is created for the London data center operations to maintain of all the trades entered in Hong Kong and New York via third party trade application software, Calypso, in their Bullit System. Also involved in coding a UNIX Korn Shell Script to transmit the data file to the London System and to maintain the transmitted data file in our local system.
• Coordinated with the development team and the traders to resolve the production real time issues with the trading workstation application to ensure a smooth functioning of the system.

Confidential, NY

Lead PowerBuilder Programmer

• Created and maintained mappings for the RDJ formatted files generation in order to be processed by RDJ. Created mappings to re-format the RDJ processed file to SIRIUS GL formatted file. Responsible for the complete application development lifecycle. Translated business requirements into technical specifications.
• Designed and developed a front-end application for the users to enter the adjustments to the month end data for all the modules including General Ledger, Loan, Money Market, DDA, Nostro, Letter of Credit, and Bankers Acceptance.

Environment: Sybase, Informatica, PowerBuilder v6.5, RDJ, Korn Shell Script, UNIX

• Created KORN shell scripts for the nightly process job to:
• ­ create an extract of events
• ­ process the events
• ­ transmit the accounting entries to the transaction level database and transactions to the GL system
• ­ send notification to the concerned technical team in case of an event of error

Environment: Korn Shell Script, UNIX

• Designed and developed a complex back-end batch process to load the regulatory reporting data on a daily basis. The process gets triggered immediately after the data warehouse nightly load jobs. The process comprised of the following steps: Executed stored procedure to load tables in the data warehouse. BCP all the tables containing FX data from data warehouse to the database residing on Regulatory Reporting production server.
• Executed POWERMART sessions using Regulatory Reporting production database.
• Created files in the Regulatory Reporting UNIX server.
• Imported FX data into another production server (IDOM).
• Created a complicated POWERMART session with all the lookup, filter, and expression transformations.

Environment: Informatica, Sybase, Korn Shell Script, Windows NT 4.0

• Designed and developed a suite of reusable framework components that is enabling this customer to move their fat-client PowerBuilder applications to a multi-tier, scalable platform.
• Developed PowerBuilder Windows that use this architecture which facilitates data access against the Sybase database. Instructed development team members on PowerBuilder functionality and enhancements, and set up Sybase development environment, including source code version control.
• Educated IS group on PFC architecture considerations, and coached them in determining when to use various DataWindow, UserObject, and Window Services.
• Created new PFC extension layer classes and functionality, implementing coding safeguards and robust error reporting. Created and extensively documented a prototype PFC-based application, so the developers unfamiliar with PFC could model subsequent application subsystems on working components. Also, researched and resolved interoperability/stored procedure conflicts between PowerBuilder and Sybase client software.
• Documented the solutions, and communicated them to DBA and development groups to reduce impact on development schedules. Created and documented a version upgrade and conversion strategy. Guided client in tool selection, and in application framework/class library design and construction.
• Defined project standards, while leading a PowerBuilder /Sybase team in enhancing Powersoft Foundation Classes (PFC) and creating custom application services and business objects (PFD layer).
• Created application distribution and deployment plan, and configured PVCS and PBNative source control/version control for PowerBuilder source code management and change control. Created and maintained detailed design documents and Microsoft Project plans for this application development initiative.
• Designed and developed a front-end application for the maintenance of the Budget in all the branch locations of SocieteGenerale. This application is used but not limited to the following:
• Maintain the budget allocations to all the responsibility centers.
• Monitor the expenses of each responsibility center based on varied expense categories such as Salaries etc.
• Maintain the revenues for the bank.

Environment: PowerBuilder v6.5, PFC, Sybase, Windows NT 4.0

• Designed and developed a Reconciliation program to perform the reconciliation from summary level (GL level) to the detail level (transaction level). Created stored procedures used for the reconciliation program.

Environment: Sybase SQL Server, PowerBuilder v6.5, PFC, Windows NT 4.0

• Technical Manager: Managed a project to upgrade PeopleSoft HRMS system from client/server architecture (v7.5) to Internet architecture (v8).
• Coordinated with systems engineering team to perform the installation and configuration.
• Managed and assisted a team of PeopleSoft developers to enhance the HRMS system features.
• Resolved the software technical and functional issues by troubleshooting the database, application, web, and process scheduler servers configuration.
• Coordinated with users, developers, and systems engineering group to ensure a smooth functioning of the system.

Confidential, NY

Lead PowerBuilder Programmer

Responsibilities:

• Responsible for developing the Y2K complaint OMS LITE client/server application to help the users to view, edit, and add new data through various sub-systems such as financial, consumption, inventory, purchase, shipment, and spoilage. Created stored procedures which are used: a) as a source for the front end client/server application. b) to transfer the data with manipulation between databases. c) to generate ad hoc reports for the users.
• Primarily responsible to change the existing nightly load batch job process between three different servers (two Sybase SQL Servers and one Microsoft SQL Server) and to design and develop a new method which takes care of all server problems.

Environment: PowerBuilder v6.5, Sybase SQL Server, Korn Shell Script, Unix, Windows 95

Confidential, NY

Senior PowerBuilder Programmer

Responsibilities:

• Responsible for the analysis, design, development, and maintenance of the Accounting Adjustments System. Adjustments System was designed to help the Accounting Personnel to enter the adjustments to the month end data for all the modules including General Ledger, Loan, Money Market, DDA, Nostro, Letter of Credit, and Bankers Acceptance.
• Responsibilities also included creating stored procedures for (a) the consolidation of all the adjustments and generation of the consolidation report, (b) for loading the data into data warehouse, and (c) for extracting the data from the data warehouse into a flat file. Also created configuration files using for the installation of the application on the entire user PCs.

Environment: PowerBuilder v5, PFC, Sybase SQL Server, C, VAX/VMS, Windows NT 4.0, Install Builder, S-Designor

Confidential, CT

Senior Programmer Analyst

Responsibilities:

• Responsible for the design and development of the screens to maintain the Deal System (Pilot System). A Deal is a unit on which the entire reinsurance business is dependent. The purpose of the system to set up deals with other insurance companies based on the factors such as coverage type, reinsurance basis etc. The Deal System will not only maintain the deal information but also the treaty and company information. Also involved in developing the data model for the Deal System. Created Stored Procedures for transferring the data from the new system tables to the existing system tables, for transferring the entire treaty and deal information from one company to another company, for updating the dates in multiple tables based on the user selection using. Created the configuration files for the installation of the system on the entire user PCs. Also created reports for the Group Treaty Information and Renewal Action Information.

Environment: PowerBuilder v5, Sybase SQL Server, C, Windows NT 4.0, Install Builder, S-Designor

Confidential, PA

Lead Programmer/Analyst

Responsibilities:

• As part of a project team, designed and developed the pilot screens which maintain the Technical and Commercial Attribute Configuration for the Order Management sub-system of OneVISION automation system for the steel industry. The screens assist the users in maintaining (creating, modifying, and deleting) the technical and commercial titles, descriptions, controls, constraints, and defaults. Solely responsible for the design and development of the screens for maintaining the Invoicing sub-system of aOneVISION automation system for the steel industry using.
• Involved in customizing the PowerTool framework as per the users needs. Enhanced PowerTool base windows and user objects functionality. Added new functions to the base window and user objects.

Environment: PowerBuilder v5, PowerTool, Oracle RDBMS, C, Windows NT, Install Builder, S-Designor

Confidential, MI

Programmer/Analyst

Responsibilities:

• As part of a project team, loaded database tables from the Financial Obligation System (FOS) database to the Michigan Architect Project (MAP).
• As part of a project team, developed the Michigan Department of Transportation Financial Obligation System (MFOS) application. Developed GUI screens and prepared the construction plan and the Window specifications documents.
• The MFOS application manages the financing of approved MDOT phases. Federal and State funding sources, the funding distribution and mix for approved phases, and the approval and rejection of funding obligations are all managed by the MFOS application. The MFOS application provides the coordination of Federal Fund Obligation and Disbursement, communication between Project Management, Program Control, Project Initiation, Project Accounting, and the Federal Highway Administration.

Environment: PowerBuilder v5, Oracle RDBMS and Pro*C, Windows

Confidential, MI

GUI Programmer/Analyst

Responsibilities:

• As part of a project team, worked on a Customer Order Management (COM2000) system. Project responsibilities were as follows:
• Participated in compiling Application Development Standards to govern the project PowerBuilder development environment. The purpose of this standard is to define PowerBuilder implementation techniques, expected benefits, reduced development time and increased level of quality.
• Participated in compiling Application Design Specification documentation for each of the sub-systems. These documents identify the various objects involved in each of the sub-systems. In addition, these documents are used extensively during the application development phase.
• Built conceptual models (reusable prototype screens) of the various sub-systems which constitute the COM2000 system.
• Developed screens for various sub-systems such as Customer Profile, Order Entry, Management Reporting, Metal Processing Order, Booking Plan, Shipping Profile, Pricing etc., which forms a part of the COM2000 system.

Environment: PowerBuilder v3, Oracle RDBMS and Pro*C, Windows

Confidential, CA

Programmer/Analyst

Responsibilities:

• As part of a project team, performed analysis, system design and development of an Information Warehouse System. Built conceptual models (reusable prototype screens) of the various sub-systems which constitute the Information Warehouse System. This Information Warehouse system included various sub-systems, such as Budgeting, Pricing, and Foreign Exchange. The screens for all the sub-systems were developed.

Environment: Gupta SQL*Windows, Oracle RDBMS, Windows