CAREER SUMMARY

Certified BI Professional MBA Architect with passion for all things reporting and analytics. Worked in some of the biggest Data warehouse, Analytics and Business Intelligence environments. Projects have included Financial, Risk, Predictive, Operational, and repair solutions. Strategy and hands on development in reporting, ETL, analytics and all aspects of requirements. Partnering with business and aligning IT deliverables with the needs of business teams. Evaluation of current and emerging technologies, policy and architectural direction on BI, Visualization and Analytical subjects. Leading and coordinating solution designs related to platforms, environments, reports, data governance, data quality, MDM, hadoop optimization, hadoop sizing, Big Data strategy, hadoop based operational reporting system, deep analytics environment and archive and storage system. Expertise in BI platforms, Data warehouse, Visualization tools.  Strengths include consensus building, aligning IT deliverables with business needs, accelerating data discovery for end users, business intelligence reports (dashboards, OLAP and formatted reports), operational reports, data warehouse source to target maps, GAP analysis, documentation and functional testing. Familiar with all phases of SDLC, Agile, SCRUM, RUP and CMMI Level 4 delivery.

PRICEWATERHOUSE COOPERS LLP, Chicago, IL                                  2015–2017

             Senior Manager (Solutions Architect) – Full Time

Member of US Transformation Office Data & Analytics Delivery team. Innovative Data Visualization and Analytics tools delivery. Data Science team support, Predictive Analytics, Data Services warehouse and analytics strategy for Data Analytics and Delivery Services team.  Drove solutions for Data Discovery, Competitive advantage, Visualizations, Data Preparation and Data Science projects. 

·         Innovative technology platform direction for IT services, BI COE and external vendors

·         Azure Cloud based Data Hub creation and design using HBASE / Hadoop (Hortonworks/ Azure HD Insights) Data dictionary and governance rules established. Azure Cloud based SQL servers

·         Implemented new Analytics work bench solutions for desktop users -engagements, departments and whole enterprise. Coordinating Analytics tools choices and prescriptive training program to meet the needs of the organization related to Business Intelligence and Visual Analytics – Tableau, Qlikview, Alteryx and SAS servers.

Encode, Inc                                                Somers, NY                                          2015-2016

 Big Data Analytics Solutions Architect – Contract Position

Search engine optimization and Data warehouse strategy for Digital Intelligence and Source Control. Guidance on design, sizing, construction and training.  Digital Marketing, Click path analysis and Shopping cart conversion. Reporting, Visualization & Analytics. Working with Digital marketing and analytics teams.

n  Creation Analytics and Infrastructure strategy and roadmap (Tableau, COGNOS and Neteeza)

n  Guiding principles on IBM Big Insights and HDFS Application Solution design, Data Management, Content Management, Visual Analytics, Data Analytics and COGNITIVE Analytics. (IBM Watson products)

n  Guide strategy on Analytics environments, infrastructure and tools.

TCS                                                        Alpharetta, GA                                          2014-2015

 Big Data Analytics Solutions Architect - TCS

Application and Big Data Infrastructure and Technical Architectural guidance on sizing, construction and design of Predictive and Descriptive Analytics environment solutions for Reporting, Visualization & Analytics. Involved with all Predictive, Prescriptive, Descriptive and Streaming Analytics solutions. Working with global data centers on extending Data Warehouses using Logical Data Warehouse concepts using Hadoop, Traditional RDBMS and In-Memory Data Warehouse appliances.

n  Coordinating Global Analytics deliverables for international consulting firm.

n  Guiding principles on Application Solution design, Data Management, Mobile delivery, Content Management, Visual Analytics, Data Analytics, Forecasting and Risk Analytics.

n  Guide strategy on Analytics environments, infrastructure and tools. (Tableau, Lavastorm and SPSS Modeler)

RCG                                                        Deerfield, IL                                                     2014

 ESS Solutions Architect - Contract Position - RCG

Infrastructure and Technical Architectural guidance on sizing, construction and design of Reporting and Analytics Environment Solutions for Reporting, Visualization & Analytics. Involved with all Infrastructure, Integration, Information, User Interface and BI Architectures issues. Working with Logical Data Warehouse concepts using Hadoop, Traditional RDBMS and In-Memory Data Warehouse appliances.

n  Working with HDP 2.1, Netezza , Teradata, Oracle Exadata and DB2 BLU

n  Guiding principles on Visualization environment construction

n  Guided Documentation of all Data Flows related to systems and Data Marts.

Allstate Insurance Corporation          Northbrook, IL                                          2012- 2014

 Big Data / Analytics Information Architect

Architectural guidance on sizing, construction and design of Big Data Reporting and Analytics Environment Solutions for Reporting, Visualization & Analytics. Education of users of Big Data concepts. Application design, development and infrastructure where it is related to reporting platform and deep analytics ecosystem. Involved with all Integration, Information, User Interface and BI Architectures issues. Creating strategy for Data Lake, Hadoop Archive and Storage, Data Integration Hub in Hadoop. Involved with all aspects of Data Warehouse construction and design.

