SUMMARY

• Twenty Four (24) years of strong experience in Data Warehousing, analysis, design, development and implementation of client/server based New and Legacy applications using PowerBuilder 12,11.5, 11.0/9.0/8.0/7.0/6.5.6.0 , PFC, Visual Basic 6.0, .Net, JAVA, PL/SQL, C, ASP, shell script, XML,TOAD, Oracle 7.3,8i,9i and Sybase SQL Server 10, SQL Server, Sybase SQL Anywhere under Windows XP/2000/NT/98 and Unix environment.

TECHNICAL SKILLS

Data Warehousing: SSIS/SSRS/SSAS, Informatica, ETL, Informatica Admin, SQL Server Jobs

GUI: PowerBuilder 12.5,11.5,11.2, 9.0/8.0/7.0/6.5/6.0/4.0/3.0 , PFC, Visual Basic 6.0/5.0,.Net,Netbeans, Eclipse

Languages: PL/SQL, JAVA, C, Shell Programming, .Net, COBOL,HTML, ASP

Tools: SSMS, BIDS, TOAD, Visio, SQL*Loader, SQL*Plus, PL/SQL Developer 8.0.2, Aqua Studio, JCAPS, Appeon

Data Modeling: PowerDesigner 8.0, Erwin, Visio

RDBMS: Oracle 7.3,8i,9i,10g,11i, Exadata, Sybase ASE 15, SQL Server, Sybase SQL Anywhere

Operating Systems: Windows XP/2000/NT/98, Unix

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SSIS/SSRS/SSAS Developer

Responsibilities:

• Worked in the Business Intelligence group on a variety of tools from SQL Server SSMS/BIDS (SSIS/SSAS/SSRS/SQL Server Jobs), Informatica Powercenter Respository Manager, Powercenter Designer, Powercenter Monitor, Infomatica Administration, Ad Hoc reporting
• Created and developed ETL packages using SSIS to bring data from Source systems into the staging area. Wrote stored procedures to get data from staging into the Datawarehouse.
• Created SSAS cubes for users to report off of for their analysis
• Created SSRS reports for end user reporting needs
• Supported Informatica ETL process; Modified workflows/sessions in line with business requirements
• Underwent training in Informatica Administration from Informatica. Was Informatica Admin for the Dev and QA environments (set up users etc, made sure Informatica was up and running, monitored ETLs )
• Wrote and modified UNIX shell scripts that tied all Infomatica workflows together.
• Was primary support for Informatica ETL jobs.
• Interacted with end users/business analysts to learn more about user issues and then suggested, coded and implemented production bug fixes, and also developed reports using SSRS.
• Wrote stored procedures, scripts fot creating tables, indexes, jobs using SSMS.
• Performed database analysis and design for Data Warehouse platform.
• Performed unit and system testing.
• Performed code reviews.
• Used Sharepoint to publish data to users using the Sharepoint portal.
• Used Vbscript to automate generation of pricing spreadsheets and among other things to password protect, hide/display columns, split spreadsheets, format columns.

Environment: PowerBuilder 8.0/7.0/6.5/5.0 PFC, PL/SQL, Powerdesigner 8.0, Pervasive 7.0,Visual Basic 6.0, VB .Net, MV90, Oracle 7.3/8i, Windows NT

Confidential, Dallas, TX

SQL Developer

Responsibilities:

• Working as an Software Consultant in the design and development of Healthcare applications.
• Used Powerbuilder 12.5,11.5 as development tool with Sybase ASE 15,Oracle 11g,10g as the database back end
• Migrated all Powerbuilder apps from Legacy Source Control to SVN
• Used PBORCA and created batch files to automate application builds
• Developed stored procedures, triggers and scripts in Sybase ASE 15 using Rapid SQL.
• Developed and enhanced modules in Occusource, BCS and Autocomm Legacy applications
• Enhanced C code and UNIX shell scripts
• Scripted Detail Technical Design Documents as part of the development cycle.
• Worked with external vendors to refine Fax sending process via inhouse applications
• Exposed to JCAPS Webservices using Netbeans
• Worked with different teams upstream and downstream of team apps to understand ETL and SSIS processes to identify issues
• Worked with BA to understand business processes and proposed and implemented cost effective, scalable and efficient solutions

Environment: PowerBuilder 8.0/7.0/6.5/5.0 PFC, PL/SQL, Powerdesigner 8.0, Pervasive 7.0,Visual Basic 6.0, VB .Net, MV90, Oracle 7.3/8i, Windows NT

Confidential, Dallas, TX

SQL Developer

Responsibilities:

• Designed and scripted the UCF application to handle the Unclaimed Fund Escheatment process in JPMC.
• Working as an Application Consultant in the design and development of Mortgage Banking applications.
• Used Powerbuilder 11.5 as development tool with Oracle 11g,10g as the database.
• Used SVN as source control for Powerbuilder libraries.
• Developed stored procedures, triggers and scripts in Oracle using PL/SQL,SQL PLUS.
• Wrote SQL scripts to migrate database from one server to the other including creation of tables, constraints, triggers, data etc.
• Wrote embedded SQL to update database tables as part of enhancement of current applications.
• Developed UNIX shell scripts to perform batch operations.
• Scripted Detail Technical Design Documents as part of the development cycle.
• Enhanced POTS system to batch process loan closures by calling stored procedures from within Powerbuilder.
• Created DB links using SQL to select data from other databases.
• Wrote batch programs to update loan numbers in select application as part of the Loan renumbering process.
• As part of this, wrote SQL scripts to disable constraints and triggers, update the loan numbers and then reapply the triggers and constraints.
• Performed extensive Unit testing of applications in the Dev environment. Also performed/assisted in UAT in the UAT environment.
• Supporting applications deployed to production. Interacting with end - users/business analysts to understand issues, provide fixes/solutions/workarounds.

Environment: PowerBuilder 8.0/7.0/6.5/5.0 PFC, PL/SQL, Powerdesigner 8.0, Pervasive 7.0,Visual Basic 6.0, VB .Net, MV90, Oracle 7.3/8i, Windows NT

Confidential, Houston, TX

Application Developer

Responsibilities:

• Worked as an Application Consultant.
• Worked on enhancing existing applications which entailed researching and grasping key business and technical concepts in a short period of time.
• Used Powerbuilder 12,11.5 as development tool with Oracle 11g as the database.
• Developed stored procedures in Oracle using TOAD.
• Wrote SQL scripts to query database, insert/update/delete records.
• Wrote Design Documents and Detailed Unit test cases.

Environment: PowerBuilder 8.0/7.0/6.5/5.0 PFC, PL/SQL, Powerdesigner 8.0, Pervasive 7.0,Visual Basic 6.0, VB .Net, MV90, Oracle 7.3/8i, Windows NT

Confidential, Dallas, TX

Software Developer

Responsibilities:

• Designed and developed new interfaces for Legacy UFS(Unified Freight System) using Powerbuilder 11.0, PFC
• Worked on the full Software life cycle including analysis, design, development, testing, deployment and post deployment production support.
• Created JAVA classes for the JAVA middle tier using the Eclipse platform.
• Involved in coding PL/SQL programs, creating screens for the new modules using PowerBuilder
• Wrote complex selects for reports like Invoice, Shipment, Master Waybill etc.
• Created Detailed Design Document, Functional Specs Document, Unit Test Cases Document for all screens developed
• Generated custom reports, used datawindows in PB extensively.
• Used Rational ClearCase as Version Control Tool
• Used Rational ClearQuest to submit bug reports and track change request records.
• Also used ClearQuest to track the release in which a feature, enhancement, or bug fix was made.
• Interacted with end users/business analysts to learn more about user issues and then suggested, coded and implemented production bug fixes.
• Wrote packages, stored procedures and triggers using PL/SQL Developer.
• Tuned and Optimized queries using PL/SQL Developer.
• Performed database analysis and design for the above application.
• Performed unit and system testing.
• Performed code reviews and interacted with offshore teram members.
• Used Sharepoint to maintain/update Release Notes and Build Related information.
• Was trained in WebMethods for Data Warehousing needs.
• Wrote stored procedures to denormalize tables and get them into the data warehouse.

Environment: Powerbuilder 8.0, PFC, Toad, /PL SQL Developer 5.1,Oracle 9/8i, Forte UDS 5.0, Rational ClearCase/ClearQuest, Windows 2000/NT

Confidential, Dallas, TX

Application Architect

Responsibilities:

• Worked as an Application Architect
• Designed and developed web services using the .Net and EasySoap Engines in Powerbuilder 11.2.
• Attended Sybase training for Powerbuilder 11.5,12
• Designed and developed Components for EAServer 5.5
• Worked with different Source Control Systems like VSS, TFS
• Designed and developed COM objects using VB.Net and C#
• Underwent training in C#.net
• Used AQUA Studio and DB Embarcadero to write stored procedures in Sybase T SQL.
• Developed Sybase Stored Procedures which were called from web services to perform updates on the database.
• Used SQL to query the database and wrote complex SQL statements for selects, inserts, updates and deletes.

Confidential, Dallas, TX

Application developer

Responsibilities:

