Summary
Overview
Work History
Education
Skills
Education Certifications
Technical Skills
Selected Achievements
Timeline
Generic

Lakshmi Thotakura

Austin

Summary

23+ years of expertise in enterprise data architecture and BI solution delivery for government healthcare, Medicaid, and social programs Proven leader of globally distributed BI and analytics teams (10–20 members), delivering EDW and analytics for multi-state systems Deep expertise in Snowflake, AWS, Cognos, Tableau, Power BI, Informatica, SQL Server, and Oracle Track record of delivering $20M+ projects with stakeholder satisfaction, data quality assurance, and agile execution Known for aligning BI strategy with business goals to drive data-informed decisions and policy insights

Overview

25
25
years of professional experience

Work History

Practice Area Lead

IBM
05.2016 - Current
  • Practice Leader –BI and Advanced Analytics Practice responsible for the development and oversight of standard process and best practices for BI Application implementation of the SDLC in delivery vertical.
  • People manager/Coach of BI and analytics team.
  • Provide BI Solution Architecture for enterprise data warehouse solutions.

Analytics Lead

IBM
03.2024 - 03.2025

BI and Advanced Analytics Lead

IBM
11.2023 - 02.2024

BI and Advanced Analytics Migration Lead

IBM
08.2023 - 10.2023
  • Helped the team with the migration strategy for Cognos Reports to Power BI.

BI and Advanced Analytics Lead

IBM
04.2021 - 07.2023
  • West Virginia Medicaid Enterprise Data Solution (EDS) is a comprehensive set of integrated, interoperable commercial off-the-shelf (COTS) products, applied technologies, and best practices centered around a single enterprise data store and portal for data collection, organization, and analysis.
  • Solution’s robust reporting functionality provides standard and ad hoc reporting capabilities and dashboards with state-of-the art visualization features.
  • The vision for the EDS is to create and maintain a useful, objective, and comprehensive solution that can be used to promote better care, better health, and lower costs for West Virginians.
  • Leads the BI and analytics team of developers in developing and implementing successful modern BI and analytics solutions.
  • Establishes the standards for the development of the solution.
  • Architects, designs, develops and leads the development of BI solution.
  • Participates with the Business Analysts, Analytic consultants in reviewing the requirement about the designing of data marts, metadata layer, adhoc user query platform and development of reports and Dashboards.
  • Reviews the unit test of the code and moving to test environment.
  • Documentation of Technical design requirements and reviewing with the development team for mapping the data elements required to build the metadata layer.
  • Coordinates with the client team, Data Architecture, project manager business analyst and testing teams in relation with the BI solution.
  • Guides the Report Specification Documents and reviews the technical specifications for the development of reports and dashboards.
  • Conducts peer review of the Business and Technical requirements documents.
  • Collaborates with test leads in reviewing test cases and creation of data to complete the testing in test environment before sending to business users.
  • Ensure accuracy of delivered reports and conformity to SLAs.
  • Analyzes data questions and issues as they arise and drives the optimal solutions.
  • Work with Business and Technology teams to propose solutions and provide strategic direction.
  • Work with Business Teams and Technology teams to prioritize on-going BI demands.

BI and Advanced Analytics Lead and Data Architect

IBM Consulting
11.2018 - 01.2021
  • New Mexico Data Services (NMDS) solution aggregates Medicaid and other agency data to create comprehensive views of New Mexico’s HHS programs and moves to a more client-centric model.
  • The key benefits will positively impact every aspect of your program, from policy decisions to business process improvements, and that we have highlighted throughout our response.
  • Designed the architecture for the implementation of BI solution for Human Health Services Department of New Mexico.
  • Worked with Datawarehouse Lead to produce Business Architecture design payment deliverable document.
  • Assisted Delivery Lead with Level of Estimation for BI and Architecture tasks for making decisions on resource and capacity planning.
  • Implemented standards in accordance with the BI Practice Area, implemented processes for delivering EDW and modern BI and analytics solutions.
  • Conducted Lunch and learn sessions with the cross teams to about the BI and analytics implementation strategies and standards.
  • Lead Business User Group awareness presentations about the EDW and modern BI and analytics solutions.
  • Successfully established stakeholder client group relations.
  • Contributed to risk identification, evaluation and mitigation activities related to data architecture and modern BI and analytics solutions.
  • Conducted Cognos and Tableau Training for 120 State users.

