SUMMARY:

• Data Warehousing ~ Business Intelligence (BI) ~ Information Management ~ Solution Architecture ~ Project Management
• Results - driven leader with excellent communication and problem-solving skills, known for ability to work under tight budgets and timelines to deliver quality solutions that solves complex business problems.
• Proven ability to analyze large-scale business requirements and drive all phases of data warehouse development and support, including the design of Enterprise Data Architecture and Implementation Strategies.
• A demonstrated record of accomplishment of using current technology to substantially increase decision-making accuracy while decreasing cost.
• The proven ability to align business goals and objectives with IT capabilities.
• Managed a Corporative initiative to Re-Engineer the existing Data Warehouse to align with its 5-year growth strategy. I was responsible for resource planning, implementation plans, roadmap, project plans, current state assessment and future state architecture. Developed Logical Data model of core subject areas.
• Led JAD sessions with Senior Management and SME’s of functional areas and assisted the development of initial business requirements. Developed a Data Management Process with work products and templates, which was a repeatable process that reduce the time and cost to delivery. This allowed the Data Management team to meet their SLA obligations to the Business Users.
• Responsible for developing information strategies and roadmaps, as well as, delivering analytical solutions to support the business. I was also responsible for promoting ways to use data and analytics to best meet enterprise business needs, and facilitating a consistent approach to developing, accessing, and applying data across the enterprise.
• Led the development and execution of the Business Intelligence Data Roadmap. This roadmap is a multi-year strategy focusing on data integration and process improvement, analytic capabilities, and user data access tools, as well as data governance and data quality to support the enterprise’s 5-year strategy.
• Managed the implementation of Master Data Management approach that generated 23% process improvement while taking advantage of shared Customer and Product Data information. Produce Data Governance guidelines to manage a MDM environment.
• Implemented Data Management Process and RACI to ensure quality measures with a repeatable process. This process was aligned with day to day activities and Governance council activities.
• Provided direction on the development of the Data Mart and Dashboards to support the reporting and analytical needs of the multiple functional business areas.
• Collaborated with business stakeholders, other shared services organizations, development teams, corporate groups, and vendors to implementation of Enterprise Data Warehouse solution using Business Objects XI and Oracle.
• Managed in the implementation of Teradata’s Telecommunication Logical Data Model and IBM’s Retail data model.
• Develop Enterprise Data Warehouse architecture which included SOA interfaces and a Federated Data Warehouse.
• Managed the implementation of Business Intelligence application using Netezza and Business Objects.
• Implemented SAP NetWeaver BW and Retail Link data marts in Teradata.
• Developed POC Dashboards using Business Objects Xcelsius
• Managed the integration of Financial General Ledger and Billing applications into the Enterprise Data Warehouse.
• Developed Solution Architecture to support Data and User Migration process to convert from DB2 to Teradata
• Designed a Solution Architecture to build a Hub and Spoke EIM architecture using Netezza and Cloudera(Hadoop), which centered around three major components (Operational Data Hub, Enterprise Data Hub, Analytical Data Hub and Cassandra (NoSQL).
• Developed an Architecture Blueprint and strategy for data retirement and archive using AWS Redshift and Hadoop.
• Architected a MS Azure Data Lake solution using JSON file, Hive DB, Tableau and Power BI tool.
• Architected a MongoDB solution for an insurance company.

SKILLS SUMMARY:

Business Intelligence: Cognos, Hyperion, Business Objects XI, Siebel Analytics, Oracle OBIEE DB2 OLAP, SAP NetWeaver BW, Tableau, Power BI

ETL: Prism, Informatica Suite(MDM,Metadata Mgr,etc), DataStage, PLSQL, BO Data Integrator

Data Modeling: Erwin, Data Architect, System Architect, Rational Rose, Visio, ER Studio Embarcadero

Master Data Management (MDM): Siperian, Trillium, BO Data Quality Manager (DQM), Informatica Suite MDM, Metadata Mgr, etc)

Modeling: Business Model, Logical Data, Physical Data, Dimensional, Conceptual, Component and UML

Databases: Oracle, DB2, Teradata, Netezza,, Hadoop(IBM BigInsights, Cloudera), Amazon Redshift, MS Azure, MongoDB

Industry: Telecommunications, Retail, Financial, Confidential

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Solution Architect

