Data Project

Vijay E mail:

M i **@***********.***

Sr. Tableau Developer P hone: 847-***-****

SUMMARY

• Over 8 years of IT experience which includes analysis, design, development, implementation,

deployment and maintenance of Business Intelligence, Data Warehouses and Data Mining

applicationsin Financial, Healthcare, Utility, and Manufacturing industries.

• Proficient in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau

8.2 8.1,8.0, Tableau 7 and Tableau 6.

• A highly motivated and excellent team player with technical expertise in software engineering

processes and outstanding knowledge on life cycle of the software design process (SDLC).

• Extensive knowledge of all phases of the Software development life cycle (SDLC), Agile, Scrum and

the iterative Rational Unified Process (RUP).

• Experience in gathering and writing detailed business requirement and translating them into

technical specifications/ System Requirement Specifications (SRS) and designidentifying

interface and business process specifications.

• Extensive Experience working with business users/SMEs as well as senior management.

• Outstanding knowledge in relational Data modeling, Dimensional data modeling, logical/Physical

Design, ER Diagrams, forward and reverse engineering, Publishing ERWIN diagram, analysing data

sources, creating interface documents etc.

• Strong understanding of the principles of Data warehousing using Fact Tables, Dimension Tables,

Star Schema and Snowflake Schema modeling.

• Expertise in Teradata, Oracle, SQL Server, Informatica, SSIS, SSRS, UNIX, Toad, Microsoft

Office Suite.

• Outstanding knowledge in writing complex SQL queries, Stored Procedures, database tuning, query

optimization and resolving key performance issues.

• Extensive experience in using Tableau functionalities for creating different Reports, Interactive

Dashboards with page and dashboard Prompts.

• 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.

• Expertise in designing and creating various analytical reports and Dashboards to help users to

identify critical KPIs and facilitate strategic planning in the organization.

• Expert in Unit System and User Acceptance Testing and Performed Data Validation for all the

reports and dashboards generated from various database sources.

• 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.

• Good working knowledge of Meta-data management in consolidating metadata from disparate tools

and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a

single repository to get information on data usage and end-to-end change impact analysis.

• Experience in writing complex SQL scripts/ queries to perform End-to-End ETL validations and

support Ad-hoc business requests.

• Strong influence management skills, reporting and analytical/problem solving skills with attention to

detail.

• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven

Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

Technical Skills:

Reporting Tools Tableau8.2 8.1 8.0, Business Objects 5.x/4.1, Crystal Reports, Cognos

ETL Tools IBM Info sphere DataStage, Informatica, Microsoft SQL Server

Integrated Services

Databases Teradata, Oracle 118i/9i, DB2 UDB, MS-SQL Server, Sybase

Requirements Management Requisite Pro, Microsoft Office (Word, PowerPoint Excel)

Front End Tools Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes

Document Management Documentum,Visual Source Safe 6.0, Share point, Ultra Edit

Defect Management tool HP Quality Center

Methodologies Data Modeling – Logical/Physical/Dimensional, Star/Snow flake

Schema, ETL, OLAP, Complete Software Development Lifecycle,

CMMI Compliance, Waterfall,

Agile, Iterative

Data Modeling Tools Power Designer, ERwin, ER Studio, MS Visio

Languages C, C++, C#,.NET, SQL, PL/SQL and Java

Operating System Windows NT/2000, UNIX (HP UX, Solaris 2.7/8, AIX), AS/400, OS/390.

Web Applications HTML, Perl, XML and JavaScript

Scheduling Tools Control M, Autosys, ESP Scheduler

Professional Experience:

Motorola, Chicago, IL November ’14 - March ’15

Sr. Tableau Developer

Motorola Solutions is one of the leading mobile manufacturers in the global market. Created production

and sales reports for the sales and dashboards for the risk assessment team.

Responsibilities:

• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a

better understanding of the Business Processes.

• Prepared project reports for management and assisted the project manager in the development of

weekly and monthly status reports, policies and procedures.

• Creating and modifying Business Intelligence analytical reports using Tableau.

• Responsible for creating Metrics, Filters, Calculated fields, parameters using Tableau Desktop.

• Used geographic view which clearly gives the performance of a particular state.

• Developed customized calculations when required.

• Worked on drill through reports by creating HTML references.

• Extensively used Tableau Web to enable users to run-predefined sales and inventory reports for

building their own customized reports.

• Created various actions in database like filter actions to send information to other tableau worksheets

and to connect the same in analytical flows, URL actions to connect views of data to external

resources and Highlight action to provide rich visual interaction between the views on the sheet.

• Designed business intelligence dashboard using Tableau Desktop and publishing the same on

Tableau server, allowing executive management to view current and past performance sales trends,

forecast sales, and to track existing customer sales.

• Created Unit Test Cases and documented the Unit Test Results.

• Conducting the Unit testing of the module to identify the bugs.

