We provide IT Staff Augmentation Services!

Powerbuilder Consultant Resume

Des Moines, IA

SUMMARY:

  • Over 17 years of experience in developing and supporting Client Server and N - Tier enterprise applications using PowerBuilder, PFC, Sybase, EAServer/Jaguar, SQL Server, Oracle, DB2, Unix, C#, WCF, Maestro, Python, Perl, SQR, DB2, SSMS, SSIS, SSRS.
  • Excellent interpersonal, presentation skills, with demonstrable leadership, verbal and written communication skills to maintain effective work relationships with all levels of personnel in a team environment or independently.
  • Impressive problem-solving and critical thinking skills.
  • Extensive knowledge of Software development using Agile (SCRUM) methodology.
  • Extensive experience in Information Systems Analysis, Design, Coding, Testing, Debugging, Implementation and ETL using SSMS and SSIS.
  • Have managed and led teams of size ranging from 2 to 6 members.
  • Highly experienced in Migration projects - Oracle on Windows to Exadata, PB 5, 9 to 12 version, Sybase to DB2 and SQL Server 2012.
  • Mentored and extensively worked in support and development projects using Oracle, SSMS, SSIS, PB 5 to 12 and VB 6.0 for different clients with different domains.
  • Administered and worked in Enhancement and Production support projects to document, reduce redundancies, automate tasks and simplify the existing code.
  • Worked extensively in ETL Tools to Extract, Transform and Load data into Reporting databases from which report is done effectively using SSIS and Cognos Impromptu.
  • Developed and maintained SSRS, SQR reports and Crystal reports.
  • Managed projects and worked extensively with DB objects to Design databases, create Triggers, Procedures, Packages, Functions and Tune and support Database system.
  • Knowledge of programming and design methodologies related to RDBMS Applications.
  • Played active role in effectively working with business users, gathering and documenting both business and technical requirements, and mentoring the technical team.

TECHNICAL SKILLS:

GUI: PowerBuilder 12.5.2, PFC, VS 2012, WCF, WPF.

RDBMS: Oracle 11g, MS SQL Server 2014, Sybase 15.2, DB2.

Languages: C#.Net, C, C++.

Operating System: Windows NT, XP, UNIX, AS/400.

Tools: SQR, Toad, DBArtisan, Rapid SQL, TFS, PVCS, VSS, ERWIN, SQR Developer, Share Point, Visio, Maestro, Appworx, Job Scheduler, Power Designer, Info Maker, Crystal Reports, PowerGen, TortoiseGIT, Stash, SSIS, SSRS, TFS, Team Track, Perl, Python, Serena, JIRA, Change Order, Docu corp, MQSeries, Rational Robot, Rational Test Manager, Clear Quest, WRITS, MSTest, NUnit and Reflector.

PROFESSIONAL EXPERIENCE:

Confidential, Des Moines, IA

PowerBuilder Consultant

Responsibilities:

  • Working on Agile development to build the HDS View application using PowerBuilder 12.5.2 and Oracle 11g applications.
  • Have designed and developed many windows, user objects and data windows, Product setup, made API calls for credit card processing, designed and developed packages and jobs to load and process Prior carrier claims, Nightly Age Off process, label printing, etc.
  • Analyze performance and tune applications to make them more robust and fast.
  • Design efficient and intelligent database object like Packages, triggers, views and functions.
  • Designed, architected, and implemented the system enhancements which utilized PowerBuilder for dynamic front end user interface.
  • Designing standard Framework as per PowerBuilder Foundation class.
  • Developed Front end windows using PowerBuilder v12.5 and PFC services with SQL Server and Oracle as backend.
  • Developed PB code that will interact Java APIs for PayTrace Credit card processing.
  • Working on Agile/SCRUM iterative and incremental software development.

Environment: PowerBuilder 12.5.2, PFC, Agile - Scrum, Oracle 11g, SQR Developer, PowerGen, TortoiseGIT, Stash Windows XP and 7 desktops.

Confidential, Birmingham, AL

PowerBuilder Consultant

Responsibilities:

  • Worked on enhancement and support for Passport and VISA PowerBuilder applications. Have designed and developed many windows, user objects and data windows to enhance the PB applications.
  • Worked on several SSRS reports and Data Conversion for Passport and Premier applications to DART using VS 2012, SQL Server 2014, SSIS and JIRA.
  • Worked on Agile/SCRUM iterative and incremental software development.
  • Involved in installing and configuring of EAServer and conversion of PowerScript code that is compatible for EAServer.
  • Responsible for guiding other developer on analysis, debugging, code review and maintaining PowerBuilder based application.
  • SNG production support - This project involves the study/enhancement activity associated with the Southern Natural GAS pipeline support, using VS 2010 C#.Net, WCF, Web Services and Oracle 11g.
  • Maintain Defects of the PowerBuilder Application along with resolution steps, change request of the PowerBuilder Application and issues with the application.
  • Worked on hundred plus CMRs to enhance and support the Passport and Premier applications. Major achievements were to implement Line pack enhancements, KMPage, sitemap, performance tuning of batch jobs, rate case projects, enhance reporting.
  • Ensured that client and end-user requirements were met for various projects.
  • Prepared project proposals and participated in status meetings.
  • Analyze performance and tune applications to make them more robust and fast.
  • Wrote efficient and intelligent database object like Packages, Perl scripts, Python scripts, Maestro commands, SQR reports, triggers, views and functions.
  • Efficiently used version manager (TFS, PVCS), change management (Team Track) and Work Request Initiation and Tracking System - WRITS
  • Provided support for UAT, implementation and On-call support.
  • Tested all the Premier applications as part of Oracle Migration from Windows to Exadata. Work closely with DBAs and Network team to resolve all the issues.

