Anjali Raj

Tableau Developer

Phone: 862-***-****

Email: ad1lld@r.postjobfree.com

SUMMARY:

Overall 8+ years of experience in Analysis, Design, and Development of Data warehousing projects in Finance, HR, and Healthcare domains using Tableau and OBIEE Tools.

Worked on Agile SDLC and SCRUM for managing software development.

Sound knowledge of different phases of software development life cycle (analysis, design, development, test) for Business Intelligence solutions.

Strong understanding of Dimensional Modeling (Star and Snowflake Schemas)

Worked on up-gradation and migration of Tableau /OBIEE between Dev/QA/UAT/Prod environments.

Experienced in designing customized interactive dashboards in Tableau using drill-down, guided navigation, prompts, filters, and variables.

Expert in the design and creation of different dashboards and reports utilizing Tableau Visualizations such as bar graphs, scatter plots, pie charts, geographic visualization, and others leveraging actions, other local and global filters based on end-user requirements.

By integrating Denodo with Tableau, built versatile, data-driven dashboards that provide valuable insights.

Developed Tableau reports and dashboards for multiple data sources using data blending.

Experience in writing expressions in Tableau and Expert in fine-tuning the reports.

Good experience in creating Tableau worksheets and Tableau dashboards.

Expert in using OBIEE Answers to create queries, format views, and charts, and add user interactivity and dynamic content to enhance the user experience.

Extensive experience in migrating a Tableau data source from one source to another.

Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors, and Indexes using SQL.

Experience in Performance Tuning and Query Optimization.

Proficient in creating Calculations (Cube Calculations, hiding columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting, Shared Encoding) using Tableau Desktop.

Expert in generating on-demand and scheduled reports for business analysis or management decisions using SQL Servers Reporting Services (SSRS), Tableau, and POWER BI. Expertise in Installation, configuration, upgrading, and administration of Tableau Desktop/Server.

Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.

Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS) and Reporting Services (SSRS).

Experience in Data analysis and reporting in health care and marketing dept. SAS experience includes detailed knowledge of statistical analysis of marketing and health care data and in the production of reports, tables, graphs, and listings.

Strong experience in using MS Excel (Pivot table, VLOOKUP, etc.,) and MS Access to dump the data and analyze based on business needs.

Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing, and processing, writing data extract scripts/programming of data conversion, and researching complex data problems.

Proficient in working on SQL in Oracle 8i/9i/10g/11, SQL Server (MS Sequel Server) 2005/2008, DB2, Teradata 13 databases, Snowflake, Google Big Query, Vertica, Hive, AWS, and SAP HANA, BW/BI.

Proficient in using Amazon Web Services (AWS) Extensive experience with services like EC2, IAM, S3, Redshift, Quick Sight, and Kinesis.

EDUCATION:

Bachelor's in computer science from Kakatiya Institute of Technology, India – MAY 2015

TECHNICAL SKILLS:

Programming Languages

SQL, PL/SQL, Python, HTML

Databases

SQL Server, MySQL, Hadoop, Redshift, Oracle 11g/10g/9i, MS SQL server 2019, TERADATA.

Reporting Tools

Tableau, Power BI, Cognos, Tableau Suite of Tools2019.3/2018.3/10.5

Operating system

Windows XP, Windows OS, Mac OS

ETL Tools

Informatica, Alteryx

Data Modeling

Logical Modeling, Physical Modeling, Relational and Dimensional Modeling, ER Diagram, UML, and XML Schemas

Tools

MS Office, PowerPoint, MySQL Workbench Desktop, Server, Reader, Online and Public and Administration of Tableau Server,Hadoop, Informatica Power Center 9.1, Oracle Database Management Studio, Oracle Express 11g/12c, PostgreSQL

Data Analytic Libraries

Pandas, NumPy, Matplotlib, Seaborn

Methodologies

Agile, Waterfall, SCRUM, SDLC

PROFESSIONAL EXPERIENCE:

Tableau Developer

Fannie Mae Washington, DC Jun 2022 — Present

Project Description: The Project was involved in development of strategic reporting and integrated source of data for Fannie Mae’s lines of business and support function, this infrastructure will be flexible and extensible framework that integrates data from multiple sources like security, party and common securitization platform and servicing, utilizes enterprise services and vend data to support business need.

Roles & Responsibilities:

Created data visualization worksheets and dashboards in Tableau, as per the customer requirements.

