SUMMARY

• Around 6 years of experience in Data Visualization, Tableau, Business Intelligence & have worked in developing reports and Dashboards in Tableau.
• Around 5+ years of experience in building both n - tier static and interactive web applications & e-business projects using ColdFusion, Asp.Net, JavaScript, CSS, Oracle 9i, SQL server 2005/2008 and ColdFusion Application Server and Java
• Extensively worked on various Tableau desktop 7.x/8.x/9.x/10.x versions, Tableau Server, Tableau online, Tableau reader.
• Experience in creating dashboards using calculations, groups, sets, parameters, calculated fields, and hierarchies.
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services ( SSRS), Tableau and POWER BI.
• Experience in creating filters, quick filters, data source filters, global filters, context filters and user filters
• Extensive experience in creating Calculations (Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Marks Card Changes, Rich Text Formatting,) using Tableau Desktop.
• Strong knowledge OLAP and OLTP systems and Experience in using Dimensional Data Modeling and Relational Data Modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & Logical Data Modeling for designing Data warehouse / Datamarts.
• Data blending to create views combining data from multiple data sources.
• Extensively worked on databases like Oracle, SQL Server, DB2 and Teradata.
• Effective Ability to create Custom Tableau reports using SQL and advanced Tableau mapping.
• Extensively involved in creating users, user groups, roles, scheduled instances for reports in tableau server.
• Expertise in SQL Server Integration Services and SQL Server Reporting Services (SSRS) and with good knowledge on SQL Server Analysis Services (SSAS).
• Extensive experience in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Waterfall Charts, Geographic.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Experience in connecting and extracting data from different data sources.
• Extracting data from data sources like Sales force, SQL server and Excel files for getting data to Tableau for creating various dashboards.
• Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option and Parameterized and Linked reports using Tableau.
• Experience in publishing Dashboards and presenting dashboards on web and desktop platforms to Tableau Server.
• Exposure to Amazon web services.
• Experience Working in Agile, Waterfall and Scrum project management methodologies.
• Worked with the data architects and ETL team to finalize the data model and transformations for the data mart
• Consistently delivered results in various stages of Software Development Life Cycle (SDLC).
• Experience in documenting the testing process using MS-Office tools including MS-Word, MS-Excel, and MS-Project.
• Experience in data modeling techniques like Snowflake Schema, Star schema, Fact, and Dimension tables.
• Strong knowledge of Software Development Life Cycle (SDLC) methodologies like waterfall, Agile Scrum.
• Excellent rapport with developers, testers in all the projects and worked in close collaboration with team members to ensure enhancement of software quality.
• Excellent skills in communication & collaboration, Strong analytical, logical, problem-solving skills and ability to quickly adapt to new technologies by self-learning.
• Strong experience in programming with .NET framework and using C#, Asp.Net, Web API, WCF services.
• Experience in Web Services, WDDX and Fuse box

TECHNICAL SKILLS

Tableau: Tableau desktop 7.x/8.x/9.x/10.x, Tableau Server, Tableau online, Tableau reader

Web Technologies: ColdFusion, Adobe Pagemaker, Photoshop, Adome Image ready, Visual studio .net, Viusal source Safe, ShockWave

ETL Tools: Informatica, SSIS, SSRS, SSAS.

Databases: MS SQL Server, Oracle 10g,11g, Teradata

Programming Languages: SQL, TSQL, PL/SQL

Scripting Languages: HTML5, CSS5, JavaScript

Operating Systems: Windows XP/7/8/10,Mac,Unix

Methodology: Agile, Waterfall, Scrum

PROFESSIONAL EXPERIENCE

Confidential - Dulth, GA

SQL /Tableau Developer

Responsibilities:

• Performed as Tableau Developer and Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Worked closely with Business Analyst in gathering various requirements.
• Responsible for writing Business Requirements Document (BRD), Use Case Specifications, Functional Specifications Document (FRD).
• The building, publishing customized Interactive reports and Dashboards, report scheduling using Tableau Server.

  Extracted data from internal data warehouse system to SSRS.

• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Create tabular and matrix reports by using SSRS and use stored procedures and functions to create SSRS reports.
• Exposure to Amazon web services.
• Created Adhoc reports to users in Tableau by connecting various data sources.
• Generated Dashboards by joining multiple complex tables.
• Created security parameters for tableau dashboards at the row level.
• Used excel sheet, flat files, CSV files to generate Tableau reports.
• SQL Server Reporting Services (SSRS) and with good knowledge on SQL Server Analysis Services (SSAS).
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Experience in SQL Server 2012 Self Service BI tools like Power view, BISM Tabular models and SQL Server Data tools.
• Used advanced concepts - blending, LOD to meet the customer requirements.
• Experience in Data Conversion and Data Migration using DTS and SSIS services across different databases like Oracle, MS access and flat files.
• Generated Dashboards with Quick filters, Parameters, and Sets to handle views more efficiently. Published Workbooks by creating user filters.
• Hands-on development assisting users in creating and modifying Worksheets and Data Visualization Dashboards.
• Designed and developed stored procedures, queries, and views necessary to support SSRS report
• Created report schedules, Data Connections, Groups in Tableau server.
• Generated Tableau Dashboards for Sales with Forecast and Reference Lines.
• Developed Parameter based reports, Drill-down reports, Charts and Tabular reports using Tableau and enabled ad-hoc reporting.
• Executed and tested required queries and reports before publishing.
• Involved in creating Complex Stored Procedures, triggers, cursors, tables and views and other SQL joins.
• Connected Tableau Desktop with Teradata to extract data from stored procedures and custom SQL to plan refresh timings and publish to tableau server.
• Used snowflake
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Skilled in Tableau Desktop for data visualization through various charts such as Bar Charts, Line Charts, Scatter Plots, Pie Charts.
• Created extracts and published data sources on Tableau Server for the users from various databases.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on a business change to ensure that the views and dashboards were displaying the changed data accurately.
• 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 server, Tera Data 14, Teradata SQL Assistant, My SQL, Oracle, MS Excel.

Confidential - Wellesley, MA

SQL/Tableau Developer

Responsibilities:

• Performed as Tableau Developer and Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Interacted with client to understand the requirements.
• Worked on New report, dashboard requests using Tableau 8.x on top of Oracle 10g, Teradata.
• Tuned the SQLs, reports for improved performance.
• Resolved multiple report errors.
• Tried to reduce the disk space by implementing snow flake schema.
• Used snow flake schema to fetch the data and to normalize the low-level data redundancy
• Extensive use of T-SQL DDL and DML commands for various applications.
• Visualized data by creating Charts and Graphs (bar graphs, line charts, pie charts, Tree maps, Bubble Charts, Waterfall Charts, Bump Charts, Funnel Charts, and Bollinger Charts) based on client's need.
• Created a number of SSIS packages using advanced tools to pull data from various data sources including flat files, MS-Access, Excel, SQL Server/Oracle databases, etc.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Created SQL Agent Jobs, Alerts, to schedule DTS/SSIS packages.
• Experience in creating multiple reports ( SSRS) in Drill mode using tables, financial tables, crosses tabs and charts. Handled Tableau admin activities granting access, managing extracts
• Excellent Knowledge in Data Warehouse Concepts, Data Modelling, ETL and worked on OLTP & OLAP in all environment which includes development (DEV), test (QA) and production (PROD).
• Experience with Teradata/ Oracle/ MS SQL Server and ability analyse data sets using SQL.
• Experience in working with Oracle 12g/11g/9i/8i, MS SQL Server 2000/2010/2012/7. x running on Windows 2000/XP.
• Analyzed several data issues and got them corrected where applicable.
• Extensively worked on different types of filters.
• Used trend lines extensively for correlating different KPI’s for new product launches.
• Created custom Function's (Date range, Time functions, Logical functions) in the reports.
• Scheduled extract refresh and subscriptions for weekly and monthly reports.
• Worked on administration tasks like adding workbook Permissions, Ownerships and User filters.
• Provided training to Business users in using Tableau.

Environment: Tableau Desktop 8.0, Tableau server / Administrator, Windows/RHEL, Oracle 10g, Teradata, SAP Business Objects 3.1, 4.0.

Confidential, Greenwood Village, CO

ColdFusion Developer

Responsibilities:

• Designed the front-end screens using H TML, CSS, ColdFusion and client side scripting in Java Script, Ajax
• Replaced outdated custom tags to CF components
• Developed Cold Fusion value objects and service objects
• Implemented Json to transmit data between the server and the application.
• Developed the web services to call the third-party components from ESP or CONVERGYS
• Implemented the web services to integrate with front end systems to display the most upto date information to the user systems
• Developed Cold Fusion Components for business functionalities.
• Deployment of the code to testing, UAT servers’ every day to help the off-shore testing team to validate the code.
• Documented all stages of the project and involved in fixing the bugs and debugging existing
• ColdFusion code and gave production support for the entire application.
• Involved in the system integration and testing.
• Used MVC Framework for development of the application.
• Created and updated user documentation for each of the application developed.
• Created design documents for the application flow using TIBCO
• Implemented the application using Fuse Box methodology.
• Implemented AJAX for UI blocking.
• Helped reporting team upgrade the Oracle Discoverer 10G reports to crystal reports and into Tableau dashboards.
• Triaging defects in war room in the final stages of the project with all the front-end, backend teams to solve them then and there.

