PROFESSIONAL SUMMARY:

• Certified and Highly Skilled Professional with having 9+ years of experience in IT industry as BI Developer with Tableau, Cognos and Business Objects with strong background in Databases and Data warehousing concepts.
• Created several dynamic dashboards using Tableau Desktop in various versions (2018.x/10.x/9.x/8.x/7.x) of Tableau Software .
• Experience working on interactive dashboards with Filtering, highlighting, LOD expressions and worked on joins and blending multiple data sources.
• Experience in creating reports and dashboards, analytics, score carding, and monitoring events and metrics using Cognos.
• Design and Development with the primary focus on the Cognos 11.1.1, Cognos 10, Cognos 8.x Suite, Cognos Reportnet, Cognos Impromptu, Cognos Transformer.
• Experience working with Microsoft Business Intelligence stack MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).
• Worked on advanced features of Cognos Report Studio such as Conditional Variables, Conditional Blocks, Drill - through, Page set, Master-Detail relationships, Bursting and various kind of prompts.
• Worked on creating interactive, real-time dashboards using drilling downs and customizations.
• Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.
• Combined multiple data sources using blending in Tableau to keep track of data, operator inputs, and real-time systems all in one dashboard.
• Experience creating visualizations using Bar graphs, Area, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps, Box and Whisker Plots, Highlight tables, and making use of Calculated fields, Actions, Parameters, Sets, Quick, and Context filter according to the end user requirement.
• Built a dynamic application with wide range of options like quick filters, calculated fields, dynamic interaction, flexible ad-hoc capability in various functional areas like finance, sales, marketing and HR.
• Designed dynamic dashboards using Tableau Desktop that allowed even non-technical users to derive insights from the data.
• Strong experience in Trouble Shooting, Performance tuning of reports and resolving issues within source data and reports.
• Experience using Python for importing, transforming and analyzing data and creating visualizations and reports.
• Experience in Python (libraries used: NumPY, SciPY, MatPlotLib, seaborn, tweePY, Pandas dataframe, MySQL DB for database connectivity), TabPY and PyCharm.
• Experience in creating users, groups, workbooks, projects and the appropriate permission sets for Tableau server logons and security checks.
• Experience working with various databases like Teradata, Oracle, DB2, SQL Server, MS Access, MS Excel and Flat files.
• Experienced in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Experienced in writing SQL Queries using joins, derived tables, sub-queries, and correlated sub queries for validating data on reports and for generating data extracts to suffice source data requirements in Tableau.
• Advanced knowledge of performance optimization in Tableau Desktop.
• Identifying Business Data and requirement and modifying it to logical data models.

TECHNICAL SKILLS:

BI/Reporting Tools: Tableau desktop, Cognos, SSRS

Relational Databases: MS SQL Server, Oracle, Teradata, AWS Redshift

Requirement Management: Microsoft Office

Document management: Visual Source Safe 6.0, Share point

Languages: SQL, PL/SQL, T-SQL, Python.

Operating systems: Windows 10/7/XP, Windows Server 2012/2008

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

BI Developer/Analyst

Responsibilities:

• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts.
• Experience in migrating client's reports from excel (static) based solution to an interactive service.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies and Sets to create detail level summary report and dashboard using KPI's.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Deftly designed dashboard templates as per the requirement and dashboard content which includes complex tabular reports.
• Performed Data analysis and Data Visualization using Python libraries (numPY, pandas, matplotlib, seaborn).
• Collect the Dumps generated by several reports from PostgreSQ L Databases and importing to MySQL Databases.
• Create, customize & share interactive web dashboards with simple drag & drop. Expert in generating complex dashboard reports and business views along with user acceptance test and data accuracy test.
• Connected to the AWS Red shift directly from Tableau to access cloud data warehouse and quickly perform visual analysis.
• Developed report level logic as per the requirement and DB constraints, creating POC for client approvals.
• Converted existing Cognos Reports into Tableau Dashboards.
• Monitored events and metrics using Cognos and translated them into Tableau Dashboards.
• Created Cognos Reports using Conditional Variables, Conditional Blocks, Drill-through, Page set, Master-Detail relationships, bursting and various kind of prompts.
• Having experience in SME (Subject Matter Expert) in all BI tools.
• Utilized capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions and Table calculations.
• Defined best practices for Tableau report development.
• Worked on scheduling the extracts and setting up the permissions.
• Extensively used Tab admin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

