Resume

Sign in

Data Microsoft Office

Location:
Marysville, Ohio, 43040, United States
Posted:
October 24, 2016

Contact this candidate

Nawaz Sharief

Sr. Tableau Developer/Sr. Data Analyst

acw7h5@r.postjobfree.com

(630)-***-****

SUMMARY

A Certified Tableau Developer having 8+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms in Retail, Money transfer & Payment services, Banking, Health Care, and Pharmaceutical industries.

Proficient in Tableau 9.x/8.x/7.x/6.x (Desktop, Server), Cognos, MicroStrategy 9.x/8.x (Desktop, Intelligence Server, Narrowcast Server) and SSRS.

Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.

Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups.

In depth understanding of the As-Is and To-Be (Gap Analysis) business processes and experience in converting these requirements into Technical Specifications for preparing Test Plans.

Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM)which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.

Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.

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

Expertise in using Tableau Filter, URL and Highlight actions to switch between sheets and navigate to external or internal websites

Expert in visualizing the data, reporting and analyzing, creating the dashboards and reports in an intelligible pictorial representing like bars, geographic maps, bubbles, pies, lines and etc.

Proficient in creating Tableau scorecards, dashboards using advance Tableau functions like Calculated fields, Sets, bins, Groups, Parameters, Actions, Level of Detail (LOD), Adhoc Calculations, etc.

Experience in creating various filters like quick filters, data source filters, global filters, context filters and user filters in Tableau.

Good experience in creating users, groups, sites, row level security and monitoring server activities in Tableau Server.

Hands on experience with IBM Cognos 8.4 Report Studio, Query Studio, Analysis Studio, Framework Manager and Power Play Transformer.

Worked extensively with the major functionality of SSRS ad-hoc reports, Drill down reports, multi-parameterized reports and drill through reports.

Posses’ strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.

Expertise in analysis, design and implementation of data warehousing applications using Teradata, InformaticaUNIX, DB2, Oracle and SQL Server technologies.

Proficient in developing Entity-Relationship diagrams, Dimensional Modeling, Star/Snow Flake Schema Designs, and expert in modeling Transactional Databases and Data Warehouse.

Experience in designing the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.

Experience in writing complex SQL scripts/ queries to perform End-to-End ETL validations and support Ad-hoc business requests.

Expert in Trouble shooting, Performance tuning the reports and resolving the issues within the server and dashboards.

Having good communication skills, Team lead and player and interpersonal skills.

Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.

TECHNICAL SKILLS

BI Tools : Tableau, Cognos, MicroStrategy, SSRS

ETL Tools : SSIS,Informatica, Data Stage

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

Change Management :ClearCase Clear, CA Service Manager

Front End Tools : Microsoft Project, Microsoft Office, Visible Analyst

Databases : Teradata, Oracle, SQL Server, DB2, MongoDB, Sybase, Access etc

Document management : Visual Source Safe 6.0, Share Point, Ultra Edit, Documentum

Defect management tool : HP Quality center 10.0

Programming Languages : Javascript, HTML, SQL, PL/SQL, XML, Python

Data modeling : Power Designer, ERwin, ER Studio, MS Visio

PROFESSIONAL EXPERIENCE

The Scotts Miracle-Gro Company - Marysville, OH Aug 15- Present

Sr. Data Analyst

The Scotts Miracle-Gro Company is the world's largest marketer of branded consumer lawn and garden products. ScottsMiracle-Gro brands are sold through the world's leading home improvement retailers and mass merchandisers. Other key channels include large hardware chain stores, independent hardware stores, garden centers, nurseries, greenhouses and food and drug store. The project was to design and develop dashboards for Sales and Marketing teams using Tableau.

Responsibilities:

Involved in the solution scoping of the project.

Organized workshop sessions to gather business requirements (blue printing) from the business users.

Responsible for Extraction, transformation and loading using SSIS.

Built Strategic, Analytical and operational dashboards using Tableau.

Developing various tableau dashboards prototype for the future uses and conversion of current excel reports into tableau.

Implemented row level security for the Tableau dashboards and used various advanced table calculations for the dashboards.

Created Bullet graphs to determine profit generation by using measures and dimensions data from SQL Server and Teradata.

Created stored procedures, user defined functions, views, tables and T-SQL scripting for complex business logic.

