SUMMARY

• Over 7+ years of IT experience in Design, Development, Integration, Implementation and Maintenance of MS Business Intelligence and Tableau Platforms.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6/7/8.
• Strong experience in SQL Server development, System Analysis, Design, Development and Support of MS SQL Server 2012, 2008, 2005 and 2000.
• Extensive experience in dealing wif Relational Database Management Systems, including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers and cursors.
• Experienced in SQL Server Business intelligence tools like SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS)
• Well versed in query optimization for performance tuning and monitoring of processes.
• Expert in creating universes on OLAP SAP BW, Oracle, SQL server, Teradata, DB2
• Extensive noledge on visualization of data and noledge of tools such as tableau.
• Worked on complex KPI scorecards, heat maps, tree views, circle views, bar charts etc... Data visualizations and interactive dashboard which halped business get a good handle on the team's productivity.
• Worked on different table calculations for different Scorecards.
• Published dashboards on Tableau public.
• Worked closely wif Tableau support team during tableau server upgrades to 8.1
• Worked on data blending and increased the dashboard performance by extracting data .
• Worked on Data Model design, Data Extraction, Transformations and Loading, Mappings & Workflows, Customized Analytics Reports.
• Deployed tableau server in clustered environment by adding worker machines.
• Broad experience in resolving universe issues like Loops and Traps using Alias and context.
• In - depth noledge in building/maintaining Repository, Universes and creating adhoc reports.
• Working in both Semantic layers of Business objects like Universes and Business views as Data source for Crystal reports.
• 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, Heat maps and Highlight tables.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS

Programming Languages: T-SQL, XML, Oracle

Business Intelligence tools: Tableau, Business Intelligence Development Studio (SSIS/SSRS), Informatica Power Center 7.1/8.6/9.1, Web intelligence, Xcelsius 2008 and Crystal Reports 2008 XI.

Data Base: Server 2000/2005/2008/2008 R2/2012, MS Access, Teradata

Operating Systems: XP, Windows NT / 2000. Windows Server 2003/2008/2008 R2, Linux

SDLC tools: Perforce, Team foundation Server (TFS), HP Quality center

PROFESSIONAL EXPERIENCE

Confidential, Jersey city, NJ

Sr. BI/Tableau Report Developer

Responsibilities:

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop for BML eBay & PayPal. Worked on various data sources such as Oracle, Teradata, SQL Server,DB2
• Developed ETL processes extracted data daily from Mainframe DB2 and ORACLE Databases, and loaded data into a SAS based Decision Support Warehouse
• 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 report 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 the 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 assisting users in creating and modifying worksheets and data visualization dashboards.
• Worked on BI Report Tuning and Report Validation SQL Tuning
• 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 Xcelsius 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: Tableau Desktop 8.0/7.0, Tableau server / Administrator, tabcmd, SQL developer, SQL 2012,Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007.

Confidential, Virginia Beach, VA

Tableau Report Developer

Responsibilities:

• Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
• Scheduled the published dashboards from Tableau Server on weekly basis.
• Sending the dashboards to users by emails wif the halp of admin team wif subscriptions.
• Performance tuning of Reprots by creating Linked Universes, Joins, Contexts, Aliases for resolving loops and checked the integrity of the universes using Business Objects Designer module during development.
• Given training/demos to users on Tableau Desktop for development.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created Data Connections, published on Tableau Server for usage wif Operational/Monitoring Dashboards.
• Administered user groups and scheduled instances for reports in tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Built complex formulas in Tableau for various business calculations.
• Resolved various performance issues and analyzed the best process distribution for different projects.

Environment: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, UNIX, SQL Server 2008, Oracle 11g, Toad,MS Office, Visual Studio 2010.

Confidential, Plainville, CT

SQL/BI Developer

Responsibilities:

• Designed, Coded, Tested, Implemented the Stored Procedures to support the System.
• Fixed bugs in the existing in-house developed Software which is used to upload the reports for the end users to view the reports.
• Designed, coded and tested several T-SQL Queries to Support the System.
• Fixed bugs in the software that was used to support the healthcare system.
• Designed, Coded, Tested, Implemented Stored Procedures to get data for the reports.
• Designed the reports using Crystal reports And SSRS to create reports for the end users.
• Created ad-hoc reports, drill down, and drill through reports using Crystal Reports and SSRS.
• Scheduled meetings wif the end users and business owners and gatheird requirements for the system.
• Developed triggers on tables to support the system.
• Created and configured SQL mail to send mail as events occur.
• Used the SQL profiler to trace the data and thus troubleshoot TEMPeffectively.
• Worked on SQLSMS to grant other users the rights to the needed stored procedures and table as required.
• Worked closely wif the business owner to understand the requirements.

Environment: SQL Server 2008, MS Visio, Erwin Visual studio 2008,NET Framework, PowerBuilder, Crystal reports, SSRS

Confidential, Memphis, TN

SQL Server Developer

Responsibilities:

• Created SSIS Packages.
• 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 the relationships using constraints.
• Created Data Models using Erwin tool.
• Created several stored procedures to Archive the old data in the database.
• Wrote custom T-SQL Stored procedures to improve performance, preserve referential integrity, and provide additional application functionality for maintaining hierarchal data.
• 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 the database and fail-over methods.
• Monitored Server Activity and Performance.
• Developed reports using complex formulas to query the database to generate different types of ad-hoc reports using Crystal Reports.
• Experience working wif ASP.NET as frontend team.
• Optimized the 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.
• Involved in testing, bug fixing and documentation for the project
• 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.

Confidential

MS SQL Server Developer

Responsibilities:

• Involved in implementation and scheduling of the backup and maintenance strategy on the development server.
• Created Stored Procedures and Database objects.
• Responsible for backups/restores, designing DTS packages and maintenance.
• Reviewed and optimized SQL queries, Stored Procedures, Views and Triggers to achieve maximum efficiency and scalability.
• Daily Database backups and integrity checking.
• Data Transfer (using DTS) from Development to Testing and to Production Servers.
• Designed and created Stored Procedures, Tables Views and DTS packages for existing SQL Server Databases.
• Involved in Data Migration and used DTS to import and export data into tables using SQL Server 2000/2005, creating tables, views and Stored Procedures using SQL Server.
• Fine-tuned queries for the performance of reports which were being deployed in Crystal Reports.
• Wrote Stored Procedures for Reporting purposes and developed various reports using SQL Server Reporting Services.
• Used T-SQL to create various queries.

Environment: SQL Server 2000/2005, Windows NT/2000 server, Crystal Reports.