Summary:

• 10 years of Oracle experience
• 18 years of PowerBuilder experience
• 6 months of WEB Development
• About 18 years of industry experience in Analysis, Design, Development and Implementation of client server systems
• About 15 years of US experience
• Work experience in PowerBuilder 11.5/9.x/8.x/7.x/6.x/5, Power TCP Controls, PFC 6.x, Forms 3.0, Oracle 10g/9i/8.0/7.1, Sybase 12/11/10, MS SQL Server 6.0, Sybase Adaptive Server Anywhere 9.0/8.0, PL/SQL, SQL Loader, TOAD, Visio, HOW Case Tool, Rational Rose, S-Designor, PVCS, Visual Source Safe 6.0 , Object Cycle Manager, Crystal Reports, Clarify, Wise Installation 6.0,
• Working knowledge of C , ASP.NET , MVC, HTML, CSS, Java Script, JQuery, Kendo, MS Visual Studio 2005/2010/2013, Visual Studio Team Foundation Server, SSRS, SharePoint
• Strong Knowledge of SQL Stored Procedures
• Experience in Object Oriented Analysis and Designing , CASE Tools , Use Cases
• Experience in Project Management, Client Management
• Experience in all stages of Project Life Cycle: Business Requirement, Analysis, Development, Testing, User Acceptance Testing, Implementation Production Support
• Experience in writing Tech Specs, Test Plan, Implementation Plan Test Results
• Industrial Knowledge In : Claims Management, Radio Programming, Retailer Business, Financial Accounting, Sales Purchase Accounting, Payroll Accounting, Wireless Communication
• Excellent Communication Skills

Software Competencies:

• Front End :PowerBuilder 11.5/9x/8x/7x/6x/5, PFC 6.0, Corner Stone 5.0, Forms 3.0, PL/SQL,SQL-Plus, PowerTCP WebEnterprise Tool
• WEB/ Tools : ASP.NET , C , MVC, HTML, CSS, Java Script, JQuery, Kendo, MS Visual
• Studio 2005/2010/2013, Visual Studio Team Foundation Server, SSRS, SharePoint
• Back End/Tools :MS-SQL Server 2012, Oracle 10g/9i/8.0/7.0, Sybase ASE 12, Sybase System 10/11,MS-SQL Server 6.0, MS Access, TOAD, MS Management Studio
• 2012/2010, DB Artisan
• CASE Tools :MS Visio 2003, HOW 1.01, Raditor 1.0, S-Designor 6.0, Rational Rose 5.0,
• ABC Flow Charter
• Other Tools :PVCS, Wise Installation 5.0, MS Visual Sourcesafe 6.0, Process Analyzer, Clarify, Crystal Reports
• Operating Systems :Windows8, Windows 7,Windows XP, Windows 95/NT, HP-UNIX, Sun SPARC

Selected Assignments:

Confidential

Role : Analyst/Developer

Environment :PowerBuilder 7.0, MS-SQL Server 2010/2012, MS Management Studio 2010/2012, MS Export/Import Tools, MS Analyzer, Windows7/Windows XP, Visio, PVCS, Visual Studio 2010/2013, ASP.NET, C , MVC, HTML, CSS, JavaScript, JQuery, Kendo, SSRS , SharePoint, Visual Studio Team Foundation Server

Responsibilities:

• Involved in Analysis, Design, Development and Implementation of Schedules System for Bankruptcy Group
• Involved in Analysis, Design, Development and Implementation of Banking Application for loading the paid items through one process and related reports
• Involved in Analysis, Design, Development and Implementation of customized Claims Management System screens and reports to accommodate the requirement of different cases/projects.
• Involved in Enhancement and Implementation of different systems i.e Integration GCG2020, Watchlist, GCG EFC, Ohio Maintenance and other related system in accordance to 2020 Systems
• Involved in writing complex stored procedures for data processing and also for reports which pulls data from different project databases
• Involved in ETL processes for different projects
• Involved in bug fixing in WEB Applications
• Involved in production support for multiple Applicatons

Salient Features:

GCG Inc is premier provider of Legal Administration Services for Class Action Settlements and other Claims Administration, solicitations, legal notice programs and Bankruptcy cases. Claims Management Systems is the core application which allows the company to keep track of claimants and process claims for different cases. System is customized to accommodate the requirements of different cases. GCG EFC application allows the data control group send the data for NCOA process and update the modified addresses through the system.

Confidential

Role : Analyst/Developer

Environment :PowerBuilder 11.5 , Sybase ASE 12, DB Artisan 8, Windows XP, Unix, PB Native

