SUMMARY:

• A data analytics champion and senior BI/data architect with excellent reputation, overall 20 + years of diverse experience: 11 + years of reputed Confidential consulting experience, 8 + years of retail, 4+ years of telecom, 4 + years of Higher - Ed, 3 + years of Healthcare, and 1 year of Financial Services/ Investment Banking industry experience.
• Created significant value for businesses with numerous full life-cycle implementations and by delivering enterprise class systems with focus on Enterprise Data Warehouse, Business Intelligence and Reporting, Data Architecture and Integration.
• Experienced in technical architecture of enterprise data and BI delivery platforms including ETL strategy, BI Delivery Strategy, repository design—governance and MDM, enterprise data warehouse, data mart, changed data capture (CDC), date transformation, data and metadata internationalization, multiple currency solutions, versioning and SCD. Well versed in Inmon vs. Kimball, Confidential foundation vs. dimensional architecture.
• A MicroStrategy Certified Engineer (MCE) and a MicroStrategy expert with 14+ years of software experience as a MicroStrategy architect building and delivering sophisticated analytics and BI applications across various industries.
• Highly analytical with a “big picture” vision, possess the ability to work with key decision makers to convert complex requirements into actionable project plans and deliverables
• A hands-on technology leader keen on forging partnership with business users at all levels in order to understand issues and challenges in their day-to-day operations and deliver repeatable BI solutions to solve business problems.
• Have delivered numerous successful large-scale BI and Data Warehousing projects which also included leading engagement teams with offshore developers and working with software vendors.
• Have advised clients in government and public sector, healthcare, manufacturing, Higher-Ed, retail, financial services, media, telecom and energy industries as I have architected, delivered managed, evaluated, implemented, and supported world-class strategic/commercial Enterprise BI applications.
• Team management/leadership, Project Management
• Inmon vs. Kimball, Confidential vs. Dimensional Data Architecture, Enterprise Data Warehouse Design
• Data Integration and Migration
• Data Governance and Master Data Management (MDM)
• Logical and Physical Data Modeling, Data Dictionary Management Tools
• Visualization, Cubes, Dynamic Dashboards,
• BI Strategy, Roadmap, BI Architecture and Solution Design
• Retail Store Operations analytics and reporting,
• Applications Development
• Supply Chain, WMS, Ecommerce, Customer Data Integration, Sales and Inventory Analytics
• Forecasting and Planning Applications
• Strategy, Planning & Development
• Process Modeling & Data Flow
• Lead multi-site/off-shore, large scale projects
• MicroStrategy schema design for Hadoop and Hive

EXPERTISE IN:

• Manufacturing/ CPG
• Teradata Retail Data Warehousing
• Media and Telecommunications
• Real - time Higher-Ed BI
• Government and Public Sector
• Plant Operations Management/ Forecasting Analytics
• Healthcare BI Analytics
• HR Analytics
• Retail Analytics
• Product Life-Cycle Management
• Financial Services Analytics
• Customer Churn Analytics
• Merchandise Planning Analytics
• Store Operations Analytics
• Student and Admissions Analytics

TECHNICAL SKILLS:

• MicroStrategy 8, 9, 10, Analytics
• Big Data, Hadoop, Hive
• Essbase
• SAS 9
• Oracle, PL/SQL
• DB2 UDB and Z/OS
• Teradata
• SQL Server (T-SQL/SSAS/SSIS)
• JDA, SAP BIW
• Netezza
• Kognitio
• DataStage
• XML, XSD, JSON
• Erwin 9.7 Model Mart, Web Portal
• Unix (AIX/HP-UX/Sun-Solaris)
• Red Hat 5.4/5.5 Linux
• Windows Server 2003, 2008 R2
• IIS, Tomcat/ Apache, WebSphere
• Excel/ Access VBA
• Visio/Microsoft Project
• PowerPivot, PowerQuery, PowerBI

