SUMMARY

• Around 7 years’ experience in Data Analysis, Data Design and Data Visualization, Data warehouse, Tableau /BI developer.
• Proficient in Tableau 10.x/9.x/8.x/7.x (Desktop, Server, Public) as Developer.
• Experience in Data quality, Data organization, Metadata, and Data profiling. Involved technical support on data warehouse teams. Demonstrated ability to move from one sequential assignment to the next.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other Local and Global filters according to the end user requirement.
• Good Experience in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Extensive experience in creating navigation links with in Interactive Dashboards and implementing interactive charts.
• Expert in Preparing dashboards using calculated (Table Calculations, Hide Columns, Creating/Using Parameter, Totals) fields and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding parameters, calculations, groups, sets and hierarchies in Tableau.
• Experienced in client requirement Analysis, Physical, Logical design, development (using normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2008/2005/2000 , DTS, SSIS, SSAS and SSRS 2005/2008/2010.
• Experience in creating dashboards with relational and multi-dimensional databases including SQL, MS Access at gathering and manipulating data from various sources.
• Expertise in Teradata 13.10, Oracle 9i/10g/11g, SQL Server, Informatica, SSRS, SSAS, UNIX, Microsoft Office, PL SQL Suite.
• Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, etc.
• Excellent Knowledge in Data Warehouse Concepts, Data Modeling, ETL and worked on OLTP & OLAP in all environment which includes development (DEV), test (QA) and production (PROD).
• Created ad-hoc SQL queries for customer reports and executive management reports
• Good in creating Reports that include Filters, Charts, Scorecards, Drilldown and Drill Through.
• Experience in local and global filters and Data blending, Data extraction, Data integration, Data modeling and Data rendering in Tableau.
• Strong database knowledge of SQL, stored procedures and triggers. Master SQL skills and ability to troubleshoot. Created and maintained complex SQL queries for specific reports.
• Proficient in SSIS to develop Crystal Reports for extracting, cleaning, transforming and loading data into warehouse.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, Merge, Merge Join, SQL task, Script Task and Send Mail Task to generate various Crystal Reports.
• Worked with ETL process to Extract, Transform and Load the data into stage area and data warehouse. Created ETL mapping documents to outline date flow from source to target system.
• Proficient in designing of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Experienced with multiple Relational Databases including Oracle 9i/10g, MS SQL Server and DB2.
• Excellent knowledge on writing complex SQL queries, stored procedures, functions, views, cursors, Indexes and performing fine tuning in query side and database aspects.
• Outstanding Data analysis and management skills, reporting and problem-solving skills.
• Experience in Performance tuning of Targets, Sources, Mappings and Sessions.
• Gathering Business Requirement, Interacting with Project Manager and the Users for better understanding of the process.

TECHNICAL SKILLS

Reporting tools: Tableau Desktop 10.4/10.1/9.2/8.3/7 , Tableau Server /10.18.2, SSIS, Crystal ReportsPower BI, Business Objects 4.1/XIR3/R 2/6.5/6.0/5.1

Programming Languages: SQL, TSQL, PL/SQL, Java, JavaScript, HTML, XML, CSS, C and C++, R- programming, Python

Operating Systems: UNIX, Linux and Windows

Related Skills: MS Visio, Power Designer, Excel, version control, SQL Navigator, ER Diagrams, Conceptual, Logical & physical modeling, MapReduce

Data Warehousing ETL Tools: Informatic Power Center 6.2/7.1/8.6/9.5 , SSIS, Business Objects Data services

RDBMS: Oracle 9i/10g/11g, SQL Server 2000/05/08, MS SQL Server, Teradata, PL SQL, Toad, Sybase12.x/11.x, IBM DB2, MS Access

Methodologies: Agile Modeling, Scrum Model, SDLC model, Waterfall model

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Tableau Developer

Responsibilities:

• Analyzed and understood the process flow to provide solution for the proposed requirement change.
• Identified the area of the code where the fix needs to be done and prepared necessary technical development documents and analytical reports to help users to identify critical KPI's.
• Provided fix for a dataflow which was successfully implemented and accepted by the business.
• Designed standardized DataMart with aggregated data, calculated metrics to suffice the source data need for various Tableau Reports and worked with ETL developers, DBAs, Data Modelers to implement the same in Development, Test and Production environment.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server, creating new schedules and checking the tasks daily on the server.
• Used Tableau to create visual interactive dashboards using calculations, parameters and workbooks for decision making to identify critical KPI's and helped them in finding keen insights.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Writing various queries to pull the data required to verify the Metrics calculations from backend.
• Successfully extracted data and completed data conversion for legacy systems.
• Performed rigorous unit testing for the code change in development and stage environments.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports by coordinating with senior managers in emergency.
• Given /demos to users on Tableau Desktop for development.
• Included finalized model from data mining team to OLAP cubes created by real-time data to test the efficiency of the model.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization and analyzed in each schema file.
• Created Data Connections, Published on Tableau Server for usage with Operational or Monitoring Dashboards and have experience in installation and maintenance of Tableau Server.
• Analyzed and resolved key performance and server-based issues on regular basis.
• Documented interactive dashboards by combination of views and reports and created crosstabs, conditional, drill down, summery, sub reports, parameterized.
• Conducted data analysis using interactive Excel features.
• Implemented table partitioning to maintain performance levels to speed up loading and archiving.
• Evaluated database performance issues and executed database optimization.
• Developed SQL scripts to create database objects like Tables, Views and Sequences and created PL/SQL Procedures, Functions and Packages.

Environment: Oracle 11g Ex, Windows 7, Tableau Desktop 10.4, Tableau Server 10.4, Informatica 9.6, Java Script API, MS Office Suite (Word, Excel, PowerPoint)

Confidential - Menomonee, WI

Tableau Developer

Responsibilities:

• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development.
• Experience with the technologies like, Hadoop, SQL in writing custom SQL and working with large data sets and optimize performance within Tableau.
• Responsible for creating reporting data model as per the requirements. Experienced in constructing UX (User Experience) frameworks for desktop and mobile platforms.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data from various sources to various destinations.
• Developed assisting users in creating and modifying worksheets and data visualization dashboards.
• Understanding of relational database structures, theories, principles, and practices.
• Expert in creating a dual-axis bar chart with multiple measures.
• Extensively involved in creating graphs and charts by using measures and dimensions data from various databases by using joins and blending.
• Advanced Tableau experience from dashboard design and development. Expertized with use of action filters, user filters, advanced navigation techniques, Level-of-Detail (LOD) expressions
• Blended data from multiple databases into one report from each database for data validation.
• Preparing Dashboards using calculations, parameters, groups, sets, filters in Tableau.
• Installed and configuredTableaudesktop 9.0 along with silent mode features and migratedTableau reports from 8.3 to 9.0 Version.
• Worked on several projects in parallel and Build the Dashboards in Agile Approach and utilized offshore team for the Dashboard build and deploying them into the servers.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems to effectively develop technical solutions to their requirement and partnered with other developers to ensure full understanding of needs.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Published dashboards to Tableau server.
• Created Relationships, actions, calculated fields, sorting, groupings, live connections, in-memory in bothtableauand Excel.
• Involved in testing the SQL Scripts for report development,Tableaureports, Dashboards, Scorecards and handled the performance issues effectively.
• Worked with the customers to resolve various issues associated with the reports.

Environment: TableauServer,TableauDesktop, MYSQL Server, Informatica 9.1, SSIS, Excel, TSQL, UNIX, Hadoop, SQL, Visual Studio

Confidential - Miami, FL

Tableau Developer

Responsibilities:

• Served as Business Systems Analyst meeting deadlines and budget requirements.
• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Followed Agile Methodology, Adherence to the Agile Scrum Methodology.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• 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.
• Analyzed dimensional and fact tables in a campaign data mart that details Inclusion, exclusion and Segmentation criteria, Offer assignment and campaign response by campaign.
• Creating and modifying Business Intelligence analytical reports using Tableau.
• Used geographic view which clearly gives the performance of a state.
• Developed customized calculations when required.
• Worked on drill through reports by creating HTML s.
• Migrated all the reports, dashboards, scorecards from Tableau 7.0 to Tableau 8.0 after testing the version on Sand Box.
• 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.
• 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, forecast sales, and to track existing customer sales.
• 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.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report and leaving no room for performance degradation.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks and assessed data for accuracy and other statistically unique values.
• 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: TableauServer,TableauDesktop, Teradata, Teradata SQL Assistant, Teradata Administrator, SQL, Share Point, Agile-Scrum, Informatic, Autosys, CA Service Manager, UNIX, MS VISIO, Microsoft Office Suite.

Confidential

BI Developer

Responsibilities:

• Actively worked with Business Partners and Designers to get the Requirements and create High Level Application Design.
• Preparing Dashboards using calculations, parameters inTableauand DevelopingTableaureports that provide clear visualizations of various industry-specific KPIs.
• Access and change extremely large datasets through filtering, grouping, aggregation, joining, blending and statistical calculation.
• Consult with customers and inside partners to accumulate necessities and set milestones in the research, advancement, and execution periods of the project lifecycle.
• Understanding ofTableaufeatures like calculated fields, parameters, table calculations, low-level security, R -integration, Joins, Data Blending, and Dashboard actions.
• Develop, organize, manage, and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Created cubes using packages which are built in framework manager.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, business layer and presentation layer defining the cardinalities and appropriate relationship between query subjects.
• Created Standard Reports using Report Studio, like Dashboards, List Reports, Crosstab Reports and Chart Reports and Ad- Hoc Reports using Query Studio.
• Created reports which involved Multiple Prompts, Filters, multi-query reports.
• Implemented drill through on columns and cells to get the detailed information, and used style, render variables formatted the reports using layout component and Classes.
• Developed complex reports using Drill through, conditional blocks and render variables.
• Involved in status calls for requirement gathering and updating the requirements in the Design document and publishing the updated document into share point.
• Involved in unit testing of reports and model.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection.

Environment: TableauServer 8.0/8.1/8.2,TableauDesktop 7.x/8.x, IBM Cognos 10.1(Framework Manager, Report Studio, Query Studio, Powerplay Transformer), SQL Server 2005, Windows7.

Confidential

ETL Developer

Responsibilities:

• Involved in requirement gathering and preparing the both functional and technical documents for all reporting needs. Documented various business requirements and deployment plans.
• Understanding the specifications for Data Warehouse ETL Processes and interacting with the data analysts and the end users for informational requirements.
• Involved in the performance tuning using SQL queries.
• Worked with various ETL tools for the generation of data marts for reporting purpose.
• Took Initiative for indexing of the tables in data warehouse.
• Monitored the survey information from the vendor is updated on time to the database.
• Developed predictive tables for Health risk assessment HRA module using JOINS and T-SQL queries.
• Analyzed database requirements from the users in terms of the dimensions and fact tables using OLAP operations.
• Written scripts using JOINS, CTE, Stored procedures to pass the test cases while UAT testing.
• Performed all TRACK database tasks, including setting up team members, ensuring that data was entered correctly, and tracking theprogress of alldefectsuncovered duringtesting.
• Physical Migration of the Developed reports onto the DevelopmentSSRSserver
• Prepared Test plans which includes various test strategies, test schedules and test deliverables.
• Used Informatica dashboard to check ticketing issues and resolve the bugs raised in the environment.
• Moved internal tables to external for the deployment environment using SQL Server.
• Written complex SQL queries for querying data against different data bases for data verification process.