SUMMARY:

• Highly motivated Database Analyst & Developer, with aptitude to explore and implement new features and capabilities in Business Intelligence. Over 8 years of experience in performing various roles on both Technical and Functional aspects of providing Business Intelligence solutions and has been a part of numerous End - to-End Data Warehousing assignments. Has strong knowledge of OLAP and OLTP systems, with extensive experience in using Dimensional Data Modeling and Relational Data Modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & Logical Data Modeling for designing Data Warehouse / DataMarts.
• Over 8+ years of strong experience in Data warehousing and Business Intelligence technologies with strong experience of data visualization using Tableau and experience in delivering key technologies in data design and ETL.
• 5+ years of extensive experience working with Business Intelligence data visualization tools with specialization on Tableau as both Admin and developer.
• Extensive experience inTableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6, Tableau 7 and Tableau 8, 9.X
• Very good experience on using Tableau functionalities for creating different Reports, Interactive Dashboards with page and dashboard Prompts.
• Ability to support multi environment Tableau infrastructure including server security troubleshooting and general system maintenance
• Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to- end change impact analysis.
• Extracted data from SQL Server into data marts, views, and/or flat files for Tableau workbook consumption using T-SQL. Strong DW- BI skills and SQL skills.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server 2005 Reporting Services (SSRS).
• Experience In extracting from heterogeneous sources, transformation of data modifying, and end to end transformation to heterogeneous destination as a source of data (SSIS)
• Experience in developing visualization features/designs most appropriate to data and analysis needs of business user’s which include data cubing and analyzing the data (SSAS)
• Good experience in performing various roles on both Technical and Functional aspects of providing Business Intelligence solutions and has been a part of numerous End-to- End Data Warehousing assignments.
• In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
• Developing reports on SSAS & SSRS on SQL Server (2000/2005/2008/2008 R2/2012), Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
• Migration experience with DTS to SSIS 2008.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL join’s and statements for applications.
• Involved in creation and updates of several SQLIndex, Views, Complex Stored Procedures, triggersand appropriateUser defined functions.
• Has strong knowledge of OLAP and OLTP systems, with extensive experience in using Dimensional Data Modeling and Relational Data Modeling.
• Strong influence management skills, reporting and analytical/problem solving skills with attention to detail.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS:

Operating Systems: MS-DOS, MS Windows 9X, 2000, XP.

Business Intelligence Tools: Tableau Desktop, Tableau Server, Web Intelligence, Informatica, Data stage, SQL, Transact SQL, PL/SQL, Embedded SQL, Microsoft SSIS, SSRS, SSAS

Databases: MS SQL Server 2005/2008, DB2, MS Access, Netezza, Teradata,Tableau server browser-based analytics

ETL Tools: Informatica 9.6/9.1/8.6/8.5.1 (Power Center/Power Mart) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect)

Languages: C, C++, Core Java

Software Methodologies: Waterfall, Agile and Scrum Models.

Cloud Technologies: Amazon Redshift, RDS,S3, Glacier, AWS storage Gateway and Amazonworkspaces

OLAP Tools: Microstrategy, Business Objects, MS Analysis Services, Informatica

Management and Project Tools: MS Word, Excel, Project, Visio and Access, Rational Team Concert

PROFESSIONAL EXPERIENCE:

Confidential, CT

Tableau Developer

Responsibilities:

• Project primarily concentrated on Risk reporting/analytics in the key financial risks faced by Auto finance including Credit risk, Prepayment risk, Liquidity risk & ALM, Market risk etc.
• Successfully create deliverables in Tableau 9.x and make several of the visualizations and reports created live across the organization
• Partner with business managers and analysts to understand requirements, source systems, and perform data analysis, explore and work towards presenting data to business by identifying and highlighting insights using Tableau Stories.
• Perform Tableau Serveradmin duties; add users/groups from Active Directory; and schedule instances in

  Tableau Server including weekly data dump.

• Train the Business and other Users to interact and develop adhoc reports using Tableau and facilitate the presentations during business meetings.
• Developed Tableau data visualization using Pareto’s, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
• Interacted and worked with ETL team for improving performance on data from multiple data sources Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Developed Tableau reports for orders, played key role in monitoring Tableau servers, analyze and recommendinfrastructure sizing including hardware and software requirements
• Tableau development lifecycle from gathering requirements and designing solutions, through developing code
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Metrics, Filters, Prompts to achieve the functionality of the canned reports and created advanced objects like Derived Metrics, Compound Metrics.
• Developed MicroStrategy Dynamic Dashboards in the Flash Mode using several controls and worked extensively on widgets.
• Configured Enterprise Manger and developed customized reports to depict the usage and performance of reports, User activity and Cache analysis.
• Created Tableau info graphics detailing key topics and concerns raised by various customers segments in the survey
• Involved in analyzing the user requirements and transform them intoTableauDashboards and Reports.
• Involved in designing and creating Dimensional Data model (Star schema) for Dodge Global Network application and ENR Survey reports.
• Created detailed Spotfire reportingsolutions for production analysis using bar charts, combination charts, pie charts, tree maps, heat maps and map chart visualizations.
• Worked with CIO of the organization in gathering the requirements to create Project/User Usage Executive Dashboards, reports for Sales Executives.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures ( KPI ) and Measure
• Experience with QlikView sheet objects Pivot, List, Multi box, multiple charts types, KPI’s, custom requests for Excel Export, Fast Change and objects for Management Dashboard reporting.
• Configuring AWS platform with Tableau 9.0 to visualize mortgage automobile insurance data for clear analysis.
• Work as part of a team to see projects through from planning to completion for various enterprise clients using the Agile development process.
• Involved in the complete process cycle; functional skills in analyzing the client requirements: translating new ideas into client-specific solutions using opportunity identification, requirements development, delivery, support, analysis and quick learner.

Environment: Tableau Server 9.2/8.1/8.2, Tableau Desktop 9.2/8.1/8.2, Windows Server Standard R2, Excel, SQL Server management studio, MicroStrategy 9/8.1, MS SQL Server 2008R2, UNIX .

Confidential, Atlanta, GA

Business Intelligence Developer / Tableau Developer

Responsibilities:

• Designed and implemented an interactive Accountability Dashboard of university performance information for use by the general public on web browsers and mobile devices. The consultant will also develop a written plan for converting other existing data-rich publications into interactive online visualizations.
• Created high-quality, intuitive visualizations and dashboards with Tableau Desktop
• Developed efficient workflows that in corporate existing data from relational databases, Excel, and other sources
• Integrated Tableau server in to AWS using IPN VPV Modules to create modules and analyze the data.
• Experienced in Amazon EC2 setting up instances, virtual private cloud (VPCs), and security groups
• Tableau server for AWS is browser publishes interactive dashboards with Tableau desktop and sharing.
• Identified data in Oracle databases, Excel, SAS and other sources and restructure to use in Tableau for creating Visualization
• Utilized Process SQL in SAS to redefine the data structure and aggregate the data to use in Tableau for creating Visualization
• Designed new Oracle tables and views as needed
• Designed a dashboard with multiple accountability and performance indicators grouped at multiple levels and linked in multiple ways
• Involved in Upgrade of MicroStrategy environment from 8.1 to 9
• Created Subscription sets, documents, publications and services for delivery of reports through Narrowcast.
• Validated end user requirements using Microstrategy tools.
• Created Question Objects for Personalized execution.
• Drive Tableau adoption, provide office hours and one-on-one in TableauDesktop, reorganize enterprise-wide Tableau Server Infrastructure, and champion the development life cycle.
• Worked as user and administrator functions of Tableau Public/Public Premium and Tableau Online
• Presented design alternatives to stakeholders, help clarify requirements, and conduct demos
• Created complex calculative fields using functions available to meet the client requirements for different dashboards
• Created informative visualizations that intuitively display large amounts of data and/or complex relationships
• Used Dual Axes, lines, Trend lines to show their trends over 30 years of services
• Coordinated database middleware issues with DAB system, system performance with System Architects.
• Created incremental refreshes for data sources on Tableau server.
• Tableau Desktop Qualified Associate business intelligence and analytics
• Converted existing Crystal Reports and Xcelsius into Tableau Dashboards
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.

Environment: Tableau 8.2, Tableau 8.3, Tableau 9, Tableau Public, Tableau Online, Oracle, Word press, SAS, MicroStrategy 9/8.1

Confidential, Naperville, IL

Tableau BI Developer

Responsibilities:

• Created and Maintained of Business Intelligence Reports, Dashboards Design and Development,
• Reviewed, assessed and promoted adoption and standardization of Tableau support solutions across Corporate
• Worked primarily as the Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution designed, developed and supported BI solutions
• Involved in Debugging and monitoring, and troubleshooting issues/tickets.
• Created reports for different business user groups like Sales, Marketing etc
• Created reports with graphical representation using Shapes as shown below to indicate the profit or loss percentage which helps user understand easily.
• Used Dual Axes, lines, Trend lines to show their sales growth
• Created Pareto analysis to determine the root cause and take preventive actions against the causes.
• Created Data Hierarchy in the data window
• Created calculative fields using functions available in order to different metrics as per the requirements
• Utilized annotations where ever possible.
• Prepared financial presentations and forecasts and analyzes trends (leading and lagging indicators)
• Converted Brio reports in to Tableau reports and fixed all the issues related to the conversion.
• Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data.