Responsibilities:

• Involved in designing creating new screens as per the New Business rules for the redefining AS 400 processes to migrate to Airwave.
• Involved in creating and implementing an new application Affiliate Master to download data MS CRM to Sybase database using Web Server Proxy via Affilate Portal Service Calls.
• Involved in writing complex stored procedure for implementation of Affiliate Compensation Process other related processes.
• Involved in writing Technical Specs
• Salient Features
• Confidential One is one the largest producer distributors of radio programming in the Confidential It broadcasts entertainment,news etc to about 7000 radio stations across Confidential. Airwave System is the core ERP system for Network operations in Client Server environment. Airwave System is a repository for Program information which are scheduled aired in different stations. MS CRM supports the affiliates contact informations and Affiliate Masters application is used to download the data from CRM database to Airwave DB through Affiliate Web Portal using Web Server Proxy Services.

Confidential

Role : Senior Analyst/Developer

Environment : PowerBuilder 9.0/8.0 , Oracle 10g/9i/8.0/7.3, PL/SQL, Cursors, SQL Loader,TOAD, Sybase ASA 9.0/8.0, Windows XP /Windows NT/95, Unix, PowerTCP WebEnterprise Tool, Visual Source Safe, Wise Scripting, MS Visio 6.0, Snagit7, MS Visual Studio 2005 ,ASP.NET

Responsibilities:

• Analyzing and implementation of the new Business Rules for different companies.
• Creating modifying different screens reports as per the Business group requirements
• Creating reusable NVOs to implement the business rules
• Used an third party OLE Control to implement transfer of data between local Sybase ASA database to the Oracle Database using the HTTPS protocol
• Extensively used dynamic features to modify Datawindow objects on runtime.
• Initiated the rewrite process of changing complex functions into stored procedures to improve the performance of the AMPS processes
• Involved in analysis, design ,development of PB dll download automation process
• and coded complex procedure to upload PB dlls as blob and also created a restart tool to automatically restart the application after the dll download process.
• Involved in analysis, design and development of security methodology for all applications including the Web applications and implemented using stored procedures.
• Involved in trouble shooting and resolving production issues.
• Completely handled maintains support for AMPS Admin and Metadata manager applications which involved writing complex SQLs to update data on Oracle Server
• Interacting directly with the business group to gather new requirements.
• Involved in writing technical specs, test plan and test results.
• Involved in converting Sybase SQLs to Oracle Stored procedures for web AMPS implementation.
• Involved in testing for web AMPS implementation.
• Coded complex procedure to upload PB dlls as blob

Salient Features:

Confidential is one of the world's top consumer goods companies. AMPS application is a promotion planning tool for the company. This assists the account managers in building, presenting and tracking promotion plans for their accounts. AMPS Administation application helped in maintaining the master data information for AMPS and other applications. Metadata Manager application helped in setting dynamically sqls criteria required to update the Local SQL Anywhere database and Oracle Server data during the data refresh and posting process for AMPS planning system.

Confidential

Role : Analyst/Developer

Environment : PowerBuilder 6.0/ PFC 6.0, Oracle 8.0, Windows NT, HP-UNIX

Object Cycle 2.0, PL/SQL, SQL-Plus, Clarify 1.0 :

Responsibilities:

• Involved in the production support activity which included Bug fixing, trouble shooting, database changes and enhancement of the different system as per the user requirement.
• Creating modifying different screens reports as per the Business group requirements
• Creating reusable NVOs to implement the business rules
• Extensively used PFC features in enhancement of the system
• Involved in writing stored procedures
• Involved in testing and implementation of the changes done to the system
• Interacting with the different users for getting the user specification.
• Used Object Cycle for Version control
• Used Clarify Tool for problem tracking

Salient Features:

Confidential One, subsidiary of Capital One, is one of the largest direct marketers of wireless services in the country. The Wireless Communication system caters to the day to day Sales and Services of the business. The main system : SSAMS Sales and Services Management System helps the associates in entering the customer details , history of the customer, the deals for mobile accepted by the different customer etc. Each account goes through different queues to get the authorisation process. Other system STARS, CAPI, BOMS helps in retention of the customer, creating new accounts, accounts saves and closes, account posting for billing the customer.

Confidential

Role : Analyst/Developer

Environment : PowerBuilder 5.0/ PFC 5.0, PL/SQL, Oracle 7.1, Windows 95

Responsibilities:

