SUMMARY

• Professional Goal: T use my technical expertise, business acumen and organizational skills t solve BI and data warehousing challenges on time and within budget.
• Enterprise architect and developer with over 32 years of IT experience . 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 wh has continuously mastered new technologies, from mainframe t object oriented systems and BI tools
• Self-starter with the established history of designing robust systems solutions that are easy t maintain and scalable for future enhancements
• Demonstrate great interpersonal skills and the ability t act as a conduit between the business and IT
• Excellent at building detailed and accurate project work plans
• Possess the skills t considerably improve 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, Shell Script, 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 Studi 2003, Websphere Software Application Development Java IDE , VisualAge Smalltalk, VisualAge Java, VisualWorks, Gemstone, Powerbuilder, Visual Studi 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 t 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 t Essbase/Hyperion Release 11 . Led in-house maintenance and enhancement of the system by understanding the details related t ODI and Essbase processes
• Guide and participate in migrating Windows-based Oracle 10g database and its associated tasks and schedules t Unix-based Oracle 11gR2. Some of the processes used Shell Scripts.
• Lead infrastructure management t 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 wh serves as a mentor and guide t team of junior analysts

Confidential

Lead Developer

Sales Applications BI Project

• Led a process t 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 t 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 t support the solution by providing upgrades and enhancements
• Led Salesforce.com deployment, from evaluation t development t implementation
• Created interfaces using Professional version set up t transfer master data and existing orders from Sales data
• Integrated salesforce.com int 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 t accommodate user requests

Confidential

Lead Developer

VA Administration Project

• 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 tw Oracle applications using Oracle packages, stored procedures and functions. Oracle version used was 8i and later migrated t 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 Domin system

Confidential

Technical Consultant

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

Confidential

Transamerica Leasing, Purchase, NY: Billing Systems

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

Confidential

• Developed enterprise wide interface solution t transfer data and control between Oracle PeopleSoft and Mainframe CICS system, using triggers and stored procedures t 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 t populate mainframe feed int SQL Server 6.5, and wrote stored procedure and ActiveX Data Objects t load tables
• Technologies utilized: SQL Server 6.5, Visual C , MQ Series, COBOL

Technical Consultant

Confidential

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

Technical Consultant

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

Technical Consultant

Confidential

• Created a sophisticated Receipt Tracking System t analyze and review sources of advertising revenue, migrating data t new hardware Windows , software PowerBuilder , and infrastructure Sybase
• Modified Profit Planning and Control System t PeopleSoft Accounting Code Structure and provided data feed t the PeopleSoft Financial System
• Implemented Head Count Payroll Model system t provide a variety of functionality t Planners t execute what-if scenarios for finalizing departmental budgets
• Rewrote application environment using Visual Basic and Sybase after generating a detailed technical specification document t 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