Summary
Overview
Work History
Education
Skills
Certification
Timeline

Chandra Sekhar

Markham,ON

Summary

  • A highly adaptable Data/BI Analyst with nearly 8 years of experience, specialize in collecting, organizing, interpreting, and presenting various types of statistical data with ease.
  • Strong SQL skills, including the ability to write complex queries, manipulate huge datasets, and extract insights.
  • Skilled in data visualization, statistical analysis, and cloud computing platforms, with a proven ability to extract insights from large, complex data sets.
  • Expert in developing, maintaining, and mining a repository of internal and external data to create reports that summarize key performance metrics and address strategic questions.
  • Skilled in using advanced Excel, Pivot tables, VBA, and Python to automate repetitive data analysis processes, resulting in improved efficiency and accuracy.
  • Expertise in Tableau, Microsoft Power BI, Power BI Pro, Power BI Mobile, and creating and developing Dashboards into rich look.
  • Developed a thorough understanding and maturity in all phases of business processes, including gathering requirements and coordinating ongoing iterative development within the Software Development Life Cycle (SDLC).
  • Experienced in Exploratory Data Analysis (EDA), with a strong understanding of data cleaning techniques (e.g., handling missing values, duplicates, outliers, and invalid data), data transformation, and data visualization.
  • Skilled in utilizing data analysis tools including R, Python, and SQL to extract valuable insights and develop impactful dashboards.
  • Expertise in machine learning techniques such as classification and clustering, able to utilize these techniques to effectively analyze and interpret data.
  • Proficient in performing ETL (Extraction, Transformation, and Loading) from diverse data sources such as Excel, Flat file, .CSV file, Access DB, and DB2. .
  • Knowledge in utilizing Azure Data Lake, Azure Data Factory, SQL Data Warehouse, Azure Blob, and Azure Storage Explorer.
  • Experienced in working in Agile Scrum, Waterfall and SDLC methodology environments.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Sr. Data Analyst

ServiceNow
Hyderabad, India
10.2021 - 03.2023
  • As the first member of the SRE Org. Analytics team, played a crucial role in its growth and development, successfully streamlining the organization's reporting and analytics processes and improving efficiency and accuracy in data management.
  • Gathered requirements for product vision and project scope by working with the project manager, product manager, and/or project sponsor.
  • Launched the analytics initiative for the SRE organization from scratch, leveraging data analysis and visualization skills to develop and implement a solution that delivered valuable insights for the team and stakeholders.
  • Designed, developed, and maintained self-service dashboards and reports using Power-BI to support analysis and continual improvement of operational alerts, automations, and processes.
  • Worked with massive data repositories sets to prepare regular and ad-hoc analysis of ServiceNow data, including alerts, tasks, and automation trends, and presented findings and recommendations to the leadership team.
  • Provided data-based suggestions for enhancing alert reliability, automating processes, and expanding automation coverage and capabilities.
  • Championed the adoption of data analytics to serve as the foundation and measurement of current and future processes, automation, and alerting, driving the organization's data-driven decision-making process.
  • Presented insights and proposals to senior leadership and cross-functional teams following Agile development practices.
  • Significantly contributed to the organization's overall success through efforts in data-driven decision-making processes.

Sr. Analyst - BI

Ivy CompTech (Entain)
Hyderabad, India
04.2021 - 10.2021
  • Developed Tableau dashboards to provide real-time insights into player betting statistics, optimizing team strategies.
  • Automated repeated tasks and queries, resulting in a 50% reduction in data gathering time and increased efficiency, consistency, and accuracy.
  • Created interactive dashboards using Level of Detail (LoD) calculations, data blending, table calculations, calculated parameters, and action filters to visualize financial trends.
  • Collaborated with stakeholders to design and develop data models for various products, addressing their data needs.
  • Developed Parameterized, Cascaded, linked, Drill-through, and Drill-down reports.

Data Scientist

Quantium Analytics
Hyderabad, India
07.2019 - 04.2021
  • Gathered requirements from clients to prepare analytical reports and provided analysis to support data-driven decisions.
  • Assisted FMCG/Retail clients in making data-driven decisions by utilizing various analytical methods, such as Source of Volume (SOV) Analysis, Basket Affinity, Customer Affinity, Customer Journey, Pricing Ladder Analysis, New Product Development (NPD) Analysis, and Benchmarking.
  • Designed and developed an Excel tool for a multinational beverage corporation client to generate over 1000 PDF reports at different levels, displaying key performance indicators and details on lost sales due to product unavailability on shelves or out-of-stock situations.
  • Conducted large-scale experiments to identify hidden relationships between variables in large datasets.
  • Visualized data to enable businesses to make decisions quickly.
  • Coordinated research and analysis activities using both structured and unstructured data and utilized programming to clean and organize data.
  • Prepared analytical reports that assisted clients in product promotions and strategy planning, ultimately leading to increased sales.
  • Maximized efficiencies by developing automated solutions using Excel, Python, and Snowflake for ongoing reporting.
  • Created ad hoc reports and analyses to meet specific client needs.
  • Conducted a thorough analysis of promotional activities to determine their effect on sales and identified optimal promotional strategies based on data.
  • Performed complex data transformations, analyzed large datasets, and optimized query performance by utilizing Scala and Spark SQL.
  • Identified data anomalies and worked with business units to perform root cause analysis and resolve issues.
  • Created graphs and charts detailing data analysis results.
  • Designed surveys, opinion polls and assessment tools to collect data.

