SUMMARY

• Professional Goal: To use my technical expertise, business acumen and organizational skills to solve BI and data warehousing challengeson time and within budget.
• Enterprise architect and developer with over 32 years of IT experience in the US. Have technical expertise that encompasses a range of hardware platforms, programming languages, databases, and application development and BI tools. Further, have experience working across many industries, including Healthcare, Entertainment, Consumer Goods, Transportation, Government, Education and Financial Services.
• Dynamic learner who has continuously mastered new technologies, from mainframe to object oriented systems and BI tools
• Self-starter with the established history of designing robust systems solutions that are easy to maintain and scalable for future enhancements
• Demonstrate great interpersonal skillsand the ability to act as a conduit between the business and IT
• Excellent at building detailed and accurate project work plans
• Possess the skills to considerablyimprove the performance of existing applications

Technical and Infrastructure Expertise

Databases

• Oracle 7, 8, 9i, 10gR2 and 11Gr2, Essbase Rel 11, Sybase, SQL Server, Access, DB2, UDB, IDMS, DMS-1100, VSAM, FOCUS, ISAM

Application Servers

• Essbase Application Server Release 11, Oracle Data Integrator, Microstretegy App Server, Microstretegy Web Server, Oracle BI Application Server, Salesforce.com, Websphere Application Server, Smalltalk Gemstone Server

Programming Languages

• SQL, PL/SQL, Perl, Java, IBM Smalltalk, SmallTalk-80, PowerScript, PeopleCode, SQR, XML, C, Visual C , C , MF COBOL, COBOL, Visual Basic, VBScript, JavaScript, FORTRAN, FOCUS, ASSEMBLER

Application Tools

• Development Software: Oracle Data Integrator ODI , Oracle Warehouse Builder OWB 10gR2 and 11gR1, Oracle Workflow OWF , Oracle Discoverer Admin and Development Tool, MicroStrategy, Analytical Workspace Management AWM for OLAP, OBIEE, Oracle BI Publisher, Visual Studio 2003, Websphere Software Application Development Java IDE , VisualAge Smalltalk, VisualAge Java, VisualWorks, Gemstone, Powerbuilder, Visual Studio C , TOAD, Objectory, Erwin, SQR , MQ Series, PeopleSoft
• Hosted Service: Salesforce.com
• Operating Systems: MVS, OS-1100, HP-UX, AIX, SUN Solaris, OS/2, Windows
• Scheduler: Windows, Maestro, CA-7
• Change Control: Source Safe, PVCS, MKS, Endevor
• Connectors: Connect Direct, Lotus Enterprise Integrator, Xtalk, CrossPlex, Hyperchannel, Xcom, ODBC, JDBC
• Testing: SQA

PROFESSIONAL EXPERIENCE

Confidential

Data Warehouse Engineer BI Specialist

• In-house technical lead for Enterprise level BI projects that provide analytical solutions for VNSNY's Finance, Operations, and Clinical departments.
• Play key role in the implementation of Reports Metrics that include the design and development of reports and dashboards, ETL processes and metadata management using Oracle's Discoverer BI Tool
• Designed a Data Warehouse in Oracle 10g in which the staging area is populated from heterogeneous sources like DB2, SQL Server and external Flat file feeds. Then used the staging area data to build Dimensions and Facts for reporting
• Designed and automated in-bound and out-bound processes from Oracle Data Warehouse
• Participated in the transformation of Patient Accounts Application from Essbase/Hyperion System which operated on UDB Release 7 to Essbase/Hyperion Release 11 . Led in-house maintenance and enhancement of the system by understanding the details related to ODI and Essbase processes
• Guide and participate in migrating Windows-based Oracle 10g database and its associated tasks and schedules to Unix-based Oracle 11gR2
• Lead infrastructure management to ensure continuous availability and operational efficiency of service
• Manage ETL Servers where ODI is installed, Microstrategy App Servers Microstrategy Web Servers
• Monitor Production and Development Oracle Database Servers
• Team player who serves as a mentor and guide to team of junior analysts

Confidential

Lead Developer, Sales Applications BI Project

• Led a process to satisfy Univision's reporting needs by evaluating a number of BI tools, ultimately choosing an Oracle tool set and developing BI applications on those tools
• Evaluated BI tools using a framework for proof of concept: Microstrategy, Cognos, Oracle and Business Objects
• Established Oracle BI environment for development and Production. Worked with DBA group to set up Oracle Database 10gR2, Oracle Warehouse Builder OWB . Installed Oracle BI Discoverer App Server, Oracle Discoverer Admin and Desktop and Analytical Workspace Manager AWM for OLAP
• Implemented BI solution for Sales Insertion Order system. ETL tasks were done in Oracle Warehouse Builder OWB . Reports development was done in Oracle Discoverer. Continued to support the solution by providing upgrades and enhancements
• Led Salesforce.com deployment, from evaluation to development to implementation
• Created interfaces using Professional version set up to transfer master data and existing orders from Sales data
• Integrated salesforce.com into existing Univision sales system: stored unique Salesforce.com ID in the Sales System for data management, installed Outlook edition of Salesforce.com for contact and email, and participated in generating relevant reports
• Provided user support, including the addition of custom fields to accommodate user requests