• Designed and developed new interfaces for Legacy UFS(Unified Freight System) using Powerbuilder 8.0, PFC.
• Involved in coding PL/SQL programs, creating screens for the new modules using PowerBuilder. Made modifications to existing screen to suit new requirements.
• Created Detailed Design Document, Functional Specs Document, Unit Test Cases Document for all screens developed.
• Generated custom reports, used datawindows in PB extensively.
• Coded methods to Forte middle-tier
• Designed and developed new reports for UFS(Unified Freight System) using Powerbuilder 8.0, PFC
• Used Rational ClearCase as Version Control Tool
• Used Rational ClearQuest to submit bug reports and track change request records.
• Also used ClearQuest to track the release in which a feature, enhancement, or bug fix was made.
• Interacted with end users/business analysts to learn more about user issues and then suggested, coded and implemented production bug fixes.
• Wrote packages, stored procedures and triggers using PL/SQL Developer
• Tuned and Optimized queries using PL/SQL Developer
• Performed database analysis and design for the above application
• Performed unit and system testing
• Performed UFS Builds
• Performed code reviews and interacted with offshore teram members
• Maintained Java Struts application using XML, XSL and XSLT.
• Created JAVA classes for the JAVA middle tier using Eclipse.
• Used Sharepoint to maintain/update Release Notes and Build Related information
• Migrated Powerbuilder Applications to Ver 11.0.

Environment: Powerbuilder 8.0, PFC, Toad, /PL SQL Developer 5.1,Oracle 9/8i, Forte UDS 5.0, Rational ClearCase/ClearQuest, Windows 2000/NT

Confidential, TX

SQL DBA

Responsibilities:

• Oversaw all activities for interaction of data flow between Utility companies and competitive retail electricity suppliers participating in deregulated electricity market, specifically to review all transaction sets pertaining to customer enrollment, changes, drops, reinstatement, history and usage.
• Worked closely with both utilities and competitive retailers to keep testing scenarios on schedule and resolve any issues during its lifecycle.
• Utilized TOAD, SQL and Siebel Energy for Oracle 7.3 database inquiries and validation.
• Provided authorized certification to competitive retailers, allowing them to compete in deregulated Texas electricity market after successful completion of test cycle.

Environment: Siebel Energy, SQL, TOAD, Oracle 7.3, Unix, Windows 2000/NT

Confidential, Tulsa OK

Responsibilities:

• Involved in developing highly specialized billing calculators using PB 5.0,7.5,8,PFC.
• Performed feasibility study, requirement analysis. Acted as liaison with end users and management.
• Developed and designed reports, created web interfaces and batch jobs needed as part of billing process using PB 5.0,7.5,8,PFC.
• Developed an automatic CIS upload using FTP to send billing determinants at the end of each billing cycle to send to mainframe. Integrated this process with MVPBS using PB 8.0.
• Designed and developed Texas Messaging System (AEPSOT) through which they send data to ERCOT (Energy Reliability Council of Texas) using PB 8.0, PFC with an Oracle 8i backend.
• Developed complex reports using N-up, Composite, Crosstab and External Datawindows in PB 8.0.
• Involved in migration from PB 5.0 to PB 7.5, PB 8.0.
• Involved in migration from Oracle 7.3 to Oracle 8i.
• Involved in system maintenance, monthly release to apply new modifications and production support
• Developed unit test and integration test plans.
• Carried out analysis, design and development of database tables and constraints.
• Wrote functional specification of front-end and back-end programs.
• Provided system support for performance tuning and troubleshooting.
• Created Oracle 7.3, 8i triggers, stored procedures, sequences, packages, Indexes, DB links, Views, Synonyms, DBMS jobs, DBMS OUTPUT.
• Used Powerbuilder Data Pipelines to refresh data from the production database to the test database.
• Worked on Microsoft SQL Server queries and stored procedures.
• Made changes to a VB .Net application that interfaced with AEPSOT.

Environment: PowerBuilder 8.0/7.0/6.5/5.0 PFC, PL/SQL, Powerdesigner 8.0, Pervasive 7.0,Visual Basic 6.0, VB .Net, MV90, Oracle 7.3/8i, Windows NT

Confidential, Fortworth, TX

Responsibilities:

• Developed client side 4GL software using Object Oriented techniques.
• Used PFC functionality extensively like Window Services, Datawindow Services, Application Services and Main Services.
• Designed and coded front end including menuing and tree traversal using PB 6.5, PFC.
• Wrote stored procedures in PL/SQL.
• Involved in migration from PB 5.0 to PB 6.5.
• Involved in system maintenance, monthly release to apply new modifications and production support
• Developed unit test and integration test plans.
• Carried out analysis, design and development of database tables and constraints.
• Wrote functional specification of front-end and back-end programs.
• Provided system support for performance tuning and troubleshooting.

Environment: PB 6.5/6.0/5.0 PFC, PL/SQL, Oracle 7.3, Windows NT, Unix

Confidential

Responsibilities:

• Wrote and replaced Funcky calls with equivalent PFC calls. In addition, replaced Windows API calls with PFC/PowerBuilder 5.0 calls.
• Added new functions to PFE layer. Also modified Embedded-SQL statements to work with SQL Server.
• Used testing tool SQA Suite extensively to record test plans for about a dozen applications.
• Used CASE tool ObjectSmith 5.0 as Script Assistant, Inheritence Adjuster.

Environment: PowerBuilder 5.0/4.0 PFC, Sybase SQL Server 5.0, Watcom 4, WFW, Unix