• Involved in Bug fixing and completing modification required in different modules of OPCS, GEO Geographic Data System and Security System and also involved in improving the performance of the system.
• Creating modifying different screens as per the Business group requirements
• Creating reusable NVOs to implement the business rules
• Extensively used PFC to enhance the features of the application.
• Reviewed the code for improving performance issues and implementing it
• Interacting with clients for getting requirement specification.

Salient Features:

Confidential is developed for Confidential Department of Commerce. Confidential helps Economic Development Agency EDA to track different project through the different phases of its life cycle Pre-approval of Grants/Financial tracking/ Post approval monitoring /other grants . OPCS interacts with other system like GEO Geographic Data System to get the geographical data. It generated multiple reports for tracking the different projects.

Confidential

Role : Analyst/Developer

Software : Power Builder 6.5/ PFC 6.0, Object Cycle 2.0, MS SQL Server 6.0,

Windows NT

Responsibilities:

• Involved in developing generic window templates using PFC features which can be used by the Team
• Involved in analysis and developing loading module to load the existing data from the old system and successfully completing the loading of data.
• Involved in analysis and developing billing extract module which create text files with the information extracted from the system and send it through e-mail as an attachment to the client.
• Salient Features:
• This is Care Management System developed for American Oncology based in Confidential
• The system provides solutions to the practitioner as well as the cancer patients. The system captures all the guidelines and the details of the cancer patients along with a comprehensive list of Providers all over Confidential It extents to capture the guidelines for AIDS also.

Confidential

Role : Project Leader/Technical Lead

Environment : Power Builder 5.0-6.0/ PFC , Crystal Reports, Sybase System 11,

Windows 95/NT ,S-Designor 5.0, HOW 1.0

Responsibilities:

• Involved in interacting with the end users to capture the requirement details and doing analysis using Case Tool HOW.
• Identifying process logic using Use Cases, Roles etc. for the integrated accounting system and designing the system and depicting the process in Case Tool HOW, designing CDM and PDM in S-Designor to match the requirement of the client
• Created reusable NVOs for different modules
• Used extensively PFC features for developing the system
• Involved in development and technically supported the team for different modules.
• Involved in writing triggers and stored procedures

Salient Features:

The integrated accounting system is developed to cater to the core functionality of Financial, Payroll and PF accounting of different client. The system was developed using the Object Oriented techniques and hence was able to implemented for different clients. The system includes the capturing of Personal Information, Monthly Processing, Leave Details, Loan, Tax Processing etc.

Confidential

Role : Analyst/Developer

Environment : Power Builder 4.0/ Power Tool 4.0, Sybase System 10,

Windows 95/NT, Rational Rose

Responsibilities:

• Involved in the Analysis of the business aspects and designing of the system
• Involved in developing the unique drill-down feature from Trial Balance to the Actual Voucher, Voucher Preparation and Voucher Authorization screen
• Involved in writing triggers and stored procedures

Salient Features:

The system caters to the needs of the Financial accounting and shipping business: capturing different events in Time Charter, Bareboat Charter and Voyage Charter. The system accounts for the different kind of Purchases and Maintenance activities taken place in the shipping business.

Confidential

Role : Project Leader/Technical Lead

Environment : Forms 3.0 , PL/SQL , Reports1.0, SQL-Plus,Oracle 7.1

Windows 3.1, HP-UNIX, Sun-SPARC

Responsibilities:

• Involved in the Analysis and design of the system and also interacting with client for requirement specification.
• Developed Forms and reports in the system
• Involved in technically supporting the team in other modules
• Involved in writing triggers and stored procedures

Salient Features:

Financial Accounting System which involves preparation of payment and receipts vouchers, Credit Note and Debit Note. System provides all statutory reports required in Financial Accounting. Purchase Accounting captures information at different events: Purchase Order, Stores Receipt Note Preparation, Billing and Payment to the Supplier. Sales accounting tracks events: Sales Order, Delivery Challan, Invoicing and Receipts from customers.

Confidential

Role : Developer

Environment : Forms 3.0 , PL/SQL , Reports1.0, SQL-Loader , SQL-Plus, Oracle 7.1,

Windows 3.1, HP-UNIX, ABC FlowCharter

Responsibilities:

• Involved in developing Forms and reports
• Involved in writing stored procedures in PL/SQL
• Involved in loading data using SQL-Loader.

Salient Features:

Financial accounting system caters to the day to day activity of the accounts department. The conversion program was required by the Financial Accounting system in Oracle so that the pending vouchers which was already entered through COBOL are readily available for processing when the system goes online after Implementation. The system includes screens for correction of erroneous data and reports.