Power Bi Data Analytics

LOKESH VINTHA

+1-623-***-**** **************@*****.*** www.linkedin.com/in/vintha-lokesh

PROFESSIONAL SUMMARY

Highly skilled Data Analytics Engineer with 4+ years of experience in managing and interpreting large datasets, designing data models, and delivering actionable insights to guide strategic business decisions. Proficient in SQL, Python (Pandas, NumPy), and R for data manipulation, statistical analysis, and predictive modelling. Experienced in developing interactive dashboards with Tableau and Power BI, and leveraging AWS tools such as Redshift, Glue, and Lambda for data warehousing, ETL pipelines, and automation. Advanced expertise in Excel, including Power Pivots, VLOOKUP, and VBA macros, to optimize reporting workflows and data transformation processes. A proven collaborator with cross-functional teams to build tailored reporting solutions and drive process improvements. Adept at maintaining data integrity and ensuring compliance in regulated industries like healthcare. Passionate about transforming complex data into meaningful, actionable insights that enhance operations and support data-driven decision-making.

TECHNICAL SKILLS

Data Analysis & Programming: SQL, Python (Pandas, NumPy), R Data Vitalization: Tableau, Power BI, AWS QuickSight Data Warehousing & Modeling: Amazon Redshift, Data Modeling (Fact and Dimension Tables), Data Warehousing ETL & Data Pipeline: AWS Glue, AWS Lambda, DBT, Excel Macros Advanced Excel: Power Pivots, VLOOKUP, Array Functions, VBA Macros Cloud Platforms: AWS (S3, IAM, CloudWatch, Glue, Lambda, QuickSight) Statistical Analysis & Machine Learning: Python (Scikit-learn, Pandas), R, TensorFlow, Keras, Convolutional Neural Networks (CNN)

Version Control & Collaboration: Git

Data Security & Compliance: HIPAA Compliance, AWS IAM Documentation: SQL Query Documentation, Data Workflow Documentation, Reporting Process Documentation PROFESSIONAL EXPERIENCE

Data Analytics Engineer CVS Health, Woonsocket, USA March 2024 - Present

• Analyzed complex healthcare datasets using SQL and Amazon Redshift to uncover insights that optimized patient care workflows and streamlined operations.

• Designed and managed data models in Redshift to ensure efficient data organization for faster queries and accurate reporting across business functions.

• Enhanced data warehousing processes by improving pipelines, enabling seamless access to high-quality, reliable data.

• Built interactive dashboards in Power BI and AWS QuickSight to monitor key metrics such as patient volume, costs, and resource utilization, supporting critical business decisions.

• Utilized advanced Excel features (pivot tables, array functions, VBA macros) to automate reporting, reducing manual work and boosting data accuracy.

• Created complex SQL queries to process multi-source datasets and deliver impactful reports aligned with business goals.

• Automated ETL processes using AWS Glue and Lambda, reducing manual intervention and improving data ingestion efficiency.

• Applied Python (Pandas, NumPy) and R for statistical analysis and predictive modeling, generating forecasts to improve healthcare operations and patient outcomes.

• Partnered with cross-functional teams (healthcare, finance, HR, supply chain) to design customized reporting solutions tailored to their needs.

Business Data Analyst Principal Financial Group Aug 2022 - Aug 2023

• Performed data analysis on existing data warehouse systems, including schema optimization for performance improvements.

• Conducted data mapping from source to target systems, ensuring integrity and consistency across ETL processes.

• Utilized SQL extensively to access, manipulate, and analyze large datasets for business insights.

• Created business flow diagrams, use case and sequence diagrams using MS Visio to support data-driven solution design.

• Participated in data-driven application development by gathering requirements and defining technical specifications.

• Conducted gap analysis to align system infrastructure with new business analytic requirements.

• Facilitated Joint Application Development (JAD) sessions to align analytic requirements between technical and business teams.

• Participated in design walk-throughs with SMEs to baseline and validate data models and business architecture. Data Analyst OPTUM July 2021 - July 2022

• Created and analyzed business requirements to compose functional and implementable technical data solutions.

• Identified integration impact, data flows, and data stewardship to ensure smooth data handling across systems.

• Evaluated and enhanced data models to reflect evolving business requirements and improve usability.

• Generated, wrote, and ran SQL scripts to implement DB changes, update tables, manage indexes, and create views & stored procedures.

• Consolidated and updated various data models through reverse and forward engineering for better data insights.

• Analyzed DB discrepancies and synchronized environments (Staging, Development, UAT, and Production) with accurate data models.

• Reviewed and revised data models for soundness of data structures and adherence to client/business standards.

• Restructured logical and physical data models to adapt to changing business needs while ensuring data integrity. EDUCATION

Arizona State University Aug 2023 - May 2025

Master of Science in Information Technology Project Management GPA: 3.80/4.0 Key Courses - Data Mining & Analytics, Statistical Analysis with R/Python, Machine Learning & Deep Learning, Data Warehousing & Modeling, Cloud Computing & Big Data, Business Intelligence & Visualization, Database Systems & SQL, IT Project Management.

Contact this candidate