BI and Advanced Analytics Lead

IBM
01.2018 - 05.2019
  • The Developmental Services Consolidated Information System (DSCIS) is a provincial database and the authoritative source for collecting, managing, and reporting Development Services (DS) sector client information powered by IBM Cúram.
  • IBM provided services, tools, and support to reengineer the client’s environmental procedures and programs from data acquisition to report delivery.
  • The result was a modern, scalable analytic system that delivers a cross-ministry common enterprise data warehouse aligned for intelligent data insights.
  • Held a crucial role as a BI Lead and as a subject matter expert with Social programs.
  • She was accountable for the design, development, and implementation of BI solution for the government Agency.
  • As an architect, played a key role in the project for matters related to the design, development, and implementation of the BI solution.
  • Participated in the requirement gathering with Business Analysts and SME to understand business needs and help define requirements for reporting solutions.
  • Led the BI and analytics team of developers and mentored new team members.
  • Coordinated the development team to ensure that deliverables were met on time.
  • Showcased the BI work at the end of each iteration following the agile implementation processes.
  • Developed and unit tested Reports and Dashboards.
  • Conducted design and implementation peer reviews.

Data Architect, Information Architect

IBM
06.2016 - 12.2017
  • Served as BI Architect and Developer for the State of Delaware.
  • Created multiple enhancements to the Reports and Framework manager models.
  • Lead the offshore team, in the development of Reports and testing.
  • Worked as Data Architect in the team for the State of Texas EDW/BI Contract.

BI Reports and Analytics Manager

Accenture
Austin
11.2013 - 05.2016
  • Designed the overall BI and analytics architecture to meet business requirements and goals.
  • Create a blueprint for data integration, and reporting system for the Foster Care capacity needs.
  • Developed and enforced federal rules and policies, including data quality, data lineage, and data security while designing the solution.
  • Worked with the Title IV-E eligibility rate report design and development.
  • Defined the framework for data analytics, including the use of advanced analytics.

BI Analytics Delivery Manager

Accenture
Austin
03.2013 - 05.2016
  • As a BI and Analytics manager at Ohio IE project, I was responsible for $20 million worth of deliverables for this state of Ohio IE project.
  • Lead the customer focus business representation team of 20 people.
  • Worked the development and implementation of Integrated Eligibility Product named Accenture Benefit Management system to enroll eligible client population.
  • Identified business priorities on MDM subject areas.
  • Translated business requirements to technical implementation.
  • Architected the design and implemented Master Client Index (MCI) using Informatica MDM solution.
  • Data governance & quality strategy were delivered.
  • Worked extensively with external Business clients, counterparts to design customizations and conversion of Integrated Eligibility project.
  • Designed the architecture to build robust solution to convert 40 years of legacy Medicaid Eligibility data into new IE system.
  • Lead the development team in Austin location to build ETL solutions and BI reports.
  • Conducted UAT sessions with business customers and county workers to release complex eligibility components into production.
  • Worked with designers and business architects to come up with the right balance of changes that are needed in each of the IE applications to ensure that the project is being aligned with the key architectural guidelines and meet the long-term goals.

Enterprise Information Solution Architect

