SUMMARY:

• Technology Executive with thought leadership in all aspects of Enterprise Information Management including solution design, architecture and implementation.
• System Architect with 17+ years of successful experience in Enterprise Data Warehouse, Business Intelligence and Enterprise Information Management solution design and implementation.
• Experienced People Manager with proven track record in managing in - house and vendor teams with onsite/offshore development as well as 24X7 production support projects
• Proven expertise in all aspects of Solution Architecture, Data Architecture, Data Governance, Relational and Dimensional Modeling, and Program Management for Enterprise Engagements, BI Strategy and Program Roadmaps.
• Proven track record in managing and leading cross-discipline teams for delivering high quality business solutions on time and within budgets.
• Scrum Alliance Certified Scrum Master
• CEB IT Leadership Academy Certified Business Partner
• Experienced in leading and mentoring Data and Solution Architects for designing Enterprise solutions.
• Experienced with BI methodologies from Ralph Kimball and Bill Inmon
• Experienced with Enterprise Architecture frameworks like Zachman and TOGAF

TECHNICAL SKILLS:

Business Verticals: Retail & Consumer Goods, Media & Entertainment, Banking, Financial Services and Insurance, Healthcare, e-Biz and Utilities

Process Methodologies: Agile (Scrum), Six Sigma, RAD/JAD, and Waterfall

Data Warehousing and ETL Tools: Oracle Warehouse Builder (OWB 11g/10g), Syncsort DM Express 7.x, Oracle Analytic Workspace Manager (AWM 11g/10g)), Oracle Workflows, Kalido Dynamic Information Warehouse (DIW), Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Analysis Services (SSAS)

Database Platforms and Tools: Oracle 11g/10g with OLAP, Teradata 13.10, MS SQL Server 2014/2012/2008 R2/7.0, Sybase 10, PL/SQL Developer, Toad, PL/SQL Developer, Teradata SQL Assistant, Simba MDX OLAP Provider

Business Intelligence Reporting Tools: QlikView 11.2, Oracle Business Intelligence Enterprise Edition (OBIEE 10g), Tableau 7.x, Oracle Discoverer Plus for OLAP, Oracle Discoverer Plus Relational, Microsoft SQL Server Reporting Services (SSRS), CUBUS, Business Objects XI R2

Data Management, Modeling, Designing and Governance Tools: SQL MDS, Erwin, Visio, Kalido Business Information Modeler (BIM), Kalido Master Data Management (MDM) and Kalido Data Governance Director (DGD)

Cloud Computing Platforms: Amazon Web Services (AWS Data Pipeline, AWS Lambda), Microsoft Azure

Application Server/Middle Tier: Oracle Application Server 10.1.0.3, OC4J, Oracle Business Intelligence Server

Operating Systems: Windows Vista/XP/2K/NT, SUN Solaris, and Red Hat Linux

Customer Relationship Management: Siebel 7.7/7.5, Siebel Tools Configuration, Siebel Call Center, Workflow, Assignment Manager, VBScript, eScript, Business Services, Actuate Reports

Programming Languages: C, C++, VC++, VB, Lotus Script, Lotus Formula Language, PL/SQL, Unix Shell scripting.

Hardware Platforms: Sun Sparc Servers, Sun-Fire-V490 servers, IBM Intel Xeon Servers, HP Proliant 3800 series servers, IBM compatible P-IV PCs

PROFESSIONAL EXPERIENCE:

Confidential

Senior Director, Business Intelligence

• Leading and Managing BI and Data Warehousing Program for all group brands operating out of North America geography.
• Direct Reporting to the CIO and CFO/COO for the BI program.
• Dotted line reporting to Global Leaders in Fast Retailing Japan
• Leading and Managing the 24X7 SQL Server Database Operations for all group brands hosted out of North America geography.
• Overseeing the IT support for Planning team at Theory US
• Managing a team of full time employees, DBAs and IT partner resources.
• Overseeing Solution Architecture and Data Architecture for Theory - the leading group brand in the US.
• Managing the designing and implementation of BI solutions for empowering business with actionable intelligence.
• Designing and Building Enterprise Information Assets like Enterprise Data Entity Models and Data Architecture Frameworks.
• Accountable for successful and timely delivery of all BI and Database initiatives.
• Working with Business Sponsors to address the ever-evolving needs and growing requirements for actionable and self-service BI data by creating the roadmap for Enterprise wide BI landscape.
• Representing the Technology Department in the Data Governance council formed by the Key Business Sponsors.
• Rationalizing the technology platforms across the BI/Application domain.
• Managing SQL Server Managed Services
• Managing IT Vendor/Partner Relations

