Data Analyst Business Intelligence

PRANAV KUMAR

DATA ANALYST

+1-203-***-**** Colby CT

Results-driven Data Analyst with 3 years of experience in financial services, payroll solutions, and customer service. Skilled in data visualization, statistical analysis and BI tools to drive data-driven decisions. Proficient in SQL, Python, APIs and performance analytics, optimizing business strategies with large datasets.

Experienced in cloud platforms, data warehousing, and ETL pipelines for accurate reporting. Strong in structured data processing, version control (GitHub), and business intelligence. Adept at translating complex data into insights, enhancing UX/UI in Fintech and driving growth through technical writing and strategy.

Technical Skills

Programming: SQL, Python, R, SAS, MATLAB

Data Visualization: Power BI, Tableau, Excel, Looker, Google Data Studio

Databases: SQL Server, Oracle, PostgreSQL, MySQL, MongoDB, Teradata, Snowflake

Cloud Technologies: AWS (Redshift, S3, Athena, Glue), Azure (Synapse, Data Factory, Databricks), Google Cloud Platform (BigQuery, Cloud Functions)

Big Data Tools: Hadoop, Spark, Kafka, Hive, Pig

ETL & Data Warehousing: Informatica, Talend, Apache Nifi, Alteryx, SSIS, Airflow

Machine Learning & AI: Scikit-learn, TensorFlow, Keras, PyTorch, AutoML, NLP

Data Governance & Security: GDPR, HIPAA Compliance, Data Masking, Role-Based Access Control (RBAC)

Agile & Project Management: Jira, Confluence, Agile Scrum, Kanban

Work Experience

Data Analyst SEP 2024 – Present

Sun Trust Charlotte, NC

Integrated AWS cloud services to optimize financial data management, improving scalability and security.

Developed machine learning models for predictive analytics, enhancing product recommendations and customer engagement.

Implemented relational data management to transform business intelligence and strengthen governance.

Designed Power BI dashboards for real-time fraud detection and KPI tracking to enhance risk assessment.

Utilized Hadoop and Spark to refine data processing workflows and improve transaction monitoring efficiency.

Automated reporting with Python and SQL, reducing manual effort by 30% and improving data accuracy.

Built ETL pipelines using Informatica & Snowflake for seamless banking data integration.

Enforced data governance policies to strengthen regulatory compliance in financial institutions.

Conducted A/B testing to optimize marketing campaigns and maximize return on investment.

Developed SQL-based analytics for customer retention and efficient loan processing.

Collaborated with stakeholders to enhance banking services and improve operational efficiency.

Leveraged Python and SQL to automate data-driven decision-making and streamline reporting.

Data Analyst AUG 2021 – AUG 2023

Turbo Hire India

Performed predictive analytics on workforce trends, aiding HR in strategic talent management.

Developed robust data quality frameworks to enhance payroll processing accuracy.

Migrated payroll data to the cloud by implementing ETL pipelines with Azure Data Factory.

Applied regression models to detect payroll anomalies, mitigating compliance risks.

Created Power BI reports to deliver real-time insights into workforce analytics.

Leveraged NLP techniques to analyze employee feedback, driving HR decision-making.

Established standardized data governance policies to ensure secure payroll data handling.

Optimized payroll processing and compliance tracking by designing interactive Tableau dashboards.

Utilized SQL and Python for payroll data analysis, uncovering trends and reducing discrepancies by 15%.

Streamlined data reporting workflows by collaborating with HR and finance teams to automate processes.

Certifications:

Masters in SQL Certification

AWS Certified Cloud Practitioner

ISO 90001 Python Certification

Education:

Master of Science in Business Analytics Sacred Heart University, Fairfield, CT, USA.

Bachelor of Business Administration Krishna University, Machilipatnam, India.

Contact this candidate