• Bug fixes during unit testing and system testing.

• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data

Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8

desktop/Server.

• Worked on Performance tuning of report with huge queries using concurrent query execution for

better performance of report.

• Responsible for daily communications to management and internal organizations regarding status of

all assigned projects and tasks.

• Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics,

implement verification procedures, and fulfil client requests for information.

• Actively tracking schedule, clear and crisp communications with key resources, stake holders and

SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding

scope creep issues.

Wellington Management, Boston, MA February ’13 - October ’14

Sr. Tableau Developer

Wellington management is a private investment management company which acts as investment

advisors for clients from more than 50 countries around the world. Created Reports and Dashboards for

Liquidity Coverage Ratio and Risk-Weighted Assets using Tableau.

Responsibilities:

• Gathered requirements from end users, involved in modifying various technical & functional

specifications

• Designed and Developed various analytical reports from multiple data sources by blending data on a

single worksheet in Tableau Desktop

• Utilized advance features of Tableau software like to link data from different connections together on

one dashboard and to filter data in multiple views at once.

• Involved in new KPI generation for Scorecards.

• Installed and upgraded of Tableau server and server performance tuning for optimization.

• 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.

• Defined best practices for Tableau report development.

• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets

for Tableau server logons and security checks.

• Data collection and leveraging on data manipulation teams for required data.

• Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau

reporting.

• Identify new metrics and enhance the existing KPI's.

• Preparing Dashboards using calculations, parameters in Tableau.

• Understanding of relational database structures, theories, principles, and practices.

• The ability to interact professionally with a diverse group, including executives, managers, and LOB.

• Working on generating various dashboards in Tableau server using various sources such as

Teradata.

• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the

same time maintaining the accuracy of the core information content that is being communicated

• Involved in license management SLA’s with Tableau support.

• Defined and created procedures to install Tableau desktop in silent mode.

• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of

Tableau repository.

• Published developed dashboard, reports on the Tableau Server so that the end users having access

to the server can view the data.

• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to

server.

• Proof-read all documents and maintain accuracy of information and preparing SOP.

• Responsible for Developing a Dashboard and preparing ad-Hock Reporting.

Environment: Tableau Desktop 8.1-8.2, Tableau server / Administrator, SQL developer, SQL 2008,

Oracle 10g, PL/SQL, T-SQL Microsoft Excel 2007,MS Access, Windows 2007 server, java 1.5 platform,

Teradata, Microsoft office 2007, Business objects 4.0.

University Hospitals, Cleveland, OH July ’11 – January ’13

Tableau Developer/ Data Analyst

University Hospitals of Cleveland is a major not-for-profit medical center in Cleveland, Ohio, United

States. It has presence 150 locations throughout northeast Ohio, it includes a network of hospitals,

outpatient centers and primary care physicians. University Hospitals Case Medical Center is home to

world-class clinical and research centers, including cancer, pediatrics, women's health, orthopedics,

spine, radiology, radiation oncology, neurosurgery neuroscience, cardiology, cardiovascular surgery,

organ transplantation, and human genetics. Implemented Tableau Desktop and server, created

Dashboards for various departments so that they can delve in to larger datasets and resolve the problems

quickly.

Responsibilities:

• Interacted with business user group for domain requirements gathering.

• Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.

• Involved in defining the whole project life cycle, following agile methodology. Analyse business

requirements and segregated them into high level and low level

• Develop, Organize, manage and maintain graphs, tables, slides and document templates for the

efficient creation of reports.

• Interact professionally with diverse group of professionals in the organization including managers and

executives.

• Developed Standard Operating Procedures (SOP) for Monitoring.

• Extensively used data blending, embed functionalities in Tableau.

• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau

server. Creating New Schedule's and checking the task's daily on the server.

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical

maps, Gantt charts using show me functionality.

• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images,

Maps.

• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report

and Dashboard using KPI's.

• Gathered user requirements, analysed and designed software solution based on the requirements.

• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design

process for various Sources and Targets.

• Defined best practices for Tableau report development and effectively used data blending feature in

tableau.

• Create, customize & share interactive web dashboards in minutes with simple drag & drop method

and access dashboards from any browser or tablet.

• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.

• Creating users, groups, projects, Data connections, settings as a tableau administrator.

• Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity,

and customized views on Server Analysis.

• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL

to provide definition, structure and to maintain data efficiently.

• Good SQL reporting skills with the ability to create SQL views and write SQL queries highly

recommended.

Environment: Tableau Desktop/Server 6.x-7.x, SQL Server 2008, HPQC, Oracle 11g, Business objects,

SQL, PL/SQL, T-SQL, Microsoft office 2007.

Fujitsu, Schaumburg, IL July ’09 – June’11

Business Systems Analyst/ Data Analyst

Fujitsu (America), Inc. is a leading provider for IT products and services to the customers with high quality

