SUMMARY

• 18 years of total IT experience including 15 years of US experience in system study, analysis, design, development, migration, integrating, testing, documentation, implementation and support of various projects through their entire life cycles using client/server technology.
• Have good knowledge of Relational Database concepts, GUI, Client Server architecture, Objected Oriented technology, SDLC and Testing under Windows and UNIX environment.
• Developed, maintained and supported several PowerBuilder applications using the versions 5.0 to 12.5 with Oracle 7.x to 11g, MS SQL Server 6.5 to 2012, Sybase and DB2 as back - end.
• Have experience, functional and domain knowledge with different clients like Energy (Power, Oil & Gas), C/ETRM, Utility, Financial, Trading, Tax, Manufacturing, State, Federal Government, Transportation, Telecommunication, Banking, Educational and various types of business application systems.
• Excellent problem solver and quick learner. Ability to lead, work in a team environment and can easily adapt to any other software with less time. Flexibility and responsiveness to changing priorities. Work in a cross-functional environment for enterprise projects.

TECHNICAL SKILLS

GUI: PowerBuilder 12.5/12.0/.NET,11.5, 10.5/9.0/8.0/7.0/6. x/5.0, PFC, Java 2.0, Visual Basic 6.0/5.0, D2K

DATABASE: Oracle 11g/10g/9i/8i, SQL Server 2008 R2/2005, Sybase 12.x/11.x, SQL Anywhere, DB2, MS Access

TOOLS: SQL Navigator 3.11, SQL Developer, DBArtisan, ERwin, Power Designer, DTS, SSIS, Query Analyzer, SQL Enterprise Manager, Batch Job Server, FTP Client, MS Office, Visio, PVCS, Visual Studio, Visual Source Safe, PB Native Source Control, Business Objects 5.1, MTM, TFS, soapUI, Crystal Reports

LANGUAGES: SQL*Plus, T-SQL, PL/SQL, PowerScript, Pro*C, HTML, ASP, .NET, JDK 2.0, JDBC, XML, C#, C++

OPERATING SYSTEM: Windows 7/XP/2000/98/95, Windows NT 4.0/3.51, UNIX, MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. Technical Consultant

ENVIRONMENT: SolArc RightAngle 9.0.5, PowerBuilder 9.0.2, MS SQL Server 2008 R2, 2012, Visual Studio 2010/2012, Citrix, Team Foundation Server (TFS), MS Office 2013, Windows 7

Responsibilities:

• Customization of the RightAngle modules to many clients.
• Enhancements to the RAIV system according to client requests to different modules/desktops within RightAngle.
• Upgrades from older versions to new versions.
• Worked on PB datawindow Invoice templates, RTE and Word Document templates for generating the Invoices, Statements and Contracts.
• Production Support, RA (PB/.NET) Product Installations and Environment setups.
• Data Configurations and Troubleshoot the issues.
• Created packages for implementations.
• Created test cases, unit test on the screens before delivery.
• Analysis, design, development, gather requirements, specifications, provide HLEs, troubleshooting, code reviews, testing, configurations and documentation.

Confidential, Round Rock, TX

Sr. Technical Consultant

ENVIRONMENT: PowerBuilder 12.5, Oracle 11g, Visual Studio 2012, SQL Developer, Citrix, Web Services, Team Foundation Server (TFS), Microsoft Test Manager (MTM), Soap UI 4.0.1, SOA, TOAD, .NET, XML, Visio, Sharepoint, MS Office 2013, Windows 7

Responsibilities:

• Worked on the Pricing (CalcPricing) module of Financing Connect project.
• Created DB scripts for Build Transaction and created different scenarios to test Pricing Web Services.
• Involved in analysis, design, development tasks, configuration, unit testing, system testing, performance testing and deployed pricing web services in application servers.
• Reviewed the logic and code for the Calculate and Process buttons in eBoss to use in Pricing.
• Created and updated the Installation Instructions document(s) for Pre Requisites, PowerBuilder components, Pricing Web Services for DIT deployment.
• Created INI, runtime package files that were required for MSI builds and other configuration files, Test suites and Pricing run time builds. Installed IIS, .net framework and other required software(s).
• Verified the data flow and table updates for pricing module to match up with current eBoss application.
• Created many test cases, tested and executed in MTM for all the countries which fall under EMEA region.
• Created defects, troubleshoot and fixed the defects and tested the defects in DIT environment for Phase 2.
• Created many transactions, few dealers and customers in development and testing environment to test all the possible scenarios with different contract terms, finance types, local lease types and assets.
• Worked with business users, involved in requirement gatherings, team meetings, technical documentation and supporting the above application.
• Supported Pricing application and also worked on few tasks of FEAC and RTB projects.

Confidential

Lead Programmer/Analyst

ENVIRONMENT: PowerBuilder 12.1, MS SQL Server 2008 R2 / 2005, MS SQL Server Management Studio, SQL, T-SQL, MS Office 2010, Serena PVCS, Citrix, Track-It Windows 7

Responsibilities:

• Worked on new modules and many enhancements to the OMS System.
• Requirements gathering, analysis, design and development, unit testing and implementation.
• Worked on new reports, modifying existing reports, bug fixing, unit testing and ongoing applications support.
• Created, modified many database objects that were required for the development and enhancements.
• Responsible for code review, source code maintenance, build and release the Test and Production environments in Citrix servers.
• Produce required spreadsheets (data requests) as per system/business users/VA needs.
• Documentation of the new functionality changes and for major enhancements.
• Send status of the tasks to the IT Manager/CIO/Business Users on weekly or daily basis.
• Install all software applications that were necessary, give training on the modules and application objects.
• Responsible for Source control management, Change control management and track all the tasks.
• Using and maintain different tools that were necessary for this OMS project and other portal applications.

Confidential

Sr. Applications Developer

ENVIRONMENT: PowerBuilder 12.0/.NET/10.5/9.0, PFC, MS SQL Server 2005/2000, T-SQL, Citrix, Oracle 10g/9i, Epsilon, Endur, XML Spy, MS Office 2010, Visual Source Safe, PB Native, Windows XP / 7

Responsibilities:

• Worked on new development, enhancements for CAISO Bidtool application.
• Worked on enhancements of MISO and PJM Bidtool applications.
• Involved in requirements gathering, analysis, team meetings, and meetings with business users.
• Created, modified many database objects that were required for the development and enhancements.
• Involved Unit Testing, Integration Testing for many screens and modules.
• Responsible for code review, source code maintenance, building executables and implementation of releases.
• Involved in Data Migration, Data Backup, Maintaining Teams Network drive, Data Pipelines, etc.,
• Produced required spreadsheets as per business user’s requests.
• Involved in Applications Production Support and database administration.
• Energy trading applications (Trade Floor experience) and ongoing Production support for the above applications.
• Worked on enhancements on RTDispatch application.
• Wrote Business Case, Functional Design, Technical Design Documents.
• Maintained the source control software and application releases.
• Have exposure to various ETRM tools, Power Exchange and Energy applications and data.
• Developed a new application RA Capacity using newer versions PowerBuilder 12 and .NET and worked on the enhancements and production support.
• Designed and modified the database tables, sequences, triggers, constraints, indexes for this RA Capacity Sales Automation project.
• Converted the application to PB 12 .NET from PB Classic 12.
• Created mock-up screens, work-plan before actual development.
• Created many Bubble Charts, Bar Graphs and Pie Charts for analysis for users and CEO.
• Responsible for code review, testing, UAT and Production releases, deployment and installations for users.