Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sharan Kalashikam

Austin

Summary

Results-driven IT Professional with a progressive background in Data Architecture, ETL, Business Intelligence, and Data Analysis initiatives. Proficient in database structures, theories, and practices. Known for exceptional problem-solving abilities and analytical skills. Experienced in various stages of the Software Development Life Cycle (SDLC), including requirements gathering, design, implementation, and testing.

Overview

11
11
years of professional experience

Work History

Sr. Data Engineer

Centene
08.2023 - Current
  • Company Overview: The Milliman Health Cost Guidelines (HCG) Grouper processes medical claims, pharmaceutical claims, and member eligibility data using the Milliman HCG categorization and utilization counting methodology
  • HCG Standard Categorization and utilization counting allows straightforward comparisons to Milliman benchmarks and consistent comparisons for various sub-populations
  • Led the development of Teradata Stored Procedures, Tables and Views for extracting complex Medical Claims, Pharmacy, and Member data from the Enterprise Data Warehouse (EDW) for seamless HCG Grouper processing
  • Innovated Informatica workflows with Teradata Parallel Transporter Connections, achieving a throughput of 37,000 records transferred per second and enhancing data flow efficiency
  • Created SSIS Packages to execute third party HCG Grouper tool, assigning MR Lines to Medical/Pharmaceutical claims, aiding claim type and health cost category classification
  • Orchestrated deployment of SSIS packages into SSIDB Catalog, ensuring smooth execution and management of Grouper tool
  • Utilized Python to build automated reports, replacing legacy Microstrategy for the Milliman Application, which improved report maintenance and reduced overhead
  • Implemented Python Scripts to dynamically retrieve passwords from cyberark safe, facilitating secure and automated logins for ETL processes executed via Control - M
  • Implemented DMRs within BTEQ scripts for SQL updates, leading to well-categorized data in final EDW tables, bolstering auditing capabilities and user activity tracking
  • The Milliman Health Cost Guidelines (HCG) Grouper processes medical claims, pharmaceutical claims, and member eligibility data using the Milliman HCG categorization and utilization counting methodology
  • HCG Standard Categorization and utilization counting allows straightforward comparisons to Milliman benchmarks and consistent comparisons for various sub-populations

Sr. Data Engineer

Cigna
01.2022 - 06.2023
  • Company Overview: The primary goal of CRM is to enhance customer engagement through multi-channel communications, leveraging email, letters, phone calls, and texts for healthcare benefit programs, appointment scheduling, health checkups, and various medical services
  • Architectured and executed targeted campaigns using Teradata CIM Tool (Customer Interaction Manager) across diverse categories including Behavioral, Autism, and Hearing Impairment
  • These campaigns facilitated personalized customer outreach
  • Engineered opportunities and interactions using Teradata stored procedures, BTEQ Scripts, tables/views, effectively stored within the Enterprise Data Warehouse (EDW)
  • Leveraged Teradata Parallel Transporter and Stored Procedures to extract and transform data, ensuring alignment with business requirements
  • Proficiently utilized Metadata Administration Utility (MAU) to establish campaign-specific views integrated into CIM Tool for efficient data utilization
  • Led the offshore team, defining technical requirements and comprehensive business documentation
  • Ensured timely achievement of quarterly deliverables, strictly adhering to SLA timelines
  • Pioneered a DEMO project and delivered an insightful presentation on AWS Glue, introducing this innovative tool to the organization
  • Implemented robust code management and deployment practices using GIT, guaranteeing synchronization across development, integration, and production environments
  • The primary goal of CRM is to enhance customer engagement through multi-channel communications, leveraging email, letters, phone calls, and texts for healthcare benefit programs, appointment scheduling, health checkups, and various medical services

Sr. Performance Engineer

Cigna
08.2021 - 12.2021
  • Reshaped the landscape of legacy Stored Procedures, Views, and Tables which previously exhibited resource-intensive behavior, driving up CPU usage and impacting downstream processes
  • Expertly reconstructed intricate queries while meticulously evaluating their performance through Teradata's explain plan, thereby mitigating query skews
  • Ingeniously harnessed Global Temporary Tables (GTTs) and Volatile Tables (VTs) to optimize resource and space consumption, effectively addressing spool space challenges
  • Maintained a dynamic collaboration with administrators and vendor teams to continuously fine-tune performance engineering strategies
  • Employed Teradata Viewpoint to holistically assess the rewritten queries, gauging critical metrics like CPU usage, individual query run times, skew percentages, and Product Join Index (PJI) influence
  • Automated validation workflows using Tidal Enterprise Scheduler, orchestrating the execution of BTEQ scripts and routing resource-intensive queries for evaluation by designated stakeholders

Sr. Application Software Engineer

