PRIYANSHI ALLE

Sr Data Analyst

ady1hw@r.postjobfree.com

469-***-****

Objective:

Highly skilled and detail-oriented data analyst with 9 years of experience in collecting, analyzing, and interpreting complex data sets. Seeking a challenging position to leverage my expertise in data analysis, statistical modeling, and data visualization to drive business growth and provide valuable insights.

Summary:

•Extensive experience in data analysis, data mining, and statistical modelling.

•Ability to collect, manipulate, and analyse complex data sets.

•Proficient in SQL, Python, R programming, and Tableau for data manipulation and analysis.

•Strong analytical skills, including the ability to identify patterns, trends, and outliers in data, providing valuable insights for informed decision-making.

•Expertise in creating and maintaining databases, ensuring data quality and integrity.

•Skilled in creating interactive and visually appealing data visualizations using Tableau and Power BI, facilitating data-driven decision-making processes and effectively communicating complex information to stakeholders.

•Collaborative approach in working with cross-functional teams to define key performance indicators (KPIs) and develop real-time monitoring dashboards, ensuring timely and accurate reporting of critical metrics.

•Proven ability to ensure data quality and integrity through the creation and maintenance of databases, implementation of data cleansing strategies, and investigation of data quality issues.

•Demonstrated expertise in conducting ad hoc analyses to support business initiatives, including market trend analysis, customer preference analysis, and the impact assessment of marketing campaigns.

•Leadership experience in leading teams of data analysts, providing guidance and mentorship to junior colleagues, and fostering a collaborative and high-performing environment.

•Proven track record in producing actionable insights and data-driven recommendations.

•Excellent communication skills, both written and verbal, enabling effective conveyance of complex information to diverse audiences.

•Strong problem-solving and critical thinking skills, enabling the identification of innovative approaches and solutions to complex data challenges.

•Ability to work effectively in cross-functional teams and collaborate with stakeholders to understand business requirements and translate them into data analysis solutions.

Technical Skills:

•Data analysis and statistical modelling

•SQL, Python, and R programming languages

•Data visualization tools (Tableau, Power BI)

Database management and data cleansing

Predictive modelling and forecasting

•Advanced Excel and spreadsheet analysis

•Strong problem-solving and critical thinking skills

•Excellent written and verbal communication

•Team collaboration and leadership

Professional Experience:

Edward Jones, Saint Louis, MO Mar 2022 to Present

Senior Data Analyst Responsibilities:

•Conducted comprehensive analysis of large datasets using SQL, Python, and R, resulting in improved operational efficiency and cost savings.

•Developed and implemented statistical models to forecast sales trends and customer behavior, leading to a 10% increase in sales revenue.

•Created interactive data visualizations using Tableau and Power BI to present insights to stakeholders, facilitating data-driven decision-making.

•Collaborated with cross-functional teams to define key performance indicators (KPIs) and developed dashboards for real-time monitoring and reporting.

•Identified and investigated data quality issues, implementing data cleansing strategies to ensure accuracy and integrity of data.

•Conducted ad hoc analyses to support business initiatives and provide insights into market trends and customer preferences.

Amex, New York, New York Jul 2020 to Feb 2022

Sr Data Analyst Responsibilities:

•Led a team of data analysts in designing and implementing data-driven solutions for business problems.

•Developed and maintained complex SQL queries and scripts to extract, transform, and load data from various sources.

•Conducted in-depth statistical analysis to identify patterns and trends in customer behavior, resulting in improved customer segmentation strategies.

•Collaborated with data engineers to design and optimize data pipelines and workflows.

•Prepared and presented analytical reports to senior management, providing actionable recommendations for business improvement.

•Mentored junior data analysts and provided guidance on best practices in data analysis and visualization.

Neiman Marcus Group, Dallas Texas Jun 2019 to Jun 2020

Data Analyst Responsibilities:

•Gathered and analyzed data from multiple sources, including customer surveys, website analytics, and transactional databases.

Developed data models and performed regression analysis to assess the impact of marketing campaigns on customer acquisition and retention.

Designed and implemented automated data reporting processes, reducing reporting time by 50%.

•Collaborated with marketing teams to identify target customer segments and optimize marketing strategies.

•Conducted data mining and segmentation analysis to identify cross-selling and upselling opportunities.

Illinois Department of Innovation and Technology Nov 2017 to May 2019 Data Analyst Responsibilities:

•Creating Python scripts in Databricks to automate the valuation of internal projects at Capital One.

•Extract data from data lakes (such as One Lake) and carry out a variety of processes to separate the data into the necessary format before running SQL queries and python scripting to obtain the appropriate results.

•Regular communication with the marketing and finance teams to update the data changes that occur daily, weekly, or monthly and produce reports.

•To ensure that the results that are projected are accurate, the output data from these produced scripts will be tested using the best test scenarios.

•Linking Snowflake to Data-Bricks to view the results; establishing and allowing access to tables to the finance team and production environment.

•Significant expertise with the ETL tool Informatica on different databases, including Oracle, SQL Server, Teradata, and MS Access.

•I did Azure Active Directory work.

Metrixlab, India May 2013 to Jul 2017

Tableau Developer Responsibilities:

•Used agile approach in collaboration with team members, the product owner, and the technical manager to clarify requests and collect requirements through a variety of meetings.

•Sequential files from diverse Source Systems are used to implement Data Warehouse.

•Created mapping for Data Mart and Warehouse items.

•Using the DataStage tool, design and develop ETL tasks to load data warehouses and Data Marts.

•Created Unix Shell Scripts to automate the data loading procedures into the desired data warehouse.

•In charge of overseeing the delivery, dealing with stakeholders, and obtaining requirements.

proficient in using Snowflake and Tableau 2019.2 versions, as well as SQL to extract data from Snowflake for developing queries and data analysis for dashboard building.

•Azure Blob storage offers a scalable and highly available object storage solution for big data.

•Azure Power BI is a cloud-based business intelligence and data visualization service that analyzes and presents data.

•Developed heat maps, scatter plots, geographic maps, pie and bar charts, symbol maps, horizontal bars, histograms, packed bubbles, and candle stick statistics for Tableau data visualization.

Written functions, SQL logical statements, and procedures for the data analysis.

Developed intricate calculations for Tableau reports, including rapid table calculations, string manipulation, basic arithmetic calculations, custom aggregations and ratios, date math, and logic statements.

•In charge of moving old programs to the AWS and Azure clouds and SaaS solutions.

•Created dashboards utilizing Tableau's calculations and parameters. For users of Tableau Visualization, near-real-time monitoring dashboards were created and implemented. developed the reports by testing the data connectors that transferred the database's data to the Tableau dashboards.

•Using Tableau Desktop, created intricate visuals and reports with data from relational databases.

Education:

•Master of Science in Computer Science University of Illinois at Springfield

•Bachelor of Science in Computer Science Jawaharlal Nehru Technological University

Contact this candidate