SUMMARY:

A seasoned Information Management & Technology professional with 20+ years of extensive experience in Data Warehousing, Business Intelligence & Analytics, Data Management & Governance, Information Architecture, Enterprise Reporting, ERP Applications, IT Operations, Technology enablement and transformations impacting people, process & technology. A successful consultant with strong hands - on experience in several key areas from strategy/roadmap to implementation & support including business analysis, technical & functional requirements, architecture, implementation project management and establishing best practices. A senior BI Architect/Data Architect with proven track record to implement end to end Reporting & Analytics solution. A team player with excellent communication and problem-solving skills.

EXPERIENCE SNAPSHOT:

• Manufacturing
• Airline
• Telecommunications
• Retail
• Government

TECHNICAL EXPERTISE:

• Business Intelligence
• Data Analytics
• Data Governance/MDM
• Data Visualization
• Data management

TECHNICAL SKILLS:

Roles: Solution Architect, ETL Architect, BI Architect, Data Architect, BI/DW Manager

Data Modeling: Logical, Physical, ODS, Star and Snowflake schemas.

Data Profiling: Informatica Data Explorer

Data Integration: Informatica PowerConnect for R/3, Data Services, WebMethods

Big Data: Hadoop, Hive, Impala, Pig, Spark, HBase, Cassandra, Apache Nifi, Google

BI Tools: Business Objects, OBIEE, Cognos, SAP BI

Visualization: Tableau, QlikSense

RDBMS: Oracle, Exadata, Netezza, Teradata, DB2, SQL Server

Enterprise solution: SAP R/3, i2 SRM/SCM suite

Languages: Java, ABAP, CA- Open Road, PLSQL, SQL

Scripts: Perl, Python, Shell scripts, BTEQ, MLOAD, Fastload, Fast Export, java script

Tools: PVCS, Mercury Quality Center, Microsoft Office suite, Visio, MS Project

OS: Windows NT/2000/XP, HP-UX, Sun Solaris, UNIX/LINUX

PROFESSIONAL EXPERIENCE:

Confidential

Dev Manager/Data Quality Lead/Data Architect

Responsibilities:

• Manage Team of Onsite/Off shore resource for delivery of Dev components for different sprints/cut over phases
• Worked with project and application teams to ensure that they understand and fully comply with data quality standards, architectural guidelines and designs
• Take requirements, Design and Develop Data Quality Reports and Dashboards to reconcile data between JDE and SAP-ECC for master data objects - Customer, Material and Vendor.
• Cleanse and Enrich Postal code and address data using Address doctor in IDQ for Customer and Vendor master objects.
• Profile data from source JDE tables and SAP to identify transformation rules. Data cleansing requirements, constructed source file etc.
• Design and Develop DQ reports for AP/AR/GL, Inventory/Warehouse managements, Open Sales orders etc. between JDE/SAP, all such transactional data objects
• Design and Develop, Overall DQ Readiness reports for all the Master Data Objects-Customer/Vendor and Material
• Data Model the Interim table structures and views to performance tune the tableau reports and transformation logic for ETL and IDQ.

Technical Environment: UNIX, Informatica, IDQ, SAP, Tableau, Oracle, JDE

Manager/Information Architect

Confidential, Atlanta, GA

Responsibilities:

• Collaborated with Data Architect and Business Stake holders to design and implement the Campaign Performance Datamart & Marketing Campaign Management Datamart
• Worked with client to manage expectations and milestones of various sprints of Agile BI Methodology
• Designed time-variant models that support both point-in-time (historical) and current state analysis

Technical Environment: UNIX, Teradata, Informatica, SAS, Tableau, Tibco MDM,Erwin

Confidential, Marietta, GA

Data Architect, ETL Architect, Defect Manager

Responsibilities:

• Owned and managed all changes to the data models. Created data models, solution designs and data architecture documentation for complex information systems.
• Worked with project and application teams to ensure that they understand and fully comply with data quality standards, architectural guidelines and designs
• Designed & Implemented EDW & Reporting solution for Confidential Auto Parts, NOL and Pulse system
• Designed & Implemented Data integration, Conversion and Migration from TamsII to RPM POS system.
• Worked closely with business owner, systems architect and director of architecture and end users to develop the requirements and design of the conversion process and define success criteria.
• Implemented data cleansing before data loading and defined rules for data quality.
• Designed a Data Architecture for a Data Scorecard solution which gives a true picture of the converted data.

Technical Environment: UNIX, Oracle. Exadata, Informatica, Cognos, QlikSense, Erwin

Confidential, Atlanta, GA

Data Integration Architect/Data Architect

Responsibilities:

• Worked with project and application teams to ensure that they understand and fully comply with data quality standards, architectural guidelines and designs
• Designed Datamodel & Data integration solution for Confidential ’s Cell Tower/Networking operations Data Governance initiative
• Designed Canned reports & Dashboards for data quality metrics in Tableau
• Lead efforts to design, implement and refine data management solutions
• Worked closely with business owner, systems architect and director of architecture and end users to develop the requirements and design Data Quality data mart

Technical Environment: UNIX, Oracle, DataServices 4, Tableau, SAP Business Objects

Information Architect

Confidential, Atlanta, GA

Responsibilities:

• Created a POC for Confidential to analyze promotions and customer behavior using Sales Data from POS logs.
• Created a POC for Confidential using Splunk to analyze what catalogs to carry in their inventory based on customer searchers on Confidential online

Technical Environment: Splunk

Confidential, Chicago, IL

Responsibilities:

• Created a POC for Hyatt Hotel’s. to do text analytics on competitor data files using SPSS to enrich the existing information to help make educated decision

Technical Environment: Hadoop, Cloudera, IBM SPSS

Confidential, Marietta, GA

Responsibilities:

• Created POC to extract Call Center Records and do call center segmentation

Technical Environment: Google Cloud Dataflow, Big Query, Tableau

Senior Specialist BI/DW

Confidential, Atlanta, GA

Responsibilities:

• Defined metrics and user stories for custom and Ad-hoc reporting from different State Government Agencies like Confidential, DOE, DECAL, USG, TCSG, and PSC
• Gathered business requirements, working closely with business users, project leaders and developers. Analyzed the business requirements and designed conceptual and logical data models.
• Enforced naming standards and data dictionary for data models.
• Designed transformation in Informatica IDQ to cleanse and standardize data coming from various sources
• Documented the key business rules related to MDM to uniquely identify various dimensions such as Student, Teacher, and Institution etc.
• Assessed & Developed current state and future state of BI landscape.
• Recommend short term and long-term BI initiative/goals

Technical Environment SAP DS, SAP BO, SAP BW, SAP HANA and Netezza

Confidential, Irvine, CA

ETL Architect, Tech Lead

Responsibilities:

• Designed and Implemented ETL processes and strategy
• Gathered business requirements, working closely with business users, project leaders and developers. Analyzed the business requirements and designed conceptual and logical data models.
• Enforced naming standards and data dictionary for data models.
• Lead a team Onsite and Offshore to develop Integration, Interim and Aggregation schema’s

Technical Environment Oracle, UNIX, Informatica, Cognos, Tidal

Confidential

ETL/BI Technical Lead

Responsibilities:

• Designed and Developed ETL processes using Data Integrator to integrate data between SAP R/3 with DataVantage Point of Sales system (Outbound) and Audit balancing sub system (Inbound)
• Designed and architect interfaces around XML file exchanges between Commerce Hub and Web Commerce and PFS Web
• Designed & Developed audit balancing process & scorecard to detect fraud in retail transactions
• Designed & Developed inbound inventory reconciliation interface between POS and SAP R/3

Technical Environment: DataIntegrator, Business Objects, SAP, PLSQL, FogBugs, TIDAL, XML