BI /Data Engineering Manager
Resume:
Professional Summary
Work History
BI Manager/Data Engineering Lead – SouthCo, Concord Ville, PA, USA: Jan 2024 – Till Date
• Led the end-to-end migration from on-premises SQL Server, SSIS, and SSRS to Microsoft Fabric, leveraging Azure SQL, Databricks, and Spark to modernize data infrastructure and improve scalability.
• Architected scalable cloud-based data models, ensuring seamless transition from legacy systems and enhancing data accessibility and performance.
• Collaborated with senior leadership (SLT) to gather requirements and design comprehensive BI solutions tailored to executive reporting needs.
• Oversaw enterprise-wide data intelligence initiatives, delivering actionable insights through Power BI dashboards for marketing and finance teams.
• Optimized high-volume ETL processes, identifying inefficiencies and implementing archiving strategies, reducing storage costs by 30%.
• Troubleshot and enhanced data workflows, optimizing SSIS packages through indexing, streamlined workflows, and better temporary storage management, significantly improving ETL reliability.
• Designed and deployed cloud-native data pipelines for large-scale text processing using Azure Databricks and Spark, enabling real-time analytics and insights.
• Developed Salesforce dashboards and integrated website analytics to track customer behavior and improve marketing ROI.
• Orchestrated complex ETL workflows using Apache Airflow and Azure Data Factory, automating data ingestion and transformation pipelines across cloud and on-premise environments, leading to a 30% reduction in processing time.
• Conducted A/B testing and integrated Google Analytics with BI solutions to boost engagement and link web traffic to sales.
• Automated reporting processes by implementing Power Automate to extract data from SharePoint lists, saving over 10 hours of manual effort per week. Tech Stack: Microsoft Fabri/Azure Data Bricks, Python, Spark, Power BI, SSIS, SSRS, Salesforce, Snowflake, Power Automate, SQL Server, SAP S/4 HANA Associate Director/Data Product Owner – WTW, Philadelphia, USA: Jul 2019 till Sep 2023
• Spearheaded the product management of BI solutions, guiding a cross-functional team in delivering innovative data products that enhanced decision-making and drove operational improvements.
• Managed the end-to-end lifecycle of data products, including cloud migration, data integration, and feature development, resulting in enhanced data-driven decision-making across multiple business functions.
• Led the architecture and design of scalable data solutions in Azure Synapse, aligning with business goals and providing clear product roadmaps to senior leadership for product development and enhancements.
• Worked with product, engineering, and data science teams to define key metrics, design dashboards, and implement new data solutions that improved operational performance and customer engagement.
• Drove product strategy and execution for large-scale data products, ensuring they met data governance and regulatory compliance requirements, including GDPR and CCPA for handling customer data.
• Directed the development of machine learning models to identify anomalies, saving $800k within the first quarter, demonstrating the impact of data products on business outcomes. Tech Stack: Azure Devops, Data Factory, Power BI, DAX, Visual Studio, SQL Server, Analysis service Modeling, ML, Python, Spark, Power Automate, Synapse Analytics, Data Lake, OAC Results-driven Senior Data Engineering Leader with over 15 years of experience designing, developing, and optimizing scalable data platforms and analytics solutions. Proven expertise in leading cross- functional teams, architecting cloud-based data ecosystems (Azure), and driving business intelligence initiatives for critical decision-making. Passionate about using Big Data technologies, distributed systems, and AI-driven solutions to create innovative data solutions that align with business goals, while improving data quality, governance, and operational efficiency in complex environments. Strategic Planning & Execution
Stakeholder Engagement &
Collaboration
Team Building & Mentorship
Excellent Communication &
Presentation
Leadership & Soft Skills
8
***************@*****.***
Contact Details
Philadelphia, USA
Shilpa Sripathi
Data Product/Analytics Manager
Technical Skills
Programming Languages:
SQL, Python
Data Technologies:
Azure Data Factory, SSIS, ODI,
Synapse, Spark, Snowflake
Cloud Platforms:
Azure, Oracle Cloud
Databases:
SQL Server, MYSQL, Oracle SQL,
PostgreSQL
BI & Visualization:
Power BI, Tableau, Oracle BI, BI
Publisher
Machine Learning & AI:
Azure ML Studio,
Rapid Miner
Tools:
Git, JIRA, Visual Studio
Methodologies:
Agile, SCRUM, DevOps, CI/CD
Analytics Lead - WTW, Philadelphia, USA: Nov 2017 till Jul 2019
• Responsible for effectively determining the size of business requirements, tasks, issues, and changing requests for each sprint cycle.
• Led a team of skilled analysts and developers to successfully design and execute comprehensive business intelligence solutions for stakeholders.
• Orchestrated project kick-off meetings, facilitating collaboration and coordination between analysts and developers.
• Owned and managed the EPM Data Warehouse, leading data enhancements and cloud migration initiatives.
• Led the end-to-end execution of new analytical solutions, ongoing enhancements, and bug fixes for Client Revenue, MI, FCP & AR projects.
• Ensured data accuracy, integrity, and compliance with regulatory standards, fostering trust in analytics insights and facilitating informed strategic decisions.
• Experienced in writing complex DAX queries for creating analytics reports on Power BI Desktop and implementing data modeling techniques using Power Query editor in Power BI and Analysis Services model in Visual Studio.
• Experience in designing and deploying the tabular model using visual studio to dev, test and production environments.
• Designed and implemented end-to-end data integration pipelines using Azure Data Factory, ensuring seamless data flow and efficient processing.
• Optimized data pipelines for performance and scalability, improving data processing time by 30% and managed Full/Incremental Load processes ensuring efficient data integration and synchronization.
• Implemented Incremental load refresh on the Power BI platform, optimizing data processing and reducing refresh time by 50%.
• Implemented row-level data security and workspace authentication measures in Power BI, ensuring the confidentiality and integrity of sensitive information.
• Developed multiple report visualizations using Power BI, establishing connections to OBIEE answers for data retrieval and analysis.
• Worked on power automate to create flows to trigger the power bi refresh based on the data load completion.
Tech Stack: Power BI, Analysis service Modeling, Data Factory, Synapse, Power Query, DAX, Visual Studio, SQL Server 12.0.2, Azure Devops, OBIEE 12C, OAC Senior Developer – WTW, Philadelphia, USA: Nov 2012 till Nov 2017
• End to end implementation of billing cycle reports (using new ETLs, new BIP reports, PL/SQL packages, Shell scripts) using bursting feature to deliver the reports to finance team to know list of clients who have outstanding balances to pay off.
• Developed and implemented over 100 HR and Finance BI Publisher reports as part of the BI Central project, subsequently publishing them on the Report2Web portal.
• Delivered complex bonus and payments solutioning using HCM tables/schemas and automated the bursting process to multiple target locations (like email, shared drive). Tech Stack: OBIEE 11g, Oracle11g, BI APPs 7.9.6.3, OBIEE 12C, Informatica 9.0.1, ODI 11.1.1.9, Windows, Linux, Exadata, JIRA
Senior BI Consultant – Walmart, Arkansas, USA: Nov 2011 till Nov 2012 Project: Compliance Tech Stack: OBIEE 10g, BI Publisher10g, Oracle 11g, Tableau, Data stage BI Consultant – United Airlines, Chicago, IL, USA: Jan 2011 till Nov 2011 Project: Mileage Plus Redemption Tech Stack: OBIEE 10g/11g, Hyperion BRIO 6.5, Windows, Unix BI Consultant – Amerisource Bergen Cooperation, PA, USA: Jul 2010 till Jan 2011 Project: Actuate Reports Migration Tech Stack: BI Publisher10g, Oracle 11g, HP QC, Siebel Medical BI Consultant – Life Technologies, Carlsbad, CA, USA: Feb 2010 till Jul 2010 Project: Actuate Migration Tech Stack: BI Publisher10g, Oracle 11g, HP QC, Siebel Medical 8.0.0.8 BI Developer – Eli Lilly, Indianapolis, USA: Mar 2009 till Feb 2010 Project: Outcome& Medical Liaisons Tech Stack: BI Publisher, Siebel MedicLeaderal, Oracle 11g https://www.linkedin.com/in/sripathis
hilpa/
8
***************@*****.***
Contact Details
Philadelphia, USA
Shilpa Sripathi
Data Product/Analytics Manager
Professional Certifications
Certified Scrum Master
Microsoft Certifications:
Azure Enterprise Data Analyst Associate
Azure Data Scientist Associate
Power Platform Functional Consultant
FreedomforAI: Non Technical Prompting
techniques
Education
NO CODE AI AND MACHINE LEARNING
BUILDING DATA SCIENCE SOLUTIONS
Massachusetts Institute of Technology
(Professional Education), MA
MASTER OF SCIENCE: INFORMATION
TECHNOLOGY
State University of New York, Utica,
NY
Contact this candidate