Accenture
Austin
11.2005 - 02.2013
  • During the tenure of 7+ years at TMHP, I worked on various diversified projects with Texas Medicaid Enterprise Datawarehouse team.
  • Some of the key projects are: NPI Remediation for encounters: Provided architecture, data model and design for Encounters Provider Model and NPI Remediation.
  • Performed analysis for the implementation of NPI remediation for encounters data.
  • Encounters Data Warehouse: Created conceptual design model for Department of State Health Services & Contingency Fee Contractor Services.
  • Developed technical design for DSHS&CFC Final Extract.
  • Built aggregate data model for MCO Reporting System by merging data from different source systems such as claims and encounters.
  • AHQP Data mart – played a key role in building AHQP ETL Cycle enhancements and AHQP Universe updates.
  • Expertise includes in providing the design solutions and building the universes for querying the ad hoc platform and produce canned reports.
  • Well versed with AHQP, MARS, Dispro and Encounters Full picture, Best Picture, Rate setting, OAG, Member and Provider Universes.
  • Mapping Tables Data mart: Created data models and lead the initiative to design and develop a unique interface to load and query the data by Health and Human Service Commission (HHSC) users into data warehouse.
  • Responsible for all activities related to the logical architecture of data, metadata, and its lifecycle from data entry into the organization, usage, persistence and exit from the organization.
  • Extensive query optimization and scalability are the key success factors of this project.
  • Used SQL Profiler, Execution Plans, Performance Monitoring and DBCC Commands to improve performance.
  • Waiver Reporting: Lead the team to develop highly complex reporting system for Department of Aging and Disability Services (DADS).
  • Designed logical/physical data models for the waiver data sheets.
  • Developed architecture and implemented solution for the waiver reports.
  • Provided high level design, detail designs and development Plans for the waiver reporting requirements.
  • Integrated multiple source systems – acute care, long term Care, vendor drug data into SQL Server CDS Database.
  • Dental Provider Extract: Provided Architecture and designed solution to merge data from Medicaid and CHIP Data sources to generate a common extract to uploaded files to CMS - Insure Kids Now.gov.
  • American Recovery and Reinvestment Act Reports: Designed high level process for ARRA data extraction process.
  • Created high level design and development plan and architecture of the reports.
  • Worked on MFADS and MSIS outbound extracts consisting of encounters and claims data.

Enterprise Data Architect

GE Oil & Gas
Houston
05.2005 - 10.2005
  • Lead the offshore and onsite team in implementing solutions for undertakings successfully with the Global Delivery model.
  • Designed the architecture and created physical/logical and conceptual models to build ETL and more than 50 enterprise-wide reports of GE Security for the Higher Management like CEO/CIO Groups.
  • Worked on the Architecture and design of BI and Advanced Analytics model for the different types of Businesses within GE Security like - Order Fulfillment, Sales, Network Solutions, and Daily Positions etc.
  • Involved with requirements gathering, Functional & Technical specifications.

Data warehouse Architect

Federal Home Loan Bank
Atlanta
06.2004 - 04.2005
  • Designed and lead the development of Financial Management Reporting System.
  • Fostered Data Management and Architecture.
  • Promoted data integrity and reuse at all levels.
  • Designed Enterprise Logical (3 NF Relational) and physical models (Dimensional).
  • Implemented Data Architecture, Data Governance & Data quality process.
  • Proposed and created Master Data Management Initiative and roadmap.
  • This project improved the efficiency of the overall Banking functionality by 40%.

EDW Developer

GE Power Systems
Atlanta
02.2001 - 05.2004
  • Developed Complex transformations, Mapplets using Informatica to Extract, Transform and load data into Data marts, Central Data warehouse.
  • Designed and created the Facts and Dimension tables.
  • Set up batches and sessions to schedule the loads at regular intervals.
  • Created around 30 B.O. Universes specific to each Business initiatives.
  • Created Data Specification documents required for corporate business reports.
  • Generated different kinds of advanced reports for different user groups using BO, WEBI.
  • Some of the core projects worked here are Handheld Receiving Project, Management Information Tracking Tool (MITT).

Technical Programmer

