PROFESSIONAL SUMMARY:

• Over 5 years of rich experience in Data Warehousing and Business Intelligence technologies using Tableau and Informatica
• Proficient in various reporting tools such as Tableau 2019.x/10.x/9.x Desktop, Server, Power BI
• Expertise in performing development activities from gathering requirements and designing solutions, through developing code/reports to testing and creating release/run - book/deployment documents
• Ability to analyze and dissect user requirements and build solutions to cater to business specifications
• Developed interactive Tableau dashboards to provide a clear understanding of industry specific KPIs using quick filters and parameters to handle them more efficiently
• Worked extensively on extracting data from diverse sources by creating complex queries in SQL, data blending and joining tables
• In depth knowledge in Tableau advanced analytics features like Dashboard Actions, Calculated Fields, Forecasting, R integration, Parameters and Trend lines and other user interface elements
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement
• Created mappings using different transformations such as lookups to bolster the performance as the volume of data was high
• Published Workbooks by creating user filters and row-level security so that only appropriate teams can view it
• Generated context filters and data source filters while handling huge volume of data
• Designed and developed visualization solutions with business requirement documents and plans for creating interactive dashboards
• Extensive knowledge in different reporting objects like Facts, Attributes, Hierarchies, Calculated fields, transformations, filters, Sets, Groups, Parameters etc. in Tableau
• Transformed massive datasets through filtering, grouping, aggregation, and statistical calculation
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD analysis
• Created various documents such as Functional and Technical Specification and Business Requirements, Data Flow and Process diagrams
• Provided feedback in the project estimates for the development team present offshore as well as on-site

TECHNICAL SKILLS:

Languages: PL/SQL, Unix Shell Scripting, R, SAS, Octave

Databases: Oracle 10g/11i/12c, Oracle SQL Server 2008 R2, MS Access, MS Excel,, DB2, Netezza, SQL Server, Teradata, MYSQL, PostgreSQL

Tools: Tableau, MS Power BI, Qlikview, IBM Cognos, Informatica PowerCenter, IBM SPSS, Alteryx, MS Excel, PUTTY, WinSCP, Rstudio

BI/ Data Visualization: Used Tableau to bring data to life and help visualize data in contexts relevant to perspective, enabling deep insights.

Utilities: MS Office Suite, MS SharePoint, MS Project

Platforms: Windows7/8/2003/NT, Unix, MS Server 2008 R2, Mac OS, DOS

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, Ohio

BI Developer (ETL-Informatica/Tableau)

Responsibilities:

• As a Tableau Developer, I facilitated steering committee level discussion on business priority pertaining to BI
• Produced attractive visuals/dashboards to convey the story inside the data
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices
• Created dashboards for analyzing POS data using Tableau 8.0
• Consistently attended meetings with the client subject matter experts to acquire functional business requirements
• Developed case studies to understand new product launch, promotion effectiveness, trend detections, Seasonal forecasting
• Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications
• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets
• Created custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the report
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations
• Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's
• As an ETL developer, I analyzed the existing data flow to create Source-to-Target mapping (STTM) documents
• Developed and maintained ETL mapping though Informatica PowerCenter 10.1/9.5/8.6 to extract the data from multiple sources like SQL server, DB2, and flat files
• Designed and created enterprise-wide data warehouse/data mart solutions by creating prelanding, staging, data vault and data mart
• Created complex SQL procedures and queries using joins, aggregate functions, analytical functions, correlated subqueries, to load historical data, create SQL override queries and to identify and eliminate duplicates
• Extensively used UNIX commands for version controlling, migration, execution, find and replace etc.
• Performed unit and system integration testing, documented results and mitigated issues in development and UAT environments and aided in the productionizing of the loads
• Created implementation plans and technical specification documents for support teams
• Efficiently followed Agile Methodology and possess good knowledge of Agile components and techniques
• Extensively worked on querying and data analysis on Netezza, MYSQL, PostgreSQL database

Environment: Tableau Desktop 8.0, Tableau server / Administrator, MS SQL Server, Netezza, DB2, Informatica PowerCenter 10.0, PowerExchange Navigator, Putty

Confidential

BI Consultant (Tableau ETL)

Responsibilities:

• Designed and developed visualization solutions with business requirement documents and plans for creating interactive dashboards
• Used advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions
• Created dashboard showing current ticket status elaborating issues raised & status of actions in process towards resolution
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security
• Extensive knowledge in different reporting objects like Facts, Attributes, Hierarchies, Calculated fields, transformations, filters, Sets, Groups, Parameters etc. in Tableau
• Developed reports to provide clear visualizations catering to industry-specific KPIs
• Transformed massive datasets through filtering, grouping, aggregation, and statistical calculation
• Restricted data for particular users using Row level security and User filters
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD analysis
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
• Used Data Blending, groups, calculated fields, and aggregated fields to compare and analyze data in different perspectives
• Used multiple Measures like Individual axis, Blended axis, and Dual axis
• Performed end-to-end Data Analysis and ensured the data quality gaps are identified
• Scheduled Tableau Data Extracts using Tableau Server and the Tableau Command Utility
• Used R functions as Table calculations (aggregated) like Sum, MIN, MAX etc. in Tableau
• Implemented advanced geographic mapping techniques and use custom images and geocoding to build spatial visualizations of non-geographic data
• Collaborating with IT business partners to create a standard process for developing, publishing, and migrating Tableau dashboards through the Development/QA/Production environments
• Assisting business partners in analyzing raw data or data visualizations and advising them on the actions that can be taken from the analysis provided
• Managed different BI projects simultaneously extracting data from various platform and building key KPI for executive reporting
• Partner with business at various levels and keep an open communication related to BI
• Enforce technology related industry standard best practices for different BI platforms

Environment: Tableau Desktop 7 8.1, Tableau Server, Oracle SQL Server R2, MS Excel

Confidential

BI Analyst/Developer

Responsibilities:

• Extracted and analyzed data from multiple sources to provide factors affecting sales performance across different product category, locations and segments
• Performed impact and gap analysis for accurately identifying the bottlenecks and addressed/raised issues if any
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scatter plots, geographical maps, Gantt charts using show me functionality
• Tested reports, uploaded tableau dashboards on to server, and provided production support for tableau users
• Standardized and simplified data for metrics analysis and looking for anomalies
• Generated weekly and monthly reports for in-house ticketing system to gain insights into the response time and suggested scope of improvement and reducing planning/execution man-hours
• Managed multiple job requests ranging from ad-hoc requests, critical system issue or process related requirements
• As a database developer, responsible for a critical database upgrade from Oracle 10g to 11g
• Liaised with different implementation teams and acted as the link between business and them to ensure a smooth upgrade in all three development environments
• Tested and validated over 500 objects including Views, Materialized views, Procedures post Go-Live success
• Updated the objects with necessary changes and deployed code to Integration and Production environment
• Conducted post- go-live presentations for clients and training sessions with support teams
• Requirements gathering from business partners about problems or obstacles where data insight is needed
• Communicated with business-owners and IT to design and implement data analysis solutions

Environment: Oracle 10g, 11g databases, Sharepoint, Visual Studio, Windows