Worked on Tableau Reports for higher data visualization.

Involved in combining all the data sources into one and building Tableau dashboards based on the requirements of the users.

Design and create innovative and valuable visualizations in Tableau to track KPIs, metrics, and other key data points.

Applying Denodo, integrated financial data from numerous sources including accounting, CRM, and ERP systems to build financial dashboards using Tableau to gain insights into income, expenses, budgets, and financial trends.

Used different Data Migration Services and Schema Conversion Tools along with ETL tools.

Used different custom housekeeping utilities and monitoring services to have the cluster running efficiently.

Extracted and processed data stored in Cloudera Hadoop, including HDFS, HBase, and other Hadoop components.

Experience coding and modifying SQL/ETL/Alteryx based on dashboard requirements in Tableau Designing and developing data sources, and dashboards in Tableau.

Implemented different functionalities using Tableau like Dual Axis, Actions, Filters, Calculated fields, parameters etc.

Involved in server-based Tableau workbooks (twb), packaged workbooks (twbx) and dashboards.

Worked with end users to explain Tableau workbooks.

Created data visualization worksheets and dashboards in Tableau per customer requirements.

Work cross-functionally in order to proactively and systematically identify and implement any enhancements to reporting and analytics processes.

Work closely with Data and Business Analyst peers to define and produce KPI definitions, data specifications, and delivery documentation.

Performed migration of Tableau data source from SQL Server to Amazon Redshift.

Oversee analytical team in the identification, extraction, aggregation, and quality assurance of data from multiple sources in support of performing operational reporting and quantitative analysis.

Report parameters included single-valued parameters and multi-value parameters which also consisted of different parameter types like hidden, internal, and default (queried and non-queried parameters).

Increase automation and data quality in reporting analytics output.

Worked on Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping, Crystal Report Design.

Designed reports using pivot tables, bar-charts, Line-charts, and Pie-charts on data from cubes and Oracle in Excel 2007.

Created complex Stored Procedures, Triggers, Cursors, Tables, and other SQL Joins and Statements for Applications by using SQL.

Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes.

Involved in Performance Tuning of Stored Procedures which included Creating Indexes, Work Around for Expensive Operators, and implementation of various coding standards (Index hints, Locking hints) etc.

Designed and created Report templates, bar graphs, and pie charts.

Used JIRA as a Change Management/Work Management/SCRUM tool.

Suggesting new Viz based on data and analysis.

Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Scatter Plots, Geographic Map, Histograms, Dual Axis charts with custom images, Cross tabs for detail views, and Line graphs.

Improving data processing speed by optimizing SQL and Tableau viz.

Experience and exposure to Data Warehousing and Big Data Ecosystems.

Participate in visioning sessions and design reviews to develop wireframes.

Support ad-hoc requests for visualization and dashboards.

Expert in the reconciliation of Data Movement between Source vs. Datamart & Business Objects reports

Extensively involved in data replication through Informatica data replication (IDR)from Oracle to data warehouse.

Reviewed business/system requirements change requests and design specifications to identify gaps and ensure requirements/business rules were clear and consistent.

Experience in Creating Tableau calculations, table calculations, LOD calculations, blending, actions, time period functions, and parameters based on requirements.

Documented various business requirements, and deployment plans and prepared various user guides to facilitate the users to learn and adapt to the new systems.

Designed and created various analytical reports like Performance Dashboards and Metrics to help users identify critical KPIs and facilitate strategic planning in all functional areas including Order Management, Finance and Planning, Process Management, Sales/ Marketing, and Resource Management.

Environment: Tableau 2018, 2019, Tableau Server, Oracle, Tableau, Windows, SQL, MS Excel, JIRA, MYSQL, DDL, DML, Amazon Redshift, Excel, Dashboards, Agile Methodology, Crystal Reports, Business Objectives 4.1, Oracle 10g, SQL T-SQL, Unix Shell scripting, python.

Tableau Developer

McKesson Woodlands, TX DEC 2021 — MAY 2022

Project Description: The project was mainly focused on measuring and reporting the efficiency of the contact center sales channel, it involved analysis of the sales funnel, cross-selling of TV products, customer acquisition rate, resolution turnaround time, etc.,

Roles & Responsibilities:

Creating reports using Tableau for customized and ad-hoc Queries.

Developed Tableau workbooks from multiple data sources using Data Blending.

Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.

