PROFESSIONAL SUMMARY:

• 6 years of IT experience in Data warehousing and Business Intelligence technologies along with around 4 years of data visualization using Tableau.
• Extensive experience in enterprise Tableau environment including report/dashboard design, development, maintenance, and support using different versions of Tableau Desktop and Tableau Server.
• Experienced in requirement gatherings, analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Clear understanding of Data Warehousing concepts with emphasis on ETL and Life Cycle Development.
• Highly Proficient in Agile, Iterative, Waterfall models in software development life cycles.
• Expertise in cleaning, transformation, and modeling large data to discover patterns, trends and behaviors and support decision making process using Alteryx Designer.
• Worked in Formal Systems analysis, design, implementation of Operational/Database systems utilizing Oracle RDBMS Methodologies.
• Worked in all phases of BW/BI full life cycles including analysis, design, development, testing, deployment, post - production support, maintenance, documentation, and end-user .
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, line diagrams, pareto charts, funnel charts, scatter plots, pie-charts, donut charts, bubble charts, funnel charts, heat maps, tree maps as per the end user requirements.
• Expertise in using advance Tableau features like Calculated fields, Sets, Groups, Parameters, context filters, quick filter, global filters, custom geo coding, Actions, LOD, Adhoc Calculations etc.
• Expertise in designing and developing analytical reports, interactive dashboard design, and visual best practices to convey the story inside the data by integrating data from multiple sources and help users to identify critical KPIs and facilitate strategic planning in the organization.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Created reports using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Proficient in analysis, design and implementation of data warehousing/ BI solutions using Tableau, Alteryx, Informatica, MicroStrategy, Tableau and Database technologies.
• Extensive experience in designing the architecture for Extract, Transform, Load environment and development of mappings and process using Informatica Power Center.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing, processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Hands-on experience using Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact, Physical and Logical Data Modeling.
• Knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• Adept in analyzing bugs, interacting with team members in fixing errors and User Acceptance Testing (UAT) and assisted in Post - Production support.
• Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.
• Hands on experience in Integrating SAP BW with Business Objects Data Services.
• Create Views with Formatting or standard templates, Applying sorts, calculations
• Good understanding of business environment, excellent communication skill and ability to work proactively in a fast-paced environment.

TECHNICAL SKILLS:

Analysis Tools: Tableau, Power BI, MS SSRS, MS SSAS, MS Excel

Data Integration (ETL) Tools

Alteryx, Informatica, MS SQL Server Integrated Service (SSIS)

Database: Oracle, SQL Server 2008, Teradata, SSMS, MS Access

SDLC: Waterfall & Agile methodologies, project life cycle, MS Project 2013, JIRA

Programming: SQL, PL/SQL, Python, C#, CSS, HTML, JavaScript

Application Software: MS Office, Eclipse, MATLAB, Visual Studio, MS Excel advance, MS Access, Toad Oracle

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Software Engineer/ Tableau Developer

Responsibilities:

• Involved in full project lifecycle of SDLC and coordinated with all project teams.
• Involved in gathering, reviewing business requirements, and analysing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created business Intelligence standardizations to create database layers with user friendly views in SQL Server that can be used for development of various Tableau reports/ dashboards.
• Designed and developed a business intelligence data visualization dashboard using Tableau Desktop, allowing executive management to view past, present and forecast data.
• Identified the Key factors (KPI) involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
• Created various intuitive visualizations on inventory related data to show the data in an effective manner by applying different calculations, Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and table calculations.
• Created Executive score card dashboards to shows the high and granular level of data.
• Created Filled Maps and Symbol Maps according to deliverable specifications.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Creating Dashboards according to the project functional requirements and Tuned data loads Tableau application for efficient performance.
• 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.
• Modified interactive Dashboards and Creating guided navigation links within Interactive Dashboards. Make use of filters and making them local and global accordingly.
• Created Python snippets to extract the data from AWS S3 to local databases.
• Enhanced existing reports and provided them with better view to calculate budget and profits.
• Created extracts and scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
• Performed incremental refreshes and applied Row level security to maintain security and performance.
• Used SQL tools like Toad and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and marts.
• Designing and building the structure of dashboards, and suggested how to present the data, why and find opportunity to get attention to a chart.
• Involved in Production support and maintenance phase and Prepared various dashboards for teams and streamlined the processes.

Environment: Tableau Desktop/ Server, Oracle, MySQL, Oracle, Python, R-Script, Teradata, MS SQL Server 2008, Excel, UNIX, SQL Server 2008, SSMS.

Confidential, MN

Data Visualization Developer/Tableau Developer

