SUMMARY:

• Over 7 years of IT experience as a Tableau and SSRS Developer in various Industry verticals like Financial Services, Health Care, Insurance and Service.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Tableau desktop report
• Experience in Installation, Configuration and administration of Tableau Server in a multi - server and multi-tier environment.
• Extensive experience on building Interactive dashboards using Tableau.
• Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.
• Established Best Practices for Enterprise Tableau Environment and application intake and development processes.
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms.
• Expert knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS
• Expert in developing Drill through and Drill down reports using MS SQL Server Reporting Services (SSRS)
• Quick learner, excellent communication skills and good performer both in team and independent job environments. Never missed the deadline of any projects.
• Maintained positive communications and working relationships at all business levels.

TECHNICAL SKILLS:

Reporting Tools: Tableau 9.0, 8.2 and 7.0, SSRS

Databases: MS SQL Server 2005 to 2012, Oracle 11g,10g, MS Access

ETL Tools: SSIS, Informatica

Programming Languages: T-SQL, PL/SQL, C#, VB 6.0, Python, VBA, R

Scripting Languages: VB Script, Java Script

Operating Systems: Windows, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Tableau Developer

Responsibilities:

• Experience in CCAR/DFAST or regulatory reporting.
• Analyzing and Developing Most Critical Stress Test Reports(CCAR/DFAST)
• The Project Involved Pre, During and Post activities of the report development
• Continuous Engagement with ALM (Asset and Liability Management) team to gather the requirements for the reports.
• Work Closely with the ETL team to get the required data. Extensively using Toad for querying and analyzing the data.
• Manipulate and extract relevant information for analytical purposes and identify address data quality gaps.
• Interact with business users to gather requirements and provided guidance for the Data Warehouse team in how to structure data for optimal use in Tableau.
• Taking a part of Business Analyst Role by Identifying the requirements and Capturing the requirements in Report Requirement Document.
• Developing End to End Reports useful for predictive analysis
• Using Custom SQL for joining the tables, and selecting the required Data.
• Build complex formulas in Tableau for various business calculations.
• Efficiently build the reports which caters the reporting requirement for different business lines such as Mortgage, Credit Card, Debit card, Asset Management, etc.
• Working closely in the project team with Business Analysts, ETL and Project Manager and update daily status in the Daily Scrums.
• Automate and simplify self-service support for internal business clients.
• Test reports to ensure accuracy, remediate defects and developed rollout plan with business partners.
• Technology Point of contact for UAT (User Acceptance Test), Helping the users understand the reports and also fixing the issues which were found in UAT.
• Updating the HP ALM with the comments and issue resolve status.
• Migrate content from Development to QA to Production Environment.
• Supporting the production and also handle the ad-hoc reports.
• Support user questions, and create enhancements to existing reports and capabilities in alignment with business needs.
• Create extensive joins for data blending from several different data sources.
• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics.
• Experience in working with Tableau Desktop and Tableau Server.
• Experience in creating Dashboards using Table calculations, Logical calculations, number calculations and creating parameters.
• Experience in creating Different maps, dual axis charts.

Environment:, Tableau 9.0, Tableau Server, Oracle Database 11g, Toad, Rapid SQL 8.6.0, HP ALM, SharePoint, MS Excel 2010.

Confidential, Greeley, CO

Tableau Developer

Responsibilities:

• Participate in the user requirement gathering and Design meetings. Translate business needs into reporting and analytic requirements.
• Created calculations including string manipulation, advanced arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations.
• Representing data using various visualization types: crosstabs - scatter plots, geographic maps - pie and bar charts, motion charts - small multiples, heat maps - density charts, tree maps - highlight tables, different mark types on dual axis/combo charts, drill down/drill across on dashboards.
• Built advanced chart types and visualizations: bar in bar charts - bullet graphs - pareto charts, build complex calculations to manipulate data, using statistical techniques to analyze data, using parameters and input controls to give users control over certain values, implement advanced geographic mapping techniques.
• Used statistical techniques to describe data Using groups, bins, hierarchies, sorts, sets, and filters to create focused and effective visualizations.
• Worked on the development of Dashboard reports for Key Performance Indicators for the top management
• Utilized Measure Name and Measure Value fields to create visualizations with multiple measures and dimensions.
• Handled changes in data source such as field addition, deletion or name changes.
• Combine visualizations into interactive dashboards and publish them to the web. Sharing visualizations with business users.
• Performed multiple server installation of Tableau Servers.
• Configured a single server installation, administer content, users, groups, and the data server, administer security and permissions, administer sites in tableau server, tasks and create extracts, embed views, perform basic administration
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.