Environment: Tableau 8.1, SQL Server, Business Objects

Confidential, San Francisco, CA

Tableau Developer

Responsibilities:

• Created dashboards according to user specifications and prepared stories to provide an understandable visions and worked with the design team.
• Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Participated in building and visualizing dashboards using Tableau Desktop.
• Used Tableau visualization software to generate Tableau combination dashboards.
• Created views inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
• Projected and forecastedfuture growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on whichstates were connected the most.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blendeddata frommultiple databases into one report by selecting primary keysfrom each databasefor data validation.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
• Scheduled data refresh onTableauServer for weeklyand monthlyincrementsbased on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users after repeated requirements elicitation.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Published developed dashboard, reports on theTableauServer so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Proof-read all documents and maintain accuracy of information.
• Responsible for Developing a Dashboard and preparing ad-Hoc Reporting.

Environment: TableauDesktop 7.0/8.1,TableauServer,MS Office Suite,Oracle SQL ServerR2, MS Excel

Confidential

Business Data Analyst/Business Intelligence Analyst

Responsibilities:

• Collaborate with business and IT to define and manage project scope. Manage requirements throughout the SDLC.
• Collaborate with Project Managers to manage business partner expectations.
• Plan business analysis activities. Develop estimates for business analysis tasks. Accountable for managing to those estimates.
• Elicit requirements using techniques such as interviews, workshops, working sessions, and/or existing systems documentation or procedures.
• Analyze and document business requirements for business requests while using industry standard analysis techniques such as business process modeling, data flow modeling, workflow analysis, functional decomposition analysis and business rules definition.
• Understand and apply Financial and Corporate IT standards, designs and documentation standards into the recommended project artifacts.
• Requirement gathering - Solution design.
• Served as a liaison between business team and the project team by assisting the business in Identifying, understanding, and documenting their business need.
• Collected and documented Business Processes as well as Business Rules.
• Worked closely with different departments to improve the efficiency of the existing systems in place.
• Participated in various stages of data and requirement analysis for project needs.
• Involved in developing a comprehensive system Test Plan and created the Test Cases.
• Reviewed the Customer Requirements Specifications and developed end to end Test cases using Microsoft Word.
• Worked with the team to define and design test objectives and additionally, collaborated to formulate effective test documentation.
• Designed DDL and DML for MS SQL Server 2000
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Optimize query performance by creating indexes.
• Involved in writing SQL batch scripts.

Confidential

SQL Server SSIS/SSRS Developer

Responsibilities:

• Interacted with Business Users and Analyzed user requirements and built reporting solutions such as relational database reports, OLAP reporting, dashboards, and scorecards.
• Involved in the dimensional modelling of Data warehouse using Erwin tool
• Created complex T-SQL Queries, Stored Procedures, Indexes, Functions and, Views to support efficient data storage and manipulation
• Used joins and sub queries to simplify complex queries involving multiple tables.
• Provided technical support to move databases from development to test and production for multiple applications.
• Experienced in slowly changing dimension in SSIS packages.
• Created SSIS packages to transfer XML file data into SQL server database.
• Used SSIS and extract transform loading (ETL) tool of SQL Server to populate data from various data
• Implemented Error Logging using Event Handlers and also implemented logging in SSIS Packages
• Created dynamic Package Configuration of type SQL Server table.
• Developed Query for generating Drill Down and Drill through Reports in SSRS 2008(R2)
• Designed and formatted SSRS Reports using Parameters and Expressions for the Reports.
• Automated the execution of SSRS reports using Subscriptions and Data-Driven Subscriptions.
• Deployed SSRS reports to Share Point Sever 2010 and also configured SSRS 2008 to Share Point Integration mode.
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Involved in Analyzing, designing, building of OLAP cubes with SSAS 2008(R2) Identified and defined Fact relationships in SSAS
• Worked on PERFORMANCE POINT SERVER to build advanced KPI’s for the cubes
• Involved in Optimization and Performance of queries and stored procedures using SQL Execution Plan
• Created SSIS package to check XML file validation and data validation to match the requirements.

Environment: Erwin, SQL Server 2005, MS Server Integration services, SSRS (MS server Reporting Services), MS SSAS, Window 2007 Server, Crystal Reports, Share Point Server 2007,VB.net.