Princeton Insurance Co
NJ
08.2000 - 01.2001
  • Company Overview: Princeton Insurance is New Jersey's leading healthcare liability insurer, continuously protecting the assets and reputations of the New Jersey healthcare community.
  • Built PL/SQL procedures for Reports.
  • Worked with user requirement gathering and analysis.
  • Built interfaces of various third-party systems to the Oracle Suite of applications which included accounts receivables in a healthcare setting.
  • Created reports including CPT and ICD coding, HCPCS, modifiers, coding, and documentation guidelines.
  • Princeton Insurance is New Jersey's leading healthcare liability insurer, continuously protecting the assets and reputations of the New Jersey healthcare community.

Education

MBA - Information systems management and Finance

Osmania University
India
01.2000

Skills

  • Power BI
  • Tableau
  • Cognos
  • SAS
  • Business Objects
  • Informatica
  • Data Services
  • SQL
  • T-SQL
  • PL/SQL
  • Snowflake
  • Oracle
  • SQL Server
  • AWS
  • NonStop/Tandem
  • Dimensional
  • Data Vault
  • 3NF
  • Erwin
  • Sparx
  • Agile
  • Waterfall
  • Hybrid Project Management
  • EDW Architecture
  • Governance
  • Stakeholder Engagement
  • Team Coaching
  • SLA Management
  • QA
  • Data Integrity
  • Cognos analytics
  • NonStop /Tandem
  • TACL
  • XML
  • C
  • C
  • Data Integrator
  • Oracle Applications
  • Visio
  • Maximo 411
  • UNIX
  • Windows
  • Windows NT
  • Citrix

Education Certifications

  • MBA, Information Systems Management & Finance, Osmania University, India, 2000
  • Pursuing Post Graduate Program in Artificial Intelligence for Leaders at University of Texas,Austin

Technical Skills

Power BI, Tableau, Cognos, SAS, Business Objects, Informatica, Data Services, SQL, T-SQL, PL/SQL, Snowflake, Oracle, SQL Server, AWS, NonStop/Tandem, Dimensional, Data Vault, 3NF (Erwin, Sparx)

Selected Achievements

  • Delivered a $20M BI program for Ohio Medicaid, leading a 20-person team across eligibility and analytics modules.
  • Architected and migrated 400+ legacy Cognos reports to Power BI for the State of Texas.
  • Trained 120+ users and improved dashboard adoption by 75% through data literacy sessions.
  • Reduced report turnaround time by 40% via optimized Snowflake pipelines and QA automation.
  • Ensured 99.9% SLA adherence for 1,000+ reports across state health and social programs.

Timeline

Analytics Lead

IBM
03.2024 - 03.2025

BI and Advanced Analytics Lead

IBM
11.2023 - 02.2024

BI and Advanced Analytics Migration Lead

IBM
08.2023 - 10.2023

BI and Advanced Analytics Lead

IBM
04.2021 - 07.2023

BI and Advanced Analytics Lead and Data Architect

IBM Consulting
11.2018 - 01.2021

BI and Advanced Analytics Lead

IBM
01.2018 - 05.2019

Data Architect, Information Architect

IBM
06.2016 - 12.2017

Practice Area Lead

IBM
05.2016 - Current

BI Reports and Analytics Manager

Accenture
11.2013 - 05.2016

BI Analytics Delivery Manager

Accenture
03.2013 - 05.2016

Enterprise Information Solution Architect

Accenture
11.2005 - 02.2013

Enterprise Data Architect

GE Oil & Gas
05.2005 - 10.2005

Data warehouse Architect

Federal Home Loan Bank
06.2004 - 04.2005

EDW Developer

GE Power Systems
02.2001 - 05.2004

Technical Programmer

Princeton Insurance Co
08.2000 - 01.2001

MBA - Information systems management and Finance

Osmania University

Similar Profiles

CREATE PROFILE
Lakshmi Thotakura