Sravan Pala
Lead Data Analytics Engineer
Leander,TX
Summary
Certified Advance Programmer Lead Data Analytics/Data Engineer with over 12 years of experience in designing and implementing data solutions. Expertise in big data technologies, data warehousing, and ETL processes. Proven track record of leading teams to deliver high-impact data projects. Adept at optimizing data architectures to support analytics and business intelligence initiatives.
Overview
9
9
years of professional experience
1
1
year of post-secondary education
Work History
Data Analytics Lead
Highmark Health
2022.10 - Current
- M360 provide central repository of contact information for organization consumers-members as well as prospects
- Worked on building new DI jobs to extract, transform and load new data source to M360
- Worked on Analyzing existing MDM Process based on Data quality issues reported by users
- Identified some tuning/adjustments are required on existing Cluster rules, case sensitivity and additional conditions need to be added to MDM Nodes
- Design and implement scalable data pipelines and ETL processes through Python
- Developed real-time data streaming solutions using Kafka
- Designed and maintained data warehouse on Google Big Query, enabling efficient data querying and reporting.
Senior SAS Developer/Technical Lead
Element Technologies Inc
2018.06 - 2022.09
- SAS AML is Huntington Bank’s Primary System for identifying potentially Fraud and suspicious activity
- Developed Scenarios and run against Huntington’s customer, account, and transactional data to identify suspicious behavior
- Worked on Migrations of all scenarios and Data to SAS AML 7.1
- Created SAS MDM batch jobs, entity matching and entity linking through relationships
- Worked on supporting and enhancing complex python framework which automates complex Model Management Batch Process
- Created different batch process to send Data to LASR for generating VAAR Reports in 7.1 SASAML
- Worked on Optimizing some Data management codes and made them run efficiently.
- Troubleshot and resolved complex issues with existing SAS programs, maintaining uninterrupted workflow for end users
Senior SAS Developer/Technical Lead
Element Technologies Inc
2017.12 - 2018.05
- Worked as HEDIS Operation Analyst in Operation and Maintenance and Medical Quality Applications Team
- Working on Creating SSIS Packages by Merging, Formatting and loading Supplemental Data to test server
- Created Automated packages for loading files, Running SQL Codes and Extracting t files for HEDIS Measures
- Responsible for quantity and quality of data used in HEDIS reporting
- Used SQL code to generate reports and performs ETL process (data loading, validation)
- Monitors and manages data feeds into data warehouse as well as extraction transformation and loading to analytical database
- Involved in SME for Monthly HEDIS Production cycle for assigned plans.
SAS Developer
Element Technologies Inc
2016.05 - 2017.11
- Used Tableau and SAS tool to execute financial model measuring risk and return to repeat payday loan transactions for internet-based lending as well as Retail (storefront) channels
- Developed Score cards for Online Portfolio and Monitored Loss and Retention rates for Retail Loans
- Used VBA for developing codes within excel to develop macros for populating Data in report
- Making changes in Underwriting Portal for each product based on their Performance
- Maintained Metadata Analysis for Nine Servers and Schedule to run them on Task Scheduler
- Worked on ADW and Underwriting Database with clear understanding of different data like Loans, Collection, Customers, Location and Transaction data
- Worked closely with Plan controls to Balance risk/return on new products offered in alternative.
SAS Developer
Element Technologies Inc
2015.01 - 2016.04
- Worked as a BI developer in Decision Support Informatics (DSI) and Enterprise project office (EPO) teams
- Worked with quality improvement, Claims and other operational business owners to maintain accuracy of HEDIS data
- Responsible for sending the files to Operational team for running and utilizing Care analyzer (NCQA Certified Software) to obtain HEDIS measure rates for monthly and annual reporting to management
- Ensure HEDIS data is submitted both timely and accurate to NCQA
- Responsible for maintaining SAS datasets in Analytical Data view (ADV) which are extensively utilized for reporting and analytical purposes by various departments across the company
- Worked on FACETS and Care Advance data with a sound knowledge and clear understanding of claim data, provider data, pharmacy data etc.
SAS Developer
Kdpl
2011.06 - 8 2013
- Created new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update and conditional statements
- Conducted Data Requirement Analysis, designed technical specifications and Data mapping sheets to meet business rules and data extraction ETL process by looking at metadata to know dependencies and joins between different tables in warehouse for leveraging execution time and SQL performance tuning
- Working with SAS Enterprise Business Intelligence Server (SAS/EBI) and SAS Information Map Studio
- Generating demographic tables, adverse events and serious adverse events reports
- Involved in multiple projects and interacted with other SAS programmers, statisticians and data managers to analyze data.
Education
Certified Base SAS Programmer for SAS 9 -
SAS Institute
Certified Advance SAS Programmer for SAS 9 -
SAS Institute
Master of Science -
Texas A&M University-Kingsville, USA
Kingsville, TX 2013.01 - 2014.05
Skills
- Programming Languages: Python, SAS, SQL, R, Unix shell
- Big Data Technologies: Hadoop, Kafka, Hive
- Databases: Oracle, MySQL, PostgreSQL, Teradata, DB2
- ETL Tools: SSIS, SAS DI, Informatica
- Data Warehousing: Google Big Query, Snowflake
- Cloud Platforms: Azure, Google Cloud Platform (GCP)
Data Visualization: SASEG, MDM (Data Flux), VA, Tableau, Business Intelligence (SSRS/BI), Putty
- DevOps: Jenkins, Git, Kubernetes, Git Lab
Timeline
Data Analytics Lead
Highmark Health
2022.10 - Current
Senior SAS Developer/Technical Lead
Element Technologies Inc
2018.06 - 2022.09
Senior SAS Developer/Technical Lead
Element Technologies Inc
2017.12 - 2018.05
SAS Developer
Element Technologies Inc
2016.05 - 2017.11
SAS Developer
Element Technologies Inc
2015.01 - 2016.04
Master of Science -
Texas A&M University-Kingsville, USA
2013.01 - 2014.05
SAS Developer
Kdpl
2011.06 - 8 2013
Certified Base SAS Programmer for SAS 9 -
SAS Institute
Certified Advance SAS Programmer for SAS 9 -
SAS Institute
Similar Profiles
Katharine CleggKatharine Clegg
Medical Records Specialist at Highmark HealthMedical Records Specialist at Highmark Health
Narasimhan SaiganeshNarasimhan Saiganesh
Director, IT at Highmark HealthDirector, IT at Highmark Health
Donna BolognaDonna Bologna
Director, Talent Engagement - Business Partner at Highmark HealthDirector, Talent Engagement - Business Partner at Highmark Health