n  Evaluation of Hadoop 2 distributions and conversion to Cloudera CDH4.5

n  Big Data solutions with unstructured, sensor data and sentiment analysis (IoT telematics data)

n  Improved performance on Dashboard reporting using Xcelcius 200%

n  Claims, Risk, Fraud, Pricing and Sales oriented reporting solutions.

n  Aided in selection of Data Profiling and Quality Tools. (Informatica, IBM Infosphere and Datameer)

n  Lead BI and Visualization steering committee.

            Volkswagen Credit Corporation          Libertyville, IL                                          2011-2012

            Sr. Business Intelligence Analyst – Contract Position – I-A Consulting

Managed Reporting and Data Warehouse Requirements Documentation for New Data             Warehouse.  

n  Project: Dashboard reports (Data Requirements, Functional Requirements, Conceptual design)

n  Project: WebFocus report ( GAP Analysis, Data Requirements for reports, Validating reports, New tables and Views) ( 32 reports validated with CFO /Controlling group/Accounting team)(350 stories written)

n  Project: Dialer Data (New reports, New Tables, Estimation of Effort)   (7 stories written)

n  Data Profiling using Dataflux.

n  Agile requirements for reports and Assets, Payments, Delinquency Topics and System requirements.

n  Managed conversion of reports from WebFocus to Business Objects or Qlikview

n  Created Acceptance Criteria, Tasks for Development Teams and Estimations for current and future projects.

            Kohl Corporation                      Menomonee Falls, WI                                                       2011

           Business Analyst – Contract Position – Apex Systems

           Managed Business Requirements for Trillium Data Quality tool.   

n  Worked with Marketing Analysts on Data Quality and Standardization of the Data Warehouse    data.      

n  Gathering requirements, documenting customer needs and aiding in profiling of the data.

n  Documented Business Rules, Functional and Non-Functional requirements in Caliber tool.

n  Created test cases and test plan for data quality tool and process in HP Quality Center

             RBS Citizens Bank Corporation          Cranston, RI                                                       2010

            Lead Business Analyst – Contract Position – Talentburst

n  Managed Business Requirements for New Commercial Loan Origination System .    

n  Member of the CL Replacement Project team.  Gathering requirements, Documenting customer needs and Rationalizing reports to the new loan system. (AFSVision from Focus based reports)

n  Aided in new design of new data model to accommodate new source system.

n  Worked with the ETL team to develop new ETL scripts in Data Stage.

             Eaton Corporation                              Cleveland, OH                                                      2010

            Project Manager – Contract Position – Kforce

Managed small and medium scale report development projects.

Project: Update Supplier Quality Reporting System

3 Resources (ETL SME, Report Developer, Kalido SME)   

Informatica,TIBCO, COGNOS and custom Applications were the systems of record.

n  Lead Data, BI and Integrations efforts.  Gathering requirements, Documenting customer needs and Developing reports out of a data warehouse. (Converted 5 reports 3 new reports)

n  Designed new Kalido structures to accommodate source system data.

n  Developed new ETL scripts in Informatica to populate tables in the data warehouse. Khallix based applications were used for some of the financial data.

n  Project: Treasury Securities - Sungard Treasury Application Upgrade

·         ( Scope of effort. Wireframe of Solution created)

            Wells Fargo Bank                            San Francisco, CA                                                   2009

           Lead Business Analyst – Contract Position – Kforce

Managed Business Requirements for Commercial Loan System.    

Member of the Commercial Tools team.  Gathering requirements, Documenting customer needs and Rationalizing reports to the new loan system.

Worked with the SQL Server Developer to develop new ETL scripts in SSIS.

             State of Utah                                           Kearns, UT                                                      2009

           Crystal Reports Developer – Contract Position – Smith Johnson

            Report Development for the Department of Licensing Division.    

n              Developed 13 new reports. 

n              Upgraded the report server - platform to Business Objects Xi.

            MarketStar                                            Ogden, UT                                                       2008-2009

          Project Manager/BI Analyst – Contract Position – Robert Half Technologies

Managed Data Management and Reporting Platform for an enterprise project.    

Managed all phases on the creation of a new Data Warehouse.  (Scope, Plan, Implementation, Testing)

Guided Data Integration effort using Kalido software, MS SQL Server 2005 and custom applications.

Managed output of OLAP cubes, new reports and clean up of existing reports.

Project: Reporting Solution

Evaluated BI solutions from vendors (Microstrategy, Talend, Qlikview and Business Objects)

Including comparison matrix. Vendor for selection process

n               Designed reports and OLAP solution to satisfy requirements

             Southwest Airlines                                 Dallas, TX                                                           2008

           Project Manager/BI Analyst – Contract Position – RCG Technologies

Managed reports portion of an enterprise project.  (International Code Sharing) 

