As a Business Intelligence and Data Warehouse Analyst , I have 10+ years of experience in building and support BI models in educational, manufacturing, mining, pharmaceuticals, and agriculture industry. I interface with the client to capture their requirements and develop BI application. At MathWorks, in my role as a Datawarehouse Analyst, my duties include the development and deployment of data warehouse solutions and reporting tools. I am tasked with collecting business needs, executing data extraction, modeling, and validation, as well as designing, creating, and implementing reports and dashboards using technologies such as Snowflake, SQL, SAP Business Objects, Power BI, Tableau, and Crystal Reports.I have created various Operational reports using Power BI, Tableau which has furnished higher management with instantaneous tracking of various key performance indicators, thereby facilitating enhanced decision-making . I am extensively involved in the end to end support of On prem to Cloud migration of datawarehouse which has improved the reporting performance by 80%. AT ITC Infotech ,the projects I have handled had an average cost estimate of USD 1.2 million, the biggest being the Merck Project which was 2 million USD. Of this I was directly responsible for the BI platform development costing 0.5 million USD.I was extensively involved in designing relational databases, determining KPIs, ETL process of data( Data Modeling, Data Extraction, Data Loading),implementing reports for French based electrical company Schneider Electrics which increased revenue by 20%. Developed business reports for US based pharmaceutical company Bristol Myers using SAP ,SQL which improved performance by taking 50% lesser execution time than existing customer reports and managed off-shore team with regards to developments and implementations.Developed report and dashboards using tools like Tableau ,Microsoft Power BI,Crystal Reports, SAP Business objects which facilitate effective business analysis and provided data driven decision making.Technical Skills:Snowflake, Microsoft Power BI, Tableau,Microsoft Power Automate,SAP Business Warehouse , SAP Business Intelligence,Crystal Reports,Oracel SQL,Testing tools HP Quality center and Application Lifecycle Management,Microsoft Word,PowerPoint,Excel, Visio,JIRA,Confluence ,Supply Chain Management,Project Management,Agile and Waterfall(Software Development Life Cycle).Statistical Skills: Data warehousing, Business Intelligence, Project Management, Requirement Gathering, Query Optimization, Data Modeling
Listed skills include Requirements Analysis, Sap Erp, Business Intelligence, Business Analysis, and 21 others.