SUMMARY

• Experienced Datawarehousing and Business Intelligence Expert with more than 15 Years of information technology experience on Business Intelligence, transactional, Datawarehousing, E - business and Marketing Applications.
• Exposure to diverse verticals like Finance, Gaming, Online Gaming, Mobile, Social, Sales, Direct Marketing, HealthCare, Mortgage, Retail, Entertainment, Digital Marketing, Manufacturing etc…
• Experience in establishing an enterprise-wide data governance & Master Data Management framework, with a focus on improving data quality & security by creating new or upgrading existing organizational policies and standards, governance metrics, processes, related tools and data architecture.
• Collaborated with business unit stakeholders in producing KPIs and quality metrics while ensuring compliance with data policies, standards, roles & responsibilities, and adoption requirements.
• Developed short & long-term budget/investment plans to execute on Data Strategy Roadmap; ongoing management of allocated budget + ROI updates against plan.
• Defined, configured & optimized various Enterprise Data Management processes and stages including data ingestion/acquisition, standardization/enrichment, harmonization and data provisioning.
• Provided best-practice guidance to individual business units on data management & BI solutions to ensure grassroots efforts are interoperable within enterprise-wide ecosystem.
• Strong understanding on the architectural concepts of Relational databases & Big Data.
• Strong Experience in Leading/implementing industry standard End-to-End DWBI solutions by applying detailed knowledge of a strategic industry.
• Lead & Developed extensive BI solutions for numerous CRM, Campaign Management & ERP environments.
• Good exposure in Leading/Implementing Datawarehouse/DataMart Projects using Informatica, SnowFlake, Talend, SQL Server, Netezza, Oracle, RedShift, Datastage, Pentaho, Horton Works, Cassandra etc.
• Experience in Leading/implementing BI solutions using reporting tools like Microstrategy, SQL Server, PowerBI, Cognos, Business Objects and Tableau etc…
• Provided leadership to direct reports to define the vision and goals to achieve business outcomes and oversee the implementation of the project portfolio.
• Worked closely with Digital Infrastructure & Applications teams to develop, implement and manage Data Insightful solutions.
• Develop comprehensive internal documentation related to data models/taxonomies, ecosystem maps/schemas, hygiene/update processes, governance protocols, data security & privacy.
• Manage selection of hardware, storage, and software products & service providers for Data Development, Data Warehousing and other BI products & services.
• Participated actively in sector/peer Data/Application Architecture network groups to exchange learnings, synthesize knowledge and collaborate - sharing internally to key stakeholders.

TECHNICAL SKILLS

OLAP Tools: MicroStrategy, MicroStrategy Cloud Services, PowerBI, Tableau, Qlik, Birst, SQL Server Report Services (SSRS), ProClarity, SQL Server Analysis Services (SSAS), Actuate, OBIEE, Cognos, Jaspersoft, Pentaho, Jaspersoft, R

Cloud Platforms: AWS, Azure, Google, SalesForce, Heroku

ETL Tools: Informatica, Informatica Cloud Services, Data Integrator, Microsoft SQL Server Integration Services (SSIS), DataStage, Talend, Pentaho, Oracle Warehouse Builder, Oracle Data Integrator, DM Express

Data Quality Tools: Informatica Data Explorer, Talend Data Profiler, Informatica Data Quality, Melissa Data, 360Science

Operating System: Windows, Linux, Cent OS, Ubuntu, Mac

Languages: Java, PL/SQL, C++ and C, Perl, Windows Shell Script, Linux Shell Scripting, JQuery, NodeJS

Relational Databases & Big Data: Oracle, MS SQL, MS Access, Netezza, MySQL, DB2, Teradata, Horton Works, Big Data, SnowFlake, Horton Works, Cassandra

PROFESSIONAL EXPERIENCE

Confidential

Manager, Enterprise Data Architecture

Environment: AWS, SnowFlake, RedShift, SalesForce, Heroku, Microsoft Azure, Microstrategy, Tableau, Netezza, DashDB, IBM Data Architect, Cognos 10.2, SQL Server, SQL Server Integration Services, SQL Server Reporting Services, MGT, ATI, IGT, CMS, SMS, LMS, Micros, R, Lawson, Stratton Warren, Upsight, Infinium, Kronos, VizExplorer, TicketMaster.

