• Qualified professional has 9 years of extensive IT Experience in Data Warehousing and Business Intelligence applications in Banking, Financial Services, Property and Causality Insurance.
• Proficient in Tableau 7.x/8.x Desktop, Server , Micro Strategy 9.x/8.x Desktop, Intelligence Server, Narrowcast Server
• Proficient in Database Design, Development, Implementation and administration of SQLSERVER 2012/2008R2/2008/2005 and providing ETL/Business Intelligence solutions using Microsoft components
• Proficient in data blending using Alteryx
• 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.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• Worked with, charts, bars, images and dynamic reports.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Created sheet selector to accommodate multiple chart types like Panel charts, Bullet charts and Stack bars etc. In a single dashboard by using parameters.
• Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs using Erwin Star and Snowflake Schemas, and Expert in modeling Transactional Databases and Data Warehouse.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Good Knowledge in Oracle, SQL Server, Informatica, SSIS, SSRS, SSAS, Microsoft Office Suite.
• Proficient in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursor
• Proficient Star Schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies and facts.
• Posses' strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization, views, cursors and resolving key performance issues.
• Well-versed in usage of SSIS Control Flow items tasks and containers and SSIS Data Flow items sources, transformations and destinations .
• Proficiency in creating different types of reports such as Cross-Tab, Chart, Conditional, Drill-down, Summary, Form and sub reports, and formatting them.
• Experience in developing OLAP cubes using SSAS and identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services SSAS 2012/2008R2 .
• Coordinated Technical Reviews, developed System requirements. Developed test requirements, test plans, scripts, test conditions and test data. Supported status reporting and test execution for Unit testing, Integration testing, System testing, Regression testing, and User Acceptance Testing UAT .
• Adept in analyzing bugs, interacting with team members in fixing errors and UAT and also assisted in Post Production support.
• Strong influence management skills, reporting and analytical/problem solving skills with attention to detail.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities

Confidential

Tableau Developer/ Admin

Responsibilities:

• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Worked with DBAs to design and implement Conceptual data model, Physical Data Model, SSIS mappings and workflows to meet business requirements
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Worked with Source system Subject Matter Expert SME to ensure that the extracts are properly mapped.
• Extensively used Alteryx for data blending.
• Worked on the backend SSAS cube development which was the source data for the tableau.
• Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modeling.
• Deployment of tableau by laying the architecture and using suitable deployment model and creating security levels for users, looking after the system administration, ensuring the best practices for optimal use of the system.
• Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Worked with, charts, bars, images and dynamic reports.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Created sheet selector to accommodate multiple chart types like Panel charts, Bullet charts and Stack bars etc. In a single dashboard by using parameters.
• Used MDX queries to create the calculated members in Tableau
• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Used Sql Queries at the custom Sql level to pull the data in tableau desktop and validated the results in Tableau by running Sql queries in Sql developer.
• Attended daily standup meetings to update scrum master with what is achieved, what is being done and is there any impediment.
• Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters.
• Created and maintained issue log where business users enter their feedback by working on dashboard in test environment. Implemented the feedback and incorporated the necessary changes.
• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created tableau functional design document.
• Participated in the retrospective meetings and next sprint planning meetings.

Environment: Tableau desktop 8.1/8.2, Microsoft SQL Server, SSIS,SSAS,SQL,MDX, Salesforce.

Confidential

Tableau Developer / Server

Responsibilities

• Migrated all the reports, dashboards, scorecards from Tableau 7.0 to Tableau 8.0 after testing the version on Sand Box.
• Worked on drill through reports by creating HTML references.
• Developed customized calculations when required.
• Used geographic view which clearly gives the performance of a particular state.
• Creating and modifying Business Intelligence analytical reports using Tableau by connecting to different data sources like sales force, Bigdata, Teradata.
• Analyzed dimensional and fact tables in a campaign data mart that details Inclusion, exclusion and Segmentation criteria, Offer assignment and campaign response by campaign.
• Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends at various geographic locations.
• Created various actions in database like filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

Environment: Tableau 7.0/8.0, Teradata 13.10 , Teradata SQL Assistant, Teradata Administrator, SQL, Share Point, Agile-Scrum, Informatica , CA Service Manager, UNIX, MS VISIO, Microsoft Office Suite.

Confidential

Senior SQL Developer

Responsibilities:

• Analyzing the system design of the Enterprise data warehouse implementation
• Developed complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Created various database tables and procedures to update and clean the old data.
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications
• Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Involved in conversion of DTS to SSIS packages and troubleshooting the migration issues.
• Built the interfaces to integrate data between the PAS application and the third party vendors using XML, XSD, XSLT and BIDS.
• Involved in designing high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse with different transformations in order to get the accurate data using SSIS 2008 and deployed the SSIS packages to different environments by maintaining the configuration settings in the XML files and variables.
• Developed SSIS Packages to extract data from Excel spreadsheets, Microsoft Access database and flat files, load them onto SQL server 2008 for Data Analysis and Reporting by using multiple data flow transformations such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Developed Custom Selection of reports ordering using SQL Server Reporting Services SSRS .
• Created Tabular reports, Matrix reports, List Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Developed and integrated complex stored procedures to generate the special reports according to client's need.
• Developed OLAP cubes using SSAS and calculate the metrics that were revealed in the functional analysis.
• Created MDX script for representing Cube Calculation using SSAS.
• Interacted with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance

Environment: SQL Server 2008R2, T-SQL SSIS, SSRS, SSAS, XML, XSLT, Team Foundation Server, SQL Server management studio, BIDS ,DB Visualizer, HP Quality Center, Mainframes, UNIX, PUTTY

Confidential

SQL Developer

Responsibilities:

• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSIS.
• Expert in using BCP and Bulk Insert, FTP Task.
• Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading ETL .
• Worked on a package Migration wizard in SQL Server 2005 to migrate DTS Packages to SSIS, SSIS Package Configuration, Passing variables dynamically and used SSIS Logging.
• Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Developed various SSRS reports for business users.
• Responsible for full Report Cycle including Authoring, Managing, Security and Generation of reports.
• Involved in building a strategy for star schema with fact and dimension Tables.
• Involved in creating entity relational and dimensional relational data models using the Visio Data Modeling tool and participated in designing of Logical and Physical Architecture database.
• Extensively used joins and sub-queries to simplify complex queries involving multiple tables, addition of new columns, triggers and configured IIS and Worked on Index tuning, stored procedure tuning.
• Created Stored Procedures for Batch Processing and Wrote T- SQL codes for the project.
• Extensively used XML documents to pass multiple parameters for Stored Procedures to read and write database table.
• Designed XML Documents and generated XML documents from Tables.
• Worked in Database Security, Replication and Log Shipping activities.

Environment: SQL Server 2005, T-SQL, SSIS, SSRS, MS Access, MS Excel, SAS, Visio 2007,DB2, Xpeditor, File-aid.