EXPERIENCE SUMMARY:

• Decisive, Diligent, Result Focused, Dedicated Computer Software Engineer with 19+ years of experience in developing & supporting client server/WEB applications, Database Architecture & Development, Data Interfaces, Data Warehousing, Custom Reporting Tools for companies of Financial services.
• Extensively worked in PowerBuilder (V3 - V12.5.2) with Confidential ’s, Oracle (V7 - V11GR2) Database & PL/SQL, MS SQL server 2000-2012 & T-SQL, Sybase & TSQL, DB2. Designed/Developed/supported many applications as well as Designed & scripted many databases and it’s Database objects (Functions, Triggers, procedures, packages). Have a very good understanding of OOP’s Concepts and used it extensively. And a very good experience with multi-tier architectures.
• Extensive experience in Capability Maturity Model Integration (CMMI) Level 3-5 environment & have comprehensive knowledge of full project life cycle using well defined Traditional Waterfall, SCRUM, RUP and Agile Extreme Programming methodologies. Worked with companies of different environment and sizes (Small, Medium and Large corporations).
• Extensively worked in Migrations, reverse engineering, configuring and managing the PowerBuilder apps using Oracle & MS SQL Server databases with ER tools. Analyzing the application for performance and tuning them, setting up & managing production/testing/development environments and done workflow process documentations.
• The diversity of projects on which I have utilized my PowerBuilder & DB skills has provided me with a unique expertise that brings to your organization the value of robust and cost effective solutions for your system’s needs. I can work effectively with your in house staff to gather, define, design, code, test and implement system solutions. In the process will be closely working and building working relationships with Development, DBA’s, BA’s, Quality, IT Infrastructure team, Stakeholders and customer base.
• Strong communication, presentation, negotiation, verbal, analytical and problem-solving skills with entrepreneurial leanings. Self starter and fast learner with very little directions. A keen and inquisitive technology follower, always in touch with the current technology developments/trends related to software and hardware of computing devices with various IT Companies.

PROFESSIONAL EXPERIENCE:

President / Software Engineer

Confidential, Los Angeles, CA

Responsibilities:

• Application Maintenance & Enhancement of Confidential ’s PACE - Commercial Admin System; using PowerBuilder V12.0 with Sybase DB.
• Commercial Admin maintains Confidential Network Channel’s TV programming, commercial timeslot logs. Worked with development, DBA’s, QA’s on maintenance of the System.

Tools: and Environment: PowerBuilder (V12.0) with Confidential ’s, Sybase 15.5, TSQL, Toad 3.1, TFS, Issue Tracker- Ticket Management, MS Outlook/Word/Excel.

Confidential, Austin, TX

PowerBuilder Developer/Analyst

Responsibilities:

• Supported the Application Maintenance & Enhancement of QLS - Quality Letter system for 4 Contracts DB (DME, PBN, PBS and PAE); using PowerBuilder V12.5.2 with MS SQL Server DB. Worked with development, DBA’s, BA’s, Quality, Stakeholders on maintenance of various Modules - Medical Claim Cases, Claims Info, Claims Decisions, QLS Claims &Mainframe Interface, QLS Letter generation and QLS Maintenance of Master tables.

Tools: and Environment: PowerBuilder (V12.5.2) with In house PB Framework, MS SQL Server 2012, TSQL, PowerDesigner (V16), TFS, Oracle Web Server - Claims Imaging System, Attachmate - Mainframes, Axosoft & C2C Kaseya Ticket Management, MS Access/Project/Word/Excel/Visio.

Confidential, Lincoln, NE

Sr. PowerBuilder (PB) Developer/Analyst

Responsibilities:

• Supported the Application Maintenance & Enhancement of Confidential - Child Support Enforcement Computer system; using PowerBuilder V12.5 with PowerFrames & IBM DB2 DB. Worked with development, DBA’s, BA’s, Quality on maintenance of the system of various folders - CSE Case, Court case, Enforcement, Intergovernmental and Organization.

Tools: and Environment: PowerBuilder (V12.5.2) with PowerFrames, IBM DB2, PowerDesigner (V16), Share Point, MS Access/Project/Word/Excel/Visio.

Confidential, Austin, TX

Sr. PowerBuilder Developer/Analyst

Responsibilities:

• Responsible for reverse engineering the After Sales Repair System ( Confidential ); using PowerBuilder V11.5 with Confidential ’s & Oracle DB. Converted the Korean Confidential Application into English using translation Tool and developed extended Translation tool for further analysis and documentation of Confidential .
• Responsible for technical documentation of Confidential for Web team for web conversion. Worked on Confidential application and database on Receipt, Warranty, Material, Settlement management modules. Coordinated the work with the in house development team and offsite team.

