IT Data Analytics Specialist - August 2024 - Present
Lead Analyst, Business Intelligence - September 2022-July 2024
Proven expertise in leveraging a diverse set of tools including Oracle SQL Developer, SQL Server Management Studio, Power BI, Paginated Reports, MS Dynamics 365, Snowflake, Power Automate, Sharepoint and Smartsheets to create comprehensive reports and dashboards tailored to meet business requirements and client needs.
Achievements:
• Implemented Power BI Dataflows and Power Automate resulting in a significant reduction of data loading time from 5 hours to 30 minutes to 1 hour, thereby boosting team productivity and efficiency.
• Spearheaded initiatives to automate report and dashboard generation processes using Power BI Dataflows and Service, leading to streamlined operations and improved data accuracy.
• Demonstrated proficiency in Power Query, DAX, ETL, SQL, and Data Visualization, effectively utilizing these skills to deliver insightful analyses and visually compelling reports.
• Actively contributed to the team's growth and development by imparting best practices in report and dashboard creation, fostering a culture of continuous learning and improvement.
• Successfully created and maintained dynamic reports and dashboards for clients, ensuring that they are updated automatically and providing them with real-time insights for informed decision-making.
• Possess strong knowledge of various data sources including Oracle, SQL Server, and SharePoint, enabling seamless integration and extraction of data for reporting purposes.
Overall, consistently delivering high-quality, data-driven solutions and playing a pivotal role in enhancing organizational efficiency and client satisfaction through innovative reporting strategies and automation techniques.
Skills Rating (1-10):
SQL (8/10): Proficient in SQL, particularly in T-SQL for SQL Server Management Studio, PL/SQL for Oracle SQL Developer, Snowflake SQL, and Impala SQL. Experienced in creating various objects like stored procedures, views, and staging tables, and optimizing long-running queries.
Data Engineering (8/10): Skilled in designing data models in Power BI from diverse sources such as SQL Server, Oracle Database, ODBC connectors, SharepointFolder, and Smartsheets. Capable of setting up Row Level security in Power BI.
API Integration (7/10): Experienced in automating report delivery via email using Power BI and Power Automate.
Data Analysis (10/10): Proficient in troubleshooting and root cause analysis to ensure accurate data interpretation and dashboard reliability.
Data Visualization (10/10): Able to create dashboards tailored to client requirements across various domains such as Finance, Order Management, Procurement, Operations, and Services.
Project Management (9/10): Skilled in project planning, requirement assessment, client communication, prioritization, time estimation, progress updates, client testing, and documentation.
Python (3/10): Although lacking direct experience, the individual expresses eagerness to learn Python quickly, citing its parallels with SQL functions and commitment to putting in extra effort to acquire this skill promptly.
