| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLE Street Address
EXPERIENCEGEP Navi Mumbai, IndiaData Analyst June 2019 August 2022Spearheaded the design and implementation of a dynamic monthly client report in Power BI, displaying key performance metrics and insightful visualizations to drive decision-making.Applied advanced SQL and Power BI skills in building intricate queries, which allow seamless data filtration, transformation, and visualization for both internal and external stakeholders.Pioneered the creation of comprehensive dashboards and reports offering valuable insight into critical metrics for clients, prospects, and company performance as a whole.Executed seamless data updates and imports into Power BI from various sources, meticulously managing the data model to ensure optimal data relationships and facilitating data analysis.Employed Python skills in conducting rigorous data cleaning, preprocessing, and transformation, ensuring data integrity and suitability for analysis across various platforms.Collaborated closely with senior data analysts to cleanse and prepare vast transactional data sets in SQL, undertaking thorough data quality assessments.Facilitated seamless data migration processes between staging tables in SQL and multiple data sources, including Excel, CSV files, and other SQL servers, thereby maintaining the integrity and accuracy of the data.Demonstrated adeptness in utilizing diverse analytical tools, such as Excel, Power BI, Python, and SQL, to conduct exhaustive data analysis and transform complex datasets into actionable insights.Conducted in-depth ad hoc data analysis using SQL and Power BI, which shed light on key data collection points and forecasting methodologies for product teams.Implemented internal process optimizations, leading to a remarkable 25% increase in operational efficiency and achieving a 100% SLA with zero errors.Developed robust ETL pipelines to collect, manage, and analyze datasets, contributing to a 25% boost in productivity and streamlining data analysis processes.Utilized advanced SQL techniques for the optimization of database performance, resulting in the improvement of query execution time and the enhancement of the overall system efficiency.Conducted thorough data audits and validations using SQL scripts to guarantee the accuracy and compliance of data with regulatory standards.Cross-functionally collaborated with stakeholders to gather requirements and translate business needs into actionable data analysis solutions.Participated effectively in constant learning and professional activities to stay up with emerging trends and technologies in data analysis.Contributed to the development of best practices and standard operating procedures for data analysis processes, ensuring consistency and efficiency across projects.EDUCATIONClark University, Worcester, MA, USA May 2024MS in ITMGMs College of Engineering and Technology, Navi Mumbai, IndiaBS in Computer Engineering May 2019SKILLS, TOOLS & TECHNOLOGIESSQLPower BIProficient in Microsoft ExcelPython ProgrammingStatistical Analysis and ModellingETLProject ManagementMicrosoft Office SuiteAgileWaterfall SDLCStrong problem-solving skillsExcellent communication skillsEffective presentation skillsCERTIFICATIONSSQL (Intermediate) March 2024HackerRankVisualise Data with Power BI October 2023Growth SchoolStudy on IOT Sept 2018IJRESM |
