SUMMARY:

Over 16 years of experience as database architect, designer, database administrator and IT Lead Developer and DW Specialist using Oracle, Sybase, SQL Server, MySQL and Ingres and other open source RDBMSs, Programming using PL/SQL, T - SQL on various Unix platforms along with C++ and Java development wrappers for ETL and aggregators.

TECHNICAL SKILLS:

Languages: C++/STL, C, Core-Java, shell scripting, yacc/lex, awk, sed.

4GLs: Pro*C/C++, OCI/C++, OTT.

RDBMSs: Oracle 8/9i/10/11g, SQL Server, Sybase, Ingres and VAX/Rdb.

OSs: RHAT Linux, HP/UX, Solaris, SunOS, SVR, OSF/1, AIX, VMS & WinNT.

Tools: System Architect, SQL Developer, Abinitio, Power Designer, ErWin, SQL Tools, TS*Reorg, RMAN etc,C++ related - Rational Rose (UML & OMT), Purify, Quantify, POSIX Thread.

Communications: BSD 4.3 Sockets, TCP/IP, UDP, IP and ICMP, Sun RPC and NFS, Unix IPC.

ERP Apps: SAP R/3.

PROFESSIONAL EXPERIENCE:

Confidential, State of Arkansast

Data Warehouse Architect

Responsibilities:

• Analysis of EEF Cúram and legacy SNAPS business rules and data
• Analyze Data Flow diagrams to support the new DW design requirements
• Define ETL transformation Standards and specs to be adopted for all Informatica transformations.
• Define Informatica mappings and processing logic for all SCD2 type conversions. Due to complexities of Cúram built-in SCD transformations cannot be utilized.
• Interview consultants, provide project management support, other managerial and leadership activities.
• Define DB2 standards, configuration requirements, AIX configuration requirements, data refresh cycles etc.

Confidential, Richmond, VA

Sr. Architect Consultant

Responsibilities:

• ODS and DW Architecture and design.
• Develop SQL to extract and aggregate data using Oracle OLAP functions.
• Some transformations were done using Unix/Shell scripts, Unix Utilities and C++ code and Oracle SQL stored procedures and functions..
• Data was de-normalized and cleansed using C++ programs or stored procedures depending on the size and complexity.
• Used crontab for scheduling and monitoring jobs.
• Wrote several different aggregate components to plug into shell scripts to build a ETL environment.
• Helped DBAs with DDLS for views to release aggregated partitions ready for production release.
• Negotiated extract schedules with legacy teams. Managed and litigated issues related to data quality and extract issues pertaining to several different legacy systems due to different refresh cycles etc.

Confidential, Charlotte, NC

Sr. Architect - Consultant

Responsibilities:

• Confidential is a real-time high throughput trading system backend implemented using TIBCO EMS/C++ providing a service layer for various internal and external front-ends and downstream systems. All Confidential Fixed Income Trades are routed through Confidential .
• Sr. Member of the IT team hired to redesign and enhance functionality related to evolving and rapidly changing requirements for various regulatory agencies such as MSRB, DTCC and others.
• Meeting with Traders and Middle Office personnel to discuss requirements and enhancements required for Confidential .
• Supporting the Traders and middle office users by helping the production support staff, determine issues with the system and/or interfaces, creating enhancement requests, determination of the work effort and scheduling changes to Confidential .
• Designed a rule based process to help speed up implementation to ensure Confidential was not penalized for late or misreported trades.

Confidential, NYC, NY

Director of Data Engineering/Architect

Responsibilities:

• Worked closely with Product Development Managers and the Software Engineering teams to streamline database design and develop PL/SQL and T-SQL code to meet the requirements for the new database architecture and product enhancements.
• First to Market - Complete unification of Meta-data related to Books, Video, Video Games and Music based on Ralph Kimball’s Data Warehouse Bus Architecture.
• Lead a team of server-side developers and hands on development using PL/SQL and T-SQL to help migrate and normalize data from various databases to a single Unified database.
• Defined data interchange formats and feeds, XML repositories, Data Stores, Database Architecture.
• Architected DW/Data Store and ODS to create factless data warehouse for Media Product related information.
• Implemented and feed ingestion scripts using Unix shell scripts and PL/SQL store procedures and pseudo procedures and blocks for Data sourcing and ETL activities.
• Designed API for Generic data client dependent extracts using PL/SQL and built interfaces for web service based data delivery mechanisms for meta-data out of the data store.
• Due to large volumes of data involved Oracle 10g partitioning and bulk loading capabilities were extensively used. Used built in SQL Functions to convert Data Warehouse denormalized data into normalized views.
• Used Visio extensively for Data Flow Diagrams and for Data and Process Flow modeling.

Confidential, Jersey City, NJ

AVP - GSS DW

Responsibilities:

• Sr. member of the Global Sales Services Data Warehouse.
• Responsibilities included requirements gathering, maintenance of the Perl/T-SQL based ETL processes.
• Responsible for the EAI/Web services based processes for GSS-DW ETL processes.
• Liaison between the Database Administrator group and GSS-DW team.
• Build and publish Data Cubes for BO Reports.

Confidential, Union, NJ

Project Lead Developer Database Warehouse ETL

Responsibilities:

• Designed and developed a home grown ETL tool using shell scripts, PL/SQL, C++/STL/C Pro*C to normalize data sourced from Mainframe to normalize, aggregate, cleanse and load into Oracle 9i.
• Initial database instance used was Oracle 8 which was later migrated to Oracle 9i and eventually to 10g to utilize the new features for Partitioned tables and bulk data processing as well as some new features in related to ranking and some new sql functions.
• Supported data marts related to Call Plan Reporting, Call Plan Management Summary Reports, Call Plan compliance reports, Weekly and Monthly Rx, Managed Care Rx, Merck-SP Joint Venture, Response to Target - Targeting Frequency and Reach DSS and Incentive computations and reporting for Hep./Oncology markets.
• Oracle Database instance size was approx. 3TB and weekly data aggregation using PL/SQL, Unix Shell scripts and some C++ components was approx. 500 Million Prescriptions sold in various product markets for North America (USA, Canada and Mexico).
• Used Ab-Initio ETL tools for aggregating large amounts of data for reporting purposes related to OLAP based data marts and DW/ODS. Used Oracle 8i/9i/10g (R)OLAP functions for aggregating Sales and Marketing data for smaller amounts of data.
• Used Rational Rose (UML) and C++/STL for all design and development activities.
• Designed and developed an ORM persistence layer in C++/Pro*C for Oracle for SFA system.
• Used Visio extensively for Object Modeling (UML), Process Flow and Data Flow diagrams.

Confidential, Piscataway, NJ

Sr. Consultant

Responsibilities:

• Provided leadership in design and development activities & mentored other developers.
• Designed and developed code generators in C++ for parsing and processing FCIF formats data files. FCIF format is similar to XML.
• Designed the preprocessor for ALPSS/Mozart Directory Listing system
• Designed and developed code generators in C++ to generate C++ source code for mapping relational tables and Business Objects and provide persistence storage to Business objects.
• Used Rational Rose (UML), C++ and Rougewave for all design and development activities.
• Developed and maintained PL/SQL stored procedures.
• Tuned C++ Application using Quantify and Purify.
• Reverse engineered both C++ code using Rational Rose and Power Builder front-end code and PL/SQL code using Cast Application Mining suite.

Confidential, I A

SAP Basis Administrator

Responsibilities:

• As part of the ERP Infrastructure team, helped implement SAP R/3 on Oracle and HP/UX.
• Performed the role of Oracle DBA for enterprise wide production database.
• Created hot-standby and disaster recovery databases and identified, implemented backup and recovery strategies using Omni-back.
• Administered SAP/R3 for a system that supports over 50000 users.
• Performed upgrades, applied patches and performance tuned SAP R/3.
• Helped identify bottlenecks in processes and located poor performing SQL statements. Recommended and performed necessary modifications.
• Tools used TMS, CTS, SQL*LAB, OSS, TS*Reorg.

Confidential, NJ

SAP Basis Consultant

Responsibilities:

• Monitored Oracle performance and tuned SAP R/3 application.
• Created hot-standby databases and created backup and recovery strategies using ADSM.
• Performed routine Oracle DBMS administrative activities like reorgs and refreshes for the development systems.
• Applied legal and hot patches and used OSS extensively for problem resolution.
• Helped create a load balancing policy for SAP R/3.
• Managed SAP R/3 processes and printers and spools.
• Configured CTS and TMS and performed CTS.

Confidential, NYC, NY

Manager Network & ERP Applications

Responsibilities:

• Performed project planning for Basis Team’s activities for HP/UX and Oracle version upgrades
• Configured TMS and CTS and developed a strategy for CTS and client refreshes. Used OSS for problem resolution and applied notes.
• Helped identify Oracle performance problems and suggested modifications to the SAP R/3 application team.
• Installed ITS and Java SAP GUI.
• Wrote ABAP Programs to assist in the SAP Basis Team’s tasks.
• Developed EDI interfaces for links between Confidential and Bank of America.

Confidential, Jersey City, NJ

Manager Real-time Content Delivery

Responsibilities:

• Architect and Designer of the database to implement a Total News Solution to provide real-time web-based news and quotes distribution.
• Lead the technical team for design and implementation of the Business Object Server (BOS) and News Repository using C++/STL, CGI, and CORBA implementation objects.
• Worked hands on in implementing the BOS using OCI and C++/STL.
• Developed a bridge between the BOS & APIs of various news feeds like Reuters, DJ New Wire and Bloomberg - using C++/STL, TCP/IP.
• Implemented the push and pull models using CORBA, HTTP & CGI/C++.