Confidential

Lead Developer

• Worked as the lead developer on a Veteran Administration Project where Object Edge participated in the development of Enterprise Service Bus architecture
• Utilized WebLogic App Server, Java and Oracle technologies
• Participated in developing database model, populating data tables and testing various interfaces for the project

Confidential

Senior Technical Specialist, Data Standardization Marketing

• Installed, maintained and enhanced Standard Data Application deployed on Websphere Application Server. Application was developed using Java beans, JSPs, Java Servlets, and Oracle database 8i and 9i
• Designed and implemented complex interface between two Oracle applications using Oracle packages, stored procedures and functions. Oracle version used was 8i and later migrated to Oracle 9i
• Enhanced and maintained Global Marketing Product Management System. The repository was Oracle 9i and it deployed Oracle Packages, Stored Procedures Functions. It received data from front end Domino system

Confidential

Marketing Information System

• Enhanced product development planning and scheduling workflow system to populate a central database
• Technologies utilized: Oracle Database 8i and 9i, Oracle SQL, Oracle Packages, Procedures Functions

Confidential

• Enhanced and maintained EDI feeds written in Gemstone Smalltalk, including exception handling and application enhancements, and wrote the output to Oracle database tables
• Technologies utilized: Gemstone Smalltalk, ASP, JavaScript, Oracle

Confidential

• Developed enterprise wide interface solution to transfer data and control between Oracle PeopleSoft and Mainframe CICS system, using triggers and stored procedures to extract PeopleSoft data from tables
• Technologies utilized: Oracle Database Version 8i, CrossPlex gateway

Confidential

• Developed Workflow and Test Scripts for testing Financial Applications of Y2K conditions
• Technology utilized: SQA

Confidential

• Used Visual C and COBOL for a Real Estate Relocation Program to populate mainframe feed into SQL Server 6.5, and wrote stored procedure and ActiveX Data Objects to load tables
• Technologies utilized: SQL Server 6.5, Visual C , MQ Series, COBOL

Confidential

• Designed and developed Sales Recognition and Receipt Tracking Systems
• Technologies utilized: PowerBuilder 5.0, CornerStone Class Library, Sybase 11

Confidential

• Identified deficiencies in the business logic and code for cable Network Contract, Contact and Billing Systems, and applied correction using SQLs, program changes and user data entry.
• Technologies utilized: SQL Server, PowerBuilder 4.0, SQR, Business Objects, Siebel Oracle CRM

Confidential

• Created a sophisticated Receipt Tracking System to analyze and review sources of advertising revenue, migrating data to new hardware Windows , software PowerBuilder , and infrastructure Sybase
• Modified Profit Planning and Control System to PeopleSoft Accounting Code Structure and provided data feed to the PeopleSoft Financial System
• Implemented Head Count Payroll Model system to provide a variety of functionality to Planners to execute what-if scenarios for finalizing departmental budgets
• Rewrote application environment using Visual Basic and Sybase after generating a detailed technical specification document to bring out all relevant mapping between program modules, functions,and data structures
• Technologies utilized: Sybase, PowerBuilder, Objectory tool for requirement analysis and design , Erwin, C, VisualWorks 2.0, ObjectLens, MicroFocus COBOL, Visual Basic, SQA

Confidential

• Generated reports related to Drug Utilization Review by extracting data from DB2 loading into Sybase
• Technologies utilized: Sybase, PowerBuilder, C, DB2, VSAM

Confidential

• Developed a Customer Order Fulfillment System
• Technologies utilized: PowerBuilder, Sybase, Novell

Confidential

• Modified AS-RUN Log Reconciliation System of a cable network using PowerBuilder and SQL Server
• Technologies utilized: PowerBuilder, SQL Server, Novell Netware API

Confidential

• Played a key role in designing and implementing an enhancement to the Automated process of data transfer from the Network Commercial Sales system to Switch To Air Routine system
• Designed and implemented functions of a Corporate Front End system for Payroll using IDMS ADSO
• Enhanced various NBC systems, including their Scheduling System, Human Resource Information System, and Accounts Receivable Subsystem
• Technologies utilized: IDMS, ADSO, FOCUS, CICS

Confidential

Independent Consultant

• Carried out functional enhancements and trouble shooting for a variety of application areas including TV Network Inventory, Revenue Billing and Compensation, Station Clearance, Sales Plan, Contract Management, TV Network Routine Generation, Local Station Feed, Program Scheduling and Data Collection Systems
• Technologies utilized: UNISYS DMS-1100, ISAM, IBM 3090, IDMS

Confidential

Independent Consultan

• Developed Budgeting and Benefit Production applications for NYC Medicaid, Public Assistance, and Food Stamps Programs
• Technologies utilized: Sperry DMS-1100, TIP-1100, COBOL, UTS COBOL

Confidential

Technical Consultant

• Lead developer for in-house sales and accounting system, also implemented turn-key projects for external customers
• Technologies utilized: Sperry 1100 Series Mainframe systems, ECL, COBOL, DML