SUMMARY

• 9+ years of total IT experience in Analysis, design, development,administration, and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, OLAP, Client/Server and Web applications on Windows and Unix platforms
• Expertise in Tableau, Oracle, MySQL and Netezza.
• Technically hands - on commercially experience mainly wif creating teh dashboards and reports using Tableau Desktop tool and building various dashboard development activities such as Dashboard layout design and development, Tableau Extracts, Tableau Actions, Tableau Dashboards color coding and formatting, Tableau designs, proto types and Tableau mock up reports, Wireframes, Frame works, Design documents (HLD, LLD), Data mapping documents and reporting.
• Using teh Tableau Desktop for teh Data Analysis, Data Visualizations, and Data Discovery and for teh data explorations.
• Using teh Tableau server Product for publishing teh dashboards to server, user management, user security and administration, Content Restriction as a Tableau Content Administrator.
• Experience working as a Tableau analyst, TableauDeveloper and Tableau Administrator and experienced as in using teh Tableau BI Products Tableau Desktop and Tableau Server.
• Expertise in creating Report Inventory, Report Mapping document, Report Business Requirement Documents (BRD), Reports Functional Requirements Documents (FRD), Use cases diagrams and report inventory document.
• Experience in creating various visualizations in tableau for dashboards using tableau various charts and graphs.
• Extensive experience on building dashboards using Tableau and involved in requirements gathering/analysis, design (Mock ups, Proto types, frame works), development, testing and production rollover of reporting and Analysis projects.
• Having experience on various data analyzing techniques, reports efforts estimation, Reports development planning.

TECHNICAL SKILLS

SQL Developer: Tableau v7.x/8.x/9.x/10.x/ 2018.3/2019.3 , OBIEE v 10g/11g, SSRS, Oracle, Eloqua, Salesforce, Microsoft Office Suite, Microsoft SQL Server, Informatica, TOAD,SQL/PLSQL,Cloudera SQL, Mode Analytics, Postgre SQL,Python.

Data Modelling and schemas: Conceptual data model, logical data model, and physical data model.Star Schema, Snowflake Schema and Galaxy Schema.

Databases: Oracle, MS SQL Server, DB2, MS Access.

SQL Programming: SQL, T-SQL, PL/SQL.

Tools: SQL navigator, SQL developer, MS-Visio.

Programming Languages: Java, JavaML, C, Python.

PROFESSIONAL EXPERIENCE

Confidential, Rockville, MD

Lead Tableau Developer

Responsibilities:

• Project Scope: To analyze trends in patient payment metrics on teh basis of services provided point-of-services collections, patient receivable, registration accuracy and time to collect.
• Tested, Cleaned, and Standardized Data to meet teh business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments.
• Interacted wif Strategic Development Team, Business analyst and Nurse Managers to analyze business needs and developed technical specifications.
• Created lot of custom reports for teh pathologist using complex stored procedures and SSRS reports.
• Created Standard, Cross-tab, Sub reports and TAT reports for Pathology department management of Quest Diagnostics which was collaborated wif AHC.
• Created Batch Stored Procedures for in teh Report Scheduler according to teh monthly, weekly or daily.
• Developed Cognos Framework Manager Models, published packages on content stores, elevating reports from/to Dev/Test/Prod regions.
• Generated Tableau Dashboard wif quick/context/global filters, parameters and calculated fields on Tableau reports.
• Created Tableau Dashboards wif interactive views, trends and drill downs along wif user level security.
• Created and developed Parameterized, Drill Down and AD Hoc Reports using SQL Server 2008 Reports Services (SSRS)
• Interacted wif teh existing database developers and DBA to understand teh existing schema.
• Thorough analysis, unit testing and integrated testing wif other applications of database objects & T-SQL statements before deployment to teh production server.

Environment: Tableau Server and Desktop (8.3), Manual Testing and also by using TabJOlt, SQL Server Reporting Services 2012, Microsoft Office.

Confidential, Columbia, MD

Sr. SQL/Tableau Developer/ Analyst

Responsibilities:

• Confidential, N.A., is a United States national bank chartered and supervised by teh federal Office of teh Comptroller of teh Currency. Confidential offers banking, insurance, brokerage, and investment banking services in All over USA
• Responsibilities:
• Involved in Reviewing requirements and data sources form MS Excel and MS Access for design, development, testing, and production rollover of reporting and analysis projects wifin Tableau Desktop.
• Used Tableau Desktop for blending databases and creatingg different interactive views and dashboards.
• Developed reports based on Cognos Framework Manager metadata model’s queries/stored procedures and by writing direct manual sql queries in reports.
• Created extract files for improving teh performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Review Vendors Status Reports wif Project Team and created visualization for budget forecasting.
• Published views and dashboards in Tableau Server for auditor review.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that teh developed dashboards are displaying accurate and upto-date live data and sent those into production after editing.
• Involved in troubleshooting and performance tuning of reports and resolving issues wifin Tableau Server and Reports.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating wif stakeholders and business groups.

Environment: Tableau Desktop, Tableau Server, Oracle SQL Server, MS Excel, MS Access, Win Server 2008

Confidential, Massachusetts

SQL/Tableau Developer

Responsibilities:

• Design and creation of tables and stored procedures wif E-R diagrams.
• Writing teh stored procedures, checking teh code for efficiency using T-SQL.
• Created and maintained databases for development and testing environments using SQL Server.
• Write complex SQL queries and stored procedures to meet business requirements.
• Involved in designing, developing and testing of teh ETL (Extract, Transformation and Load) strategy to populate teh insurance data from various source systems feeds using SSIS.
• Worked wif star schema by building relationships between Fact Table and Dimension tables.
• Automate and schedule daily, weekly and monthly SSIS, SQL jobs using SQL server job agent.
• Provided on-call support for teh job failures in teh SQL Agent and rerun teh jobs post resolution.
• Responsible for checking databases, jobs, nightly backups on all servers and monitored system log, security log on Event Viewer.
• Cognos Framework Manager-enabling a multi developer environment using Creating Segment/ link Segment and Merge methods.
• Worked wif Business Analysts & Business stakeholders in gathering requirements and developing them into Tableau Dashboards and Reports.
• Developed and reviewed SQL queries wif use of join clauses in Tableau Desktop for validating static and dynamic parameters data for data validation.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that teh views and dashboards were displaying teh changed data accurately.
• Implemented autantication using Kerberos and Apache Sentry
• Performed ELT and analytics through Alteryx tool. Used GIT and SVN for code versioning.
• Worked on Agile development methodologies, tools, and processes. Participated in Scrum activity, Sprint Planning, Story Writing, Backlog Grooming, Mid Sprint Review and Project Road Map Design
• Developed Tableau dashboards/workbooks to display PCS summary reports, PCS playbook reports, FMU vs MLE distribution and Pending Exposure report to Business
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Developed visualizations like Bar, Bubble, Line, Area, Stacked Bar, Pie and Donuts charts. Created workbooks using calculated fields for different visualization requirements.
• Created and assisted users in Tableau dashboard development by providing various levels of Drill Down functionality to understand teh business in detail.
• Consistently attended meetings wif teh subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy teh business’s needs

Environment: MS SQL Server 2014/2016, T-SQL, SSIS (ETL), SQL Agent, Windows 2012 Servers, Alteryx, MS Excel and MS Access, Tableau, Jira.

Confidential, NY

SQL/Tableau Developer

Responsibilities:

• Understanding teh Business requirements, Application and function specifications, Design documents.
• Installation and configuration of Tableau Desktop in different environments DEV, STAGE and PROD.
• Worked on Revenue by Month and Year, customer sales by product group, third party forms revenue by month and year, Total sales.
• Performed Cognos admin tasks like installing and configuring teh Cognos Server and Framework Manager, Webserver, publishing teh packages from Framework Manager, importing teh packages and exporting teh packages, integrating Cognos BI application wif other applications.
• Building teh customized and interactive dashboards based on requirement.
• Implementation of teh data level and view level security, involved in developing teh Incremental ETL.
• BI Reporting Module Lead. Requirement gathering from functional team and designing of BI reporting framework
• Involved in reviewing business requirements and analyzing data sources from Flat file, Excel, Oracle for design, development, testing, and production rollover of reporting and analysis project wifin Tableau Desktop
• Developed various analytical reports from multiple data sources by blending data on a single worksheet.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets
• Created dashboards by extracting data from different sources using parameters and calculations
• Involved in creating Tree Map, Heat maps, background maps, calculated fields, mapping and hierarchies
• Involved in generating dual-axis bar chart, Pie chart and Bubble chart wif multiple measures and data blending in case of merging different sources
• Writing of SQL and PL SQL code based on reports and business requirement in Oracle DB
• Involved in Query Optimization task to increase overall performance of Report generation
• Being an Agile project actively contributed to planning sessions and story creations related to ETL and BI reporting.
• Performed Cognos admin tasks like installing and configuring teh Cognos Server and Framework Manager, Webserver, publishing teh packages from Framework Manager, importing teh packages and exporting teh packages, integrating Cognos BI application wif other applications.
• Created Various BI Publisher Reports on top of BI Answers and aligned them on various Dashboards as per teh requirement.
• Practiced backlog grooming, release and sprint planning, daily stand ups, impediment removal and conducted user acceptance testing.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that teh views and dashboards were displaying teh changed data accurately.

Environment: Tableau Desktop 9.0, Tableau Server, Jira.

Confidential

Tableau Developer

Responsibilities:

• Produced Executive Dashboards for teh company’s C-level leadership to provide insights into Product Performance, Partner Metrics, Discounting and Marketing Pipeline.
• Performed data/systems analysis to determine best BI solution (reports, dashboards, scorecards etc.) using Tableau 10.x
• Implemented Dashboards using Tableau for Sales Finance enabling Executives’ 360 view into business.
• Drove team's adoption of tool to help streamline common reporting elements across organization.
• Created new Data source and replaced wif existed Data source. Created Schedules and Extracted teh data into Tableau Data Engine.
• Drove initiative in adoption of Tableau in Sales Finance Organization.
• Worked wif Strategy team to build various Portfolio metrics that helps drive their Quarter end reporting and understand key highlights and lowlights of business wifin each quarter.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• 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.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Preparing Dashboards using calculations, parameters in Tableau.
• Designed and Tested Reports in teh Dashboards for Financial Analytics and created Ad-hoc reports according to teh client needs.

Environment: Tableau Desktop 9.0, Tableau Server, Jira.