SUMMARY:

• Over twenty years of experience in IT, which spans experience in client server, Web and mainframe technologies. Several years of experience as project manager and technical lead.
• Expertise in Data Architecture, with over eighteen years in data warehouse and big data solutions design and development. Interests include data modeling, SQL and ETL tuning, Hadoop and advanced analytics.
• Good working experience in the domains of Telecom, Manufacturing, Banking and Insurance.

PROFESSIONAL EXPERIENCE:

Consultant

Confidential

• ETL design and development, in Python, for an IOT solution on lighting fixtures, data sourced from over 500 Postgres databases, loading into a Postgres database for analysis.
• Currently developing a data mart, for offers/sales data source in Cassandra, and also working on building a POC on Neo4j graph database.
• Developed a solution, in Python, for sales lead scoring, as a service in the cloud, including file - based and Velocify system interfaces.
• Developed a framework for Predictive Asset Maintenance, using HDFS, Spark and Flume.
• Developed big data architecture, on MongoDB, for a large automobile manufacturer in Europe.
• Architect a solution for on-line Marketing analysis using Redshift and Python on AWS.
• BI multi-tenant data architecture for distributors in the Retail domain.
• Design and develop data models and ETL for the Enterprise Data Warehouse, for Benjamin Moore Paints. Projects included Inventory Valuation, Chromalink - a project to track POS transactions. This project included development of complex SQL and Pl/Sql scripts for data loading and validation.
• Develop data models for the Enterprise Data Warehouse, on Teradata, for BCBS of North Carolina, to support Affordable Care Act (ACA) and ICD-10 conversion.
• Design the data model and ETL Scripts and data cleansing scripts for Householding, using Oracle SQL, Pl/Sql and Perl, for a Data mart in the Retail marketing space, for Allant (a Retail Marketing service provider ).

Confidential, Chicago

Architect/Manager

• Lead and hands-on in BI projects - ETL migration from Pl/Sql to SAP BODS, and DQ for a large Telecom service provider in the West Indies.
• Lead an offshore team in Reports development for a software vendor in the Health Insurance space, end-to-end BI implementation for a large software developer using MS SSIS and SAP BO.
• Install, trouble shoot and build competency in SAP HANA, on SUSI Linux.
• Design and build a BI solution for marketing services, including data modeling, dashboards and reports using SAP BO and ETL, from Google Analytics, using SAP BODS.

Confidential

Senior Manager

• In the data management solutions group, primarily responsible for building a data migration factory. The factory setup includes creating capacity and tools around the dimensions of People, Processes and Technology. Responsibility also includes managing and delivering data migration projects out of the factory and pre-sales support for data management.
• Developing re-usable components for data migration, specifically for legacy to SAP migration using BODS. Developing accelerators for data migration/DQ improvement from Siebel CRM to Salesforce, using Informatica.

Confidential

BI Architect and Program Manager

• Manage and lead development of the framework.
• Co-ordinate with domain experts on functional inputs for business processes and KPIs.
• Review & develop Data models & reporting templates (dashboards, strategic/tactical reports).
• Develop advanced analytics frameworks in various domains.
• Manage integration with industry standard data models.
• Participate in pre-sales and sales efforts.
• Manage implementations of BI projects using iDecisions.
• In the center of excellence (COE) for data warehousing, designed solutions using Composite Virtualization server.

Confidential

Enterprise Data Architect

• Responsible for Enterprise Data Architecture in Sales and Distribution, which includes the subject areas of Order Entry, Finished Goods Warehouse Management, Transportation and Invoicing. End-to-end Responsibility includes the following,
• Manage and lead the development of the enterprise logical model.
• Mentor and manage data modelers, review/develop physical data models for SAP BI and staging and dimensional models in Enterprise Data Warehouse.
• Review artifacts - data flow diagram, data model, ETL processes.
• Design ETL processes and front-end reports.
• Analyze, identify gaps in SAP BI business content, model the missing content.
• Lead Customer MDM development.
• Maintain Systems of Record for data entities in O2C.

Confidential, Austin, TX

Senior Consultant

• Lead the design and implementation of the insurance database cache for e-IIV (Electronic Insurance Identification and Verification), this system allows a medical facility to search for available insurance benefits. HL7 messages from a medical facility are transformed and stored in the database, before being forwarded to the Clearing House as EDI (X12) messages. Responses are similarly stored and forwarded to the medical facility.
• Design and implement database supporting the messaging system for ePharmacy (Electronic Pharmacy). This system facilitates the exchange of Claims data, as NCPDP messages (over HL7), between Pharmacies and Insurance Processors.

Confidential, Dallas, TX

Project Lead

• Prepare the project plan for migrating and integrating data from the Order Entry System, NX 1.7 to NX 2.0, which also involves extracting and migrating data from the Billing System which is in Sybase. Design and implement the Staging Area, Pl/Sql and TSQL scripts for Data Analysis and Profiling.
• Design Informatica Mappings and Workflows and develop standards for migrating Confidential Online West Systems to the SSP Database.
• Lead and mentor developers and DBAs in SQL, Database design and tuning, for a very large DataWarehouse.

Confidential, Dallas, TX

Project Lead

• Lead the design and development of database for the SMS (short messaging service) games system. This application allows users to play Trivia Games on their SMS enabled cell phones.
• Install and implement Oracle 11i (Financials) under Solaris with high availability. Work with the Functional Consultants to setup GL, AP, AR and Assets modules. Using Open Interfaces and Pl/Sql, migrate data from legacy systems to Oracle Financials.

Confidential, Des Moines, IA

Senior Software Engineer

• Developed and supervised the development of C/DB Library programs and stored procedures, using Sybase and Sybase gateway for CICS, to update the mainframe database (VSAM files), with transactions generated in the client server system.

Confidential

Senior Software Engineer

• Developed a Device Driver, under UNIX, for the UT1553B communications controller.
• Involved in the development of a semiautomatic translator from IMS DB to DB2. This product was developed in C++, under UNIX.