Hello! I’m Rahul Tyagi
SQL Developer | Senior Data Engineer | Business Intelligence Developer
Bio
Graduated from Northeastern University with a Masters Degree in the field of Data Analytics. I am currently working as a Business intelligence Developer at P3 Healthcare Partners, Nevada. I am mainly responsible for developing enterprise business intelligence solutions for my organization with the help of latest technology available in the healthcare sector. I have experience of creating enterprise data warehouse solutions to provide seamless and state of the art data flow. I have experience in developing BI reports for data analysis and Conducted quantitative analyses on available metrics and briefed senior leadership, enabling them to improve analytical products to maximize visibility and usefulness to the community.
I have also worked as a Data Science intern in line-vision where I was responsible for developing algorithms for dynamic line rating and prepared statistical models for analyzing the weather data, implemented SQL queries and procedures, developed application for prediction analysis. I am proficient in R Language and have experience in developing Analytical applications with R using shiny package.
An Experienced Project Analyst and Quality Analyst with a demonstrated history of working in statistical data analyzation with hands-on experience of Working on relational databases.
Experience of working on complex SQL queries using PostgreSQL and interacted with the AWS platform for database designing and warehousing. Expert in pandas, NumPy, matplotlib for visualizing the data and produced valuable insights about the data pattern, trends and helping organizations in successfully completing their business objectives, improving their marketing strategies, and provided them with recommendations for increasing their
market growth upto 25%.
Used Python Libraries SciPy, Scikit-learn for applying machine learning algorithms like linear regression, Principal component analysis and applied machine learning algorithms and techniques while Working on Projects with Airbnb, Fitbit and Line-vision ( A boston based energy utility company). And helped them in completing their projects with the most effective and efficient way possible.
I have hands on experience and knowledge of working ETL practices and business intelligence. I have worked in SSIS for data integrations and extraction. I have Deep understanding of Microsoft Excel and data visualization tools like tableau, Power BI. I was involved in quality assurance and have working experience in statistical data analyzation for planning and implementing daily metrics and analysis. I think I can be a game changer for your company.
ETL Developer with experience of working in different sectors like manufacturing, Healthcare, Energy sector and developed models and algorithms for business purposes and to complete my organizations objectives as and when required.
Skilled in Microsoft Office, Statistical quality control, Mat-lab, Analytical and Creative Mind, MySQL, SPSS, Tableau, Advance statistics for Engineers, Quantitative analysis SAS, Toad data modeler, STATA, Problem solver, Team player, Detail oriented, Machine learning Algorithms.
Programming languages:
C, C++, JAVA, R Programming language, Python, SQL
To learn more about me, keep exploring my site or reach out directly.
Education
What I’ve Learned
Feb 2020 - May 2020
Harvard Business School ( Boston, USA)
Business Analytics Certification
Sep 2017 - June 2019
Northeastern University (Boston, USA)
Masters Degree in Data analytics Engineering
August 2011 - May 2015
Jss Academy of Technical Education (Noida, India)
Bachelor of Technology ( Mechanical Engineering)
Feb 2020 - May 2020
Wharton Business School, Pennsylvania
Artificial Intelligence for Business Certification
My Experience
Background & Expertise
Clever Care Health Plan Senior Data Analyst (Healthcare Analytics)
Nov 2022 – Present
• Lead the design and implementation of BI solutions for claims, Pharmacy data, and operational reporting, resulting in a 20% increase in data accuracy and reporting efficiency.
• Built forecasting models to predict high-risk patients and developed reports to identify potential high-cost factors.
• Created ETL data pipelines using SQL to ingest HealthPlan files, reducing external vendor costs by up to 46%.
• Conducted data analysis and predictive modeling to improve patient outcomes and reduce healthcare costs by 25%.
• Developed and implemented machine learning algorithms to identify patients at risk of developing chronic diseases.
• Designed and implemented data pipelines using Python and SQL for data integration and transformation.
• Developed BI reporting using QuickSight and PowerBI.
• Experience with big data tools: Hadoop, Spark, Python, and Talend.
Amazon, Data Engineer (Analytics and Planning)
Dec 2021 – Nov 2022
• Created complex data pipelines and interactive dashboards to support organizational data and analytics needs, reducing data latency by 25%.
• Developed internal tools for real-time data analysis using Python, SQL, QuickSight, and AWS services, improving decision-making accuracy by 50%.
• Created tables, constraints, and indexes using SQL and Python scripts for data migration from SQL Server to Amazon RDS on AWS S3 and EC2 instances.
• Collaborated with interdisciplinary teams to design and implement data-driven solutions.
• Maintained databases to ensure data accuracy and integrity
P3 Health Partners, Nevada ( Business Intelligence Developer)
Sept 2019 - Dec 2021
-
Developed Power BI reports, key metrics for managing care management, Pharmacy for health plans to monitor critical metrics,
highlight areas of improvement, and influence marketing strategy.
• Assisted in data architecture/data modelling for relational databases using SQL, SSIS. Extracted, manipulated and provided end to end
solution to senior management for their business problem.
• Created new processes/procedures/guidelines to leverage data.
• Extensively worked on EMR, HEDIS measure and Census data for health plans and helped senior management identifying gaps in the
data and helped in removing gaps in reporting.
• Developed automation process for the data warehouse loads with the help of SSIS and Talend.
• Developed Azure Data-lake for data integration and modeling.
• Developed Specialty cost reporting for finance and economics department within healthcare sector using SQL queries and SSRS.
• Expert in writing SQL queries for database integration, designing and implementing logical and physical data models and
schemas; and performing database management.
• Talend developer with experience of developing Talend integrating jobs, building designs and architecture for mapping,
extraction of data.
Line vision (Data Science intern)
May 2018- Sep 2018
As an intern in line vision. I was responsible for performing predictive analysis and formulated algorithms for better prediction of weather data. My team successfully Developed an interactive application using shiny in R for statistical analysis and visualization. My Organization embedded our application and algorithm, in their product which is used by clients such as national grid.
Performed complex SQL queries using PostgreSQL, interacted with the AWS for database designing and warehousing. Used Python libraries like pandas, NumPy, matplotlib for visualizing the data and produced valuable insights about the data pattern, trends which helped my organization in successfully completing their business objectives more easily and efficiently.
Used Tableau to create performance dashboards for visualizing performance indicators of our predictions and models. Utilized tableau features to study statistical importance and find meaningful relations and trends which helped in taking robust business decisions. Created data pipelines for internal usage to work more efficiently. Used python and R for data wrangling and data cleaning.
Used Python Libraries SciPy, Scikit-learn for applying machine learning algorithms like linear regression, Principal component analysis for prediction of dynamic line rating and random forest to predict the conductor condition and line life expectancy, performed hypothesis testing, calculated confidence intervals which helped in getting important predictions which fulfilled our client’s objectives in the most efficient manner.
Interacted frequently with CTO, CEO to suggest methods and strategies for improving design, planning and development of business process, marketing strategies which helped organization to expand business and increase market growth up to 10%..
Worked on AWS architecture (S3, EC2), Ensured data quality and integrity in databases, Solved database usage issues.
Broadcast Engineering Consultants India Limited ( Project Analyst)
Dec 2016 - May 2017
Administered and provided the Project Management Services to build and Analyze material data using SQL Queries to improve the material inventory and reduce the cost of inventory, finances and budget.
Acquired hands on experience of working on Advance Microsoft excel, used pivot tables for data manipulation and at the same time provided data driven insights and identified potential clients with which company was able to increase its business.
Manipulated, recorded, and combined datasets using SSAS, SSIS and got promoted for my work.
Created linear regression models, ANOVA models for analysis to support business decisions. Managed a team of 5 members
Aultra Lighting Systems Limited ( Project Analyst)
June 2015 - Sep 2016
Provided executives and clients with analytical reports and helped in improving decision making strategies and marketing policies.
Provided executives and clients with analytical reports and helped in improving decision making strategies and marketing policies.
Best employee of the month award for successfully completing my target before time and for providing Ad -Hoc queries
Developed advertising KPIs and data visualization for internal usage. Build SSIS packages for providing integrating services, normalizing data and performed import/export process from BCP and ETL Process for data staging.
My Skills
What I Do
Certifications
SQL Programmer (Test-Dome Certified), Python for Data Science (IBM Certified), Data Analyst (IBM Certified), Hadoop Specialist (IBM Certified), SQL and Relational Database Specialist (IBM Certified), Google Analytics (Google Certified)
Skills
Microsoft Office, Statistical quality control, Mat-lab, Analytical and Creative Mind, MySQL, SPSS, Advance statistics for Engineers, Quantitative analysis SAS, Toad data modeler, STATA, Problem solver, Team player, Detail oriented, Machine learning algorithms, knowledge of Apache, Hadoop, Confidence interval hypothesis testing, C, C++, JAVA, R Programming language, Python.
My Projects
Work Portfolio
CMS HealthCare Project
Created data warehouse for the CMS Healthcare dataset which includes information related to physicians, teaching Hospitals and Payments related to insurance companies. linked all the different data set using a key that will help in joining them (zip-code). After that created different summary tables based on the insights retrieved after analyzing them. Visualized the summary tables which helped in decision making process.
Created Reports based on summary tables to derive insights, Patterns like problem of Medicare payments per state, Allotment of physicians based on the income groups, Spending done by the hospitals and physicians, finding patterns and ways to improve the revenue system of insurance companies. Identifying major areas which requires proper allotment of physicians based on the diseases and infection rate.
Developed summary and visualization dashboards related to spending for each episode Visits which informs us how and when are the skilled professionals appointed based on the paid HHRG (Home Health resource group- basis of payments for each episode)
Performed data analysis, star schema data modeling and design specific to data warehousing and business intelligence environment. Developed efficient SSIS packages for processing fact and dimension tables with complex transformation like type 1 and type 2 changes using slowly changing dimensions.
Used For-each loop to integrate data with 3 million rows into one staging area and performed analysis.
Optimized ETL performance to provide quickest response time possible. Created management reports with SSRS as well as SQL.
Exceptional Achievement
"The best way to predict the future is to create it"
Abraham Lincoln