Business Analyst

LatentView Analytics
Bengaluru, India
12.2017 - 06.2019
  • Designed and implemented data pipelines to efficiently move and transform data from source systems to target systems.
  • Created pipelines and automated the whole process for invoice delivery management and to calculate the success rate for various invoice delivery methods for an American multinational technology company.
  • Gathered and documented functional requirements for enhancements of ongoing financial reporting.
  • Primarily involved in data migration by changing the source and validating the data.
  • Provided end-to-end campaign support from designing to reporting for various marketing strategies to achieve significant lift in retaining customers and identifying potential causes for localized fluctuations in customer engagement.
  • Built a scalable reporting infrastructure from a Google Sheet-based reporting environment that is fully automated and can be created in a very short turnaround time (from 3 weeks to 3-4 days) for each new campaign.
  • Helped a Transportation Network client understand customer behavior by refining the existing layman segmentation to rule-based segmentation and then micro-segmentation of mature customers.
  • Collaborated with stakeholders to define features, integrations and partnerships.
  • Recommended improvements to existing or proposed systems to enhance solution functionality.
  • Provided technical support for existing reports, dashboards or other tools.
  • Created and designed business intelligence databases, spreadsheets or outputs.

Programmer Analyst

Cognizant Technology Solutions
Hyderabad, India
06.2015 - 11.2017
  • Part of the Asset Management team, worked in the Trade Capture team where built reports using complex SQL and SAP Crystal Reports to audit trades across different regions.
  • Created and presented executive dashboards and scorecards to show the trends in the data using Excel.
  • Additionally, analyzed the ticketing data for resource optimization and to track the actual effort.
  • Wrote and executed SQL queries to provide custom reports to client partners based on requirements.
  • Performed requirement gathering for change requests.
  • Created and modified tables, stored procedures, views, indexes, user-defined functions, and triggers as required.
  • Experienced in working in Agile Scrum, Waterfall, and SDLC methodology environments.
  • Used Excel pivot tables, charts and reports to break down and analyze information.

Teaching Assistant

SRM University
Chennai, India
07.2014 - 04.2015
  • Assisted teachers with lesson preparation and curriculum implementation.
  • Instructed and monitored students in use and care of equipment and materials.
  • Grade examinations, term papers and laboratory reports.
  • Compile research results and assist professors in the analysis of results and the preparation of journal articles or papers.
  • Graded assignments and tests and documented results into filing systems.

Education

Master of Technology - Embedded System Technologies

SRM University, Chennai, India
05.2015

Bachelor of Technology - Electronics and Communications

Jawaharlal Nehru Technological University
04.2012

Certificate in Engineering Excellence - Data Science

International School of Engineering, Hyderabad, India
06.2017

Skills

  • Languages : SQL, VBA, Python, R, Scala, C, Spark SQL, DAX, M query
  • Databases : MySQL, Teradata, Snowflake, SAP Hana, Big Data, Google Big Query
  • Tools : Excel, Power-Bi, Tableau, Visio, Lucid Charts, Power Query
  • Platforms : Jira, ServiceNow, SharePoint, GCP, Confluence

Certification

  • Get Started with Python, Grow with Google - 2023
  • Certification in SQL, Stanford Online - 2016

Timeline

Sr. Data Analyst - ServiceNow
10.2021 - 03.2023
Sr. Analyst - BI - Ivy CompTech (Entain)
04.2021 - 10.2021
Data Scientist - Quantium Analytics
07.2019 - 04.2021
Business Analyst - LatentView Analytics
12.2017 - 06.2019
Programmer Analyst - Cognizant Technology Solutions
06.2015 - 11.2017
Teaching Assistant - SRM University
07.2014 - 04.2015
SRM University - Master of Technology, Embedded System Technologies
Jawaharlal Nehru Technological University - Bachelor of Technology, Electronics and Communications
International School of Engineering - Certificate in Engineering Excellence, Data Science

Similar Profiles

CREATE PROFILE
Chandra Sekhar