CHRONOLOGICAL SUMMARY OF EXPERIENCE:

Confidential, Union, NJ

Senior Data Architect

Responsibilities:

• Currently serve as Enterprise Data Architect as I lead a group of onsite and offshore data architects, modelers, and analysts.
• Responsible for designing, architecting and maintaining data structures, perform data profiling and design ETL logic and mapping for Enterprise Foundation Layer (EFL) and Enterprise Reporting Layer (ERL). EFL and ERL consist of 2000+ and 800+ data structures (tables and several thousands of access layer views), respectively.
• Serve as the Subject Matter Expert on Teradata Retail Data Model (TRDM) and Corporate Data Steward.
• Data Subject matter expertise encompasses Supply Chain, Warehouse Management System, E-Commerce, Vendor, Customer, Carrier, Container (Carton), Shipping, Purchase Order, Invoice, Product, Sales, Inventory, Claim and Resolution, Transportation Management, Vendor Direct to Customers, Freight Audit Payments, Gift Registry, Location, Fiscal and Gregorian Calendars.
• Reverse engineer existing physical models into a logical representation, forward engineer new models.
• Lead definition, communication and governance of the data modeling standards, data governance standards, co-ordinate definition, manage storage and stewardship. Serve as a member of the data governance team and closely work with MDM architects to maintain corporate master data. Help in establishing continuous data quality improvement programs focused on the authoritative source(s) of data assets. Assist in ensuring the consistency, accuracy and reliability of critical data assets working closely with business colleagues at an enterprise level who identify and remediate DQ issues. Provide data analysis and profiling support to the MicroStrategy BI, data analytics and data science team.
• Provide analysis support and recommend solutions of the data access requirements. Conduct cross functional model reviews with project team members. Participate in data architecture sessions and promote integrated systems and controlled data redundancy.
• Manage projects, end-to-end, using Agile software development methodology. Manage relationships and partnering with the business category leads on overall project management
• Responsible for delivering and maintaining corporate data models in Erwin Model Mart Server and Erwin Web Portal and corporate data dictionaries in MicroStrategy Analytics Desktop, MicroStrategy Enterprise Platform and Real-time updatable Excel Workbooks.
• Work closely with BI and MicroStrategy team to define configure datasets from big data sources using MicroStrategy Connector for Hadoop and Hive. Serve as advisor for MicroStrategy schema architecture and BI Environment tuning (VLDB Properties) due to significant MicroStrategy Architect expertise.

Confidential, Overland Park, KS

Founder and Managing Director

Responsibilities:

• RS provides a broad, deep spectrum of technology services to help organizations translate their strategic business goals into IT initiatives and solutions that measurably improve performance.
• We turn large volume of data to actionable information quickly and economically.
• We are experts in MicroStrategy implementations (Architecture, Administration and Development) enabling our clients to realize their vision into actionable information.
• We are currently focusing on developing industry-specific analytics data models, drawing inspiration from Confidential ’s school of data modeling.
• These models will enable our clients to implement a turn-key BI solution fronting on MicroStrategy to implement Analytics that deliver business value.
• The industry specific analytics dimensional models that I have developed are:
• My charter was to develop a foundation layer for the enterprise data warehouse in Teradata ( Confidential ).
• The Confidential feeds data to BI reporting layer in Kognitio (Dimensional modeling, optimized for MicroStrategy high-performance BI).
• When these new BI models implemented, this new data architecture enabled Confidential executives and merchants/vendors to fully harness the power of MicroStrategy reporting on Kognitio in order to get near-real time analytics on Supply Chain, Ecommerce, Vendor, Sales and Inventory Analytics.
• Evaluated existing MicroStrategy architecture model as per requirements and recommended changes and enhancements; Assisted in implementing architecture design for existing and future Citibank reporting needs. Advised client developers on best practices of design and developing reports, documents and interactive visualization dashboards as per KPI’s requirements.

Confidential, Vienna, Virginia

