CAREER SUMMARY

• Data Visualization and Analytical professional using Tableau to analyze and obtain insights into large data sets, create visually compelling and actionable interactive reports and dashboards.
• Over eight 8 years of industry-wide experience in ETL Infomatica/Tableau Developer. Requirements gathering, design build, development, testing, implementation, production support in a complex environment. Thorough understanding of business processes with demonstrated effective communication, interpersonal, analytical skills.
• Extensive experience working with Tableau Software as a dashboard developer.
• Extensive experience working in Windows, UNIX, LINUX environments.
• Excellent understanding of Data modeling Dimensional Relational on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases Oracle , Mainframes, SAP BW, MS Access and client/server applications.
• Created and developed Tableau data visualization reports for KPI's.
• Defined best practices for Tableau report development.
• Built Tableau visualizations against various Data Sources like Flat Files Excel, Access and Relational Databases Oracle, SQL Server .
• Define specification, design and build of Tableau Desktop reports and dashboards
• Installation, set up and administration of Tableau Server
• Training designers, analysts and end users in Tableau Desktop and Tableau Server
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Expertise in Informatica Power Center 9.x/8.x/7.x extracting data from Oracle, SQL Server, Teradata and DB2 databases.
• Involved in different phases of Data Warehouse Life Cycle including business reporting requirements gathering, source system analysis, logical/physical data modeling, ETL design/development, project deployment, production support.
• Strong ability to analyze source systems and business requirements, identify and document business rules, design data architecture for cohesive decision support and prepare dimensional data models.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Extensive knowledge of Dimensional Data Modeling like Star and Snowflake schemas, FACT and Dimensions tables, physical and logical modelling.
• Experienced in leveraging ETL Transformations to meet the business requirements Source Qualifier, Aggregate, Lookup, Rank, Joiner, Filter, Router, Sorter, Sequence Generator, Union, Update Strategy etc. .
• Worked with complex queries involving multiple table inner and outer joins and optimizing the queries by creating various clustered, non-clustered indexes and indexed views with the help of DBA.
• Experience in the full-cycle software development including requirements gathering, prototyping, and proof of concept, design, documentation, implementation, testing, maintenance and production support.
• Excellent communication, documentation and presentation skills using PowerPoint.

PROFESSIONAL EXPERIENCE

Confidential

Role: Sr. Tableau Developer

Responsibilities/Deliverables:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Good Knowledge on Tableau installation and configuration with Single Server System
• Worked on technical strategy, provided hardware and software configuration, understood client-wide BI implementation project, designing and developing visualizations.
• Created batch scripts for tableau Server backup atomization on weekly basis and save the backups in particular folder.
• Brainstorm ideas on what to include in views/dashboards from the data source and document on the fly business requirements.
• Involved in creating database objects like tables, views, procedures, triggers, functions using Oracle SQL to provide definition, structure and to maintain data efficiently.
• Extensively involved in creating graphs by using measures and dimensions data from various databases by using data blending concept.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports using Tableau.
• Involved in creating many complex Adhoc and Dynamic reports with calculated fields, filters, parameters, hierarchies, sets and groups.
• Created much visualization like filled maps, geo maps based on dimensions and measures which give the End user more visibility to make decisions based on the region.
• Created many Dashboards and KPI reports using relevant Marks or Highlight functionalities.
• Responsible for creating calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.
• Involved in creating a dual-axis bar chart with multiple measures.
• Implemented data blending to blend related data from different data sources.
• Responsible for Training end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters, and date functions.

Environment: Tableau V 8 Desktop, Server, Reader , Oracle, SQL Server, PL/SQL, TOAD

Confidential

Role: Tableau Developer /Admin

Responsibilities/Deliverables:

• Worked in coordination with Clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement
• Created Users, User Groups and Projects through Tableau server Web and assigned roles and permissions for Tableau Users.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
• Created complex Executive dashboards using Tableau Desktop that was published for the business stake holders for analysis and customization using filters and actions.
• Created dashboard using parameters, sets, groups and complex calculations.
• Implemented various data connections from data source to Tableau Server for report and dashboard development
• Monitored VizQL server, Application Server and data server activity to track performance and system stability
• Developed actions, parameters, Filter Local, Global and calculated sets for preparing dashboards and worksheets using Tableau
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Developed many reports with multiple data connections and performed data blending and created different visualizations like Bar Charts, Gantt Bar Charts, tree maps, bubble charts using complex joins.
• Created complex reports like Detail level Transaction report's, monthly Aging, YTD cash goal reports,
• Quarterly reports by creating multiple queries, sub queries, and merged dimensions, ranking features in single report.
• Involved in creating guided navigation links for Interactive dashboards in Tableau.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Mobile App.
• Provided 24/7 production support for Tableau users.
• Involved in testing dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Highly responsible for scheduling and delivery of jobs using SQL Server Agent. Performed SQL tuning by using Database Engine Tuning Advisor for long execution plans.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop, Tableau Reader, Tableau Server, Tabcmd, Oracle, MS Office 2007/2010, SQL Server 2008, Windows 7, Enterprise Manager, SQL Server Management Studio, Microsoft Excel.

