Data Microsoft Office

Aswini

Phone: 469-***-****

Email: ******.***@*****.***

Education:

Master's in Computer Science. Jan 2016 - April 2017

Northwestern Polytechnic University, California.

Bachelor's in Computer Science. Sept 2009 - April 2013.

Jawaharlal Nehru Technological University, India.

Objective: To secure a challenging position where I can effectively contribute my skills as a software professional, possessing competent technical skills and serve the organization whenever needed and reach higher positions.

PROFESSIONAL SUMMARY:

Around 5 years of experience in Data Analysis/Business Analysis, System Analysis & Design, Development, testing and implementation of BI/Data Warehousing projects using Tableau, in Insurance, Finance, Banking, Health Care, and Retail and Payroll Services industries.

Extensive experience in creating UI visualizations with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 10.x/9.x/8.x/7.x/6.x.

Extensive experience in designing, developing and publishing visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.

Utilized all Tableau tools including Tableau Desktop, Tableau Reader and Tableau Public.

Strong understanding of project life cycle and Software Development Life Cycle(SDLC) methodologies including RUP, RAD, Waterfall and Agile.

Interviewed SMEs and Stakeholders to get a better understanding of client business processes and authored Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.

Dashboard design, aggregation functions, set analysis, use of SQL scripts and Strong knowledge on software development life cycle (SDLC).

Proficient in creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bubble Charts, Funnel Charts, Bar Charts (Horizontal, Stacked), Bullet Graphs, Area Charts, Scatter Plots, etc.

Expertise in Developing User Objects (filters, prompts, metrics, Sets and Groups, Calculated Fields) to develop Documents and reports.

Exceptional experience in dealing with various databases like Teradata, Oracle, DB2, SQL Server, MS Access, and Flat files.

Extensively built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data using Tableau.

Developed reports, dashboards, and SQL queries using Tableau. Worked on gathering data requirements from different sources and data cleansing

Good experience in installing, configuring, upgrading and managing Tableau server in cluster environment

Experience in Developing, Designing and Support inter active Tableau dashboards.

Knowledge in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.

Experience in developing and debugging Stored Procedures and Triggers.

Worked on administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs.

Experience in working with Data Cleansing technique in ETL procedures.

Skilled at building and deploying multi-valued parameterized reports using Power BI, Tableau.

Excellent hands on experience in creating groups and measures, KPIs.

Extensively involved in Reverse-Engineering and Business Rules Extraction Expert in project planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results.

Flexible, enthusiastic and project oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirement of client.

TECHNICAL SKILLS

Reporting Tools

Tableau (Desktop/Server), Micro Strategy (Desktop/WEB), SSRS,

DWH, Business Intelligence.

Data Integration

(ETL) Tools

Informatica Power Center, SSIS

Modeling Tools

Power Designer, Erwin, ER Studio, MS Visio, OBIEE

SQL Tools

Teradata SQL Assistant, Rapid SQL, Toad, PL/SQL Developer, SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor.

RDBMS

Teradata, Oracle, OLAP, SQL Server, DB2, Mongo, SAP HANA

Access etc,

UI Tools

CICS, ROSE, PUTTY, Visible Analyst, Lotus Notes

Documentation

Documentum, SharePoint, HP Quality Center.

Scripting/Languages

C, C++, .NET, HTML, JavaScript, Python, PERL, SQL, PL/SQL, and XML, BTEQ, JSON, CSS

Scheduling Tools

Autosys, Control M

Operating Systems

UNIX, Linux, Windows 7/XP/2000, 2008/2003, Windows 9x

WORKING EXPERIENCE:

Client: Vistra Energy, Tx April 2017 To Till date

Role: Tableau Developer.

Responsibilities:

Analyzed the business requirements, identifying the requirements, reviewing and communicating with business and getting sign offs from business.

Developed reports, dashboards, and SQL queries using Tableau.

Worked on gathering data requirements from different sources and data cleansing.

Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to created summary level and detailed Reports.

Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.

Prepared Tableau reports in various subject areas like Materials Procurement Savings, Bill of Materials, Customer Service Index, Employee Productivity and Employee Safety.

Played critical role in establishing Best practices for tableau reporting by conduct meeting with the clients for gathering reporting requirements; identify the KPI’s and developing POC Dashboards.

Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and excel.

Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

Worked closely with the ETL Team to automate the Data load process, create required aggregate tables, indexing and table portioning for performance optimization of Reports.

Experience in using analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc., in many tableau reports.

Effectively used data blending feature in Tableau to integrate different database tables.

Designed and developed various analytic reports / dashboards using Tableau.

