Data Analyst

SHASHWAT JAIN

USA **.**.****@*****.*** +1-313-***-**** LinkedIn

PROFESSIONAL SUMMARY

Results-driven MBA professional with 7+ years of experience in business intelligence, data management, and analytics. Expertise in Gartner’s leading business intelligence platforms, data modeling, data warehousing, data governance, and data visualization. Proven ability to drive enterprise-wide analytics strategies, optimize data platforms, and implement data solutions that enhance business decision-making and operational efficiency. Highly skilled in data architecture, business intelligence strategy, and cross- functional collaboration with stakeholders across Medical, Finance, Commercial, R&D, Operations, and other enabling units. Certified Scrum Master, SAFe® with strong leadership, project management, and strategic problem-solving skills. Adept at leading teams, managing budgets, and executing complex business data initiatives aligned with organizational goals to deliver impactful, data-driven results. Passionate about fostering a culture of innovation, ensuring data quality, and optimizing business intelligence tools to drive sustainable growth and business transformation.

SKILLS

SQL Hive Snowflake ETL CI/CD SDLC Agile Scrum Kanban Waterfall Project Management JIRA Confluence Power BI MS Fabric Power Query Power BI service (SaaS) Power BI REST API GIT Integration Data Analysis Expressions, DAX M language Tableau Qlik Sense Tellius Alteryx Azure Data-Factory & Data lake Azure Synapse AWS Redshift Power Apps Power Automate ServiceNow Collibra Dataverse Salesforce Veeva SQL Server SSIS SSRS SSAS Azure IAM and AD Qualtrics R Language Python Stakeholder management Vendor Management Conflict Management Microsoft Excel or Google Sheets Microsoft PowerPoint or Google Slides MS Word MS Access Office 365 OneNote Smartsheet Microsoft Visio SharePoint Microsoft Project Statistical Methods & Concepts Predictive analytics Quantitative analysis Qualitative analysis ERD Ad-hoc reporting LaTeX documentation

WORK EXPERIENCE

AstraZeneca Pharmaceutical, Alexion (Rare Diseases Unit) New Haven, CT Senior Business Intelligence Analyst / Product Manager March 2022 – Present

• Enterprise Business Intelligence Strategy: Led company-wide Business Intelligence (BI) program, overseeing software platforms and environments, driving data-driven decision-making, and optimizing operational efficiency across departments. Partnered with business units to develop and execute BI roadmaps.

• Self-Service Analytics & Platform Management: Developed and deployed OKRs on enterprise-wide self-service analytics strategy using Power BI and Qlik Sense, enabling users to make data-driven decisions. Led platform architecture and data governance, ensuring compliance and data integrity. Managed the migration of 500+ Qlik Sense reports to Snowflake, improving refresh times by 30%, reducing load failures by 50%, and reducing maintenance costs.

• Governance & Compliance: Directed Power BI and Qlik Sense governance efforts, enhancing data quality and security across BI platforms. Integrated Collibra for improved data cataloging, governance, and compliance, ensuring consistent and accurate reporting across teams.

• Platform Optimization & Enhancements: Spearheaded Power BI platform optimizations and data integration, resulting in a 30% increase in user engagement and improved performance management. Reduced dashboard load times by 20%, improved reporting capabilities, and enhanced the user experience through strategic data integration and engineering.

• Cross-Functional Collaboration: Collaborated with cross-functional stakeholders in Medical, Finance, Commercial, R&D, Compliance, Global Operations – Supply chain and other enabling units to align BI strategies with organizational goals. Delivered actionable insights, reports, and dashboards, with end to end solutions that impacted decision-making and operational performance.

• Cloud-Based BI & Security: Led the implementation of cloud-based BI dashboards in Power BI with stringent HIPAA, GDPR, and GxP compliance to guarantee data privacy and security. Automated security measures through Azure IAM, Azure AD, Power BI Row Level Security (RLS) ensured sensitive data handling aligned with regulatory requirements.

• Center of Excellence Leadership: Fostered a Center of Excellence (COE) with over 1,500 users, promoting collaboration, knowledge sharing, and best practices for BI tools. Developed a Power BI best practices SharePoint community and Proof of Concept

(POC) initiatives to extend functionality across the organization.

• AI & Automation Implementation: Developed a GenAI chatbot solution embedded into Power BI, based on a customized LLM model, as an alternative to Copilot. Collaborated in implementation of a Generative AI-powered automated analysis commentary POC for Power BI reporting. Reduced manual analysis commentary processes by 40%, driving efficiency and empowering users with automated insights.

• People & Vendor Management: Managed a team of 14-15 analysts, engineers, and platform admins, managing vendor contracts and negotiations, optimizing offshore resources, and ensuring compliance with tracking through ServiceNow to NextGen ServiceNow on SLAs and Project deliveries for timely, cost-effective project delivery.

