Business Intelligence Data Warehouse

Sourin Rao

**** ****** **, ****, ** *****, Phone: 248-***-**** (Mobile)

Email: ******.***@*****.***

OBJECTIVE

To exceed your organization's goals and objectives by applying client engagement, program management, enterprise data warehouse, data migration, business transformation, systems integration skills, data analytics, business intelligence, agile methodology (a combined experience in excess of 25 years.) to solve the business challenges of your organization.

PROFESSIONAL SUMMARY

A hands-on professional with proven. ability to provide proactive leadership in developing, facilitating and coordinating multiple projects/initiatives. A customer driven manager and a change agent demonstrating broad based competencies in complete IT SDLC and the following areas:

Business Intelligence Data Warehouse Program Management

Business Development Data Science Team Building

Project Execution System Integration P&L Management

25+ years combined experience in various industries including healthcare(BCBSM, Philips), commercial aviation, automotive (FORD), telecommunications, health & human services (child support),, consulting, and insurance

25+ years of consulting experience with companies like Accenture, Deloitte Consulting and IBM

Proven Business Intelligence and Data Warehouse professional with deep technical expertise in Tableau, Spotfire, COGNOS, Teradata, Business Objects, Siebel Analytics, Informatica, SAS, Databricks

Developed and managed domestic and international business ventures (India) with responsibility for revenue and profits

25+ years hands on experience in managing successfully on time, within budget delivery with a proven track record in leveraging cross functional teams of 10-25 analysts/developers/managers

Experienced background in full lifecycle of implementation including phases of requirements gathering, analysis, design, integration, transition, documentation, training & implementation

Worked closely with the Sales team in pre-sales support, response to RFP’s, proposal preparation and client presentations

Worked closely with the delivery team to ensure on-time/on-schedule delivery of the projects

A proven and successful Client Engagement Manager/Business Development, managing multiple accounts with a mix of onsite as well as offshore projects

Managed the expectations of consultant’s onsite and kept them motivated by providing them the appropriate training and career counseling in a timely manner

TECHNICAL SKILLS

IBM Mainframes: IBM ES/9000 or 3090 - MVS/ESA, TSO/ISPF, COBOL II

IBM Midrange: AS/400 - OS/400, CL, COBOL/400.

PC Technology: OS/2, MS-DOS - MF-COBOL, C, REALIA COBOL.

CaseTool: Coolgen, IEF 5.3.1 (Block mode - BAA, BSD), Composer.

Middleware: MQ Series, MQ COM/Proxy, Guardian, ADB2.

Web Technology: ASP, SQL Server, IIS.

Database: DB2, Teradata 14.10, Oracle 10g, Ingress, MS-ACCESS

Data Warehouse: Tableau, Spotfire, Databricks, Teradata 14.10, Oracle 10g, COGNOS 10, COGNOS TM1, Informatica, Business Objects, Siebel Analytics

Statistical Software: SAS, SPSS

PROFESSIONAL ACCOMPLISHMENTS

Feb 2023 – Current Philips, Data Services Program Manager

Work collaboratively with other functions including R&D, Project Management, Technical Consultants, Applications Consultants, Solution Architects, and third-party vendors on Data

Service projects including Data Migrations, MRN Conversions, Data Cleansing, Data Reporting, etc.

Supporting the Supplier Selection Process cross functionally for sustaining and for new

product development.

Drive the Data Services component of implementation projects to completion within budget and on time.

Ensuring that supplier related risks (cost, quality, availability) are anticipated, controlled, and mitigated.

Driving decision making processes for make or buy analysis.

Executing and supporting process improvement initiatives in relation to the Data Services

product offering

Work with third party Data Migration vendors providing a liaison between the third-party

vendors and Philips internal Project Management and resources

Identifying strategic cost reduction by significant contribution to design decisions, with

product roadmaps in perspective.

Prepare and design detailed Data Services Implementation plans that incorporates standard best practices along with custom requests to fulfill requirements outlined in the Statement of Work

Assist the Solution Architects with preparation of Statement of Work details for customer

approval.

Attend pre-sales discussion with customer to determine Data Services strategy and approach.

Working with product ownership to track software defects in relation to Data Services tools.

Sep 2020 – Jan 2023 Blue Cross Blue Shield of Michigan, Detroit, MI, Sr. Delivery Lead

Managed multi-million dollar (8.5 million) program to transform the Information Environment platform from Cloudera to Databricks/AWS Redshift

Program Management managing projects for data masking, data security, analytics automations, health case data feeds

Analyzing business needs and working with cross functional (technical & non-technical) teams to identify requirements and deliver enterprise solutions.

Leading a matrix project team to define, establish, and ensure completion of all program milestones while adhering to timelines and budgets.

Creating and managing detailed project plans for small to high complexity projects