Responsibilities:

• Lead in the design of a solution to email customers for the notification of their insurance application.
• This was a MongoDB assignment, where I design the collections and assigned the indexes and primary keys.
• I wrote the High Level Design document and Data Flow diagram that was used by the ETL and API developers.
• In the HLD, took data from DB2 sources and insert into MongoDB.

Confidential

Sr. Consulting Manager/Solution Architect EIM

Responsibilities:

• Solution Architect of Confidential ’s EIM practice where I am responsible for providing added value and thought leadership to both Confidential ’ clients and internal Consultants.
• My role included interviewing with our clients to understand their business objectives.
• Provide a technical solution that aligns their business objectives with their IT capabilities.
• I was responsible for the overall design of a MS Azure Data Lake implementation.
• This include the data model, ingestion of the data, and general architecture.
• Here we used MS Azure blob storage to capture real-time transaction JSON files and then move them over to a Hive database for analytical reporting.
• Here we used Horton Works and PowerBI to access the data.
• Extensive work on SOAP API’s. Working with a .net application that access the truck information and pass it to the Data Lake.

Confidential

Solution Architect

Responsibilities:

• I was responsible for the overall design of the Hadoop environment, which included Hive DB, Sparks, Python, Cloudera and Power BI.
• Using Teradata LDM for Telecommunication, I create the LDM and Physical data models.
• I also generate the DDL to create the Physical database and tables, xref tables and views.
• Work with business to define and prioritize data requirements for enterprise applications including data attributes, entities, business rules and data definition, metadata preparation and ensure adherence to the data governance processes
• Work with the business users to understand the requirements and developed ETL standards documents for extracting data and populating the model.
• Assessment of Client’s EIM Architecture
• Developed User Migration Process to move from DB2 to Teradata
• Identified Vendor of conversion tool to convert DB2 SQL to Teradata
• Develop Query conversion process using conversion tool
• Develop a strategy to use the Operational Data Hub as an Ingestion Engine using Hadoop Clusters for persistent source data and the Enterprise Data Hub as the integrated single source of truth of business data and provided Analytical needs virtually through views as Spokes of the Enterprise environment. I also performed design in VBP and MLR programs which include technical high-level design document, but also data model modification.
• Perform Product Evaluation and Selection (PES) process of Hadoop supported products, such as Cloudera, IBM BigInsights, MarkLogic, MongoDB, Sparks, Hive DB, etc., in relationship with existing Client’s product/tools capabilities.
• Use Hive db as the ingestion engine or Operational Data Store, which eliminated a step in the ETL process and provide a means to handle unstructured data.
• I worked with the Enterprise Architecture team to develop a Technology Capability Stack to better assess needed expansion of capabilities and identify gaps or overlaps.
• Developed data retirement strategy using Amazon Redshift and Hadoop, leveraging AWS EMR and AWS S3.

Confidential

Sr. Manager/Solution Architect

Responsibilities:

• Developed Data Mart layer which consisted of, common dimensions, facts, and aggregates
• Implemented a Data Management Process Flow
• Designed WCHVIEWODS Women and Children s Health ODS and Data mart
• Establish Data modeling standards using ER - Studio s
• Provided standard for the ETL teams both onshore and offshore
• Responsible for information strategies and roadmaps, including delivering analytical solutions to support the business objectives.
• Also, responsible for promoting ways to use data and analytics to best meet enterprise business needs, and facilitating a consistent and repeatable approach to developing, accessing, and applying data across the enterprise

Confidential

Senior Consulting Manager

Responsibilities:

• Developed Data Management Assessment Methodology
• Developed Data Management Assessment Roadmap
• Business Intelligence Guiding Principles
• Developed Client Data Management Workshops
• Implementation Strategies aligned with Client’s Business short and long growth plans
• Developed Data Modeling Workshops
• Generated 6.5 mil in billable revenue
• Maintain effective working relationships with stakeholders managing or utilizing master data

Confidential, Atlanta, GA

Sr. Data Architect

Responsibilities:

• Lead design session with Business users
• Managed Data Analysis with source applications mapping into eCDW
• SME on technical issue with the ETL team
• Maintained the eCDW logical and physical data models
• Developed Data Mart layer of the eCDW, identifying dimensions, facts, and aggregates
• Worked closely with the business user defining requirements
• Develop BI solutions
• Conducted interviews with the client’s business community and performed JAD sessions
• Worked with ETL team on Teradata and Oracle load strategies

