Learn Data Skills
Beta
Preetham Duvva

Preetham Duvva

Tech Lead Business Intelligence

LA Care

Technologies

My Portfolio Highlights

My New Course

Introduction to Tableau

Analytical wordsmith, crafting stories with data as the pen and curiosity as the ink.

My Work

Take a look at my latest work.

course

Introduction to Tableau

course

Communicating Data Insights

course

Data Storytelling Concepts

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Makers | Jul 2023 - Dec 2023

Strategy Consultant

Responsibilities include program management conducting market research and driving recommendations for U.S. market entry. • Conducted comprehensive consumer research utilizing advanced methodologies for survey design and tools to analyze market trends, consumer behavior, and competitive landscapes, resulting in over 100 interviews. • Delivered a compelling go-to-market strategy through synthesis of survey data and conjoint studies. • Utilized strong product marketing skills to identify trends, forecast demand, and propose recommendations to the client.
Show More

L.A. Care Health Plan | Jan 2018 - Nov 2023

Technical Lead - BI / Enterprise Data

Played a key role in leading the efforts of building business intelligence solutions and implementing end user reporting solutions.

L.A. Care Health Plan | Apr 2015 - Jan 2018

Senior Business Intelligence Developer

Develop strategic solutions for extracting member eligibility (834) and claims (837) from QNXT application to different plan partners and trading partners.

L.A. Care Health Plan | Jun 2014 - Apr 2015

Senior BI Consultant/BI Report Developer

Provide an optimized reporting solution using SSRS and BI Publisher for core system applications such as QNXT.

Hewlett-Packard | Mar 2014 - Jun 2014

Senior Consultant/Solution Development Lead (Reporting) @ GDS

GDS Cloud Showback/Chargeback Dashboard •Played a key role in the design, development and implementation of Strategic and Analytical Business Intelligence Reports/scorecards using QlikView for the GDS Cloud Showback dashboard project. •Integrated the GDS Cloud Showback Dashboard with the GDS cloud portal . •Responsible for maintenance, deployment and security of the dashboard.

Hewlett-Packard | Feb 2013 - Mar 2014

Senior Consultant/SLA Reporting Engineer @ ES IT

• Designed complex QlikView reports using various functionality to meet the business needs. • Employed complex formulas and expressions in the various tables/charts across the report to provide optimum business solutions through QlikView. • Worked extensively on different Qlikview features like linked objects, Associative search, Mekko charts, etc. • Unit Testing and Performance Tuning of the QlikView reports in order to reduce the execution time required for generating these reports and thereby improving the overall speed of execution and performance of the reports. • Maintained the security of the QlikView accesspoint for Dev/ITG(Testing)/ Prod via the User Access Management portal. • Developed various web-based data capture screens as a part of the reporting solution for account teams to submit actual service level performance data. • Created complex stored procedures/ views for reporting purposes and also worked on various optimizing techniques. • Worked on the data migration techniques using SQL Server Integration Services (SSIS) to obtain data from multiple SQL sources to load into SLA reporting databases. • Worked extensively on the performance tuning of the databases to ensure optimal reporting user experience. • Strong understanding of modern software development tools and Software Configuration Management (SCM). • Strong understanding of basic database administration and software test methodologies. • Good verbal and written skills and also ability to work effectively in the team.

Insurance Auto Auctions | Sep 2011 - Jan 2013

BI Consultant/ BI Developer

• Developed complex stored procedures to perform data migration to help ETL process using change data capture method. • Designed a master SSIS package to trigger the stored procedures in order to perform the Daily incremental ETL load. • Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler. • Developed complex queries to run historical load from a linked server using dynamic SQL. • Designed various dimensions and fact tables in order to build OLAP cubes using appropriate dimension usage. • Designed and built data aggregations and partitions in order to enhance the performance of the cubes and also to help in the ongoing data analysis and reporting using SQL Server Analysis Services. • Designed perspectives as per the business requirements and generated report models to build ad hoc reporting inter face for the business users. • Developed a master SSIS package to run the daily load of analysis services to enhance parallel processing of the cubes and dimensions. • Developed various reports which include drill down reports, drill through repots, cascaded parameterized reports, matrix reports using SSRS in share point integrated mode. • Worked on querying the data and creating-on demand reports using Report Builder in SSRS and also responsible to set up report subscriptions and deploy them to share point server. • Worked in the conversion and migration of canned reports in Business Objects to re design them using SQL Server Reporting Services. • Responsible in providing prompt and highly efficient support of on demand requests to the QA testing and UAT testing in an agile methodology environment.

Accenture | Mar 2011 - Sep 2011

BI Consultant/ Report Developer

• Worked with the functional team to gather the requirements from business users for designing various types of reports as per the business needs. • Advanced extensible reporting skills using SQL Server 2008/2005 Reporting Services. • Developed various types of complex reports like Drill Down, Drill through, Cross tab reports using SSRS 2005/2008 and Office Writer. • Involved in scheduling, creating snapshots, creating report subscriptions and data driven subscriptions using SSRS 2008. • Deployed the reports to the report server to access it through the report manager and made sure the reports were available from the front end of the myTE application. • Expertly handled the performance tuning of critical reports and also managed security model of the reports. • Created and executed SSIS packages to populate data from myTE data source and load it onto the server. • Created complex packages for different data loading operations for myTE application. • Experienced in writing complex SQL queries, stored procedures, triggers, views, constraints, joins, DDL, DML and user defined functions to implement the business logic. • Advised the optimization of the queries by looking at the execution plan for better tuning of the database. • Involved in optimizing code and improving efficiency in databases including re creating clustered and non clustered indexes, updating statistics, recompiling stored procedures and performing other maintenance tasks. • Developed complex T-SQL Queries and Dynamic SQL Queries for reports on Enterprise Data Warehouse (OLAP) and Operational databases (OLTP) and developed reports using Global Variables, Expressions and Functions.

My Education

Take a look at my formal education

Master of Business Administration - MBA  in BUSINESS ADMINISTRATION (MBA)UCLA Anderson School of Management | 2024
Master's degree, Electrical and Electronics Engineering in Electrical EngineeringCalifornia State University-Sacramento | 2010
Bachelor of Technology - BTech, Electrical and Electronics Engineering in Electrical EngineeringVNR Vignanajyothi Institute of Engineering & Technology | 2008

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free