Adarsh Jange
Newark,CA
Summary
Experienced professional with over 3 years of hands-on experience in Data management and analytics, possessing a Masters degree in Information Systems. Proficient in Tableau, Python, SQL, PowerBI, and AWS with a strong focus on ETL development. Skilled in translating complex business needs into actionable insights. Proven ability to optimize data workflows and drive informed decision making across various roles. Experienced in handling a variety of data sources, including relational, NoSQL, and streaming data.
Overview
5
5
years of professional experience
Work History
Data Analyst
Fannie Mae
02.2023 - 01.2024
- Performed ad-hoc analysis and data manipulation on large and complex datasets using SQL.
- Reduced query retrieval time by automating tasks with PL/SQL scripts, stored procedures, and functions.
- Utilized regression analysis and inferential statistics to forecast sales using R, Tableau - R Integration, and Excel.
- Developed standards for performance metrics, data collection, data integrity, query design, and reporting format.
- Ensured high-quality and meaningful analytical output.
- Worked on performance improvement of reports and SQL tuning to minimize resource utilization in a production environment.
- Added alerts in splunk and performed actions in splunk for checking logs when there are production issues.
- Experience collaborating with cross-functional teams within and outside organizations.
Data Analyst
Iron Mountain
12.2018 - 06.2021
- Collaborated with SVPs and Senior Directors across HR, Finance, Sales operations, IM Products (LOB), and Global Warehouse Reporting on building 50+ Dashboards & 75+ reports that drove efficiency KPIs up by 26%.
- Developed and optimized numerous complex SQL queries and stored procedures on Redshift to extract, transform, and load data, meeting specific business requirements and enhancing data accessibility.
- Implemented a streamlined dashboard on Salesforce to monitor the Accounts receivables from the customers & track past dues which enables the sales representatives to attain monthly cash collection targets & prevent future suspension of customer accounts.
- Constructed operational Power BI dashboards, enabling data visualization. Collaborated globally, managing complex data structures for integrity and performance, streamlining cross-functional data processes with a focus on confidentiality.
- Designed, developed cost effective end to end Cloud BI solutions using Azure SQL, Azure Data Factory, Azure Analysis services, SSRS, Power BI.
Education
Master of Science - Information Systems
Cleveland State University
Cleveland, OH12.2022
Skills
● Programming: Python, R, HTML, CSS, Django Framework, Spark, Scala
● Frameworks: ETL, Hadoop, Hive
● Database: SQL (MySQL, SQL Server, T-SQL), NoSQL(MongoDB)
● Cloud: AWS (EC2, S3, Lambda, Glue, Redshift, DynamoDB, Elastic file system), Apache Airflow, Snowflake, Azure (Data Factory, Databricks, Data Lake)
● Libraries: NumPy, Pandas, Scikit-Learn, Matplotlib, Seaborn
● Data Visualization Skills: Power BI, Tableau, Data Studio, Google Analytics
● Operational Skills: Agile, JIRA, Scrum
Soft Skills: Communication, Leadership, Problem solving, Time management, Adaptability
Timeline
Data Analyst
Fannie Mae
02.2023 - 01.2024
Data Analyst
Iron Mountain
12.2018 - 06.2021
Master of Science - Information Systems
Cleveland State University