Centene
04.2017 - 07.2021
  • Company Overview: The primary function of the Revenue Analytics department is to manage the reconciliation of remittance data and eligibility (member enrollment) data, which is sourced in the enterprise data warehouse
  • This is an integral part of providing input for determining the monthly Health Benefit Ratio (HBR) during month end close which is used to measure Centene's financial performance
  • In this way, the department provides month end support for accounting
  • Orchestrated full SDLC engagement, managing projects such as Revenue Reconciliation, Encounters, and HBR from requirements to testing, ensuring alignment with dynamic business needs
  • Collaborated cross-functionality with management, design, development, and operations teams to refine requirements, guide implementation, and enhance reporting applications
  • Crafted, optimized, and maintained Stored Procedures of data extraction, transformation, and loading across Teradata, SQL Server, and Informatica platforms
  • Engineered robust data processing procedures for diverse dimensions (Claims, Pharmacy, Encounters, Provider, Eligibility), utilizing complex SQL queries to derive actionable insights
  • Led optimization efforts using Volatile tables, Derived tables, and Global Temporary Tables (GTT), enhancing system efficiency and query performance
  • Automated ETL jobs with Control-M Scheduling Tool, ensuring data processing aligned with dynamic business needs and implementing rigorous testing for seamless system operation
  • The primary function of the Revenue Analytics department is to manage the reconciliation of remittance data and eligibility (member enrollment) data, which is sourced in the enterprise data warehouse
  • This is an integral part of providing input for determining the monthly Health Benefit Ratio (HBR) during month end close which is used to measure Centene's financial performance
  • In this way, the department provides month end support for accounting

ETL Consultant

Arka Technologies Inc
10.2015 - 10.2016
  • Orchestrated end-to-end project execution, spanning requirements gathering, system design, development, deployment, maintenance, and support
  • Crafted logical and physical data models
  • Optimizing data processing performance
  • Developed complex SQL queries, leveraging Teradata Joins, Stored Procedures, and Macros for valuable data insights
  • Implemented query optimization techniques (Explain plans, Collect statistics, Index management) for improved report and SQL query performance
  • Designed ETL processes, documented data mapping, and utilized Power Center Designer tools for seamless data migration
  • Managed code, requirements, and deployments using TFS

SQL Developer

MindTree
01.2014 - 04.2015
  • Collaborated with business analysts to understand requirements and translate them into effective database solutions
  • Developed and improved Stored Procedures, Tables, and Views to match business needs
  • Translated SQL Server stored procedures to PL/SQL in Oracle, ensuring cross-platform compatibility
  • Optimized SQL queries for improved data retrieval and manipulation performance
  • Ensured report accuracy through rigorous data quality checks and verification processes

Education

Master of Science - Information Systems Security

University of The Cumberlands
01.2021

Master of Science -

University of Illinois

Bachelor of Technology - Electronics and Communication Engineering

JNTU
01.2015

Skills

  • SQL Server 2012/2014
  • Teradata 14/15
  • Oracle 11g/10g
  • SSIS
  • Informatica
  • SQL Loader
  • Fast Load
  • Multi Load
  • BTEQ
  • SQL Profiler
  • Teradata SQL Assistant
  • SSMS
  • TOAD
  • SQL Navigator
  • Express Studio
  • View Point
  • PL/SQL
  • IDMC
  • AWS
  • S3
  • GLUE
  • UNIX Shell Scripting
  • C#
  • C
  • C
  • NET Framework 45
  • PHP
  • Python
  • Tortoise SVN
  • GitHub
  • TFS
  • TIDAL
  • Control-M
  • UNIX
  • Sun Solaris
  • HP UX
  • Linux
  • Windows 2008/R2
  • Agile development methodologies
  • Project documentation
  • Testing
  • Debugging
  • Deployment
  • Business Objects
  • Data analysis
  • Data processing
  • Data transfer
  • Data migration
  • Data warehousing
  • Business intelligence
  • Data modeling
  • Reporting
  • HTML
  • XML
  • VS Code
  • Excel Macros
  • Python programming
  • ETL development
  • Git version control
  • Advanced SQL
  • Data security
  • SQL programming

Timeline

Sr. Data Engineer

Centene
08.2023 - Current

Sr. Data Engineer

Cigna
01.2022 - 06.2023

Sr. Performance Engineer

Cigna
08.2021 - 12.2021

Sr. Application Software Engineer

Centene
04.2017 - 07.2021

ETL Consultant

Arka Technologies Inc
10.2015 - 10.2016

SQL Developer

MindTree
01.2014 - 04.2015

Master of Science -

University of Illinois

Bachelor of Technology - Electronics and Communication Engineering

JNTU

Master of Science - Information Systems Security

University of The Cumberlands

Similar Profiles

CREATE PROFILE
Sharan Kalashikam