Mahadev Malladi
Senior Business Intelligence Developer at Indiana Farm Bureau Insurance- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Full professional proficiency
-
Telugu Native or bilingual proficiency
-
Hindi Limited working proficiency
Topline Score
Bio
Vadim Kovalenko
As programmer analyst Mahadev constantly showed high knowledge of currently used techniques and ability to learn new technologies. He constantly showed his interests in increasing system effectiveness by utilizing modern technology and improving efficiency of the existing applications. Mahadev is a very meticulous individual who will do anything to achieve results. He will work around the clock without hesitation and is very dedicated to the task at hand. Mahadev cares and his actions demonstrate that. While Mahadev has many excellent qualities, I most appreciate the fact that he takes ownership of problems and solutions. His willingness to learn new technologies, dive into challenges and ability to calmly solve issues that arose always surprised me. I am happy that he and I are still friends to this day and that I have had the pleasure of watching him grow as a person and as a developer.
Kevin Dillard
Mahadev had a deep understanding of both the business application and the architecture of the database warehouse. He was able to lead the creation and implementation of the analysis services provided to the business by gathering and satisfying requirements from the customer. His technical expertise of the Microsoft stack and PostgreSQL database was second to none. He was the expert and respected by all his colleagues and customers and great to work with.
Vadim Kovalenko
As programmer analyst Mahadev constantly showed high knowledge of currently used techniques and ability to learn new technologies. He constantly showed his interests in increasing system effectiveness by utilizing modern technology and improving efficiency of the existing applications. Mahadev is a very meticulous individual who will do anything to achieve results. He will work around the clock without hesitation and is very dedicated to the task at hand. Mahadev cares and his actions demonstrate that. While Mahadev has many excellent qualities, I most appreciate the fact that he takes ownership of problems and solutions. His willingness to learn new technologies, dive into challenges and ability to calmly solve issues that arose always surprised me. I am happy that he and I are still friends to this day and that I have had the pleasure of watching him grow as a person and as a developer.
Kevin Dillard
Mahadev had a deep understanding of both the business application and the architecture of the database warehouse. He was able to lead the creation and implementation of the analysis services provided to the business by gathering and satisfying requirements from the customer. His technical expertise of the Microsoft stack and PostgreSQL database was second to none. He was the expert and respected by all his colleagues and customers and great to work with.
Vadim Kovalenko
As programmer analyst Mahadev constantly showed high knowledge of currently used techniques and ability to learn new technologies. He constantly showed his interests in increasing system effectiveness by utilizing modern technology and improving efficiency of the existing applications. Mahadev is a very meticulous individual who will do anything to achieve results. He will work around the clock without hesitation and is very dedicated to the task at hand. Mahadev cares and his actions demonstrate that. While Mahadev has many excellent qualities, I most appreciate the fact that he takes ownership of problems and solutions. His willingness to learn new technologies, dive into challenges and ability to calmly solve issues that arose always surprised me. I am happy that he and I are still friends to this day and that I have had the pleasure of watching him grow as a person and as a developer.
Kevin Dillard
Mahadev had a deep understanding of both the business application and the architecture of the database warehouse. He was able to lead the creation and implementation of the analysis services provided to the business by gathering and satisfying requirements from the customer. His technical expertise of the Microsoft stack and PostgreSQL database was second to none. He was the expert and respected by all his colleagues and customers and great to work with.
Vadim Kovalenko
As programmer analyst Mahadev constantly showed high knowledge of currently used techniques and ability to learn new technologies. He constantly showed his interests in increasing system effectiveness by utilizing modern technology and improving efficiency of the existing applications. Mahadev is a very meticulous individual who will do anything to achieve results. He will work around the clock without hesitation and is very dedicated to the task at hand. Mahadev cares and his actions demonstrate that. While Mahadev has many excellent qualities, I most appreciate the fact that he takes ownership of problems and solutions. His willingness to learn new technologies, dive into challenges and ability to calmly solve issues that arose always surprised me. I am happy that he and I are still friends to this day and that I have had the pleasure of watching him grow as a person and as a developer.
Kevin Dillard
Mahadev had a deep understanding of both the business application and the architecture of the database warehouse. He was able to lead the creation and implementation of the analysis services provided to the business by gathering and satisfying requirements from the customer. His technical expertise of the Microsoft stack and PostgreSQL database was second to none. He was the expert and respected by all his colleagues and customers and great to work with.
Credentials
-
Tableau Essential Training
LinkedInOct, 2019- Nov, 2024
Experience
-
Indiana Farm Bureau Insurance
-
United States
-
Insurance
-
700 & Above Employee
-
Senior Business Intelligence Developer
-
Feb 2020 - Present
• Extracting the data from DB2 Mainframes to SQL server using SQL Server Integration Services(SSIS). • Converted the legacy SSIS packages/projects to Integration service Catalogs using project deployment ensuring the encryption by efficiently using environment variables • Created error log script that can be used for all the jobs which sends emails of detailed error messages to all developers about the failed steps in job • Updated data of Auto and Home policies in data warehouse with source using merge statement and implemented SCD2 • Developed Stored Procedures for Life prediction Customer churn Model so that agents can contact customers who doesn’t want to renew their policies. • Developed stored procedures to inform about Models (SSAS Tabular) whether they are being processed or not at the right time using SSAS dynamic management views • Improved performance of existing SSIS packages/Stored Procedures. • Good knowledge of defining, developing and deploying Star Schema, Snow flake Schema and Dimensional modelling • Modified existing Tabular models (SSAS) • Developed dashboards using POWER BI in various line of businesses such as Auto, Home, Life and etc. using custom visuals like Bar Charts, Pie Charts, Line Charts, Cards, Slicers, etc. so that company can make informed decisions • Modified existing dashboards regarding Policies in force and Households in force, and included growth perspective using POWER BI visualizations • Created a dashboard for company goals 2023 using POWER BI and enabled users to enter values using SSRS maintenance reports • Developed summarized , detail and chart type reports using SSRS so that users can review summary and case by case data. • Developed Life Customer Churn SSRS report that gives information about policy holders who might be leaving the company which was a result of Customer Churn prediction. • Identified blocks of any daily running jobs and modified the process (SSIS/SQL) to resolve any conflicts/issues. Show less
-
-
-
Indiana Department Of Child Services
-
United States
-
Government Administration
-
700 & Above Employee
-
Sr.Datawarehouse Engineer
-
Feb 2012 - Feb 2020
• Extracted the data from several sources like PostgreSQL and applied several transformations to manipulate the data and loaded that transformed data into SQL server destinations using SQL server integration services (SSIS) • Played a major role in screening threshold research in providing the manipulated data which helped in researching about child abuse hotline data. Analyzed screened in reports using Python programming • Developed and deployed executive dashboards for Indiana governor’s office using softwares that helps analyze foster care data in various aspects. • Extracted the data using SSIS Packages from SQL server and created Datawarehouse that includes facts and dimensions from scratch • Developed MOLAP cubes using SQL Server Analysis Services (SSAS). • Created template for organization, this template has features of error handling and auditing and utilized this template to build several individual SSIS Packages • Developed stored procedures based on Indiana DCS policies and used them again for generating reports using Microsoft T-SQL • Designed various drill-down reports , charts and sub-reports using Microsoft SQL Server Reporting Services(SSRS) •Developed heat maps by region and by county which helps users to identify abuse rate in different counties and regions. • Created Reports using maps in SSRS with help of spatial data • Used Performance Monitor/SQL Profiler to analyze long running/slow queries and tune the same to optimize Application and system performance • Developed emergency Ad hoc reports based on the requirements of Indiana governor’s office • Tested, Cleaned and Standardized Data, meeting the business standards using Fuzzy /exact lookups using SSIS tasks. Show less
-
-
-
Bridgestone Americas
-
United States
-
Motor Vehicle Manufacturing
-
700 & Above Employee
-
Microsoft SQL BI developer/Consultant
-
Nov 2010 - Feb 2012
• Created a SSIS Package (works for transactional and canonical data that works as a template for every interface • Created Automated Job steps to process daily and weekly Data • Created various complex SSIS packages and deployed to Development, QA and Production environments. • Extensively used various Red gate tools • Used SQL Compare for comparing and deploying SQL objects. • Used SQL Data Compare for comparing and deploying data. • Used SQL Packager for comparing and deploying SQL objects with or without data. • Source control that Keeps team in sync with easy access to the latest database version. • Worked closely with Business team during the development of the Interfaces • Created Technical specification documents for each SSIS package developed • Administered and monitored SSIS packages • Extensively used various SSIS objects like Control Flow components, Data flow components, Connection Managers, Shared Data sources • Efficiently used Configuration files for changing the connection managers while deploying packages to different servers • Created DTEXEC and DTEXECUI batch files to run various interfaces • Created several Linked Servers to load data into different locations • Used Dynamic SQL for different variables while developing the SSIS packages Show less
-
-
Education
-
2009 - 2010
University of Bridgeport
Master of Science - MS, Electrical Engineering Technologies/Technicians
Community