• Financial Oversight & Budget Management: Managed $2.5M+ OPEX and CAPEX budgets for BI operations, ensuring alignment with organizational financial goals. Achieved cost reduction targets, saving $350K annually through the migration to Power BI service cloud SaaS and optimized platform strategies.

• Project Management & Agile Delivery: Led end-to-end project management through SDLC phases using Agile methodologies, ensuring timely delivery and alignment with business requirements. Achieved a 20% efficiency gain through the migration of Qlik Sense reports to Power BI by optimizing data engineering and workflows, and the integration of NextGen ServiceNow for streamlined incident and change management processes, and overall service delivery.

• Workflow Automation and Reengineering: Saved 340+ labor hours through the automation of workflows, data migration, system integration via Power Automate and incident management and support process via ServiceNow. These improvements significantly reduced turnaround times and enhanced overall operational efficiency.

• Version Control & Collaboration: Streamlined version control and team collaboration using GitHub and Azure DevOps to manage data models, scripts, and CI/CD data pipelines. Optimized writeback functionality by leveraging A/B testing across SQL Server, Vizlib, Dataverse, Power Apps, and Power Automate, resulting in improved data tracking and more efficient BI project workflows.

• Data Migration & Platform Transition: Directed the successful migration from Qlik Sense, Tableau, and Tellius to Power BI, enhancing platform performance, reporting capabilities, and reducing maintenance costs. Managed the transition of data from Hive to Snowflake, optimizing data access and workflow efficiency.

• Strategic Reporting & Documentation: Delivered actionable insights and compelling presentations for leadership, influencing strategic decisions. Developed and maintained SOPs, data strategy documents, and best practices to drive process improvements and effective change management across the BI landscape.

• Data Governance & Product Development: Contributed to data cataloging using tools like Collibra, enhancing data discoverability and ensuring compliance. Actively assisted in the development of FAIR data products and data marts, which led to the establishment of self-service analytics and a 50% reduction in manual reporting. Wide Vision Technologies Indore, India

Senior Business Analyst September 2015 – July 2019 Business Analyst January 2015 – September 2015

• Stakeholder Collaboration & Liaison: Collaborated with cross-functional stakeholders and business partners to define and prioritize business requirements, ensuring alignment between technical teams and business goals for successful project delivery. Acted as liaison, translating complex requirements into actionable deliverables, enhancing communication and project timelines, resulting in 30% reduction in project delivery times and a 20% increase in stakeholder satisfaction.

• Reporting & Data Visualization: Developed custom reports and key performance indicators (KPI) dashboards using Power BI, SSRS, and Excel (Pivot Tables, DAX), providing actionable insights for customer analytics and drive business decisions and improve operational efficiency. Created executive-level dashboards to track key business metrics and support performance improvement.

• User Acceptance Testing: Led SIT/UAT efforts, executing advanced SQL queries to validate data integrity across data pipelines, identifying, and resolving issues, ensuring seamless project delivery. Worked closely with end-users to identify and address system issues, ensuring alignment with business objectives, contributing to a 98% defect-free product launch.

• Agile Methodology & Project Management: Managed end to end Agile/Scrum processes, including sprint planning, daily stand-ups, and backlog prioritization, resulting in faster project delivery and improved team productivity. Streamlined project intake and team workflows, driving improved efficiency and accountability.

• Data Quality & Operational Efficiency: Improved data quality and governance, boosting accuracy, supporting customer acquisition and retention strategies. Developed dashboards and reporting tools that optimized workflows and improved operational efficiency by 10%. Research Assistant (Provost Office) – Diversity, Equity, and Inclusion University of New Haven June 2021 – December 2021 Graduate Assistant University of New Haven January 2021 – May 2021

• Survey Methodology & Data Analysis: Employed Qualtrics surveys and quantitative methodologies to assess diversity, equity, and inclusion within the university.

• Data Visualization & Reporting: Utilized Tableau to create compelling data visualizations, synthesizing findings into reports for stakeholders including the Provost's Office, college deans, and MBA Roundtable. EDUCATION

Ph.D. Doctor of Business Administration, Business Intelligence and Data Analytics (STEM) (Expected Start Date) March 2025 Westcliff University Miami, FL

Master of Business Administration, Data Analytics (STEM) December 2021 University of New Haven (Dean’s Scholar) GPA – 3.81/4.00 West Haven, CT Bachelor of Commerce (B.COM), Taxation December 2015 Devi Ahilya University Indore, INDIA

CERTIFICATIONS/TRAININGS

• Qlik Sense Deploy and Administer, and Essential Training – QLIK

• Certified SAFe® 6 Scrum Master

• Generative AI – Google

• PharmStars' PharmaU(TM) – Certification of expertise in drug development, regulatory affairs, marketing strategies.

• IBM Data Science Professional Certificate

• Microsoft Fabric Certification DP-700 (in progress) Power BI – scheduled 29th May

• AWS Cloud Solution Architect (in progress) – scheduled 17th June

Contact this candidate