SUMMARY:

• Over 8+ years of extensive IT Experience as a Sr. Data Analyst, Data Visualization Engineer , Tableau, Cognos and Power BI Developer and Server Administrator, Business Systems Analyst in Data Warehousing and Business Intelligence applications in Banking, Telecom, labor, SCM, Financial, Retail, Automobile and Life sciences/Healthcare industries.
• 5+ years of experience in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 10.x/9.x/8.x/7.x.
• Expertise in Tableau Server Administration and working in DW environment
• Embedded Tableau reports to Microsoft Power BI Launchpad and Crystal reports.
• Outstanding working experience on Cognos, Confidential, Microstrategy and Spotfire Professional.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Extensively worked on Prototyping and designing reporting , data analytics and visualization solutions
• Create process efficiencies through automation (report delivery, dashboard creation and data management)
• Very good knowledge of Operational data store ( ODS ) architecture and implementation.
• In - depth knowledge of tools like SAS for Data Manipulation. terdashboards, and metrics to monitor the network performance
• Mine data and extract useful network insights
• Integration experience of SAS OBDC with tableau , installing and configuring SAS ODBC driver.
• Worked on SAS ODBC data connection issues such as Live Versus Extract-based Connections, DSN Versus Driver Connections and Extract Creation Performance.
• Strong knowledge in developing, designing and implementing data mining models using neutral networks and logistic regression
• Highly proficient in tools like OLAP and ad-hoc query tools, broad base, Siebel , e-configuration and Epiphany
• Experience in Tableau Server Installation and Configuration, creating users, groups, projects, providing access levels.
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.,
• Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources.
• Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data for complex data analysis.
• Expertise in analysis, design and implementation of data warehousing/ BI solutions using Teradata, Oracle, Informatica, Micro Strategy, Tableau, Unix technologies.
• Expertise in web integration of Tableau Reports with SAP ERP, HANA, BOBJ, AWS, HTML or Asp.Net.
• Worked extensively on Tableau JavaScript API for performance improvement of web page.
• 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 via API
• Hands on experience in Business objects.
• Expertise in Microsoft Excel plus Google Sheets data manipulation

TECHNICAL SKILLS:

BI Tools: Tableau 10.X/9.X/8.X/7.X ( Desktop, Server, Reader), SSRS, Cognos, Confidential 10.0, Tibco-Spotfire Professional, Microstrategy, Power BI.

ETL Tools: Informatica, SSIS

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

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

Defect management tool: Test Director, HP Quality center

RDBMS: Hadoop, Postgress, Teradata, Oracle, SQL Server, MS Access, TFS.

Scripting Languages: HTML, CSS, Java, Python

Operating systems: Windows 7/XP, Windows Server 2012/2008, UNIX/Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Cary, NC

Tableau Developer & Server Admin / Data Analyst

Responsibilities:

• Created and hands on experience in Level of Detail Expressions (LOD’s) such as Customer order frequency, Cohort analysis, Daily profit KPI , Percent of total, New customer acquisition, Comparative sales analysis, Average of top deals by sales rep, Actual vs. target, Value on the last day of a period, Return purchase by cohort etc.
• Involved in full project lifecycle of SDLC and coordinated with all project teams.
• Worked on embedding Tableau reports to Microsoft Power BI Launchpad and Crystal reports.
• Implemented Tableau , performed admin activities across multi-environment infrastructure
• Interacted with SME & End Users and gathered business requirements.
• Responsible for writing Business Requirements Document ( BRD ), Use Case Specifications, Functional Specifications Document ( FRD ).
• Performed Gap analysis by identifying existing system, documenting the enhancements to meet the end state requirements.
• Experienced working in Agile , Rally & Scrum implemented Environment.
• Handled the tasks of building, deploying and maintaining metadata inventories and data support tools
• Experienced working on different ticketing systems such as Agile ticketing.
• Understanding of and experience with real-time analytics, BI platforms and visualization tools such as Tableau
• Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
• Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.,
• Created and administered user, user groups, and scheduled instances for reports in Tableau Server.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups.
• Developed effective and interactive Dashboards using Parameters and Actions.
• Setting the user permissions in Tableau Sever.
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Prepared proof of concept for best practices in Tableau deployment .
• Expertise in providing business solutions by analyzing various trends, risks and patterns in the data using interactive crystal reports .
• Created detailed dashboards utilizing Microsoft Power BI desktop to improve analysis and decision making.
• Experience in creating Complex Spotfire Dashboards or Reports Using Tibco Spotfire Professional.
• Converted Various Excel, Tableau and BO Reports to Spotfire.
• Setting up complete ETL Workflow in Confidential .
• Enhanced existing oracle views in the ETL Confidential workflow.
• Extensively working experience in Tableau Server Configuration/DB Connection for Oracle DB.
• Involved in integration of Tableau JavaScript API Filters in web application
• Excellent in Performing maintenance activities of Tableau Server incl. Backup, Logs Cleanup and Archiving Log files in prescribed intervals
• Experience in working on sourcing the data from HADOOP platform using scoop .
• Experience in running queries in HIVE .
• Worked on different Hadoop distributions such as HDP and CDH.
• Configured AWS for Tableau and Installed Tableau Server.
• Played an important role in coordination with the entire team and managing the time estimates for the entire project.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Used SQL tools like Toad and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and marts.

Environment: Tableau (Desktop/ Server)9.3 & 10.0, Confidential, Microsoft Power B.I., Teradata V2R5/R6/R12/R13, Hadoop, AWS, SQL developer, MS SQL Server & TFS, Oracle MySQL, PL/SQL, T-SQL, Teradata SQL Assistant, Toad, MS Access, Windows 2012 R2 server,

Confidential, Philadelphia, PA

