Siddharth Singh Email & Phone Number

London, Gb

New York, New York, United States

New York, New York, United States

• Collaborated with FP&A teams to understand data requirements and design data pipelines to collect, transform, and store financial and operational data • Managed end-to-end production data modeling, encompassing data refreshment, ensuring data integrity with upstream systems, promptly addressing issues, and upholding comprehensive documentation • Implemented a seamless transition from Python-based ETL to leveraging Snowflake, resulting in improved efficiency and performance by 40%• Created dynamic dashboards using Tableau to visually represent key financial metrics, enabling efficient data-driven decision-making within the FP&A team• Streamlined ETL processes by implementing incremental data loading, caching strategies, and parallel processing• Implemented data quality checks and validation processes, reducing data errors by 35% and improving overall data accuracy• Employed columnar storage formats like Parquet to reduce storage footprint and accelerate query performance by 82%• Provided training and support to FP&A staff on data tools and reporting processes, enhancing their analytical capabilities• Built an user input form to streamline data collection, automating monthly report generation and eliminating the need for manual intervention • Documented data engineering processes, ensuring knowledge transfer and compliance with best practices • Implemented version control systems to track changes in code and configuration, fostering collaboration and codebase integrity

New York, New York, United States

• Led and managed the successful transition of client's legacy ERP systems to NetSuite• Built fuzzy logics to map customer information coming from different ERP systems, reducing the manual effort by 85%• Designed and optimized complex SQL queries to extract and transform data from legacy ERP systems efficiently • Created stored procedures to automate the data cleaning and standardization process before transferring data to NetSuite

Hoboken, New Jersey, United States

• Designed logics & created ETL pipelines to enhance data infrastructure by improving the efficiency of moving data from database to Big Query by 40%• Reduced 33% of GCP storage by creating SQL deduplication logics and python scripts for optimized data insertion• Performed ad-hoc analyses on business trends and results to provide insights to multiple functions within company• Built python scripts to fetch client data using API to perform analysis & store it in Big Query• Generated reports & created tableau dashboards to highlight product utilization metrics to help product & sales teams improve 7% per month on revenue• Documented business requirements and transformed them into tableau dashboards to highlight KPIs

Mumbai, Maharashtra, India

• Gathered & analysed data to generate reports & created dashboards to highlight the KPIs to improve team performance• Automated service request logged with service desk to bring down call volume by 30% • Automated process of encrypting client payroll data for added security, reducing manual effort by 80%• Performed analysis on historical data to improve the closure rate of tickets logged by 20%• Actively engaged with internals clients throughout the organization to meet and exceed different requirements• Managed data archival and reporting module to extract information from database using SQL developer

Master Of Science - Ms, Business Intelligence And Analytics, Cgpa- 3.94

Bachelor Of Technology (Btech), Engineering