Shrishti Rai
Assistant Manager
Pune
Summary
Results-driven data analyst with over 5 years of expertise in SQL database management and data visualization, adept at transforming complex data into actionable insights. Specializes in creating interactive dashboards and optimizing ETL processes to enhance data accessibility and usability. Proven track record of influencing strategic decisions through strong problem-solving capabilities and effective communication. Currently serves as Assistant Manager at Vodafone, leveraging analytical skills to drive business success.
Overview
5
5
years of professional experience
3
3
Certifications
2
2
Languages
Work History
Assistant Manager
VOIS
09.2024 - Current
- Streamlined data delivery for enterprise reporting at Vodafone Germany.
- Developed SQL queries in Teradata Studio to extract essential datasets.
- Executed BTEQ scripts on Linux, verifying output accuracy and completeness.
- Conducted performance reviews to identify areas for employee improvement.
- Performed validation checks on data prior to reporting to ensure reliability.
- Interpreted data requests from reporting teams for timely access.
- Utilized Git for effective management of SQL scripts and version control.
- Collaborated with cross-functional teams to resolve data discrepancies.
Data Analyst
IBM
11.2023 - 08.2024
- Performed data analysis and query creation with Oracle SQL Developer to support data management.
- Managed data loading tasks using Oracle SQL Developer, optimizing system performance.
- Delivered application support and maintained effective data management practices within UPS.
- Employed Secure CRT tool alongside Linux commands for efficient data refresh in DB2 database.
Data Analyst
IBM
02.2022 - 11.2023
- Developed 7-day rolling forecast system for Northwest Natural Gas Company.
- Utilized Informatica IICS for seamless data integration and Azure for scalable storage solutions.
- Designed interactive Power BI dashboards to visualize gas supply and demand trends, supporting strategic decisions.
- Collected and analyzed data to assess business and market trends, facilitating informed decision-making.
Data Analyst
Infosys
08.2021 - 02.2022
- Worked with tableau for creating interactive dashboards for Citi Bank.
- Developed reports and dashboards, ensuring they met user needs and business goals with the help of tableau desktop.
- Created visually appealing dashboards with different chart types like Line, Bar, Pie, Scatter, Heat Maps, Dual Axis, and Geo Maps.
- Implemented Tableau features to make dashboards interactive and logical.
- Extracted data from various sources and performed data analysis using SQL queries.
System Engineer (Visualization Developer)
Infosys Ltd
12.2020 - 08.2021
- Contributed to the HSBC Account as QlikSense expert. Streamlined data retrieval and manipulation processes. Managed application development using Qlik Sense from design to deployment.
- - Served as QlikSense expert for HSBC, managing data retrieval and application development.
- - Developed reports mirroring SAP using QlikSense and SQL.
- - Improved data retrieval efficiency with advanced SQL Server queries.
- Achievements:
- Proposed and implemented design alternatives, enhancing client satisfaction.
System Engineer
Infosys Ltd
11.2020 - 12.2020
- Completed SSIS and SQL training; developed and executed SSIS packages for ETL processes. Applied SSIS best practices for efficient data workflows and automation. Utilized advanced SQL queries for data manipulation.
Education
B.E - Electronics And Communication Engineering
Gyan Ganga Institute of Technology And Sciences
06.2020
SSC/HSC - undefined
Little World School
05.2016
Skills
- Database management using SQL
- Data visualization tools
- Data analysis and visualization
- ETL process management
- Power BI and QlikSense
- Oracle SQL Developer and Teradata Studio
- Experience with GitHub workflows
- Experienced with Linux systems
- Analytical problem-solving
- Experienced in data modeling techniques
- Data management expertise
- Effective teamwork
- Strong verbal communication
- Familiar with Google Cloud Platform
- Experienced in Python development
- Data integration processes
- Prioritization and scheduling
- Effective multitasking
Accomplishments
- Recieved Silver Award at VOIS for handling the UER area very well.
- Earned an Insta Award at Infosys for strong commitment and dedication toward the job.
- Received the Pinnacle Award at IBM Best Individual Contributor.
Certification
Microsoft Certified: Power BI Data Analyst Associate (2023)
Timeline
Assistant Manager
VOIS
09.2024 - Current
Data Analyst
IBM
11.2023 - 08.2024
Data Analyst
IBM
02.2022 - 11.2023
Data Analyst
Infosys
08.2021 - 02.2022
System Engineer (Visualization Developer)
Infosys Ltd
12.2020 - 08.2021
System Engineer
Infosys Ltd
11.2020 - 12.2020
SSC/HSC - undefined
Little World School
B.E - Electronics And Communication Engineering
Gyan Ganga Institute of Technology And Sciences