Reading Books
JYOTI SONI
Data Analyst
Mumbai,Maharashtra
Summary
Motivated and Results driven BI developer with a proven track record in Business Intelligence,Data Warehouse and Data Analytics related projects. Proven ability to identify business needs and develop valuable solution to drive accuracy and process efficiency. Experienced in developing , implementing, documenting , monitoring and maintain the data warehouse extracts, transformations and ETL process. Utilized Power BI (Power View) and tableau to create various analytical dashboard that depicts critical KPI along with Slicers and dicers enabling end-user to make filters. Implemented Power BI gateway for schedule refreshing. Experienced in designing and developing reports using data from ETl and Various heterogeneous data sources. Worked on small and Large scale projects Experience with all phases of SDLC and agile methodologies Stonng Investigative and troubleshooting skills. Believe in team work.
Overview
4
4
years of professional experience
5
5
years of post-secondary education
2
2
Certifications
3
3
Languages
Work History
Senior Data Analyst
Adobe
Noida, Uttar Pradesh
01.2022 - Current
- Leveraged text, charts and graphs to communicate findings in understandable format.
- Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
- Interpreted business questions and collaborated with engineering teams to identify data sources.
- Identified, reviewed and evaluated data management metrics to recommend ways to strengthen data across enterprise.
- Assessed large datasets, drew valid inferences and prepared insights in narrative or visual forms.
- Developed and implemented data collection systems and other strategies to optimize statistical efficiency and data quality.
- Mapped current business and operational processes and recommended areas for improvement.
- Diminished process gaps and encouraged optimal productivity by closely supervising workflow of claims analysts and mail clerks.
- Optimized system and platform performance capabilities in most efficient, practical way possible.
- Applied sales forecasting techniques and strategic planning to verify sales and profitability of products, lines and services.
- Delivered key metrics for sales, credit and warranties to drive success of business.
- Developed tools and processes to help improve operational efficiency and enhance sales team productivity.
- Generated bar graphs, trend lines and pie charts to represent sales data.
- Identified and researched inefficiencies and inaccuracies in processes and procedures.
- Gathered and analyzed quality statistics to determine trends.
- Produced detailed and relevant reports for use in making business decisions.
- Collected, organized and modeled data using Sql Server
- Gathered, documented and modeled data to assess business trends.
Data Analyst
Accenture
Mumbai, Maharshtra
02.2020 - 12.2021
- Gathered and documented business requirement for analytical reports
- Participated in requirements meetings and data mapping sessions to understand business needs
- Integrated Custom visual based on requirements using Tableau
- Imported data from SharePoint, Excel sheets, Azure Board,Clouds,MongoDB.
- Worked on Figma Designing tool for designing logos and graphics for reports.
- Provided continued maintenance and development of bug fixes and Tableau Reports
- Explored data in variety of ways and across multiple visualizations using Tableau
- Strategic expertise in design of Experiments, Data collection, analysis and visualization
- Researched and resolved issues regarding integrity of data flow into databases.
- Identified and documented detailed business rules and use cases based on requirements analysis.
- Participated in requirements meetings and data mapping sessions to understand business needs.
- Developed tables, views and materialized views using SQL.
- Analyzed SAP transactions to build logical business intelligence model for real-time reporting needs.
- Recommended data standardization and usage for protection of data integrity.
- Created and improved intelligence resources to facilitate consistent data management strategies.
- Transformed project data requirements into project data models.
- Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending changes.
- Designed and developed schema data models.
- Trained employees on software to improve data management, monitored use and suggested improvements.
- Documented business workflows for stakeholder review.
- Updated organizational systems and subsystems to improve and streamline data collection.
BI Developer
L&T Infotech
06.2017 - 12.2019
- Prepared detailed reports on updates to project specifications, progress, identified conflicts and team activities.
- Analyzed proposed technical solutions based on customer requirements, budget and product goal.
- Analyzed key aspects of business to evaluate factors driving results and summarized into presentations.
- Developed short-term goals and long-term strategic plans to improve risk control and mitigation.
- Improved business direction by prioritizing customers and implementing changes based on collected feedback.
- Improved processes within collections and rigorously tested test and learn strategies throughout collections processes.
- Advised senior managers on policy strategies for reducing liability and preventing losses.
- Designed customized data collection models for specific visualization tasks.
- Liaised with DevOps team to integrate business intelligence assets into future development lifecycles.
- Collected data from wide-ranging sources.
- Planned, designed and implemented diverse business intelligence solutions.
- Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence.
- Automated BI reports for secure virtual server environment.
- Documented software development methodologies in technical manuals to be used by IT personnel in future projects.
- Created proofs of concept for innovative new solutions for Medical Project.
- Collected, organized and entered patient data into medical systems.
- Studied and researched various medical terms as well as software and coding systems.
Education
B.Sc. - IT
Amity University
Noida 08.2014 - 05.2017
12th -
Science
04.2012 - 04.2013
10th - CBSE -
Vaish Public School
04.2010 - 04.2011
Skills
Enterprise application integration
Python
Database Management
Business Intelligence Analysis
Tableau
Power BI
Predictive Modelling
Agile Methodology
Client Interaction
SQL
SQL Server
Statistical Modelling
Machine learning Algorithms
Objective
To obtain my Masters Degree in Data Science which helps give me the skills to make difference in the Data Science and Machine Learning industry through my
research
Certification
Completed DA-100 Certification
Accomplishments
- Supervised team of 4 staff members.
- Resolved product issue through consumer testing.
- Obtained Mini degree in Journalism
Interests
Travelling
Learning New Tech skills
Timeline
Senior Data Analyst
Adobe
01.2022 - Current
Data Analyst
Accenture
02.2020 - 12.2021
BI Developer
L&T Infotech
06.2017 - 12.2019
B.Sc. - IT
Amity University
08.2014 - 05.2017
12th -
Science
04.2012 - 04.2013
10th - CBSE -
Vaish Public School
04.2010 - 04.2011