Confidential, Atlanta, GA

Solution Architect

Responsibilities:

• Solution Architect of Master Data Management (MDM) development projects
• Solution Architect for major retail, fuel & energy, Confidential and telecommunication clients.
• Designed of the overall architectural framework and implementation strategy EDW and BI projects.
• Provided product evaluation and selection for BI and MDM software.
• Conducted interviews with the client’s business community and performed JAD sessions.
• Developed and Implemented MDM data governance and RACI charts.
• Developed logical models, physical models, and dimensional models.
• Designed MDM Architecture and implementation strategies.
• Designed and implemented Operational Data Stores (ODS), Enterprise Data Warehouse, Federated Data Warehouse, and Business Intelligence solutions.
• Participated on sale proposals both oral and written
• Provided mentorship to Confidential ’s BI consultants
• Designed ETL architecture and Lead ETL projects
• Managed On-shore and Off-shore resources
• Developed Confidential ’s Data Modeling and Business Intelligence best practices and standards.

Confidential, Atlanta, GA

Release Manager - Sr. Consultant

Responsibilities:

• Lead the design of the EDW Logical Data Model, applying design changes based on user requirements. Instructed the ETL team on how to populate the EDW, regarding maintaining the integrity of the EDW and ensuring the relationships are maintained and populated in the required order.
• Maintained a project calendar of weekly milestones and activities from the overall project plan and tracked the progress of these milestones.
• Implemented a project issues log that documented all issues and risk identified during each phase of the project. I developed and recommended mitigation strategies for high-risk issues to reduce the impact to the project schedule.
• Coordinated and managed cross-functional activities between the Architecture team and the ETL Delivery team.

Confidential

Sr. Managing Consultant

Responsibilities:

• Responsible for 74% client utilization and a $9m sales objective.
• Technical consultant in sales presentation for clients interested in building data warehouses using DB2/UDB or Oracle. Prepared Data Warehouse Architectural presentations for the IBM’s Sales team based on client requirements.
• Responsible for the BI space in RFP’s to clients purchasing IBM’s Retail Enterprise Data Warehouse Model (REDW), which included the pre-sales activities and implementation strategies. Performed customization and support of REDW Confidential the client sites
• Designed and developed Enterprise Data Warehouse solution for major clients in the Utility & Energy, Distribution, Retail Sales, and Public sectors. Designed the overall architectural framework and implementation strategy. Provided recommendations for BI software, modeling techniques, web enabling, and CRM implementation. Conducted interviews with the client, performed JAD sessions, implemented methodology and standards, component models, logical models, physical models, and dimensional models.
• Designed Operation Data Stores that provided a centralized communication hub for CRM and Legacy applications. This was primarily done to create a single client view of a customer throughout the OLTP environment and the Data Marts. Designed the EAI architecture using MQ/Series, XML and various ETL tools.
• Designed Conformed Data Stores and Functional Data Marts specific to BI tools, such as Brio, Business Objects, Eureka, and Cognos. Designed the Dimensional Data Models required to support and enhance the features of the specific BI tool. Provided technical support to the DBA, ETL and Reporting teams during the development phase of these projects.
• The Lead Data Architect for IBM’s Retail Enterprise Data Model, working in conjunction with the IBM’s sales staff as a Technical expert. I performed the physical implementation of the Retail Enterprise Data Warehouse Confidential several client sites. This included physical data model, implementation design, database considerations and lifecycle strategies. Made recommendations how best to take advantage of DB2 warehousing features such as, MQT, MDC and Cube views.
• Developed and managed project plans and project budgets. Lead project teams in data model reviews, inspections, and all necessary documentation. Lead the development of Enterprise Data Warehouses for clients ranging in size from 500 GB to 14TB and provided life-cycle strategies.
• Worked with IBM’s Sales Team in the sale of a Bottom-up Architecture implementation strategy, this was used to bring immediate ROI to a client, while satisfying the business requirements of an Enterprise Data Warehouse solution.
• Wrote and co-wrote publicans in the area of Data Warehousing that are used as intellectual capital of IBM Confidential various client engagements.