SUMMARY

• 8+ years of IT industry experience in implementing all phases of the Software Development Life Cycle (SDLC), including Business Requirements Gathering, Design, Development, Testing, and Implementation of Data Warehousing/Business Intelligence Applications.
• 4+ years of Experience in building visualizations and Dashboards using the various versions of Tableau suite (10.1.1,9.0, 8.2, 7) like Tableau Desktop, Server, Public and Reader.
• Sound knowledge of Health Care,Technology,Retail, Finance, Banking, Pharma, Project and Resource Management domains.
• Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
• Proficient in conducting Gap Analysis, Business Process Re - engineering, Designing Work flows and communicating the trade-off decisions on product features based on technology, budget constraints and customer requirements.
• Organized numerous Joint Application developments (JAD), Joint Requirement Planning sessions (JRP), Interviews, workshops and Requirement Elicitation sessions with end-user/clients/stake holders, Subject Matter Experts and the technology group.
• Valuable experience in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Expert in design and development of various dashboards/ reports utilizing Tableau advance visualizations like Bars (Horizontal, Stacked, Side by Side), Lines (Continuous, discrete), Bullet Graphs, Scatter Plots, Circle Views, Pie-Charts, Packed Bubbles, Funnel Charts, Geographic Maps (Symbol, Filled) to represent different datasets.
• Hands on experience in creating users, groups, projects, Data connections, settings, incremental refreshes for data sources on Tableau server
• Strong experience in integrating Alteryx, ClouderaHadoopwithtableauand developed the reports.
• Created report on Cloud based environment usingAmazonRedshiftand published onTableau Online.
• Extensive Work experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating database tables, constraints, indexes.
• Involved inTrouble Shooting, Performance tuning of reportsand resolving issues withinTableau.
• Proficient in Dimensional Modeling using Kimball and Inmon methodologies for Star and Snowflake schema designs of Data Warehouse and Data Integration projects.
• Extensive experience Worked on Erwin utilizing features like Reverse/Forward Engineering, Subject Area, Domain and developing Data Dictionary and publishing Data Models.
• Outstanding knowledge in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues,
• Flexible, enthusiastic and project oriented team player with excellent communication skills and leadership capabilities to develop creative solutions in challenging environments.

TECHNICAL SKILLS

Reporting Tools: Tableau (Desktop/Server/Public/Reader), Business Objects, Microsoft SQL Server Reporting Services (SSRS)

Data Warehousing ETL Tools: Informatica, PowerCenter, Data Stage, SSIS, Informatica Cloud

Databases: Teradata, Netezza, Oracle, SQL Server, MS Access,AmazonRedshift

SQL Tools: Toad, Teradata SQL Assistant, SQL Developer

Data Modeling Tools: Power Designer, Erwin, ER Studio, MS Visio.

Scripting Languages: PL/SQL, SQL, Unix shell scripting, Java, C, HTML, XML

Testing Tools: Mercury Test Director, IBM Rational Tester, Quick Test Professional (QTP), HP ALM

Operating Systems: UNIX, Linux, Microsoft

Others: MS Word, Excel, PowerPoint, VISIO 2007

PROFESSIONAL EXPERIENCE

Confidential, North Wales, PA

Sr.Tableau Developer/Data Analyst

Responsibilities:

• Capturing end user stories on JIRA agile tool, analyzing and laying out a design in continuous integration environment and grooming the end user’s stories with business users, business analysts and delivering the user stories every sprint.
• Preparing production migration documents for each sprint release and work with production team during migrations. Preparing functional documents, technical designs solutions and business rules on Atlassian confluence in each sprint.
• Creating Informatica mappings, Tables in database and run the mappings through shell scripts to perform ETL from source to target.
• Designing and Modifying Materialized Views, Views with preferred granularity of the data and aggregating data needed for Tableau Reports and producing executive level tableau dashboard visualizations for senior management.
• Worked closely with data architect and informatica ETL team to build tableau reports and optimizing performances of materialized views in the database.
• Worked on large data sets withinHadoopecosystem performing analysis using Hive
• Developedtableauvisualizations connecting to servers like ClouderaHadoopHive.
• Worked jointly with business analysts and product owners to solicit visualization requirements, recommending changes, creating prototypes, giving demos to the users.
• Aggregating data, calculating metrics to report across the dashboards in the database to improve the performance.
• Creating parameters and integrating with calculated fields in tableau dashboards to report at different granularity of the data.
• Optimized the configuration of Amazon Redshift clusters, data distribution, and data processing
• Moved reporting to Amazon Redshift and rewrote reports and dashboards in Tableau
• Building drill down dashboards, detailed tabs, spark line trends for weekly, monthly and creating SLA charts like bar chart, Crosstabs and using powerful visualizations in tableau, meeting the business needs.
• Building Ad-hoc reports, publishing data sources, dashboards, embedding dashboards for end users and creating refresh extracts on tableau server.
• Creating stored functions and batch stored procedures in the database for refreshing the materialized views, calculating business days, SLA Dates which are used in developing KPIs.
• Using Tabcmds commands for scheduling tableau dashboard refreshes and scheduling Tidal jobs for a continuous integration of data refreshes.
• Creating Test Plans and Test Cases in HP ALM for system integration testing and running the test cases against the database to validate the data in both materialized views and on the dashboard.