Confidential

Role: Tableau Developer

Responsibilities/Deliverables:

• Developed local and global filters while preparing worksheets and dashboards in Tableau.
• Connected Tableau server with share point portal and setup auto refresh feature.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, SQL Server and Oracle.
• Used and applied actions like filter, highlight and URL to dashboards.
• Implemented data blending in order to merge data from different sources.
• Used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Involved in creating a dual-axis bar chart with multiple measures and also created bins for different measures.
• Created dashboard using parameters, sets, groups and calculated fields.
• Created dashboards by extracting data from different sources.
• Develop data visualizations and interacting with Business users to understand and analyze their requirements.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Published Tableau Packaged Workbook .Twbx in Server.
• Performed Tableau type conversion functions when connected to relational data sources.
• Experience in creating different Tableau workbooks, dashboards including Bars, Histograms, Pie charts, Maps, Scatter plots, Gantts, Bubbles and Highlight tables.
• Train end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters and date functions.
• Involved in performance tuning by creating and updating stored procedures and triggers.
• Involved in creation and updates of several SQL Indexes, joins, Views, Stored Procedures, triggers and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting for future predictions.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand data in an easy and efficient manner.
• Worked with Tableau Server Extract .TDE .
• Build homepage to navigate to all reports.
• Creating Users, User Groups and Projects through Tableau server Web and assigned roles and permissions for Tableau users.
• Reviewed basic SQL queries and edited inner, left and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Strong knowledge of Data Warehousing methodologies and concepts including Star Schemas, Snowflake Schema and identifying fact and dimensional tables.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Environment: Tableau Desktop, Tableau Reader, Tableau Server 7/8, Tabcmd, MS SQL Server 2012, T-SQL, MS Excel, SQL Server Management Studio, Share Point, MS Office 2010/2013.

Confidential

Role: Sr.ETL Informatica Developer

Responsibilities/Deliverables:

• Used Update strategy and Target load plans to load data into Type-2 Dimensions
• Created and used reusable Mapplets and transformations using Informatica PowerCenter
• Utilized Lookup, Aggregator, Joiner, Union, Expression, Filter, Update strategy, Sql and Normalizer, Router, Source Qualifier transformations to model various standardized business processes and implement business logic using Informatica.
• Used various transformations in the mappings and applied surrogate keys on target table
• source systems
• Developed mappings and mapplets using Informatica Designer from various transactional
• Extensively used Informatica scheduler to schedule Informatica workflows
• Executed several sessions and created batches to automate the loading process
• Workflow Variables, Session Parameters, Ftp Session Parameters and Source-Target
• Extensively used Parameter file to override mapping parameter, mapping Variables,
• In charge of converting data using SQL Server 2005 using SSIS
• Used PMCMD command to schedule sessions and batches
• Manager
• Created Workflow and Tasks to schedule the loads at required frequency using Workflow
• Worked along with the DBA to resolve performance and tuning issues
• Experience in working with SQL Server Integration Services SSIS
• Application Connection parameters
• Used different partitioning options for better performance
• Involved in doing Unit Testing, Integration Testing and System Testing
• Increased Code Reusability using shortcuts, Mapplets, Reusable Transformations, Re-Used
• mappings, Reusable Sessions and Worklets to reduce redundancy in code
• Handle slowly changing dimensions of Type 2 to populate current and historical data to
• Dimensions and Fact tables in the data warehouse
• Monitoring the ETL jobs and fixing the Bugs
• Provided reliable, timely support of integration, performance and user acceptance testing
• processes
• Excellent analytical, problem solving, communication and interpersonal skills with ability
• to interact with individuals at all levels

Environment :Informatica Power Center 8.1, Informatica Power Centre 9.1, Oracle 11g, UNIX, Windows2000, PL/SQL, SQL Server 2003

Confidential

Role: ETL/ Informatica Developer

Responsibilities/Deliverables:

• Met with business/user/developer groups to understand the business/data needs and
• gather requirements.
• Extracted and analyzed the sample data from source systems to validate the user
• requirements. Created high level design documents and process flow document.
• Participated in data model Logical/Physical discussions with Data Modelers.
• Did data profiling and analyzed data from vantage side.
• Extensively used Informatica Client tools Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Developed various mappings using Mapping Designer and worked with Aggregator,
• Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and
• Sequence Generator transformations.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once
• using Workflow Manager.
• Created Indexes, Partitioned the tables better query performance.
• Developed Various Procedures, Functions Packages in PL/SQL
• Prepared Unit and Integration testing plans. Involved in Unit and Integration testing using
• the testing plans. Involved in UAT with user groups.
• Involved in after implementation support, user training and data models walkthroughs
• with developer/user groups.
• Created Test cases for the mappings developed and then created integration Testing
• Document.
• Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica Power Center 8.6.1/8.1.1, Oracle 10g/9i/8i, SQL Server 2000, PL/SQL, Erwin, TOAD, SQL Plus, SQL Loader, Windows, Linux and HP-UX.