SUMMARY:

• 8+ years of professional IT experience in Designing, Administration, Analysis, Management in the Business Intelligence Data warehousing, Client Server Technologies, Web - based Applications and Databases and Experience.
• Excellent understanding of data warehouse specific Architecture, Design and Procedures, ETL and workflow development, data cleansing, data quality validation and unit testing.
• Expertise in latest BI Tools such as Tableau, Qlikview, Qliksense and Spotfire
• Experience in complex BI Reports, Dashboards, Project Management, Change/Incident Management, Maintenance, upgrade, Fix pack/Service pack installations, and Root cause analysis, Resolution Methods Time/Cost/Budget Management.
• Created Dashboards and developed reports using various tools like Tableau/QlikView/Qliksense procedures and
• Objects.
• Experience in Incremental Loading/Refresh in Tableau and document Versioning.
• Experience with sheet objects including multiple charts types, Trends, KPI’s, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting.
• 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 in Data Interoperability, Analytics and BI and Production Support issue resolution.
• Expertise in working with Data Warehousing and business intelligence tools for developing various Dashboards.
• Administered Tableau server and client environments including environment optimization and troubleshooting for Access Point, Publisher, server and client installations as needed
• Implemented security in BI Applications at Document and Server Level.
• Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
• Gathered fair understanding of Tableau application administration encompassing Planning/Implementing User, Resource and Password Management, Backup & Recovery Strategies, Performance Tuning, Creation and configuration of database on Oracle.
• Experience in working with various types of charts (Line chart, Bar chart, Pie chart, Gauge charts, Straight/Pivot Tables, Scatter Plot etc.).
• Experienced in working with many complex SQL queries with Joins, Date functions, Inline functions, and Sub-queries to generate reports.
• Hands on experience on MS Visio, MS Project, MS Outlook, MS Power point, MS Excel (pivot tables and pivot charts), MS Word and MS Access.
• Hands on experience in analyzing, testing, gathering and documenting requirements.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and
• Dimensional Tables.
• Identify, propose and implement enhancements over the existing reports to improve user experience.
• Created Master Library with the dimensions, Measures and Visualizations.
• Developed applications in Tableau Desktop and shared the apps with the team through Tableau Public.

TECHNICAL SKILLS:

BI Tools: Tableau, QlikView 10/11, QlikView Server/Publisher 10, Qlik Sense, Business Objects, Crystal Reports, WebI, MS Excel, Cognos 8/10 BI Suite/Scripting.

Database: MySQL, MS SQL Server, Oracle 9i/10i/11g, MS Access and MongoDB

Modeling: Transformer & Framework Manager

Languages: SQL, PL/SQL, Java, VB, HTML, DHTML, XML, JavaScript

OS: Windows XP/Vista/7/8/10, Windows 2000, Server 2003, Server 2008, Server 2012 and Linux

PROFESSIONAL EXPERIENCE:

Sr. Tableau Developer /Business Intelligence

Confidential, Hoffman Estates, IL

Responsibilities:

• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Participated on business requirement document preparation
• Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.
• Interacted with business users and business analysts to understand the requirement and reviewed high level design documents and functional specification documents
• Key advisor performance indicators using SQL scripts, on multiple projects, giving expert guidance on governance, reporting techniques and project management, performance improvement
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Rebuilt dashboard applications on both front-end and back-end UI, developing scripting template, UI design and coding standards, design guidelines, migrations strategy and implementation plan
• Worked on building queries to retrieve data into Tableau from SQL Server 2008 and Oracle SQL Developer, and developed T-SQL statements for loading data into Target Database.
• Created Tableau dashboards of call handling forecasting, call rate, call waiting time and call forward, average call time
• Maintained and administered source documents and sets, user profiles and executed resource management services like Access point resources, distribution folders and email servers and to monitor user access to manage the limited number of licenses
• Enhanced existing dashboards with new functionalities and Tune ETL scripts for better performance
• Developed user interactive sheets and reports as business needs and for writing SQL scripts to load the relevant data in Tableau applications
• Created SQL stored procedures and views to fetch the data from database to build reports
• Developed scripts for data reloading, mapping and transformation and maintained and updated the dashboard reports as required by the clients
• Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps, Pareto charts according to deliverable specifications.
• Conducted and guided Tableau BI application global roll out, managed QA testing, user acceptance testing, software update, migration deployment and parallel run, stabilizing the server platform and application to achieve the steady state for transitioning
• Experience in standardizing Tableau for shared service deployment.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.

Confidential, Irving, TX

Sr.Tableau Developer

Responsibilities:

• Actively participated with business users and functional team to understand the reporting requirements and worked on all phases of the project.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Imported data from different sources like Oracle, SQL Server, MS Access, XML files, QVDs and flat files using OLE DB/ODBC.
• Developed scripts for data reloading, mapping and transformation by using joins, concatenations, resident loads and temporary tables.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data
• Optimized existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
• Worked with various Sheet Objects, Charts (including Drill Down and Cyclic field grouping), Table box, Lists, Input box, Master Calendar.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and dashboard using KPI’s.
• Utilized capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dash board actions and Table calculations.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop Expert in generating complex, dashboard reports, AdHoc, business views along with user acceptance test and data accuracy test .
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality .
• Preparing Dashboards using calculations, parameters in Tableau.
• Creating section access code and binary loads for un-compromised security and quick reloading of applications.
• Involved in performance tuning of dashboards to limit the response time and enhance the functionality.

Confidential, Charlotte, NC

PL/SQL Developer

Responsibilities:

• Involved in performance tuning of stored procedures and SQL queries.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Upgraded Oracle 9i to 10g software in different environments for latest features and also tested databases.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Worked on XML along with PL/SQL to develop and modify web forms.
• Designed Data Modeling, Design Specifications and to analyze Dependencies.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.

Confidential

Business Intelligence Developer

Responsibilities:

• Hands on experience with PL/SQL scripting in Toad and Oracle Enterprise Manager.
• Experienced in analysing all business functionalities related to back-end database interface.
• Extensively used PL/SQL Developer for creating database objects, running the command scripts for inserting the configuration data items.
• Designed Web-based Internet applications linked to firm-wide SQL databases.
• Creating and Debugging of Packages and Procedures & Functions and troubleshoot jobs using the debugging tool.
• Analysed business process workflows and developed ETL procedures for moving data from source to target systems.
• Involved in Analysis, Coding, Testing and Implementation of various modules and reverse engineering of the application using Erwin. Used Erwin to transform data requirements into data models.
• Automated data loading, extraction, reports generation using UNIX Shell scripting and loading data by using SQL* Loader to custom tables.
• Worked on materialized views, DBMS SCHEDULER for scheduling jobs and UTL MAIL to send mails using oracle 10g.
• Implemented shell scripts for trouble shooting Oracle Errors with the help of trace files and scheduled them.
• Configured database performance tools such as Oracle Enterprise Manager, SQL Navigator and used them for tuning of applications.