Resume

Sign in

Microsoft Office Data

Location:
Hyderabad, Telangana, India
Posted:
October 20, 2016

Contact this candidate

SharanKusuma Email: acw5h2@r.postjobfree.com

Sr. Tableau Developer Phone: 773-***-****

SUMMARY

Over 8years of IT experience including analysis, design, development, implementation, deployment and maintenance of Business Intelligence, Data Warehouses and Data Mining applications inFinancial, Healthcare, Utility, and Manufacturing industries.

Proficient in Tableau Desktop, Tableau Server and Tableau Online in various versions of Tableau 9.3,9.2,8.x, 7 and 6. Participated in beta testing of Tableau 10.

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)including Waterfall.

Experience in gathering and writing detailed business requirement and translating them into technical specifications/ System Requirement Specifications (SRS) and design identifying 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, StarSchemaand Snowflake Schemamodeling.

Expertise in Teradata, Oracle, SQL Server, Informatica, SSIS, SSRS, 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, geo and custom geo maps and other making use of actions,local and global filtersbased 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, Systemand 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.

Involved in Tableau 10 Beta testing.

Used data blending to achieve custom geo coding using excel.

Created Extracts, used scheduling, maintenance of subscriptions, creation of groups / users for accesses appropriately.

Technical Skills:

Reporting Tools

Tableau 9.3,9.2, 8.x, 7,6, Business Objects 5.x/4.1, SSRS

ETL Tools

Informatica, Microsoft SQL Server Integrated Services

Databases

Teradata, Oracle 11g, DB2, MSSQL 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, SharePoint, JIRA

Methodologies

Data Modeling – Logical/Physical/Dimensional, Star/Snow flake Schema, ETL, OLAP, Complete Software Development Lifecycle, CMMI Compliance, Waterfall, Agile, Iterative

Data Modeling Tools

ERwin, ER Studio

Languages

C, SQL, PL/SQL and Javascript

Web Applications

HTML, Perl, XML and JavaScript

Professional Experience:

Motorola, Chicago, IL November ’14 - Current

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 and also including custom geo locations including zip-3 locations.

Developed customized calculations when required.

Worked on drill through reports by creating HTML references. Created URL filters while embedding the dashboard with a view using JavaScript.

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 their 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, analyse metrics, implement verification procedures, and fulfil client requests for information.

Actively tracking schedule, clear and crisp communications with key resources, stakeholders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

Dashboards were created using IBM DB2 boosted by Netezza, also including SQL Server and Excel.

Wellington Management, Boston, MA February ’13 - October ’14Sr. 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 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.

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.

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, and 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, and 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 May ’10 – 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 engineered the database 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).

Mediamint, Hyderabad, India May 08 – April 10

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