Shaila Khan
Data Analyst @Tyler Hill Consulting
Signup · Get unlimited contacts
WORK HISTORY
Data Analyst @Tyler Hill Consulting
Nagpur, IN
Collected, validated, and maintained business data from multiple sources (SQL Server, Excel, SharePoint, Smartsheet) to ensure accuracy and completeness of MIS reports.Designed and delivered daily, weekly, and monthly MIS dashboards in Power BI and Excel to track KPIs, operational performance, and financial metrics.Automated recurring reports using ETL workflows (Alteryx, Databricks, Azure Data Factory) to reduce manual processing time and improve efficiency.Performed trend analysis and forecasting to support management decision-making and strategic planning.Collaborated with cross-functional teams to translate business requirements into actionable reporting solutions.Developed ad-hoc analysis and custom data extracts using SQL queries and Advanced Excel (PivotTables, Macros, Formulas).Implemented data governance checks to ensure consistent, reliable, and secure reporting across business units.Presented insights to senior management, highlighting key business drivers, risks, and opportunities.Coordinated with project managers using tools like Jira, Trello, and Smartsheet to track project deliverables and timelines.Contributed to process improvements by identifying gaps in reporting workflows and recommending automation solutions.
EDUCATION
Nagpur University
Bachelor of Engineering - BE, Computer and Information Sciences
Tulsiramji gaidwad patil institute of Engneering and Technology, Mohgaon Nagpur
Master of Business Administration - MBA, Buisness Analytics
ABOUT SHAILA KHAN
Results-driven Business Intelligence & Data Analyst with 5+ years of experience in development, system analysis, data visualization, and project coordination. I specialize in leveraging tools like Power BI, SQL, Snowflake, Databricks, Alteryx, Advanced Excel, and Azure to transform raw data into actionable business insights.My work spans diverse industries including solar energy, skincare & beauty, finance, and retail/e-commerce, where I’ve created impactful dashboards, optimized reporting workflows, and improved data quality to support key business decisions.I excel at translating business requirements into technical specifications, leading end-to-end dashboard development, and working in Agile/Scrum environments with cross-functional teams using tools like Jira, Trello, and Smartsheet. Technical Highlights:Built dynamic Power BI dashboards using DAX and Power Query to improve visibility and decision-makingDeveloped automated ETL workflows with Azure Data Factory, Databricks, and Alteryx to streamline processing and reduce manual effortManaged PPA (Power Purchase Agreement) analysis and supported e-commerce performance tracking across online marketplacesUtilized Snowflake for cloud-based data warehousing and scalable reporting solutionsDesigned SharePoint intranet portals and data collaboration systems to enhance communicationSupported data governance initiatives, ensuring clean, consistent, and reliable datasetsApplied Python and R for statistical analysis, forecasting, and advanced reporting Key Skills: Power BI, Tableau, SQL Server, PostgreSQL ETL & Data Integration | Azure Data Factory, Databricks, Alteryx Cloud Data Warehousing | Snowflake Advanced Excel (PivotTables, Macros, Formulas) DAX & Power Query | Data Modeling | KPI Reporting Python, R (Statistical Analysis & Forecasting) SharePoint (Admin & Intranet Solutions) Smartsheet, Jira, Trello | Agile/Scrum Methodologies Business Requirement Gathering | Project Coordination E-commerce Analytics | Solar Data Reporting Data Governance & Quality AssuranceI’m passionate about helping businesses unlock the power of their data—delivering insights that increase efficiency, boost performance, and drive strategic outcomes.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.