Cleaned data source in SQL Server and prepared data source in Tableau metadata using complex joins, Custom SQL, split and data blending

Designed, developed and maintained daily, weekly, monthly and year-end summary, trending and benchmark reports repository in Tableau Desktop.

Generated complex calculated fields and parameters, toggled and global filters, dynamic sets, groups, actions, custom color palettes, statistical analysis to meet business requirements

Implemented visualizations and views including combo charts, stacked bar charts, Pareto charts, donut charts, geographic maps, sparklines, crosstabs etc.

Defined visualization pixels and created dashboards using vertical/horizontal containers and collected dashboards in Tableau Story 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 in order to show the relevant data for that particular selected object.

Connecting and extraction to different data sources including Teradata, MS SQL Server, flat files using ODBC driver installation on the tableau server machines.

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.

Tableau administration and development roles and helping the client with the issues of data connections, extraction and maintenance.

Tableau server and desktop upgrade from 8.3 to 9.0.

Environnent :TableauDesktop/Server(8.3/9.0), MS Office Suite, SQL Server, Teradata, Salesforce, Teradata SQL Assistant, SharePoint, AutoSys, MS Excel.

TJX Companies, Framingham, MA May 14-Jul 15

Sr. Data Analyst

The TJX Companies, Inc. is apparel and home goods company which claims to be the largest international apparel and home fashions off-price department store chain in the United States. The project is to implement BI reporting solutions by creating reports, dashboards, and scorecards in Tableau.

Responsibilities:

Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.

Analyzed requirements for various reports, dashboards, and scorecards and developed the same using Tableau desktop

Mentored business power users to create reports/dashboards using Tableau desktop.

Design, build and maintain logical model for Tableau reporting application.

Design, build and maintain all Tableau schema objects (attributes, facts, hierarchies).

Designed Summary and Detailed reports using Data Blending feature in Tableau and utilized the cascading feature on Dimensions to provide dependency on objects through filters.

Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.

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.

Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.

Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.

Created Table of Contents (TOC), a common navigation page which had all the links to various reports.

Make use of filters and making them local and global accordingly.

Providing technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.

Publish the 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 publishing or extracted to server.

Design and development of various reports and dashboards that can be easily accessible through Tableau App in IPad, iPhones, and other smart mobile phones.

Exhibited internal sales trends using Tableau for better understanding of profitability of different client segments. This replaced time consuming Excel/ SAS based data analysis.

Created advanced grid reports, consisting of data analysis by combining a template with filters. The end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.

Created several base formulas (mathematical expressions) using existing facts in Tableau that can be re-used to build any number of metrics.

Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.

Actively participated in clarification meeting with the Clients.

Created Test Cases and documented the Test Results.

Used Tableau QA Testing server to migrate Tableau objects from development environment to the Test environment.

Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environnent :Tableau (Desktop/Server), Teradata, Oracle, SQL Server, Informatica, Teradata SQL Assistant, SharePoint, PL/SQL, CA Service Manager, UNIX, Documentum, Microsoft office Suite

MoneyGram International, Minneapolis, MN May 12 – Apr 14

Sr. Data Analyst

MoneyGram International Inc. is a money transfer company based in the United States which is a public company and listed under the ticker symbol MGI and works with individuals and businesses through a network of agents and financial institution customers. The goal of the project was to identify fraud, transaction analysis, trends, and customer retention using Tableau Reports

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.

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.

Created technical designs for the various reporting requirements.

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.

Dashboard Visualization through Tableau BI application.

Effectively used data blending, filters, actions, Hierarchies feature in tableau.

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

Designed different BI Dashboards for the Company Executives, through an efficient use of Tableau Report Services.

Created all possible Metrics, for enabling the end users to generate customized reports by creating their own Templates and Filters.

Built Complex Reports using advanced reporting functions like with YTD calculations, percentage differences, sets and groups etc.,

Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.

Defined best practices for Tableau report development.

Administered user, user groups, and scheduled instances for reports in Tableau.

Executed and tested required queries and reports before publishing.

Helped end users with integration of their front end application with tableau server by establishing trusted authentication.

Created rich dashboards using tableau desktop and prepared user stories to create compelling dashboards to deliver actionable insights

Maintained Test Log and wrote Test Evaluation, Summary Reports.

Setup and Deployed tableau server to publish dashboard to a central location for portal integration

Implemented row level security and windows AD authentication for Tableau reports