Responsibilities:

• Gathered and analyzed the business requirements and then translate them to technical specifications and performed impact analysis.
• Participated in the architecture and design of features associated with Collaboration and Scaling of Alteryx across the business.
• Created various workflows in Alteryx to manipulate the raw data and extracted that data to tableau.
• Extensively worked on performance tuning of mappings, sessions and various ETL Processes.
• Translated business logic from one system (SQL, Excel, etc.) into Alteryx in a quick and accurate manner.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Created various visualizations to show the growth percentages of products in each region.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views
• Designed and developed various analytical reports from multiple data sources by blending data on a single Worksheet in Tableau Desktop.
• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets
• Worked on Tableau desktop for some of the reports replicating the SSRS reports.
• Used Python and R-scripts and extracted data from APIs and created dashboards in Tableau.
• Created Scatter Plots, Stacked Bars, Box and Whisker plots using, Bullet charts, Heat Maps, etc., according to user requirements.
• Created reports using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Involved in Informatica Performance tuning of the ETL process and SQL tuning.
• Worked on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, and MS Excel.
• Trained the business users on Tableau's self-service model of Creating and Publishing the Reports.
• Provided resolution to performance problems of dashboards deployed on Tableau server using out of the box performance analyzer tool of Tableau desktop and Tableau server.
• Created Users, Groups and Projects on Tableau Server.
• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Provided post implementation production support.

Environment: Tableau Desktop/Server, Oracle, MySQL, Alteryx, Informatica, Python, R-Script, MS SQL Server 2008, Teradata, Excel, UNIX, SQL Server 2008.

Confidential, MA

BI Data Analyst/ Tableau Developer

Responsibilities:

• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Worked with Architects and Business Analyst to understand architecture design and business logic.
• Obtained and maintained understanding of Provider Network data for commercial and government lines of business.
• Involved in reviewing business requirements and analyzing data sources from Excel, Oracle, Hadoop, Teradata, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Developed asset allocation strategies, investment models, and implemented portfolio risk monitoring.
• Data Profiling, Mapping, and Integration from multiple sources to AWS S3/RDS/Redshift.
• Providing technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
• Interact with client and understand business requirement for the creation of new workflow on Alteryx tool.
• Worked on writing queries to source and load the data to SQL Server and Oracle databases using Alteryx and SSIS.
• Used Data Blending, Groups, combine Adobe Marketing Cloud data and other aggregated data, spotlight into compare and analyze data in different perspective.
• Designed and developed Tableau visualization solutions by connecting to Google Analytics, Oracle and SQL databases.
• Developed custom SQL connections and calculated fields within Tableau to facilitate automated production of data visualizations.
• Used JavaScript API to set and create filters, select and highlight elements in the view, and process the view to retrieve updated data.
• Created Scatter Plots, Stacked Bars, Box and Whisker plots using, Bullet charts, Heat Maps, etc., according to user requirements.
• Created reports using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Created the Test Evaluation and Summary reports.
• Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Implemented security in reports as per employee groups and roles as per the requirement and was involved in deployment process.
• Created users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Designed and developed trend reports including forecast and trend lines.
• Established, maintained and ensured adherence to application standards for data reporting.
• Data analysis using SQL Analyze complex datasets to detect patterns and anomalies. Recover information from computers and data storage devices.

Environment: Tableau Desktop/ Server, Power BI, Windows Server Standard R2, Excel, SQL Server management studio, Hadoop, Redshift, T-SQL, MS SQL Server 2008 R2

Confidential

SQL BI Developer

Responsibilities:

• Actively involved in different stages of Project Life Cycle.
• Participated in gathering of User Requirement and System Specification.
• Created new database logical and physical design to fit new business requirement and implemented new design into SQL Server 2000.
• Successfully migrated old data from legacy system into SQL Server2000 using DTS Packages.
• Filtered bad data from legacy system using complex T- SQL statements, and implemented various constraint and triggers for data consistency.
• Created company’s first Excel-based interactive dashboards that included pivot tables, Power Pivot, v lookups, auto refresh, macros, user-defined functions, goal seek, and scenarios.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Wrote complex stored procedures to process driver’s record and balanced the processing load between front end and back end.
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Created ad-hoc SQL queries for customer reports, executive management reports.
• Implemented batch processing for approval process using Jobs and DTS.
• Created Users and Roles, and managed security and permission of database.
• Documentation of all the processes involved in maintaining the database for future .
• Actively participated in User Acceptance Testing and debugging of the system.

Environment: SQL Server 2000, SSIS, T-SQL, MS Excel, MS Access 2000, Erwin, Windows NT