Confidential, Herndon, VA

Business Intelligence Developer

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Pulled data from IBM db2 to Cognos to develop Business Intelligence Reports.
• Responsible for Data Analysis, designing, developing and testing reports in Cognos 10x for the various disciplines within organizations in accordance with standard team processes.
• Assisted with ETL processes, dimensional modeling, OLAP cube development.
• Developed new/enhance existing COGNOS BI reporting & cube structure solutions including framework manager models.
• Created, modified, enhanced and maintained Framework Manager Model within Cognos.
• Developed Star /Snowflake schema using Framework Manager.
• Analyzed requirements for various reports, dashboards and created proof of concept / prototype of the same using Tableau desktop.
• Extensively developed different types of visualizations in Tableau like Dual Axis, bar charts, Waterfall charts, Bullet graphs, box and whisker plots.
• 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.
• Implemented Grand Totals, Sub-totals, and Changing Aggregation for Customizing the Data.
• Created Hierarchies, sets, combined sets and Groups in Tableau.
• Generated adhoc Tableau reports on demand for providers.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many Tableau reports.
• Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards and handled the performance issues effectively.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Cognos that were published to internal team for review and further data analysis and customization using filters and actions.
• Created dashboard using parameters, sets, groups and LOD calculations.
• Created drill down and drill up in worksheets.
• Involved in creating a dual-axis bar chart with multiple measures.
• Created report schedules on Tableau server.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.

Confidential, Jacksonville, FL

Data Analyst

Responsibilities:

• Involved in BI work stream projects in the implementation and use of new BI software tools and systems.
• Built Tableau visualizations by connecting to various Data Sources Relational Databases (Oracle, SQL Server).
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Responsible for creating SQL datasets for Tableau and Ad-hoc reports.
• Worked extensively with Advance Analysis Actions, LODs (FIXED, INCLUDE, EXCLUDE) Calculations, Parameters, Background images, Maps.
• Worked on creating interactive, real-time dashboards using drilling downs and customizations.
• Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into
• Lead the design and development of analytical projects designed to understand key business behaviors that drive customer acquisition, retention, and engagement
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Worked on various reports using best practices and different visualizations like Bars, Trends, Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables
• Designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Used LOD functions of Tableau for building complex calculations, created drill down timeline reports in dashboard and Involved in data source audit to reduce the data extract size to create optimized the performance of the Tableau workbook.
• Involved in writing QA test cases for the Tableau dashboards
• Involved in data blending analysis in case of merging different sources and creating a dual-axis bar chart with multiple measures.
• Involve in ETL applications, data feeding, cleansing, archiving and re-modeling.
• Worked extensively with Advance Analysis, Actions, Calculations, Parameters, Background images, Maps.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
• Installing Tableau Server in an enterprise level for substantial number of Global users with a Governance principle.
• Performance monitored and tuned the Tableau reports.
• Also used Python packages like numPY, pandas, matplotlib/seaborn for Data Analysis and Advanced Data Visualization.
• Creating New Schedule's and checking the task's daily on the server.

Confidential, Kansas City, MO

Tableau/SQL Developer

Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Analyzed the data using statistical features in Tableau to develop Trend Analysis reports.
• Experience in assisting users in creating and modifying worksheets and data visualization dashboards.
• Worked with SSIS Packages on SQL Server 2010 and SSIS packages on SQL Server 2008 for the automation of day to day Maintenance Jobs.
• Responsible for Developing a Dashboard and preparing ad-Hoc Reporting.
• Managed and created and altered Databases, Tables, Views, Indexes, and Constraints with business rules using T-SQL .
• Performed functional testing of the application.
• Developed complex Stored Procedures, Triggers, User Defined Functions based on the requirement.
• Created dashboard using parameters, sets, groups, and calculations.
• Created visualizations with multiple measures and dimensions.
• Involved in creating of data blending in case merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in creating calculated fields, mapping, actions, and hierarchies.