Brahmini Alekhya

Kaki Brahmini Alekhya Senior Reporting Analyst Hyderabad - - OBJECTIVE Experienced Reporting Analyst with over 28 months of experience in Business. Demonstrated analysis and problem-solving skills with keen attention to detail and ability to consistently produce high-quality deliverables. EDUCATION — B Tech -) Mechanical Engineering Vignan Institute of Info Technology. Inter -) Narayana Junior College. SSC -) Amar Concept School. S K I L L S: Dashboards of Tableau Data Analytics Power Queries Power Point Microsoft Excel Advanced Excel Secondary research Data Extract and Gathering EXPERIENCE Working as Senior Reporting analyst in MERILYTICS PRIVATE LIMITED from January 2019 to till date. Project 1: Utz Business Analytics (Jan 2019 to Feb 2019) Client: USA Role: Reporting Analyst Project Description: Analytical support for Finance team where we evaluate the COGS by SKU at a monthly level and generate SKU level profitability. We also generate various reports and analytics on ad-hoc basis such as Sales reports etc. Roles and Responsibilities:    Translated business requirements into technical requirements and developed project plan to achieve the result. Generated various reports and analytics on adhoc basis such as Sales reports etc. Working on major tools Advanced Excel/Data visualization and SQL. Project 2: ELCV - Business Analytics (Feb 2019 to Jun,2019) Client: USA Role: Reporting Analyst Project Description: It is one of the market leader’s skincare, makeup, fragrance, and hair care products. The company owns a diverse portfolio of brands, and we partner with their venture arm to support the ELCV finance team in reporting brand performance, build valuation models and set up BI dashboards for individual brands. Roles and Responsibilities: License and Certifications: Google Analytics ‘For Beginner by Google Analytics Academy. LinkedIn Skill Assessment Badge Excel. Volunteered as Campus Ambassador for Tryst- IIT Delhi. Volunteered as Campus Ambassador for IISc Bangalore Additional Skills: Team Oriented approach Problem Solving Team Leadership. Organisation and Prioritisation. Ownership.     Leveraging and forward planning from different sources producing periodical reports and Visualization. Data Cleansing using Pre- defined Queries /Process on daily basis. Worked on tools Excel, PPT, Power Query Functionally worked on deliverables at Product performance, Sales Performance and Periodic Reporting Using MS Excel Project 3: Transplace – BI (May 2019- Jul,2020) Client: North America Role: Senior Reporting Analyst Project Description: Transplace is the leading provider of transportation management services and logistics technology in North America. We work with their finance team to support reporting for the AR/AP teams, create executive dashboards for company level and business unit level leadership, and provide support for individual business units on specific database related requests. Roles and Responsibilities    Report generation and Maintenance of reports based on business requirements. Working with finance team to Support reporting for AR/AP teams to create executive dashboards for company level. Functional in Periodic reporting using Excel, Planning and Analyzing. Project 4: Vice Media - Business Analytic (Jul 2020-Dec,2020) Client: USA Role: Senior Reporting Analyst Project Description: Vice Media is an online media company based out of New York. Merilytics partnered with the company to support and Finance and Marketing teams on reporting and business analytics. The project also involves setting up APIs to extract the data required for the analysis from the NetSuite ERP system. Roles and Responsibilities    Working closely with Associates and stakeholders. Undertake operation research to identify and recommend optimal solutions to complex challenges applying predictive analysis and tools to forecast and employee business analytics to enhance the ability to quantify and qualify data. Implementing the basics of Power-Bi and SQL, Infographics and Advanced Excel which provides the Business Insights. Project 5: Persona – Business Analytics (Dec,2020- Till) Client: USA Role: Senior Reporting Analyst Project Description: Persona is a US based vitamin supplement provider which has been acquired by Nestle in August 2019. We support them on all their accounting and finance requirements creating financial packages and reports that are shared daily. The reports provide a snapshot of the daily customer acquisitions by channel as well as the accounting summary of the last week. Roles and Responsibilities    — Functional working in Google analytics, Excel, Power Pivot, Power Query, PPT. Assisting in Budget Modeling and Sales Performance Analysis. Preparing and structuring the data, developing the systematic dashboards, pie-charts, pivot tables and converting into the power queries developing the process and examining the usage data with associate’s senior analyst and other stakeholders. APPRAISAL AND ACHEIVEMENTS    Helped and Trained Freshers in Understanding Business Insights. Co-ordinated the counter parts in weekends and off hours as well. Delivering new and complex high-quality solution to Client resulting in a consistent rating of 9 over last 2 years in the competencies of Problem solving, Team-oriented approach, Ownership, Job-specific knowledge, Company values and policies.