EXECUTIVE SUMMARY:

• Extensive experience in design, development and implementation of Business Intelligence Systems, utilizing
• Structured and Unstructured data feeds, including Big data, for Financial, Insurance, Media, Retail and Pharmaceutical Applications with emphasis on Data Analysis, Conceptual, Logical and Physical Data
• Modeling, Database Design, Implementation and Performance Tuning, ETL workflow and development, and Business Intelligence Reporting
• Proven track of solving the most challenging tasks and developing and implementing creative data solutions, which yield increased profitability, reliability, security and operational efficiency
• Enterprise Data Warehouse Architecture, Development and Implementation;
• Master Data Management and Governance;
• Business and Data Analysis, including Big Data, for OLAP Data Modeling and Physical Implementation;
• Enterprise Data Sources to Targets Infrastructure design; Source to Target data mapping, ETL Implementation;
• Hands - on Development and Performance tuning of Database, ETL, BI reporting and MDM processes and procedures;
• Business Intelligence Reporting design and development with drill down, roll up and drill across functionality;
• Database Administration, Capacity Planning, Troubleshooting, Performance Tuning, Parallelism and Partitioning;
• Metadata Standards, Naming Conventions, Data Dictionary support of standardized taxonomy for enterprise data system

TECHNICAL SKILLS:

Databases: Oracle 12C/11G/10G/9i/8i, DB2, SQL/Server 2012/2010/2008 , Netezza, Informix, Sybase, IDMS, IMS

Systems: UNIX Solaris/HP-UX/AIX, Windows 10/7/XP/2000/NT 4.0, MVS/ESA, VM, VMS, MS-DOS

Languages: PL/SQL, T-SQL, SQL92, Hive QL, Python, Visual Basic, C, COBOL II, BAL, FORTRAN V, REXX

Data Modeling: ERWIN, ER/Studio, Rational Rose, Oracle Designer, Popkin System Architect, CA Repository

DB Admin : Oracle 12C/11G/10G, SQL*Plus, SQL Developer, TOAD, DB/Artisan, Confidential Data Studio, RMAN, Oracle Data Pump, SQL*Loader, Import/Export, Control-M, Tidal, HP Quality Center

DW/BI: Confidential DataStage, Informatica, SSIS, SAP BO Data Services, Business Objects, QlikView, Crystal Reports

Main Frame: CICS/LU6.2, DB2/QMF, IMS, IDMS, VSAM, ISAM, TSO, JCL, MDI Gateway, EZtrieve, RACF, ACF2

Miscellaneous: XML, HTML, JDBC, ODBC, MQ Series, MS Office, MS Project, Visio, PowerPoint, SDLC, AGILE

PROFESSIONAL EXPERIENCE:

Data Warehouse Architect/Consultant

Confidential, New York, NY

Responsibilities:

• Business Data analysis, OLAP Dimensional Star Schema Data Modeling for Data storage and Business Intelligence Reporting using Confidential media data sources, such as Omniture, UpLynk, FreeWheel, SIMS, and Tribune
• Development of ETL infrastructure for automatic process and housing of Hadoop based media data, provided by external data vendors, using specialized software tools such as Hive, Curl, Python, Confidential Infosphere Datastage and QualityStage
• Development and production implementation of Informatica MDM server solution for automatic synchronization of Shows and Episodes between Confidential SDR Data Warehouse and MDM Hub’s golden copies to ensure proper BI reporting

Technology: Erwin, Netezza, Oracle, SQL Server, DB2, Confidential Datastage, Hadoop/Hive, Python, Informatica MDM/IDQ/IDD

Lead Data Architect/Consultant

Confidential, New York, NY

Responsibilities:

• Business Analysis of ‘Securities’ legacy system, including subject areas such as Clients, Accounts, Securities, Transactions and Settlements for conversion into modern era Enterprise Data Architecture utilizing best of breed technologies
• Utilization and expansion of Banking Data Dictionary taxonomy; Development of Conceptual, Logical and Physical Entity
• Relationship models utilizing data normalization process for reducing data redundancy, establishing entity relationships, enforcing referential integrity between entities in various subject areas
• OLTP data modeling, architecture and database support of application architects and developers, including creation of new entities and relationships, attributes and indexes, physical database implementation, migration of data between different environments, performance tuning and troubleshooting of database objects and queries, eliminating legacy data issues
• Development of data purging and archiving strategy utilizing Oracle data partitioning strategy and application subject data experts knowledge regarding applicable data retention time for transactional and historical data

