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, 8.1.6, 8.2 and 9.0 as a Developer and Analyst.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
• In - depth noledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations wif Drill Down and Drop down menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau.
• Extensive noledge 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 Modelling, 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.
• Strong interpersonal skills wif demonstrable verbal and written communications to maintain TEMPeffective work relationships wif 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, 9.0, SSIS, SSRS,SSAS, Qlikview

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

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, West Point, Pennsylvania

Tableau Developer/Consultant

Responsibilities:

• 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 wifin Tableau Desktop.
• Created views in Tableau Desktop dat 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 dat were broken into regions allowing business user to understand where we has 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 dat 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 wif project managers, developers, customers and vendors planning and implementing new environments as well as restructured and rebuilt existing environments.
• Assisted internal development teams wif database design, performance tuning, security, maintenance and management.
• Data Modeler wif strong Conceptual and Logical Data Modeling skills, experience wif 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 me/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 wif T-SQL
• Strong T-SQL Developer skills including stored procedures, Indexed views, User Defined Functions (UDL), Triggers, and Distributed Queries.
• Worked wif 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, New York

Tableau Developer and Admin / Data Analyst

Responsibilities:

• Scope of the project was to enhance the Mobile Banking App's systematic processes which were associated wif their 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 wif business team to gather TEMPeffective requirements for the system along wif 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 wif 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 are complied wif 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 wif Quick Filters for on demand needed information wif just a click of a button.
• Developed and reviewed SQL queries wif 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 dat business or system change to ensure dat the published dashboards are displaying accurate and up-to-date information.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating wif stakeholders and business groups.

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

Confidential, New York

Software Developer/ SQL Developer

Responsibilities:

• Design & Development of Prototype, Web pages and Business Layer
• Involved in implementation, Functionality testing and Bug fixing.
• Active participation in demos to the client.

Environment: Windows XP, VS.Net, Asp.Net, XML, SQL Server, SSIS, SSRS

Confidential

Data Analyst

Responsibilities:

• Experience in installing and configuring Windows clusters.
• Performed regular Administration activities from managing system resources, users and database to the fine-tuning level
• Responsible for preparing the existing SQL platform for upgrades dat 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 wif SQL Server Management Studio as well as basic account management and troubleshooting wif connectivity, security and firewall issues.
• Created and scheduled maintenance plans (database and log backups and cleanups).
• Ensured dat 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.
• 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 noledge 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 wif diverse teams in a record time.

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