VINOD KUMAR R
MI
Summary
Experienced Software Engineer/ Data analyst with 5+ years of expertise in software development life cycle (SDLC) and project life cycle activities. Proven expertise in designing and implementing ETL pipelines, conducting impact analyses, and ensuring data quality across various platforms. Proficient in Python for data analysis, scripting, and automation tasks using pandas and NumPy libraries, SQL for data modeling and query optimization, and Power BI for data visualization. Skilled in utilizing Microsoft Office Suite, especially Excel, to create advanced reports and dashboards that facilitate data-driven decision-making. Familiarity with dimensional modeling and experience using dbt for data transformation, designing data models and visualization solutions, particularly in Looker. Strong problem-solving skills and experience in a global delivery environment.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Software Engineer| senior data analyst
Farmers insurance | Accenture Pvt. Ltd
02.2021 - 08.2022
- Collaborated with technical teams to identify and document requirements for system enhancements, ensuring accurate claims processing
- Spearheaded the design and implementation of robust ETL pipelines using Python and Informatica, streamlining data processing from diverse sources and improving data accuracy
- Conducted comprehensive data analysis utilizing SQL and Excel to extract, clean, and analyze data, uncovering insights that informed strategic decision-making for client engagement and operational improvements
- Developed advanced Excel dashboards and reports using pivot tables, VLOOKUP, and data visualization tools, enhancing stakeholder understanding of key performance metrics
- Automated reporting processes in Excel, reducing report generation time by 40% and improving accuracy using macros and complex formulas
- Created interactive dashboards and visualizations in Power BI that transformed raw data into actionable insights, facilitating data-driven decision-making across the organization
- Established data governance policies and metrics in partnership with business stakeholders, enhancing data integrity and compliance
- Lead initiatives to identify, propose, and actively participate in process improvement projects, driving efficiency and enhancing operational outcomes
- Engage collaboratively with cross-functional teams to uphold processes and best practices, including Quality Assurance testing protocols
- Provided technical expertise for system and application design, performance, integration, and security
- Documented unit and regression test cases and incorporated new business requirements into technical designs.
Software Engineer| Data Analyst
Zurich Insurance | Accenture Pvt. Ltd
05.2020 - 02.2021
- Led requirement analysis sessions and crafted comprehensive Business Understanding documents, ensuring clarity in project goals and deliverables
- Utilized statistical analysis and predictive modeling techniques in Python and SQL to derive insights from complex datasets, supporting business units in strategy formulation and operational improvements
- Developed and maintained Excel-based reporting solutions that provided stakeholders with real-time insights into performance metrics, leveraging advanced Excel functions and data visualization features
- Implemented advanced database features in PostgreSQL, such as partitioning and materialized views, to improve data organization and query performance
- Collaborated with development teams on ETL tasks, ensuring data integrity and stability through rigorous testing and validation
- Actively participated in troubleshooting and resolving database-related issues, demonstrating strong problem-solving skills and a proactive approach to maintaining database uptime and reliability
- Stayed updated on the latest Power BI features and enhancements, incorporating new functionalities into existing reports to improve efficiency
- Participated in regular meetings and presentations to showcase Power BI solutions and gather feedback for continuous improvement
- Detailed Analysis of the present functionalities of the integrated customer Data Warehouse and Appending the New Feature using the Functional Documents
- Understand the problem, Code Fix, Proper Testing, and Migration of code to Production Area with Service Management Approval to meet the SLA (Service Level Agreement) within very short intervals of time.
Software Engineer| ETL Developer
Kaiser Permanente | Accenture Pvt. Ltd
08.2017 - 05.2020
- Understanding the Business Design Documents & creating an overall design based on requirements & Business reviews
- Designed and implemented ETL solutions in Informatica, successfully populating data into staging and warehouse environments from multiple sources
- Analyzed large datasets using SQL and Excel to identify key performance indicators (KPIs) and trends, driving improvements in operational processes and reporting accuracy
- Developed comprehensive ETL standards and documentation, ensuring adherence to best practices and enhancing team productivity
- Monitored and optimized workflows for data integration, significantly reducing processing times and ensuring timely data availability for analytics
- Played a key role in establishing testing strategies for functional, integration, and system testing in data warehouse projects, ensuring high data quality and reliability.
Education
Master of Science - Information Technology
University of Michigan - Flint
Flint, MI12.2023
Skills
- Data Structures and Algorithms
- Power BI
- Excel
- SQL
- Python
- Pandas
- NumPy
- R
- MySQL
- PostgreSQL
- Snowflake
- MongoDB
- MS SQL Server
- Oracle Database
- MATLAB
- SPSS
- Informatica
- Apache Spark
- Looker
- Jupiter Notebook
- Anaconda
- GitHub
- Microsoft Azure
- Test Planning and QA
- Agile Methodologies
Certification
- GCP Associate Cloud Engineer
- Microsoft Azure Cloud Certified
Timeline
Software Engineer| senior data analyst
Farmers insurance | Accenture Pvt. Ltd
02.2021 - 08.2022
Software Engineer| Data Analyst
Zurich Insurance | Accenture Pvt. Ltd
05.2020 - 02.2021
Software Engineer| ETL Developer
Kaiser Permanente | Accenture Pvt. Ltd
08.2017 - 05.2020
Master of Science - Information Technology
University of Michigan - Flint
Similar Profiles
MANJUSHREE TAMBOLIMANJUSHREE TAMBOLI
Development Associate Manager at Accenture Pvt Ltd, Farmers InsuranceDevelopment Associate Manager at Accenture Pvt Ltd, Farmers Insurance
Stephanie RuarkStephanie Ruark
Insurance Agent at Farmers Insurance / United Healthcare InsuranceInsurance Agent at Farmers Insurance / United Healthcare Insurance
LAURA TAYLORLAURA TAYLOR
Auto Claims Representative at MetLife Insurance Merged to Farmers InsuranceAuto Claims Representative at MetLife Insurance Merged to Farmers Insurance
Breanna SlaughterBreanna Slaughter
Credentialing Specialist at United Outstanding PhysiciansCredentialing Specialist at United Outstanding Physicians
Kendra MallisonKendra Mallison
Production Assembler at Portage Wire Systems IncProduction Assembler at Portage Wire Systems Inc