Technology: ER/Studio Enterprise Edition, Oracle 11G, SQL Server 10.0, DB/Artisan, TOAD, Oracle Data Pump

Lead Data Architect/Consultant

Confidential, New York, NY

Responsibilities:

• Business analysis and re-design of existing Point of Sale Data Mart system, which houses information about accounts, organizations, products, currencies, orders, deliveries, invoices, account receivables and payables, in order to improve data quality, eliminate inefficiencies in Data architecture and ETL, fully automate data load processes, migrate reporting platform from Oracle Forms to Microstrategy Reporting; Performance tuning of SQL queries, stored procedures and functions
• Identifying new data sources, designing new dimensions and facts to meet additional requirements from business users, mapping of source to target data, enhancing existing dimensions by expanding attributes list, refining dimension to fact references, replacing natural keys with surrogate ones as per Best DW Practices, implementing and optimizing Oracle partitioning strategy for better loading and reporting performance, revamping index strategy based on data cardinality.

Technology: ERWIN, Oracle 11G, Informatica, Microstrategy, Toad, Sql Developer, Linux

Lead Data Architect/Data Modeler/ETL Developer

Confidential, Jersey City, NJ

Responsibilities:

• Performed business analysis, conceptual, logical and physical dimensional OLAP design, data modeling and implementation of Financial Marketing system (“Touchpoint”). Data encompasses holistic view of the client, based on sales transactions and marketing information about contacts with the client, made in the course of Marketing campaigns, CRM communications and Company’s website visits by individual investors, financial advisors and institutional clients over historical period of time.
• Contact data included Campaign Emails, Corporate sales visits, Website clicks and activities including Web based external financial services, Web conferences, CRM Communications, Literature subscriptions and orders, and Marketing campaigns
• Developed sophisticated algorithms and procedures for deriving analytical data from “Touchpoint” data mart for profiling and segmentation of clients based on statistical correlation between marketing contacts and financial transactions over historical period of time, to predict and influence clients’ performance by means of clients’ customized marketing campaign strategy
• Designed and developed complete ETL framework, Source-to-Target mapping of data elements and data lineage, and transformation procedures for automated data delivery from various data sources and providers, including internal systems, Web click streams, CRM data, Email files, Literature XML files, Excel users’ files, Web service (SOAP protocol) data
• Designed and developed SAP Business Objects universes, trained business users to best practices of using data in Business Objects reports to maximize performance and take advantage of optimized OLAP data mart
• Created Business Objects Intelligence and QlikView Dashboard reports for 360 degree unified holistic view of the client
• Developed Permanent Security ID Reference data mart to provide stability to Security ID and the linkage between market data and user-provided estimates and ratings; permanency of Security ID and the cross-reference between key Security identifiers have been implemented by using Type II slowly changing dimension (Security Master File Reference data)
• Implemented ETL workflow and processes for loading data into Product (Security) MDM Data Hub from multiple feeds such as Bloomberg, CompuStat, Fidelity Corporate Actions data, GICS Direct (MSCI), and PAM (Princeton Financial Services)
• Developed multidimensional cubes for analysis of clients’ portfolio performance across multiple products and client types
• Utilized MDM Data Governance for Data Quality, SDLC for analysis, architectural design and DW implementation

Technology: ERWIN, ER/Studio, Oracle 11G/10G, SQL Server 8.0, Confidential InfoSphere DataStage, Confidential Web Services (RTI), SAP Business Objects XI, QlikView, SSIS, SSAS, UNIX, DB/Artisan, SDLC/Agile

Lead Data Architect/Developer

Confidential, New York

Responsibilities:

• Performed business study and developed functional specification, dimensional (OLAP) modeling supporting aggregated view of metric performance indicators with drill down, roll up, and drill across capability embracing multiple metrics and dimensions such as Business Unit, Service Center Unit, Region, Product, Problem and Time for Confidential
• Developed detail source-to-target mapping, logical and physical dimensional modeling design and implementation
• Implemented complete ETL workflow using SQL Server, Oracle, PL/SQL and Business Objects Data Integrator
• Implemented detail data validation process, error handling, troubleshooting and performance tuning procedures

Lead Data Architect/Data Base Administrator

Confidential, New York

Responsibilities:

