Possess 4+ years of professional analytics experience. Ability to interpret data and analyze results using statistical techniques and provide on-going reports in a timely and professional manner. Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
6
6
years of professional experience
Work History
Data Analyst
InfoSmart Technologies, Inc.
10.2023 - Current
Perform data analysis daily on existing operations work to measure and report on quality and productivity of workflows
Utilized Azure Synapse Analytics to analyze existing operational data, measuring quality and productivity metrics using SQL queries and Azure Synapse Studio
Implemented Python scripts for data cleansing, then integrated them into Azure Synapse Pipelines using Azure Data Factory to preprocess raw data before ingestion into Azure Synapse SQL Pools
Participated in ETL design and development efforts, performing code reviews, reporting project status, and leading projects
Developed Spark SQL code for analyzing data on EMR cluster
Developed Python scripts to clean the raw data
Work closely with business/technology resources on process management and oversight of Agile testing methodologies, as well as application requirements and processing
Developed CI/CD framework for data pipelines using Jenkins tool
Leveraged Azure Synapse Analytics to construct distributed high-performance systems, utilizing Spark and Scala through Synapse Spark Pools for parallel data processing
Experience in building distributed high-performance systems using Spark and Scala
Used Spark SQL for data pre-processing, cleaning, and joining very large data sets
Collaborated on ETL tasks, maintaining data integrity, and verifying pipeline stability
Also have experience with database fabric
Business Data Analyst Intern
Synergies Tech
07.2023 - 09.2023
Executed tasks effectively and efficiently, resulting in a 15% increase in departmental productivity
Demonstrated strong ability to do quality work for the usual projects that an individual would be assigned at this level
Analyzed large sets of data, resulting in a 10% increase in efficiency and productivity
Conducted comprehensive business requirement analysis and translated them into Functional specifications for network engineering projects
Facilitated requirements gathering sessions, eliciting key information and insights from business users to drive effective network solutions
Performed thorough data analysis and modelling to identify network performance gaps, Bottlenecks, and areas for optimization
Developed and maintained documentation including network diagrams, process flows, and technical specifications to ensure clear communication and knowledge transfer
Participated in the evaluation, selection, and implementation of network technologies and solutions, ensuring alignment with business requirements and industry best practices
Data Analyst Intern
Dak Tech, Inc.
06.2022 - 07.2022
Expert in designing ETL data flows using SSIS, creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Access/Excel Sheets using SQL Server SSIS
Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions, and developing, fact tables, dimension tables, using Slowly Changing Dimensions (SCD)
Collaborated on Azure Synapse ETL tasks, ensuring data integrity throughout the process and verifying the stability of data pipelines within Azure Synapse Analytics
Used SQL for querying and analysis purposes on various source tables and conditions applied
Involved in converting Hive/SQL queries into Spark transformations using Spark RDDs with Scala
Good working knowledge on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects
Marketing Data Analyst
Crisis Management Services & Solutions
08.2018 - 07.2021
Assisted in the analysis of large sets of data, resulting in a positive impact on the company's overall performance
Demonstrated strong attention to detail, resulting in a 25% decrease in errors
Utilized Tableau and SQL to redefine and track KPIs related to marketing initiatives
Created data visualizations (pie, bar, heat charts) to enhance data comprehension for marketing and analyst teams
Assisted in designing and executing A/B tests to optimize campaign elements, resulting in company-wide sales % improvement in conversion rates
Tracked and measured performance metrics of digital marketing initiatives, interpreting data related to user behavior, traffic sources, and conversion funnels
Conducted funnel analysis, cohort analysis, and customer segmentation to target specific audiences and enhance campaign effectiveness
Utilized marketing automation platforms and data visualization tools to analyze and present digital marketing data in a visually compelling manner
Education
Master of Science - Business Analytics
Lewis University
05.2023
Bachelor of Science -
Himalayan University
05.2018
Skills
Tableau
Spark
Power BI
Azure Synapse
SPSS
Fabric
Visual Studio
Excel Functions
Microsoft Office
MySQL Server
Google Suite
Data Visualization and Presentations
Data Analysis
Python Programming
Timeline
Data Analyst
InfoSmart Technologies, Inc.
10.2023 - Current
Business Data Analyst Intern
Synergies Tech
07.2023 - 09.2023
Data Analyst Intern
Dak Tech, Inc.
06.2022 - 07.2022
Marketing Data Analyst
Crisis Management Services & Solutions
08.2018 - 07.2021
Master of Science - Business Analytics
Lewis University
Bachelor of Science -
Himalayan University
Similar Profiles
Renjith MukriRenjith Mukri
Network Engineer at Infosmart Pty LtdNetwork Engineer at Infosmart Pty Ltd