SUMMARY

• Over 6 years of working experience as Tableau Developer, Business Analystwith high proficiency in Dashboard reporting, requirement gathering, Datamodeling including design and support of various applications in OLTP,DataWarehousing, OLAP and ETL in Various Domains like Finance, HealthCare, E - Commerce…etc.
• Strong experience inDataAnalysis,DataMigration,DataCleansing, Transformation, DataImport, andDataExport through the use of various ETL tools such as Informatica, Talend and Ab Initio.
• Hands on Experience in development of Reports and Dashboard in Tableau. Working Experience in design and development of Tableau visualization solutions.
• Use Tableau Desktop to analyze and obtain insights into large data sets.
• Proficient in developing security metrics program and creating Tableau dashboards and various visuals in Tableau.
• Created Parameters to achieve desired functionality and create risk metric analysis by coordinating with users.
• Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter and calculations.
• Experience in testing and writing SQL & PL/SQL Queries, Stored Procedures, Functions, Triggers and Packages.
• Experience in working with Microsoft Business Intelligence (BI) stack SQL Server Integration Services (SSIS) for data integration, SQL Server Analytic Services (SSAS) for analytics, SQL Server Reporting Services (SSRS) for business intelligence and visualization in SQL Server Management Studio (SSMS) environment.
• Good familiarity in working with automating global reporting through effective data management using sophisticated reporting tools such as SQL, SAP BW, BEx Analyzer, MSBI, and Tableau.
• Experienced in SQL for writing Indexes, and Views, Stored Procedures, Cursors, Triggers under define function DTS, Transaction management, T-SQL, code optimization and performance Tuning creating tables and Indexes.
• Experience with Javascript, XML, JSON, Sharepoint, .Net / aspx development.
• Experience with SQL Server 2012, 2008 R2, 2008, 2005 installation, configuration, SSIS, SSRS and administration.
• Expertise in Visual Studio.NET technologies like .Net, Aspx, ASP.NET, XML, JavaScript.
• Good understanding of Tableau Desktop, Tableau Server, MS BI PowerPivot, and PowerQuery.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, line diagrams, pareto charts, funnel charts, scatter plots, pie-charts, donut charts, bubble charts, funnel charts, heat maps, tree maps according to the end user requirements.
• Excellence in delivering Quality Conceptual, Logical and PhysicalDataModels for Multiple projects involving various Enterprise Applications.
• Expertise in managing teams and working in partnership with clients and being interface between technology and business. Strategic planner in using technology with business.
• Expert in design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Extensive experience in developing use cases, creating screen mock ups, conducting GAP analysis, SWOT Analysis, Report Requirement Specification and Risk Analysis.
• Experience using SOAP UI for validating the Real Time Request and Response transactions.
• Experience in developing detailed specs through JAD and JAR sessions, interviews, on site meetings with business users and development team.
• Experience in creating functional designs for integrations between e-commerce and ERP systems.
• Strong working knowledge in creating use-cases, process flows, proto types, mock-ups and wireframes to make customers understand and get an idea of the system and make sound decisions as part of e-commerce and m-commerce projects
• Hands on experience in business process engineering and all phases of SDLC (software development life cycle) involving Requirement Analysis, Software design, development, implementation, testing, maintenance and Object Oriented Design (UML).
• Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complexdatamanipulations.
• Advanced metrics presentation skills including attention to detail, consistency andappearance. Good knowledge on decision-making skills on complex /ambiguous metrics related information.
• Responsible for developing, analyzing and reporting key risk indicator and keyperformance indicator metrics that enable management to make timely and effectivedecisions related to threats, risks and control requirements.
• Advanced Excel, Modeling, Data Manipulation skills and chart creation, creativity, and visual representation of data.
• An excellent team player to work under time constraints and technically strong person who has the capability to work with business users, project managers, team leads, architects and peers.

TECHNICAL SKILLS

Reporting Tools: Tableau 8, SQL Server Reporting Services)

ETL Tools: SSIS (SQL server integration services), DTS, Talend, Ab initio, Informatica

Databases: MS SQL Server 2000/20 R2/2012, Oracle 11g/10g, DB2 MS excel 2010, MS Access

RDMS Load Tools: SQL*Loader, IBM DB2 UDB 8.1/7.0, MS SQL Server

Languages: C, C++, XML, HTML, Java/J2EE, T-SQL, SQL, PL/SQL.

Operating System: Windows, UNIX, Linux

Office Applications: MS-Office

Database Tools: TOAD, AQT, SQL Navigator

Data Modeling: Dimension tables, Pivot Tables, Erwin

MS BI Stack: SSIS, SSAS, SSRS, SSM

PROFESSIONAL EXPERIENCE

Confidential, PA

Responsibilities:

