Data/BI Analyst

Satyam Singh

Fairfax, VA *****

202-***-**** II ********@***.*** https://www.linkedin.com/in/singh-satyam1299 Tableau Public EDUCATION

Master of Science in Data Analytics Engineering Graduated: 05/2024 George Mason University, Fairfax, Virginia GPA: 3.83 Bachelor of Engineering in Computer Science Graduated: 06/2022 Savitribai Phule Pune University, Pune, Maharashtra, India GPA: 3.93 Technical Skills

Programming: Python, R, R Shiny, Java, PySpark Databases: SQL, Snowflake, TeraData SQL, SQL Server Data Visualization: Tableau, Microsoft Excel, Power BI Cloud Platforms: MS Azure, AWS Machine Learning: EDA, Regression, Classification, feature extraction, A/B testing, ETL (Extract, Transform, Load) Packages/Tools: Pandas, Numpy, TensorFlow, Sci-kit learn, Git, Matplotlib, Seaborn, Plotly, ggplot, dyplyr, tidyverse PROFESSIONAL EXPERIENCE

Management Analyst II

Fairfax County Government, Fairfax, VA, USA 07/2024 – present

● Developed and maintained interactive KPI dashboards in Power BI, utilizing Power Query, DAX, and SQL to optimize resources and deliver actionable insights to senior leadership.

● Implemented advanced data collection and storage solutions using Power BI, streamlined Federal Grant reporting processes and improved data accessibility across departments, resulting in 50% faster reporting turnaround.

● Deployed advanced analytics dashboards in Power BI for management, delivering week-over-week trend analysis, error page monitoring, using DAX measures and calculated columns to support data-driven decision.

● Provide technical support and train staff across departments in the use of data collection tools and business applications, including Microsoft Power BI and SharePoint.

● Ensured data accuracy by establishing data governance best practices, validating datasets,maintaining privacy standards.

● Lead ongoing QA reviews for data systems, ensuring compliance with performance contracts and internal policies.

● Collaborate with IT, access/security teams, and business units to resolve system issues and conduct root cause analysis. Data Science Intern

Arlington County Government, Arlington, VA, USA 09/2023 – 05/2024

● Coordinated comprehensive audits and reviews of diverse County programs, ensuring data quality and execution of filtering, sorting, and validating data operations.

● Spearheaded the successful completion of the Fire Department Audit Review, delivering strategic recommendations that led to an 11% cost reduction and a 23% revenue enhancement through thorough revenue analysis and pricing strategies.

● Pioneered the implementation of a robust data storage system, consolidating and cleaning information from diverse sources, resulting in a 40% reduction in data retrieval time for audit reviews through AGILE frameworks. Inventory Analyst Part-Time (Student Employee)

Eaglebank Arena, Fairfax, VA, USA 01/2023 – 05/2024

● Streamlined inventory management processes, resulting in a 15% increase in operational efficiency. This ensured event stands were consistently well-stocked, minimizing disruptions and fostering a smooth customer experience.

● Implemented a comprehensive inventory tracking system, achieving a 20% reduction in stock discrepancies. This enhanced supply chain visibility and optimized resource allocation.

● Leveraged data analysis to provide strategic procurement recommendations, successfully preventing stockouts during peak event periods. This proactive approach ensured seamless event execution. ACADEMIC PROJECTS

UK Bank Customer Analysis Tableau, Excel

● Employed digital tech, business intelligence, behaviour analysis, and meeting client acquisition requirements.

● Achieved a 25% revenue increase and a 10% cost reduction for the client through business analytics.

● Developed Tableau customer analysis dashboard with metrics to meet client acquisition's business needs, resulting in a 15% upsell and 20% churn reduction through business analytics. Statistical Analysis on Employee Attrition SQL Server, R, dyplyr, ggplot, tidyverse

● Conducted thorough research and data analysis using R, identifying critical factors impacting attrition.

● Achieved a 20% reduction in attrition and drove revenue growth through insightful analysis and strategy development.

● Analyzed research findings and data visualizations to propose a 10% salary increase and 5% reduction in working hours; successfully decreased annual employee turnover by $500k and drove revenue growth. Product and Retail Analysis Python, Numpy, Pandas, Matplotlib

● Cleaned and validated Python data, researched 50,000+ sales transactions over 3 years, with merger considerations

● Analyzed sales patterns in the retail sector to identify trends and anomalies, leveraging Python, Numpy, Pandas, Matplotlib, and statistical models resulting in a significant 12% increase in overall revenue streams.

Contact this candidate