Data Analyst Analysis

K R U P A L P A C H P U T E

Houston, TX- ***** ****************@*****.***

OBJECTIVE

Data Analyst with 4+ years of experience in leveraging data, financial analysis, and visualization tools to drive strategic decision-making. Proficient in Tableau, Excel, Python, ETL, and SQL for extracting actionable insights from complex datasets. Expertise in IT and software domains with a strong foundation in statistical modeling and programming. SKILLS AND ABILITIES

• Programming: Python, R, SQL, MATLAB, SAS

• Technical Skills: Agile, Scrum, SDLC, SAP, Budgeting and Financial Analysis, Data-Driven Strategy Formulation, Resource Allocation, Data Analysis, Requirements Gathering and Elicitation, Exploratory Data Analysis (EDA), Data Modelling and Forecasting

• Additional Skills: Attention to Detail, Cross-Team Collaboration, Data Analytics/Visualization, Customer Service, Adaptable

• Core tech: MS Office, Advanced Excel, Power BI, Tableau, Google Analytics, KNIME, SharePoint, JIRA, Trello, Confluence, Asana, Miro, AWS Cloud, Postgres, Kafka, Databricks, Looker, Microsoft SQL Server, Snowflake, GitHub, Apache Spark, VBA, Google, Big Query EXPERIENCE

Benda Infotech, Remote, Data Analyst, May 2023 - at present

• Optimized the organization’s data warehousing processes by identifying inefficiencies in data storage and retrieval and implementing advanced indexing techniques, which reduced data query time by 30% and improved overall system performance by 20%.

• Created complex SQL queries and stored procedures to improve performance by 35%, while automating data workflows with Python to reduce model training time by 40% and boost operational efficiency.

• Constructed an automated ETL pipeline to transfer user activity and song metadata from S3 to Redshift, managing over 1 million records and streamlining data integration for better decision- making.

• Built dynamic dashboards in Power BI, enhancing real-time decision-making and boosting operational efficiency by 30%.

• Enabled actionable insights and strategic decision-making using Tableau and Excel, generating an additional $600k in annual revenue through enhanced analytics and reporting capabilities. Accenture, Pune, India, Sr Data Analyst, August 2019 – June 2021

• Championed the development and execution of a real-time tracking system for production in Tableau, enabling comprehensive KPI monitoring across 10 production lines and accelerating decision- making by processing over 500,000 data points weekly.

• Identified and compiled data from various internal sources (Excel spreadsheets, local databases) and external sources (third-party APIs, online datasets), ensuring comprehensive data collection of over 100,000 records monthly.

• Instrumental in the design and implementation of an ETL pipeline processing 500,000 records daily, enhancing query performance by 35% and improving data accuracy, contributing to data driven insights and streamlined operations.

• Formulated and executed transformation rules to cleanse, normalize, and aggregate data, embedding error handling mechanisms while processing over 350,000 records daily to ensure data consistency, accuracy, and integrity against anomalies.

• Automated the loading of transformed data into a centralized data warehouse, optimizing query performance to handle 200 concurrent queries efficiently and improving storage efficiency by 10 terabytes.

• Implemented a customized project tracking system in JIRA to monitor project health, identify potential risks, and automate performance reporting, leading to improved visibility and efficiency across multiple projects.

• Boosted data processing speed by 40% through the implementation of SQL and Python scripts, enhancing the timeliness and reliability of analytical reports, and reduced manual entry errors by 30% use Prefect for automated data validation, increasing overall data accuracy.

• Trained six end users in finance, operations, and marketing to utilize Tableau dashboards, cutting report generation time by 30% and empowering teams to extract actionable insights, improving overall workflow efficiency.

Bharti Airtel Limited Pune, India, Networking Analyst, Nov 2018 – May 2019

• Launched performance monitoring dashboards in Power BI that aggregated data from 7 different sources, enhancing visibility into network health and enabling a 30% increase in system uptime and reliability across the organization.

• Automated the consolidation of reports from various sources into a single Excel sheet by developing an efficient macro, streamlining the data integration process and resulting in a savings of 20 hours of manual work per week while eliminating errors in data entry.

• Analyzed 100,000+ customer interactions through a custom-built Python script, identifying key trends that allowed the development of personalized outreach strategies; enhanced customer retention rates by 15% over six months.

• Analyzed network performance in low-coverage areas against population density and user distribution, leveraging geospatial analysis to identify opportunities for a 25% increase in service reach and support the deployment of 15 additional towers.

• Performed advanced data preprocessing methodologies that successfully reduced model training time by 40% while preserving predictive accuracy, significantly enhancing the overall efficiency and effectiveness of the predictive model.

• Interpreted the results generated by the predictive model to extract actionable insights, which improved risk assessment processes and contributed to more informed decision-making regarding credit card issuance and management strategies. EDUCATION

• W. P. Carey School of Business – Arizona State University - Master of Science in Information System Management (Major in Data Analytics) Aug 2022 - July 2023

• G. H. Raisani College of Engineering, India - Bachelor of Engineering in Computer Science July 2015 – June 2019

CERTIFICATIONS

• Microsoft Certified: Data Analyst Associate

• Excel Data Analysis: Forecasting

• Artificial Intelligence Foundations: Machine Learning

• Google AI Professional Certificate

Contact this candidate