| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
EMAIL AVAILABLE PHONE NUMBER AVAILABLE
LINKEDIN LINK AVAILABLESummaryAs a Data Analyst total 11+ years of experience, I leverage my Tableau certification and SQL proficiency to collect, evaluate, and present actionable data and recommendations that support marketing, business development, and product management decisions at a senior level. I have designed and developed reporting dashboards to analyze web activity from clickstream data using BI tools. I have also defined campaign strategy (including cross-channel treatments, control groups & A/B multivariant testing)I also have extensive experience in performing ETL processes on very large, complex, multi-dimensional datasets, using analytical and statistical tools to perform deep-dive analyses and optimize business performance and investment. I own, build, and automate the generation of SnS business metrics using Tableau, and manage multiple analytical projects in a fast-paced, intense, and results-oriented environment. I am passionate about solving problems at their root, understanding the broader context, and aligning my work with the high-level business goals.ExperienceAmazon.com Services LLC Seattle, WA Oct 2022 presentBusiness Intelligence Engineer/Data AnalystThe project is to build world-class processes around collecting, organizing, and presenting data to understand customer behavior, feature performance, and accurately calculate ROI across multiple marketing and business development channels. Collected, evaluated, and presented actionable data and recommendations to drive marketing, business development and product management decisions at a senior level. Owned, built, and automated generation of SnS business metrics using Tableau. Analyzed high-level business goals and continually align work with them to meet needs of business. Examined and solved problems at their root, stepping back to understand the broader context. Recognized and adopted best practices in data investigation and reporting: data integrity, test design, analysis, validation, and self-service automation. Wrote high quality code to retrieve and review data. Learnt and analyzed broad range of Amazon's data resources. Accessed and worked with data from multiple sources, and collaborated with internal stakeholders such as Product Managers, Data Scientists, and Software Engineers to help drive the business forward.PayPal San Jose CA May 2021 June 2022 SR Data AnalystThe project is to provide data-driven insights on the Consumer Marketing franchise, including but not limited to Business casing, Deep dives, Campaign Performance readouts and optimization and to deliver accurate, action-driving recommendations to drive business performance and investment optimization.Lead and perform deep-dive analyses using analytical and statistical tools on very large, complex, multi-dimensional datasets. Lead the engagement with the stakeholders and internal customers. Found applicability and actionability to their work, influencing stakeholders to make the most out of the work analytics. Managed multiple analytical projects at a time, in a fast-paced, intense, and results-oriented environment. Partnered with account executives to define campaign strategy (including cross-channel treatments, control groups & A/B multivariant testing) Tracked performance of campaigns and analyzed impact on profitability. Delivered more interactive Tableau reports that speak to the needs of business partners and provide greater visualized insights. Developed new and modify existing SQL code to meet operational report user stories requirement.Delta Dental Oakland, CA Mar 2018 - Mar 2021 Data AnalystThe project is to track email e ectiveness of Campaign. Dashboards and reports were built with the help of Tableau tool to transition manual reporting needs to automated processes and Tableau front-end designs. Prepared user stories to create compelling Tableau dashboards, reports, and KPI s based on business requirements, performed testing, and performed end-user training. Responsible for googling analytics reporting and analysis for various marketing campaigns. Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau. Actively involved in creation of user, groups, projects, workbooks, and the appropriate permission setup for Tableau server logons. Designed and developed reporting dashboards to analyze web activity from clickstream data using Tableau and SQL Performed administrative and support activities across Tableau infrastructure including security administration, installation, and configuration of the Tableau Server. Demonstrated flexibility and willingness to put on many di erent hats as is sometimes required of role to architect data models, ETL processes, and complex data entry applications that have a meaningful impact for multiple teams across the enterprise. Delivered more interactive Tableau reports that speak to the needs of business partners and provide greater visualized insights.Staples San Mateo, CA Jun 2017 - Jan 2018Senior Business Intelligence Developer/Data AnalystThe project was to track performance of Sales Team, visualize Call to Sales Conversion Metrics and forecast Sales. Dashboards and reports were built with the help of Tableau and Microsoft Power BI tool to determine best performing sales team and to check the sales(dollars) done by each rep and the time taken to convert call to order. Created advanced Tableau dashboards with quick/context/data-source filters, parameters and calculated fields that allowed to track and improve Sales units KPI by 13% within month. Served as primary contact for Tableau Server. Maintained and scheduled Tableau Data Extracts using Tableau Server. Created and managed Tableau sites, projects and workbooks, groups, data views, data sources and data connections. Demonstrated the ability to work under pressure, handling changing requirements, and dealing with tight.deadlinesDigite, Inc. Bangalore, India Apr 2015 - Apr 2016Sr. Business Data Analyst/ Senior ConsultantWorked on Retail Project that maximizes sales conversion. This is achieved with the help of Business Intelligence Tool. The Business Intelligence System using Tableau is responsible for developing and maintaining enterprise/corporate level Its management applications like forecast, spreadsheet data in data warehouse and data marts and feeding to analysis services for cube and reporting purposes. Created Tableau-based data visualization dashboards, performed testing, developed user guides, and performed end-user training. Developed several reports using Report designer of SSRS like linked reports, drill through reports, sub reports and parameterized reports. Defined Extract, Transform and Load (ETL) Strategies, creating ETL Packages and populating in ROLAP and MOLAP storage modes. Extensively involved in Data Extraction, Transformation and loading from OLTP to OLAP system in SQL Server 2005 by creating cubes that uses the relational data warehouse as sources to its dimensions and facts.Infosys Pune India Aug 2009 - Jun 2013
Senior System EngineerDeveloped collaboration platform for distributors with the help of MSBI (Microsoft Business Intelligence) tool to interchange data on sales, inventory, order cuts and other parameters critical for business intelligence. The project was to reduce ordering costs by up to 80 percent and increase store coverage by up to 15 percent. SSRS reports and SSAS analysis minimized costs by improving distributor productivity and enhancing sales force execution and maximized visibility by generating accurate and actionable insights across the distribution channel. Created Dimensional Models using star schema design and snowflake schema design. Design, development, unit, and system testing of ETL process using SSIS to load data into data warehouse data mart using star schemas. Created various cubes and optimized the same using the SSAS. Developed several reports using Report designer of SSRS like linked reports, drill through reports, sub reports and parameterized reports. Provided management with metrics, reports, and schedules as necessary, mapping business processes and documenting business flows. Optimized the performance of Stored Procedures and queries by identifying and eliminating bottlenecks.EducationCal State East Bay- College of Business & EconomicsMaster's degree, Business Analytics2016 - 2018 SYMBIOSIS INTERNATIONAL UNIVERSITYMaster of Business Administration (M.B.A.), Information Technology2013 - 2015 Thapar Institute of Engineering & TechnologyBachelor of Technology (B.Tech.)2005 - 2009Licenses & Certifications Tableau Certified Data Analyst - Tableau SoftwareIssued Jan 2022- Expires Jan 2024 Tableau Desktop Certified Associate - Tableau SoftwareIssued Mar 2020 - Expires Mar 2022 Tableau Desktop Specialist -Tableau Software Microsoft Certified Technology Specialist: SQL Server 2008, Database Development-MicrosoftD695-2297 Microsoft Certified Professional -MicrosoftE113-1115 Data Visualization with Python - IBM Data Science: Visualization - Harvard University375c24472d794c3c90e1ea580ab645ab |
