SUMMARY

• Over 25 years of experience in Enterprise level BI/DW Solutions, Mainframe, Client - Server and Cloud Applications.
• Expertise in data architecture and designing/Implementing enterprise platforms like Data warehouses and Big Data Solutions.
• Over two years of experience in Big Data Architecture with good exposure to technologies like HDFS, Spark, Hive, Pig, Flume, Kafka, Cassandra, MongoDB.
• Proven expertise in all aspects of data management methods and practices including, Design of DW schema, Re-engineering and reverse engineering, Data Profiling, Data Quality, Data architecture strategy, Data migration, Cloud Storage, Performance tuning.
• Experienced in ETL implementation using Informatica, BODS, SSIS.
• Experienced in creating physical database objects and data marts such as tables, indexes, stored procedures, functions, triggers and writing complex SQL queries.
• In-depth knowledge on application development methodology with strong programming skills in Python, C, C++, SQL, PL-SQL, COBOL, T-SQL.
• Vast experience in Extraction, Transformation and Load (ETL) strategy, design and implementation.
• Includeing ETL across different platforms such as Oracle, Sybase, Teradata, VSAM files, SAP Applications.
• Extensively worked on Dimensional modeling - Drill Down and Roll Up, Slice and Dice.
• Designed and developed Data Marts by following Star Schema and Snowflake Schema Methodology.
• Experience with business intelligence (BI) tools like Tableau, BO, COGNOS.
• Worked closely with customers to analyze data sources, for the purpose of integration with planned data frameworks, and to understand BI requirements.
• Industry domain experience in Manufacturing, Banking, Retail, Insurance and Health Care.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Information Architect

Responsibilities:

• Developing the data model and Info. Architecture for an Authorized Data Source (ADS) for Payments, based on ISO 20022.
• Mapped Foreign Exchange and other Financial Markets trade data to FPML (Financial Products Markup Language), to develop a canonical model for the enterprise.
• Developed data warehouse solution in the cloud (AWS) on Snowflake.

Consultant Data Engineer/Architect

Confidential

Responsibilities:

• Developed search functionality using ElasticSearch for an ecommerce application.
• ETL design and development, in Python and Spark, for an IOT solution over lighting fixtures, data sourced from over 500 Postgres databases, loading into HDFS for analysis.
• Developed BI reporting solution for an offers/promotions application, data for which was sourced from a Cassandra 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 Kafka.
• As a POC, Implemented the solution in Scala, for a large Bank in India.
• Developed data lake architecture, on MongoDB, for a large automobile manufacturer in Europe.
• Architected a BI solution for Marketing analysis using Redshift and Python on AWS.
• Developed 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.
• 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 Python, for a Data mart in the Retail marketing space, for Allant (a Retail Marketing service provider
• Confidential  Lead and Architect the project for data migration from Salesforce.com (SFDC) and Siebel to a consolidated instance of SFDC. SAP BODS with SFDC Adapter used for migration.

Confidential, Chicago

Architect/Manager - Business Intelligence

Responsibilities:

• 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 Linux.

Confidential

Senior Manager - Information Management.

Responsibilities:

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

Software: ErWin, Oracle, Teradata, COGNOS, BusinessObjects, OBIEE

BI Architect and Program Manager

Responsibilities:

• In the center of excellence, responsible for managing the development of iDecisions, Business Intelligence (BI) framework for data marts in various domains like Telecom, Banking, Insurance, Retail, Airlines, HealthCare.
• iDecisions, which is Satyam’s IP, is used as an accelerator for building BI solutions.
• In the center of excellence (COE) for data warehousing, designed solutions using Composite Virtualization server.

Confidential

Software: SAP, Teradata, SAP BI, SAP MDM, MicroStrategy

Data Architect

Responsibilities:

• Responsible for Enterprise Data Architecture in Sales and Distribution, which includes the subject areas of Order Entry, Finished Goods Warehouse Management, Transportation and Invoicing.

Confidential

Software: Oracle, ErWin, Informatica, COGNOS

Senior Consultant

Responsibilities:

• In the Data Warehousing Center of Excellence, Train and mentor data analysts, and manage various data warehousing and ETL projects, related to design and performance improvement in Informatica, COGNOS and Oracle data base.
• Develop response to RFPs and develop the architecture for various projects.

Confidential, Austin, TX

Software: Oracle, Pl/Sql, ErWin, UNIX, HIPAA, HL7

Senior Consultant

Responsibilities:

• Lead the design and implementation of the insurance database cache for e-IIV (Electronic Insurance Identification and Verification).
• 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

Software: Oracle 9i, Sybase 11, Informatica, Pl/Sql, ErWin, UNIX Shell

Project Lead

Responsibilities:

• 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

Software: Oracle, UNIX (Solaris), PL/SQL, Unix Shell, ErWin

Project Lead

Responsibilities:

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

Confidential, Dallas, TX

Software: Oracle, UNIX, Pl/SQL, Python, ErWin

Technical Lead

Responsibilities:

• Manage and lead a team in developing the database and load scripts for a B2B Messaging system, for EDI and XML Messages, in the Utilities Deregulation Market.
• Manage the design and development of ETL scripts using Pl/Sql and Python.

Confidential, Omaha, NE

Software: Oracle, PL/SQL, ProC, UNIX (HP-UX, AIX)

Consultant

Responsibilities:

• EADS (Engineering Advanced Decision Support) is a very large Data Warehouse for the Engineering Department.
• MCS (Maintenance Control System) is an OLTP system which is used to record and track maintenance and service operations on locomotives.
• Implemented Replication between MCS and EDCS databases.
• EDCS (Equipment Data Collection System), a payroll system for the maintenance workshops.

Confidential, Des Moines, IA

Software: UNIX, Sybase, C++, MVS, COBOL, CICS

Senior Software Engineer

Responsibilities:

• 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

Software: UNIX, C/C++, MVS, COBOL, CICS, IMS, DB2

Senior Software Engineer

Responsibilities:

• As a consultant at John Deere (Moline, IL), was involved in the enhancement and maintenance of the inventory and parts distribution systems.
• Designed and developed a package for Linear Programming, in C.
• Developed a Device Driver, under UNIX, for the UT1553B communications controller.