Senior Consultant / Technical Lead

Responsibilities:

• Partnered with clients to identify key business intelligence needs in the organization to develop BI roadmap and make recommendations for MicroStrategy BI platform
• Led customer services engagements and services delivery, which included: consistent delivery of BI, subject matter expertise, project management
• Performed information systems needs assessment, information gathering, and recommend appropriate business systems and IT infrastructure for MicroStrategy customers
• Performed capacity planning, prototyping, stress and load testing, hardware sizing, data modeling, application development, technical product assistance and tuning to meet customer performance and functional requirements
• Provided ongoing production consulting implementation support. Offer expertise on data modeling, warehouse specification, application building, and technical product assistance and tuning of warehouse, application and deployment support.
• Specified business systems (inputs, outputs, data, human and automated interfaces) to meet information processing objectives for MicroStrategy’s proprietary software products
• Examined MicroStrategy’s proprietary software products for their compliance with functional specifications

Confidential, Kansas City, Missouri

Lead Data Warehouse Architect

Responsibilities:

• Responsibility included strategic development, maintenance and support integration of enterprise data warehouse system and corresponding data marts that aligned with corporate standards and organizational business requirements.
• Advised and recommended best practice data architecture, maintenance, and process to create an enterprise data repository assuring the integrity, quality and timeliness of data stores.
• Ensured that best practices were followed for the acquisition, development, maintenance, support, and testing for ETL processes using XML structures. Scheduled, monitored and validated load processes for disparate data sources and formats.
• Informed all parties accessing the data warehouse of changes in structure, data, and load frequency on a timely basis.
• Developed or validated the creation and maintenance of data definitions and metadata.
• Supported reporting managers aligned with data architecture, business needs, and strategies. Monitored usage of the data warehouse to identify potential capacity overloads.
• Planned, assembled and facilitated requirements-gathering sessions to support the process for end-user development.
• Assembled complete project plans and monitored project status to ensure project deadlines are met.
• Worked with outside consulting staff to ensure understanding of requirements and meeting of project deadlines.
• Developed requirements for potential new product POC’s and lead the POC process and sessions to ensure the most effective solutions for the business are selected.

Confidential, Atlanta, Georgia

Managing Consultant and Senior Consultant

Responsibilities:

• Worked extensively with the business user community of several universities and management including CIO and directors, to gather requirements for universities’ operational and DSS reporting solutions and to build their respective data warehouses in Oracle.
• Experience included interfacing with the business users and holding JAD sessions with the Chancellor’s Office, Office of Institutional Research (OIR), Office of Academic records and Admissions, Financial Aid, Billings and Receivables, Finance and Accounting, and Human Resources offices of University of Alabama (UA), University of Alabama at Birmingham (UAB), and University of Alabama in Huntsville (UAH).
• Coordinated and led requirement gathering sessions with clients from these three campuses to complete data mapping effort to reverse engineer over 9,000 data elements from a legacy source system to an Oracle 9i enterprise data warehouse model in Erwin.
• Led implementation efforts that involved working with 3 different universities’ Institutional Research departments to develop views, and stored procedures to implement an executive reporting solution that would enable querying data from 3 disparate oracle data warehouses for analytical reporting via database links.
• Led development efforts of 135 BI reports and provided mentoring and class training sessions to power users on Crystal Reports, and Crystal Enterprise. Published and maintained BI reports on the web. Provided leadership in gathering, analyzing and documenting business requirements, interviewing business users and implementing solutions.
• Created mapping documents detailing the data element definitions used in the legacy SCT Plus Student, Finance and HR systems and EDW data models and their associated mappings. The users would use these documents to suggest the most appropriate wording to describe each data element.
• Worked with IT staff to install and configure hardware and software.
• Assisted team members in building a prototype for end-to-end testing which included capturing changes at real - time (Change Data Capture using Striva and Ascential DataStage), retrieving data into data warehouse.
• Was responsible for maintaining Engagement Permanent file, and Work-In-Progress file, project financial information, and project plan.
• Was responsible for providing weekly status updates to client on the status of the projects.

