Richa Singh
Summary
- Skilled Data Analyst with 6+years of experience in Translating numbers and facts to inform strategic business decisions .
- Experienced Business Intelligence Developer with 10+ years of hands-on in Report Development, Deployment & maintenance using Tableau, Tableau Server, Power BI, Sigma, SSRS
- Interacting with business users for creating and following processes to keep data confidential and coming up with solutions to costly business problems
- Experience with Supplier contract data sets, Meta's data centers, Apple customer complaint center . customer PII information etc.
- Involved in project planning & troubleshooting of performance issues and testing using various defect tracking tools like JIRA
- Involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.
- Worked in all phases of complete BI life cycles including analysis, design, development, testing, deployment, post-production support/maintenance, documentation and end-user training.
- Good knowledge of data warehousing concepts, data modeling, created snowflake/star schemas as required, dimensions & facts etc.
- Good understanding of business environment, excellent communication skill and ability to work proactively in a fast-paced environment, communicate effectively with colleagues and business Users
Overview
12
12
years of professional experience
1
1
Certification
Work History
Data Analyst
Gaea Global (Client -Facebook)
Menlo Park, CA
06.2021 - Current
- Analyze business problems for collecting data from Data centers all across the country and provide solutions using data modeling and dashboards for Facebook's Data center schedulers for maintaining proper functioning of all the data hubs and keep a sanity check
- Understanding business requirements and documenting everything to create a project plan highlighting details like timeline, project complexity, kick-off requirements etc
- Share sample designs(POC) for helping clients get clearer picture of how dashboards will look like eventually
- Work with data team to analyze data related to data centers at Facebook and understand what schedulers want to see in the dashboard as critical metrics and what should be focused on the dashboard
- For building queries, we used an in-house query tool known as Daiquiri which uses syntax similar to SQL
- Create tables and views in Daiquiri to use as data source for Tableau Dashboard (2020.1)
- Take complete ownership of building data source, designing dashboard, testing data before sharing it with the team, publishing dashboards to server and setting permissions for selected audience on the server.
- Documented all feedback provided by the client in a status tracking document to keep track of all changes in a timely manner and put together high-level summary of all the tasks done to complete the project
BI Developer & Data Analyst
Maris Consulting (Client - Medallia)
San Mateo, CA
11.2019 - 03.2020
- Design dashboard for Medallia's customer contract data using data from an application deployed on salesforce using Tableau Online and Sigma
- Data modeling using snowflake in order to make data ready for building dashboards
- Analyzed customer data on salesforce and understand requirements from end users
- Run ETL job using Fiserv tool to migrate data from salesforce into snowflake
- Build views in snowflake to provide data for building visualizations using Tableau and publish dashboards on Tableau online after multiple rounds of testing
- Took complete ownership of assigned modules and delivered them within deadlines
- Documented all requirements and feedback provided by client and put together high level summary of all the tasks done to complete the project
Tableau Developer & Data Analyst
LTI (Client - Apple)
Cupertino, CA
01.2019 - 11.2019
- Developed user-friendly tool for Apple's legal team which would display customer complaints data in order to resolve case filed against Apple
- Data ranged from 3-4 Million of rows and very critical so had to build with lot of data modeling, extracts and regular refresh schedules
- Teradata was used for data modeling and reporting tool was Tableau
- Developing business critical dashboards for Apple's Legal team
- Gathering requirement from GBI (Global business intelligence) team in regular meeting sessions
- Analyze data and build visualizations best suited to convey right story to legal attorneys
- Used Tableau Desktop, Tableau Server to build and publish visualizations
- Working directly with business users for getting sign-off on all dashboards and data
Tableau Developer & Data Analyst
Nationwide Insurance
Columbus, OH
08.2017 - 12.2018
- Building dashboards for representing third party contracts with the company and maintain reports for keeping check on any kind of defects or contract violation
- Designing and publishing dashboards to Tableau Server
- Communicating and understanding client's business requirements by constructing easy-to-understand data and process models and facilitate weekly meetings with clients to document status, new requirements and explore potential solutions
- Good Understanding of Goal, Question, Metric (GQM) methodology, dashboard design and best practices, Tableau Server, Agile, and data manipulation
- Involved in troubleshooting of performance issues and testing using various defect tracking tools validates complex system requirements and existing business processes and information systems
- Designs, develops and implements new programs and/or modifications of existing applications
- Analyze supplier data using Aginity query tool for building proof of concepts using third parties' data from Netezza and work with ETL team for creating fields with same logic to be used as fields for Tableau dashboards and views
- Create Tableau data source workbooks and publish on tableau server to build tableau dashboards
- Create customized charts like doughnut, Sankey, waffle charts depending on the nature of third party data available from ETL.
Senior Data Analyst
Infosys Ltd. (Client - Capital Group Financial)
, NY
03.2015 - 11.2016
- Migration project for converting old BO, Cognos reports into SSRS and Tableau reports
- Responsibilities:
- Analyze client's business requirements and processes through document analysis, interviews, workshops, and workflow analysis for designing data warehouse and transform data into interactive data visualizations
- Develop business architecture using requirements such as scope, processes, alternatives, and risks
- Understand Requirements and Functionality of application from specifications and detailed walk through of existing crystal and Cognos reports and Dashboards
- Communicate client's business requirements by constructing easy-to-understand data and process models and facilitate weekly meetings with clients to document status, new requirements and explore potential solutions
- Provide input into developing and modifying systems to meet client needs and develop business specifications to support these modifications
- Liaise between business and technical personnel to ensure a mutual understanding of processes and applications
- Designed, developed, tested, and maintained Tableau functional reports based on user requirements and existing Crystal and Cognos reports
- Mastered ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau
- Worked closely with Business users
- Interacted with ETL developers, Project Managers, and members of QA teams
- Converted existing BO, Cognos reports to better quality visualization tableau dashboards using Tableau Desktop, created different KPI using calculated key figures and parameters
- Experience in dashboard design and data visualization using best practices used in visualization and design
- Also, performed administrative task such as managing ownership, setting permissions, providing access to particular users, also worked on defect tracking using various testing tools
Data Analyst
PC Solutions (Client - Genpact)
06.2014 - 03.2015
- Build data warehouse by ETL process using SSIS tool and putting data into multidimensional cube (SSAS)
- Goal was to create reports for business users
- Engage client to gather software requirements/business rules, and ensure alignment with development teams to ensure proper requirement Gathering and understanding functionalities of this application
- Work on client's business requirements by constructing easy-to-understand data and process models and facilitate weekly meetings with clients to document status, new requirements and explore potential Solutions
- Regular interactions with Business user, QA team, Development team and have regular standup meetings within the team to keep track of the project
- Developed Data warehouse by extracting existing data from diverse data source which was consolidated into uniform SQL server 2012 database (Data Warehouse)
- ETL capabilities of SQL server Integration services (SSIS) were used to define imports of data, build scheduling packages, to define integration flow and to define Database maintenance plans and send Emails
- Data Modeling (Multidimensional modeling) Create number of cubes, dimensions and business critical KPIs using SQL server Analysis service (SSAS) representing aggregations in several different ways-hierarchically and using custom groupings that company will use to analyze dashboard performance
- Creating several MDX queries according to business requirements
- Design and deploy dynamic graphical reports including features like drill down, KPI's, drop down menu, Parameters and publish reports using Tableau server and shared links with business users
- Draft and maintain business requirements and align them with functional and technical requirements
- Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations
- Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's
- Strong Dashboard design experience and passionate practitioner of effective data visualization
- Familiarity with best practices around visualization and design
- Also, involved in administration tasks such as Setting permissions, managing ownerships and providing access to users and adding them to specific user groups
- Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
BI Developer
PC Solutions (Client - Getit Info Media Pvt. Ltd)
04.2011 - 05.2014
- Develop dynamic business Reports and dashboards using multidimensional model (Cubes)
- Existing data from diverse data source were consolidated into a uniform SQL server 2012 database (Data Warehouse)
- ETL capabilities of SQL server Integration services (SSIS) were used to define imports of data, build scheduling packages, to define integration flow and to define Database maintenance plans and send Emails
- Create number of cubes, dimensions and business critical KPIs using SQL server Analysis service (SSAS) representing aggregations in several different ways-hierarchically and using custom groupings that company will use to analyze performance
- Creating several MDX queries according to business Requirements
- Developed several detail and summary reports including line and pie-chart, trend analysis reports and sub reports according to business requirements using SQL server Reporting service (SSRS)
- Implemented business intelligence Dashboards using SSRS and excel Services producing different summary results based on user view and role membership.
Education
Bachelors - Electronics and Communication
Rajiv Gandhi Prodyogiki Vishwavidhyalaya
India2010
Skills
- Software Skills
- Tools/IDEs: Tableau Desktop, Tableau Server, Sigma, SSRS, MicroStrategy, Power BI
- Database: MSSQL, Snowflake, Trino(Presto),Oracle, Netezza, Teradata, Sybase
- Conceptual: Software Development Life Cycle, ETL, Data Lake, Containerization
- Platforms: Linux, Windows 7 and above
- Data Quality Assurance Processes
- Business Management
Accomplishments
Tableau Desktop Certified 2020
Certification
Tableau Desktop Specialist June 2020
Timeline
Data Analyst
Gaea Global (Client -Facebook)
06.2021 - Current
BI Developer & Data Analyst
Maris Consulting (Client - Medallia)
11.2019 - 03.2020
Tableau Developer & Data Analyst
LTI (Client - Apple)
01.2019 - 11.2019
Tableau Developer & Data Analyst
Nationwide Insurance
08.2017 - 12.2018
Senior Data Analyst
Infosys Ltd. (Client - Capital Group Financial)
03.2015 - 11.2016
Data Analyst
PC Solutions (Client - Genpact)
06.2014 - 03.2015
BI Developer
PC Solutions (Client - Getit Info Media Pvt. Ltd)
04.2011 - 05.2014
Bachelors - Electronics and Communication
Rajiv Gandhi Prodyogiki Vishwavidhyalaya
Similar Profiles
Pinky ShajiPinky Shaji
Functional Consultant (On Site & Off Shore) at Gaea global technologies,IncFunctional Consultant (On Site & Off Shore) at Gaea global technologies,Inc
Sanchana SrikanthSanchana Srikanth
Web Developer at Gaea Global TechnologiesWeb Developer at Gaea Global Technologies
SAMEEKSHA T PSAMEEKSHA T P
Technical Consultant at Gaea Global TechnologiesTechnical Consultant at Gaea Global Technologies
Manoj Singh RawatManoj Singh Rawat
Data Analyst/Data Migration Analyst at Sopra SteriaData Analyst/Data Migration Analyst at Sopra Steria
Lenina MirzaLenina Mirza
Data Analyst (Customer Support Data Analyst) at Mazda Australia Pty LtdData Analyst (Customer Support Data Analyst) at Mazda Australia Pty Ltd