• Analyzed IMS, NDC, DNA, CARS, and other data feeds encompassing prescription utilization, rebate and chargeback transactions for Medicare, Managed Care and Veteran Administration systems
• Developed Logical and Physical Dimensional (Star) data models and forward-engineered them into Oracle 9i Data Marts
• Performed source-to-target ETL mapping for historical and incremental Type1 and Type2 update using DW best practices
• Developed ETL processes for Veteran Administration, Medicare, and Managed care using Informatica, Unix and PL/SQL
• Developed and tuned Business Objects Universes and Reports using Designer, Supervisor, BO Report Manager, WEBI
• Performed application and Oracle 9i database performance tuning for better data load turnaround and BI response time

Lead Data Architect/Data Base Administrator

Confidential, New York

Responsibilities:

• Analyzed ViewDirect architecture to identify and eliminate model deficiencies in supporting large data volumes
• Performed capacity planning, installation, and trouble-shooting of Oracle 9i, Database objects, and SQL queries
• Performed Logical and Physical design and implementation of Data Warehouse using Oracle 9i and DB2 UDB
• Set up ETL procedures for data loads using PowerCenter 6.0; Created Business Objects universes for reporting

Confidential, Montvale, New Jersey

Responsibilities:

• Full life-cycle design, data modeling and implementation of Microstrategy Engagement data mart
• Developed Informatica ETL mappings, optimized sessions and Oracle 9i target sources for robust data loads
• Developed and implemented slowly changing dimensions strategy for Engagement Data Mart
• Implemented Oracle 9i data warehousing features; set up ETL sessions and batches

Confidential, New York, NY

Responsibilities:

• Managed the process of analysis, data source identificion of new dimensions and fact tables, utilization of Conformed dimensions within Global Data Warehouse for Lost Revenue Data Mart, as per DW best practices
• Implemented Metadata Repository Framework for Enterprise Data Warehouse
• Developed ETL mappings using Informatica PowerCenter 5.1 and performed ETL and Oracle8i performance tuning
• Developed reports using Cognos PowerPlay and Brio

Confidential, New York, NY

Responsibilities:

• Re-designed OLTP Security Master and Commission Ledger data models; coached software developers
• Re-configured and tuned Oracle 8i Instance, modified database objects, and optimized OLTP database structure
• Re-engineered PL/SQL application stored procedures, triggers, and SQLs for better performance
• Streamlined and optimized data load procedures utilizing Oracle8i partitioning and parallel features

Confidential, New York, NY

Responsibilities:

• Designed and implemented ODS and Data Mart (Star schema) for ‘Strategic Customer Trends’ CRM
• Set up Oracle Express dimensional cubes for CRM Analysis by age groups and geographic locations
• Implemented source-to-target mapping with Informatica and PL/SQLs; managed Oracle/Java/XML developers
• Developed Business Objects Universes and assisted account executives with Business Intelligence reports

Confidential, New Jersey

Responsibilities:

• Performed DBA support for Clinical Data Warehouse, comprising Zocor Clinical Trial data from U.S. and overseas
• Set up Oracle database Digital Signatures procedures and scripts to comply with FDA CFR 21 Part 11 regulations
• Performed performance tuning of partitioned Oracle database for massive data updates and SAS Application Reporting

Confidential, New York, NY

Responsibilities:

• Conversion of “Exchange Physicals for Futures” and “Brokers Association” systems from VB 3.0/Oracle 7.3.1 VMS/Access into VB 6.0/Oracle 8.0 NT 4.0; Development of PL/SQL stored procedures, packages, and Crystal reports
• For Private Banking, OLTP database design of Portfolio Management System; development of client-server and Web-based textual and graphical portfolio performance reports, used by account executives for wealthy clientele
• Development and implementation of VB/Oracle/Main Frame-based customer information system (“CIS”) for worldwide automated banking service, which provided accounting, ATM, and investment inquiry services to 700 bank officers
• Development of Trade Capturing system for conversion of incoming trade transactions into electronic images. The system provided full capturing, storage, retrieval, audit, and archiving services by using a free-flowing trade packet
• Development and implementation of Automatic Magnetic Fuel Card System by pioneering the communication bridge between Windows based VB Client and Main Frame based CICS/DB2/IMS utilizing ODBC/MDI Communication Gateway
• Re-engineering of Main Frame DB2/IDMS/CICS/COBOL Customer Information System into Windows VB/SQL Server

Technology: Oracle 8.0.5 NT, Oracle 7.1 VMS, SYBASE 10.0, Informix 7.0, SQL Server 7.0/6.5, Access97, ERwin, T/PL/SQL Stored Procedures, Visual Basic, Crystal Reports, ImageBasic, IDMS, DB2, Windows, UNIX, MVS