We provide IT Staff Augmentation Services!

Software Consultant Resume

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

Hire Now