Environment: PowerBuilder 9.0 and 12, PFC, Agile - Scrum, VS 2012 C#.Net, C++, WCF, Oracle 11g, Appworx, SSIS, SSRS, SQL Server 2014, Crystal Reports 10, Maestro, SQR, Python, Perl, Windows XP and 7 desktops.

Confidential, Colorado Springs, CO

Senior Programmer Analyst

Responsibilities:

  • PASSPORT, GTSYS, Visual Integration Systems App (VISA) and Volume Accounting project involves the study/enhancement and support of these systems.
  • Successfully completed decompiling of ASP.Net Web applications from their DLL files to re-compile and create working code for web applications that were running in Production.
  • Ensured that client and end-user requirements were met for various projects.
  • Prepared project proposals and participated in status meetings.
  • Used Agile/SCRUM iterative and incremental software development process.
  • Analyze performance and tune applications to make them more robust and fast.
  • Write efficient and intelligent database object like stored procedures, triggers, views and functions and Worked on creating several SSRS reports.
  • Efficiently using version manager (TFS, PVCS), change management (Team Track) and Work Request Initiation and Tracking System - WRITS
  • Provide support for UAT, implementation and On-call support.
  • Migrated ‘EPSS’ and ‘Gas Master’ applications from PowerBuilder 9 to 12 and enhance the code to work more efficiently.
  • Migrated ‘GM Reports’ application from PB 11.1 to 12. Optimize the stored procedures to run the reporting application (GM Reports) efficiently.
  • Migrated ‘EPSS’, ‘EP Arms’, ‘AppLauncher’ and ‘Gas Master’ databases from SQL Server and performed complete regression testing.
  • Migrated ‘EP Arms’ ‘EPM Portal’ and ‘AppLauncher’ applications from VS 2003 ASP.Net to VS 2010 ASP.Net and enhance the code to work with XHTML standards and have code and design separated.
  • Designed and maintained reports using Crystal Reports and MS SQL Reporting Services.

Environment: VS 2010 C#.Net, Agile - Scrum, Appworx, PowerBuilder 9.0 and 12, PFC, SSIS, SSRS, SQL Server 2012, Crystal Reports 10, Unix, Windows XP and 7.

Confidential, El Segundo, CA

Associate Project Manager

Responsibilities:

  • These projects involved the study/enhancement activity associated with the Worldwide Licensing and Approval (WWLA) system and OMNI Business Process Alignment.
  • Worked as an Associate Project Manager to design and develop OMNI application.
  • Worked extensively on EAServer/Jaguar and web Datawindows in a distributed OMNI application.
  • Have closely interacted with users and business analysts to acknowledge and understand the requirements and came up with technical solutions that best suits the needs.
  • Built and maintained application based on PowerBuilder 10.5.
  • Troubleshooting and maintaining applications in a n-tier environment consisting of DB2 RDBMS, Sybase EAS
  • Prepared HLD, LLD, assigned tasks to the team, generated code, created test plans, performed testing and delivered enhanced code.
  • Migrated OMNI, MDM, PowerSDE, PFAdmin and SLSACC apps from PB 6.5 to 10.5.
  • Studied the MDM (single sign-on) and PowerSDE system and document the Current State to effectively support and enhance the applications.
  • Involved in the development of the application based on Sybase PowerBuilder.
  • Proposed solutions based on the current state analysis to decommission MDM Sybase database and the Non AS/400 application from MDM.
  • Studied and document the online screens, the batch process, prepare ER Diagram, Data Dictionary, Data Flow, Application Architecture, Content Analysis Diagram, etc.

Environment: IBM AS400; Windows XP desktops, PowerBuilder 10.5, MS SQL 2000; IBM - DB2 v5R3 HP, UC4, HP UNIX servers; Windows 2000, Sybase 12.5, EA Server/Jaguar.

Confidential

Team Lead

Responsibilities:

  • Enhanced and Supported FXBoB application coded in PowerBuilder, Oracle, Sybase and UNIX Shell.
  • Analyzed and resolved the problems reported by the Users.
  • Performed 24/7 On-call production support, coordinated with server groups and DBAs.
  • Interacted with the users and business analysts constantly for acknowledging and understanding the problem and to obtain the details on user requirements in the case of enhancements.
  • Successfully studied the application in three months from client side London and moved the application to offshore (India) for enhancements and support.

Environment: Pentium Client/Server, WINDOWS XP, PowerBuilder 8.0, SYBASE 12.5, Oracle 8i

Confidential

Senior Programmer Analyst

Responsibilities:

  • Customized and Enhanced Strategic Suite of Systems Pegasus A&H Insurance application for India and 12 other countries in the Middle East.
  • Provided support for Strategic Suite of Systems Pegasus A&H Insurance application.
  • Provided support for EMMA WAATS travel insurance web application.
  • Worked extensively on EAServer/Jaguar and web Datawindows in a distributed Pegasus application.
  • Worked as a senior PowerBuilder programmer Analyst and have analyzed and resolved the problems reported by the Users for Pegasus and EMMA applications.
  • Worked closely with underwriters to launch new products and enhance the applications to support the new products in tight deadlines.
  • Used Rational testing tools to do the unit, integration and system testing.
  • Worked on ETL jobs that were run as nightly batch to optimize the queries and reduce the time taken to Extract, Transform and Load the data.
  • De-normalized the data to make the reporting process easier.
  • Worked on reporting tools Cognos Impromptu to develop reports.

Environment: Pentium Client/Server, WINDOWS NT 4.0, PowerBuilder, SYBASE 11, Docu corp, Rational Robot, Rational Test manager, Rational Clearquest, EAServer/Jaguar and COGNOS.

Hire Now