Pooja Shah Email and Phone Number

• Experienced working with Stakeholders and Department Managers to understand pain point, gather requirements and suggest solutions• Created business and information flow processes to set up data pipelines for reporting• Provided internal business analysis to improve Company visibility and profitability• Identified new and ongoing customer-reporting requirements• Worked with Data Architects to design reporting data models and improve performance• Performed data collection, cleansing, transformation and testing for day-to-day analysis and reporting development• Created/modified Stored Procedures to improve data processing and data quality• Analyzed trends in customer data and identify opportunities to maximize profit, minimize costs, recommend value-added business solutions and determine potential areas for improvement and growth• Manipulated data and compile the results to generate performance and management reports• Worked with SQL Server, SSAS, Share Points and other sources to get data for reporting• Designed and developed reports using reporting development tools i.e., SSRS and Power BI• Worked with complex DAX and formulas to create custom columns and measures to enrich datasets as required• Worked with Admin team to resolve performance issue that comes with reporting• Managed user access and restrictions for report• Trained users to use dashboard and created user manuals for references

• Implemented Data Models to satisfy various functional requirements and created reports for CRM to satisfy business needs• Created Process Chains to load data on daily/weekly/monthly bases• Created Process Chains for all jobs that are directly scheduled through SQL Server, Excel, SharePoint, Flat Files• Worked with users to define reporting needs and helped design/develop flexible solutions using best data modeling practices• Created data models for end user to develop their own custom reports• Worked with support team to resolve the tickets raised by business users for issues regarding BW reports and data validation with source systems • Developed/supported Tableau data visualizations and dashboards