Mastered the ability to design and deploy rich Graphic visualizations with the Drill Down menu option and Parameterized using Tableau.

Extensive knowledge in various reporting objects like Hierarchies, Filters, calculated fields, Sets, group parameters etc., in Tableau.

Collected HR data from a variety of systems, including payroll, HRIS, and performance management platforms using Denodo, and created dashboards for monitoring employee performance, HR metrics, and workforce analytics using Tableau.

Generated Tableau combination charts using Tableau visualization software.

Manage and convert large amounts of data into business decision-making tools.

Created different views using Tableau Desktop and Combined visualizations into Interactive Tableau Dashboards publishing them to a web portal.

Managed real time data streaming from Cloudera Hadoop to Tableau, enabling users to access the most up-to-date information.

Performed migration of Tableau data source from Excel to Google Big Query.

Developed Storytelling dashboards using Tableau desktop and published them to BI server that allowed users to understand the current data.

Ability to work in a dynamic and fast-paced environment with tight time frames.

Provide analysis to senior management and sales team to develop strategic plans and interpret the strategic plans into the annual budgeting file.

Developed dashboard reports using Reporting Services, Report Model, and ad-hoc reporting using Report Builder.

Developed SQL queries, triggers, functions, and cursors.

Involved in sprints and planned releases with the team using JIRA.

Designed and developed reports such as Drill down, and Drill through using Microsoft Reporting Services (SSRS).

Developed Proof of concept to showcase and measure the efficiency of the proposed solution.

Development of a dashboard in Tableau for data visualization to expedite the data analysis process and report automation.

Design, configure, and document Tableau Data Source and Extract

Built the Data Visualizations using Charts, Drilldowns, and Quick Filters.

Involved in writing SQL queries using Teradata and Oracle 10g.

Create views in Tableau Desktop that are published to the internal team for review and further data analysis and customization using filters and actions.

Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.

Created customized reports using various chart types like text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, and combination charts in Excel and SSRS.

Improved performance of the dashboard at the report level, by reducing the scope of the visualization with respect to sheet and data sources, reducing the number of filters in the view, and creating efficient calculations.

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Experience in designing various Data Visualization Dashboards, gathering customer requirements, writing test cases, preparing analytical reports to help users identify critical KPIs, and partnering with developers to ensure full understanding of internal/external customer needs.

Used Python integration in tableau using Script_ bool, Script_ Int, Script_eal, and Script string and performed Statistical/predictive analysis.

Built complex formulas and logical conditions in Tableau for various business calculations. Performance tuning of the Reports

Created Query Prompts, value prompts, Date & time prompts, Text box prompts and cascading prompts, Calculations, Conditions, and Filters in the reports.

Used style, render, and conditional variables to reports to achieve the design specifications.

Used Actions extensively to link and filter sheets for easier navigation in Dashboards Creating dashboards with multiple lists, charts, and other data containers in Tableau as per Business requirements.

Developed Tableau workbooks to perform year-over-year, quarter-over-quarter, YTD, QTD, and MTD types of analysis.

Implemented LODs for various calculation needs.

Environment: Tableau Server 8.1/8.2, Tableau Desktop 8.1/8.2, Oracle, Windows, Microsoft Office, SQL, SQL Developer, SQL*Loader, TOAD, JIRA, Windows Server Standard R2, Excel, MSBI (SSAS, SSRS, SSIS), MS SQL Server 2008R2.

Tableau Developer

ThinkSoft Technologies India APR 2018 — AUG 2021

Project Description: The main objective of the project was to collect and consolidate the primary and secondary sales data from various countries within the Asia Pacific region. Worked as Tableau developer and ETL support analyst for the Consumer Healthcare business area.

Roles & Responsibilities:

Worked with Business to understand the new requirements.

Analyzed the existing RPD model as part of fit gap analysis, to accommodate the new business requirements.

Define and implement routine reports (daily/weekly/monthly) of key performance metrics and action item alerts as well as on an ad hoc basis to drive results.

Created Tableau workbooks for weekly reporting by establishing connections to various data sources.

Expertise in building custom charts and visualizations and complex calculations using Tableau.

Design, develop, and maintain Tableau reports and dashboards that present complex data in a clear and visually appealing manner.

Created interactive filters, calculated fields, LODs, table calculations, types of action filters, and parameters for preparing dashboards and worksheets in Tableau and Extracted, transformed, and loaded data utilizing SQL.

