SUMMARY:

• Highly accomplished, results - driven Technology Executive with over 17 years of experience in various industries, including Big 4 Consulting, Banking, Insurance, Air lines and Financial Services, with specific expertise in Data Strategy, Analytics and Innovation. Over 7 years of proven success within the Big Data, IoT and Analytics space.
• Experience in managing all aspects of Data Management in the Big Data environment including sourcing, ETL, data modeling, normalization and OLAP/BI reporting.
• Providing analytics that power business decisions, with end-to-end solutions and services in data warehousing, big data and analytics to become a data-driven business.
• Proven achiever who is committed to aligning technology and business to generate cost-effective solutions and deliver multiple, mission-critical, multimillion-dollar projects on time and within budget.
• Expert in understanding the data and designing/Implementing the enterprise platforms like Hadoop Data lake and Huge Data warehouses.
• Have over 2+ years of experience as Hadoop Architect with very good exposure to Hadoop technologies like HDFS, Map Reduce, Hive, Hbase, Sqoop, HCatalog, Pig, Zoo Keeper.
• 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 + Conversion with ETL tools + Performance tuning.
• A Senior SQL Server performance tuning expert with practical experience from midsized databases to very large databases.
• Hands on experience with SQL 2000/2005/2008/ R2/2012 including T-SQL programming, DTS, Performance tuning, Reporting, designing logical/physical databases and Troubleshooting.
• Expert in SQL Server OLAP database development including KPIs, Data mining, working with changing dimensions.
• Broad understanding of Data Warehousing and Business Intelligence Solutions; can use various software programs such as Oracle, DB2, Micro Strategy, Informatica, SQL Server Integration Services (SSIS) to process data, access different system resources, and in corporate T-SQL statements.
• Specialized knowledge in evaluation and implementation of large-scale, automated reporting systems and tools driving efficiency throughout the organizations.

KEY DATA ANALYTICS AND ENGINEERING PROFICIENCIES:

• Data Engineering | Data Strategy | Data Governance | Program Management
• Scorecards, Dashboards, KPIs, and Reporting
• Data Visualization Tools (Qlikview, Microstrategy)
• Statistical Modeling/SAS|Forecasting
• Retail Banking and Credit Card Data Data Warehousing, Analytics and Wallet Share Reporting
• Data Analysis (Profiling, Munging, Cleansing, and Mapping)
• Big Data (Hadoop, Hive, Hue)
• Advanced SQL (HiveQL, PostgreSQL, Teradata SQL, SOQL)
• Scripting (Bash, Qlikview)
• Data Warehouse (HDFS, Greenplum, Teradata, Oracle)
• Relational Database Design
• Systems Integration
• Development Processes and Methodologies
• Salesforce (Sales Cloud and Service Cloud)
• Key Strategy and Management Proficiencies:
• Product Strategy and Development
• Business Analysis and Design
• Strategic Planning and Executive Presentations
• Alternative Solution, Cost/Benefit Evaluation
• Business Process Improvement
• Workflow Analysis/Process Reengineering
• Business Intelligence, Business Analytics and Optimization
• Talent Acquisition, Development, and Management
• Program Management and Roadmap Planning
• Organizational Transformation and Change Management
• Streamlining Teams and Operations

TECHNOLOGIES:

Business Intelligence, Power BI, Azure, Azure Cloud Solutions, Big Data, Azure Cloud Security, Azure SQL DB, Tableau, SQL Server, SSRS, SSAS, SSIS, Tabular, Internet-of-Things (IoT), SharePoint BI, SalesForce, Azure PaaS, Azure IaaS, Azure Security, Office 365, Dynamics CRM, ER/Studio, Dynamics AX, Cloud Hosting, PowerShell, and Machine Learning

PROFESSIONAL EXPERIENCE:

Director, Data | Strategy | Analytics |Innovation

Confidential, Hoffman Estates, IL

Responsibilities:

