SUMMARY

• Overall Project Experience: Information gathering, Technical Design Analysis with Prototypes, functional Analysis, Programming, Testing, Implementation, Training Support and Production Support. Knowledge in Commercial applications like Dealers Solutions, Banking, HealthCare, Financial Accounting, Inventory Control, Production Analysis Payroll etc.
• 18 Years' Experience in PowerBuilder -Version 5 to 12.5
• 18 Years' Experience in SQL Oracle, SQL Server, Sybase, DB2 Informix .
• 8 Years' Experience in Oracle PL/SQL

• 6 Years' Experience in SQL Server T-SQL with MS Management Studio.
• 5 Years' Experience in DB2/Informix/4GL.
• Good Understanding and Knowledge of C .Net, ASP.NET, Java/Eclipse
• Good Understanding and Knowledge of SQL Developer and TOAD.
• Good Understanding and Knowledge of Source Control tools. Clear Quest, PVCS, Harvest SVN .
• Good Understanding and Knowledge of SSIS SSRS.
• Good Understanding and Knowledge of Data Modeling Normalization.
• Good Understanding and Knowledge of Agile Waterfall methodology/SDLC.
• PowerBuilder Technical Knowledge 18 Years working experience
• Excellent knowledge about object oriented Concepts such as Inheritance, Encapsulations, Polymorphism, override overload functionalities. Create modify the Powerbuilder interface Class such as different types of Windows, Menus, Visual Non-Visual User objects Controls Datawindow objects with all type of Data Sources, presentation styles, Edit Styles Reports, Develop code using best practices for modularity, error handling, auditing, multi-user and performance, write efficient code with advanced concepts such as Data Store, Share Data, Dynamic data window objects functionalities, user events functions, Embedded Dynamic SQL, Database connection and transaction management, Debug the application programs to fix and maintain existing code, Develop unit tests to ensure code works as designed Good knowledge of PFC PowerBuilder foundation Class .
• SQL Technical Knowledge 18 Years working experience
• Excellent knowledge in DML, DCL DDL Concepts, efficient complex SQL queries using Inner joins, Self-joins, Outer joins, Cross joins, Union, Intersect, Minus, subqueries, Group by, Having, Order by, numeric/non-numeric/date/conversion functions , Indexes, clustered non-clustered, Views Referential integrity, Constraint such as Primary key, Foreign key, Unique Key, Not Null Check etc.
• Oracle PL/SQL Technical Knowledge 8 Years working experience
• Create modify Procedures, Functions, Packages, Triggers, Sequences, virtual table columns, Dynamic SQL, Collections such as Records table-wise, Cursor-wise, user defined wise , Bulk Collect, tables, Varrys, Nested tables, Index By Table, Loops, cursors Implicit, explicit, REF, for loop with parameters , Predefined/Non Predefined/User Defined Exceptions Debug to fix and maintain existing code.

Confidential

Title: Sr. PowerBuilder Developer

• Environment: PowerBuilder Ver.12.5, PFC, PL/SQL, SVN, Sybase agile methodology.
• Project Responsibilities: Business Analysis Information gathering from End users and business analysts Technical Design Analysis Unit Test with Prototype and Coordinated with DBA group, applied knowledge of database design standards Production Support with Firewall trouble shooting, modifications and fix production problems Writing functional and technical specifications, technical documentation Training to Trader Group End Users
• Brief Project Profile: John Deere Company, is an American corporation that manufactures agricultural, construction, and forestry machinery, diesel engines, drivetrains used in heavy equipment, and lawn care equipment. EQUIP application used to maintain John Deere their Dealers accounting systems including includes module Accounts Payable, Accounts Receivable, Cash Processing, General Ledger, Parts Administration, Parts Processing, Rental administrations, Sales Processing, Sales Professional, Service administration, Service Processing, Service administrations, Services marketing, Service Processing, Service Tech., Standard Job Pricing, Managements reports Warranty Processing etc.

Confidential

Title: Sr. PowerBuilder Developer

• Environment: PowerBuilder Ver.11.5, PL/SQL, Informix/4GL, Crystal Report 10 Toad.
• Project Responsibilities: Business Analysis Information gathering from End users and business analysts Technical Design Analysis Unit Test with Prototype and Coordinated with DBA group, applied knowledge of database design standards Production Support with Firewall trouble shooting, modifications and fix production problems Writing functional and technical specifications, technical documentation Training to Trader Group End Users
• Brief Project Profile: Yamaha Motor Corporation, U.S.A. is a growing and dynamic organization with superb products that includes motorcycles, outboard motors, ATVs, personal watercraft, snowmobiles, boats, outdoor power equipment, race kart engines, accessories, apparel, and much more. G-fast application used to maintain Yamaha accounting systems including inventory control Accounts systems, customer, sales and purchase functionality, warehouse functionality including order entry, allocation, picking shipping to customer etc.

