SANJEEV SINHA

Email: adk9d8@r.postjobfree.com /adk9d8@r.postjobfree.com

Contact Number: 630-***-****/630-***-****

TECHNICAL SKILLS

Technologies

Tableau (8.0 / 9.1/9.3,10.1,10.2,10.3, 10.5, 2018.1,2018.3, 2019.1, 2019.2,2020.2,), Cognos 8 and 10.1, 10.2, Informatica, Active reports, Framework Manager Report Studio, Dynamic Cue, Query Studio, Event Studio, Transformer, QTP, Quality Center, Informatica IDS, OBIEE 11g,Python

Database

SQL, Oracle, Teradata

Client Side Internet Components

VB Scripting, C, SQL, PLSQL, Oracle Forms and Report

Operating Systems

Windows 9x/2000/XP

CORE COMPETENCIES

Data Warehouse Implementation

BI/ETL Solutions Design & Delivery

Report & Dashboard Creation

IT Project Coordination & Development

Analysis, Testing, & Defect Fixing

Database Management

Requirement Gathering &

Modeling & Scripting

Coordination & Liaison

EDUCATION

PGDM in Financial Management from Institute of Management & Technology, India.

Bachelor of Commerce, India

Others: Diploma in Software Management

IBM CERTIFIED BI AUTHOR (COG-112)

PROFESSIONAL EXPERIENCE

FedEx

December 2019 – Present Tableau Developer/Analyst

Understand the Requirements and Functionality of the application from specifications.

Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

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

Created different KPI using calculated key figures and parameters

Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.

Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.

Created joins, and unions and did pivot for database tables as per the requirement in Tableau Prep builder

Scheduled Automatic refresh and scheduling refresh in Tableau.

Participate in planning of daily activities with the team members.

Validated data at the row level and the data level to ensure completeness and correctness of the data.

Worked closely with reporting team for deploying Tableau reports and publishing them on the tableau and SharePoint server.

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

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

Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

Utilized Tableau server to publish and share the reports with the business users.

Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.

Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets

Created custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the reports.

Scheduled extract refresh for weekly and monthly reports.

Worked on workbook Permissions, Ownerships and User filters.

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Caterpillar Inc. BI Developer

July 2019 – November 2020

Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

Created extracts and published data sources on tableau Server for the users from various databases in Green Plum. Used complex joins and validated them by running and tuning long SQL queries.

Processed the spend and goals data in Alteryx in such a way that it is suitable for reporting

Provided training to end-business users on Power BI, enabling them to create reports and dashboards.

Having good knowledge on row level security by using User functions and user filters

Developed Detailed cross reports for business as per ad-hoc requests.

Worked with Business manager to gather requirements and translate them into Technical Documents.

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

Worked on Tableau Command line tools tabadmin for Configuration settings in tableau Server and tabcmd for users, groups creation.

Effectively involved in the maintenance of Data Server, metadata management, creating shared Data sources and publishing them to Tableau Server.

Create action filters, parameters and calculations for preparing dashboards and worksheets in Tableau

Continuous monitoring of tableau server for user availability and refreshes schedule.

Created custom admin views for monitoring the usage of server and users in addition to pre-built administrative

views available on maintenance page.

Involved in supporting performance-testing team in testing the performance of tableau servers and workbooks.

Extensively used data blending techniques in dashboard development.

Supported different user group and business domains.

Providing tableau Demo's to new on boarding users.

Defined architecture for Tableau- establish Dev/QA/Prod mount environments

Setup new projects, security groups, roles and administer users for all supported platforms.

Migrate the Data sources from QA To Production server.

Migrate the workbooks and dashboards from QA To Production server.

Add or update the Batch file for data sources refreshes.

Replace data sources from old data source to latest data sources,

Replace the work books from QA server to Production.

Providing Tableau Demo's to new on boarding users.

Maintain the data source auto schedules process on Tableau web server.

Involved in Production support for Business users.

Designed and developed ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Lookups, Aggregator, Mapplets, connected and unconnected stored procedures / functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were extensively done.

Developed U-SQL scripts for processing massive amounts of data in a very familiar environment which is mainly used for AZURE DATA LAKE ANALYTICS.

Worked on creating Azure Data Factory for moving and transforming the data.

Worked with Azure Data Lake Store to capture data of any size, type, and ingestion speed in one single place for different operations

Illinois State University BI Developer

March2015 - June 2019

Developed Reports – Package and Premium Migration by Daily, Monthly and Quarterly. Free View Customer Usage Report. Funnel Report with Details of active and inactive streamers.

Channels viewed Prime Time, Weekly, Monthly and Quarterly. View stats on the seasonal sport channels.

Worked on multiple Data Sources including Tableau Server, MySQL, SQLServer (ETL Tables), Excel to get the data needed for the dashboards.

Handled the Data Transformation using SQL for the reporting purposes.

Created Rich dashboards using Tableau Desktop and prepared user stories to create compelling dashboards to deliver actionable insights.

Built dashboards for measures with forecast, trend line and reference lines.