Environment: Tableau(Desktop/Server)10/9.x,AWS,Oracle11g,Teradata,Cloudera Hadoop,Hive,AmazonRedshift,HPALM,Alteryx,InformaticaPowerCenter,JIRA,AtlassianConfluence,Stash,SharePoint,OracleSQLDeveloper,Linux server, AWS VPCx, Microsoft Suite (Excel, Word, and Visio),PG Admin(Postgre SQL).

Confidential, Hanover, MD

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Collaborate with end users, project stakeholders and support partners to identify needs, goals, and business models.
• Prepared Business Requirement document and then converted business requirements into technical designs.
• 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.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality and publishing them to tableau server and tableau Online.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Worked on generating various dashboards inTableauserver using various data sources (SQL Server,AmazonRedshift, Excel, Text, Salesforce, Send Grid, Google Analytics etc.)
• Created report schedules on Tableau server and Tableau Online.
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic
• Created and assisted users in Tableau dashboard development.
• Defined best practices for Tableau report development andeffectively used data blending feature in tableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Manage the application’s users, groups, and integration with Active Directory.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.
• Integration of Tableau reports with Asp.Net web applications and usage of JavaScript API for performance improvement.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Involved in testing the Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Environment: Tableau (Desktop / Server), Teradata, Oracle, MS SQL Server, SQL, Toad, Unix, Teradata SQL Assistant, MS Visio, Java Script API, Asp.Net VB, MS Office Suite (Word, Excel, PowerPoint)

Confidential, Centennial, CO

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Served as Business Systems Analyst/ Data 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.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Interact professionally with diverse group of professionals in the organization including managers and executives.
• Developed Standard Operating Procedures (SOP) for Monitoring.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Mentored Power users in creating and modifying worksheets and data visualization dashboards.
• Involved in license management SLA’s with Tableau support.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Used TabAdmin and TabCMD commands in creating backups and restoring backups of Tableau repository.
• Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Provided Tableau server and Tableau desktop .
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• 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: Tableau, Teradata, Teradata SQL Assistant, Share Point, Informatica, Autosys, CA Service Manager, UNIX, MS VISIO, Microsoft Office Suite (Word, Excel, PowerPoint).

Confidential, Columbus, Ohio

Sr. BI Analyst/ Tableau Developer

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Analyzed requirements for various reports, dashboards, Scorecards in BO and created the same using Tableau desktop.
• Analyzed the source systems and created technical design documents and data flow diagrams.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Publish the 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 publishing or extracted to server.
• Configured different data sources using Tableau Desktop
• Created best visualizations reports as per the business requirements using Tableau desktop professional edition.
• Enabled tableau Actions to drill down from Dashboard to worksheet.
• Created users, groups, projects, workbooks and the appropriate permission sets forTableauserver logons and security checks.
• Extensive experience on creating trend reports including forecast and trend lines.
• Configured incremental data refresh for the data sources.
• Configured AD security using tableau server.
• Responsible for authorizing the users based on their privileges.
• Involved in migration activities related to Tableau across the environments.
• Prepared BI Interactive Dashboards using calculations, parameters inTableau.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Implemented security in reports according to employee groups and roles according to the requirement and was involved in deployment process.

Environment: TableauDesktop, Tableauserver, SQLdeveloper, Oracle, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007, Quality Center

Confidential, Santa Clara, CA

SQL/Report Developer

Responsibilities:

• Involved in planning, defining and designing data and provided documentation.
• Upgraded MS SQL Server using detach/attach, backup and recovery and by replication.
• Used SSIS Import/Export Wizard, for performing the ETL operations.
• Createdalerts, notifications, and emailsfor scheduled SSIS packages execution.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2008r2.
• Generated reports usingSSRSthat could be used to send information to different primary vendors, clients, and managers.
• Designed astarschema for the data warehouse using dimensional modeling and developed it using the Erwin tool.
• Created sub-reports, drilldown-reports, summary reports, and parameterized reports in SSRS.
• Generated reports using SSRS that could be used to send information to different Primary vendors, clients and managers.
• Designed and implemented stored procedures and triggers for automating tasks.
• Maintained the table performance by following the tuning tips like normalization, creating Indexes.
• Used the HTML code to make the report manager more functional and customizable.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split, Derived column etc.
• Tracking the life cycle of project using HP ALM
• Troubleshootand fixed issues in existing cubes in SSAS.
• Designed a new schema for the data mart databases.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment: MSSQLServer 2008r2, T-SQL,SSRS2008r2, Visual Studio 2008r2, Erwin 8.0, HP ALM, UNIX, MS VISIO, Microsoft Office Suite (Word, Excel, PowerPoint).