Created dimensional hierarchies for data at different granular levels as per the business requirements.

Worked on Configuring Tableau Security parameters at object level, and data level to control access to customer data.

Created new reports and modified existing reports with different views and Action links at various levels for drill across capability.

Experienced in migration Tableau data sources from On-Premises Oracle to Snowflake.

Created Sales Dashboards for Business users belonging to various regions.

Interacted with end users and developers to validate the data model, reports, and dashboards.

Involved in Unit testing, Integration testing, and User Acceptance testing to check whether the data was loading into the target, which was extracted from different source systems according to the user requirements.

Responsible for developing, supporting, and maintenance for ETL processes using Snowflake.

Used Snowflake clone and time travel features with Snowflake multi-cluster warehouses.

Hands-on using snowflake utilities, Snow SQL, Snow Pipe, and Snow Pro techniques.

Developed ETL pipelines in & out of the data warehouse using Snowflakes Snow SQL writing SQL queries against Snowflake.

Used Tableau API such as Python, and Web Data Connector, and Performed Predictive Analysis.

Built reporting against Single Tables, Multiple Tables, and Complex Custom SQL.

Worked on building multiple layouts like Bar charts, Donut charts, Trend charts, stacked bars, Pie Charts, Funnel Charts, Bar within bar charts etc.

Created Tableau scorecards, and dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, and Gantt charts demonstrating key information for decision-making.

Created calculations using Fixed, Include, and Exclude LODs to perform aggregations on different levels.

Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.

Created extensive joins for data blending from several different data sources.

Environment: Tableau 9.0, Tableau 10.2, SQL, DDL, Data Analysis, Oracle 12c, Tableau Server, Informatica, Excel, Oracle 11g/12c, MS SQL Server 2008, IBM DataStage 11.3, OLAP, OLTP, Business Objects, Oracle, Data Studio, Windows.

Tableau/OBIEE Developer

Hypersoft Tech India JUN 2015 — MAR 2018

Project Description: This project was involved in the development of strategic reporting, creating an interactive dashboard, and visualization of data solutions to support various business operations utilizing Tableau Software and SQL.

Roles & Responsibilities:

Participated in User Meetings to understand the requirements.

Worked with subject matter experts and project team to identify, define, collate, document, and communicate the data migration requirements.

Provided line listings as per business requirements using SQL and PL/SQL.

Responsible for writing complex SQL queries and developing the in-house application's back-end programs in PL/SQL.

Built the OBIEE repository/metadata (rpd) (Physical Layer, Business Model, and Mapping Layer and Presentation Layer) and created the subject area where reporting and analysis are centered around.

Developed User documents for internal analysis using BI Publisher.

Scheduled bursting of the reports to e-mail or file location based on the business necessity using BI Publisher.

Created various views in Tableau (Treemaps, Heat Maps, Scatter plots)

Created and optimized data visualizations, including charts, graphs, tables, and maps, to convey insights and trends.

Built visualizations in Tableau to show how ratings changed and how the model performed over time.

Utilized techniques and business intelligence (Tableau) to create dashboards and ad hoc reports to address business problems and streamline processes.

Utilize SQL to gather data perform an in-depth analysis of department records and create impactful dashboards in Tableau.

Prepare Dashboards using calculations, and parameters in Tableau.

Responsible for Developing a Dashboard and preparing ad hoc Reporting.

Extensively involved in doing user acceptance testing (UAT).

Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain formats as required in Excel and created SSIS packages to load Excel sheets from PC to database.

Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.

Responsible for the development and maintenance of SAS Information Maps for Analytics and Business forecasting Team

Imported raw data files in Excel format in SAS and subsequently created SAS datasets and performed data cleaning and data manipulations for further analysis and reporting.

Designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS) and Reporting Services (SSRS).

Good understanding of SSRS with Report authoring, created daily, weekly, and monthly reports as per requirement using SSRS.

Created SSIS Packages for loading mappings into Tables and deployed them.

Environment: OBIEE 10.1.3.4, Tableau, Oracle, PL/SQL, Windows Server 2003, Tableau Desktop 2018.1, 2018.3, Tableau Prep 2018.1, 2018.3, Salesforce, SAS/Base, SAS/BI Platform, IBM Cognos, Oracle JD Edwards, Microsoft Excel.

Contact this candidate