Data Analyst Entry

Mansi Shukla

Data Analyst

Email ID: *************@*****.***

Contact: +1-949-***-****

LinkedIn: https://www.linkedin.com/in/s-mansi-96b559266/

Location: Austin, Texas.

https://github.com/mansi-dolph

Technical Skills:

Programming Languages

Python, R, SQL

Data Visualization

Tableau

Power BI

Matplotlib/Seaborn

ggplot2

Database Management:

MySQL, PostgreSQL, NoSQL.

Excel

Advanced formulas, Pivot tables

Version Control

Git/Github

Data Warehousing

ETL (Extract, Transform, Load)

Profile Summary:

Around 5+ years of experience in analyzing complex datasets and delivering actionable insights to drive business growth.

Enthusiastic and detail-oriented Data Analyst with a passion for leveraging analytical skills to drive organizational growth.

Proficient in Python, SQL, and Tableau, with a strong background in statistical analysis and data visualization.

Demonstrated success in optimizing data processes and creating impactful reports that facilitate strategic decision-making.

Proven ability to solve business problems through insightful exploratory data analysis & providing actionable recommendations.

Experienced in creating technical documents and presentations using MS Office, and adept at preparing dynamic dashboards in Tableau with a focus on calculated fields, parameters, groups, sets, and hierarchies.

Hands-on experience in data validation and cleaning using MS Excel.

Eager to contribute to a dynamic team, apply acquired skills, and gain valuable experience in the ever-evolving field of Data Analyst.

Experienced in working collaboratively with cross-functional teams to align data analysis with business objectives and support project management initiatives.

Committed to continuous learning and staying abreast of industry advancements to deliver cutting-edge data solutions.

Proven track record in managing and querying both relational and NoSQL databases, ensuring data accuracy, and implementing effective ETL processes to streamline data flow.

Expertise in applying statistical techniques and predictive analytics to identify trends, forecast outcomes, and solve complex business challenges.

Adept at communicating complex data findings to stakeholders and managing multiple projects with a focus on achieving business objectives.

Professional Experience:

Client: DTCC (Depositary Trust and Clearing Corporation), Texas

Duration: March 2021 – May 2024

Job Title: Data Analyst

Created and enforced data management policies to maintain data quality, consistency, and accessibility across the organization.

Provided primary and secondary analysis by gathering the relevant data and pertinent information.

Conducted additional analysis to validate the findings from the primary analysis.

Designed the database schema to efficiently store and manage book inventory, customer details, and order information.

Developed and delivered training sessions for end-users and team members on data tools, systems, and best practices to improve data literacy and utilization.

Implemented SQL queries and stored procedures for data retrieval, insertion, and updating.

Analyzed market trends and competitive data to provide insights into industry dynamics, customer behavior, and potential opportunities or threats.

Identified and analyzed business trends to support strategic initiatives, operational improvements, and performance evaluations.

Created compelling visualizations, such as charts, graphs, and heatmaps, to represent complex data in an easily understandable format.

Developed and refined data presentation techniques to effectively communicate findings and support data-driven decision-making.

Developed and optimized SQL queries for efficient data retrieval, insertion, and updating, reducing query execution time by 25% through indexing and query tuning techniques.

Provided ongoing support to address user inquiries and resolve issues related to data systems and processes, ensuring smooth operations.

Performed root cause analysis on recurring issues to identify underlying problems and implement long-term fixes.

Performing Exploratory Data Analysis (EDA) of the dataset to uncover patterns, trends, and insights relevant to customer preferences and performances.

Analyzed and diagnosed data-related issues, including pipeline failures and data inconsistencies, implementing effective solutions to resolve problems.

Analyzed and optimized data processing and query performance to maintain responsiveness and efficiency as data loads increase.

Achievement: By fulfilling these core responsibilities and designing dashboard in power Bi, actively contribute to the formulation of accurate predictions for the 2024 season, thereby aiding stakeholders in making well-informed decisions and strategic plans. Identified trends and patterns to distinguish successful promotions from those that did not meet expectations. Presented findings and recommendations to the sales director, facilitating informed decision-making for upcoming promotional periods.

Client: Fujitsu America, Texas.

Duration: April 2019 - March 2021

Job Title: Data Analyst

Performed statistical analysis, interpreted data trends, patterns, and correlations, and generated insights that are relevant to the project objectives.

Created and maintained data models to organize and structure data efficiently for analysis, including dimensional models, star schemas, and entity-relationship diagrams.

Designed and implemented interactive dashboards and visualizations using tools like Tableau and Power BI, enabling stakeholders to easily interpret and analyze complex data sets.

Collaborated with business stakeholders to gather and analyze requirements for data analysis projects, ensuring alignment with business objectives and identifying key performance indicators (KPIs).

Analyzed data needs and gaps by assessing existing reports and data sources, and recommended solutions to address business challenges and improve decision-making.

Performed data extraction from various sources, including databases, APIs, and flat files, to compile comprehensive datasets for analysis.

Developed and maintained processes for integrating data from disparate sources, ensuring consistency and accuracy in the resulting datasets.

Developed and applied predictive models and algorithms to forecast future trends and behaviors, providing actionable insights for strategic planning.

Performed exploratory data analysis to uncover insights, detect anomalies, and understand data distributions and relationships.

Present findings in a clear and actionable manner using reports, dashboards, and visualizations to communicate insights to stakeholders.

Analyzed and resolved data inconsistencies and quality issues, collaborating with data engineering teams to implement corrective measures.

Achievement: Identified trends and patterns to distinguish successful promotions from those that did not meet expectations. Presented findings and recommendations to the sales director, facilitating informed decision-making for upcoming promotional periods. Successfully reduced database query execution time by 30% through optimization techniques. Monitor key performance indicators (KPIs) related to subscription growth, game sales, and user engagement. Ensure the accuracy, completeness, and consistency of data collected from various sources. Implement data quality checks and validation processes to maintain data integrity.

Education Details:

Master’s in Business Administration - IIMS, India.

Bachelor of Science - CMS degree college, India.

Certifications:

Data Analytics Essential - University of Texas, Austin.

IBM Certification: Introduction to Data Analytics.

Contact this candidate