Tableau, Developer & Backup Server Admin / Sr. Data Analyst

Responsibilities:

• Interacted with the stakeholders by interviewing them, by preparing questionnaire and getting feedback.
• Collaborated with Enterprise Architecture, IT leadership and internal stakeholders.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created reports using Trend Lines, Statistics, and Log Axes, Groups, hierarchies, Sets.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created new Schedule's and checking the task's daily on the server.
• Experience in standardizing Tableau for shared service deployment.
• Extensively used data blending , embed functionalities in Tableau.
• Prepared Tableau to Connect to Oracle MySQL Using SSL by Creating a TDC file and or Connected through the ODBC driver for MySQL
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Worked with Source system Subject Matter Expert ( SME ) to ensure that the extracts are properly mapped. Used SQL Workbench for data mapping and querying.
• Handled the tasks of code development and data analysis
• Experienced in a wide variety of telecommunication networks
• Experienced in configuring and administering different level of securities.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Involved in creating dashboards and reports in Tableau and Maintaining server activities , user activity, and customized views on Server Analysis .
• Gathered user requirements, analyzed 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.
• Good knowledge on Teradata Manager, TDWM, PMON, DBQL, MySQL assistant and BTEQ.
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.

Environment: Tableau Desktop / Serve, Cognos, Confidential, Microstartegy, Teradata, Informatica, MS SQL Server, Toad, Teradata SQL Assistant, SQL, PL/SQL, T-SQL, UNIX, PowerShell, Microsoft office Suite (Word, Excel, PowerPoint).

Confidential, Philadelphia, PA

Tableau and Cognos Developer, Sr. Data Analyst

Responsibilities:

• Interacted with business to collect and understand Requirements.
• Evaluated Global consumer risk reporting data models to design Tableau solutions.
• Worked in BI team to fulfill the needs of regulatory/management/finance/loss mitigation/fraud reporting and 10Q.
• Interacted with business users and performed Gap Analysis of Client requirements.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Worked closely with business power users to create reports/complex dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Created users using Tableau Admin and assigned privileges to create report/publishing reports to server.
• Enabled the data security filters for the users/groups using AD groups .
• Performed report tuning using extracts, Cache options, removing unused fields.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Developed Executive Dashboard reports using Cognos Report Studio , Workspace and Workspace Advanced .
• Created different types of reports like list, crosstab, chart and also dashboards in the Cognos
• Creating the Metadata Model, Active reports and Visualizations in Cognos
• Responsible for creating / delivering monthly reports to business users.

Environment: Tableau (Desktop/ Server), Cognos, MS SQL Server 2008, Excel, SQL, PL-SQL, TSQL, UNIX, SQL Server 2008, SQL BI Suite (SSIS, SSRS), MS Office, Visual Studio 2010

Confidential, Columbus, OH

BI reporting analyst & SQL Developer

Responsibilities:

• Wrote program to export as text files or PDF to outside Life science Business Users.
• Utilized SQL Queries , stored procedures, packages, used defined functions, views, cursors using Toad or SQL Developer to present data on the reports such as sales information, deposit and payout and their incentive compensation information.
• Created mid to complex Reports (Oracle data sources) with one or more of the following features to support statistical and operational business needs, Grouping, Sorting, Drill-down Dynamic Parameter prompts, Sub reports or Crosstab summaries
• Better understanding and familiarity with hospital and / or clinical workflows.
• Developed Drill down Reports, Linked Reports, sub reports and Parameterized Reports using Cognos
• Expertise in analysis, design and implementation of data warehousing/ BI and Business Objects solutions.
• Efficiently debugs and manages stored MySQL procedures and functions
• Debugged nested procedures and functions as well as anonymous code (similar to anonymous blocks in Oracle)
• Supported conditional breakpoints and tooltip expression evaluation
• Hands on experience in running SQL commands in the debugging context
• Created formulas and/or used statistical or financial functions for reports as needed.
• Used SQL stored procedures, created alias data tables as required to improve report performance.
• Created Stored Procedures and Views as data sources using Oracle databases for reports.
• Used Optimizer HINT for tuning T-SQL and PL/SQL queries rewrite most of them for efficiency
• Involved in preparing and executing SQL code deployments (DDL/DML) with application rollout teams into QA/Production environments.
• Created Tables, Views, Constraints, Indexes and developed Complex database objects including
• Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL with exception handling
• Implementing performance tuning methods to resolve issues and bottlenecks. Identifying long running queries and performing performance tuning.

Environment: Microsoft SQL Server 2008, Crystal Reporting, Shell Scripting, SSRS, SSIS, XML, T-SQL, .NET, MS Word and Excel, SQL Profiler, Toad.

Confidential

SQL Developer

Responsibilities:

• Analyzed reports and fixed bugs in stored procedures using SSRS.
• Used complex expressions to group data, filter and parameterize reports .
• Created linked reports and managed snapshots using SSRS.
• Performed various calculations using complex expressions in the reports and created report models.
• Generated Complex SSRS reports like reports using Cascading parameters, Snapshot reports Drill-down Reports, Drill-Through Reports , Parameterized Reports and Report Models and ad hoc reports using SSRS based on Business Requirement Document.
• Conducted performance tuning of complex SQL queries and stored procedures by using SQL Profiler and index tuning wizard.
• Provided Production support to analyze and fix the problems and errors on daily basis by modifying SSIS Packages and Stored Procedure if necessary.
• Designed and developed Tables, Stored procedures, Triggers and SQL scripts using TSQL, Perl and Shell scripting for enhancements and maintenance of various database modules

Environment: MS SQL Server 2005/2008, MS SQL Server Reporting Services, SQL Server Integrating Services, SQL Server Analysis Services, T-SQL