SUMMARY

• Over 10+ years of experience as a BI Developer with background in design, development and testing, support and maintenance of BI solutions.
• Experience with data analytics, prototyping and designing reports with visualization solutions using Tableau Desktop, Tableau Server and Tableau Reader.
• Experience creating complex data visualizations and interactive dashboard for decision support systems using Bars, Lines, Pies, Donuts, Maps, and Scatter plots, Gantts, Bubbles, Histograms, Heat/ Highlight Maps, KPI Scorecards, Tree Maps.
• Spatial visualizations of non - geographic data using advanced geographic mapping techniques, use of custom images and geo coding to build.
• Proficient in creating and using Calculations and Formatting with Tableau.
• Employed various Tableau Functionalities like 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.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business requirements.
• Knowledge on Preparation, Filtering, Blending and Analyzing of data using ALTERYX.
• Experience working with datasets ranging across various Healthcare, Finance, Marketing, Manufacturing and Service Industries.
• Relational database (RDBMS) background in SQL Server /, Oracle with extensive knowledge and proficiency of T-SQL, PLSQL to design business applications.
• Very good experience in designing and creating database objects including Tables and developing Stored Procedures, Views, Functions, Cursors, Triggers using SQL Server to implement the business logic.
• Experience with designing Data Models, develop ETL (Extractions, Transformations and Load) packages using Microsoft SQL Server Integration Services (SSIS), and customize Analytics Reports with Microsoft SQL Server Reporting Services (SSRS).
• Experience in building Dashboard, Scorecards and Custom reports using IBM Cognos, Microsoft SQL Server Reporting Services (SSRS).
• Working experience with different capacities on the various software development life cycles (SDLC) of the projects ranging from client requirements, design, development, testing, support and maintenance.
• Experience working under Agile (Test Driven, Iterative, Scrum) and Waterfall modes of software development life cycle.
• Ability to work simultaneously on multiple projects coupled with good communication and positive team spirit.
• Analytical and self-starter with excellent problem solving and Team player skills.
• Software team management duties included supervising team development efforts at all stages, doing code reviews, conducting weekly meetings with the clients and staff, documenting client-driven enhancements, compiling weekly status reports.

TECHNICAL SKILLS

BI Reporting Tools: Tableau 10.0/9.3/9.2/9.1/8.2/8.1 , Tableau Server 10.x/9.x/8.x, Tableau Reader, IBM Cognos 8.4, Microsoft SQL Server Reporting Services (SSRS), Crystal Reports, Alteryx.

Databases: Microsoft SQL Server 2012/2008 R2/2005, Oracle 11g/10g, IBM DB2, Teradata, PostgreSQL, MySQL.

Data Modelling: Erwin, ER Studio, Microsoft Visio,Microsoft Project, Microsoft Office Suite - MS Excel, MS Access, Microsoft SharePoint, Power Designer, Altova’s UModel

Languages: C, C++, HTML, T-SQL, PL/SQL, ETL, Talend

Operating Systems: Windows 8/7/XP/ 2008/2003/2000/ NT, Linux

Defect Management: HP Quality center

Version Control: Microsoft Visual Source Safe (VSS), Microsoft Team Foundation Server (TFS)

PROFESSIONAL EXPERIENCE

Sr. TABLEAU DEVELOPER

Confidential, Baltimore, MD

Responsibilities:

• Create and maintain Talend jobs to transform and load data into DWH tables.
• Create and maintain Talend jobs to extract data from PostgreSQL Tables and load into Target fact tables used for reporting.
• Custom SQL for complex data pulls, and replicated those Custom SQL query joins onto Tableau to connect to various data sources.
• Translate technical requirements and Functional Specifications Document (FRD) into report visualizations.
• Identifying Facts, Dimensions, Levels / Hierarchies of Dimensional Modeling.
• Prepare dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Generate reports involving multiple measure types of Individual Axes, Blended Axes, and Dual Axes methods.
• Extensively use calculated fields for different logics for Claim Incurred Trend, Performance Indicators calculations for the different claim types by service usage, provider networks etc.
• Implement efficient ways of data visualization for easy understanding and at the same time maintaining the accuracy of the core information content.
• Created multiple visualization reports/dashboards using Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.
• Work with SMEs to ensure that the extracted data sources in the forms of Excels and cubes are properly mapped and are backed up as needed.
• Support user acceptance testing and mentor business users how to slice and dice data using filters and parameters.
• Responsible for writing and document Use Case Specifications using Visio.
• Publish the developed dashboards to production as well sync up the data by scheduling extract refreshes.
• Performed Gap analysis by analyzing existing system, document for future enhancements or leverage of the reports.
• Attend daily standup meetings to update scrum master with what is achieved, what is being done and is there any impediment.
• Experienced working in Agile and Scrum implemented Environment.

