Dhanya Pellissery

Tableau Developer/Visualization expert

Email id: acvd1k@r.postjobfree.com

Phone: 848-***-****

PROFESSIONAL SUMMARY

* ***** ** ***** ** EXPERIENCE in Software development and data warehousing using both ETL and BI Reporting tools.

Excellent exposure in developing Tableau Reports for Banking / Financial Application.

4 Years of progressive experience in Tableau.7,8 &9 versions for Business Analysis, Reporting and Dash-boarding for enterprise applications and experience on Tableau server side.

Creating UI visualizations with Tableau Desktop, Tableau Server and Tableau Reader

2 Years work Experience in using ETL Tool INFORMATICA

3 Years of Experience in Web Development and windows applications and products using visual studio 2010, 2008, 2005, VB, ASP.NET, Dot NET Frame Work Methodology, team foundation server, IS web servers and database like SQL Server 2008/2005.

Expertise in Reports and Dashboards that are published on the Tableau Server

Experienced and fully engaged in Software Development Life Cycle (SDLC) which includes gathering and analyzing business requirements, functional/technical specifications, designing, developing, testing, deploying the applications and providing production support.

Experience in design and development of interactive data, data visualizations, graphical dashboards and reports using any tools like Tableau.

Experience in creating user,groups,projects on tableau server.

Handled Tableau server side for user permissions,grouping, scheduling reports

Scheduled data extracts and subscriptions on a daily basis.

Extensive Knowledge on Tableau Desktop, Tableau Public, Tableau Reader,Tableau Server

Comfortable with advanced tableau topics such as complex calculations, table calculations, Filters, parameters, data blending, extract optimization.

Experienced in Designing & Formatting Dashboards using Tableau.

Experience in working with data warehousing ETL Tool INFORMATICA.

Experience in working with Operating Systems like Windows XP/07.

Developing business requirements, dashboard development, and data verification and analysis

TECHNICAL SKILLS

BI Tools : Tableau6, 7, 8.1,8.3,9

ETL TOOL : Informatica Power Center 9.1/8.6

Language : SQL, PL/SQL

RDBMS : Oracle 9i, 10g,11g

Web Technologies : ASP.NET, HTML, HTML5, AJAX, Web-Services.

Scripting Language : XML, CSS, Java Script, WSDL, XSD

Technology : MS.Net Framework 1.1/2.0/3.0/3.5/4.0, ADO.NET

Database : Oracle 10g,11g,Ms-Access,MS-Access

Development Tools : Microsoft Visual Studio .NET 2005/2008/2010

Web Server : IIS5.1, IIS 6.0 and IIS 7.0

Operating Systems : Windows 7/NT/2000/XP/2003

Programming Languages : VB, Net, C++, Core Java

PROFESSIONAL EXPERIENCE

June2012 –till date

Tableau Developer/Administrator

Citigroup

Warren, NJ

Description:

Citigroup, the leading global bank provides consumers, corporations, governments and institutions with a broad range of financial products and services. Citi bank distinguishes themselves by the quality of their service. Citi bank use TABLEAU to provide web-based reports for clients & sales, monitor loss and manage risk across geographies. Also several reports were developed for Customer ( corporate / personal ), Loans reports, High profile Transactions, End of Day reports, Customer account level Reports, Pending Standing Instructions reports, SWIFT Unprocessed reports, ACH Payment /Collection Exception reports, Monthly Interest and Charge Reports, Retail Teller Daily Transaction reports, Annual P/L Reports, Adhoc Intra-Day Reports, General Ledger Daily Balance reports, Daily Interest rate reports, RTGS High Volume Transactions reports, Account /Transaction Reconciliation reports, ATM Rejected transaction reports, Teller Till / Vault Detailed reports . All these Server side reports administration was also take care by me.

Also specific MONTHLY/ QUARTERLY reports were developed for bank to know bank’s current position.

Responsibilities:

Interact with Business users and understanding their requirements.

Developing, Designing and supporting interactive Tableau Dashboard reports.

Recommending Dashboards per Tableau visualization features.

Creating UI visualizations with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 9,8,7,6 versions.

In addition to the above mentioned standard reports, business uses will request for adhoc intra-day reports which was also developed using Tableau.

Delivering reports to Business team on timely manner.

Extensive experience working with Business Intelligence data visualization tools with specialization on Tableau.

Expertise in mapping and visualization in Tableau

Also developed in-house reports for management decisions.

Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.

Involved in migration Project of legacy reports to Tableau.

Extensively worked with HTML5, CSS, and Javascript

Designed multiple Dashboards with the help of tableau features like Sets,Parameters,Quick Filters,Actions,Bins etc.

Used different graps in tableau such as Bubble chart,pie chart,heat maps,bar graphs,Box plots,scatter plots etc and different type of filters like quick filter for creating dashboards.