Worked with the tableau community to extensive test the tableau 8 beta version

Environment:Tableau (Desktop/Server), Teradata, Oracle, SQL Server, Power Designer, MS Visio, RUP methodology, Rational Rose, Requisite Pro, Microsoft Office Suite (Word, Excel, Power Point, Visio).

LifeLock - Phoenix, AZ Oct 10 - Apr 12

BI Developer/ Sr. Data Analyst

Life lock provides Identity protection services to the end consumers and its clients that include transaction monitoring (PII/PCI), timely alerting and restoration servicesThe project is to implement reporting solutions on to response data of various campaigns and create database layers, the views of which can be used as data sources in Tableau report development.

Responsibilities:

Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.

Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.

Developed and maintained high level overview of the project and design flows using MS Visio.

Created dashboard using parameters, sets, groups and calculations.

Created interactive dashboard and applied actions (filter, highlight and URL) to dashboard.

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 data sources together on one dashboard to filter data in multiple views.

Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.

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.

Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.

Created incremental refreshes for data sources on Tableau server.

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.

Created report schedules, data connections, projects, groups in Tableau online.

Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.

Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.

Migrated reports from Cognos 8.4.1 to Tableau 8.

Worked on Framework Manager Models Relational DMR for Standard Reporting and Adhoc Analysis

Validated the Data Loads in the Cube using Analysis Studio

Developed numerous multi tab multi page dashboard reports based on the existing remedy database incident management system with drill through functionality to the detail reports.

Environments:Tableau Desktop/Server v7/v8, Cognos 8.4.1, SQL Server 2008, SQL Server Management Studio, MongoDB, Oracle11g, Clear Quest, Clear Case, Excel, JAVA, J2EE, Linux.

Baxter International, Deerfield, IL Sep 09 - Sep 10

Data Analyst

Baxter International Inc. is an American health care company with primary focus on products to treat hemophilia, kidney disease, immune disorders and other chronic and acute medical conditions. Baxter’s Medical Products business produces intravenous solutions and other products used in the delivery of fluids and drugs to patients; inhalation anesthetics; contract manufacturing services; and products to treat end-stage renal disease, or irreversible kidney failure, including solutions and other products for peritoneal dialysis and hemodialysis. The project is to set up a central data repository to capture metadata about many internal operational information sources.

Responsibilities:

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 ODS, flat files and placing it into data warehouse.

Designed, developed, and tested the jobs, using Data Stage

Involved in the some part of performance tuning.

Developed simple and complex jobs using Data Stage to load dimensions and fact tables as per STAR schema techniques.

Created Data Definitions and help maintain Metadata repository.

Utilized Erwin for reverse engineering the database from DDL scripts.

Experience in using MicroStrategy in creating and managing reports for an organization.

Created documentation, worked with users for new module enhancements and testing.

Designed and Developed Drill through Reports, Dashboards and modified the existing Dashboards using MicroStrategy desktop.

Interacted with the End users on a regular basis for resolving issues pertaining to the reports.

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, Toad, Data Stage, MicroStrategy, Autosys, UNIX, Microsoft (Word, Access, Excel, Outlook), RUP Methodology, MS VISIO, MS Project.

Virtusa, Hyderabad, India July 08 – Aug 09

Business Analyst / Reports Developer

Virtusa Corporation is a global information technology (IT) services company providing IT consulting, technology and outsourcing services. The project involved in developing web application and analyzing reports for different clients.

Responsibilities:

Gathered and documented business requirements for existing and future business systems.

Worked with the business unit to define business requirements and analyze the possible technical solutions.

Responsibilities included requirement gathering, business process flow, business process modeling and business analysis.

Designed and developed project document templates based on SDLC methodology.

Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams.

Conducted workflow, process diagram and gap analyses to drive requirements for the automation process.

Using detailed knowledge of application features and functions access scope and impact of business needs throughout analysis and completion of all enhancement specifications.

Design and developed extranet for internal reporting functionality for client.

Design and developed shell scripts to schedule data loading process to staging server

Providing Support and Maintenance for all the clients.

Environment: Sun Solaris, Windows NT, Oracle 9i, My SQL, JSP, Servlet, MS Office Suite. Micro Strategy, Desktop Report, OLAP Services, Architect, Narrowcast Server, Administration, Erwin, Oracle 10g, and Windows 2000



Contact this candidate