SUMMARY

• Performance oriented and business needs focused, highly skilled senior Business Intelligence, Data Warehousing, and Analytics professional with proven track record of business/technology knowledge and commercial acumen at international operating level. Possess extensive entrepreneurial experience in diverse leadership disciplines with hands on approach.

AREAS OF EXPERTISE

• Planning & Execution
• Business Focused - Leveraging Technology and Partnering with Business in delivering Interactive Analytics and Business Insights.
• In depth end-to-end Knowledge and Hands-on Experience in DW/BI/Analytics Technologies - Meta Data Management, Master Data Management (MDM), Source Analysis, Data Quality, Data Mapping and Transformation, ETL Architecture, Designing Relational and Dimensional schemas, Self-Service BI, Dashboards, Data Security Schemes, Defining SLAs, Performance Tuning, etc.
• Leadership and Management
• Global Experience
• Management Consulting (IBM, PWC, Capgemini) - 9 years
• Development and successful implementation of multiple full system life cycle engagements/applications in Data Warehousing, Business intelligence, Analytics, MDM, and Information Governance.
• Experience in proposal preparation and providing leadership from pre-sales through final delivery.
• Incorporate Business Strategies and Develop BI and Analytical Applications to Enable Business Goals.
• Experience in Building High-Performance Collaborative Teams.
• Familiarity and some experience with Big Data Technologies from architecture perspective.

TECHNICAL SKILLS

Database Management Systems: Looker, ORACLE 9, 11i, 12, DB2, DB2/UDB, IMS, Rdb, Informix, Teradata

Application Packages: SAP BI/BW, SAP SEM 3.0, IBM InfoSphere, IBM DataStage, IBM Cognos, Crystal Reports, Crystal Enterprise, PRISM Warehouse Executive, Prism Directory Manager, ERWIN, ORACLE Data Warehouse toolkit, Business Explorer, Visio, MS-Project, MS-Office, Itron MDMS, Business Objects, Tableau, Meta Center, Duck Creek, Guidewire, MS Azure, MS SSIS, MS SSAS, MS SSRS, Looker

PROFESSIONAL EXPERIENCE

Confidential

Data Platform Architect

Responsibilities:

• Develop and maintain strategic roadmap to meet enterprise data platform vision.
• Accountable for ETL development best practices and compliance.
• Design and architect data platform to deliver a scalable model for future growth needs.
• Mentor data engineering team to support data platform.
• Engage with the business to work through existing capability matrix.
• Deliver roadmap updates to the CTO, Director, and Business Owners as needed.
• Assist with design of BI tool semantic layer

Technical Environment: Oracle, Oracle GoldenGate, Informatica, Looker, Business Objects, SAS.

Confidential

Senior IT Program Manager

Responsibilities:

• Managing projects and programs with on time, within budget delivery by leveraging cross functional project teams of 30-35 team members consisting of analysts/developers/architects/testers/project managers on-site and off-site
• Estimation of resources and participants needed to achieve project goals and objectives
• Identifying and manage project dependencies and critical path and finalize a roadmap for the delivery of new analytical capabilities.
• Facilitate meetings and get consensus amongst the stakeholders.
• Deliver presentations and program status to the management and executives at all levels.
• Contributed in the design of new ETL, Data Warehouse/Data Marts, and Reporting and Analytics Architectures, data governance and data quality processes.
• The program was managed using Agile methodology (JIRA, Confluence, and Clarity).

Confidential, Dearborn, Michigan

Group Manager/Lead Architect

Responsibilities:

• Evaluated long-term business objectives and short-term business needs.
• Gap Analysis for existing BI/DW landscape with reference to current and future business needs, architecture, Tools, processes and in-house skills.
• Managed BI Team and created a high performing team environment based on knowledge sharing, collaboration, delegation, and accountability.
• Designed and implementing an Enterprise Data Warehouse and self-service BI/Reporting environment. Long-Term objective is to align the new BI/DW environment from Product perspective which can be marketed to other DME companies. The product scope includes analytics for the subject areas of Billing, Providers, Patients, and Suppliers.
• Used Data analytics to get business insights for Decision Support with reference to Inventory management based on the consumption patterns and patient segmentation in multiple geographies. Also used the data analytics to optimize and project delivery resources.

Confidential, Oklahoma City, OK

Management Consultant

Responsibilities:

• Determine the effectiveness of existing technologies and processes in relation to the data architecture design, create necessary implementation/migration plans, and recommend new solutions as required.
• Develop data governance framework, clearly identifying roles and responsibilities of technology and business teams.
• Initial BI/DW landscape analysis has identified the limitations and gaps from architecture, data, process, and organization perspectives. Worked with IT and Business Executives, SMEs, and GuideWire architects to define future strategy and roadmap aligned with current and future business objectives. Defined the new organizational structure for BI, DW, and Analytics team, its Charter, and roles and responsibilities.
• Architected high-level architecture framework based on Data Lake approach.
• Current Source Environment includes Guidewire Insurance Suite (Policy Center, Claim Center, Billing Center, and Contact Manager), Guidewire Datahub and InfoCenter (Oracle, SAP BODS, Cognos). In addition to evaluating GW DataHub and InfoCenter’s fitness to CompSource Business needs, also evaluated the optimal upgrade path for these products. Worked directly with Guidewire consultants during analysis and estimation. Worked with Guidewire consultants to evaluate the upgrade path and dependencies for GW DataHub and GW Infocenter. Prepared the Project estimation, project plan.
• Evaluated AWS and Azure. Based on the fitness with Business needs, AWS was selected. Under the Hybrid cloud, applications were moved to AWS while data was kept in-house. Used Pentaho tool set for this initiative.