Environment: Tableau Desktop (10.0.x, 9.3.x, 9.2.x,), Tableau Server (10.x, 9.x), Microsoft SQL Server 2012, T-SQL, PostgresSQl, Talend5.6, HP Quality Center, Microsoft Excel 2013, Microsoft Visio, Windows 2012 R2 Server, Agile Methodology, Scrum.

TABLEAU Developer

Confidential, Salt Lake City, UT

Responsibilities:

• Interact with the stakeholders to capture and convert the high level requirements of the project and design flows using MS Visio.
• Process extract data sources from MS Excel and Access to analyze metrics, implement custom procedures, and create reports fulfilling client requirements.
• Extracted data using Parsing, Data Mining, Joins, Aggregations using Alteryx 9.5.
• Create and modify analytical reports with visually rich and interactive dashboards at each stage of loan approval using Tableau Desktop.
• Developed customized calculations as required for different areas of post approval processing namely Funding and Book Keeping.
• Use geographic view to understand and leverage the key areas of the business by line of business and geographical area.
• Create filter actions to share/send information with othertableauworksheets.
• Provide rich visual interaction between the views, create URL actions to connect the data views to external resources.
• Implement new features of Tableau namely new Visualizations, Forecasting, Data Blending and Hyperlink Objects based on use case.
• Publish the dashboards to report server using TableauServer.
• Agile mode of project management methodology and participate in weekly sprint resource planning, implementation and tracking using Microsoft Team Foundation Server (TFS).
• Update status of the work task in daily scrum meetings with the team and higher management; for milestone tracking and avoiding scope creep issues.
• Involve in bi-weekly Change Advisory Board (CAB) meetings with internal organizations regarding status of all assigned projects and tasks or for any future requests.

Environment: Tableau 9.1.x, Tableau Server (9.1), Alteryx 9.5, Oracle 11g, PL-SQL, Teradata, Microsoft Team Foundation Server (TFS), Microsoft Office Suite 2013 - MS Excel, MS Access, MS Visio, Windows 2012 R2 Server, Agile Methodology, Scrum.

TABLEAU DEVELOPER

Confidential, Bloomington, IL

Responsibilities:

• Gathered user requirements, analyze and design BI Reporting solution based on the requirements.
• Interacted with Business Analysts and Data Modelers for defined Mapping & Design documents for various Sources and Targets.
• Design and define best visualization templates, build and publish customized interactive reports and dashboards using Tableau Desktop.
• Schedule and monitor data extract refreshes using Tableau server.
• Create visualizations and dashboards using Scorecards, Stack Bars, Bar Graphs, Scatter Plots, Geographical Maps, Gantt charts using show me functionality.
• Worked extensively with Calculations, Parameters, Background Images, Maps, Advance Analysis Actions and other embedded functionalities in Tableau.
• Extensive use of data blending across heterogeneous data sources from Excel, Access, and MS SQL Server etc.
• Created area map to find out customer base usage within United States.
• Created quick filter to narrow down individual states and cities along with revenue being generated in individual state or city.
• Create detail level summary reports and dashboards with usage of Trend Lines, Statistics, Groups, Hierarchies, Sets, and KPIs etc.
• Deploy reports to server using Tableau Server.
• Involved in writing new custom SQL queries with Tableau using T-SQL to provide conclusive data source for effective report visualization.

Environment: Tableau Desktop (8.2.x, 8.1.x), Tableau Server (8.x), SQL Server 2008 R2, T-SQL, Microsoft Office 2010, Windows 2012 Server, Agile Methodology, Scrum.

