VIJAY PININTI
Connecticut
Summary
Experienced Senior Business Data Analyst with expertise in Power BI and advanced data modeling to enhance reporting accuracy. Skilled in generating insights to optimize business planning and operations while ensuring compliance with regulatory requirements and internal controls. Capable of identifying and leveraging data trends to drive strategic decision-making.
Overview
8
8
years of professional experience
Work History
Sr. Business Data Analyst
Verition Fund Management
Connecticut
03.2024 - Current
- Gathered bulk data upload requirements in collaboration with investment operations and compliance teams to ensure regulatory alignment.
- Standardized high-volume datasets received from various systems into structured templates for enhanced accuracy.
- Validated field mappings with Excel Power Query, confirming adherence to business rules between source and target systems.
- Conducted test uploads in staging environments to detect mismatches or missing fields prior to production rollout.
- Performed line-item reconciliations by analyzing exception reports, addressing discrepancies at the row/column level.
- Leveraged advanced Excel functions alongside VBA macros to streamline reconciliation processes and minimize manual effort.
- Coordinated investigations of exception cases with IT and stakeholders, performing root cause analysis to drive effective resolution.
- Implemented automated scripts in VBA and Python for pre-validation of bulk uploads, ensuring data integrity before submission.
MSBI/Azure Data /Power BI Developer
Citibank
Tampa
02.2023 - 03.2024
- Directed transition of more than 100 legacy Crystal Reports to Power BI leveraging SQL Server as main data source and guaranteeing adherence to ICD coding alongside Medicaid/Medicare EDI regulations.
- Created and optimized dynamic Power BI dashboards and scorecards concentrated on customer deep dive sales trends and revenue metrics employing advanced functionalities like DAX and M code.
- Constructed comprehensive ETL pipelines leveraging SSIS and intricate SQL queries for migrating data from legacy systems into Power BI, prioritizing healthcare reporting and regulatory alignment.
- automated ETL processes leveraging Azure Data Factory, optimizing ingestion and transformation of data from PostgreSQL, Oracle, and flat files into Power BI.
- Engaged finance teams, business analysts, and stakeholders to gather healthcare reporting requirements, ensuring adherence to HIPAA, Medicaid/Medicare, and EDI standards (837, 834).
- Created interactive Power BI dashboards showcasing key healthcare metrics such as patient outcomes and resource utilization.
- Deployed and integrated dynamic row-level security (RLS) within Power BI service to secure sensitive healthcare information and adhere to internal data governance standards.
- Incorporated MDX and DAX to analyze extensive healthcare datasets effectively
- Converted legacy ODBC and ANSI SQL connections to secure SQL Server integrations, enhancing data integrity and access control while maintaining HIPAA compliance.
- Coordinated with data engineers and DBAs to fine-tune SQL queries, oversee index management, and elevate performance within SQL Server environment.
- Engineered intricate data models in erwin data modeler precisely reflecting healthcare data structures while maintaining consistency and audibility.
- Designed and tested embedded logic scripts for predictive maintenance, enhancing equipment uptime and minimizing false alerts.
- Supported ETL pipelines integrating EHR systems, Azure Data Lake, and Oracle backend for scalable reporting.
MSBI/Azure Data /Power BI Developer
CVS HEALTH CORPORATION
Pittsburgh
01.2022 - 01.2023
- Designed advanced Power BI data models using DAX and M code, validating accuracy with SQL Server, Azure SQL Database, and Oracle sources.
- Developed interactive dashboards and custom measures to visualize Intel’s strategic KPIs, enhancing decision-making processes.
- Configured real-time data pipelines and visualized KPIs in Power BI, adhering to ISA-95 standards.
- Automated ETL workflows using Azure Data Factory for timely data ingestion and transformation.
- Built complex ETL pipelines with SQL Server Integration Services (SSIS) to extract and transform data from multiple sources.
- Collaborated with business systems analysts and key stakeholders to refine requirements, ensuring database constraints were met.
- Conducted impact analysis on data structure changes, maintaining system integrity and stability.
- Developed embedded analytics modules in C and Python for processing industrial sensor data streams.
Data Analyst
Birlasoft Technologies
Hyderabad
07.2018 - 04.2021
- Designed scalable SQL Server and Oracle data models for large-volume uploads and line-item reconciliations.
- Developed ETL packages in SSIS to extract, transform, and load data from Excel and Oracle databases with quality checks.
- Automated reconciliation checks and upload validations through SSIS, streamlining processes and enhancing data integrity.
- Implemented incremental loading strategies using SQL merge statements to enhance processing time for recurring uploads.
- Created SSRS and Power BI reports with drill-down options, enabling stakeholders to monitor reconciliation status and exceptions effectively.
- Conducted line-item reconciliations by comparing uploaded data against source systems, identifying discrepancies, and executing remediation steps.
- Standardized bulk upload templates and validated field mapping to align sources with system requirements.
- Defined reconciliation and reporting requirements with stakeholders, ensuring alignment on data processes for enhanced accuracy.
Education
MBA - Masters in Business Adminstration
Trine University
Angola, IN04-2021
BBA - computer science
Osmania University
Hyderabad06-2018
Skills
- Power BI
- DAX
- Power Query
- KPI Reporting
- Data Visualization
- Real-Time Streaming
- Big Data Analytics
- Azure Data Factory
- SQL Database
- Databricks
- Azure
- SSAS
- SSIS
- Informatica
- Python
- Pandas
- NumPy
- Scikit-learn
- Machine Learning
- R
- Tidyverse
- PL/SQL
- T-SQL
- MDX
- VBA
- RESTful APIs
- Web Services
- Data Pipelines
- Real-time processing
- Blob Storage
- AWS
- RDS
- S3
- Redshift
- Oracle Cloud
- IBM Cloud
- Matplotlib
- Seaborn
- RMarkdown
- ANOVA
- Regression
- SciPy
- PySpark
- Apache Spark
- Tableau
- Cognos BI
- SSRS
- Flex Dashboards
- Power Pivot
- Power Map
- Star Schema
- Snowflake Schema
- OLAP
- OLTP
- Data Marts
- Database Design
- SQL Server
- Oracle
- PostgreSQL
- DB2
- Teradata
- Index Tuning
- Performance Optimization
- API Integration
- Data Services
- Power BI REST API
- XMLA
- Microsoft Flow
- Agile
- Scrum
- Jira
- Waterfall
- Cross-functional teamwork
- Stakeholder Communication
- Mentoring
- Predictive analysis
- Correlation Analysis
- Mathematical modeling
- Trend analysis
- OBIEE
- Oracle BI Publisher
- Business Objects
- Microsoft BI Stack
- ADLS
- Databricks Delta
- ADLS
- Databricks Delta
Publications
- Secure data sharing in cloud computing using revocable-storage identity-based encryption., Not Provided
- Heart failure Predictions using advance Neural networks and image processing., Not Provided
- AUGMENTING THE EXISTING CBPM MAINTENANCE PHILOSOPHY CURRENTLY IN USE IN THE MARINE SECTOR WITH INTELLIGENT PREDICTIVE CBPM PHILOSOPHY., https://link.springer.com/chapter/10.1007/978-981-15-7234-0_51
- STOCK PREDICTION AND ANALYZING USING ARIMA,LSTM MODELS AND INDICATORS., IJSREM Journal, 05/21, 05, 05
Timeline
Sr. Business Data Analyst
Verition Fund Management
03.2024 - Current
MSBI/Azure Data /Power BI Developer
Citibank
02.2023 - 03.2024
MSBI/Azure Data /Power BI Developer
CVS HEALTH CORPORATION
01.2022 - 01.2023
Data Analyst
Birlasoft Technologies
07.2018 - 04.2021
MBA - Masters in Business Adminstration
Trine University
BBA - computer science
Osmania University