SUMMARY

• 8+ years of experience in IT including development, Analysis and support.
• Around 5 years of extensive Tableau Experience in Enterprise Environment 6.x, 7.x, 8.x,9.x as Tableau / Data Visualization Architect and Administrator. Database expertise including SQL, ETL, Reporting, and Tuning.
• Data Warehousing experience on Data Modeling using Star schema and Snowflake schema with Facts, Measures and Slowly Changing Dimensions (SCD) Type1, Type2, and Type3.
• Transformations, filters, prompts, calculated fields, Sets, Groups, Parameters etc., in Tableau and in depth knowledge working experience on Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
• Experience in publishing Tableau Server, setting appropriate security and permissions
• Extensively useETLmethodology for performing Data Migration, Data Profiling, Extraction, Transformation and Loading using Talend and designed data conversions from wide variety of source systems likeSQL Server, Oracle, DB2and non - relational sourceslike XML, flatfiles,and mainframe Files.
• Experience inscheduling toolsAutosys, Control M & Job Conductor (Talend Admin Console)
• Extensively experience with Talend, SQL Server DTS & Integration Services (SSIS) Packages, for Extract, Transform, and Load (ETL) Data Warehouse technique, Business Objects Universe Designer, Deski and Webi reporting tools
• Experience creating Tableau dashboards with relational and multi-dimensional databases
• Participated in Test Plans, Test Scenarios and Test Cases based on Business Requirements and Technical Documents for ETL
• Extracting data from production data stores, Built Data structures, Developed departmental reports for performance and response purposes by using Oracle, SQL, MS Access, MS Excel, PL/SQL.
• Experience on Hadoop framework, UNIX scripts, Pig, Hive.
• Experience in Data warehouse, ETL-Extraction/Transformation/Loading, Data Analysis, Data migration, Data preparation, Reporting, Validation and Documentation.
• Experience providing Tableau desktop training for clients and end users.

TECHNICAL SKILLS

Operating Systems: WINDOWS NT, WINDOWS 95/98/2000 and UNIX

RDBMS: Oracle 10g/9i, SQL Server 2008/2005/2000, Sybase

Data Modeling: Erwin, Visio2000

Big Data: Hadoop ecosystem, HDFS, Map Reduce, Hive, PIG, Sqoop, NOSQL

Languages: C, C++, Java, COBOL, PL/SQL, T-SQL

ETL: SSIS, Talend, Tableau 9.x(with API)

Reporting tool: SSRS, Tableau

PROFESSIONAL EXPERIENCE

Business Intelligence Consultant (Talend/Tableau)

Confidential, McLean, VA

Responsibilities:

• Involved in analyzing the user requirements and transform them intoTableauDashboards and Reports.
• Effectively useddatablending feature intableauto connect different databases like Oracle, MS SQL Server.
• Administrating tableau server infrastructure (DEV/QA and PROD),
• Developed tableau server audit reports to view and analyze tableau server insights (health, tableau server usage, tableau server data extract failures etc.)
• Tableau server status reporting and data extract management.
• Worked with Stakeholders and business users for mentoring and training.
• Creating and maintaining new data extracts as per the new requirements,
• Resolving ODBC driver issues with the data extracts,
• Tableau desktop and server tickets resolution (primary contact for support)
• Resolving tableau dashboards development and performance issues
• Developed Tableau data visualization using Pareto’s, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
• Developed effective and interactive Dashboards using Parameters and Actions
• Developed donut charts for analyzing sales planning data.
• Created different KPI’s using Table calculations and calculated key figures(Manipulating strings, arithmetic calculations, aggregation options and Logical functions)
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Designed and deployed rich Graphic visualizations using Tableau.
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Worked extensively with Advance analytics like Reference Lines and Bands,Trend Lines.
• Expertise in working with data building Groups, Hierarchies and sets.
• Mastered in different Formatting techniques, using Annotations and Mark labels.
• Defined appropriate Hierarchies, measure groups and KPIs & deployed cubes.
• Created different reports like tabular, matrix, ad-hoc, drill down and drill through reports.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Using the Shiny UI with lower level code of HTML tags and JavaScript.

Environment: TableauDesktop 8/9,TableauServer 8/9,Tableau Public, Oracle 11g,Microsoft SQL Server 2012, Microsoft Visio, Shiny, Windows 7/8/10.

Tableau Developer/Admin

Confidential - King of Prussia, PA

Responsibilities:

• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
• Published Workbooks and Dashboards to the Tableau server.
• Involved in creation of groups and users in Tableau server using Active Directory settings.
• Used Tabcmd utility tool and used Tabadmin utility tool and played the role of Tableau administrator.
• Played key role in enhancing client’s Web reporting system, reducing time of delay financial tracking analysis by 30%.
• Purchasing, Setting up, and configuring a Tableau Server and MS-SQL 2008 R2 server for Data warehouse purpose.
• Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.
• Consolidate multiple data silos that exist on campus to one location.
• Scheduled data extracts on a daily basis.
• Resolved end user reporting problems through collaboration with IT and Operations.