Developed Complex dashboards and used advance chart visualizations in Tableau like Dual Water Fall charts, Axis, Bullet Graphs, Bubble Charts, etc. to assist business users in solving complex problems.

Involved in dashboards on SAP HANA views and publishing the HTML files/reports back to XS server on SAP HANA.

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

Built Excel, Qlik View and Domo reports in Tableau.

Developed and Documented technical architecture, system design, performance test results and other technical aspects of the implementation.

Assisted power users in Tableau dashboard development.

Environment: Tableau (Desktop/Server), Teradata, Teradata SQL Assistant, Adobe Analytics, Microsoft SQL Server, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint).

Client: Availl,Tx Aug 2016 to Feb 2017

Role: Tableau Developer/ Admin.

Responsibilities:

Gathered Business Requirements, interacted with the Executive Directors, Project Manager and SMEs to get a better understanding of the Business Processes.

Developed various dashboards, used context filters, sets while dealing with huge volume of data.

Provided Tableau desktop training for end users.

Worked on creating Pivots, sets, groups, and parameters.

Worked on Creating various plots and drill down analysis using Tableau desktop.

Installation, Configuration, Administration and Development experience in Business Intelligence Tools using Microsoft SQL Server, Tableau, SAP Business Intelligence Platform.

Worked on scheduling reports, managing data sources and refresh extracts.

Developed SQL scripts to create database objects like Tables, Views and Sequences.

Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.

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

Prepared dashboards using calculated fields, groups, sets and hierarchies in Tableau.

Generated Tableau dashboards with combination charts for clear understanding.

Cleaning and Blending multiple data sources to allow for different views on application data in a single dashboard.

Created side by side bars, Scatter Plots, Stacked Bars, Pareto Charts, Bollinger Bands, Radial Charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.

Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.

Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.

Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to server.

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

Published the dynamic dashboard reports to Tableau server for navigating the developed dashboards in web.

Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.

Worked on Tableau Admin for scheduling the Data refreshing frequency, manage automatic subscription, security and controlling access.

Successfully administered users, user groups, and scheduled instances for reports in Tableau.

Resolved various performance issues and analyzed the best process distribution for different projects.

Environment: Tableau (Desktop/Server), MS SQL Server 2008, UNIX, Microsoft Office Suite (Word, Excel, PowerPoint), Teradata Administrator.

Client: Netxcell Limited, India. July 2014 to Nov 2015

Role: Tableau Developer

Responsibilities:

Designed and implemented Dashboards and Scorecards with business KPIs using

Performance Point Server and published them via Tableau.

Worked on gathering data requirements from different sources and data cleansing.

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

Displayed multiple measures like Individual Axes, Blended Axes, and Dual Axes.

Effectively used data blending feature in Tableau to combine the data from different sources like Adobe marketing cloud into a single report.

Wrote Custom SQL scripts for creating aggregate tables and generating views.

Worked on understanding of relational database structures, theories, principles and

practices.

Excellent hands on Experience in ETL (Extraction Transformation and Loading) by

extracting large volumes of data from various data sources using SSIS.

Experience in working with different type Dirty Data from Different sources.

Experience in working with Data Cleansing technique in ETL procedures.

Assisted power users in Tableau dashboard development.

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

Client: Truzio Technologies, India. June 2013 to June 2014

Role: Jr. Tableau Developer.

Responsibilities:

Communicated with clients to gather and analyze requirements.

Created interactive dashboards using tableau desktop

Analyzed the source data and handled efficiently by modifying the data types.

Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.

Generated Dashboards by joining multiple complex tables.

Generated dashboard for Finance team, provided security by using user filters.

Created adhoc reports to users in Tableau by connecting various data sources.

Analyzed the existing business requirements in Tableau.

Implemented Data blending on multiple data sources and generated interactive dashboards.

Developed SQL scripts to create database objects like Tables, Views and Sequences.

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

Used Informatica Power Center for extracting Oracle, flat files for Data Extraction Involved in the development of Informatica mappings and also tuned them for better performance.

Creating stored procedures and some complex queries to embed this in SSRS reports.

Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).

Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.

Client: Global Logic Technologies Ind Pvt Ltd, India. June 2012 to May 2013

Role: SQL Server Developer.

Responsibilities:

Analyzing data, understanding data model, translating requirements and populating dimensions and facts in data warehouse.

writing queries by utilizing DML/DDL/DCL’s and dealing with the tables.

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Assisting the data entry team when needed and pulling the required data from various tables using complex SQL queries.

Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.

Load the configuration file into the database using the existing SSIS packages.

Helping SA's in the validation process after the load using the SQL scripts.

Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 and Flat files.

Environment: MS SQL Server 2005/2008, Access, Management Studio, Visual Studio, SSIS, SSRS, T-SQL.

Contact this candidate