SUMMARY

• Over 5 years of IT experience in Database Development of Oracle, MS SQL Servers 2008, in Production, QA, and Development environments Extensive IT Professional experience with expertise in Tableau Development, Modeling, Data Warehousing, Design and Technical management
• Technical hands - on experience using Tableau 9/8.1/8.
• Hands on experience in creating workbooks and dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions Tableau 8 and Tableau 8.1
• Publish Tableau Dashboards in Tableau Server, Tableau public Premium.
• Partnered with Business stakeholders and executives with the goal of providing them with the ability to make decisions and gain insights through data visualization reports and operational reports.
• Experience in building prototypes for demonstration and illustration purposes for Business partners and senior leaders
• Developed dash boards with rich Graphic visualizations, Drill Down and Drop down menu options, Parameterized using Tableau.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines and Statistics. Groups, hierarchies, Sets to create detail level summary reports and dashboards using KPI'
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring complex business logics and detail-level data analysis.
• Administered user, user groups, and scheduled instances for reports in Tableau
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Expert Knowledge of Integration Services (SSIS) package design, constructing, and deployment.
• ETL implementation using SQL Server Integration Services (SSIS).
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
• Developing reports on SSRS on SQL Server 2008, Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards in Tableau.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Parameterized, Drill-down, Top N, Adhoc, Form, OLAP and Sub reports, and formatting them.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2008
• Great ability to create and manage various database objects like tables, views.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in Performance Tuning and Query Optimization.
• Excellent communication skills, analytical skills, understand business requirements in various domains.

TECHNICAL SKILLS

Languages: C++, T-SQL, PL/SQL,HTM

Databases & Architecture: Oracle, MS SQL Server 2008, Relational DBMS, Client-Server Architecture, OLAP, OLTP

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, Export & Import (DTS), SSIS, SSRS, Database Tuning Advisor, SQL* Plus, Performance point server, ProClarity

BI Tools: Tableau 9.1, 9.0 and 8.X

IDE: Microsoft Visual Studio 2005

Web Technologies: HTML, Java

Platforms: Windows XP/NT/2000 server

Other Tools: ERwin, MS Visual SourceSafe, MS Office suite, MS Visio, SPSS

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Tableau Developer, Oracle/SQL Server

Responsibilities:

• Worked a great extent with the design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies etc.
• Created solution driven dashboards by developing different chart types including Crosstab’s, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Created Tableau workbooks with calculations, parameters, Quick Filters.
• Worked and generating various workbooks and dashboards extracting date from various sources such as Oracle, SQL Server and data files using data blending and joins.
• Created parameters for Prompts in Calculations for various workbooks and dashboards
• Developed workbooks and dashboards using Tableau Visualizations like Heat maps, Pie Charts, Dual Axis workbooks and Charts, Bar Graphs, Scatter Plots, Trending and Forecast dashboards, Waterfall Charts, Geographic maps using local and global filters.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Responded to users’ requests for additional data
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Design and development of custom controls.
• Developing the stored procedures according to business requirements.
• Developing and updating Lookup pages to populate values to the controls
• Performed Analysis and design of implementing a Start Schema Data Mart with Facts and Dimensions.
• Involved in creating various reports using SSRS that helped users made informed decision.
• Took the responsibility of preparing the Functionality Test Plan which was used to test system inputs and outputs in the pre production stage.
• Responsible for analyzing post implementation issues by looking at the various reports created based on the new system.
• Installed and configured systems and trained team members that were responsible for creating reports based on the new system.
• Performed Data Analysis and Data validation by writing complex SQL queries using SQL against the SQL server database.
• Worked with the DBA and Database developers to convert the functional specification to technical specification.
• Closely monitored the system performance after implementation to address any minor performance issues and evaluate the overall system.
• Wrote complex SQL queries to pull and process data from multiple data sources (SQL Server, flat files, etc).
• Designed and programmed re-usable SQL code to prepare data for analysis.
• Downloaded data from various sources.
• Loaded data into SQL database and convert it to applicable dataset to make it ready for report generation.
• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Installation and configuration of SQL Server 2008.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports, Linked Reports, and Reports using stored procedures using Sql Server Reporting Services 2008.
• Experience in creating Adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008.

Environment: Tableau, Oracle, SQL Server 2005/2008 Enterprise Edition, SSIS, T-SQL, SSRS. SMTP Server Campaign.

Confidential

Tableau Developer, SQL /SSIS developer

Responsibilities:

• Created bar, pie, line charts, area, geo maps, heat maps, scatter plots, crosstabs, and combined them into dashboards which allowed interactivity within data. Using tableau
• Creating Ad-hoc reports on demand, Gathering Business requirements for custom reports.
• Created views and dashboards that are presentable to internal and external vendors.
• Build advanced chart types and visualizations bar in bar charts- bullet graphs, box and whisker plots - pareto charts.
• Implement advanced geographic mapping techniques and using custom images and geo coding to build visualizations of non-geographic data.
• Combine data sources by joining multiple tables and using data blending, visualizations techniques.
• Created Backup scripts to take periodic backups for the content on Tableau server.
• Worked on the requirement gathering of the reports
• Analysed the database tables and created database views based on the columns needed.
• Created dashboards displaying sales, variance of sales between planned and actual values.
• Implemented calculations and parameters wherever needed.
• Published dashboards to Tableau server.
• Build dashboards using techniques for guided analytics, interactive dashboard design, and visual practices,
• Scripted Custom SQL and used Custom SQL option to connect to a specific query rather than the entire data source
• Created Individual Axes, Blended Axes, Dual Axes and combination charts to compare multiple measures in a single view.
• Created Map Views with custom geo coding
• Created Tableau Data Extract and Tableau Packaged Workbook (Dashboards) using Tableau Desktop and published and shared them
• Installation and configuration of SQL Server 2008.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2008.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Extensive testing and migrating the reports or objects from development to Production system.
• Developed testing scripts and test cases.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy exact lookups using SSIS tasks.
• Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS package.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: Tableau, Oracle, SQL Server 2005/2008 Enterprise Edition, SSIS, T-SQL, SSRS, Windows Server 2003.

Confidential, Chicago

Software Engineer

Responsibilities:

• Analysis of requirements for new project and impact analysis.
• Preparing the project and deployment plan of the activities.
• Preparation of Functional Specification, Technical Specification documents.
• Requirement Gathering.
• Develop the solution for collaboration with other processes in Team centre.