electronic products in areas like Information technology and Information & telecommunication systems,

Power and Electronic and Automotive Components and Devices and Digital Media consumer products.

The Project is to implement Reporting Models, Cubes and Reports to cater various business needs.

Responsibilities:

• Requirement gathering for various users, interviewing them, and satisfying their exact needs.

• Involved in the complete Life cycle of the Project and in the data analysis process

• Gather the various requirement matrices from the business analysts.

• Worked with Master Data Management.

• Assisted the DBA in converting the logical models to physical.

• Conduct Design discussions and meetings to come out with the appropriate Data Mart using

Kimball Methodology.

• Designs for the various reporting requirements.

• Conduct Design reviews with the business analysts, content developers and DBAs to ensure the

feasibility of the designs.

• Used Erwin for developing data model and forward engineer the data model.

• Reverse engineer the data base in to physical data model by using Erwin.

• Developed entities and relationships using Sybase Power Designer.

• Developed Data Migration and cleansing rules for the integration architecture.

• Developed data mapping documents between legacy, production and user interface systems.

• Designed different type of STAR schemas like detailed data marts, Plan data marts,

• Used Erwin for monthly summary data marts and inventory data marts.

• Designed ER Diagrams, star schema and snow flake schema.

• Importing source definitions. Creating and importing target definitions. Creating the table targets.

• Created and modified of Attributes, Facts, Metrics, Filters and other report objects.

• Conducted data validation testing to ensure data quality.

• Active Participation in checking the data at database level and at SSRS level in case of displaying

wrong data.

• Tested all the business application rules with test & live data and automated.

• Involved in testing and fixing bugs on test and On-line data.

• Worked with the Implementation team to ensure a smooth transition from the design to the

implementation phase.

Environment:Informatica, Cognos, Power Designer, PL/SQL, Oracle9i, TOAD, UML, Microsoft Office

Suite ( Word, Excel, Power Point, Visio).

E dison Energy, I rvine, California Nov ’08 – June ’09

ETL - Data Warehouse Developer/ Data Analyst

Edison energy provides products and services in electric goods marketand provides customers with a

range of energy services including power management and electric transportation. The company hosts a

very large database system and other operational databases. A central data repository is setup to

capture metadata about many internal operational information sources.

Responsibilities

• Worked on the project that involved development and implementation of a data warehouse.

• Interacted with business users and performed Gap Analysis of Client requirements

• Elicit business solutions to develop SOX compliance into the existing procurement workflow

executed through IT channels.

• Performed Analysis of Reference Data, Data sets and Asset classes in order to bring data into the

central repository.

• Worked extensively with MS Visio and Rational tools to document requirements.

• Created the AS-IS and TO-BE process flow diagrams.

• Defined the scope of the project based on the gathered business requirements including

documentation of constraints, assumptions, business impacts, project risks and scope exclusions

• Defined functional business requirements, analyzed client requirements, and generated workflow

processes

• Prepared Business Requirement Document and then converted business requirements into

Functional Requirements Specification.

• Assisted in project management activities like planning, development, task allocation, project

execution

• Provided full project life cycle flowcharting, analysis and documentation.

• Responsible for extracting, transforming, and loading data from oracle, flat files and placing it into

data warehouse.

• Designed, developed, and tested the Jobs, Job Sequences using DataStage 8.1

• Involved in the some part of performance tuning.

• Developed simple and complex mappings using Informatica to load dimensions and fact tables as

per STAR schema techniques.

• Defined project milestones, schedules, monitoring progress and updating plans using MS Project

• Prepared monthly status reports for Enhancement Requests to the project team that was used in

efficient tracking and monitoring of open issues of the project.

Environment:Oracle, Teradata, Toad, DataStage 8.1, Cognos, Autosys, UNIX, Microsoft (Word, Access,

Excel, Outlook), RUP Methodology, MS VISIO, MS Project.

Mediamint, Hyderabad, India June ’07 – Oct’08

ETL/Data Warehouse Tester

Mediamint is the leading supplier of automated enterprise software testing solutions delivered by an

expert team of software test professionals backed by a service framework.Mediamint solutions are

composed of proven processes and a combination of best-of-breed test tools from commercially available

providers and when necessary Mediamint in-house developed tools and solutions.

Responsibilities

• Worked on the project that involved testing and implementation of a data warehouse.

• Responsible for testing process of extracting, transforming, and loading data from oracle, flat files

and placing it into data warehouse.

• Analysed and tested the mappings, using Informatica 7.1

• Interacted with management to gather sources and their requirements

• Involved in the some part of performance tuning.

• Tested simple and complex mappings using Informatica to load dimensions and fact tables as per

STAR schema techniques.

Environment: Informatica PowerCenter 6.x/7.1, BO 6.5,Microsoft Visio, Oracle 9i.

Contact this candidate