Confidential

EDM Technical Lead

Responsibilities:

• Analyzed the current landscape and identified the Architectural gaps, documented data quality issues and the root causes. Also evaluated the technical skills of existing Data and BI resources. Interviewed business executives and SMEs to understand the limitations/roadblocks in efficiently doing business analysis and decision making.
• Worked with Business and IT executives to prepare a plan which is aligned with long term business vision and goals while also addresses the short term challenges and business needs.
• Have identified 5 main progress tracks comprising Data Governance, Data Topology, Master Data Management, Reporting & Analytics, and Technology Evaluation for Visualization and Reporting. In addition, identified the organizational gaps with respect to Data Management and Business Intelligence and proposed the new organizational structure for Data Management and Business Intelligence organizations.
• With reference to the progress tracks, have prepared the 3 year roadmap, cost estimation, and phased approach. I was also engaged with vendor companies to evaluate their offerings with reference to the progress tracks.
• Current Source Environment includes Guidewire Insurance Suite (Policy Center, Claim Center, Billing Center, and Contact Manager). The DW/BI landscape included Microsoft SQL Server, SSIS, SSRS, SSAS, and Power BI). Also evaluated Guidewire Datahub and InfoCenter from future BI/DW Architecture perspective.

Program Manager (Director)

Confidential

Responsibilities:

• Defined BI Strategy
• Built the BI and Analytics Organization from ground-up
• Defined Organization Charter and BI Roadmap
• Established formal committees and process to interact with business executives and managers on regular basis and implemented data and process governance policies and procedures. Used RACI model to introduce Data Stewardship process. Data Quality was enhanced by introducing Data Certification process.
• Implemented Governance Structure and processes to support BI and Analytics needs of all functional areas under Specialty Lines of Business
• Made significant improvements to current Analytical capabilities by delivering an integrated analytical environment for Direct Marketing and Specialty Products to enable cross-sell exploration
• Led the effort to integrate Premium Data with Loss Data by partnering with Head of Actuary and Products, Head of Finance, and VP of New Business Development.
• Guidewire Claim Center was implemented at Enterprise level. Led all activities including the gap analysis, business requirements, design, development, testing, migration, and go-live.
• Led a multi-million dollar initiative to integrate Casualty and Property Products (source being DuckCreek) and Legacy applications under Specialty BI/Analytics to provide cross-product actuarial analytics and decision support, hence, reducing the life cycle time to model and launch new products.
• Led the effort to convert daily full load DW ETL process to daily incremental load which resulted in an annual savings of $200,000 in computing costs.

Confidential

Manager/Senior Data Warehouse Architect

Responsibilities:

• Completed a full life cycle implementation of a sales and distribution data warehouse under SAP BW, Oracle, and Business Objects for a manufacturing company
• Performed requirements definition and gap analysis
• Developed a vision for an enterprise level business intelligence strategy
• Managed all technical aspects of the project
• Led a comprehensive architectural gap analysis and Decision Edge Fitness Project
• Facilitated end user requirements gathering workshops
• Analyzed and identified the gaps in the existing architecture
• Instrumental in mapping the current Decision Edge Data Model to the business requirements to identify the enhancements required in the base model
• Helped design and develop a DSS data mart at a major bank in Brazil
• Designed the data extraction, load, and aggregation processes
• Re-engineered the data extraction and load processes for existing data marts, resulting in cost savings of over $100,000 per year
• Provided technical leadership to architect the enterprise-wide data warehousing solution for a multi-billion dollar office furniture manufacturer based in Michigan
• Performed the architectural gap analysis, requirements analysis, and high-level data warehouse design for SAP BW
• Defined the test strategy for the pilot implementation of Sales and Marketing data warehouse under SAP BW

Confidential

Data Warehouse Architect

Responsibilities:

• Provided technical leadership for a full life cycle implementation of a four terabyte data warehouse for a retail chain
• Responsibilities included interaction with client executives, project staffing and management, task assignment, quality assurance, deliverables management and knowledge transfers
• Served as primary point-of-contact with various clients in marketing division to gather and translate business needs into technical requirements
• Worked on a large paint manufacturer’s Sales and Marketing Performance Analysis Decision Support System
• Analyzed user requirements
• Evaluated and recommended tools for data extraction and meta data repository
• Communicated with executive committee, business users and technical staff
• Analyzed and Designed ETL processes for Vehicle, Sales, Service, and Marketing (VSSM) data warehouse at General Motors
• Participated in the data warehouse design
• Led the team to develop and implement the data acquisition plan for initial and incremental loads