Data Analyst Resume
Fontana, CA
SUMMARY
- 7 years of experience in IT industry as a Data Analyst, Tableau Server Administrator, Tableau Developer wif extensive noledge in functional and technical domain of Business Intelligence, creating reports, dashboards through Tableau, identifying trends and process mapping wif a background in Databases Design, Modeling, Development, Implementation and Testing of Data Warehouse applications, ETL and other Data Warehousing concepts.
- Experience working wif 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 teh end user requirement.
- Utilized Tableau to produce appealing data visualizations to clients and to halp them make business decisions wif teh halp 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 teh 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 teh development of Dashboard reports for teh Key Performance Indicators for teh 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) dat 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 noledge 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 wif 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 .
- Responsible for Knowledge transfer and 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 teh developed reports to teh 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 halp data science in Fraud analysis and Fraud detection.
- Exploring and quickly grasping new technologies to progress varied initiatives.
- Partnering wif teh business to provide consultancy and translate teh 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 teh 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 teh servers using teh Docker for teh test environments and dev-environments needs, and configuration automation using Docker containers.
- Extensive noledge of AWS glue service to transform data, also used to slice and dice teh data to teh granular level.
- Developing complex Tableau and power-bi reports based on business use case.
- Implementing teh architectural approach from start to end for reporting needs.
- Working collaboratively wif 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, Teh Exchange, AWS S3, Jenkins, Docker, Datadog, Legoland, Visual Studio code, Putty, JIRA
Confidential, Fontana, CA
Tableau Data Analyst
Responsibilities:
- Arranged walkthrough sessions wif teh user group and to confirm dat all teh requirements have been captured and obtained sign off on teh requirements documents.
- Identified teh key facts and dimensions necessary to support teh business requirements. Develop teh logical dimensional models.
- Conducted and participated in JAD sessions wif teh 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 halp 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 teh 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 wif teh 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 teh organization defined Naming conventions for naming teh Flat file structure, Talend Jobs and daily batches for executing teh Talend Jobs.
- Created Tableau worksheet which involves Schema Import, Implementing teh 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 wif 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 teh test cases for updating Early Childhood Data stories.
- Worked wif 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 teh tableau server for teh effortless password management for teh single sign on in teh Salesforce and to view teh 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 teh Tableau ps file to set as teh default color pattern in Tableau Desktop.
- Responsible for Knowledge transfer and 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 teh developed reports to teh 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 teh embedding into Salesforce in order to provide integrated views and navigation inside Salesforce for teh 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 teh 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 halp teh report users to see teh bigger picture at a single glance and insert teh ability to drill through teh different levels of dimensions.
- Assisting users in creating and modifying worksheets and data visualization dashboards.
- Testing teh reports for formatting and data correctness and publishing teh workbooks on teh Tableau server for scheduled refreshes.
- Developed and provided documentation,, 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, Nashville, TN
Tableau Data Analyst/ Tableau Admin
Responsibilities:
- Interacting wif teh client to understand teh project and finalize its scope. Estimation, design and development of various modules.
- Coordinating wif other teams working on teh same project. Ensuring smooth delivery of teh project.
- Major part of teh Big Data Admin team to carry out teh reporting activities after teh old systems are decommissioned and teh 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 teh files from one server to another and utilized Talend FTP components.
- Performance tuning - Using teh t-map cache properties, multi-threading and t-Parallelize components for better performance in case of huge source data. Tuning teh SQL source queries to restrict unwanted data in ETL process.
- Perform teh required data wrangling before connecting to teh data source (Hive) from teh Tableau client.
- Building scalable distributed data solutions using Hadoop. Used HiveQL to run queries in Hive and extract data into Tableau Client.
- Setup and benchmarked Hadoop/HBase clusters for internal use and to connect Tableau client.
- Experience in managing and reviewing Hadoop log files.
- Used multiple join conditions to get teh data from different tables and use teh same to create custom SQL in Tableau.
- Developed individual reports and design teh final dashboard according to teh user requirement.
- Research ways to halp teh report users to see teh bigger picture at a single glance and insert teh ability to drill through teh 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 teh requirements.
- Prepared detailed document of teh Data movement to non issues for future .
- 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 teh dashboard needs, teh critical success factors of teh business, related KPIs and measures in teh dataset, and teh 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 wif a clustered environment.
- Testing teh reports for formatting and data correctness and publishing teh workbooks on teh Tableau server for scheduled refreshes.
- Created report schedules, data connections, projects, groups in Unix/Tableau server.
- Developed and provided documentation,, 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.
- Interacting wif teh client to understand teh project and finalize its scope.
- Estimation, design and development of various modules.
- Coordinating wif other teams working on teh same project.
- Ensuring smooth delivery of teh project.
- Create and designed multiple dashboards as per teh customer requirements.
- Develop High performance report and dashboard wif high volume data.
- Responsible for all teh design fixes for multiple dashboards created by teh team.
- Providing continuous feedback to teh team on teh 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 teh data wif teh usage of quick filters for demand needed information.
- Tableau dashboards embedding into Salesforce for teh continuous data experience for teh users,
- Built custom tableau dashboards for teh Salesforce for accepting teh parameters from teh Salesforce to show teh relevant data for dat selected object.
- Setting up active directory on teh tableau server for teh effortless password management for teh single sign on in teh Salesforce and to view teh embedded dashboards.
- Performance tuning, Trouble shooting and support of existing system.
- Resolve various performance issues and analyzed teh best process distribution for different projects.
- Design and develop reports such as Drill down, Drill-Through using Microsoft Reporting Services.
- Review dashboard and communicate wif 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 wat users are looking for.
- Perform teh required data wrangling before connecting to teh data source from teh Tableau client.
- Developed individual reports and design teh final dashboard according to teh user requirement.
- Research ways to halp teh report users to see teh bigger picture at a single glance and insert teh ability to drill through teh different levels of dimensions.
- Analyze teh 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 teh 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 wif multiple measures.
- Good SQL reporting skills wif teh 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 teh environments.
- Experience wif 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 wif users, team lead, DBAs and technical manager to fully understand teh requirements of teh 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 teh instances. Was responsible to create sites, projects and set user permissions.
- Testing teh reports for formatting and data correctness and publishing teh workbooks on teh 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, CA
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 wifin Tableau Desktop.
- Created views in Tableau Desktop dat were published to internal team for review and further data analysis and customization using filters and actions. Preparing teh report design specifications based on teh user's requirement.
- Proficient in Building compelling, interactive dashboards and stories inTableaudat answer key business questions.
- Extractingdatafrom different sources (Oracle, SQL server, MS Excel), connecting them and using teh 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 wif Python OO Design code for manufacturing quality, monitoring, logging, and debugging code optimization.
- Wrote a Python module to connect and view teh status of an Apache Cassandra instance.
- Developed tools using Python, Shell scripting, XML to automate some of teh menial tasks.
- Used Python unit and functional testing modules such as unit test, unittest2, mock, and custom frameworks in-line wif Agile Software Development methodologies.
- Created multiple dashboards wif 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 dat teh views and dashboards were displaying teh 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 wif a clustered environment.
- Used Google analytics to observe teh trend data for various sales domain and pull teh info into Tableau.
- Edited teh node connections for Action Vector.
- Migrated views and Tables from SQL to Amazon Redshift successfully despite Redshift wif 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 teh 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.