Made us of all type of actions available in tableau such as Filter action,Hover action and select action for more the reports.

Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Designed Story boards for better visualization.

Demonstrated design and UX sensibilities

Development of Scorecards, KPI dashboard and detailed drilldown dashboards based on Hierarchy

Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues.

Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.

Ensured projects were completed on time and within budget.

Played key role in enhancing client’s Web reporting system, reducing time of delay financial tracking analysis by 30%.

Handled Tableau server side for user permissions,grouping, scheduling reports

Scheduled data extracts on a daily basis.

Worked with all levels of development from analysis through implementation and support. Participated in test planning and test script definition.

Resolved end user reporting problems through collaboration with IT and Operations

Environment:

Windows 7, Tableau7, 8.1,9 Tableau server, SQL Developer, SQL-PLUS, MS-Excel, Oracle,10 11g

Jan 2010 – Feb 2012

Informatica Developer

Client Fed Ex

Description:

MY Client was FedEx,which is the world's leading delivery company for overnight packages with its headquarters located in Memphis, TN. It is one of the global companies, present in 220 countries and about 75000 cities across the world. The main aim of the project is to have the details of all the orders and transactions of FedEx. This project is developed for Executive business management, financial and profitability analysis, Sales force management, Marketing Campaign and product analysis.

Responsibilities

Used Informatica ETL to load data from flat files, which includes fixed-length as well as delimited files and SQL Server to the Data mart on Oracle database.

Used reverse engineering in Erwin 4.x to understand the existing data model of the data warehouse.

Worked with creating Dimensions and Fact tables for the data mart.

Created Informatica mappings, sessions, workflows, etc., for loading fact and dimension tables for data mart presentation layer.

Have implemented SCD (Slowly Changing Dimensions) Type I and II for data load.

Did performance tuning of Informatica components for daily and monthly incremental loading tables.

Developed Mapplets, reusable transformations, source and target definitions and mappings using Informatica 7.1.

Developed mapping using parameters and variables.

Created complex workflows, with multiple sessions, worklets with consecutive or concurrent sessions.

Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Informatica Workflow Manager.

Used Workflow Manager for creating validating, testing and running sequential and concurrent batches.

Implemented source and target based partitioning for existing workflows in production to improve performance so as to cut back the running time.

Analyzed workflow, session, event and error logs for trouble shooting Informatica ETL process.

Worked with Informatica Debugger to debug the mappings in Informatica Designer.

Involved in creating test plans, test cases to unit test Informatica mappings, sessions and work flows.

Involved in migrating Informatica ETL application and Database objects through various environments such as Development, Testing, UAT and Production environments.

Documented and presented the production/support documents for the components developed when handing-over the application to the production support team.

Designed, developed, implemented, and supported QlikView dashboards. Integrated data sources and databases with QlikView, and designed and developed data models and backend queries for presenting data.

Environment:

Informatica Power Center 8.1, Workflow Manager, Workflow Monitor, Qlickview,TOAD 8.6.1.0, SQL Developer, Flat files, XML, Oracle 10g/9i

Dec 2006 – Jan 2010

ASP.NET Developer

KERALA INFOTECH

Description:

This project is aimed at developing an online Sales and Inventory Management System (SIMS), this

system can be used to store the details of the inventory, update the inventory based on the sale details, produce receipts for sales, generate sales and inventory reports periodically etc.

Responsibilities:

Analyzed the Functional Requirements Specifications and System Design Specifications and

Designed and implemented User Interface Layer using ASP.NET, C#, JavaScript and HTML.

Created ASP.NET User Controls to reduce the complexity of user interface design.

Performed the Validation of the web pages using validation controls and JavaScript while

Interacted with the team.

Inputting the required information.

Played an active role in writing business logic for Business Access Layer (BAL) and Data

Involved in creating the web service and consuming the web services to achieve the business

Designed Web Forms using HTML and Cascading Style Sheets (CSS).

Extensively used AJAX Controls for quick user experience through Partial Page Refresh.

Used ADO.NET data objects such as Dataset, DataAdapter, Data Table, DataReader and

Utilized ADO.NET technology extensively for data retrieving, querying, storage and

Involved in the design of the Database and developed Stored Procedures, Triggers and

Involved in testing of application at module level, system level and User Acceptance level for

Worked closely with users to ensure application development meets to user’s expectations.

Involved in developing and organizing custom error pages and exception handling.

Used Visual Studio Team System (VSTS)’s Team Foundation Server (TFS) for source

Environment:

Microsoft .NET framework 2.0/3.5, Visual Studio 2008, SQL Server 2008, T-SQL, ASP.NET, C#, AJAX, XML, HTML, CSS, JavaScript, Web Services, IIS, TFS.

EDUCATION

Masters in Computer Science – Calicut University, India - May 2006

Contact this candidate