We provide IT Staff Augmentation Services!

Senior Analyst In Reporting Resume

SUMMARY:

  • Having 6+ years of experience as an Analyst in various industries with emphasis in IT, Financial, Ecommerce and Retail Management.
  • Expertise in creating or designing a dashboard’s, reports, reporting in tableau and analytic applications and tools to drive sales and revenue growth.
  • Interpreting data, analyzing results using statistical techniques and other strategies that optimize efficiency and quality
  • Extensive TABLEAU Experience in Enterprise Environment, in Tableau 10.x as a Developer and Analyst.
  • Proficient in data Reporting, Analysis through Pie Charts Bar Charts, Scatter Plots and other making use of actions, other local and global filters according to the end user requirement.
  • Very good experience on generating the data from various sources like Sales force, SQL server and some internal applications and collecting the data from stake holders.
  • Collaborating with organizational leaders to identify opportunities for process improvements, recommend system and preparing reports for executive leadership that effectively communicate trends, patterns, and predictions using relevant data.
  • Strong knowledge on SQL, Salesforce, Excel.
  • Extensive Experience in DATA ANALYSIS, DATA MANIPULATION, DATA EXTRACTION, REPORT CREATION, Importing & Exporting Data in different formats and from various source systems.
  • Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Bubbles, Histograms, Bullets, Heat maps and Highlight tables and Excellent with Actions and Quick Filters.
  • Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
  • Worked with Data Extracts to create Tableau dashboards and scheduled extract updates at regular intervals for Project Management team and Built complex calculations to manipulate data and published final dashboards on Tableau server.
  • Excellent knowledge and ability to create reports, dashboards and Trend analysis with tools such as EXCEL and TABLEAU.
  • Having good knowledge on Advanced Excel Formats & Formulas like VLOOKUP, HLOOKUP, SUMIF, IF, MID, NOW, COUNTIF, MATCH, INDEX, CLEAR, FILTERING the data, DATEDIF, sorting the data, Conditional Formatting & Pivot Tables and also having a knowledge on Excel statistical functions .
  • Proficient in Developing the KPI’s {Key Performance Indicators} to track performance for metrics.
  • Automated the reporting elements in multiple systems and prepared the data for analysis using Microsoft Excel.
  • Hands on extract insights, provide data analysis, synthesis & presentation support .
  • Good experience in working with the different data sources and good experience in analyzing the performance of the dashboard.
  • Very Strong experience in excel programming, generalizing the code and modules.
  • Created automated Excel applications based on macros and VBA with advanced data manipulation in Pivot Tables, Charts, Tables, Ranges and formulas using code in modules and classes.
  • Good hands on experience with all VBA functions, Modules, Forms and controls.
  • Expertise in creating the multiple worksheets through VBA and automating the consolidated workbooks.
  • Deliver reporting and insights via various methods including BI dashboards, data visualization.
  • Working with daily, weekly and monthly reports in tableau, excel and sending over to the senior management.
  • Extract, filter and aggregate data through logical queries and basic programming.
  • Worked on requirements analysis and estimation of development efforts for the project
  • Experienced in designing, developing and supporting complex dashboards for the application Traffic.
  • Extensive experience in Handling the ACT Reports, User access Reports, Inactive Reports, Entitlements Reports and Bulk User Upload Reports via Tableau visualizations.
  • Good working experience with Provisioning and de - provisioning the access based on user access request.
  • Hands on experience with IAM service request fulfillment request center and part of enterprise access management team and Provisioning as per the request raised by the user.
  • Working with the Access certification processes and leading practices by daily and quarterly wise.
  • Troubleshooting user access related issues and incidents to ensure end users are successfully able to use systems and perform job functions.
  • Integrating the applications into IAM and doing migrations as per the requirement or business.
  • Expertise all Ticketing tools like Identity access management (IAM), BMC remedy (PAC2000), WACS and Internal ticketing tools.
  • Continuously monitoring and supporting the production issues and resolving the issues in respective manner.
  • Self-motivated individual with strong communication skills, great attention to details and the ability to work under pressure.
  • Good analytical and communication skills and ability to work independently and also perform as part of a team.
  • Possess good organizational and interpersonal skills in a team-based environment.

TECHNICAL SKILLS:

Primary Skills: Tableau, Advanced Excel (Formula’s), SQL, Salesforce, Decision Manager, SQL server, ENG House Business intelligence, VBA, BMC remedy, LINQ pad, Oracle Retail Management system.

Access Management Tools: Identity access Management, symphony, ILM, OIM.

Ticketing Tools: IAM, WACS, BMC Remedy, ART, SPARSH (internal Tools of Confidential ).

Domains: Banking, Retail and E - commerce.

PROJECT EXPERIENCE:

Confidential

Senior Analyst in Reporting

Responsibilities:

  • Design and develop metrics, reports and analyses to drive key business decisions.
  • Interacting with Business users on daily basis to understand reporting requirements and transform them into technical specifications.
  • Extracting data from different sources connecting them and using the same to create dashboard.
  • Importing data from various transactional applications {ProClarity} and data bases {SQL server reporting services} .
  • Created complex reports for CVR, AVR for productivity for all Regions.
  • Business requirement gathering and translating them into clear and concise specifications and queries.
  • Created Dashboards that ensured data driven monitoring of KPI and processes tracked appropriately to provide guidance for process improvements.
  • Built many Tableau reports using Bar Charts, side-by-side bars, stacked bars, maps, tree map, pie charts, line charts, interactive reports using Tableau Desktop and also Performed different calculations like Quick table calculations, Date Calculations, Aggregate Calculations, String and Number Calculations .
  • Used different Mark types in views to provide better insights into large data sets.
  • Developed visualizations using sets, Parameters, Calculated Fields, Filtering, Parameter driven analysis, trends and drill downs along with user level security and also Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
  • Worked extensively with advanced actions, calculations, parameters, trendlines and table calculations .
  • Scheduling data refresh on Tableau Server for daily, weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
  • Gather, analyze, and document data requirements for projects of medium to high complexity and moderate to high risk, perform source system data quality analysis.
  • Analyzing business information to identify process improvements for increasing business efficiency and effectiveness.
  • Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
  • Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.
  • Support, manage, and maintain organizations data in databases.
  • Preparing transparent standard reports and analyse to support business needs.
  • Creating Dashboards in Excel and Tableau for all the Reports.
  • Participating in the calls and coordinating with the onshore for the business requirement.
  • Working with Project Management Reports and delivering the reports as per the timeline.
  • Designing Excel Templates for all the reports with proper format and formulas and implementing the required reports.
  • Extensive experience in developing data visualizations like Preparing Bar charts, Pie chart representation for CVR and AVR Reports, Free virtual training reports, Major unit installs reports.
  • Perform analysis and testing of reporting results from large data sets to be used for ad-hoc reporting
  • Interact with business users and understand their requirements.
  • Coordinating with team members and understanding status of all projects and provide back-up if necessary.
  • Develop individual reports and design the final dashboard.
  • Testing the reports for formatting and data correctness, and publishing the workbooks on the Tableau server for scheduled refreshes.
  • Creating a wireframe/ paper design / design document to finalize the number of dashboards or graphs, graph type & color code
  • Experience in working with high-volume & high-dimensional data from various sources
  • Identified the areas in existing application, which can be enhanced by providing alternate solutions
  • Discussing daily about every aspect of a requirement with immediate supervisor, and participated in discussions regarding its feasibility and limitations
  • Developed requirements adhering to client specifications and expectations
  • Maintained quality of the development with minimum defects

Environment: Tableau, Advanced Excel (Formula’s), SQL Server, Salesforce, ENG house (Data Warehouse tool), Decision Manager, Vision Tool.

Confidential

Reporting Analyst