Execute project work plans and revise as appropriate to meet changing needs and requirements

Leading cross-functional teams which consists of employees, contractors, and consulting partners

Manage day-to-day operational aspects of a project and scope

Review deliverables prepared by team before passing to client

Minimize exposure and risk on project

Ensure project documents are complete, current, and stored appropriately

Track and reports team hours and expenses on a weekly basis

Managing 3rd party vendors on Project Deliverables

Jul 2018 – May 2020 AlixPartners, Southfield, MI (1+ Year), Sr. Vice President, Business Relationship Manager, Consulting

Liaison between IT and consultants

Portfolio planning and management

IT Application Owners (advocating for maintenance, upgrades, etc.)

Prioritizing and approving Sustain work

Create and maintain capability maps for related function(s) and technology roadmaps for solutions aligned to business goals

Contract/vendor management

Supporting RFP and software selection

Support project estimation and UAT

Involved in business routines

Jun 2011 – Jul 2018 General Electric, Detroit, MI (6+ Year), Sr. Program Manager, Business Intelligence & Data Warehouse, Aviation

Responsible for daily operational maintenance of the Business Intelligence and Data Warehouse team on the Fleet Data Management (FDM), Proactive Fleet Management (PFM), TruEngines Program and Seibel Analytics Reporting

Oversee the design of Spotfire reports using the relational schema database housed in Oracle and transformed by ETL tool Informatica

Involved with evaluation of Salesforce as a potential replacement for the existing CRM platform, Siebel and Siebel Analytics

Manage multiple offshore support teams for application development and maintenance, using Agile methodology

Manage project financials related to project budgets, cost variance and budget variance

Liaison with the Aviation customers to provide technical strategy and business intelligence direction for future programs

Manage team members including performance appraisals, mentoring, and professional development guidance

Oct 2008 – Jun 2011 Deloitte Consulting, Detroit, MI (2+ Years), Sr. Manager, Business Intelligence

(A global leader in IT & Business Consulting with revenues exceeding $10 Billion.)

Responsible for daily operational maintenance of the Interfaces and Data Warehouse team on the Pennsylvania Child Support Enforcement System (PACSES)

Responsible for designing and implementing the Reporting and Analytics system for the Commonwealth of Kentucky Child Support Enforcement System

Feb 2006 – Sep 2008 Accenture LLP, Lansing, Michigan (2+ Years), Sr. Manager, Data Warehouse

(A global leader in IT Outsourcing & Business Consulting with revenues exceeding $17 Billion.)

The Functional Architect is responsible for providing consistency across deliverables on the Michigan Child Support Enforcement System (MiCSES)

Responsible for the development of high quality Business Requirements and Functional Designs which need to be completed on time and within budget.

Responsible for the development of high quality Business and Functional Requirements, which need to be completed on time and within budget

Supervised policy support analysts aiding the client in evaluating federal and state legislation and program reforms into child support program policy

Effectively supervised application design analysts assisting the functional leads in developing application design in support of the business policy

Analyzed federal and state legislation and determine its impact on the Child Support program

Provided policy and business procedure input into the development of training materials

Managed team members including performance appraisals, mentoring, and professional development guidance

Jan 2001 – Feb 2006 LASON SYSTEMS, INC., Troy, Michigan (4+ Years), Director, Systems and Services

(A global leader in information & data management with revenues exceeding $150 million.)

Responsible for managing a $6 million P&L as well as manage delivery of offshore and onsite projects, and Client Engagement.

The SSW division implements a Global delivery mechanism to implement turnkey solutions for its prestigious customers like FORD, Owens Corning, WEST Group, RL POLK etc.

Forged partnership with Tata Technologies, India for SAP implementation at Owens Corning.

.

Mar 1990 to Dec 2000:

Supported New Mexico Child Support Enforcement System with enhancements for various modules

Helped Missouri Child Support Enforcement System achieve federal certification

Designed and architected Case Management, Establishment and Enforcement modules for various states (Arkansas. Missouri, New Mexico, Michigan, Pennsylvania and Kentucky)

ACADEMIC ACCOMPLISHMENTS

MS in Computer Applications, Victoria Jubilee Technical Institute, University of Bombay, India 1990

Graduated with First Class Honors and was awarded student internship with the Mahindra Eugene Steel Company, Mumbai.

Bachelor of Science, University of Bombay, India

Graduate with First Class Honors with major in Physics and elective in Electronics.

PERSONAL

I have multiple tasks experience and a professional reputation for hands-on technical approach, exceptional time management skills with superb attention to accuracy & details and a continuous desire to make things happen. I am very excited about this opportunity to create value for the team and the clients and would like to make a significant contribution in this endeavor.

REFRENCES Provided upon Request

Contact this candidate