Demonstrated Skills

Combined 18 years developing custom software and application maintenance support in small and large scale projects. Expert level in PowerBuilder, Web based application, MS.Net, ASP.Net, ADO.Net programming skills. Demonstrated ability to combine excellent written and oral communications, including presentations, to communicate well with the project sponsor, stakeholders and project team. Ability to mentor and train team members to create a strong team. Excellent OOP/OOAD skills are coupled with a strong knowledge of relational databases, including expert level SQL Server, TSQL, Oracle, PL/SQL, Sybase ASE skills. Working Experience in Airlines, Oil and Gas Federal and State Gov., Finance, Health, Mortgage, Entertainment.

Summary of Experience

• 9 years recent experience in PowerBuilder 3 11.0,
• 8 years Oracle PL/SQL experience with Oracle7/ 8/8i/9i/10g/11g
• 7 years recent Sybase experience with Sybase ASE 11.x/12.x and Microsoft SQL Server 7.0, 2000
• 4 years recent experience in Supply Chain / ERP applications.
• 2 year recent ASP.net, ADO.net, .NET Framework, C .NET and ActiveX controls and NUnit
• 2 years DB2 v6.5 and v7.0
• 2 years Crystal Report versions 7-9
• 1 year VBA script for Template Management Interface TMI, written in Visual Basic 5.0 .
• 3 Years' experience in Data conversion
• 1 Year C and C .
• 1 Year MS CRM 4.0

Technical Skills

• PM Tools: Visio, PowerPoint, Microsoft Project, Jira, SharePoint
• Platforms: Windows 7/XP/NT, Solaris 2.7/2.8, UNIX HP UX, Sun Solaris
• Languages: PowerBuilder 11/10.x/9/8, PFC, VB, C, C
• Databases: MS SQL Server, ORACLE 10G/9i/8i/7.x, SYBASE 12.x/11.x
• FoxPro2.6, DB2, MS Access, MS Excel
• Web Tools: ASP.net, ADO.net, .NET Framework with C .NET, EAStudio3.0, EA Server,Powerbuilder, Net, PowerSite, HTML,Java, JavaScript, VBA
• Web Servers: EA Server3.0, Jaguar CTS, and PowerDynamo, IIS, Weblogic 6
• Testing: WinRunner 7.0, Test Director 7.0, NUnit
• Version Ctrl: TFS, Clear Case, Visual SourceSafe, PVCS

Professional Experience

Confidential

As a PowerBuilder tech lead, I have worked on multiple applications RightAngle, OTIS, OSDS for Southwest Airlines.

Role Responsibilities:

• Technical lead in Design, Coding, Software-Software Integration and unit testing
• Strong Datawindow knowledge and extensive hands on implementation
• Customized PFC framework-using object oriented programming techniques OOP .
• Expert in stored procedures. Functions and trigger in TSQL and PL/SQL.
• Expert in database performance tuning
• Expert in MS SQL Server Oracle databases
• Agile Scrum methodology used for development.
• Migrate to new version, Compiling Deployment of builds
• Support and troubleshooting production issue for all Pwerbuilder application
• Upgraded database from SQL server 2005 to SQL Server 2008 R2
• Functional, Data analysis and ad hoc reporting
• Client interface for requirements, prioritization, and rationalization.
• Establishes and tracks performance criteria for development and production support services.
• Providing status reports of ongoing, planned and completed activities to customer

Tools and Technology used:

PowerBuilder 11/10.2/8, PFC Customer libraries, SQL Server 2008, Oracle 10g/11g and TSQL, PL/SQL, Unix, Clear Case, Windows NT, XML, Tibco BE/BW, JMS, Java JEE. Remedy, Service Now

Technical lead Confidential

TRW Corporative has several PowerBuilder, .Net applications in engineering, quality, Communication, Training, Sales, Risk Management, Financial Reporting, internal Audit, Purchasing and training and Legal of TRW Automotive. Each application is used for different purpose of day to day of work in the automotive plant and here are few critical applications and its functionality

Role Responsibilities:

• Created GUI screen development using PowerBuilder 9.02/10.02
• Demonstrate strong design, reporting and scripting development skills
• Reverse Engineer the code to capture existing functionality for critical applications.
• Provide analysis, custom code development, and troubleshooting in the design, configuration, testing, and production support solution for the client's business needs
• Client interface for requirements, prioritization, and rationalization.
• Support and handle the P1 and P2 tickets Level 1 support
• Collection and Collation of new business requirements and passing on concrete details to offshore
• Developed and maintained several applications built in PowerBuilder, .Net and ColdFusion.
• SME Subject Matter Expert and Onsite coordinator for Offshore Team for technical and functional clarifications

