Ankit Singh Email & Phone Number

New York, NY, US

New York, NY, US

• Power BI Infrastructure & Report Migration: Architected a secure on-premise Power BI Report Serverintegrated with SQL Server and led the migration of 100+ reports from Tableau and legacy systems to Power BI, enhancing.
• Custom Report Development & Business Alignment: Developed customized Power BI reports tailored to evolving business needs and KPIs, aligning reporting solutions with strategic objectives in partnership with.
• Embedded Analytics for Enhanced Accessibility: Collaborated with web development teams to embedPower BI reports in a subscriber website, improving user experience and broadening data accessibility.
• Data Migration & Workflow Automation: Directed data migration and cleansing, leveraging Python scripts for automation to ensure data accuracy and optimize processing workflows.
• Advanced-Data Modeling with DAX & M Query: Enhanced report performance and interactivity by designing complex data models using DAX and M Query, establishing standardized practices across teams for consistent and.

Cincinnati, Ohio, US

• Customer Conversion & Behavioral Insights: Directed a high-impact project with three data analysts,improving customer conversion rates by 6% through data-driven insights using Python, R, and SQL. Streamlined 1.
• Real-Time Customer Retention System: Developed a customer behavior monitoring system on Databricks using Python and SQL, identifying at-risk customers and informing retention strategies, which increased customer.
• Automated ETL Pipeline Development: Designed and implemented end-to-end ETL pipelines with Python, Alteryx, and Azure Data Factory, cutting ETL processing time by 20%. Integrated Adobe Analytics data into Tableau.
• Database Infrastructure & Performance Enhancement: Led initiatives to optimize database infrastructure, enhancing data reliability and scalability. Worked closely with development teams to execute.
• Advanced BI Reporting & Cross-Functional Impact: Developed interactive Power BI dashboards with complex DAX and M Query for real-time insights, aligning analytics with marketing and product objectives. Mentored team.

Richardson, Texas, US

• Workload & Capacity Management Automation: Led the development of a Python-based workloadmanagement tool for data analysis and visualization in Power BI, automating manual workload management by up to 75% and.
• 3-Tier Data Warehouse Architecture: Architected a scalable 3-tier data warehouse on Databricks, collaborating closely with IT teams to ensure efficient implementation and ongoing maintenance, enhancing data storage and.
• ServiceNow Process Optimization: Developed ServiceNow dashboards and an automated bot using Python, reducing ticket backlogs by 20% and improving the Net Promoter Score (NPS) by 18%. Led requirements gathering and.
• Real-Time Data Processing with Azure: Managed data workflows with Azure Data Factory, Synapse Analytics, and Stream Analytics, facilitating real-time data processing for streamlined operations and improved insights.
• Tableau Server Administration & Reporting: Oversaw Tableau Server projects, managing permissions, and ensuring secure data access. Created data-driven dashboards, enhancing decision-making through real-time reporting.
• Data-Driven Decision Making: Collaborated with stakeholders to leverage insights from Cobalt (in-house software), optimizing internal workflows and improving service delivery. Streamlined ETL processes with Power.

Pittsburgh, Pennsylvania, US

• Data-Driven Business Strategy & Marketing Insights: Conducted in-depth data analysis using Python,Snowflake, and SAS, informing product strategy and marketing campaigns. This approach contributed to a 32% increase in.
• CRM Insights & Forecasting: Extracted valuable customer insights from Salesforce and developedPython-based sales forecasting models, supporting resource allocation and enabling targeted marketingcampaigns.
• Data Warehousing & OLAP Development: Designed and implemented comprehensive data warehousing solutions using SSIS, SSAS, and SSMS, enhancing data accessibility and streamlining reporting.
• Change Management & Stakeholder Engagement: Developed communication and training plans to facilitate smooth transitions during FP&A system enhancements. Ensured continuous value delivery by aligning feature.
• Database Performance Optimization: Identified and resolved performance bottlenecks, ensuring efficient database operations. Collaborated with Account Executives to support proposal responses (RFP, RFI), aligning data.

Gurgaon, Haryana, IN

• Data-Driven Marketing Strategy: Leveraged Python, Snowflake, and SAS to conduct in-depth data analysis, 2 supporting product strategy and marketing campaigns, resulting in a 32% increase in product adoption.
• Sales Forecasting & CRM Insights: Utilized Salesforce to extract customer insights and developed forecasting models in Python, enabling data-informed decision-making and improved resource allocation across sales teams.
• End-to-End Data Warehousing Solutions: Developed and implemented data warehousing and OLAP solutions with SSIS, SSAS, SSMS, and SSRS, enhancing data accessibility and optimizing reporting processes for faster insights.
• Marketing Campaign Optimization: Analyzed marketing campaign performance to identify high-impact channels and audiences, informing strategic improvements in campaign ROI and brand awareness.
• Quantitative Analysis & Ad-hoc Support: Provided quantitative analyses for ad-hoc requests using SAS and Python, delivering actionable insights to support key business decisions.

Master'S Degree, Software Development & Engineering

Bachelor'S Degree, Computer Science