SUMMARY:

• 24 years of strong experience in D Confidential Warehousing, analysis, design, development and implementation of client/server based New and Confidential 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:

D Confidential 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

D Confidential Modeling: PowerDesigner 8.0, Erwin, Visio

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

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

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Responsibilities:

• Worked in the Confidential 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 d Confidential from Source systems into the staging area.
• Wrote stored procedures to get d Confidential from staging into the D Confidential warehouse.

Confidential, Dallas, TX

Responsibilities:

• Worked in the Confidential 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 d Confidential from Source systems into the staging area.
• Wrote stored procedures to get d Confidential from staging into the D Confidential warehouse.
• 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 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 d Confidential base analysis and design for D Confidential Warehouse platform.
• Performed unit and system testing.
• Performed code reviews.
• Used Sharepoint to publish d Confidential 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.

Confidential, Dallas, TX

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 d Confidential base back end
• Migrated all Powerbuilder apps from Confidential 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, Confidential and Autocomm Confidential 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

Confidential, Dallas, TX

Responsibilities:

• Designed and scripted the UCF application to handle the Unclaimed Fund Escheatment process in Confidential .
• 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 d Confidential base.
• 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 d Confidential base from one server to the other including creation of tables, constraints, triggers, d Confidential etc.
• Wrote embedded SQL to update d Confidential base 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 d Confidential from other d Confidential bases.
• 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.

Confidential, Houston, TX

Application Consultant

Responsibilities:

• 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 d Confidential base.
• Developed stored procedures in Oracle using TOAD.
• Wrote SQL scripts to query d Confidential base, insert/update/delete records.
• Wrote Design Documents and Detailed Unit test cases.

Confidential, Dallas, TX

Responsibilities:

• 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 d Confidential windows 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 d Confidential base 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 D Confidential Warehousing needs.
• Wrote stored procedures to denormalize tables and get them into the d Confidential 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:

• Designed and developed web services using the .Net and EasySoap Engines in Powerbuilder 11.2.
• Attended Sybase 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 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 d Confidential base.
• Used SQL to query the d Confidential base and wrote complex SQL statements for selects, inserts, updates and deletes.

Confidential, Dallas, TX

Responsibilities:

• Designed and developed new interfaces for Confidential 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 d Confidential windows in PB extensively.
• Coded methods to Forte middle-tier
• Designed and developed new reports for Confidential 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 d Confidential base analysis and design for the above application
• Performed unit and system testing
• Performed Confidential 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

EDI Retail Testing

Responsibilities:

• Oversaw all activities for interaction of d Confidential 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 d Confidential base inquiries and validation.
• Provided authorized 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

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 d Confidential 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 D Confidential windows 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 d Confidential base 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 D Confidential Pipelines to refresh d Confidential from the production d Confidential base to the test d Confidential base.
• 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, TX

Responsibilities:

• Developed client side 4GL software using Object Oriented techniques.
• Used PFC functionality extensively like Window Services, D Confidential window 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 d Confidential base 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 Confidential 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

Confidential

Responsibilities:

• Customized Targeting module in PB 4.0, which used DLLs coded in C++.
• Designed and developed the Time and Expenses Module using PB 4.0.
• Created graphics for the Time and Expenses Module using Microsoft Paint.
• Wrote IDDs/Test Plans for customer maintenance,time and expense(T&E) and targeting modules.
• Involved in testing of the entire Dendrite ESMS Suite.

Environment: PowerBuilder 4.0, Watcom 4, WFW, Windows NT/95, AIX

Confidential

Responsibilities:

• Designed and developed system using COBOL D Confidential Files to extract d Confidential using SQL*Loader.
• Used SQL*Reportwriter and PRO*C for creating reports.
• Used awk extensively to create quick reports and format d Confidential from flat files.
• Used tar to perform system backups on a regular basis.
• Wrote programs in C to generate reports from COBOL d Confidential files which were too complex for awk.
• Also wrote utilities in C to parse d Confidential files for migration from old COBOL tape files to MF COBOL on a UNIX platform.

Environment: SQL*Forms 3.0, C,SQL*Reportwriter, SQL*Loader, SQL*Menu, PL/SQL, PRO*C, Oracle CASE Tools, Shell Scripts, Oracle 7.0, Unix

Confidential

Responsibilities:

• Wrote programs to read, write, index, sort, format d Confidential and generate reports.
• Involved in day-to-day maintenance activities of Confidential Group, which included writing shell scripts and C programs.
• Used Unix backup commands like tar and dd extensively.
• Wrote programs in C to generate reports from COBOL d Confidential files which were too complex for awk.
• Also wrote utilities in C to parse d Confidential files for migration from old COBOL tape files to MF COBOL on a UNIX platform.

Environment: MF COBOL, C, UNIX Shell Scripts, Unix

Confidential

Responsibilities:

• Responsible for effecting any changes in Confidential Directives of government to Confidential System.
• Wrote programs to read, write, index, sort, format d Confidential and generate reports.
• Involved in day-to-day maintenance activities, which included writing shell scripts and C programs.

Environment: MF COBOL, UNIX Shell Scripts, FoxPro, Unix