Sr. Data Analyst
Exo edge India LLP
Total years of experience :8 years, 0 Months
•Collaborate closely with the manager, senior manager, or associate director to oversee and manage the Cyber Incident Data (Legal Department) database for cohort employees.
• Utilize advanced statistical techniques to interpret data, analyze results, and generate comprehensive ongoing reports, ensuring data accuracy and attention to detail.
• Gather, organize, analyze, and disseminate substantial volumes of information, focusing on identifying patterns and trends within data sets.
•Develop daily attendance reports, production reports (daily, weekly, and monthly), quality reports, and various other reports to provide key insights.
• Generate comprehensive reports and communicate findings to relevant stakeholders within the business.
•Spearhead the design and implementation of the OneView Dashboard for employees, overseeing the management of MIS, Ad hoc reports, and Historical Data.
•Provide crucial support in the execution of various projects alongside senior members, ensuring seamless implementation.
•Access and transform extensive datasets by employing filtering, grouping, aggregation, and statistical calculation methods.
•Demonstrate proficiency in advanced Tableau features, encompassing calculated fields, parameters, table calculations, joins, data blending, and dashboard actions.
•Normalize large datasets (using power query) from multiple projects, consistently delivering projects within prescribed timeframes.
•Expertly handle MDE (Mass Data) files and unstructured data, showcasing adaptability in dealing with diverse data sources and structures.
•Aligned with the Senior Specialist Team/Team Leader/Consultant/Principal/Partner to meticulously maintain the CDC & SAM (Global) database for consulting cohort employees.
•Analyzed CDC (Career Development Committee) reports, and efficiently managed MIS, Ad hoc reports, and Historical Data.
•Prepared a diverse range of reports on a daily, weekly, bi-monthly, monthly, and quarterly basis. Created Tableau reports offering clear visualizations of industry-specific KPIs.
•Developed tools for automating Outlook email communication, critical Excel reports, and PowerPoint presentations using VBA.
•Provided crucial support in implementing various projects alongside Consultants and Senior members. Designed and automated reports and data visualizations for enhanced efficiency
•Produced PowerPoint presentations using VBA for Business Analytics & Insights catering to both Domestic and International Markets
•Designed and developed dashboards using Tableau and Excel, incorporating filters, parameters, and action filters. Created standard monthly reports using Tableau and thematic heat maps using MapInfo.
•Established a library of presentation templates categorized by topic for future use. Generated context filters and data source filters while handling large volumes of data.
•Built dashboards featuring measures with forecast, trendline, and reference lines. Accessed and transformed massive datasets through advanced filtering, grouping, aggregation, and statistical calculation
•Conducted consultations with clients and internal stakeholders to gather requirements and plan milestones throughout the research, development, and implementation phases of projects
•Demonstrated a strong understanding of advanced Tableau features, including calculated fields, parameters, table calculations, joins, data blending, and dashboard actions
•Generated and maintained a comprehensive daily delinquency dashboard report, as well as monthly reports, ensuring accurate and timely dissemination of critical information.
•Conducted thorough analysis of daily reports and proficiently managed Management Information Systems (MIS), demonstrating a keen eye for detail.
•Utilized Microsoft SQL Server and various DataMart platforms to extract data, transforming raw information into standardized business reports on a daily, weekly, and monthly basis. Additionally, adept at handling ad hoc data requests efficiently.
• Executed a pivotal role in routine operational reporting, budgeting, and financial forecasting, utilizing SQL to code and fetch data for a variety of reports, including but not limited to RLF and NRL reports, Diamond Residential reports, Bank of California reports, Wells Fargo bank reports, Citi Group reports, Invoicing Revised reports, CBB, CAM, Daily Agent reports, CNN mortgage, Final Expenses, and more.
•Implemented process enhancements by leveraging SQL, VBA, and Advanced Excel, showcasing a commitment to continuous improvement.
•Demonstrated proficiency in maintaining quality checks and developing dashboards using Excel sheets, Tableau, and Graph charts to enhance data visualization.
•Addressed ad-hoc information requests from both internal and external sources, showcasing flexibility and responsiveness.
• Conducted in-depth analysis of reports generated by the Business Intelligence (BI) team, ensuring the quality standards of SSIS/SSRS Packages were consistently met.
•Ensured compliance with Service Level Agreements (SLAs) by meticulously managing Turnaround Time (TAT) for various processes.
•Regularly documented and updated process flows, contributing to a transparent and efficient workflow. Demonstrated flexibility in working hours, adapting to the dynamic requirements of the role and team.
•Scheduled and participated in calls with the onshore (US) team as needed, facilitating effective communication and collaboration across geographies.
•Conducted competitive analysis using COMPET, an in-house mapping software, to assess market positioning and identify strategic opportunities.
•Ensured real-time access to crucial information by uploading SKU reports and Sales Reports into the Centralized SQL Server daily.
•Produced a variety of ad hoc reports, including Summarized Sales Reports and Top Sellers Reports, providing valuable insights for informed decision-making.
•Conducted extensive data analysis by comparing Lamoda's (a Russian company) data with that of Wildberries, contributing to a comprehensive understanding of market trends and competitor performance.
•Generated detailed Coupon Discount Reports and developed reporting tools tailored to assist business executives in their decision-making processes.
•Applied advanced analytical techniques to mine business data, uncovering patterns and correlations that informed strategic initiatives and business development.
•Designed and implemented data reports and reporting tools, enhancing the efficiency of decision-making processes for business executives.
•Conducted statistical analyses of business data, extracting meaningful insights to guide business strategies and optimize performance.
•Championed the creation and implementation of reporting tools, fostering a data-driven culture within the organization.
•Contributed to the development of a dynamic decision-making environment by providing actionable insights derived from in-depth data analysis.
•Collaborated cross-functionally to integrate statistical findings into business strategies, ensuring alignment with organizational goals.
•Continuously identified opportunities for process improvement and optimization through comprehensive data analysis.
•Regularly updated and improved reporting tools to meet evolving business needs, ensuring relevance and effectiveness.
•Established and maintained data quality standards to ensure accuracy and reliability in reporting. Applied a proactive approach to identifying emerging trends and market shifts through ongoing data analysis.
•Participated in knowledge-sharing sessions to disseminate insights and best practices related to data analysis and reporting
Generate and distribute management reports in accurate and timely manner.
Develops MIS documentation to allow for smooth operations and easy system
Provide recommendations to update current MIS to improve reporting efficiency and consistency
Perform data analysis for generating reports on periodic basis.
Provide strong reporting and analytical information support to management team
Generate both periodic and ad hoc reports as needed.
Analyze business information to identify process improvements for increasing business efficiency and effectiveness.
Bachelor In Commerce (H)