Responsibilities:

• Transitioned to Confidential as part of Confidential Acquisition.
• Confidential Corporation is one of the largest and most successful casino entertainment companies in the United States. We currently own and operate 24 gaming properties in seven states - Nevada, Illinois, Indiana, Iowa, Kansas, Louisiana, and Mississippi.
• My Role heavily contributes towards Boyd's Data Intelligence Growth & Governance Program and Drive related Technology roadmap.
• Direct team of Business Intelligence Report Developers, Data Architects, and Data Engineers to build out an Enterprise Datawarehouse Solution which delivers actionable Insights to internal users across Confidential Enterprise.
• Manage relationship with various software vendors & Consulting companies.
• Member of Architecture Center of Excellence Committee responsible for defining roles, procedures, and policies around various IT Project Initiatives.
• Managed team budget for staff training and staff augmentation labor expenses.
• My role Manages/Approves Strategy/Technical Direction/Guidance & Execution plan for Projects related to multiple verticals like Gaming Marketing, Finance, Procurement, Hotel, Retail, HR, Digital Marketing, Entertainment, Race & Sports, Online Gaming, Social Networks, CRM, Master Data Management, Data Governance, Data Quality etc...
• Responsible for creating Customer MDM process, Used Heavily for Cross Property Marketing.
• My role closely works with Senior Management & Subject Matter experts to understand Business requirements and tactically Plan/implement/Deliver solutions within desired timelines.

Confidential

Director of Business Intelligence

Environment: Microstrategy, Informatica, SQL Server, SQL Server Integration Services, SQL Server Reporting Services, Microsoft CRM, MGT, ATI, IGT, LMS, Micros, Google Apps, R, TicketMaster, Upsight, Infinium, Kronos.

Responsibilities:

• Responsible for Integrating Data from all Business channels (ATI, IGT, Hotel, F&B, Kiosks, Mobile, Online Casino, GL, Website, Social, Digital, Entertainment etc…) into the Datawarehouse.
• Saved around 1.8 million Dollars in Software and Licensing Fees by effectively utilizing existing software & hardware and optimally designing the Datawarehouse.
• Responsible for gathering user requirements and creating Business Insights Using Microstrategy, Microsoft CRM, SSRS.
• Responsible for Automating Core Mailer Process, which saved 7 days of resource time. Every month, Core Mail will be generated in less than 5 minutes, scrubbed and sent to the mail houses.
• Responsible for creating Customer MDM process, Used Heavily for Cross Property Marketing.
• Responsible for implementing Data quality process to help clean bad Customer data, Mailing addresses/email addresses, Phone Numbers etc..
• Responsible for implementing Data Enrichment processes enabled us to acquire new Mail Addresses, Customer Socioeconomic Situation, Email addresses and Phone Numbers.
• Brought Email Marketing and Survey mechanism in House and saved around100K.
• Designed Datamining process to score Customer Worth, Model created a positive impact on our revenue and helped reach out to Customers we ignored due to several other reasons. Embedded Latency, Frequency, Tenure and Seasonality into the model.
• Responsible for Managing certain Kiosk Promotions (MGT), Which Involves Understanding and Automating Customer Segmentation and Load Process into the Kiosk.
• Responsible for the success & Implementation of Mobile App Project.
• Responsible for Managing Online Casino Project and assisted launching it on web and mobile devices.
• Responsible for automating numerous Time consuming and manual processes which made room for our resources to spend more time on Business/Data Analysis.
• Prepare Reporting deck for BiWeekly Marketing & Financial Meetings with the Properties. Present Analytics to CFO, President (at Corporate), Marketing Directors, Vice President, General Managers (At Properties).
• Work with department heads and help Train resources on various reports and tools.

Confidential, Phoenix

DWBI Architect

Environment: MicroStrategy 9.3, Teradata, SQL Scripting

Responsibilities:

• Understanding Business requirements from the Client.
• Performed Data Quality analysis using SQL.
• Verify accuracy of data in the data warehouse (Testing)
• As MicroStrategy Architect, I am responsible for the design, implementation and full lifecycle management of Confidential Pricing Project reporting and analytics platform.
• As an Architect, I am also responsible for defining and managing the overall BI solution architecture including the physical hardware environment, as well as presentation, application and data tier configuration. Responsible for the development of logical data models and physical data base designs applied across multiple computing environments.
• Provide strategic thinking, solutions and roadmaps while driving architectural recommendations.
• Created Schema Objects, Public Objects on MicroStrategy.
• Supported MicroStrategy Report environment
• Provided support by performing data validations.
• Prepared weekly status reports on Project Progress

Confidential, Minneapolis

DWBI Architect

Environment: MicroStrategy 9.3 Cloud Services, Informatica Cloud Services, MS SQL Server 2008, FNC Flat Files, Windows Scripting, Linux Shell Scripting

Responsibilities:

• Understanding Business requirements from the Client.
• Performed Data Quality analysis using SQL.
• Setup Informatica on the Cloud and Administered
• Setup SQL Server on the Cloud and as target database
• Designed logical/Physical data model to support reporting activities
• Designed Confidential Lending Support Services Enterprise data warehouse
• Developed Informatica Jobs, Task flows on Informatica Cloud.
• Verify accuracy of data in the data warehouse (Testing)
• As MicroStrategy Architect, I am responsible for the design, implementation and full lifecycle management of Confidential Lending Support Services Enterprise reporting and analytics platform.
• As an Architect, I am also responsible for defining and managing the overall BI solution architecture including the physical hardware environment, as well as presentation, application and data tier configuration. Responsible for the development of logical data models and physical data base designs applied across multiple computing environments.
• Provide strategic thinking, solutions and roadmaps while driving architectural recommendations.
• Created Schema Objects, Public Objects on MicroStrategy.
• Supported MicroStrategy Report environment
• Provided support by monitoring daily ETL loads and performing data validations.
• Validated data on Daily basis once loads are completed
• Prepared weekly status reports on Project Progress

Confidential, Phoenix

Technical Lead

Environment: Microstrategy 9.2.1, Microsoft SQL Server 2008, SQL Server Integration Services, SQL Server Reporting Services, Windows 2008 Server.

Responsibilities:

• Gathered requirements and validate existing requirements
• Interviewed Business & IT users to understand data source environment
• Designed logical/Physical data model to support reporting activities
• Designed Amex Travel data warehouse
• Designed, Created & Developed Amex Travel data warehouse
• Assisted Amex team with MicroStrategy Administration.
• Responsible for setting up MicroStrategy Distribution Services.
• Responsible for developing MicroStrategy Intelligent Cubes, Reports and Dashboards.
• Presented entire development activity to the Amex Travel team members and made them familiar with the process.
• Provided Training for Amex Travel Business Users on how to use various components of MicroStrategy on web interface.

Confidential, Los Angeles

Project Manager & Technical Lead

Environment: Microstrategy 9.2.1, Talend 5.X, Oracle 11g, SQL Server 2008, Salesforce.com, Microsoft Access, SQL Server Integration Services, SQL Server Reporting Services, Cent OS, Mingle, MicroStrategy SDK

Responsibilities:

