SUMMARY

• Over 7+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• In - depth knowledge on Tableau Desktop, Tableau Reader, Tableau Public and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau.
• Extensive experience working as a Business Intelligence Consultant with specialization in cognos, microstrategy, SSRS,OLAP
• Extensive experience working in Windows, UNIX, LINUX environments.
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Mainframes, MS Access and client/server applications.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Worked with ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Worked extensively with the major functionality of ad-hoc reports, Drill down reports, multi-parameterized reports and drill through reports.
• Professional in writing complexFormulas,Sub Reports,Summary Reports.
• Involved inTrouble Shooting, Performance tuning of reportsand resolving issues withinTableau.
• Installation, configuration and administration of Tableau.
• Deployed the reports andScheduled Reportsfor the use of end users and customers.
• Worked extensively with creating reports as per user requirements using Reporting Services.
• Extensive working experience inPackages, Procedures, Cursors and Triggers.
• Experienced in tuning Long running SQL queries for better performance.
• Expertise in using Version controllers like SVN & Serena Dimensions.
• Stronginterpersonalskills with demonstrableverbalandwrittencommunications to maintain effective work relationships with all levels of personnel.

TECHNICAL SKILLS

BI Reporting Tools: TableauDesktop, Public, Server, Reader/Cognos/Microstrategy

Java & J2EE Technologies: Core Java

Databases: Oracle, MySQL, DB2, Teradata, SQL Server,OLTP,OLAP

Operating Systems: Windows 95/98/2000/XP/Vista/7, Unix

Other Tools: Putty, SVN, Dimensions,OBIEE

PROFESSIONAL EXPERIENCE

Confidential, Richardson,TX

Tableau Developer

Responsibilities:

• Having knowledge of Tableau Desktop and Tableau server and strong experience delivering Business Intelligence solutions. Working with internal team and developed complex dashboards in Tableau.
• Building dashboards, automated reports and report templates using advanced Tableau functions.
• Providing guidance insight on data visualization and Tableau dashboard design best practices.
• Ability to support multi environment Tableau infrastructure including server security trouble shooting and general system maintenance.
• Experience in working with Multi-dimensional hierarchies, OLAP cubes and Data warehousing applications and also Financial reports.
• Refine and enhance the technical architecture to keep pace with changing business demands and new Tableau software releases.
• Analyze, troubleshoot and tune product performance or deployment issues.
• Strong results during implementation and integration of Tableau.
• Working with Tableau dashboards deployed on web server.
• Working knowledge of using SQL Oracle and SQL Server.

Environment: Tableau V 8.1,8.3,9.0( Desktop, Server, Reader), Oracle, Terradata, MS SQL, AON

Confidential, Alpharetta, GA

Tableau Developer

Responsibilities:

• Responsible for designing and developing user interactive dashboards for the financial applications. Enable business users with self-service reporting capabilities and supporting users in building analytical reports using Tableau Desktop 8.x/9.xFinancial Reporting and Oracle BI
• Currently working on Proof of Concepts (POC) presentation and review with project and IT lead along with developingTableauDashboards.
• Recommended OS configuration for installing Win Server 2012 R2,TableauServer, andMSSQL Server 2012 R2.
• Experience with other BI tools like Cognos, Business Objects, Micro-strategy and Netezza.
• Worked on technical strategy, provided hardware and software configuration, understood client-wide BI implementationproject, design and develop visualizations.
• Adjust views/dashboards after initial POC presentation.
• Brainstorm ideas onwhattoinclude in views/dashboards from the data sourceand document on the fly business requirements.
• Create views and dashboards on end client'ssales data. Producepowerful dashboards telling story behind the data in an easy to understand format such as pie, bar, geo, and line charts that are viewed daily.
• Cleanse and normalize data in MS Excelby combining from variousdatasources.
• PerformTableauServer admin duties; add users/groups from Active Directory; and schedule instances inTableauServer including weekly data dump.
• Train endclient users onTableauDesktop by providing step-by-step guidancefrom basics to advanced functions ofTableauincludingworking with calculations,parameters, and date functions.
• Involved in migration of Cognos reports to Tableau workbooks.

Environment: Tableau V 8.1,8.3 (Desktop, Server, Reader), Oracle, SQL Server, MSTR, Cognos.

Confidential, Philadelphia, PA

Tableau Developer

Responsibilities:

• Involved in creating dashboards by extracting data from different sources.
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axes bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, MS Excel.
• Extensively used data blending in Tableau.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
• Involved in creating Stored Procedures, tables, and views for applications.
• Involved in creation and updates of several SQLIndex, Views, Complex Stored Procedures, triggersand appropriateUser defined functions.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau V 7/8(Desktop, Server, Reader), Oracle, Teradata, Java, SVN,MS Excel

Confidential, Newyork, NY

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements andanalyzingdata sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Created views inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
• Created Heat Map showing current services by color that was broken into regions allowing business user to understand.
• Experience with other BI tools like Cognos, Business Objects, Micro-strategy and Netezza.
• Projected and forecastedfuture growth in terms of number of subscribers developing Area Maps to show details at the county level.
• Converted charts into Crosstabs for further underlying data analysis inMSExcel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, Teradata and MS Excel.
• Blendeddata frommultiple databases into one report by selecting primary key’sfrom each databasefor data validation.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer 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 onTableauServer for weeklyand monthlyincrementsbased on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user groupdiscussionsas well as communicating with stakeholders and business groups.

Environment: Tableau Desktop, Reader, SQL Server, MS Excel.

Confidential, Richmond, VA

UNIX, Composite, Hadoop Developer

Responsibilities:

• Gathered and analyzed both legal and credit data sets, performed due diligence on deals, consulted with credit associations and business representatives, and financial ratios for the preparation of credit reviews.
• Translated clients’ needs into usable mapping and coding instructions and created functional requirements document and mockups for reporting.
• Prepared Business Requirement Documents (BRD's) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Designed and implemented basic SQL queries for testing and report/data validation.
• Developed and maintained reporting using in MS Excel queries and SQL. Produce performance reports and implement changes for improved credit reporting along with performing conditional formatting for data analysis.
• Created Test Cases, Activity Diagrams, and System Flow Charts.
• Reviewed request to determine basic characteristics, such as origin and report flow, mapping, format, frequency, distribution, and purpose or function of report.
• Worked closely with the Information management groups to develop, test, and validate systems and reports, attended meetings with users and IT, documented business, technical, and systems requirements.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.

Environment: MS Excel, DB2, UML, Flowcharts.

Confidential, Madison, WI

Testing Analyst

Responsibilities:

• Understanding the business Requirements and Technical Requirements.
• Preparing the Test Cases according to the requirements.
• Test Cases were implemented.
• Test the application front end and also data integrity.

Environment: Test Director, HP ALM.