Confidential

Title: Sr. PowerBuilder Developer

• Environment: PowerBuilder Ver.11, PFC, Harvest, PL/SQL, Sybase Toad, Crystal Report ClearQuest.
• Brief Project Profile: HighMark Financial System used to calculate rates for renewals and quotes for existing customers, execute key rating processes on both a scheduled and on-demand basis, support both experience and demographic rating techniques, accommodate specific regional rating requirements, provide definable calculation rules in order to meet niche needs of the market.

Confidential

Title: Sr. PowerBuilder Developer

• Environment: PowerBuilder Ver.11, PFC, Harvest, PVCS, Oracle PL/SQL. ClearQuest.
• Brief Project Profile: BlueStar included all of the necessary processes to add and maintain an account for the customers. The BlueSTAR structure consists of various levels of datas such as Provider Maintain, Account Data, Benefit Agreement Data, Category Data, Group and section, Billing Profiles, Member data, Subscriber Details, Product data, Provider Data, Regulation Data, ID Card request, Corporate Product data, Inquiry Billing.

Confidential

Title: Sr. PowerBuilder Developer

• Environment: PowerBuilder 9.0, PVCS, Mainframe DB2 , Oracle PL/SQL Sybase
• Brief Project Profile: The Global Securities Lending system GSL was created as a tool to facilitate and process the whole lending process for Securities Lending program and department GSL have different module based upon the responsibilities of each division in Security Lending department of Trading, Operations, Reporting and Relationship Management. Each of these components reflects the activities and the personnel involvement in the process of lending securities.

Confidential

Title: Sr. PowerBuilder Developer

• Environment: PowerBuilder 6.5, PFC, SQL Server Crystal Reports
• Brief Project Profile: License 2000 is a comprehensive, state-of-the-art license processing system currently being used to License millions of professionals. License 2000 Tracks all information and requirements, including profession and License type, requested by a credentialing agency or Board. Users could enter and maintain information about applicants and Licensees. The section provides a step by step approach to entering a new applicant, searching for an existing applicant, maintaining information about licensees, renewing licenses, entering complaints about a licensee, tracking accounting information, generating reports and printing License 2000 documents.

Confidential

Title: Sr. PowerBuilder Developer

• Environment: PowerBuilder 4.0, PFC, Sybase Store Procedures, functions, Triggers
• Trust Revenue Accounting System was created as a tool to facilitate and process the whole lending process for Securities Lending program and department. That have different module based upon the responsibilities of each division in Security Lending department of Trading, Operations, Reporting and Relationship Management. Each of these components reflects the activities and the personnel involvement in the process of lending securities.

Confidential

Title: EDP Manager

• Environment: FoxPro, COBOL, DB2, Windows UNIX
• Project Responsibilities: Managed the EDP department, Enhancement Maintenance of the exiting Application User training. Involved System Analysis, Design, Development, Coding, Support Testing using PowerBuilder, COBOL Oracle, Designing interfaces with different type of Window objects, user objects and controls and applied the same with object oriented functionalities Dynamic data window objects functionalities, Data store, Database connection and transaction management, Perform debugging and testing. Creating and executable and testing PowerBuilder c application and software migration, Wrote triggers, functions and procedures to implement applications functionalities
• Financial Accounting Systems :An In-house Project, it deals with Accounts, Sales Purchase of the company and generate the various report like balance sheet, Profit Loss Account, General Ledgers, Sub-Ledgers, Vendors and Customers Analysis, Trial Balance, Bank and Cash Registers Outstanding statements of Sales and Purchase etc.
• Inventory Control Systems.:An In-house project, it deals with purchasing, Inventory maintenance and customer order processing of the Company. It allows the user to keep track of goods in stock, goods in order and handing of customer order. This application generate the various type of reports involving statements, item ledgers, receipt issue registers, age-wise analysis, ABC analysis, Non-moving items, Excess Inventory, Re-Order Positions, Department-wise consume statement etc.:Payroll Systems
• This project deals with the generation of pay slips of employees with different grades taking in account the allowances and the leaves for which they are entitled along with the deductions, if applicable. This application generates various types of reports like monthly pay slips, bonus calculations, tax calculations, monthly yearly reports including MIS leave details etc.