SUMMARY:

• IT Professional with 8 years of experience as Senior Tableau developer and ETL developer. Good experience in Business requirements, Analysis and Data exploration and Visual Analytics and involved in all stages of the Software Development Life Cycle (SDLC), Scrum, Waterfall, Agile environment
• Over 6 years of experience in analysis, design, development, testing and implementation of application software as ETL developer and a strong Experience in visual analytics using Tableau
• Acted as Tableau Developer (for designing and developing, proto typing the various dashboards using Tableau desktop
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage
• Expertise in ETL Loading strategy to maintain the history of records
• Hands - on knowledge on full range of BI Skills with Tableau 7x, Tableau Desktop, Tableau Server and Tableau Public, MS SQL Server, SSIS, SSAS, SSRS, MS Performance Point Server 2007 (PPS 2007), and Oracle
• Extensively built the dashboards such as creating Tableau Extracts, refreshing extracts, Tableau Layout designing, Tableau Work Sheet Actions, Tableau Functions, Tableau Connectors (Live and Extract), Dashboard color coding, formatting and report operations (sorting, filtering (Quick Filters, Cascading filters, context Filters), ranking, Top-N Analysis, hierarchies)
• Experience in creating several staging, Historical and Incremental loads of ETL jobs in Informatica and Jasper Soft ETL
• Experience in identifying Bottlenecks in ETL Processes, improving the Performance of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, and Normalization / De normalization strategies
• Experience in creating Performance Dashboards, Score cards, Metrics, attributes, advance chart types visualization and calculation fields to manipulate the data
• Worked on querying data and creating on-demand reports using Tableau Desktop and publish the same to Server
• End to end experience in designing and deploying data visualizations using Tableau
• Generation of Dashboards with Quick filters, calculated fields, Groups, Parameters and Sets to handle views more efficiently in Tableau
• Strong data processing experience in designing and implementing Data Warehouse and Data Mart applications, mainly Transformation processes using ETL tool IBM Data Stage
• Building and publishing Tableau reports utilizing complex calculated fields, table calculations, filters, parameters
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau
• Implemented Tableau security at the Data (Data security) and object (Roles and Permissions) level
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Good understanding of the principles and best practices of Software Configuration Management (SCM) in Agile, scrum, and Waterfall methodologies
• Experienced in working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized and normalized data models
• Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes
• Created Dashboard reports by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together
• US employment authorized for any employer and motivated team player to work as a team or independently

TECHNICAL SKILLS:

BI Tools: Tableau Desktop, Tableau Server, Tableau Online, Cognos 8.x, SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS)

ETL Tools: Informatica, Power Center 8.x, SQL Server Integration Services (SSIS)

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

Languages: JAVA, SQL, PL/SQL, HTML, Python, JavaScript and XML, SAS

Productivity Tools: MS Word, MS Excel, MS PowerPoint, MS Visio, MS Project

Methodologies: Waterfall, RAD, Agile Scrum

Reporting Tools: Cognos, Tableau, Framework Manager, Transformer, Qlickview

Databases: Oracle 11g, MySQL, Postgres SQL, MongoDB

Big data knowledge: Hadoop, Map-reduce, Machine learning using R

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Sr. Tableau Developer

Responsibilities:

• Created list reports, cross-tab reports and chart reports using underlying multiple query structure by using filters, calculations, complex expressions, and conditional formatting
• Designed the tableau dashboards to satisfy the business's needs and analyze the trends in the data
• Analyzing the large sets of data using various techniques such as quantitative analysis, advanced analytics and statistical modeling to find solutions
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications
• Involved in creating backups and restoring backups of Tableau repository
• Effectively used data blending feature in tableau and Administered user, user groups, and scheduled instances
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Worked extensively in various reporting objects like Transformations, Filters, parameters, Prompts, groups
• Prepared several complex Tableau reports and dashboards using calculations, parameters, attributes, facts
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server. Worked with historical data to analyze the trends
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services
• Created Dual Axis, side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps
• Identified the factors involving the performance of the reports and coordinated in creation of indexes
• Developed predictive statistical models using statistical analysis and other predictive modeling techniques
• Worked across departments to identify and understand key business questions, and standardize key metrics Analyzing the data of patterns, trends and fashions of various KPIs, Measures using graphs, charts, pivot tables
• Good knowledge of Tableau Admin activities like Security, Debugging, Scheduling, Subscriptions and User Security
• Demo of Tableau dashboard to users to enhance their knowledge on all the key capabilities of application
• Created Actions, Parameters, Filters and calculated sets for preparing dashboards and worksheets using Tableau
• Designed and implemented Puppet to configure, install, manage, and deploy releases across all environments
• Developed business process and technical design documentation for each reporting service developed in this project
• Experience with Scheduling Tableau Extracts, working with Multiple Data sources using Data Blending
• Built Complex Data Functions in Tableau Calculated Fields using Parameters and Sets
• Generated reports using SQL queries in Tableau and published them to users in online through Tableau server
• Perform administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance

Environment: Tableau 9.x/8.x (Desktop/ Server), SQL Server 2005/2008 R2, MS Access, MS SQL Server 2012, SSIS, SSRS, MS Visual Studio 2010, Oracle 10g, Erwin

Confidential, Seattle, WA

Tableau Developer

Responsibilities:

• Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc.
• Working with Business Teams to gather requirements and assist them in UAT process
• Involved in generating Daily/Weekly Sales & Finance trending reports using Tableau by identifying the dimensions
• Measure values and level of details for Business Analytics & Top Executives to give an overview on current Trends
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks
• Scheduled extracts on tableau server after the completion of data load into the warehouse
• Implemented star schema grouping for multi Fact, Conformed dimension
• Worked with clients to better understand their reporting and dash boarding needs and present solutions using structured Waterfall and Agile project methodology approach
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps using show me functionality Designed best practices for report development and also documented steps for performance running of cognos reports
• Bypassed SASS Tabular cubes by creating a MDX data extraction, ETL process, so that each Tableau workbook had no lag with user interactions, and had real-time responsive update updates upon user selections, in filters and drill-downs
• Designed best practices for report development and also documented steps for performance running of cognos reports
• Bypassed SASS Tabular cubes by creating a MDX data extraction, ETL process, so that each Tableau workbook had no lag with user interactions, and had real-time responsive update updates upon user selections, in filters and drill-downs
• Involved in designing Data model for various reporting based Data marts, enhancement of OLTP data model
• Created Sets, Groups and Data Bins as per user requirements and Created views using various axes like Individual Axes, Dual Axes and Blended Axes.
• Used Trend Lines, Reference Lines and Annotations to describe the data.
• Worked on groups, sets, parameters, different calculation functions including Table calculations
• Created the Analytics models, came up with ideas and proposed the solutions to the clients or customers
• Responsible for creating calculated fields, combine field, bins, sets, geo coding and hierarchies, etc
• Formulated procedures for integration of R Stats Package plans with data sources and delivery systems
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data
• Perform Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump
• Schedule 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
• Created Dashboard for the presentation using most of the Cognos functionality (such as Conditional Formatting, Drill through and Dashboards etc.)
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau8.1 desktop/Server
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information

Environment: Tableau Desktop 7.0, 8.0, 8.1, 8.2 Tableau server / Administrator, SQL developer, SQL 2008, SAS, Oracle 10g, SQL, PL/SQL, T-SQL Microsoft Excel 2007, MS Access, Windows 2007 server, java 1.5 platform, Teradata, Microsoft office 2007, Business objects 4.0, MS project

Confidential

Senior ETL developer

Responsibilities:

• Worked with the Data Warehouse Architect to perform source system analysis and identification of key data issues via analysis of the data profiling results and queries Assistance in the creation of ETL design specifications
• Defined the required analytics to design, develop financial routines, and assisted various work streams in identifying, and resolving data irregularities, and establish management reporting processes
• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination
• Worked with Data Engineers and managers on cloud and database technology infrastructures and development
• Created algorithms to improve monthly and quarterly Amortization and Accrual reporting, Fiscal Calendar user-defined-functions
• Extensively used Informatica Client tools - Designer (Source Analyzer, Target Analyzer, Mapping and Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager and Workflow Monitor
• Extensively used an Informatica debugger to figure out the problems in mapping. Also, involved in troubleshooting existing ETL bugs
• Analyzed and communicated ETL development issues, including problems with data integrity, data design, and functional and technical issues
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures
• Scheduled ETL jobs in Informatica and Linux Shell scripts and issue resolution in case failures
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse
• Involved in the testing the ETL modules, plans, deploys and tests the ETL mappings etc., to ensure that the clients remain satisfied
• Designed, Developed and Supported ETL Process for data migration with Informatica
• Created unit test plans and ETL code documentation and Worked with Business Managers, Analysts, Development, and end users to correlate Business Logic and Specifications for ETL Development
• Preparing Functional and Technical Design documents and Created stored procedures for heavy pharmaceutical transaction by using procedural parameters & working with packages, blocks & exception handling
• Extensively developed PL/SQL Packages, Stored procedures, Triggers, and finely tuned them for performance
• Documented business rules, functional and technical designs, test cases, and user guides
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build data and relation that would be used in dashboards to satisfy the business's needs
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services
• Worked as team lead for Offshore and Coordinate with the team, to ensure support tickets are resolved in a timely manner through the remedy system and ensure quality code is delivered to the client on time
• Worked with Pre-Session and Post-Session UNIX scripts for automation of ETL jobs and to perform operations like Gun zip, remove and archive files
• Involved in generating dual-axis bar chart with multiple measures and data blending from different sources
• Debugged the performance issues by using Oracle Hints, Explain plans and Table partitioning.
• Created and modified PL/SQL package stored procedures functions as per business requirements.
• Involved and Coordinated with the modeling team to provide them with the necessary information and insight into data for creating tables, triggers, sequences, Indexes.
• Analyzing the large sets of data using various techniques such as quantitative analysis, advanced analytics and statistical modeling to find solutions
• Worked with functional teams to propose the possible approaches for the bank needs.

Environment: Informatica Power Center 8.6, Auto Sys, Agile, HP UNIX, Windows NT, Oracle 9i/10g, Mainframe, SQL, PL/SQL HP Linux

Confidential

ETL developer

Responsibilities:

• Created Queries in Oracle SQL, Stored Procedures, and Views to store the data of clients, advisors
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updating to improve the query performance
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery
• Developed complex mappings with different transformation like Router, Lookup, sorter, Stored procedure, Normalizer, Filter, Update Strategy, Aggregator etc.
• Used IDQ to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes
• Create Technical Design Documents for ETL process from Conceptual, Logical / Physical Data Model
• Designed and developed MS SQL Server Reporting Services(SSRS) under SQL Server 2005.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Involved in preparing and executing SQL code deployments (DDL/DML) with application rollout teams into QA/Production environments
• Responsible for Unit Testing of ETL mappings, Bug Fixing and helping the testing team to execute the test cases
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules
• Created Batch scripts to execute workflows, schedule/unscheduled jobs, import/export users to Admin console, FTP scripts, BTEQ and TPT scripts
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, Connected and Un-connected lookup, sorter, Normalizer, SQL transformation and sequence generator
• Designed and implemented the Logical and Physical model of the database using Visio
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Developed complex T-SQL code for the application and worked in SQL server agent for job
• Worked on product customizations, to enhance new features to the existing product as per the bank requirements and involved in Planning, Analysis, Design, Development, Testing and Implementation.
• Written complex oracle SQL queries with complexity to gather the data from several sources and load into upstream Oracle database
• Used metadata driven ETL framework to generate XML's and for batch execution control
• Designed, developed, implemented ETL process to extract, transform, and load (ETL) data from inbound flat files and various source systems and loaded into Data Mart using the Informatica Power Center
• Created various complex SQL Queries, Stored Procedures, and User Defined Functions
• Involved in design on ETL framework to load Transactional data from SAP to ODS
• Design and develop ETL Load Audit Control Architecture and processes for reporting and monitoring
• Installed and maintained MS SQL Server 2005 and Written SQL queries and stored procedures to generate data
• Involved in testing the triggers and procedures to be used in the production for optimization and improving the performance.

Environment: IBM Web Sphere DataStage 8.1 Parallel Extender, Web Services, Quality Stage 8.1, (Designer, Director, Manager), Oracle Exadata/10g, DB2, Flat files, XML files, Control-M, Windows 7, UNIX, Shell Scripts, PL/SQL, SQL Developer, MS Office