SUMMARY

• Over 7 years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• 4 years of extensive Tableau Experience in Enterprise Environment, in Tableau 7.0, 8.0 and 8.1.6,8.2 as a Developer and Analyst.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management End to end experience in designing and deploying data visualizations using Tableau.
• Involved in various projects related toData Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Experience in developing 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.
• Extensive experience in Data Analysis.
• Practical understanding of theData modeling(Dimensional & Relational)concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Extensive experience working on trend reports, service provider functionality, sample assessment, online business intelligence, fleet management systems and capital markets.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Experience in client requirement Analysis, Physical and Logical design, Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2008/2005/2000/7.0 , DTS, SSIS,SSRS and SSAS.
• Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services SSIS/DTS.
• Providing technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
• In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies.
• Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.

TECHNICAL SKILLS

Specialties: Data Visualization, Business Intelligence (BI), Software Management and Data Collection.

BI Tools: Tableau 7.0,Tableau 8.0/8.1.6,8.2.SSIS, SSRS,SSAS

Relational Databases: Oracle 10g/11g, TERADATA, SQL Server 2005/2008, VERTICA

Tools: and Packages SQL Server Management studio, Toad, Profiler, Microsoft Visual Studio, Crystal Reports

Languages: SQL, PL/SQL, C, C#, ASP.Net, HTML, XML, XSL

Operating Systems: Windows 2008, Windows 2000/2003 Server, Data center, Windows NT, Windows 95/98/2000 XP, UNIX, LINUX.

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, OH

Sr. Tableau Consultant / Data Analyst

Responsibilities:

• Supported over 3,500 databases, which consumed over 10TB of data and spanned over 180 instances running SQL Server: 6.5, 7.0, 2000, 2005, 2008, 2008 R2 and 2012.
• Worked on multiple Installations, Configurations and Maintenance of SQL servers 2008, 2008R2 and 2012 according to the UH policies and best practices.
• Was involved in Migrations from SQL R2/2012 and SQL R2/2012.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Analyzing raw data, drawing conclusions & developing recommendations
• Writing T-SQL scripts to manipulate data for data loads and extracts.
• Capture technical metadata through data modeling tools.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Responsible for maintaining the integrity of the SQL database and reporting any issues to the database architect.
• Assisted in mining data from the SQL database that was used in several significant presentations.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Developed and implemented a suite of custom maintenance and monitoring solutions.
• Worked directly with project managers, developers, customers and vendors planning and implementing new environments as well as restructured and rebuilt existing environments.
• Assisted internal development teams with database design, performance tuning, security, maintenance and management.
• Data Modeler with strong Conceptual and Logical Data Modeling skills, has experience with JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications, queries.
• Checking Database Health by using DBCC Commands and DMVS.
• Monitored and modified Performance using execution plans and Index tuning.
• Handling the RFC’s and work orders assigned to me as part of daily responsibilities.
• Resolved the issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk I/O.
• Provided 24*7 on- call support to SQL application developers in implementing the applications on production server.
• Experienced in programming tasks-Stored Procedures, Triggers, Cursors using SQL Server 2008/2005 with T-SQL
• Strong T-SQL Developer skills including stored procedures, Indexed views, User Defined Functions (UDL), Triggers, and Distributed Queries.
• Worked with Server Storage team for database backups using TSM (Tivoli Storage Manager).
• Participated in the creation and update of, adherence and compliance to company database standards, policies, procedures and best practices.

Environment: Tableau, Windows, MS-SQL Server, SSIS, .NET Framework, Performance Monitor, Visual Studio, SQL Profiler, Red Gate, Event Viewer, Lite Speed5.0, T-SQL, TSM, Idera Diagnostic Manager, Quest Spotlight, KeePass.

Confidential, Jersey City, NJ

Tableau Developer and Admin / Data Analyst

Responsibilities:

• Scope of the project was to enhance the Mobile Banking App's systematic processes which were associated with Confidential Personal Banking division.
• Developed Tableau Dashboards for app usage data based on login time status, usage of pay bill capability, and transfer money to get better understanding of future enhancements.
• Involved in end to end implementation and enhancements on Mobile Banking App data starting from requirement gathering and dashboards development in Tableau Desktop.
• Assisted in offering support to other personnel who were required to access and analyze the SQL database.
• Studied and analyzed similar applications and brainstormed with business team to gather effective requirements for the system along with dashboard development.
• Created numerous dashboards in Tableau Desktop based on the data collected from Mobile Banking App by importing and blending data from MS Excel and CSV files along with Oracle SQL Server Databases.
• Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Mobile App.
• Created Crosstab's to display underlying data based on various graphs and charts created for further data analysis.
• Enforce standards and best practices around data modeling efforts.
• Developed Scatter Plots and Area Maps to show states utilizing the Mobile App most vs. least.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling behind the Mobile App usage with Quick Filters for on demand needed information with just a click of a button.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change to ensure that the published dashboards are displaying accurate and up-to-date information.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop, Tableau Server, Oracle SQL Server, MS Excel, CSV, Win Server 2008 R2, Active Directory