Environment: Tableau Desktop, Tableau Server 8.2, Oracle Database 10g, HP ALM 11.0, MS Excel 2010.

Confidential, Seattle, WA

Responsibilities:

• Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications
• Designed various practical Data Visualizations, Charts, Dashboards, Prototypes and Demos, published it in various Tableau workbooks for Confidential Analytical Projects and Data Visualization teams
• Creation of user, groups, folder structures, library and repository Tableau server logons and security checks.
• Creating New Schedules and checking the tasks daily on the server maintaining server activities, user activity, and customized views on Server Analysis.
• Create Data Extracts connecting to Teradata database, writing Free hand SQL Using SQL assistant.
• Created Complex workbooks and Dashboards by connecting to multiple data source using data blending.
• Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server
• Designed and implemented near-real-time monitoring Dashboards for Tableau Server and Visualization users
• Designed and developed monthly, quarterly and yearly reports at branch and bank level.
• Involved in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Monitored the overall performance of the database to recommend and initiate actions to improve/ optimize performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Helped create process logging and new monitoring tools, integrity reports, and mapping tools.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

Environment: Tableau Desktop, Tableau Reader, Tableau Public, Tableau Server 7/8.2, SQL Server 2012, MS Excel 2007.

Confidential, Hartford, CT

SSRS Developer

Responsibilities:

• Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
• Successfully installed and configured MS SQL Server2008R2 on the development server.
• Automated the migration of data from Flat file to MS SQL Server 2008R2 DB using Microsoft SQL Server Migration Assistant (SSMA).
• Generated assessment reports to analyze the scope and complexity of the migration projects.
• Designed a new schema design for the data warehouse using dimensional modeling and developed it using the Erwin tool.
• Migrated the entire schema as well as data into MS SQL Server 2008 and also validated the migration process to ensure that it has been successfully migrated.
• Created SSIS packages to load data from the OLTP system to a Data mart for analyzing data.
• Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Responsible for Deployment of the report using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
• Defined referential relationships with the measure groups and fact tables.
• Generated automatically grouping attribute members and implemented the calculations to aggregate physical measures.
• Defined granularity within measure group and drill through actions.
• Created cube reports that can be browsed at summary level and can be drilled down to the detail level.
• Defined the browsing perspectives and browsing translations since most transactions were online.
• Documented the development work and production release for future reference.

Environment: MS SQL Server 2008R2, SSIS 2008, T-SQL, MS Access 2007.

Confidential, Great Neck, NY

SSRS Developer

Responsibilities:

• Involved in all the phases of SDLC.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various types of Constraints and Triggers for Data Consistency.
• Used Stored Procedures for updating Servers.
• Used DDL and DML Triggers, Stored procedures to check the Data Integrity and verification at early stages before calling them.
• Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Data Ware House.
• Developed, deployed and monitored SSIS Packages. Involved in creating log files for SSIS packages.
• Created SSIS Package configurations for executing in different environments.
• Enabled Check points in SSIS package. Created break points in order to view the status of data, variables and over all status of SSIS package.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Developed and Deployed different types of Reports like List, Matrix, and Chart and Sub Reports etc.
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created/ Maintained clustered/ non clustered Indexes for fast and efficient reporting process.
• Used SSRS to create interactive reports with an ability to drill down into details.

Environment: MS SQL Server 2008, SSIS, SSRS, T-SQL, Visual Studio 2005, MS Office 2003.

Data Analyst

Confidential, Olympia, WA

Responsibilities:

• Defined and designed the data sourcing and data flows, data quality analysis.
• Identified the data source and defined them to build the data source views.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
• Developed and deployed SSIS packages to load the data from OLTP to DWS.
• Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Used SQL Server Agent to automate the SSIS package execution.
• Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS and then created reports using this data using SSRS.
• Configured and maintained Report Manager and Report Server for SSRS.
• Identified and added the report parameters and created the reports based on the requirements using SSRS.

Environment: MS SQL Server 2005, MS SSRS, MS SSIS, T- SQL, MS office 2003.