SUMMARY:

• 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, 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 skills and the ability to act as a conduit between the business and IT
• Excellent at building detailed and accurate project work plans
• Experienced Enterprise Data Architecture covering logical and physical data models
• Possess the skills to considerably improve the performance of existing applications

TECHNICAL SKILLS:

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

Development Software: Oracle Data Integrator (ODI 11, 12c), 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, New York, NY

Sr ETL Developer

Responsibilities:

• PL/SQL procedures developed and implemented for integrating in ODI processes.
• Using ODI 12C, developed mappings, procedures, functions and workflow for healthcare claims. Data from various inputs were mapped to external tables and then applied encryption algorithms for certain entities before storing initial transaction data in raw format. Then applied algorithm to these data to prepare it for Data Warehouse use. Various status were recorded for the data control as it progressed through various stages. Developed workflow to handle multiple input processes for parallel execution. Performance related features of ODI were used. Also additional logic developed to make use of partitioning and sub partitioning implemented by the database group.

Confidential, New York, NY

Data Warehouse Engineer & BI Specialist

Responsibilities:

• 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, SalesForce and external Flat file feeds. Then used the staging area data to build Dimensions and Facts for reporting. Implemented many processes using PL/SQL procedures and functions. Where relevant analyzed the processes for performance - examined V$VIEWS and worked with DBAs.
• Designed and automated in-bound and out-bound processes from Oracle Data Warehouse
• Participated in the transformation of Confidential t 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. Some of the processes used Shell Scripts.
• 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
• Created logical and physical data models for the project covering all business functionalities
• Improved performance of various processes related to Databases and reports
• Team player who serves as a mentor and guide to team of junior analysts

Confidential, New York, NY

Lead Developer

Responsibilities:

• Developed many packages, procedures and function using Oracle PL/SQL. Integrated these with other Oracle and Salesforce.
• 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, Walnut Creek, CA

Lead Developer

Responsibilities:

• Worked as the lead developer on a Veteran Administration Project where Confidential 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, Rye, NY

Senior Technical Specialist

Responsibilities:

• 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, Tarrytown, NY

Technical Consultant

Responsibilities:

• 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

Technical Consultant

Confidential, Purchase, NY

Responsibilities:

• 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

Technical Consultant

Confidential, Stony Brook, NY

Responsibilities:

• 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)

Technical Consultant

Confidential, New York, NY

Responsibilities:

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

Technical Consultant

Confidential, Valhalla, NY

Responsibilities:

• 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

Technical Consultant

Confidential, New York, NY

Responsibilities:

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

Technical Consultant

Confidential, Fort Lee, NJ

Responsibilities:

• 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, New York, NY

Responsibilities:

• 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

Technical Consultant

Confidential, Montvale, NJ

Responsibilities:

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

Technical Consultant

Confidential, Purchase, NY

Responsibilities:

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

Technical Consultant

Confidential, New York, NY

Responsibilities:

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

Technical Consultant

Confidential, New York, NY

Responsibilities:

• 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 Confidential systems, including their Scheduling System, Human Resource Information System, and Accounts Receivable Subsystem
• Technologies utilized: IDMS, ADSO, FOCUS, CICS

Confidential, Port Chester, NY

Independent Consultant

Responsibilities:

• 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, New York, NY

Independent Consultant

Responsibilities:

• 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

Responsibilities:

• 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