Confidential, North Wales, PA

Tableau Developer and Admin / Data Analyst

Responsibilities:

• Experience in installing and configuring Windows and Tableau clusters.
• Performed regular Administration activities from managing system resources, users and database to the fine-tuning level and implemented projects successfully on Tableau.
• Worked on getting the user requirements and converting them into tableau visualizations.
• Designed and developed tables, and stored procedures and prepared the data for tableau.
• Responsible for preparing the existing SQL platform for upgrades that were installed as soon as they were released.
• Assisted in creating and presenting informational reports for management based on SQL data.
• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
• Created and scheduled maintenance plans (database and log backups and cleanups).
• Ensured that all business critical processes and architectural components are clearly documented.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Performed production support and on call duties.
• Made efforts to identify and recommend Standard Policies & Procedures where they might not exist or need enhancement.
• Experience in Database administration activities forDB Security(creating logins, users, roles, and assigning permission to them).
• Expertise in analyzing and estimating the Execution Plan for better Query Optimization.
• Master in performing administrative tasks: database files management,backup/restore, Database Mirroring, data integrationandsynchronization.
• Extensive use of DTS/SSIS in SQL Server, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.
• Experience in implementing high availability using Log shipping, and knowledge of DB mirroring in SQL Server 2008/2008R2
• Responsible for performance tuning, optimizing the queries (TSQL statements), removing redundant and inconsistent data, joins from the database tables and normalizing them
• Conducted risk evaluation of database security for enterprise wide SQL server Databases and managed mitigation of identified areas with diverse teams in a record time.

Environment: Windows 2003, 2008, MS SQL Server 2000/2005/2008/2008 R2, Event Viewer, T-SQL, HTML, Visual Studio.Net 2003, Crystal Reports, LITESPEED, Performance Monitor, MS Access, DTS, BCP, SSIS, SQL Profiler

Confidential, Cincinnati, OH

Tableau Developer

Responsibilities:

• Gather and analyze the business requirements and then translate them to technical specifications.
• Created different views in workbook to visually analyze data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created External filter, internal filter and Context filter to improve performance.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Created parameters and quick filters. Created sets to display top products based on their sale.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created groups and users in Tableau server
• Used commands in Tabcmd and Tabadmin utility tool.
• Assisted in creating SQL database maintenance logs and presenting any issues to the database architects.
• Assisted in developing SQL database mining procedures for various department heads.
• Implemented new features in Tableau 6 to the existing Workbooks and Dashboards.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.

Environment: Tableau 6.0, Tableau 6 Desktop, Tableau server, Oracle 9i, Informatica 7.x, TOAD, Windows XP.

Confidential, Dallas, TX

Sr. SQL Server BI Developer (SSIS/SSRS)

Responsibilities:

• Involved at different stages of Software Development Life Cycle (SDLC).
• Worked in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Migrated data from various sources into the SQL Server 2008 using ETL (Extract, Transform, Load) tool SQL Server Integration Services (SSIS).
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2005 and Flat files.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Created different graphs like Pie charts, Bar charts, line charts.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Created Report Subscription and Data Driven Subscription using SSRS 2008.
• Created Report Snapshots and Report caching to show the data changes over time.
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-Hocreports as per the client requirements.
• Deployed the generated reports directly on Share Point Server.
• Involved in creating report models and applying row level security filters for report model.
• Involved in documentation of the Reports, Database, and SSIS packages.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.

Confidential

Software Engineer

Responsibilities:

• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Created the MS DTS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Often called on to help make changes to the SQL database that would prevent data corruption.
• Created reports from database onto excel spread sheet using DTS.
• DTS Packages are created to export and import data from CSV files, text files and Excel files.
• Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Involved in creating maintenance plans in SQL Agent to back up the database.
• Involved in creating Users and Roles, and managing security and permission of database, managing Jobs and error logs.
• Worked with development teams in the design of physical databases and in modification.
• Developed web based ASP.NET internet applications.
• Involved in analyzing MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.

Environment: SQL Server 2000/2005, Windows Enterprise Server 2003, IIS 6.0, MSMQ, C#, ASP.NET, Rational Rose Enterprise, Erwin.