Hello , I'm
Pragati Ingole,
a Data Analyst
Passionate and detail-oriented communicator with 3 years of experience working across cross-functional teams.
Skilled data analyst leveraging analytics tools to deliver insights. Proven adaptability and quick learning of new technologies for continuous improvement. Seeking full-time opportunities and willing to relocate all over USA.
About Me
I am Pragati Ingole, a driven and detail-oriented data Professional. Recent May 2024 graduate in a Master of Science in Information Systems with a concentration in Business Analytics at California State University, Fullerton. My academic journey and professional experiences are rooted in a deep commitment to leveraging data to drive business success and innovation.
With a solid foundation in both engineering and business analytics, my career spans roles where I have significantly enhanced data-driven decision-making processes. My technical skills encompass advanced proficiency in Python, R, SQL, and various ETL tools like Alteryx, as well as business intelligence platforms such as Tableau and PowerBI. I am adept at statistical analysis, data modeling, and developing predictive models that transform raw data into actionable insights.
Throughout my roles, from a Data Analyst at Bristlecone to a Graduate Data Analyst Assistant at CSU Fullerton, I have consistently improved operational efficiencies and contributed to strategic projects that capitalize on data insights to solve complex business challenges. My hands-on experience in data engineering includes optimizing SQL data migrations, automating ETL processes, and designing robust data infrastructures using contemporary cloud technologies like AWS and database systems like PostgreSQL and MongoDB.
I am actively Seeking full-time opportunities and willing to relocate all over USA where I can bring my expertise in data and business analytics to a dynamic team dedicated to creating impactful, data-driven outcomes. Let's connect and explore how I can contribute to your organization's success with my analytical skills and business acumen.
Field of Interest
Data Analytics
-
1. Languages
Python (NumPy, Pandas, Matplotlib, Seaborn), R (ggplot2, Shiny), SQL
-
2. Statistical Techniques
Hypothesis Testing, Regression, ANOVA, A/B Testing
-
3. ETL Reporting Tools
Tableau, PowerBI
-
4. Skills
Data Analysis, Data Manipulation, Data Cleaning, Data Transformation, Reporting and Visualization, Requirements Gathering, Marketing Analytics
Data Engineering
-
1. Languages
Python, SQL, VBA, C, C++, HTML, CSS
-
2. Database Systems
PostgreSQL, PG Admin, SAS, SPSS, MongoDB, MySQL, NoSQL, RDBMS
-
3. Version Control/Cloud
Git, GitHub, Amazon Web Services
-
4. Skills
Database Systems, Data Modeling, ETL Procedures, Data Transformation
Business Analytics
-
1. Software/Tools
Excel (chart functions), JIRA, Alteryx
-
2. Languages
SQL, VBA
-
3. ETL Reporting Tools
Tableau, PowerBI
-
4. Skills
Data Analysis, Reporting and Visualization, SDLC, UML, Relational Databases, Strong communication and Presentation skills
Latest Projects
Experience
Data Analyst Lowe's Retail
- Developed KPIs, evaluated performance, and created comprehensive Power BI dashboards.
- Utilized Agile principles, including SCRUM methodology, increasing decision-making speed by 15%.
- Developed churn KPIs for inventory supplies using complex SQL codes, window functions, enhancing customer retention, reducing response time by 2 hours , and boosting CRM efficiency by 20%.
Graduate Machine Learning Research Analyst California State University, Fullerton, CA
- Partnered with the California State Government to gather and analyze data from alumni (2018-2023) of California community colleges, focusing on the relationship between their field of study and current employment.
- Conducted data preprocessing and applied machine learning models to predict employment outcomes, examining alignment with field of study, employment rates, and contributing factors to unemployment.
- The analysis was used to recommend improvements in coursework, internships, apprenticeships, and extracurricular activities to enhance student career alignment and job opportunities.,
Business Data Analyst Cognizant, Pune, India
- Collaborated with cross-functional teams to deliver a $50M project by translating business needs into automated ETL pipelines using Informatica Power Center, reducing loan processing time from 40 days to one week.
- Utilized Excel and SQL Window function and deployed quality PL/SQL codes using stored procedures, views, functions, window & functions.
- Loaded data from EDW into SALESFORCE through Informatica and validated data in nCino application of Salesforce.
- Demonstrated leadership qualities with peers and applied managing up principles, automating Informatica jobs using UNIX Shell Script and CRON, resulting in a 40% reduction in manual resources.
- Involved in projects utilizing big data technologies (Hive, Sqoop, and Python) and cloud technologies (Redshift, S3). Developed, maintained interactive dashboards and KPIs using PowerBI DAX, resulting in automated processes with enhanced data accuracy.
Data Analyst Dataeaze pvt ltd Pune, India
- Led real-time data analysis, ad hoc analysis, and business insights at every decision point during the implementation of a future-ready ERP SAS system, esulting in a 35% increase in decision-making speed and $30k in savings resulting in a 35% increase in decision-making speed and $30k in savings.
- Conducted data analysis using Excel, SQL (complex queries, data aggregation), Python (Pandas, NumPy, data visualization) to identify customer behavior trends, retaining 1,000 additional customers & increasing revenue by $50k
Education
Masters of Science in Information Systems from California State University Fullerton
MS in Information Systems (Business Analytics) showcases a diverse and comprehensive study underlines a robust curriculum aimed at equipping you with advanced skills in analytics, database management, marketing, and software development, preparing you for a wide array of challenges in the information systems. COURSEWORK- Managerial Communication, Statistics for Data Science, Business Database Design, Financial Accounting, Principles of Business Intelligence, Advanced Software Development for Web Applications, Principles of Marketing, Data Warehousing Foundations for Business Intelligence, Spreadsheet Modeling, Business Data Transformation, and Data Mining for Business.
Bachelors of engineering from University of Pune, India
In the Electronics and Telecommunication Engineering program at Pune University, students dive into a comprehensive curriculum designed to equip them with a solid foundation in both electronics and telecommunications. The coursework encompasses a wide array of subjects that cover the essentials and advanced topics in the field. COURSEWORK- Engineering Mathematics, Signals and Systems, Data structures and Algorithms, Internet Of Things, Electronic Devices and Circuits, Digital Electronics, Analog communications, Computer Networks and Security, Radiation and Microwave Technology, Mobile communications, Audio Video engineering.