• Deployed self-service mobile dashboard for C-Suite to monitor company performance across the enterprise including KPI’s aligned to product, staffing, financial performance and risk management.
• Manages a team of 14 Analysts, and developers supporting the In-Home Business Services Group.
• Manages the generation of reports and analytics used to drive the In-Home Business (~$2B Annually).
• Responsible for leading development and use of statistical tools to manage the Total Cost of Quality Expense for products serviced by Sears Home Service.
• Created enhanced 360 view of customer (SYW member) by extending Salesforce (accounts, contacts, leads, opportunities, activities) with external market place sources to identify high-value vendors based on relevance and engagement activity.
• Overcame reporting limitations of 3rd party contract management software (Ariba) by delivering platform to provide executive reporting, analyze risk exposure to client corporate actions and contracts with specific legal provisions or regulatory requirements.
• Reduced Business Intelligence software maintenance and licensing costs by consolidating disparate instances of SQL Server, Informatica and Business Objects.
• Created offshore development team to manage maintenance and support for portfolio of 40+ reporting applications across SHC. Project resulted in a 50% increase in staff with 6.9% increase in cost FY15.
• Significantly improved reporting, internal controls and data quality by designing and implementing enterprise system allowing global teams to manage internal allocations ($200MM+).
• Trained DW users on how to approach and utilize the massive amounts of data available in order to resolve business problems and improve performance.
• Leading firm wide effort to build and implement standardized data services for the Data Lakes and Data Reservoirs.
• Implementing a micro-services architecture combining latest advances of data management, with cutting edge application development in multi-tenant Big Data stacks with optimized metadata management.
• Developed and executed the roadmap to source, profile, prioritize, and ingest customer data across all aspects of the Sears SYW Members.
• Lead cross functional team to successfully launch and operate new digital (Mobile and Online) home services experience with virtual reality (VR) kitchen. This platform now has over 28M lives which has allowed 15% year over year growth of Sears home services.
• Re-engineered incentive services from being niche VR solution to being a service that allows service providers to tie incentive actions for their services and referral sign ups. Grew platform from 1M lives in 2013 to currently over 4.5M lives.
• Regularly presented Data analytics program/innovative plans to board of directors and Chairman.

Director, Data Warehousing & Business Intelligence

Confidential, Greater Chicago

Responsibilities:

• Established vision, strategy, roadmap and created agile process for the development of Discover Bank Dataware house projects implementation.
• Established a Data Governance framework, Council, and Established the Discover Financial BI&DW team, and managed a department consisting of 3 managers and a total of 22 staff.
• Replaced a legacy Oracle data mart with a 20TB atomic-level data warehouse using Teradata 2690 Appliance in 14 months.
• Selected and implement Tableau data visualization software and established a Tableau “center of excellence” (COE) to support organization-wide adoption of Tableau.
• Integrated Tableau dashboards into Salesforce.com experience for Sales and Account Management.
• Provided leadership and strategic direction to grow and expand the student loans business within the Discover family of products.
• Integrated Adobe (“Omniture”) web analytics data with on-premise data, and delivered Product KPI dashboards for Product Management. Upgraded Business Objects from XI to v4.1 in 4 months.
• Integrated Google/DFP ad serving data into the data warehouse for use in reporting and analytics.
• Developed and deployed a customer reporting portal with customer-level dashboards, allowing direct access to advertising metrics for Advertisers.
• Managed a cross-functional team in the “Proof of concept” (POC) evaluation of Hadoop/HDFS using the Hortonworks distribution.
• Created a “Big Data” strategy including high-level architectural approach for incorporating Hadoop capabilities within the existing data warehousing infrastructure.
• Created presentations, and presented new technologies to business owners showing how to leverage the terabyte per day of data the company acquires (Hadoop and Pig)
• Technologies include Teradata, Oracle 11g, Business Objects XI and 4.1, ER/Studio, Crystal Reports, DataStage, Tableau 7 and 8, Salesforce.com, Hortonworks (Hadoop).

Data Architect | Analytics | Data management | Reports

Confidential

Responsibilities:

• Responsible for all sourcing, data mapping, data loading, ETL, data modeling and data consumption for Analytics.
• Provide data engineering and data enablement support for the Big Data Center of Excellence.
• Actively participate in strategic discussions, providing use case support for analytical purposes.
• Work with stakeholders and Big Data Center of Excellence (CoE) counterparts to understand and deliver on business requirements for the enablement of data.
• Lead all aspects of Data Management including data loading, ETL, data validation, MIS Reporting, Business Intelligence and Analytics/OLAP solutions.
• Designed and Developed an Active Data Warehousing Solution for Confidential . Delivered entire Business Reporting and Analytics/OLAP strategy for ADP using a SaaS delivery model.
• Specialized in Operational Reporting, Business Intelligence/OLAP, real-time data replication, ETL and Enterprise Data Integration.
• Delivered state of the art, multi-tenant hosted SaaS systems in the area of Reporting and Analytics
• Acted as Data Architect and Business Architect in all reporting tools and applications used by across client services and applications/ systems.