Career Summary:

• Around 13 years of experience in the areas of client/server and n-tier application design, development, implementation with wide range of experiences in various languages and tools. Have good experience in utility service domain particularly electric, gas and also in media sales and distribution system.
• Has been an analyst, application designer, developer and implementer at various sites in INDIA and USA
• Coordinated resources to ensure project needs are addressed and effectively assign tasks and deliverables to team members based upon their abilities.
• Supervises, motivates and mentor cross-functional /cross divisional project team members.
• Coordinated with team and end users to resolve certain post/pre-production issues
• Involved in complete SDLC phases of different Application development includes client server and n-tire application
• Used different software development methodology includes object and service orientation
• Involved in enhancement or change process starting from feasibility study or impact analysis, design , code change and code review phases of different mission critical changes.
• Involved in different module integration to existing on line transaction processing system.
• Analyzed existing design and relation of tables using ERD for different system enhancement .
• Developed different critical database objects include stored procedure, triggers.
• Enhanced performance of critical database objects by effective code change
• Tested different mission critical business rule validation components
• Integrated different complex database component as per business requirements
• Provided 24/7 on-call rotational support of application integration to users including issue resolution.
• Exposure working with different work environments and offshore onsite model.

Has extensively worked on:

TECHNICAL EXPERIENCE:

PROFESSIONAL EXPERIENCE:

MAJOR ASSIGNMENTS:

Brief description of the project:

This system helps NBC Universal to maintain its sales and distribution information of various entertainment products like Feature Film, TV series and various Media events. For its daily operation this system interacts with other system like CAF and RSS .It helps client to maintain detail of Field Order, Governing Deal, Document Assembly, licensee, territory and media rights apart from this it generates excellent reports that helps NBC to take efficient ,cost effective and timely decision to expand and promote this business .

Responsible for:

• Involved in its enhancement or change process starting from feasibility study or impact analysis, design , code change and code review. As per business need
• Analyzed existing design and table relation through ERD .
• Coordinated with team and end users to resolve certain post and pre-production issues
• Provided Technical support by fixing bug and analyzed its root cause.
• Made Changes in Power builder code that includes new User Objects,Editstyle,Window and Data window creation.
• Modified existing data window by addition, deletion, update of columns as per stored procedure change.
• Modified formula in Data Window to display some calculated value in Data Window field.
• Added new Sheet or new fields/controls to existing sheet
• Made appropriate power script and stored procedure change as per business need.
• Created/Changed different database objects using T-SQL as per business need .
• Created, Designed, Modified report as per users and Business requirement. It Includes data formatting, cross tab,grouping,summarizing,subreporting,graph,subtotaling and printing
• Enhanced performance of critical database objects by effective code change
• Tested different mission critical business rule validation components
• Maintained a source control and inventory system, to ensure appropriate version control.
• Documented the functionality, processing logic and business rules based on source code analysis and application execution.

This is an online transaction billing system for SCANA utility customers. The customer/Account/premises concept is the foundation of this system. Through this system SCANA is providing utility service bill to customer of south Carolina, North Carolina and Georgia. For its billing purpose this system is interacting with some other existing system like CAD Computer aided dispatch system and MIS Meter Inventory system . Thousands of users are interacting with this system from hundreds of different nodal offices for millions of customer records related to their utility bill generation process.

Responsible for:

• Provided Technical support by fixing bug and analyzed its root cause.
• Coordinated with team and end users to resolve certain post and pre production issues
• Involved in its enhancement or change process starting from feasibility study or impact analysis, design , code change and code review. As per business need
• Analyzed existing design and table relation through ERD .
• Made Changes in Power builder code that includes new User Objects,Editstyle,Window and Data window creation.
• Modified existing data window by addition,deletion,update of columns as per stored procedure change.
• Modified formula in Data Window to display some calculated value in Data Window field.
• Added new Sheet or new fields/controls to existing sheet
• Made appropriate power script and stored procedure change as per business need.
• Created/Changed different database objects using DB2,Cobol as per business need .
• Created,Designed,Modified crystal report as per users and Business requirement. It Includes data formatting,cross tab,grouping,summarizing,subreporting,graph,subtotaling and printing
• Enhanced performance of critical database objects by effective code change
• Tested different mission critical business rule validation components
• Maintained a source control and inventory system, to ensure appropriate version control.
• Provided 24/7 on-call rotational support of application integration to users including issue resolution.
• Documented the functionality, processing logic and business rules based on source code analysis and application execution.

Confidential

Brief description of the project:

• This project is to facilitate user to Capture/save, edit data and generate report about new gas services to a particular premise .Service generally a pipe laying process by which gas can be provided to appropriate premise.
• Through this module user can maintain different types of status for a particular service like New, Reverse, Abandoned etc and captures detail of material used during this process.
• Finally we integrated this module with the existing CSR Desktop billing system so that user can generate service order for gas services as well through their exiting service order module

Responsible for:

• Involved in its feasibility or change impact phase analysis
• Designed,Created,used new and existing user objects
• Made coding in different Response Window ,Window and Sheets
• Designed, Created Datawindow,editstyle,Menu,user objects.
• Analyzed existing design and table relation through ERD.
• Created, Changed Stored procedure using DB2,Cobol as per business need
• Created,Designed,Modified crystal report as per users and Business requirement.That Includes data formatting, cross tab,grouping,summarizing,subreporting,subtotaling and printing
• Involved in its enhancement or change process starting from feasibility study or impact analysis, design ,code change and review. As per business need
• Coordinated with team and end users to resolve certain post and pre production issues
• Integrated this module with exist billing system
• Enhanced performance of critical database objects by effective code change
• Tested different mission critical business rule validation components
• Maintained a source control and inventory system, to ensure appropriate version control.
• Documented the functionality, processing logic and business rules based on source code analysis and application execution.
• Provided Technical support by fixing bug and analyzed its root cause.
• .

Confidential

Brief description of the project:

This project is about conversion of Sybase database object with DB2 database objects for Service order Module of CSR Desktop ,which is billing system for different utility services. After this conversion whole CSR Desktop system is able to rely on one Database system that is on DB2.This conversion process enhanced performance ,security and maintainability of this existing desktop.

Responsible for:

• Involved in its feasibility or change impact phase analysis
• Designed/Created/used new/existing Power Builder user object
• Made coding in different Response Window ,Window according to change
• Designed/Created/modified Datawindow,editstyle .
• Analyzed existing design and table relation through ERD.
• Created/Changed/Converted Stored procedure using DB2,Cobol as per business need
• Developed tool to convert existing Sybase stored procedure to DB2 using VB.net
• Figured out Stored procedure dependability
• Provided Technical support by fixing bug and analyzed its root cause.
• Involved in its enhancement or change process starting from feasibility study or impact analysis, design, code change and review. As per business need.
• Coordinated with team and end users to resolve certain post/pre production issues
• Enhanced performance of critical database objects by effective code change
• Tested different mission critical business rule validation components
• Maintained a source control and inventory system, to ensure appropriate version control.
• Documented the functionality, processing logic and business rules based on source code analysis and application execution.
• Provided post production technical and functional support

Confidential

Confidential is being used by SCANA to capture data related to meter movement ,meter inventory ,Meter testing ,Meter reading and different equipment attachment into meter .this system is internally integrated with SCANA'S billing system to help different bill and report generation.

Responsible for:

• Worked as an off shore coordinator for Pinnacle Systems.
• Involved in its feasibility or change impact phase analysis
• Designed/Created/used new/existing Forms, reports,Classes,Functions
• Made coding in different layers like bisiness,service and data
• Made /changed code in code behind files as well
• Integrated existing database component with new components
• Created/Changed Stored procedure using DB2,Cobol as per business need Also designed and created crystal report as per users requirement.
• Analyzed existing design and table relation through ERD.
• Provided Technical support by fixing bug and analyzed its root cause.
• Involved in its enhancement or change process starting from feasibility study or impact analysis, design ,code change and review. As per business need,
• Maintained a source control and inventory system, to ensure appropriate version control.
• Enhanced performance of critical database objects by effective code change
• Tested different mission critical business rule validation components
• Documented the functionality, processing logic and business rules based on source code analysis and application execution.
• Coordinated with team and end users to resolve certain post/pre production issues

This system designed to track, capture, update different data related to the Secondary Sales of Pepsi Bottling Plant.DMS is an effective reporting tool for the sales marketing personnel and for upper management an efficient analytical tool for consumption analysis, inventory analysis, route wise sales Analysis.

Responsible for:

• Involved in its feasibility or change impact phase analysis
• Designed/Created/used new/existing Forms, reports,Classes,Functions
• Made coding in different layers like bisiness,service and data
• Made /changed code in code behind files as well
• Integrated existing database component with new components
• Created/Changed Stored procedure using T-SQL as per business need Also designed and created crystal report as per users requirement.
• Analyzed existing design and table relation through ERD.
• Provided Technical support by fixing bug and analyzed its root cause.
• Involved in its enhancement or change process starting from feasibility study or impact analysis, design ,code change and review. As per business need,
• Maintained a source control and inventory system, to ensure appropriate version control.
• Enhanced performance of critical database objects by effective code change
• Tested different mission critical business rule validation components
• Documented the functionality, processing logic and business rules based on source code analysis and application execution.
• Coordinated with team and end users to resolve certain post/pre production issues