Involved in Design/Lead/Develop Prototypes for business solutions (dimensional models, model builds) so that business users may visually understand and explore a new feature or functionality before implementation to expose design assumptions and drive ideation. Ensured prototypes meet the organization standards to allow transfer to production.

Developed compelling, Interactive Dashboards using different features like Filters, Parameter, Actions, Calculations (using logical, String, Table, Aggregate functions) and formatting the reports/dashboards (Layout Containers, Annotations, Mark Labels etc.,)

Trained and supporting Business Users on Tableau’s self-service model for creating their own dashboards and Publishing/Accessing them from Tableau online.

Responsible for interaction with business stake holders, gathering requirements and KPI’s and managing the delivery in Timely manner.

Responsible for Understanding Business Requirement and providing solutions by analyzing different data sets within the organization.

Created data sets as per the requirements in Tableau Prep builder

Generated context filters and data source filters while handling huge volume of data.

Generated Test Cases for each specification in Requirement Specification Document corresponding to dashboard visualization.

Created Test Scripts, Test hierarchy to represent the features and functionality that need to be test in the Dash Board.

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

Expert in Tableau server administration.

Performed administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance.

Having good knowledge on row level security by using User functions and user filters

Scheduling of Data Extracts, and the Performance Monitoring of servers and advice business accordingly

Add users, Create/Manage Groups, Workbooks and Projects, Database Views, Data Sources and Data Connections

Add/Edit Sites and corresponding administration rights (System vs. Content)

Create/Modify/Manage server task schedules

Monitor server activity/usage statistics to identify possible performance issues/enhancements

Run cleanup and create backups of the database

Upgrade server software

Enforce policies; assist users with workflows

Work with program manager as necessary regarding issues such as server down-time, versioning

Provide Tableau support to users.

Involved in the migration of Cognos environment from Cognos 10.2.2 to Cognos Analytics11.

Customized Cognos Connection according to company's specifications.

Developed Framework manager model to suit the reporting requirements.

IBM Cognos Developer March 2011 – December 2014

Creating Sales Pipeline Report for different Brands of IBM for the Higher Management of Europe and North America for different Sales Stages and different Quarters as per the requirements.

Work with sales operations teams to analyze pipeline and revenue trends.

Manage a team that collates data sets and arrange the data for reporting in COGNOS and driving efficiency through automation.

Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases. Used filters for efficient data retrieval.

Ensure strong linkages and partnerships with external and internal (e.g., IOTs/IMTs/GMU/GMTs and BUs) Stake Holders

Analyzing pre-exits reports and solving the existing issues within it

Maintenance and Schedule management for the daily email reports.

Creating Sales dashboards provided drill though capability for more analysis.

Creation of Power Play models and cubes Using Power play Transformer and Testing the report by comparing data with Cube data by using powerplay web explorer and the validity of the data it retrieves from the database.

Migrating Powerplay Client HTML reports that are tabular and pivot oriented and convert them to pictorial/dashboard-oriented reports for executive management sales.

Extensively worked on Dashboards using report studio including render variables, master-detail relationships, singletons, prompts, filters, Conditional variables, HTML items, layout component reference and formatting the objects within report design.

Experience with conditional blocks and conditional layouts.

Creating Dashboard Reports from cube using Report studio MDX Functions and adding it to the portal page using HTML Items.

Modifying the existing report based upon the change request by the user.

Project Details:

DHL, Deerfield Cognos Developer

February 2014 To December 2014

Responsibilities:

Participated in the workshops for gathering requirements.

Analyzed the impact on the reports due to the changes in the Source systems.

Involved in the Design discussions of the Mappings for data loading using Informatica

Modified the Framework Manger Models to incorporate the new data elements.

Designed and developed the reports as per the requirements in Cognos

Developed Power Play Cubes for better analysis of the data.

Lab Corp, Burlington Cognos Developer

June 2012 To February 2014

Responsibilities:

Created new relationships, calculations and modified existing relationships in Framework model so as to meet new report requirements.

Developed List, Crosstab, Charts, Drill through Reports and Master Detail Reports to deliver solution-oriented complex reports using Cognos Report Studio

Modified existing reports to improve the performance and also implemented additional new requirements

Deloitte India Report Specialist

October 2005-February 2011

Worked on Project A/R, Cash and other resolution-oriented reporting to the client directly

Worked on RFP (Requisition for Proposal) whenever a new project proposal is put forth by a Deloitte director

Providing FTE requirements for a start-up project, setting up the database for initial kick off and go live of any healthcare client

Representing the analyzed data in Excel or on PPT representation.

Extensive experience in Cognos8 BI including Framework manager, Report studio, Query Studio, Analysis studio.

Involved in the Dimensional modeling in the Framework manager.

Major areas of expertise in designing and developing, creating and modifying different reports like List, Crosstaband Chart reports using Report studio, Ad-hoc reports using Query studio and Analysis studio.

Worked on different types of reports like Cross tab, Master/Detail, Drill through reports Created Advanced Prompts.

Experienced with Complete application development life-cycle including requirements gathering, analysis and design, implementing and testing.

Contact this candidate