SUMMARY:

• Over 5 years of diversified IT experience in Analysis, Design, and Development in the fields of Business Intelligence,Data Analysis, Databases and Web - based Applications.
• 3 years of experience in Data Visualization development using Tableau to create complex, intuitive dashboards.
• Excellent team player with very good communication skills and problem solving abilities.
• One year of Data Preparation experience with Alteryx
• Well acquainted with SDLC process and it’s various aspects like functionality, performance and integration.
• Worked extensively with Advance Analytics, Actions Filters, Calculations, LOD, Blending, Parameters, Background images, Maps, Trend Lines, Statistics, and Dual Axes.
• Groups, hierarchies and Sets to create detail level summary report and Dashboard using Tableau’s Advanced Capabilities.
• Improved Reports performance in tableau using extracts and user filters.
• Implemented security at the Data (Data security) and object (Roles and Permissions) level
• Experience in Publishing Tableau Workbooks to Tableau Server and assiging User Access
• ISTQB Foundation Level certified
• Microsoft certified professional - developing windows based application in Visual studio .Net
• Experience in ORACLE 10g and MS SQL Server (2005, 2008, 2012)with good programming knowledge in PL/SQL.
• Knowledge of SAP Business Objects and Power BI.
• Conversant in writing complex SQL queries and Stored Procedures
• Experience in design and development of web applications using .Net 2.0.
• Proficient in all phases of the systems development life cycle, including requirements Definition, Data Conversion, System Implementation, System Testing and Acceptance.
• Proven ability to deliver and ensure success in high-pressure/high-risk situations.
• Experience in documenting the testing process using MS-Office tools including MS-Word, MS-Excel.
• Excellent rapport with developers, testers in all the projects and worked in close collaboration with team members to ensure enhancement of software quality

SKILL:

Business Intelligence Tools: Tableau 8.2,9, 9.2,10.1,10.3

Data preparation/ETL: Alteryx 11

Databases: Operating Systems

MS SQL Server (2005, 2008, 2012), Oracle 10g: Windows

Languages: C#, PL/SQL, XML, HTML, ASP.Net, VB.Net.

Other Tools: Toad, MS Office, MS Visual Studio 2008, MS Visio

JOB PROFILE:

Confidential, New Jersey

Tableau and Alteryx Developer

Responsibilities:

• Interacting with business team to collect the requirements and arrive at data requirements
• Coordinating with data team to source data; Model the data in case of data not existing, as needed
• Create Alteryx workflows for such scenarios where data is not readily available
• Gathered and loaded data into tableau from various sources
• Generating Business Dashboards with drill downs and slice & Dice of Data
• Unit testing and data validation
• Publishing the dashboard and walkthrough with business users

Environment: Tableau 10.5, Alteryx 11.

Confidential, New Jersey

Reporting and Data Analyst

Responsibilities:

• Interacting with multiple business teams to collect the requirements and arrive at data and reporting specs through User Stories
• Coordinating with data team to source data; Model the data in case of data not existing, as needed
• Create Alteryx workflows for such scenarios where data is not readily available
• Gathered and loaded data into tableau from various sources( Oracle, Impala)
• Generating adhoc reports for the business needs
• Unit testing and data validation
• Publishing the dashboard and walkthrough with business users
• Tracking and updating progress through JIRA and Confluence

Environment: Tableau 10.5, Oracle 11, Alteryx 11.

Confidential, New Jersey

Reporting and Data Analyst

Responsibilities:

• Interacting with multiple business teams to collect the requirements and arrive at data and reporting specs
• Coordinating with data team to source data
• Processed the spend and goals data in Alteryx in such a way that it is suitable for reporting
• Gathered and loaded data into tableau from various sources( SQL Server, Impala and excel files)
• Created Executive dashboards depicting spend vs target data using different features like LOD’s, calculated fields, action filters etc.
• Dealt with data volumes ranging from 30 to 40 million records
• Generating adhoc reports for the business needs
• Adhoc data cleansing and standardization using Alteryx
• Unit testing and data validation
• Publishing the dashboard and walkthrough with business users

Environment: Tableau 10.1, MS SQL Server 2012, Alteryx 11.

Confidential, New Jersey

Reporting and Data Analyst

Responsibilities:

• Designed wire frames and prototype
• Data analysis and reverse engineering of data model
• Data preparation with Alteryx
• Development of dashboards in Tableau
• Testing and Data Validation
• Publishing Dashboard and walkthrough with business users

Environment: Tableau 10.1, MS SQL Server 2012, Alteryx 11.

Confidential

Tableau and SQL Developer

Responsibilities:

• Created Tableau dashboards as part of the Analytics/Reporting factory
• Used advanced graphs like Box-Whisker plots, Histograms and Tree Maps.
• Implemented Mapping features in Tableau for Region Anaysis of claims
• Used Tableau URL Actions to navigate from the main Dashboard to detail Reports
• Created action filters, parameters and calculated fields for preparing dashboards and worksheets in Tableau.
• Worked on Joins and Blending to access data from Multiple Data Sets
• Publishing customized interactive reports and dashboards
• Assisted in Requirements Analysis by creating prototypes in Tableau
• Created custom SQL queries and prepared Tableau specific tables/views in MS SQL Server
• Create test plans and reports. Provided UAT support
• Created handover documents for the admin and support team

Environment: Tableau 9.2, MS SQL Server 2012, PL/SQL.

Confidential

Tableau Developer

Responsibilities:

• Involved in Exploring, Designing, Building, Testing and Deployment of theDashboards for Marketing Decision makers and Sales Analysis for critical metrics.
• Involved in understanding the reporting requirements and providing Tableau reporting solutions.
• Created Prototypes in Tableau for concurrence on requirement scoping and sign off.
• Used multiple charts like Bullet Charts, Scatter Plots and Gantt Charts
• Used Tableau features like LOD, Action Filters and URL Actions
• Develop, maintain and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Presented to higher management the discovered trends and analysis, forecast data, recommendations and gaps identified.
• Coordinated and conducted business, system requirements analysis meetings with business and technology partners, business analysts and DBA’s.
• Analyzed the Business requirements and translated them into Application and operational requirements.
• Performed PL/SQL validation queries by cross testing the resulting data from the reports.
• Implemented Security Features of Tableau like row level, object level and report level to make the data secure.
• Analyzed complex data from various data repositories.
• Blended data from multiple databases into one dashboard by selecting primary database from RDM and third party data in CSV files.
• Performed unit testing, system testing and user acceptances test (UAT) for reports and security management.
• Provided support to minimize data quality risks and proactively identify potential data issues.
• Trained end users through online and in-class sessions.
• Resolved end user reporting problems through collaboration with IT, during UAT and Warranty Support.

Environment: Tableau 8.2 & 9, Oracle 10g, PL/SQL.

Confidential

Dot net developer

Responsibilities:

• Worked with onsite team and business users to gather and analyze requirements for customer report generation in .NET.
• Involved in design and development of web applications with .NET.
• Involved in the presentation logic for GUI of ASP.Net Web pages
• Written Stored Procedures using SQL Server 2005.
• Created Pl/Sql logic for the web application for data entry & extraction.
• Generated various SQL queries to be used in the extraction of data.
• Created database tables, constraints, triggers, packages, procedures & functions.
• Performed tuning of SQL queries using Explain Plan and created indexes on tables to improve the efficiency of the queries.
• Collaborated with technical team members to integrate back-end and front-end elements.
• Created Unit and System testing plans as part of the design.
• Provided user support during the SIT and UAT phases for bug fixing and minor enhancements.

Environment: Win 2K, IIS 6.0, ASP.NET 2.0, ADO.NET 2.0, VB.NET 2.0, MS SQL Server 2005 and Visual Source Safe 6.0

Confidential

Dot net developer

Responsibilities:

• Involved in the complete life cycle of the project.
• Involved in gathering the requirements and maintain the required documentation.
• Used to analyze the requirements and involved in design and development.
• Involved in creating tables, stored procedures using SQL Server 2005
• Developed classes and interfaces for the data access layer using VB.Net, ADO.Net and SQL 2005 data access library.
• Configures Web.Config file for the configuration of the web application.
• Designed and Developed Reports.
• Performed Unit and Integration testing.

Environment: Win 2K, IIS 6.0, ASP.NET 2.0, ADO.NET 2.0, VB.NET 2.0, MS SQL Server 2005 and Visual Source Safe 6.0