Environment: Windows XP, Linux, Windows 7,Tableau 9.x, Tableau Server, Qlikview 11.0, SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and SQL, Java, JavaScript, SQL, VB

Tableau Developer/Admin

Confidential - Dayton, OH

Responsibilities:

• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Created visualization for logistics calculation and department spend analysis.
• Maintained Test log and Wrote test Evaluation, Summary Reports.
• Extensively involved in doing user acceptance testing (UAT).
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Created Test Scripts, Test hierarchy to represent the features and functionality that need to be test in the application.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Participated in the User Acceptance Warranty Testing.
• Involved in doing security and negative testing of the application.

Environment: Windows 7 and Linux,Tableau server, MS-Excel, SQL Server, SharePoint, Microsoft office, SQL-PLUS, C++, Visual Basic

Tableau Developer/ Admin

Confidential, McLean VA

Responsibilities:

• Created dashboards by extracting data from different sources using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in generating dual-axis bar chart with multiple measures and data blending in case of merging different sources.
• Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.

Environment: Tableau Server x, Tableau Desktop x, Windows Server Standard R2,, Excel, SQL Server management studio, MS SQL Server 2008R2, UNIX .

ETL Developer/Talend

Confidential, Somerville, NJ

Responsibilities:

• Design and Implement ETL for data load from Source to target databases and for Fact and Slowly Changing Dimensions (SCD) Type1, Type 2, Type 3 to capture the changes.
• Extensive experience in extraction of data from various sources like relational databasesOracle, SQL Server,and FlatFiles.
• Involved in writing SQL Queries and used Joins to access data fromOracle, and MySQL.
• Participated in all phases of development life-cycle with extensive involvement in the definition and design meetings, functional and technical walkthroughs.
• Designing, developing and deploying end-to-end Data Integration solution.
• Implemented custom error handling in Talend jobs and worked on different methods of logging.
• Created UNIX script to automate the process for long running jobs and failure jobs status reporting.
• Developed high level data dictionary of ETL data mapping and transformations from a seriesof complex Talenddata integration jobs.
• Expertise in interaction with end-users and functional analysts to identify and develop Business Requirement Documents (BRD) and Functional Specification documents (FSD).
• Created context variables and groups to run Talend jobs against different environments.
• Performed requirement gathering, Data Analysis usingData Profiling scripts, Data Quality (DQ) scriptsandunit testing of ETL jobs.
• Created triggers for a Talendjob to run automatically on server.
• Installation of TalendEnterprise Studio (Windows, UNIX) and configuring along with Java.
• Set up and manage transactional log shipping, SQL server Mirroring, Fail over clustering and replication.
• Worked onAMC tables(Error Logging tables)

Environment: TalendPlatform for Data management, UNIX Scripting, Toad, Oracle 10g, SQL Server

Data Analyst

Confidential, Fairfax, VA

Responsibilities:

• Documents the complete process flow to describe program development, logic, testing, and implementation, application integration, coding
• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines
• Responsible for conducting due diligence review of business banking customers
• Conducted GAP analysis to analyze the variance between the system capabilities and business requirements
• Created Report - Models for ad-hoc reporting and analysis
• Perform small enhancements (data cleansing/data quality)
• Extensively used SQL for accessing and manipulating database systems.
• Used SPSS and R for statistical analysis and data visualization
• Worked on daily basis with the main frame team and lead data warehouse developers to evaluate impact on current implementation

Environment: UNIX, Shell scripting, SQL Server BI Development Studio, SAS/SQL, Teradata V12, R, SSIS, MS SQL Server, Flat files

Desktop Support Specialist

Confidential, Chantilly, VA

Responsibilities:

• Provided daily desktop, technical end-user support and training to over 3,000 users. This includes problem resolution via remote control, phone, network, and e-mail in person.
• Created new user accounts, profiles, assign users specific rights as well as created home directories, assign to groups and map network drives.
• Performed XP deployment rollout for over 3,000 users on site and configure/ghost new PC’s with new image.
• Used SMS/PC Anywhere and Remote desktop connection to directly control and monitor remote clients as well as shadow RAS users that are connected.
• Supported over 250 enterprise applications.
• Trained new employees in current email software and develop Quick Desk Reference Guides.
• Troubleshot and resolved a wide variety of extensive desktop applications/issues, email problems, developed software and Internet based applications.
• Troubleshot PC related problems such as printer connection, remote location, hardware, scanners and other related peripherals.
• Installed software, hardware (floppy drives, memory sound devices, etc.).
• Performed daily database backup and recovery.
• Inputted trouble tickets via help desk software in order to track user problem and resolution.
• Researched, organized and established accounts with various vendors for hardware requests, repairs, equipment and services.
• Conducted myself in service-oriented manner that is attentive, pleasant, cooperative, sensitive, respectful and kind when dealing with users, visitors, public and all employees.
• Kept clients informed of all aspects pertaining to their service request and bring all customer requests to resolution and/or escalation to management or technical support.