• Gathered requirements and validate existing requirements
• Interviewed Business & IT users to understand data source environment
• Performed Gap analysis on data source to ensure data supports requirements (as necessary)
• Designed logical/Physical data model to support reporting activities
• Designed Teetime Analytics data warehouse
• Designed, Created & Developed TeeTime Analytics data warehouse
• Using Talend 5.X Developed ETL for the data model
• Verify accuracy of data in the data warehouse (Testing)
• Installed and Configured Microstrategy Project on DEV/QA/PROD
• Took part in Microstrategy 9.X Upgrade on Dev/QA/Prod machine.
• As Microstrategy Architect, I am responsible for the design, implementation and full lifecycle management of Golf Channel Enterprise reporting and analytics platform. As an Architect, I am responsible for defining and managing the overall BI solution architecture including the physical hardware environment, as well as presentation, application and data tier configuration. Responsible for the development of logical data models and physical data base designs applied across multiple computing environments
• Provide strategic thinking, solutions and roadmaps while driving architectural recommendations.
• Created Schema Objects, Public Objects on Microstrategy.
• Assist development team in the design of new BI solutions. Work with product owner and business Leaders to understand and translate user stories and/or requirements into data models, analytics reports and scenario models.
• Lead technology review meetings and ensure appropriate governance processes are followed.
• Performed Report/Report Builder/Dashboard Development and validation
• Performed Unit testing and Integration testing.
• Presented entire development activity to the Golf Channel team members and made them familiar with the process.
• Provided Training for Golf Channel Business Users on how to use various components of Microstrategy on web interface.
• Lead a team of 7 Consultants.
• Played a key role in providing Project Estimates (Cost & Time) to the Customer.
• Played a key role in the Business Development at Golf Channel.
• Status Reporting.
• Provide leadership, guidance and mentoring.

Confidential, San Francisco

Microstrategy Architect & Dashboard Developer

Environment: Microstrategy 9.0.2, SQL Server, Microsoft Access.

Responsibilities:

• Understanding Confidential Business, Project Documentation, Data warehouse and Microstrategy Development requirements.
• Took part in Business discovery, Analysis, Design, Development and testing phases of the project.
• As Microstrategy Architect, I am responsible for the design, implementation and full lifecycle management of Confidential Energy Management reporting and analytics platform.
• Created Schema Objects, Public Objects on Microstrategy.
• Assist development team in the design of new BI solutions. Work with product owner and business Leaders to understand and translate user stories and/or requirements into data models, analytics reports and scenario models.
• Created Reports and Dashboards.
• Status Reporting

Confidential, San Francisco

Project Manager & Technical Lead

Environment: Microstrategy 9.0.2, DB2, Microsoft Access.

Responsibilities:

• Understanding Confidential Business, Perform Source Project Documentation, Data warehouse and Microstrategy Development requirements.
• Took part in Business discovery, Analysis, Design, Development and testing phases of the project.
• Understanding existing Microstrategy 8.X/9.X environment.
• Published Microstrategy migration strategy document.
• Took part in Microstrategy 9.X Upgrade on Dev/QA/Prod machine.
• Validated the User and Schema Object migration from 8.1.2 to 9.X.
• As Microstrategy Architect, I am responsible for the design, implementation and full lifecycle management of Perform Source Enterprise reporting and analytics platform. As an Architect, I am responsible for defining and managing the overall BI solution architecture including the physical hardware environment, as well as presentation, application and data tier configuration. As an Architect I worked with the BI development team as well as the Data Warehouse team to deliver sustainable reporting solutions with optimal end user performance. Responsible for the development of logical data models and physical data base designs applied across multiple computing environments.
• Implemented Microstrategy Internationalization.
• Implemented Microstrategy Command Manager, Object Manager.
• Implemented Microstrategy Enterprise Manager.
• Provide strategic thinking, solutions and roadmaps while driving architectural recommendations.
• Created Schema Objects, Public Objects on Microstrategy.
• Assist development team in the design of new BI solutions. Work with product owner and business Leaders to understand and translate user stories and/or requirements into data models, analytics reports and scenario models.
• Lead technology review meetings and ensure appropriate governance processes are followed.
• Performed Report/Report Builder/Dashboard validation
• Performed Unit testing and Integration testing.
• Presented entire development activity to the Confidential team members and made them familiar with the process.
• Provided Training for Confidential Business Users on how to use various components of Microstrategy on web interface.
• Provide leadership, guidance and mentoring.
• Manage the project plan for new development of reporting solutions.
• Support PMO functions including project planning, earned value management, quality assurance, risk management, program audits, etc.
• Gather program technical status and develop weekly, monthly and tri-annual reports to customer.

Confidential

Senior BIDW Consultant

Environment: Microstrategy 9.0.1, Talend 4.0, DM Express 6.X, Teradata, SQL Server 2000/2008, DB2.

