About Me
Experienced data analyst with nearly 3 years of expertise in SQL, Data Analysis, Data Visualization and knowledgeable in Statistical Analysis and Predictive Modeling to uncover patterns and trends in large data sets Data…
Experienced data analyst with nearly 3 years of expertise in SQL, Data Analysis, Data Visualization and knowledgeable in Statistical Analysis and Predictive Modeling to uncover patterns and trends in large data sets Data Analyst with robust knowledge and experience in Data Analysis, Data Cleaning, Data Visualization, and creating data reports Experienced with predictive modeling using analytics packages in languages like Python Expertise in generating analytical reports using Tableau, Power BI, and problem-solving in SQL debugging skills Extracts, identifies, analyses, and interprets trends or patterns in complex data sets using Data Definition Language or Data Manipulation Language commands for data gathering and analysis activities Developed and maintained data extraction and data preparation processes to support efficiency and effectiveness throughout the data analytics lifecycle and allow for advancement and growth Skilled in retrieving various data from different Data servers and validating, and manipulating data using Macro facility and Advanced Excel Experienced in gathering, cleaning, researching, and reporting on data; including a demonstrated ability to identify appropriate statistical review for large datasets, visualization of the data, and measurement goals Hands-on experience in using analytical techniques on large data sets for delivering ad hoc analysis and development of business intelligence reports Developed numerous categorical sales analyses along with visualizations for Customer data analytics Worked in an Agile environment and exhibited effective communication skills and a keen understanding of project timelines and dependencies Highly motivated with an entrepreneurial spirit and easily adapt the skills, good communicational skills able to work well with everyone
Experience
Data Analyst
Collaborated with cross-functional team members, and with input from
relevant working groups or committees, determine data requirements, and
administer several annual and ad hoc data
Developed full ETL applications to move data within a corporate data
management platform, with MS SQL Server tools
Created interactive Power BI Dashboards, KPIs, and Reports for Monthly
Metric analysis to replace traditional excel reporting and automate data
refresh using Power BI On-Prem Gateways
Using Power BI, prepared ad hoc scenario assessments to assess potential
sales tactics or brand activities and supplied as-needed BI reporting to the
team responsible for commercial planning and operations
Developed custom dashboards and reports using Tableau, Power BI, and
Excel to provide real-time insights into business performance, and
collaborated with stakeholders to ensure they met business requirements
Performed data extraction, transformation, and loading tasks using SQL
Server Programming, Python, models to identify trends and patterns in data
Utilized VLOOKUP and DAX formulas to perform data analysis and reporting
tasks and developed VBA scripts and macros to automate data processing
and reporting workflows
Accurately maintained, transferred, and processed home data in different
databases by developing VBA and SQL scripts
Data Analyst
Collaborated with cross-functional team members, and with input from relevant working groups or committees, determine data requirements, and administer several annual and ad hoc data
Developed full ETL applications to move data within a corporate data management platform, with MS SQL Server tools
Created interactive Power BI Dashboards, KPIs, and Reports for Monthly Metric analysis to replace traditional excel reporting and automate data refresh using Power BI On-Prem Gateways
Using Power BI, prepared ad hoc scenario assessments to assess potential sales tactics or brand activities and supplied as-needed BI reporting to the team responsible for commercial planning and operations
Developed custom dashboards and reports using Tableau, Power BI, and Excel to provide real-time insights into business performance, and collaborated with stakeholders to ensure they met business requirements
Performed data extraction, transformation, and loading tasks using SQL Server Programming, Python, models to identify trends and patterns in data
Utilized VLOOKUP and DAX formulas to perform data analysis and reporting tasks and developed VBA scripts and macros to automate data processing and reporting workflows
Accurately maintained, transferred, and processed home data in different databases by developing VBA and SQL scripts
Data Analyst
Collected, Cleansed, and provided modeling and analysis of data for structured and unstructured data used for various business initiatives
Created impactful dashboards and Excel and Power BI for data reporting, extracting, interpreting, and analyzing the data to identify key metrics and transform data into meaningful, actionable information
Ingested data from different sources using SQL and Analytics API to construct data views for Tableau
Provided guidance and assistance for data visualization and report generation, specifically with visual data modeling tools such as Power BI
Developed and maintained large databases with complex relationships between tables using SSAS and created data-driven reports and dashboards using SSRS
Published reports via the Power BI service, managing them through the distribution of apps and monitoring usage/data refreshes using Gateways/security access
Created data extraction, cleansing, and load programs to move data from source systems to Data warehouses