Environment: PowerBuilder 9.02/10.2, C .NET,.NET 1.1/2.0/3.5/4.0, HTML 2.0, CFMX7.0, MySQL5.1, Oracle 9i/10g, SharePoint MOSS , Commonspot5, Webfocus, Java, CSA Remedy

Technical Lead Confidential

• As a Technical Manager, I was responsible for delivering CloudCRM which is a service from MSIT that provides internal, low cost, multi-tenant hosting of Dynamics CRM 4.0, it brings in capabilities of Microsoft Dynamics CRM with customization, access and integration with Feedstore and Active Directory, Plug-ins and custom workflows etc. It is an online hosted solution collaborating with MS CRM PG, Silverlight, MSR, MSIT, D PE, and Services.
• Business Objective of CloudCRM is Create storyboard for MS CRM on hosted model vis- -vis competition, evangelize Dynamics CRM, and Provide faster implementation with low cost and better support under a single umbrella.

Role Responsibilities:

• Perform complex product design activities, which may require extensive research and analysis
• Perform complex bug verification, release testing, and beta support for assigned products
• Provide assistance and routine consultation to users in the development of systems and software
• Collaborate with team members to review functional requirements and translate them into a system design
• Assist Project Managers in developing implementation plans, including the scheduling of project milestones
• Be responsible for the functional integrity and proper operation of all assigned systems
• Keep technical skills and knowledge of clients' technologies and service offerings current
• Take appropriate measurements to utilization of resource based on core skill set
• Stand-up meetings whenever needed to improve the team effectiveness
• Provided Innovative solutions
• Team initiatives: Value Ideas, Certification/Enhancement for certification, Training for team and Knowledge Sharing sessions

Environment: MS CRM 4.0/3.0, MS.NET, Java, Wind 2000 Server/Wind XP, MS SQL Server 2005, VM, NLB, SharePoint

PowerBuilder Technical Lead Confidential

As a Technical lead, I am responsible for delivering the Award System and PRS Project Report System for client, built PowerBuilder and MS.NET.

Role Responsibilities:

• Data conversion to accommodate new business process system enhancement.
• Led technical team of 10 members.
• Maintained work papers, reports program progress to management and program team.
• Review progression on functional and non-functional design specs by developers. Provide leadership in bug/fix prioritization.
• Overseen quality assurance, budget and resources in accordance with agreed plan, scope, and deliverables.
• Successfully executed day-to-day tasks while developing an outstanding deliverable.
• Provided and Maintained high productivity level for Client.
• Release/Delivery engineer for Awards System.
• Kept Senior Manger informed of key milestones, relationships, and activities.
• Identified and pursued business opportunities within existing client and with new clients.
• Wrote 25 Sybase stored procedures functions for Data conversion
• Key member of Technical and System design for Data Conversion
• Designed and Developed Sybase batch process for Award System.
• Created data and setup the environment for integrated system for UAT User Acceptance Test .
• Worked on post-production issue.
• Participated in recruiting Process.

Environment: ASP.net, ADO.net, .NET Framework with C .NET, HTML, JDBC, JavaScript , Web logic 6.1 , Web Services, Unix, Rational Rose, Rational Requisite Pro, Rational Clear Case, Windows NT, XML, PowerBuilder 11/10.2, Sybase ASE 12.0 and TSQL

Sr. PowerBuilder Consultant Confidential

CustomViewsm is for customer service so it has its fingers in most systems. Blue Shield of California BSC needs to regain and retain USPS United States Postal Services First Class postage discount for identified DST output, by developing a process that ensures BSC meets USPS requirements. Initial and ongoing processes and procedures will be developed for updating addresses for output generated from the NCOA National Change of Address vendor, Time Customer Service.

As a contractor, I have worked on USPS discount model, technical design, coding, and upgrading both systems from PowerBuilder 6.5/7 to ASP.net, ADO.net, .NET Framework with C .NET

Role Responsibilities:

• Technical lead in design and development for USPS discount module.
• Provide technical design solutions to the team
• Created and Developed application using MS.NET and Oracle 9i
• Involved in performance tuning and User Acceptance UAT
• Migrated PowerBuilder 10.2 to MS.NET
• Wrote stored procedures functions and trigger in PL/SQL
• Developed the Interface between Client/Server and Mainframes by using RUMBA v7.4

