SUMMARY

• Tableau/BI Developer wif Over 7+ Years of IT Experience in Business Intelligence and Data Warehousing applications in Retail, Financial, Health Care, Pharmacy and Manufacturing industries.
• Extensive knowledge in Dimensional data modeling, Star Schema, Snow - Flake Schema, Normalization, Physical and Logical modeling.
• Good understanding of Tableau Desktop architecture for designing and developing dashboards.
• Expertise in creating dashboards, reports, reporting and analytic applications and tools to drive sales and revenue growth
• Utilized all Tableau tools including Tableau Desktop, Tableau Public, and Tableau Reader extensively
• Extensive experience on building dashboards in Tableau and Involved in Performance tuning of reports and resolving issues wifin Tableau Server and Reports.
• Wrote SQL scripts and queries to extract data from various data sources into teh BI tool, Visualization tool, and Excel reports
• Built and expanded reports available for both internal support and external customer/carrier reports, which included increasing teh scope of data extracted and utilized for reporting purposes
• Created numerous ad-hoc analysis, dashboards, reports, graphs, and charts
• Experience wif analysis, data, databases, and business intelligence
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables
• Excellent in applying Actions and Quick Filters
• Expertise in Data Warehouse development working wif Data Migration, Data Conversion, and (ETL) Extraction/Transformation/Loading using Data Integrator wif DB2 UDB, Oracle, and SQL Server.
• SQL Server and Oracle Database development experience using tables, triggers, views, packages and stored procedures in PL/SQL & T-SQL. Strong RDBMS fundamentals.
• Worked extensively wif Business Objects Data Integrator to create complex Data Flows using Query, Table comparison, lookups and all transformations.
• Experienced in managing, monitoring and investigating cases such as trouble tickets from customers and fixing teh issues
• Hands on experience wif reporting tools BOBJ, Crystal Reports, and Xcelsius.
• Exposure to Full Life Cycle Solution Development (Requirement gathering, Analysis, Design, Development, Documentation, Testing and User training)
• Ability to handle multiple tasks and work independently as well as in a team.

TECHNICAL SKILLS

ETL/BI Reporting Tools: Tableau Suite of Tools 8.1, 8.0. 7, 6, 5.1 which includes Desktop, Server, online and Public and Administration of Tableau Server and SAP Business Objects XI R2, XIR3.

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

Programming Languages: SQL, TSQL,PL/SQL, Java, C and C++

Operating Systems: UNIX, Linux, Ubuntu and Windows

Application Servers: WebLogic, WebSphere

Web Services & XML: SOAP, WSDL, XML, and XSLT

Scripting Language: JavaScript, JQuery

PROFESSIONAL EXPERIENCE

Confidential, Madison,WI

Tableau Developer/Admin

Responsibilities:

• Responsible for interaction wif business stakeholders, gathering requirements and managing teh delivery.
• PreparingDashboardsusing calculations, parameters, calculatedfields,groups, sets and hierarchies in Tableau.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Used Sheet filters to produce multiple chart types in a single view.
• Used calculated fields extensively for different logics for Trend, Extended price calculations for teh different cost types.
• Foundefficientways to make tables and graphs which were visually easy to understand and at teh same time maintaining teh accuracy of teh core information content.
• Building,publishingcustomizedinteractivereportsanddashboards,reportschedulingusingTableauserver.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Ad-hoc ETL, Reports requirement runs.
• InvolvedincreatingdashboardsandreportsinTableau8.1andMaintainingserveractivities, user activity, and customized views on Server Analysis.
• Createdorganized,customizedanalysisandvisualizedprojectsanddashboardstopresenttoSeniorLevel.
• Analyzed user and business requirements attended periodic meetings for changes in teh application requirements and documents.
• Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Created visualization for logistics calculation and department spend analysis.
• Performed Parallel Testing or Production Testing, which ensures that teh new system will perform correctly in a production environment and interface correctly wif other production systems.
• Environments: TableauDesktop8.0/7.0, Tableau server/Administrator, SQL developer, SSIS, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office.

Confidential, Dallas,TX

Tableau Developer/Admin

Responsibilities:

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively wif Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary reports and dashboard using KPI’s.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Installed Tableau Server 7.0 in Dev, QA, UAT and Prod environments.
• Installed patches on teh server and documented upgrade plan from tableau 8.0 to 8.1
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development on assisting users in creating and modifying worksheets and data visualization dashboards.
• Create, customize & share interactive web dashboards in minutes wif simple drag & drop Expert in generating complex, dashboard reports, adhoc, business views along wif user acceptance test and data accuracy test..
• Access dashboards from any browser or tablet.
• Created incremental refreshes for data sources on Tableau server.
• Coordinated database middleware issues wif DBA's, system performance wif System Architects.
• Involved in license management SLA's wif Tableau support.
• Converted existing Crystal Reports and Celsius into Tableau Dashboards
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
• Provided 24/7 production support for Tableau users

Environment: s:TableauDesktop8.0/7.0,Tableauserver/Administrator,SQLdeveloper, SSIS, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007

Confidential, Houston, TX

Tableau Developer/Admin

Responsibilities:

• Develop, Organize, manage and maintain graphs, tables and document templates for teh efficient creation of reports.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Implement infographics and Dash boarding for data visualization.
• Interact professionally wif a diverse group of professionals in teh organization, including managers and executives.
• Experience in standardizing Tableau for shared service deployment.
• Developed Standard Operating Procedures (SOP) for Monitoring.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• 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.
• Involved in license management SLA’s wif Tableau support.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Experience in converting OBIEE content into Tableau BI content.
• Experience in providing Tableau server and tableau desktop training.
• Experience wif Teradata.
• Experienced wif trouble shoot of Teradata connection.
• Testedreportsanduploadedtableaudashboardsontoserverandprovidedproductionsupportfortableau users.

Environment: s: Tableau server/Administrator, Tableau Desktop v6/v7, Windows Server Standard R2, Oracle 11i, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat., TSQL.

Confidential - New York, NY

PL/SQL/Report Developer

Responsibilities:

• Coordinate wif teh application team (Java developers) to provide them wif teh necessary Stored Procedures, functions and packages (Stored Procedures, Functions, Cursors, Ref cursor) and teh necessary insight into teh data.
• Resolved functional issues in business processes through enhancements.
• Converted business logics to logical and then physical design of database systems.
• Performed tuning and optimization on SQL queries using analyze, explain plan, TKPROF utility, SQL Trace and optimizer hints.
• Extensively used SQL*Loader to load data from flat files obtained from various facilities every day.
• Generated server side PL/SQL scripts for data manipulation and validation and created various materialized views, global temporary table.
• Generated scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, Stored Procedures, roles and granting privileges.
• Handled PL/SQL compile-time, runtime errors, and debugging Stored Procedure for business logic modification, granting and revoking Schema Object privileges and roles, responding to system events through triggers.
• Used nested tables, varrays/associative arrays, string indexed, nested collections; wrote PL/SQL programs using collections and compared associative arrays to collections.
• Involved in data loading using PL/SQL and SQL*Loader, external tables and Kron jobs calling Unix (AIX) scripts to download and manipulate files.
• Developed automated Korn Shell Scripts to schedule teh load of flat files on daily, weekly and monthly basis.
• Responsible for gathering teh requirements for creating data models for data analysis and reporting.
• Regularly analyze review teh Crystal Reports developed and make enhancements to them if recommended by teh user.
• Developed cross tab reports, sub reports by using Crystal Reports version XI.
• Performed integration testing for checking complete functionality of various modules.
• Participated in daily status meeting to report any bugs, issues and risks.
• Provided 24*7 production supports for complex modules.

Environment: Oracle 10g, SQL*Loader, TOAD, PL/SQL, SQL*Plus, Erwin, Crystal Reports XI, SQL Server 2005, APEX, UNIX, Perl, Clear Case (Version Control), Clear Quest, Windows 2000/XP.

Confidential

PL/SQL Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions for Various Extract Process run through UNIX Jobs.
• Coded PL/SQL Packages and Procedures using Bulk Binding, for all Statements, DynamicSQL and Cursor Variables.
• Tuned PL/SQL Packages and Procedure to manipulate large no of data using collections like nested tables and arrays.
• Tuned Large Complex Queries and Improved Performance of PL/SQL procedures.
• Created Schema Objects like Tables, Views, Materialized views, Sequences, Constraints, and Indexes.
• Developed and Deployed Traders Oracle REPORTS in Oracle Application Server 9i.
• Generated Oracle FORMS and REPORTS using Designer 6i.
• Designed and Developed Reports using Oracle Discoverer 9i.
• Improved Performance of Discoverer Reports using Materialized views.
• Developed UNIX Shell Scripts for Autonomous Jobs.
• Experience in developing logical and physical database design, data modeling using Erwin.
• Provided Productions support and ongoing user support for teh application.
• Designed Development Documentation and Support Documentations.

Environment: Oracle10g, Oracle FORMS/REPORTS (10g), Designer10g, TOAD, Oracle, Application Server 9i and UNIX.

Confidential

SQL DEVELOPER

Responsibilities:

• Perform database consistency checks at regular intervals.
• Monitor SQL Server activity through Profiler.
• Developed stored procedures used by application developers for displaying reports.
• Modified existing database by adding tables and establishing teh relationships using constraints.
• Created Data Models using Erwin tool.
• Created several stored procedures to Archive teh old data in teh database.
• Wrote custom T-SQL Stored procedures to improve performance, preserve referential integrity, and provide additional application functionality for maintaining hierarchal data.
• Created SSIS Packages.
• Knowledge of Database Performance Monitoring tools.
• Migration from SQL Server 7.0 to SQL Server 2008
• Maintained and improved high availability and disaster recovery strategies for teh database and fail-over methods.
• Developed reports using complex formulas to query teh database to generate different types of ad-hoc reports using Crystal Reports.
• Experience working wif ASP.NET as frontend team.
• Optimized teh performance of queries wif modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Scheduled jobs for Backup, and created alerts for error reporting.

ENVIRONMENT: SQL Server 2008 Enterprise Edition, T-SQL, Excel, Erwin, Windows 2008/XP, Visual Studio, Crystal Reports.