SUMMARY

• Having 7+Years of experience in Tableau Solutions Consultant with BI experience.
• Expertise in data cleansing for analysis, perform data quality testing for gaps, and liaising with data origination teams.
• Experience in designing stunning visualizations usingtableausoftware and publishing and presenting dashboards on web and desktop platforms
• Consistently delivered results in various stages ofSoftware Development Life Cycle(SDLC).
• Have been working with various data sources such asOracle, SQL Server, ODBCand flat file sources.
• Involved inTrouble Shooting, Performance tuning of reportsand resolving issues withinTableauServerandReports.
• Experience inInstallation, Configuration and administrationofTableauServer in amulti - serverandmulti-tierenvironment.
• Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Developed Queryfor generating drill down reports in SSRS 2005.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Experienced in Business Intelligence (SSIS, SSRS), Data Warehousing and Dashboards.
• Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS)
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Migrated SSRS Reports to Performance Point server 2007 and published them on to SharePoint.
• Expertise in using Version controllers likeTFS, Visual SourceSafe andClear Case.
• Strong analytical, logical, Communication and problem solving skills and abilityto quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS

Specialties: Data Visualization, Business Intelligence (BI), Software Management and Data Collection.BI Tools Tableau7.0,Tableau8.0/8.1,OBIEE 10g,11g,SSRS

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

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

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

PROFESSIONAL EXPERIENCE

Confidential, Palo Alto, CA

TABLEAU DEVELOPER/ADMINISTRATOR

Responsibilities:

• Grant server access to team members for live connections
• Built Test Scripts and Training modules for end users
• Developed reports using custom SQL queries and created .tdsx, .tde and .tds files.
• Created four reports and filtered them by various measures and dimensions.
• Blended data from multiple databases into one report.
• 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.
• 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.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Designed and developed monthly, quarterly and yearly reports at branch and bank level.
• Involved in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.

Environment: SQLQueries, .tdsx, .tde and .tds files, TableauDesktop 7 & 8.1,TableauServer,MS Office Suite,Oracle SQL ServerR2, MS Excel

Confidential, Bellevue, WA

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 service subscribers by color that were broken into regions allowing business user to understand wherewe have most users vs.least users.
• Projected and forecastedfuture growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on whichstates were connected the most.
• 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 SQL Server 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: TableauDesktop 7 & 8.1,TableauServer,MS Office Suite,Oracle SQL ServerR2, MS Excel

Confidential, LIVINGSTON, NJ

TABLEAU DEVELOPER

Responsibilities:

• 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.
• Worked on technical strategy, provided hardware and software configuration, understood client-wide BI implementationproject, design and develop visualizationsas per requested by CEO and CFO ofa$600M firm.
• Adjust views/dashboards after initial POC presentation to CEO and CFO.
• 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 by CEO andCFO.
• 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.
• Environment:TableauDesktop 8.1,TableauServer 8.1, MS Excel, MS SQL Server 2012 R2, Win Server 2012 R2, Active Directory

Environment: TableauDesktop 7 & 8.1,TableauServer,MS Office Suite,Oracle SQL ServerR2, MS Excel

Confidential, Portland, OR

Software Developer

Responsibilities:

• Retrieve data frommultiple databases, Transform data as per client request, Load data into reporting client UI,SSRSor load to database.
• UsedSQLand T-SQLfor Microsoft databases.
• SSRS(SQLServer Reporting Services)Wrote scripts in TSQLandSQLto generate reports
• Included setting up reports for export to excel, access as ad-hoc reports for clients.
• SSIS(SQLServer Integration Services) Migrated DTS packages to SSIS, created new packages as needed.
• DesignedSSRSapplications that hadto meet clients'requests.
• Worked with clients as an analyst for custom UI, data filters and requirements.
• Background code written inSQL, PL/SQL and T-SQL.
• Interface retrieves data from Agency Metering System (AMS), Agency Load Forecast (ALF), and Market Prices web service for IAM application.
• Part of the nMarket support team used by the trading floor to monitor CALISO market.

Environment: SQL, T-SQL,SSRS,SSIS.

Confidential

MS SQLServer Developer,SSIS,SSRS

Responsibilities:

• Involved in planning, defining and designing data and provided documentation.
• UpgradedMSSQLServer using detach/attach, backup and recovery and by replication.
• UsedSSISImport/Export Wizard, for performing the ETL operations.
• Createdalerts, notifications, and emailsfor scheduledSSISpackages execution.
• Performed T-SQLtuning and optimization of queries for reports that take longer execution time using MSSQLProfiler, index tuning wizard andSQLQuery Analyzer in MSSQLServer 2008r2.
• Generated reports usingSSRSthat could be used to send information to different primary vendors, clients, and managers.
• Designed astarschema for the data warehouse using dimensional modeling and developed it using the Erwin tool.
• Created sub-reports, drilldown-reports, summary reports, and parameterized reports inSSRS.
• Generated reports usingSSRSthat could be used to send information to different Primary vendors, clients and managers.
• Designed and implemented stored procedures and triggers for automating tasks.
• Maintained the table performance by following the tuning tips like normalization, creating Indexes.
• Used the HTML code to make the report manager more functional and customizable.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split, Derived column etc.
• Troubleshootand fixed issues in existing cubes in SSAS.
• Designed a new schema for the data mart databases.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment: MSSQLServer 2008r2, T-SQL,SSRS2008r2, Visual Studio 2008r2, Erwin 8.0.

Confidential, Mayfield, OH

MS SQLDeveloper,SSIS,SSRS

Responsibilities:

• Dealt with requirements gathering, analysis, design, development, change management, deployment and user training.
• Added logins, roles, groups to the Window NT and MSSQLServer and maintainedproper security procedures.
• Designed ER diagrams (Physical and Logical usingErwin) and mapping the data into database objects.
• Created, maintained, modified, and optimizedSQLServer databases, database security and auditing
• Wrote various stored procedures, Indexed views, dimensions and stored outlines for optimal performance.
• Scheduled Jobs and Alerts usingSQLServer Agent.
• Connected Linked Servers toOLE DB data sources and providers.
• Wrote distributed queries for Linked Servers.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
• Performed Data Analysis for automating various drugs related reports utilizingSQLAnalysis Services.
• Designed, programmed, deployed and tested the requested Reports.
• GeneratedSub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports usingSSRS2005.
• Implemented a well-planned Backup and Restoration strategy that protects databases against data loss due to damage caused by a varietyof failures.

Environment: SQLServer 2005 Enterprise Edition, MS Excel, T-SQL, MS Access 2000,SQLReporting Services, Erwin 7.3, XML.