Tools: and Environment: PowerBuilder (V11.5 - V12.5.2) with Confidential ’s, Oracle (V11G R2), PL/SQL Developer, PowerDesigner (V16), SQL Anywhere 11, Share PointHP Quality Center, PB Tools, MS Project/Word/Excel/Visio, Angular- Java.

Confidential, Little Rock, AR

Sr. PowerBuilder Developer/Analyst

Responsibilities:

• Managed the Application Maintenance & Enhancement of Confidential - Children’s Reporting Information system used by state of Arkansas Confidential (Department of Children & Family Services, a division of Confidential ); using PowerBuilder V12.5 with Confidential ’s & Oracle DB, MS SQL Server DB.
• Worked with development, DBA’s, BA’s, Quality, IT Infrastructure team on maintenance of the system of various modules - Client, Referral, Investigation, Case, Child Placements, Differential Response, Provider and On call for CACD(Crime Against Children Department). By Keeping up to the requirements of SACWIS ( Statewide Automated Child Welfare System)
• Managed, worked along with the development & DBA’s team on Production support, Daily & Monthly batch process, Reporting systems for Confidential in Oracle & MS SQL Server Databases.
• Worked on the HP Quality Center tickets and taken full responsibility of the completion of the Confidential tasks by coordinating the work with the business Analyst team.

