Seasoned Anaplan Model Builder with 5 Years of well-versed Experience in data mining, developing databases and generating reports. Excellent communication, project management and problem-solving abilities. Proficient Hands on experience with Anaplan, SQL Server, Power BI, T-SQL and Tableau within large and complex environments.
· Extraction Transformation and Loading (ETL)
· SQL Server Reporting Services (SSRS)
· Teamwork / Collaboration
· Customer support, Requirement
· Data Analysis, Scheduling
· Data visualization
· Power Bi
· Probability and statistics
· SQL Server Integration (SSIS)
Description: Vanguard is implemented this project with in the enterprise finance to help leverage the Value based budgeting methodology to be consolidated in one connected planning across the organization using the tech stack of Anaplan, Power Bi and Tableau.
Designed and Implemented ZBB Models for Enterprise FP&A Teams in Anaplan based on the Principles of Value Based Budgeting (VBB).
· Designed and implemented Lists, modules, line items, hierarchy & Versions for FP&A models at Vanguard in Anaplan
· Designed a Data HUB Model to handle cost center hierarchy, General Ledger Accounts and other core dimensions and thus reduced redundancy.
· Trained 140 senior to mid-level Financial Planning Analysts, how to use and better utilize Anaplan platform.
· Developed IT consulting and Non-IT Consulting Spend Capture Templates and Dashboards in Anaplan to which resulted in efficient cost savings of over 12%
· Restricted data and access for particular users using Selective Access and Dynamic Cell Access
· Constructed dashboards for measures with forecast, trend line and reference lines in Anaplan for different use cases of VBB.
· Built models in Anaplan which helped financial service teams to track the headcount in budget planning.
· Created Export Definitions using Actions in Anaplan which assisted teams to capture budget from Anaplan and load into Hyperion Planning.
· Imported Actuals into individual GL Accounts to calculate variance between forecast and actual versions thus helping planners to stay in control of budget.
· Managed lists in Anaplan with use of selective Access to assist various users across the organization and protected data privacy among different levels of users.
· Initiated steps in reducing the Anaplan model size (reducing Sparsity) and reduced workspace load by implementing PLANS and DISCO Best Practices.
· Provisioned ALM Lifecycle management process in Anaplan by establishing Dev and Prod Environments for All models.
· Collaborated with Single sign on teams to integrate OKTA into Anaplan and delivered secured end user access.
· Created training videos for knowledge sharing and helped people across Vanguard to understand Anaplan better.
· Actively participated and engaged with Anaplan vendors to resolve issues with the platform and provided feedback to improve the performance.
· Implemented line item subsets concepts to handle forex rates for currency conversion of budgets at market rate in different currencies.
· Developed Tableau visualizations, dashboards and workbooks using anaplan-tableau connect and helped users to report better to end clients in tableau.
· Built dashboards to study the current headcount, employee turnover data, grade levels in departments and talent attrition using tableau
· Built dashboard with pareto analysis in tableau for headcount analysis based on different KPI's
· Created HR story boards in tableau to aggregate current employee data to extract meaningful insights
· Created Dashboards in tableau to capture metrics for performance management in employees and highlighted filters based on top 12 KPI's.
· Connected concur data to tableau to bring spend capture of travel data into tableau and built dashboards for air transactions, car transactions and hotel transactions.
· Built dashboards for travel team to study the pattern of bookings within the organization in adherence to travel guidelines by the company.
· Travel team successfully reduced travel budget by 15% through identifying measurable actions using analysis derived from travel dashboards in tableau.
· Provided continued maintenance and development of bug fixes for the existing and Anaplan Dashboards and Tableau Workbooks.
· Delivered user support to clients to train, educate and answer questions
Description: Comcast has implemented this project within its small and medium business sector to plan and analyse the financial forecast planning and sales planning of its commercial and retail business using business intelligence tools such as Anaplan , Power Bi and Tableau
Description : Btree solution implemented this consulting project for end clients to build their elasticsearch cluster to monitor and build machine learning anomaly detection tool for clients logging data using Elasticsearch, Logstash and Kibana.
Description : VGS publishers implemented this project to capture the behaviour of end customers buying patterns and analyzing sales data with in its distribution sectors using Tableau Reporting.
· Worked with business analysts to create and modify Data Life Cycle for Data Acquisition from various Sources
· Installed and configured MySQL on Linux and Windows environments
· Translated business needs into data analysis, business intelligence data sources and reporting solutions for various clients
· Developed Stunning Visualizations for Dashboards using the HR Data
· Blended data from multiple databases into one report by selecting primary keys from each database for data validation
· Prepared Dashboards using calculations, parameters in Tableau and created calculated fields, groups, sets and hierarchies etc.
· Cleaning the Data for Data Modelling Using Filters Provided by the Business Manager
· Responsible for creating basic reporting which provides insights about the sales of the current fiscal year
· Create a Trend Report to identify successful products in the company and forecast their demand for future production
· Designed and created report templates, by using the graphs, charts, and more based on the business requirement
· Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data
· Connecting to multiple data sources, worked on Extracts and used data Blending, joins to create different interactive views and dashboards
· Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart
· Provided customer support to Tableau users and Wrote Custom SQL to support business requirements
· Expert level capability in Tableau calculations and applied complex, compound calculations to large, complex data sets
· Developed and enhanced reports connecting to single or multiple data sources to improve performance
· Provided reporting, analysis and insights about sales drivers and key revenue performance metrics to support corporate analytics
· Interpreted data and translated ad hoc requirements and requests to deliver relevant and impactful results
· Monitored and troubleshot data source systems for data flaws and errors and upstream data issues
· Conducted business stakeholder interviews to ascertain problems and document and create business requirements
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
Job Titles Held: