Data Analyst Resume
Fontana, CA
SUMMARY
- 7 years of experience in IT industry as a Data Analyst, Tableau Server Administrator, Tableau Developer with extensive knowledge in functional and technical domain of Business Intelligence, creating reports, dashboards through Tableau, identifying trends and process mapping with a background in Databases Design, Modeling, Development, Implementation and Testing of Data Warehouse applications, ETL and other Data Warehousing concepts.
- Experience working with Tableau Desktop, Tableau Server and Tableau Reader in various versions.
- Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
- Utilized Tableau to produce appealing data visualizations to clients and to help them make business decisions with the help of Ad hoc reporting and Dashboards.
- Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data for complex Data movement and data analysis.
- Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, Star and Snowflake schema modeling.
- Experience implementing Data Warehouse presentation layer - including design and definition of logical tables, physical sources, columns, aggregation rules.
- Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
- Experience in integration of various data sources like Teradata, SQL Server, Oracle, DB2, Netezza and Flat Files.
- Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production.
- Experienced in developing rich Interactive reports and dashboards integrating various reporting components from multiple sources and Tableau servers for maintaining DB schemas.
- Having knowledge on Salesforce Service cloud like, Case Management, Solution Management using Assignment Rules, Auto Response Rules and Escalation Rules.
- Knowledge of Data Modeling Concepts (Logical and Physical) including 3NF, Supertypes, Subtypes, Abstraction, Associative entities / tables
- Good Knowledge in design and implementation processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Server Reporting Services (SSRS)/Power BI.
- Experience in designing, developing, and delivering business intelligence solutions using Power BI, SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
- Experience in Salesforce.com Setup, Configuration, Customization, Administration, Data Migration and Integration tools like Apex Data Loader, Work Bench.
- Used various sources to pull data into Power BI such as SQL Server, Excel, Oracle, SQL Azure etc.
- Azure Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) and Familiarity with Excel PowerPivot, Power View, and Power BI.
- Created functional and technical requirements as an input to application design business solution components and prototypes.
- Experience in using python API, java script API.
- Extensive experience in relational Data modeling, Dimensional data modeling, logical/Physical Design, ER Diagrams and OLTP and OLAP System Study and Analysis.
- Extensive experience in Enterprise Information Management and Architecture technologies including Information Lifecycle, Master Data Management and Business Intelligence.
- Extensively used ERWIN and Power-Designer to design Logical and Physical Data Models, Data Mapping to forward and reverse engineering data models and publishing data model to acrobat PDF files.
- Excellent understanding of relational database concepts and dimensional modeling techniques, Star and Snow-flake schema.
- Building user acceptance and monitor test plans, test scenarios, test processes and schedules, and prior testing and training.
- Responsible for Knowledge transfer and training existing and newly recruited resources on various View practices and processes such as report development, deployment, custom SQL scripts and tools used for managing and developing reports, deploying the developed reports to the server.
- Experienced in Tableau Server administration including setting up Active Directory users and groups, giving appropriate permissions for viewing published dashboards and scheduling data refresh instances.
- Experience in gathering requirements, analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects, also developed frameworks, roadmaps, and processes in support of technology.
- Good Working Knowledge in Agile Project management (Scrum process).
TECHNICAL SKILLS
BI Tools: Tableau Desktop 2018.2/2019.2 9. x/10.x, Tableau Server 2018.2/9.x/10.x, Tableau Reader, Tableau Public, Power BI, SSRS
RDBMS: SQL Server Management Studios, MY SQL, MS Access, Microsoft Azure, Power BI, SSAS, SSIS, SSRS.
Data Bases: MS SQL Server 2012/2008R2/2008/2005, Teradata, Horton works Hadoop Hive, Oracle 9i, 10g, R12.1, MySQL, SSMS
ETL: SSIS, Informatica 9.6/9.1/8.6.1/8.1/7.1 , Informatica BDM 10.1, Azure Data Factory (ADF), Informatica Cloud Services (ICS), DataStage, Alteryx 11
Productivity Tools: MS Word, MS Excel, MS PowerPoint, MS Visio, MS Project, Access, Erwin, Toad, SharePoint
Operating Systems: Windows 7/XP, Windows Server UNIX/Linux
Cloud Technology: Amazon AWS/EC2, S3, Lambda
Version Control Systems: GitHub, GitLab, BitBucket
PROFESSIONAL EXPERIENCE
Confidential
Data Analyst
Responsibilities:
- Leveraging analytic and technical skills to innovate, build, and maintain well-managed data solutions and capabilities to tackle business problems.
- Using Open Source/Digital technologies to mine complex, voluminous, and different varieties of data sources and platforms.
- Building well-managed data solutions, tools, and capabilities to enable self-service frameworks for data consumers.
- Developed Machine Learning features using Snowflake tables/views to help data science in Fraud analysis and Fraud detection.
- Exploring and quickly grasping new technologies to progress varied initiatives.
- Partnering with the business to provide consultancy and translate the business needs to design and develop tools, techniques, metrics, and dashboards for insights and data visualization.
- Worked on setting up staging and production environment for CI workflow using Jenkins and its plugins.
- Driving an understanding and adherence to the principles of data quality management including metadata, lineage, and business definitions.
- Creating a fully automated build and deployment Platform and coordinating code builds promotions and orchestrated deployments using Jenkins and GitHub.
- Virtualized the servers using the Docker for the test environments and dev-environments needs, and configuration automation using Docker containers.
- Extensive knowledge of AWS glue service to transform data, also used to slice and dice the data to the granular level.
- Developing complex Tableau and power-bi reports based on business use case.
- Implementing the architectural approach from start to end for reporting needs.
- Working collaboratively with appropriate Tech teams to manage security mechanisms and data access governance.
- Building and executing tools to monitor and report on data quality.
Environment: Snowflake, Databricks, SQL, Python, Pyspark, GitHub, The Exchange, AWS S3, Jenkins, Docker, Datadog, Legoland, Visual Studio code, Putty, JIRA
Confidential, Fontana, CA
Tableau Data Analyst
Responsibilities:
- Arranged walkthrough sessions with the user group and to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
- Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
- Conducted and participated in JAD sessions with the users, modelers, and developers for resolving issues.
- Performed source data quality assessments and created source to target mapping documentation defining source rules, target rules, and data transformations for various ETL packages using Talend.
- Created Data Definitions, Data Mappings and Data Movement operations help maintain Metadata repository.
- Developed Jobs in Talend Enterprise edition from stage to source, intermediate, conversion and Target
- Worked on Talend ETL to load data from various sources to DB2. Used t-map, t-replicate, t-filter row, t-sort and various other features in Talend.
- Effectively involved in the data migration from Teradata server to MySQL Server of Tableau reporting Systems.
- Created TD Objects like Tables, Views and used TeradataMacros for various Teradata analytic functions with the usage of techniques like RANK, ROWNUMBER and Ordered Analytical functions.
- Worked on Talend ETL and used features such as Context variables, Database components like t - SQL Input, t-Oracle Output, file components, ELT components etc.
- Followed the organization defined Naming conventions for naming the Flat file structure, Talend Jobs and daily batches for executing the Talend Jobs.
- Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
- Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, Groupings, live connections, and in-memory in both tableau and excel.
- Worked on motion chart, Bubble chart, drill down analysis using tableau desktop.
- Involved in creating stored procedures, views, and custom SQL queries to import data from SQL server to Tableau.
- Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
- Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
Environment: Tableau Server 2019.2, Tableau Desktop 2019.2, Excel, SQL Server Management Studios, AWS, Talend Data integration 5.6.1, Teradata, DB2, T-SQL, Tableau Prep, SSIS, SSRS, JIRA
Confidential, Roseville, MN
Tableau Data Analyst/ Admin
Responsibilities:
- Analyzed user requirements and functional design, prepared technical specifications, unit test plans, and created platform to run and validate the test cases for updating Early Childhood Data stories.
- Worked with Subject Matter Experts (SMEs) in understanding, documenting, developing, and testing their requirements.
- Performed modifications to SQL scripts used to deliver data to downstream report interfaces.
- Setting up active directory on the tableau server for the effortless password management for the single sign on in the Salesforce and to view the embedded dashboards.
- Employed variousTableaufunctionalities like Parameters, Global Filters, Contexts Filters,DataSource Filters, Actions Filters, Functions, Hierarchies, Sets, Groups, Calculations, etc.
- Designed and developed reports according to Confidential Accessibility standards.
- Developed xml scripts to add State Color branding to the Tableau preferences file to set as the default color pattern in Tableau Desktop.
- Responsible for Knowledge transfer and training existing and newly recruited resources on various View practices and processes such as report development, deployment, custom SQL scripts and tools used for managing and developing reports, deploying the developed reports to the server.
- Generated matrix reports, tabular reports, drill down, drill through, sub reports and multi-parameterized reports.
- Implemented Row Level Security to restrict rows of data to users for various Districts and Sites.
- Developed tableau dashboard landing page for the embedding into Salesforce in order to provide integrated views and navigation inside Salesforce for the users.
- Developed various dashboards for non-Salesforce group of users for their specific goals of understanding data.
- Developed business intelligence applications for data analysis optimized for the best performance and scalability requirements using Tableau Prep.
- Designed and created data extracts, supporting Tableau data visualization applications.
- Developed Data sources used for ECLDS reporting and Fiscal year Headcount for Kindergarten and Pre-Kindergarten.
- Automated Power Query refresh using power shell script and windows task scheduler.
- Used various sources to pull data into Tableau Client such as SQL Server, Oracle, SQL Azure etc.
- Research ways to help the report users to see the bigger picture at a single glance and insert the ability to drill through the different levels of dimensions.
- Assisting users in creating and modifying worksheets and data visualization dashboards.
- Testing the reports for formatting and data correctness and publishing the workbooks on the Tableau server for scheduled refreshes.
- Developed and provided documentation, training, and support for business users.
Environment: Tableau Server 2018.2/2019.2 , Tableau Desktop 2018.2/2019.2 , Azure SQL, Azure Data Factory (ADF), Azure Data bricks, Tableau Prep 2020.2, Salesforce.com, Erwin, Visual Studios, Excel, Access, SharePoint, SQL Server Management Studios, Unix, Power Query, SSIS, SSRS.
Confidential, Rochester, MN
Tableau Data Analyst/ Tableau Admin
Responsibilities:
- Interacting with the client to understand the project and finalize its scope. Estimation, design and development of various modules.
- Coordinating with other teams working on the same project. Ensuring smooth delivery of the project.
- Major part of the Big Data Admin team to carry out the reporting activities after the old systems are decommissioned and the data is migrated into Big Data.
- Decommission of old systems and migrating data availability and data quality into Big Data.
- Load and transform data into HDFS from large set of structured data DB2, Oracle, SQL server using Talend Big data studio.
- Created Talend jobs to copy the files from one server to another and utilized Talend FTP components.
- Performance tuning - Using the t-map cache properties, multi-threading and t-Parallelize components for better performance in case of huge source data. Tuning the SQL source queries to restrict unwanted data in ETL process.
- Perform the required data wrangling before connecting to the data source (Hive) from the Tableau client.
- Used HiveQL to run queries in Hive and extract data into Tableau Client.
- Used multiple join conditions to get the data from different tables and use the same to create custom SQL in Tableau.
- Developed individual reports and design the final dashboard according to the user requirement.
- Research ways to help the report users to see the bigger picture at a single glance and insert the ability to drill through the different levels of dimensions.
- Employed variousTableaufunctionalities like Parameters, Filters, Contexts,DataSource, Filters, Actions Functions, Hierarchies, Sets, Groups, Calculations, etc.
- Experience in creating different visualizations using Bar chart, Stacked Bars, Line Graph, Pie chart, Gantt chart, Heat Maps, Box plot, Scatter plots, Histograms, Bullets, etc.
- Created individual SSIS packages to load dimensions, fact tables then created ETL Master package to load data in Data mart
- Created Page Level Filters, Report Level Filters, and Visual Level Filters in Power BI according to the requirements.
- Prepared detailed document of the Data movement to known issues for future reference.
- Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
- Administered user, user groups, and scheduled instances for reports in Tableau.
- Documenting the dashboard needs, the critical success factors of the business, related KPIs and measures in the dataset, and the designs.
- Assisting users in creating and modifying worksheets and data visualization dashboards.
- Usage monitoring, technical policies set up and controls, admin best practices, technical audits, Managing Tableau Sites and servers in with a clustered environment.
- Testing the reports for formatting and data correctness and publishing the workbooks on the Tableau server for scheduled refreshes.
- Created report schedules, data connections, projects, groups in Unix/Tableau server.
- Developed and provided documentation, training, and support for business users.
- Worked on Agile Methodology, where Team Foundation Server (TFS) is used as a tool to update tasks of user story.
Environment: Tableau Server 10.5, 2018.1, Tableau Desktop 10.5.1, 2018.1, Tableau Prep 10.1, Talend Platform for Big Data, Big Query, Teradata, Excel, SQL Server Management Studios, SSIS, SSRS, Spark, Scala, Horton works Hadoop Hive, Python, HIPPA Gateway Testing, DB2, TFS, SharePoint.
Confidential
Responsibilities:
- Interacting with the client to understand the project and finalize its scope.
- Estimation, design and development of various modules.
- Coordinating with other teams working on the same project.
- Ensuring smooth delivery of the project.
- Create and designed multiple dashboards as per the customer requirements.
- Develop High performance report and dashboard with high volume data.
- Responsible for all the design fixes for multiple dashboards created by the team.
- Providing continuous feedback to the team on the dashboards design.
- Migration of Finance reports from MicroStrategy, SAP BO, reports to Tableau.
- Develop story telling dashboards inTableauDesktop and published them on toTableau Server which allowed end users to understand the data with the usage of quick filters for demand needed information.
- Tableau dashboards embedding into Salesforce for the continuous data experience for the users,
- Built custom tableau dashboards for the Salesforce for accepting the parameters from the Salesforce to show the relevant data for that selected object.
- Setting up active directory on the tableau server for the effortless password management for the single sign on in the Salesforce and to view the embedded dashboards.
- Performance tuning, Trouble shooting and support of existing system.
- Resolve various performance issues and analyzed the best process distribution for different projects.
- Design and develop reports such as Drill down, Drill-Through using Microsoft Reporting Services.
- Review dashboard and communicate with stakeholders and business groups.
- Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktop by connecting live/dynamic and static datasets.
Environment: Tableau Server 10.5, 2018.1, Tableau Desktop 10.5.1, 2018.1, Excel, Salesforce.com, SQL Server Management Studios, SSAS, SSIS, SAP BO, MicroStrategy.
Confidential, Newark, DE
Tableau Developer
Responsibilities:
- Conducting and participating in meetings in order to understand what users are looking for.
- Perform the required data wrangling before connecting to the data source from the Tableau client.
- Developed individual reports and design the final dashboard according to the user requirement.
- Research ways to help the report users to see the bigger picture at a single glance and insert the ability to drill through the different levels of dimensions.
- Analyze the data sources, be it a RDBMS or a XLSX file or a CSV file.
- Created workbooks and dashboards by extracting data from different sources.
- Created Tableau workbooks using parameters, sets, groups and calculations, mapping and hierarchies depending on the requirement.
- Created interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
- Created drill through reports in dashboard.
- Use data blending Techniques in case of merging different sources.
- Created dual-axis charts with multiple measures.
- Good SQL reporting skills with the ability to create SQL views and write SQL queries.
- Experience in analysis, design and implementation of BI applications using Tableau product suite.
- Maintained and Installed Tableau Server in all the environments.
- Experience with Power Query trouble shooting, Performance Tuning using Very Large Database settings.
- Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
- Monitored Application Server and data server activity to track performance and system stability.
- Developed SQL scripts to Insert/Update and Delete data in SQL server management studios 2012 database tables.
- Designed, modified database objects such as tables, views, indexes, user defined data types and functions.
- Developed complex SQL packages for Invoice Processing.
- Created DTS packages to perform data transfer from different server locations and other sources like Oracle, Excel, MS Word and Text Format Data.
- Migrating DTS packages to SSIS, created control flow and data flow diagrams in SSIS for extraction, transformation and loading of data into excel file.
- Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
- Experience in MS SQL Server suite of products like SSRS, SSAS and SSIS of MS SQL Server.
- Updated Tableau server from 9.3 to 10.1 to all the instances. Was responsible to create sites, projects and set user permissions.
- Testing the reports for formatting and data correctness and publishing the workbooks on the Tableau server for scheduled refreshes.
- Created report schedules, data connections, projects, groups in Tableau server.
Environment: Tableau Server 9.x/10.x, Tableau Desktop 9.x/10.x, Excel, SQL Server management studio, Amazon Redshift, Teradata V13, MicroStrategy 10.4, MS SQL Server 2008R2, Oracle
Confidential, SFO
Tableau/ SQL BI Developer
Responsibilities:
- Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
- Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions. Preparing the report design specifications based on the user's requirement.
- Proficient in Building compelling, interactive dashboards and stories inTableauthat answer key business questions.
- Extractingdatafrom different sources (Oracle, SQL server, MS Excel), connecting them and using the same to create dashboards inTableau.
- Created interactive dashboards and applied actions (filter, highlight and URL) to dashboard.
- Worked on generating various dashboards in Tableau Server using different data sources.
- Worked with Python OO Design code for manufacturing quality, monitoring, logging, and debugging code optimization.
- Wrote a Python module to connect and view the status of an Apache Cassandra instance.
- Developed tools using Python, Shell scripting, XML to automate some of the menial tasks.
- Used Python unit and functional testing modules such as unit test, unittest2, mock, and custom frameworks in-line with Agile Software Development methodologies.
- Created multiple dashboards with Drill Down capabilities using dashboard prompts, Local and Global Filters.
- Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
- Involved in administering user, user groups and schedule instances for Tableau reports.
- Maintaining Tableau reports & analysis and work on enhancements to existing reports or creating new reports based on business needs.
- Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
- Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
- Administered user, user groups, and scheduled instances for reports in Tableau.
- Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
- Usage monitoring, technical policies set up and controls, admin best practices, technical audits, Google analytics trends, Managing Tableau Sites and servers in with a clustered environment.
- Used Google analytics to observe the trend data for various sales domain and pull the info into Tableau.
- Edited the node connections for Action Vector.
- Migrated views and Tables from SQL to Amazon Redshift successfully despite Redshift with different compatibility in querying.
- Worked extensively on Data Migration by using SSIS. Used different transformations lookup, condition split, row count Transformation, Derived Column, Data Conversion and Union All.
- Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
- Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
Environment: Tableau desktop 9.x, Tableau Server 9.x, SSRS, SSIS, Python, Oracle, Google Analytics, SQL Server 2008/2005 SQL Server data tools.