Confidential

Platform: Synscsort DM Express / Teradata / Oracle / OBIEE / Tableau / Business Objects / Kalido / Oracle Warehouse Builder / Oracle Discoverer

• BI and Data Warehousing Program Management
• Solution Architecture and Data Architecture for the enterprise.
• Designing and Implementing BI solutions for empowering various Business functions with actionable intelligence.
• Designing and Building Enterprise Information Assets like Enterprise Data Asset Registry and Data Architecture Frameworks.
• Ensuring successful and timely delivery of all deliverables.
• Working with Business Sponsors to address the ever-evolving needs and growing requirements for actionable and self-service BI data by creating the roadmap for Enterprise wide BI landscape.
• Leading and Managing the Confidential and Technology Partner teams in implementing various BI initiatives.
• Representing the Technology Department in the Data Governance council formed by the Key Business Sponsors.
• Rationalizing the technology platforms across the BI domain.
• Managing Teradata Managed Services
• Managing IT Vendor/Partner Relations

Confidential, Chicago, Illinois

Platform: Oracle Warehouse Builder / Oracle Discoverer / Oracle Publisher / Siebel 7.7/7.5 Call Centre ENU / Oracle 10g / SCO UNIX / SUN Solaris

Responsibilities:

• Client Communication and Project Management
• BI Analyst
• Siebel Configuration and Integration
• Meeting with Business owners to understand requirements and designing enhancements for the applications.
• Documentation of requirements gathered from client.
• Creating a relational data model for the data warehouse using ER Modeling
• Installation of Oracle Application Server, Oracle BI Tools and OWB
• Creating the dimensional model using OWB
• Integrating the DW metadata with Oracle Discoverer.
• Defining the rules and creating the data mappings between Oracle database and Siebel Application Database.
• Creating reports to present business data via Oracle Publisher.
• Configuration of Siebel Applications using Siebel Tools.
• Siebel Configuration for customizing the business components.
• Developing, Simulating and Deploying Siebel Workflows - Developing Workflow Processes, Workflow Groups, Workflow Policies, Workflow Actions and Workflow Conditions.
• Designing and Developing Business Services using Siebel eScript.
• Using eScript to perform Data manipulation and field validations.
• Unit/System/Integration testing - Performing integration testing and code walkthroughs.
• Configuration of Applets, Views, Business components and objects using Siebel Tools.
• Setting up of the Organizations, Divisions, Positions and Responsibilities as per the business requirements.
• Configuring Business Components and Views as per the Visibility requirements.

Confidential

Platform: Oracle Warehouse Builder 9i/10g / Oracle Database 9i/10g / Oracle Discoverer / SCO UNIX / Solaris

Responsibilities:

• Client Relationship Management and Communication
• Project Management
• Implementation of Oracle Data warehouse for the sales performance analysis and forecasting for sales targets
• Held extensive requirement gathering sessions with the business owners and system users to understand their requirements.
• Created and Documented the System Specifications and Requirements on an incremental basis.
• Defined a relational dimensional model to setup the warehouse environment
• Configured the Oracle Warehouse Builder for setting up the database
• Defined the Source Metadata
• Defined Rules for Mapping Tables and Mappings for staging data to ensure data quality
• Handled Slowly Changing Dimensions
• Implemented Process Flows for the application data
• Performed Extraction, Transformation and Loading of Data and integration of the OWB with Oracle Discoverer.
• Designed the Reports for reporting data from the warehouse using Oracle Discoverer.
• Unit/System/Integration testing - Developing and Executing Test plans and Test Cases.
• Interacting with Business users to provide solutions to their everyday queries.

Confidential

Platform: Lotus Notes R5 / Windows 2K/NT

Responsibilities:

• Analysis, Design and Development of the KMS system.
• Global Release of the system.
• Production Support.
• Implementation of Enhancement requests.

Confidential

Platform: VC++ / Windows 2K/NT

Responsibilities:

• Application Developer having the technical responsibility for the analysis, design and development of the Performance Monitor Application.
• Analysis, Design, Implementation, Testing and Release of a performance monitoring system for the Automation System of Power Plants.

Confidential

Environment: Oracle 8.0 / VB / SCO UNIX

Responsibilities:

• Client Communication
• Database Designing
• Code Implementation
• Meeting with car dealers to understand requirements and designing enhancements for the applications.
• Documentation of requirements gathered from client.
• Designing of the database in Oracle 8
• Implementing Database Tables
• Coding for the program logic in VB
• Unit/System/Integration testing
• Creating User guide for the application and imparting training to end users