Responsibilities:

• Understanding Silverton Business, Ongoing Projects, Marketing, Hotel and Gaming data mart requirements.
• Took part in Business discovery, Analysis, Design, Development and testing phases of the project.
• Gathered Business Rules from the Key Business users.
• Created data models & Data Mapping Document for the marketing and gaming datamart projects.
• Developed Jobs and Tasks using DMExpress (ETL tool).
• Took part in migration project from DMExpress to Talend. (Performed repository and Project configuration)
• Created Jobs, mappings and workflows as per the business rules derived from earlier ETL process.
• Handled business logic changes and Change requests from the Users.
• Performed data validation on Daily basis. Automated ETL validation using Data Checker process.
• Performed Unit testing and Integration testing.
• Understanding existing Microstrategy environment.
• Published Microstrategy migration strategy document.
• Upgraded and Installed Microstrategy 9.0 & 9.0.1 on the test machine fulfilling certain pre-requisites.
• Created DSN connections as required for the upgrade and tested using MSTR DB Query tool.
• Upgraded previous version metadata during Repository Configuration.
• Configured MSTR Intelligence Server.
• Validated the User and Schema Object migration from 8.1.2 to 9.0.
• Deployed MSTR Web (IIS) and MSTR Web Services.
• Deployed Narrow cast server.
• Developed sample reports using Microstrategy 9.0/9.0.1 Desktop.
• Presented entire development activity to the Silverton team members and made them familiar with the process.

Confidential, Boston

Senior Consultant

Environment: Microstrategy 9.0, Talend 3.2.3, MySQL, SQL Server 2008, Sugar CRM.

Responsibilities:

• Understanding Confidential Business and data mart requirement.
• Installed Talend Integration Suite on Linux Box.
• Created Design and Solution Architecture document.
• Created data mapping document.
• Created Talend Project, Jobs, Flows and Business models.
• Provided support by monitoring daily ETL loads and performing data validations.
• Validated data on Daily basis once loads are completed
• Prepared weekly status reports on Team’s and Project Progress
• Published Microstrategy development strategy document.
• Installed Microstrategy 9.0 on the test machine fulfilling certain pre-requisites.
• Created DSN connections as required for the upgrade and tested using MSTR DB Query tool.
• Upgraded previous version metadata during Repository Configuration.
• Configured MSTR Intelligence Server.
• Deployed MSTR Web (IIS) and Web Universal (Tomcat).
• Deployed MSTR Web Services.
• Deployed Narrow cast server.
• Developed Microstrategy reports using filters, prompts, Metrics, reports and report services.
• Supported Microstrategy Report environment
• Created and executed HTML and Report Services documents.
• Performed data validation.
• Performed Unit testing and Integration testing.
• Prepared Transition document and shared project details with Digitas Team members.

Confidential, Detroit

Senior Consultant

Environment: Microstrategy 8.1.2, Microstrategy 9.0, Oracle Data Integrator 10.1.3.5, Oracle 10G, SQL Server 2000, SQL Server 2005, SQL Server 2008.

Responsibilities:

• Understanding Confidential Business and Sales/Spend Analysis data mart requirement.
• Developed Oracle Date Integrator Projects, Packages, Flows and models.
• Understanding existing Microstrategy environment.
• Published Microstrategy migration strategy document.
• Installed Microstrategy 9.0 on the test machine fulfilling certain pre-requisites.
• Created DSN connections as required for the upgrade and tested using MSTR DB Query tool.
• Upgraded previous version metadata during Repository Configuration.
• Configured MSTR Intelligence Server.
• Validated the User and Schema Object migration from 8.1.2 to 9.0.
• Deployed MSTR Web (IIS) and Web Universal (Tomcat).
• Deployed MSTR Web Services.
• Deployed Narrow cast server.
• Created and executed HTML and Report Services documents.
• Developed sample reports using Microstrategy 9.0 Desktop.
• Performed data validation.
• Performed Unit testing and Integration testing.
• Presented entire environment to the PPG team members and made them familiar with the set up process.