This system is design to automate the different work related to faulty cards .It captures detail data beginning from Faulty cards Receive at repairing center to final dispatch from the Repairing center .These cards are generally received from different division or subdivision and also dispatched to respective division or subdivision. And eventually this system generates the different MIS report based on these data.

Responsible for:

• Involved in its feasibility or change impact phase analysis
• Designed,Created,used new and existing user objects
• Made coding in different Response Window ,Window and Sheets
• Designed, Created Datawindow,editstyle,Menu,user objects.
• Analyzed existing design and table relation through ERD.
• Created, Changed Stored procedure using T-SQL as per business need
• Created,Designed,Modified crystal report as per users and Business requirement.That Includes data formatting, cross tab,grouping,summarizing,subreporting,subtotaling and printing
• Involved in its enhancement or change process starting from feasibility study or impact analysis, design ,code change and review. As per business need
• Coordinated with team and end users to resolve certain post and pre production issues
• Integrated this module with exist billing system
• Enhanced performance of critical database objects by effective code change
• Tested different mission critical business rule validation components
• Maintained a source control and inventory system, to ensure appropriate version control.
• Documented the functionality, processing logic and business rules based on source code analysis and application execution.
• Provided Technical support by fixing bug and analyzed its root cause.
• Coordinated with team and end users to resolve certain post/pre production issues

Brief description of the project:

This system is about automation of different work related to Inventory and Purchase Management System like Stock Maintenance, Indent generation, Internal Demand generation, Purchase order generation according to the job order and Internal Demand. Store Transfer according to the Internal Demand. Purchase Receive according to Purchase Order. Issue Of item according to the Job card number, Vendor Registration and vendor rating.

Responsible for:

• Involved in its feasibility or change impact phase analysis
• Designed,Created,used new and existing user objects
• Made coding in different Forms ,Classes , Modules,Functions and Procedures
• Designed, Created OCX and DLL components.
• Analyzed existing design and table relation through ERD.
• Created, Changed Stored procedure,Triggers using PL/SQL as per business need
• Created,Designed,Modified crystal report as per users and Business requirement.That Includes data formatting, cross tab,grouping,summarizing,subreporting,subtotaling and printing
• Involved in its enhancement or change process starting from feasibility study or impact analysis, design ,code change and review. As per business need
• Coordinated with team and end users to resolve certain post and pre production issues
• Integrated this module with exist billing system
• Enhanced performance of critical database objects by effective code change
• Tested different mission critical business rule validation components
• Maintained a source control and inventory system, to ensure appropriate version control.
• Documented the functionality, processing logic and business rules based on source code analysis and application execution.

• Provided Technical support by fixing bug and analyzed its root cause.
• Coordinated with team and end users to resolve certain post/pre production issues

Brief description of the project:

This system deals with automation of inventory control and preventive maintenance system of the plant. These include indent generation and maintenance detail recording and Scheduling for equipment. And different report generation

Responsible for:

Involved in analysis and design but my core responsibility was to make coding and assembling the software.

Developed different classes and function using MFC.

Developed Stored Procedure using Pl/SQL.

Developed Triggers using Pl/SQL

Developed different GUI dialog box using existing functions and classes

Designed/Developed different crystal report for its billing and statistical record.

Provided Technical support by fixing bug and analyzed its root cause

Brief description of the project:

This POS designed to automatically accomplish the task of seaport operation. Starting from the ship/vessel arrival in its premises to departure from there. These works includes cargo loading and unloading, Different skilled labor allocation on the basis of shift and priority, Equipment allocation fork lift, crane etc to different ship/vessel for accomplishing the loading and unloading task. Also services water, emergency etc allocation to different vessel according to their requirement , And Also railway transportation to import and export cargo from the premises of port to different client/stevedore's premise .

Responsible for:

• Involved in analysis and design but my core responsibility was to make coding and assembling the software.
• Developed different classes and function using MFC.
• Study some of old component which was is in PowerBuilder
• Developed Stored Procedure using Pl/SQL .
• Developed Triggers using Pl/SQL.
• Developed different GUI dialog box using existing functions and classes
• Designed/Developed different crystal report for its billing and statistical record.
• Provided Technical support by fixing bug and analyzed its root cause