SUMMARY

• Over 6+ years of experience in Software Design, Database Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
• Extensive experience inTableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6, Tableau 7 and Tableau 8.
• Involved inRequirements gathering/analysis,Design, Development, TestingandProduction rollover of Reporting and Analysis projects
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Involved inTrouble Shooting, Performance tuning of reportsand resolving issues withinTableau ServerandReports.
• Experience in Installation, Configuration and administrationof Tableau Server in amulti - serverandmulti-tierenvironment.
• Extensive TableauExperience in Enterprise Environment and TableauAdministrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Extensive experience on building dashboards using Tableau.
• Involved in upgrading Tableauplatforms in clustered environment and performing content upgrades.
• EstablishedBest Practicesfor EnterpriseTableauEnvironment and application intake and development processes.
• Extensive experience inTableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Experienced in tuning long running SQL queries for better performance.
• Highly used excel functions like V-lookups, pivot tables, concatenate etc.
• Proficient in designing Data Mart and Data Warehouse using Erwin Star and Snowflake Schemas.
• Working knowledge on reporting using QlikView.
• Extensive experience in monitoring the database server for deadlocks, long running queries and tuning the same to improve performance.
• Ability to translate complex data requirements into simple, understandable formats understood by both technical and non-technical users.
• Experienced in data profiling to understand the current state of data, its quality and fitness to serve business users and their needs.
• Experienced in data mapping to aid the integration of legacy systems into a new database.
• Experienced with creating various data documentations including data dictionary, data mapping and data flow diagrams.
• Very good understanding of Data Warehousing Design Methodology, Data Warehouse Concepts, Database design/architecture including both OLAP & OLTP data and complete lifecycle of project from design to development and implementation.
• Having application testing experience with working knowledge of automatic testing tools like Mercury Quick Test Professional.
• Experience in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation).
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS

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

Data Visualization: Tableau, Qlikview, PowerPivot, Excel, SSRS, SSAS, Visual Analytics, Crystal reports XI/2008, Business Objects XI/4.0

Relational Databases: MS SQL Server 2005/2008/2012 , Oracle 8i/9i/10g/11g, MS Access.

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

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

Web/App Servers: MS IIS 5/6.0, Apache Tomcat, Web logic Server 8.1/9.2/10

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

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Tableau Report Developer

Responsibilities:

• Deep experience with the design and development of Tableau visualization solutions.
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters in Tableau.
• Creating calculatedfields,groups, sets and hierarchies etc.
• Creating data blending in case of merging two different datasets.
• Understanding of relational database structures, theories, principles, and practices.
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
• Find ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Proof-read all documents and maintain accuracy of information and preparing SOP.
• Responsible for Developing a Dashboard and preparing ad-Hock Reporting.
• Managed development and maintenance of web portal pages and assisted in training on the use of MS SharePoint.
• Working knowledge on Tableau Server / Administration.

Environment: Tableau Desktop 6.02,7.0, 8.0 Tableauserver / Administrator, SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007, MS Access, Toad, Windows 2007 server, java 1.5 platform, MS SharePoint, Microsoft office 2007.

Confidential, Richardson, TX

Tableau Report Developer

Responsibilities:

• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Installed patches on server and documented upgrade plan form Tableau 6.0 to Tableau 6.1
• Built complex formulas in Tableau for various business calculations.
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Created and assisted users in Tableau dashboard development
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Developed business process and technical design documentation for each reporting service developed in this project.
• Designed and developed reports such asDrill down, Drill Through usingMicrosoft Reporting Services.
• Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems with different transformation and scheduled Jobs to run the packages on a daily basis.
• Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Used Stored Procedures to pull the data from the Production server and scheduled jobs to run the Stored Procedures.
• Maintained and supported Microsoft Team Foundation Server (TFS) to allow for a secure code in a multi-team environment.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.

Environment: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, TSQL, UNIX, SQL Server 2008, SQL BI Suite (SSIS, SSRS)/DBA, Oracle 11g, Toad, MS Office, Team Foundation Server, Visual Studio 2010, WCF web service.

Confidential

Business/ Data Analyst

Responsibilities:

• Designed and reviewed the business requirement, functional specification and project schedules based on the project scope and SDLC Methodology.
• Supported Production related activities for Enterprise Data Warehouse.
• Interacted with Business Users, Business Owners to know their requirements in developing and modifying Universes and Reports accordingly.
• Analyzed existing code to ensure that requirements were maintained during transitions to new platforms.
• Coordinated activities between business unit and technical staff, developing new methods, policies, and procedures to meet the business needs, and acting as primary trainer in education of the business unit as it relates to business applications.
• Wrote complex SQL queries and used Access/Excel to validate data.
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Highly used excel functions like V-lookups, pivot tables, concatenate etc.
• Documented business objectives and business processes.
• Created Test Cases, specified various test scripts, provided sample data for testing.
• Worked extensively with the QA team for designing Test Plan and develop the Test Scripts for the User Acceptance Testing.
• Conducted Defect Tracking and Change Control Procedures using Rational Clear Quest and Remedy.
• Worked extensively to maintain Business Continuity Planning.
• Created several reports for Cost Models and Budget purposes.

Environment: Oracle, TOAD, Mercury Quick Test Professional, MS-Project, Business Objects, Access, Excel, PowerPoint, HP Quality Center, SharePoint Portal Server 2003