Confidential, Kansas City, Missouri

Program Manager

Responsibilities:

• Analyzed existing processes and procedures in financial reporting by interviewing internal customers and implemented changes through enhancements in reporting tools and automation of manual processes
• Developed activity plan, supporting documents such as data flow diagrams and methods and procedures (M&Ps) and provided leadership in developing database and desktop applications
• Researched and analyzed financial data on Confidential ’s products and services residing in various data warehouses and consult end internal customers with software and data knowledge
• Created metadata, architected (DSS Architect) and administered (Object Manager) MicroStrategy Business Intelligence projects and develop MSI canned reports (DSS Agent). Performed monthly maintenance (expiring cache, changing filters, etc.) in DSS Web.
• Converted MicroStrategy 6 Projects to MicroStrategy 7. Modified existing reports and built new reports in Agent 7. Published and maintained MicroStrategy reports on the web.
• Provided on-going support to internal Confidential Customers’ ad-hoc and recurring financial reporting needs by Interviewing and gathering requirements via JAD sessions from business users and upper management, and developing reports from sources such as mainframe and relational databases

Confidential, Overland Park, Kansas

Applications Developer

Responsibilities:

• Partnered with business users and executive management to gather requirements, and conduct JAD sessions to implement data warehouse and reporting solutions
• Developed monthly ETL processes for a data warehouse that hosted international data and voice product revenue-related data. Created metadata shell, architected project in MicroStrategy 6 Architect and built reports in Agent 6.
• Developed warehouse schema using star multi-dimensional modeling method
• Provided ad-hoc and monthly reporting support from Confidential ’s revenue data warehouses
• Consulted customers with data knowledge on Confidential ’s data, voice and private line products
• Provided leadership and consulting to LDI Finance Information Management team in transitioning responsibilities associated with GIM data warehouse and monthly mainframe-based reports
• Assisted client to research possible data sources, organized meetings and provided ad-hoc reporting support for Dedicated Access Warehouse (DAW) Project
• Developed an in-house integrated application using Access VBA, which currently supports resource-pool trend analysis and forecasting for the Confidential Business Finance Sales Support group. Provided regular maintenance and user training

Confidential, Overland Park, Kansas

Analyst, Service Reporting

Responsibilities:

• Developed individualized “Scorecards” using MS Excel and Access VBA to support measurement of key statistics such as average handle time, wrap time, talk time, calls handled, breaks, exceptions, efficiency and productivity of 1200 sales agents, team leads, LOB managers, and a Call Center
• Supported ongoing reporting and analysis of “Reason Codes” underlying customer service calls for three Call Centers by administering Decision Support Systems (Oracle Discoverer, Impromptu)
• Developed and maintained an Access database that served as a central database and housed employee information at all levels and tracked sales agent movements in a Call Center
• Developed 50+ Excel macros to automate daily reporting processes. Reduced formatting time by 70%
• Developed report auditing schedules and performed weekly and monthly audit
• Worked with DBA and data architect to develop a logical data model for the “Reason Code Tracker” database in Oracle
• Led and coordinated assigned projects with users, IT department, peers, and external vendors
• Developed documentation and training processes to support end-users

Confidential, Overland Park, Kansas

Contractor

Responsibilities:

• Developed a visual basic script in Excel with embedded SQL to query the Witness Call Monitoring system in Sybase, which automated data collection required for weekly and monthly reporting. This eliminated the need for printing the individualized performance reports of customer service agents and manually keying the data in Excel
• Provided weekly and monthly reporting solutions to support the analysis of various reasons for customer service calls
• Calculated optimal sample size to ensure effective analysis of performance of agents on customer service calls based on a predetermined 25-element criteria and assisted colleagues in rating recorded customer service calls