Responsibilities:

  • Hands on extract insights, provide data analysis, synthesis & presentation support.
  • Gathering a requirement from the client and preparing a macro in VBA for all Excel repetitive tasks.
  • Automating the reports by using all VBA functions and excel formulas.
  • Design and implementation of required reports.
  • Developed a macro in VBA for Bulk user upload report.
  • Designed a Macro for inactivity project and it expands an automated email notification to the users based on their inactivity and creating the scripts based on requirement.
  • Understanding the business requirements and translate them into technical report requirements.
  • Designed a VBA code for Inactivity project, Application access Reports.
  • Understanding the business requirements and translate them into technical report requirements.
  • Extensive experience in developing data visualizations like Preparing Bar charts, Pie chart representation for Application Reports, User Inactive reports.
  • Perform analysis and testing of reporting results from large data sets to be used for ad-hoc reporting
  • Interact with business users and understand their requirements.
  • Coordinating with team members and understanding status of all projects and provide back-up if necessary.
  • Worked on preparing Dashboards for Production Users and Applications Traffic.
  • Develop individual reports and design the final dashboard.
  • Testing the reports for formatting and data correctness, and publishing the workbooks on the Tableau server for scheduled refreshes.
  • Connecting Tableau to database and creating designed dashboards.
  • Creating a wireframe/ paper design / design document to finalize the number of dashboards or graphs, graph type & color code
  • Experience in working with high-volume & high-dimensional data from various sources
  • Identified the areas in existing application, which can be enhanced by providing alternate solutions
  • Discussed every aspect of a requirement with immediate supervisor, and participated in discussions regarding its feasibility and limitations
  • Perform complex data analysis, design, support, and documentation.
  • Involved in User Access certifications, Reviews, User access provisions based on User requests.
  • Developed requirements adhering to client specifications and expectations
  • Maintained quality of the development with minimum defects
  • Mentored junior members of the team by solving queries and clarifying the requirement to them

Environment: Tableau, Advanced Excel (Formula’s), SQL, VBA, Access Management Tools, BMC remedy, LINQ pad.

Confidential

MIS-Executive

Responsibilities:

  • Analyzed the provided client requirement
  • Identified the areas in existing functionality, which can be re-developed as per the requirement
  • Having good knowledge in analyzing &monitoring the reports.
  • Good experienced with doing the Weekly reports& Monthly reports.
  • Developed MIS documentation to allow for smooth operations and easy system maintenance.
  • Having good experience in doing the Inventory status & bulk status reports in excel.
  • Hands on experience to do the P to D Mis - Alerts & Making the Load Allocation sheet.
  • Accessing and developing customized solutions for clients.
  • Handle to Follow-up the orders by department wise as well as breach wise.
  • Inward supply as per the plan by central planning team and plan supply by manpower and assets availability.
  • Coordinating with store operations and Merchandising teams regarding the distribution requirements.
  • Participated in Weekly reviews & meetings with concern departments.
  • Outward plan and coordinate with operations team for healthy operations.
  • Having Good Experience in Whole Warehouse operations & Store retail operations.
  • Planning to Process the Customer orders on the Basis of Priority (Breach wise).
  • Hands on Experience in Dispatch Planning & Shipping the Products to EKart.
  • Analyzing& Report generation on the quality parameters & improving on- going process.
  • Manpower & assets planning for the warehouse as per the projection planned by central planning team.
  • Good Experience in SAP Reporting (Flo).
  • Experience in giving Load Allocations to the Particular Departments (Inventory, Packing) Based on Customer Load on the Flip Kart Website.
  • Good Experience in Preparing Updating the Attendance Trackers.
  • Good Experience in preparing the Inventory reports.
  • Participated in the weekly project meetings and Coordinated with the team to meet tight deadlines.
  • Allocating the manpower to the particular Departments as much as needed.
  • Have good experience in Managing resource and work allocation
  • Experience in analyzing simple as well as complex requirements in detail.

Confidential

Junior Officer-Stock audit Reporting

Responsibilities:

  • Retail Stores Inventory Audit and Finalization of Shrinkage Reports in Excel.
  • Experience in Oracle Retail Management System.
  • Preparation of Excel Charts according as per the Shrinkage reports.
  • Store’s Inventory level Maintenance as per MBQ for all stores.
  • Every Month Scheduling for Various out Lets for Store audit (Stock Take) and Conducting / Attending as per Scheduled.
  • Developed and implemented inventory control procedures.
  • Shrinkage Reports Preparation for stock take completed stores.
  • Ensuring in transit transactions updating at DC’s &Stores.
  • Ensuring previous Day End completed or not.
  • Ensuring all DSP Bills are Updated in system.
  • Scheduled stores Date wise Enrolling in Oracle- RMS and Finalized Physical stock posting in RMS as per schedule day to day.
  • 100% Verification of high shrinkage SKUs which is appears in month on month.
  • Physical stock updating on same day of stock takes.
  • Petty cash verification with voucher And EOD Sale bank reconciliation.
  • Surprise Cash Verification at POS and PIHV Verification for High shrinkage Stores.
  • Good analytical and communication skills and ability to work independently and also perform as part of a team.

Hire Now