Environment: Unix, Windows NT, ASP.net, ADO.net, .NET Framework with C .NET, PowerBuilder 9/8/6.5, PFC, DB2 v6.5, Oracle8i, PL/SQL, Stored Procedures, NUint, Visual SourceSafe 6.0, Crystal Reports 8.5, VBA and Window XP, JDBC, JavaScript , Web logic 6.1

Sr. PowerBuilder Consultant Confidential

As Sr. Consultant, I am a key member in the development of custom system software CRIMES 5.0 Case Records Information Management and Exchange System for numerous clients. Developed Template Management Interface TMI, written in Visual Basic 5.0 . Created macros in WordBasic and Word 97 Visual Basic for the conversion of various word-processing formats into Microsoft Word format. Strong Crystal Reports, Oracle PL/SQL and DB2 skills and is a report developer for numerous clients. We maintained PowerBuilder 9.0/10 and .Net , ASP.Net, ADO.Net and Store Procedures Source Code in Visual SourceSafe.

Role Responsibilities:

• Project and Programming lead for small team designing CRIMES application and supporting.
• Met daily/weekly with Project manager/Project team to review tasks, issue, challenges, follow -up other collateral tasks, project goals, offer trend analysis and discuss issue management and risk mitigation strategies.
• Contacted clients to insure the environment access is smooth.
• Solely responsible for weekly project progress and performance reporting
• Created GUI screen development using PowerBuilder 9.02/10
• Worked for numerous clients for DB2 and Oracle
• Customized PFC framework-using object oriented programming techniques OOP .
• Wrote stored procedures functions and trigger in PL/SQL and DB2.
• Worked on Crystal Report for numerous clients
• TMI Template Management Interface using MS Word, Excel and VBA script
• Data conversion using Excel, SQL Loader and VBA

Environment: .Net Framework, C .Net, Java, ActiveX controls, J2EE, Java, JDBC, JavaScript , Web logic 6.1 Web Services, Unix, Windows NT, XML, Oracle8i, PowerBuilder 9/8/6.5, PFC, DB2 v6.5, Oracle8i, PL/SQL, Stored Procedures, NUint, Visual SourceSafe 6.0 , Crystal Reports 8.5, VBA and Window XP

Sr. PowerBuilder Consultant Confidential

• Developed and Maintained the Audit 32 System. Audit 32 supports investor due diligence audits, tracks the auditing and shipping of final title policies and deeds, and manages the approval of appraisers for placement on, or removal from, the approved appraiser panel. Audit 32 receives loan and appraisal information from the loan origination and loan servicing systems nightly and supports uploading of investor information on an as-needed basis. Audit 32 users input report selection criteria to generate management and operations reports as needed.
• Project was developed in PowerBuilder 6.5 and migrated to PowerBuilder 8.01.

Role Responsibilities:

• Audit 32 System supporting.
• High Level Design, Detail Design, Code development, testing and Implementation.
• Created GUI screen development using PowerBuilder.
• Migrated to newer version of PowerBuilder.
• Setup and Maintained the Source control PVCS for development environment.
• Wrote stored procedures functions in TSQL.

Environment: PowerBuilder 8/6.5, PFC, MS SQL Server 7.0, Stored Procedures,

PVCS, Crystal Reports 8.5 and Window XP.

Powerbuilder consultant Confidential

• The Pinnacle Gas Management System helps the Sempra Energy Gas Acquisition group, which is a Fortune 500 company and one of five top Gas Company in USA. It is public utility company for domestic gas and electricity, which has both core and non-core customer. The System developed in PowerBuilder 7.03, Oracle8i and Sybase ASE12.0 and used system framework for Pinnacle development.Info Pump 3.1.1 was used to download the data from mainframe to Pinnacle database. User accessed system through CITRIX 4.0 /Metaframe 1.80 server for faster access Remote access
• As Sr. Consultant/Team Lead, I have worked on design, development and testing of customer billing and usage modules.

Role Responsibilities:

• Complete SDLC development experience including requirement gathering, Impact Analysis, High Level Design, Detail Design, Code development, testing and Implementation.
• Delivery Management planning processing.
• Involved in Database Design, Performance tuning and writing optimized stored procedures
• Created GUI screen development using Powerbuilder 7.03
• Building a pinnacle framework-using object oriented programming techniques OOP .
• Wrote stored procedures functions and trigger in PL/SQL.
• Performed data conversion and extraction and loaded in Oracle Database using SQL Loader.
• Performed testing at system level creating test cases, test plans and executing the test using automated tools like WinRunner.
• CITRIX 4.0 /Metaframe 1.80 Administrator.