COGNOS BI DEVELOPER

Confidential

Responsibilities:

• Understand & document business need for developing an Enterprise Wide Reporting solution.
• Implemented Mock report layouts before the actual report implementation.
• Create forecast, budget, and variance reports using Cognos Report Studio.
• Generate list, cross tabs, charts and sectional reports including drill down, master-detail reports by using Report studio.
• Use of cascade prompts and prompts controls like Value, Pick List and Date & Time prompts.
• Developed multi format reports (PDF, Word, Excel and HTML).
• Created complex reports consuming cubes as data source for multi-dimensional analysis.
• Use of custom queries, calculations, conditions and filters in the reports for Ad-Hoc Reports.
• Restructure some tables, and create indexes for better performance.
• Publishing the report packages based on business requirements to report servers.
• Document test cases for Unit, System Integration and User Acceptance Testing.
• Daily update of task completion status as well weekly sprint retrospection.

Environment: IBM Cognos 8.4 (Report Studio, Query Studio, Analysis Studio, Metric Studio and Metric Designer), Microsoft SQL Server 2008 R2, T-SQL, Windows 2008 Server.

SQL DEVELOPER

Confidential

Responsibilities:

• Interact with the business users to get the new requirements as per the business rules.
• Responsible for identify and translate business requirements for the Enterprise Data Warehouse into logical and physical data models working closing with DB Architect.
• Created technical specifications for the scripts.
• Created T-SQL Functions and Stored Procedures to centralize the business logic in the database.
• Providing day-to-day Support and Maintenance for SQL Server databases.
• Used SQL Server Profiler for troubleshooting, monitoring, and optimization of SQL Server scripts from non-production database environments (Dev and QA).
• Used SQL Server Profiler to trace the bottlenecks, slow running queries, blocking sessions and tried to Optimize SQL queries for improved performance and availability.
• Archiving data from production to archive server and populate reporting data.
• Creating reports usingSQL Server Reporting Services (SSRS)for customized and ad-hoc reports.
• Production support to analyze and fix the defects/issues on daily basis by modifying SQL Server Integration Services (SSIS) Packages and Stored Procedure if necessary.
• Use Microsoft Team Foundation Server with Visual Studio for maintaining safe check in and check out.
• Creation of Technical Design Documents (TDD) with UML diagrams using Altova’s UModel; for clear understanding of business data flow processes.
• Assists functional and technical users with functional and technical testing in all environments

Environment: Microsoft SQL Server 2008 R2, Microsoft SQL Server 2008 Integration Services (SSIS), Microsoft Business Intelligence Development Solution (Visual Studio 2008 IDE), Microsoft SQL Server Reporting Services (SSRS), Microsoft Team Foundation Server, Erwin, Microsoft Access, Altova’s UModel, Windows 2008 Server.

SQL DEVELOPER

Confidential

Responsibilities:

• Interacted with the Business Users and Supervisors to gather business requirements and converted those requirements into Functional and Technical Design Documents.
• Develop and integrate applications as per written specifications
• Co-ordinate with Database Architect in designing the database schema and create Business Process Models.
• Developing database objects like Tables, Views, Indexes, Stored Procedures, Triggers using MS SQL Server 2005.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in partitioning tables that have bulk inserts, deletes and updates to improve the performance.
• Developed SQL Server Reporting Services (SSRS) reports for business end users usingReport Builderwith updating Statistics.
• Developed various operational Drill-through and Drill-down reports using SQL Server Reporting Services (SSRS).
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports
• Version control of code scripts/snippets by using Visual Source Safe; to maintain safe check in and check out.
• Creation of UML diagrams and Technical Design Documents (TDD), for clear understanding of work flow using Microsoft Visio
• Assist in test planning and execution across different testing phases.

Environment: Microsoft SQL Server 2005, T-SQL, Microsoft SQL Server 2005 Integration Services (SSIS), Microsoft Business Intelligence Development Solution (Visual Studio 2005 IDE), Microsoft SQL Server 2005 Reporting Services (SSRS), Erwin, Microsoft Visio, Microsoft Visual SourceSafe (VSS), Windows 2003 Server.