• Gather and analyze the business requirements and tan translate them to technical specifications
• Building and publishing customized interactive reports and dashboards reports in the tableau server
• Created parameters, quick filters, context filters and sets to display top products based on their sale, profits, quantity order and shipping cost
• Experience in configuring reports from different data sources using data blending
• Implemented geographic maps and use custom images and also geo coding for the data view
• Experience in creating different visualizations using bars, lines and pies, maps, scatter plots, Gantts, packet bubbles, bullets, heat maps and highlight tables
• Extensively worked on creating actions, calculated fields and calculated tables for preparing dashboards and worksheets in Tableau
• Created report schedules on Tableau server.
• Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Installed & Configured Tableau on Windows servers.
• Excellent experience and expertise in creatingTableauWorkbook's, Publishing workbooks and Dashboard.
• Findefficientways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Developed the whole application using Asp.Net MVC architecture and SQL Server (SSIS, SSAS) in SSMS.
• Knowledge on Developing Reports using SQL Server Reporting Services (SSRS) and Data Transformation Services (DTS)
• Designed and developed ETL processes using SSIS to receive customer files from data warehouses and transfer/load them into transaction processing systems.
• Able to use Excel for rapid data cleansing (data transformations, formulas, vlookups, pivot tables, and other techniques)
• Created SSIS Packages to migrate the data from database to Text files.
• Generated different reports using MS SQL Reporting Services and Crystal Reports.
• Created Stored Procedures, Triggers, Functions, Indexes, Views, Joins and T-SQL code for applications.
• Worked extensively on Data Migration, Export, Extractions, Transformation, Loading (ETL) and Data Warehouse design with Oracle, DB2, SQL SERVER.
• Developed Web Forms using HTML, XML, XSTL, JQuery, and JavaScript.
• Responsible for Developing aDashboard.
• Working knowledge onTableau Server / Administration.
• Identified internal and external Business requirements, design and configuration set-up and documented and delivered functional Requirements Document to the project team.
• Performed System testing of the Claims processing systems (Pricing Rules, Duplicate/Limits validation, Member Eligibility, Provider Enrollment, et al).
• Performed Computer System Validation Assessment(CSV) to identify the validation deliverables for the project implementation
• Converted project specifications into sequence of detail instructions and logical steps for on-line screens used for data inputting and detailed reports and file transfers for Membership Enrollment and Automated Claims Processing.
• Reviewed queries that were automatically build by Tableau and edited them as and when needed along with writing basic custom SQL queries to extract data from various data sources into the BItool, Visualization tool, and Excel reports
• Extracting the data tables using custom generated queries from Excel files, Access / SQL database and providing exacted data as an input to Tableau.
• Collaborated with the Project Managers in Tracking and Managing Project Development Process.
• Worked with development and testing teams to accomplish timely release objectives
• Planned and built project documents based on Rational Unified Process (RUP) methodology in Software Development Life Cycle (SDLC).
• Generated reports using SQL server Reporting Services (SSRS), and created user friendly templates, indexes, using XML
• Actively involved in Source Driven Testing, Target Driven Testing, Business Cycle Testing, Business Scenario Testing and Data Integration Testing.

Environment: s: Tableau Desktop 9.0, Tableau Server, MS Excel, MS SQL Server 2005, MS SQL Server 2008, TSQL, UNIX, Linux RHEL 5.4.

Confidential, Plano, TX

Tableau Developer

Responsibilities:

• Experience with the design and development of Tableau visualization solutions.
• Deep experience with the design and development of Tableau visualization solutions.
• Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Involved in creating dashboards and reports in Tableau. Created report schedules on Tableau server.
• Migrated existing Micro strategy Reports to Tableau workbooks.
• Created Tableau extract files for improving the performance.
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Installed and upgraded Tableau server and experienced in server performance tuning for optimization.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Extracting data from different sources connecting them and used the same to create dashboard
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Created data blending in case of merging two different datasets.
• Interacted professionally with a diverse group including executives, managers.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, MS SQL Server and MS Excel.
• Working on generating various dashboards in Tableau server using various sources such as Teradata.
• Responsible for Developing a Dashboard.

Environment: Tableau Desktop 9.0, 8.0, 7.0, 6.02, Tableau server / Administrator, Oracle 10g, Microsoft Excel 2007, MS Access, Microsoft office 2007.

Confidential, Troy, MI

SQL Developer

Responsibilities:

• Analyzed available data from MS Excel, MS Access, and SQL server 2000/2005.
• Designed new database on SQL server 2008R2.
• Normalized the data, created different tables, views, indexes, triggers and efficient stored procedures and Functions.
• Checked Performance Tuning of the Database by optimizing the queries with modification in T-SQL queries. Normalized tables, established joins and created indexes wherever necessary.
• Building query execution plans and making sure each and every query is using appropriate indexes.
• Involved in backup and recovery strategies.
• Created functions, stored procedures, triggers and constraints using T-SQL.
• Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.
• Server & Application fine-tuning & trouble shooting.
• Monitoring MS SQL Server performance and network issues.
• Performance monitoring and tuning of SQL servers.
• Created tables and views.
• Maintained and tuned various data objects within the SQL Server Schema.
• Managing the use of disk space, memory & connections by monitoring.
• Involved in transferring old data from various sources like flat files, MS Access, and MS Excel into MS SQL Server 2000 using DTS Packages.
• Designed new SSIS packages to extract data from various sources, transformed it based on Business needs and loaded it to OLAP servers for further analysis.
• Exported and imported data from text files and Excel to SQL Server database using bulk insert.
• Worked on developing Reports and managing reporting services.
• Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions.
• Used Tableau to design Reports and Interactive Dashboards.
• Built complex formulas in Tableau for various business calculations.
• Created and assisted users in Tableau dashboard development.

Environment: SQL Server 2000/2005/2008 R2 Enterprise Edition, T-SQL, MS Access, MSBI, MS Excel, & Windows 2003 server, TFS, Business Intelligence technologies like SSIS, SSRS, VSTS2008, BIDS, Tableau Desktop 7.0