Business Analyst Resume Profile
EXECUTIVE SUMMARY
Enterprise Technology leader with over 18 years of progressive IT, Data Management, Data Warehouse and Business Intelligence experience spanning vertical markets like Health Care, Insurance, Tele-Communication, Manufacturing, and Retail. Responsible for Leading, Managing and Architecting Data Warehouse, Data Management and Business Intelligence initiatives for multiple business units of large and start-up companies from marketing ideation, stakeholder engagement/agreement and to delivery. Has significant experience in architecture, business strategy, technical leadership, project management, and product delivery. Has proven track record in turning failed initiatives into successful delivery. Experience in collaboration between IT, Sales/Marketing, Finance and Legal teams have been an invaluable foundation for providing overall solutions that drive growth, while managing costs. Highest passions are keeping customers happy, solving complex problems, and translating technology solutions into business value.
Strengths include:
- Experienced Healthcare Business Intelligence/Analytics/Data Management Project Leader
- Lead high performance EDW/BI/DBA and Data Teams
- Enterprise DW/BI Design and Architecture
- Enterprise Data Warehouse/Business Intelligence Strategy/IT Roadmap/Delivery
- Data Governance and Information Quality
- Data Mining, Predictive Modeling, SAS, Master Data Management
- Software Development Lifecycle
- Business Objects, Crystal, Microstrategy, Performance Point, OBIEE ,Cognos, SSRS Reporting tools
- Informatica, Data Stage, SSIS, Cognos Data Manager ETL tools
- Hadoop/Amazon EC Cluster, Big Data
- Teradata MPP , Data Allegro MPP Oracle, SQL Server databases
- IT Leadership Small to 250 teams
- Big 5 Business Intelligence Practice Management Leadership
- Well recognized industry speaker in MIT IQ Program2010/ICIQ Adelaide 2011, HIMMS
PROFESSIONAL EXPERIENCE
Confidential
- As the Project Lead for TruGreen, I am responsible for managing, architecting, executing and delivering Enterprise Data warehouse and Business Intelligence initiatives for the company. I have the key responsibility in partnering with business executives and other stakeholders to ensure that the delivery of data warehouse and Business Intelligence projects meet corporate strategies and initiatives.
- I have successfully hired and built a high performing Enterprise Data warehouse and Business Intelligence team inclusive of Data Integration developers, Business Intelligence analysts and architects.
- I have successfully created and implemented an Enterprise Data Governance process at TruGreen. This includes establishment of a Business Intelligence Competency workgroup to define and manage data governance, data standards and Key Performance Indicators for all major Business Units of the company as well as provide business requirements and priorities to the IT Business Intelligence team.
- I am leading and managing the IT and Business teams in developing the Enterprise Data warehouse and Business Intelligence solutions for the company. This includes designing and developing the data integration process to load data from various source systems and also developing Business Intelligence reporting solutions for end user consumption and analytics.
- I am leading an evaluation for selection of a companywide Business Intelligence tool to meet our analytics and reporting needs. This includes creating an evaluation criterion, identifying potential vendors, developing proof of concepts POC and a detailed RFP Request for Proposals process to select the tool.
Confidential
- As the Enterprise Data Management leader for Direct General Insurance company , I am responsible for managing, architecting, executing and delivering Data Management Initiatives for the company. I have the key responsibility in partnering with business executives and other stakeholders to ensure that the delivery of data warehouse and Business Intelligence projects meet corporate strategies and initiatives.
- I have successfully partnered with the executive leadership team in socializing and creating an enterprise Data and Information strategy. The strategy is anchored with corporate strategies and has supported the 30 year over year company growth as well transform the company to a customer centric organization. This strategy covers Enterprise Datawarehouse, Data Management, Business Intelligence, Data Retention and Data Archival strategies.
- I have successfully created and presented a comprehensive Business Intelligence plan to CEO and his direct reports. This includes a set of measureable goals and roadmap of projects and initiatives. My team has completed the process of building DW/BI best practices, standards, deployment processes, IT infrastructure environments, DW/BI PMO processes etc. These efforts have started to transform DW/BI to a mature program at Direct General.
- I have successfully built a talented team to lead Business Intelligence and Data warehouse efforts. As part of the process I have made several key hires and started the process in converting existing silo data marts into an Enterprise Data warehouse framework. I created a new Business Unit for the EDW/BI team.
- We have completed building the Enterprise Data warehouse EDW for Direct General. This included building a totally new Star Schema based Data Model for Claims/Policy/Quotes star schemas, creating ETL packages to load the data model and creating dashboards and Reports using the OBIEE 11g/SSRS BI tools. As of now all company Financial, Product, Actuarial, Claims, Marketing and Board level reporting as well downstream analytics is done from the EDW.
- I have successfully created and implemented an Enterprise Data Governance process at Direct General. This includes establishment of a Business Intelligence Competency group to define standards and Key Performance Indicators for all major Business Units of the company. We have created over 100 KPIs for the Finance, Claims, Product/Actuarial and Marketing Business Units.
- I have founded the Architecture Review Board ARB at Direct General. This group leads all technology initiatives, advises the CIO on technology trends as well as influence technology procurement at the company.
- I have worked with the legal and compliance team in formulating our Enterprise Data Retention policies. These policies are now being implemented throughout the organization.
- I have led a high performing team of Database administrators and Database developers. We have designed and deployed mature deployment process, implemented tools for database monitoring, re-design and re-architecting our current application systems to position us for growth and success.
Confidential
- I am one of the founders of this BI Company. As the Data Warehouse and Business Intelligence lead for Triton, I was responsible for negotiating, selling managing, executing and delivering DW and BI initiatives for various Clients. The following are some of the projects that I have successfully delivered
- For a hospital group successfully led, architected and delivered an end end Business Intelligence solution. The system provided an analytical system for the hospital group to measure its operational costs by various dimensions like DRGs, Patient, and Provider etc. This ultimately provided them a decision support system to take corrective measures to improve quality of care and at the same time reduce costs.
- Successfully architected and delivered a complete Data Integration strategy for Dell Computer's Enterprise Business Intelligence EBI platform. This strategy allowed Dell to migrate from its legacy system to Oracle and Teradata based DW/BI systems.
Confidential
- As Director for the Enterprise Data Warehouse and Business Intelligence, was responsible for the developing, evolving and executing the enterprise wide data warehouse and business intelligence strategy. Responsible for leading the company's data warehouse reporting vision into reality and achieve the corporate goal for being the best in class for reporting . Healthways at that time was the largest Disease Management Company in the world.
- I have successfully led and managed Data Warehouse and BI initiatives for all Healthways customers. These initiatives resulted in Healthways meeting contractual reporting requirements as well providing an analytical capability to improve their programs and services. This included hiring and growing a talented team, providing on job and professional training, TDWI group membership, department budget planning, resource forecasting and governance
- For the first time in the history of Healthways, the Data warehouse department was able to successfully meet several contractual, ad-hoc and analytical reporting needs for over 80 customers. I was able to turn a failed initiative to successful delivery of enterprise Data Warehouse and BI initiatives.
- Successful led a global sourcing program at Healthways with a team of over 250 staff onshore/offshore . The program supported majority of Healthways IT functions, including supporting expanding Healthways internationally to Latin America, Europe and Australia.
- I successfully led and managed the effort to create a scalable and stable Enterprise Data Warehouse and Business Intelligence architecture, ETL architecture, data models and extensible infrastructure to meet current and future needs. Standard deployment strategies were formalized and executed to improve adherence to HIPAA and SOX as well reduce operational costs
- Designed a Microstrategy and SAS Predictive Modeling solution to highlight the success of intervention techniques on many clinical programs and services. Standardized key performance metrics and implemented them in Microstrategy analytics to produce uniform customer reporting
- Led and managed end to end IT, data management automation initiatives, resulting in significant quality improvements and reduced considerable operational costs
- I was instrumental in creating the Master Data Management strategy to consolidate all customer profile data in one place. This system improved data quality by over 50 .
Confidential
- Responsible for working with various business units and IT in setting enterprise wide strategies and goals creating a road-map, architecture and objectives in regards to Information Technology, data warehousing, business intelligence and reporting. Worked with senior business executives and stakeholders to identify critical projects, secured sponsorships and delivered key projects on time. Managed several multi-million dollar and multi-year vendor relationships for key IT products and contracts As a result of these efforts, Multnomah County was awarded a Public Agency award for best reporting .
- I led and managed a team that design and implementation of an enterprise wide Health Data Warehouse Providers, Patients and Services . This system provided business users a tool to measure clinical productivity metrics and offered them a far detailed understanding of the costs and revenues associated with its clinical operations. I led the team in the design of the data model, ETL architecture, and the reporting architecture.
- I led and managed a team of database administrators Oracle/SQL Server DBAs Remedy Administrator, Crystal Report administrator. Role required: providing day to day production support, resolving database issues, mentoring other DBAs, planning for future storage and CPU expansion, designing storage area network ensure high availability clustered environment disaster recovery plan business continuance plan
- I successfully led a high performing team of DBAs and DW analysts and at the same time provided career planning interesting assignments, training and counseling.
- I led and designed and developed SAP Business Warehouse resulting in meeting many regulatory requirements as well reducing cost of operations
- My team implemented improvements to existing architecture and ensured adherence to data and meta-data standards, ETL standards, backup and recovery standards, storage and delivery of data.
- I led and built decision support reporting system that to support the business process and analytical needs of the health business managers. This system allowed business users deep information insight and helped them take strategic and tactical decisions on various services they provided. It enabled them to understand and improve productivity data by measuring facts like RVU, visit counts, charge amounts, utilization costs across different service delivery areas like Primary Care Medical Clinics, Dental Clinics.
Confidential
- As a senior member of the global data warehouse practice of PricewaterhouseCoopers, at that time the largest professional services firm in the world, led and managed several large scale multi-million dollar Data Warehouse and CRM projects spanning vertical markets in Electronics, Telecommunications, and Manufacturing sectors. Experienced working at the executive level of Fortune 500 companies like.
- Responsible for expanding the EDW/BI practice for PwC MCS Management Consulting practice. Was successful in winning several key accounts
- I led the design, architecture and implementation of Nike's enterprise retail data warehouse. This system served as a one stop shop for all Nike's global retail data reporting needs.
- I led the design, architecture and implementation of a 3 million Campaign Management system for the Wireless and Small Business divisions of Qwest Communications. Project resulted in an increase of 50 of customer acquisition and response rates, and enabled Qwest to effectively target 11 million potential customers and run all their marketing cross-sell and up-sell campaigns from a single unified platform. This reduced planning and execution costs significantly.
- I led the design, implementation and delivery an enhanced CRM Customer Relationship Marketing for Tektronix Measurement and Business Division. This system was instrumental in providing key decision makers advanced analytics information to support the largest division of Tektronix
- I led the design, implementation and delivery an enhanced customized Customer Call Center Management system for Hollywood Entertainment which own Hollywood Video one of the largest video chains in the country. This system implemented business processes to collect late fees resulting in additional revenue generation of over 10 million dollars a year
Confidential
As a senior consultant of Cap Gemini's Data Warehouse practice, was part of a delivery team involved in the delivery of several large-scale IT initiatives for Fortune 500 companies. Authored, designed and delivered a custom Data Warehouse training class for one of his large clients. As a key member of Cap Gemini's DW team, received training in CGA DW and PM methodologies.