Environment: PowerBuilder 7.0, PFC, Oracle8I, PL/SQL, Sybase ASE 12.0, Stored Procedures, WinRunner, CITRIX 4.0 /Metaframe 1.80, InfoPump 3.1.1, PVCS, Windows NT

Sr. Programmer/Analyst Confidential

Worked on the Repertoire Management System RMS has been developed using PowerBuilder 7.03 and Oracle 8.0. This deals with major music releases and royalties payable to different artists. This project also has a unique security module. Database replication has also been implemented in RMS project. Database is frequently replicated between North America and Europe so that the users on both sides have at least view access to data although they may not be able to modify it.

Role Responsibilities:

• Created front end GUI and made changes to the screens in PowerBuilder 7.0. Had prototype walk-through for screen development.
• Responsible for designing the high level process flow and data flow.
• Participated in the design of Oracle databases and objects for the project. Made changes to tables and Indexes to include changes in the requirement.
• Created Tables and Stored procedures in PL/SQL for backend database access.
• Performance tuned the entire application including stored procedures.
• Performed System level testing using automated tools like Winrunner. Created test plans and test cases in Testdirector. Executed system tests and did validation.
• Moved application to production environment using Clearcase and performed production support after implementation.

Environment: PowerBuilder 7.03, PFC, Oracle 8i, PL/SQL, Stored Procedure, Winrunner, SQL Loader, SQL Navigator.

Sr. Programmer/Analyst Confidential

Padlock is the tool developed and marketed by PowerCerv. Context-sensitive Padlock allows a security administrator to identify the areas of an application that should have secured access, while actually within that application. This product was originally developed in two-tier architecture with PowerBuilder 6.0 and now migrated to three-tier architecture with Jaguar CTS PowerBuilder 7.0 on Windows NT4.0 and the database used was Sybase ASE 11.0.

Role Responsibilities:

• Analysis of the older version created application plan to implement in Jaguar CTS.
• Involved in coding testing and deployment of Jaguar methods and components.
• Deployed non-visual objects into Jaguar CTS.
• Created GUI in PowerBuilder PFC 6.0
• Created stored procedures in SYBASE database
• Web enabled the entire application using Sybase EA Server.
• Created and modified HTML code for web pages.
• Tuned the application and stored procedures.

Environment: PowerBuilder 6.0/7.0, Win NT 4.0, and SYBASE 11.0, Jaguar CTS.

Sr. Programmer/Analyst Confidential

ServiceMaster is service company for all residential and business needs. It also offers management services that provide facilities with support services and innovative solutions to streamline work processes. The ServiceLINK Application was developed such that it receives calls from residential and businessperson that who needs the various services provided by ServiceMaster and passes them to the customer service department. It also provides the information to the users on how to handle these customers' calls. Recently, we released the latest version of ServiceLINK in PowerBuilder 6.5, which is previously in PowerBuilder5.0. The backend used was MS SQL Server.

Role Responsibilities: Involved in coding, enhancement, writing store procedures and migrating to higher version of Application.

Environment: PowerBuilder 5.0/6.5, MS SQL Server, Win 98.

Sr. Programmer/ Analyst Confidential

Involved in system analysis, design, and database design of Schwab Institutional Trading's SI Trading Training Scheduler and Budget Tracker SITTS-BT application. The system keeps track of information about Schwab Institutional Trading's training, as well as keeps track of the costs of training for budgetary considerations. The application data model was developed using Erwin and MS Help was used to develop the help files. Utilized database triggers and stored procedures in MS SQL Server to validate business rules. Responsible for the system testing and production testing. The final version of this project was linked with Charles Schwab on-line. PowerBuilder 6.0 was the front end used.

Role Responsibilities: Analyses and Designing Develop the Specifications and Standard, Coding, writing stored procedure and triggers, and testing the application

Environment: PowerBuilder 6.05, MS SQL Server, Win 98, and Erwin, MS Help.

Confidential

Programmer/Analyst

Confidential

• Part of team that automated the Diamond Shamrock crude oil system DS-COIS .
• Role included system analysis, design, writing stored procedure, triggers, and generating reports and graphics. The project module included features such as functionality of driver payroll calculation and general commission rules. This application utilized MS SQL Server,DB2 and Sybase, and PowerBuilder5.0 as the front end.

Role Responsibilities: System analysis, design, wrote store procedures, triggers, generating reports and graphics.

Environment: PowerBuilder 5.0, Sybase, MS SQL Server, DB2, and Win 98.