Worked with team of Crystal Reports and Business Objects developers on the modification of all reports.

Coordinated effort with new application development and Data warehouse team. Oracle, Golden gate and Toad were used for data analysis.

             eBay                                         San Jose, CA/Draper, UT                                     2007-2008

           Staff Analyst

Member of Customer Insights team for the 10 Petabyte Teradata data warehouse team. Roles in      project management, business and systems analysis and QC.  Performed GAP analysis and prepared functional documentation.  Managed large scale report development projects.

Coordinated a global effort between Customer Service management around the world.

n  Lead requirements gathering, JAD sessions. (Worldwide)

n  Improved accuracy of data and automated reporting for contact management and customer satisfaction surveys.  Reduced expenses and decreased time to retrieve data.

n  Integrated SalesForce.com, Blue Monkey and Phone Data(Avaya/Aspect) into Data warehouse.  Facilitated communication with telecommunication group and end users.  Eliminated changes in presentation of data.  Ireland, German, Canadian and U.S customers.

n  Created phone reports out of the data warehouse and, improved use of data for trending, analysis, and forecasting.   Source of the data was an enormous Teradata data warehouse. Micro Strategy based solutions. Queryman and SQL assistant were used for queries.

          Boeing Finance IT                                 Long Beach, CA                                           2006-2007

         Project Manager/Functional Analyst – Contract Position – Kforce

          Managed small and medium scale report development projects.    

n  Analyzed current usage of applications, developed recommendations and advised business users on possible enhancements or changes.  Queries using Toad and PL/SQL in an Oracle based data warehouse. Sources included khallix Longview, Peoplesoft HR and EPM Finance modules.

n  Designed, documented and created COGNOS ReportNet and PowerPlay cube reporting solutions. Reduced reports from 1200 to 150 through rationalization and standardization.

n  Reduced time for monthly close process from over five days to three days through improved data warehouse delivery of transactional data.

Reporting Tools: Platforms- SAP/Business Objects, IBM-COGNOS, Micro Strategy, Information Builders, WebFocus and SAS

Reports: Crystal Reports, COGNOS ReportNet, BOBJ Webi / Deski

Dashboards: Excelcius (SAP Dashboard), Tableau, Qlikview, TIBCO Spotfire

Predictive reports: SPSS Modeler Premium and SAS Base

(Analysis of BRIO, Datameer, Hyperion Financial, FOCUS and WebFocus reports)

Analytic Tools:  R Studio, Pentaho (WEKA), SAS, RapidMiner, SPSS Modeler, IBM Watson Data Explorer, Matlab, ANOVA, MS Analysis Services

Data Quality /Data Profiling

Trillium TS Insight, TS Discovery, TS Quality, Dataflux (SAS), DQXi, IBM Quality Stage, Melissa Data, QAS (Experian), Microsoft SSIS / Data Quality Services, Spectrum (Pitney Bowes) and Informatica Power Center, Rules Point and IDQ, Iniate, SAS Data Management

Data Warehouse:  Kimball, Inman, Federated and Logical

    RDBMS:  Oracle, Teradata, Informix, EPM (PeopleSoft), MS SQL Server 2005-14

    SQL Tools:  SQL Server Management, RapidSQL, TOAD, SQL Assistant, Queryman

    ETL Applications: DataStage, Informatica, Talend, Ab Initio and SSIS

    Data Preparation: Alteryx, Actian, Birst, Datameer, Trifacta

    Modeling Tools:  Erwin, Enterprise Architect, MS Visio and Embarcadero

Big Data: Data Integration Hub, Deep Analytics Environment, Archive Storage and Data Lake

   NoSQL: HBASE, Couchbase, Cassandra, PostgresSQL SOLR and Mongo DB

   Hadoop Distributions: Cloudera, HortonWorks, Azure (HD Insight), IBM Big Insight and MAPR

   Hadoop Tools: SparkStreaming, SQOOP, Datameer, Informatica, HDFS, PIG and HIVE

Compliance:  HIPAA, HITECH, GLBA, SOx, FCRA, OFAC, Security/Privacy – PHI, PCI, PII

SFA Systems: Siebel, Salesforce.com, SalesLogix, Goldmine, Telemagic, ACT

Other Systems: HP Service Manager, Peregrine, ServiceNow, PureShare, HP Quality Center, Longview's Khallix Budgeting & Forecasting products, FiServ

Finance Systems: Oracle Financials, EPM (Peoplesoft), Hyperion, MAS 90, MAS 500 and SunGard (Analysis only)

Cloud Technologies: Google Cloud Platform, Microsoft Azure, AWS (Redshift and S3)

IIBA – INTERNATIONAL INSTITUTE OF BUSINESS ANALYSTS

TDWI – THE DATA WAREHOUSE INSTITUTE (CBIP)

The Data Warehouse Institute, CBIP – Business Analytics, 2009

CHUG – Chicago Hadoop Users Group

IUG – Informatica Users Group (Chicago Chapter)