SUMMARY:

• Around 16 years of cross - functional experience (10 years at USA in client facing role), in the areas of Business Analysis, client/server and n-tier application design, development,test,implementation using traditional waterfall and agile(scrum) methodology also have wide range of experiences in various software languages and tools like Powerbuilder,Sybase,T-Sql,Pl/Sql,.Net etc. And also have good experience in different domain like utility services i.e. electric and gas, Point of sales operation, Fleet management and media sales & distribution system.
• Has been an analyst, application designer, developer and implementer at various sites in INDIA and USA
• Acted as a bridge/communicator between business stakeholder and IT development team.
• Gathered business requirement and helped IT team to translate those into software code.
• 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 business 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 traditional water fall and agile
• 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.
• Conversant with Project Management techniques and Agile methodology

TECHNICAL EXPERIENCE:LANGUAGES:

PowerBuilder: 9,11.5,C#.NET,T-SQL,PL/SQL,VB6,:

DESIGN:  ERD,UML

RDBMS:  SQL Server (T-SQL), Oracle(PL/SQL), DB2

WEB & CLIENT-SERVER TECHNOLOGIES:  ASP.NET,XML OPERATING SYSTEM Win NT/2000/XP/7/Unix/zOS. SDLC METHODOLOGY Water Fall, Agile SCRUM

TOOLS:  Crystal Report,SSRS,Microsoft Office Suite(MsAccess,MsExcel),Sql Plus,OraEditPRO,SqlProfiler,Query, CA Central Agile, Analyzer,Calypso,Autosys,Clarity,Toad,Luntbuild,

CONFIGURATION MGMT:  TFS, VSS, ,ENDEVOR,PVCS ,SVN

PROFESSIONAL EXPERIENCE:

Confidential

Environment: PowerBuilder 11.5, Sybase, SQL Server

Software consultant

Responsible for:

• Analyzed the end point and data dependency of each application
• Suggest appropriate data change and data input/output format change to different stake holders.
• Involved in its enhancement or change process starting from feasibility study or impact analysis, design, code change and code review. As per business need
• Gathered technical requirements and participated in design session
• Ensured compliance with established internal control procedures by examining records, reports, operating practices and documentations.
• Conducted weekly meeting with development and infrastructure team
• Co-ordinated with offshore team for different task/incident review.
• Conducted different code review session with team members.
• 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 Aqua Data 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.

ConfidentialEnvironment: PowerBuilder 11.5, Sybase, SQL Server

Business Technology Analyst/Database Programmer

Oak Brook, IL

Responsible for:

• Analyzed root cause of error and malfunction at different POS
• Suggest appropriate data change to Product Consulting Service team for the error
• Raised change request (CR) and represent the same at OCM that suggested by product Consulting team
• Conducted weekly meeting with development and infrastructure team
• Co-ordinated with offshore team for service now and peregrine task/incident review.
• Monitored package generation and delivery process for 14000+ restaurant
• Monitored external feeds to RMF like price and product feed through different import process report.
• Raise Task/incident for data change, script or script execution through peregrine tool development team
• Coordinated between Business Analyst and Development team
• Ensured compliance with established internal control procedures by examining records, reports, operating practices and documentations.
• 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.
• Provided 24/7 on call support rotation basis.

ConfidentialEnvironment: PowerBuilder 11.5, Sybase, SQL Server

Software Consultant

LosAngeles ,CA

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
• Gathered technical requirements and participated in design session
• Ensured compliance with established internal control procedures by examining records ,reports, operating practices and documentations.
• 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.

ConfidentialEnvironment: PowerBuilder 11.5, Sybase, SQL Server

Software Consultant

Columbia, SC

Responsible for:

• Provided Technical support by fixing bug and analyzed its root cause.
• Gathered technical requirements and participated in design session
• Ensured compliance with established internal control procedures by examining records ,reports, operating practices and documentations.
• 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.

ConfidentialEnvironment: PowerBuilder 11.5, Sybase, SQL Server

Software Consultant

Columbia,SC

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.

ConfidentialEnvironment: PowerBuilder 11.5, Sybase, SQL Server

Software Consultant

Columbia ,SC

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

ConfidentialEnvironment: PowerBuilder 11.5, Sybase, SQL Server

Tech Leader

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

ConfidentialEnvironment: PowerBuilder 11.5, Sybase, SQL Server

Sr Developer

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

Confidential

Environment: PowerBuilder 11.5, Sybase, SQL Server

Sr Developer

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

ConfidentialEnvironment: PowerBuilder 11.5, Sybase, SQL Server

Sr Developer

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

Confidential

Environment: PowerBuilder 11.5, Sybase, SQL Server

Programmer Analyst

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

Confidential

Environment: PowerBuilder 11.5, Sybase, SQL Server

Programmer Analyst

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