Environment: ColdFusion MX 8.0, Eclipse SDK 3.5, Json, Jquery, Adobe Flex 3, XML, Crystal Reports, HTML, ColdFusion Reports, AJAX, Jnuit, Adobe Photoshop cs3, Java Script, Oracle 10g, TIBCO, HP quality Center, JIRA perficient.

Confidential, BlueAsh, OH

ColdFusion Developer

Responsibilities:

• Analyzed the project environment and sub systems of the project and prepared a high level documentation for application designing.
• ColdFusion Administrator: set up the environment, data sources and server mappings.
• Developed the stored procedures and triggers as per the business logics to present the data to the end user.
• Responsible for conceptualization, design, layouts and logic flow of the project.
• Involved in the creating of database objects like tables views, stored procedures, functions, packages, DB triggers and indexes using the latest Oracle 10g.
• Involved in Unit testing and Integration testing.
• Responsible in creating reports using Oracle Discoverer 10g
• Integrated flex with coldfusion
• Implemented the web services to integrate with back end office systems
• Developed ColdFusion Components and custom tags.
• Upgrade current application from CF 6.0 to CF8.0 version.
• Created stored procedures in PL/SQL for backend database access.
• Involved in writing DTS packages
• Installing ColdFusion on different systems (including clustering) and configuring those with appropriate database.
• Installed SQL server 2008 on windows 2003 advanced servers, applied security fixes.
• Creating users for accessing ColdFusion admin server with appropriate rights.
• Enhanced existing user interfaces.
• Developed the new Custom Tags and CFCs.
• Created and altered technical illustrations using Adobe Illustrator and Quicksilver
• Database Maintenance and support for backup Databases.
• Involved in Data mapping and migration process from SQL Server to Oracle Database.
• Used ColdFusion reports for integrating with websites, also for analyzing data.
• Creating Flex AIR desktop applications, with the use of XML, Photoshop, flash etc.
• Integrating FLEX applications with COLDFUSION.

Environment: ColdFusion MX 6.1/8.0, Adobe Dreamweaver CS3, Adobe Flex 3, Adobe Flash CS3 with Action Script 3.0,XML, Crystal Reports, HTML, ColdFusion Reports, Adobe Fireworks CS3, Adobe Photoshop cs3, Java Script, SQL Server 2008 and 2005/Oracle 10g.

Confidential, Alpharetta, GA

Software Developer

Responsibilities:

• Implemented Model-View-Controller (MVC) architecture.
• Created Use case diagram, Class, Sequence diagrams for the module.
• Used Struts/MVC framework to standardize the interactions between the JSP/View layer, the action controller and the underlying Form model. Internationalization was inherent to the design the objects that were locale to the database.
• The Servlets are used to populate the data on web application.
• Used TCP/IP protocols at Application Layer for communication.
• HTML, DHTML and JSF has been implemented to maintain the static and dynamic content.
• Increased speed and memory efficiency by implementing code migration to convert python code to C/C++.
• Reviews all data models for technical accuracy. This includes the enforcement of all modelling and naming standards. Performs all structural changes to DB2 databases.
• Used SPRING batch process to generate reports for the credit team to count the customers.
• Used JDBC, application server provided transaction API for accessing data from the Oracle the using standard statements.
• Implemented database layer using EJB 3.0 and Java Persistence API(JPA) in maintenance projects.
• Generated Model layer of MVC using EJB
• JDBC has been used for the connectivity of database.
• Used Asynchronous JavaScript Technology and XML (AJAX) for critical front-end validations to reduce the burden on the server side.
• Used Gradle Maven as a build and deployment tool.

Environment: JAVA/ J2EE, C++, JDK 1.5, JSF, Servlets, Struts 1.2. MVC Architecture, JUnit 3.0, JMS, JavaScript, WebServices, HTML, XML, AJAX, JNDI, Weblogic8.1, DB2, EJB, JDBC, CVS, Eclipse.