Tools: and Environment: PowerBuilder (V11.5 - V12.5.2) with Confidential ’s, Oracle (V11G R2), MS SQL Server 2008 R2, SSRS, SSIS packages, PL/SQL Developer, TSQLPowerDesigner (V16), Visual Studio 2003 - 2008(C#.NET, ASP.NET), IIS, TFS, HP Quality Center, Harvest, MS Project/Word/Excel/Visio, Windows Install Shield.

Sr. Software Engineer

Confidential, Seattle, WA

Responsibilities:

• Managed the Application Support & Maintenance of Compass - a Worker’s compensations Claims management system; using PowerBuilder V12.5 with Confidential ’s & Oracle DB. Worked with development, DBA’s, BA’s, Quality, Offshore team, IT Infrastructure team on maintenance of the systems.
• Enhancement of Claims Conversion Tool using PB, Oracle & MS SQL Server to manage the migrations of New Claims & Policy info into Confidential systems.
• Managed, worked along with the development team on Production support, Daily & Monthly batch process, Reporting system for Claims & Policy management.

Confidential, Baton Rouge, LA

Responsibilities:

• Managed the Application Support & Maintenance of PowerComp - a Worker’s compensations policy management system; using PowerBuilder V12.5 with Confidential ’s & Oracle DB.
• Worked with development, DBA’s, BA’s, Quality, IT Infrastructure team on maintenance of the systems.
• Worked on the Helpdesk tickets and taken full responsibility of the completion of the PowerComp tasks by coordinating the work with the corresponding business users.

Confidential, Norwalk, CT

Responsibilities:

• Managed the Application Support & Maintenance of Capital Asset Reporting System ( Confidential ) using PowerBuilder V10.5, Confidential ’s with Oracle DB. Worked with development, DBA’s, Quality, IT Infrastructure team to streamline the offshore process along with the onsite team for Support and Maintenance.
• Taken the full responsibility of the completion of the Confidential tickets and tasks by coordinating the work with the corresponding business users.

Tools: and Environment: PowerBuilder (V10.5 - V12.5) with Confidential ’s, Oracle (V10G R2), MS SQL Server 2008 R2, PL/SQL Developer, PowerDesigner (V16), TFS, GUSServiceNow Tickets, MS Project/Word/Excel/Visio, Star Team(V5.3).

Confidential

Project Leader ( Consultant)

Responsibilities:

• Managed development of Enhancements of Confidential - USA, International Society of Certified Electronics Technicians ( Confidential ) - USA applications using PowerBuilder (v8.0) & MS SQL Server 2008 R2.
• Managed the Application Support & Maintenance Practice for various clients Verizon - USA, Radiance - Singapore, Volt-Telecom - USA for FieldPower Product.
• Worked with the Applications (Web, Client Server, ERP, Database, Mobile), DBA’s, Quality, IT Infrastructure team to streamline the offshore process along with the onsite team for Support and Maintenance of the projects. Taken the full responsibility of the completion of the tickets and tasks by coordinating the work with the corresponding business users at the client.
• In a Matrix Organization model, managed 24X7 Support, Resources and Code & Project Releases by working along with the onsite & offshore team in India.

Tools: and Environment: PowerBuilder (V8.0) with Confidential ’s, MS Project/Word/Excel/Visio, Oracle (V10G R2), MS SQL Server 2008 R2, T-SQL, PowerDesigner (V9.5)SharePoint server 2007, Visual Studio 2003 - 2008(C#.NET, ASP.NET), SAP R/3, Tortoise SVN, WebSphere, Tomcat, IIS (V6.0), Atlassian JIRA Ticket Tracking System.

Confidential, San Francisco, CA

Application System Engineer

Responsibilities:

• Responsible for development of new enhancements by doing Requirements gathering, research & analyze and Maintenance of Confidential (You owe me- Retail Banking system) PowerBuilder (PB) application by coordinating with the team, stakeholders & managing the budget, cost and schedules.
• Responsible for technical documentation of Wachovia IT system integration, Confidential application and database for Forecasting, Bankruptcy, Recovery, Disaster & Damage of housing, Audit history modules. Completed the integration with web migration team by working along with the onsite team & management by managing the business users, consultants and IT vendors.
• Responsible for Confidential application tickets in Clearquest, Pac2000 & TAR tracker system by taking full responsibility of the completion of the task by coordinating the work with the DBA’s, business users and support team members onsite & offshore. Was involved in the status meetings, production maintenance and release management by working along with the offshore team in India.

Tools: and Environment: PowerBuilder (V10.5) with Confidential ’s, Oracle (V10G R2), PL/SQL Developer, PowerDesigner (V9.5), Java, J2EE Technologies (JDBC, EJB, ServletsJSP), Web Logic Server, Perl, SharePoint server 2007,Rational ClearCase & ClearQuest, Pac2000 & TAR Tracker, MS Word/Excel/Visio, REX, Visual Expert (5.6).

Confidential, Stamford, CT

Sr. Programmer Analyst

Responsibilities:

• Responsible for Migration, Enhancement & development of Confidential IT systems which include Confidential Call Center System ( Confidential ), Confidential Proxy System, Corporate Governance system, Cede stock watch system, Proxy Material management System. Instrumental in taking over the responsibility of the software systems and implementing the management’s Technological strategy of Project management by following Agile project management methodology. Managed and coordinated the onsite and offshore team at Dallas, Texas Call center & Long Island, New York processing center.
• Completed the implementation of Confidential Global System - a PB shareholder securities system for the global business users by coordinating the work with the external consultants. Worked with them to design, develop, migrate and deploy the application by working with DBA’s, business users and stakeholders by managing the financials, risk and schedule of the project.
• Setup the DB replication and created database procedures & functions for data flow between various applications. Created the import process of the data from various sources by scrubbing them with business logic before importing into the application database. Implemented Data warehousing System for Confidential using ETL processes with extensive documentation of the process.

Tools: and Environment: PowerBuilder (V10.5)/(V11.1) with Confidential ’s, MS SQL Server 2005, T-SQL, Oracle (V10G R2), PL/SQL, EAServer (V6.1), MS Access/Word/Excel/ Visio, VBA, REX, Visual Expert (5.6), Cisco VPN(V4.8), PcAnywhere (V12.0), Dameware, Windows Terminal server.

Confidential, Shrub Oak, NY

Sr. Application Consultant

Responsibilities:

• Worked as a consultant in managing and supporting the IT software Applications and Databases for Glencore commodities Backoffice Trading systems.
• Worked to establish the management and support team for the IT software Applications and Databases. Worked with the clients to establish the onsite and offshore development model for 24/7 support for the Database management and monitoring of vast customer base in web systems.
• Responsible for Requirements gathering, analyzing, design, coding, testing and implementation of new enhancements and quick fixes of HPDInfo. Instrumental in implementing the management’s Technological strategy of Project management in the Technology division of HPD by following strict Agile methodology.
• Analyzed, Designed and developed Routing module to schedule routes of complaints and reinspection of violations for CODE Enforcement Dept by interfacing with ArcGIS for geo efficient routes.
• Was involved in the migration of the older version of application from PB8.0 to PB10.2 and database from Oracle (V8.04) to V(10G). Completed various reports for Notice of Violation Issuance to the citizens of five boro’s of the New York city which was been printed on the preprinted stationeries and used MS office automation through VBA for some reports. Reports were also been pulled from the Filenet server which had violation and complaint related information with respect to the buildings. Worked on Mortgage Refinance and sales module, DOH export of violation data.
• Primary production support contact for the ETL process & daily production process consisting of report generation and batch jobs written in Oracle PL/SQL for HPDInfo by working with business users and IT infrastructure team.
• Responsible for Implementing design, coding and testing of new enhancements of PROCEDE using PB, Oracle & MS SQL Server for Harford Insurance Group (HIG) and CNA Financial Corp. clients by working with the project management and QA group.

Tools: and Environment: PowerBuilder (V8.0-V10.2) with Confidential 's, Oracle (V8.04 - V10GR2), PL/SQL, MS SQL Server 2000, T-SQL, REX, IIS, Visual Expert (5.6), PerlErwin (V3.5), PowerDesigner (V9.5), Star Team (V5.3), ArcGIS (V9.2), RapidSQL (V7.3), PowerGen (V5.0), IBM’s Filenet, MS Access/Word/Excel, VBA.