SUMMARY

• Over 6+ 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.
• Hands - On, detailed-oriented Data Analyst, SAS Developer, and Data Miner
• Familiarity with web technologies like HTML, JavaScript is plus
• Extensive hands-on experience server level experience on Windows and Linux servers
• Strong experience in SQL Server development, System Analysis, Design, Development and Support of MS SQL Server 2012, 2008, 2005 and 2000.
• Ability to use custom SQL for complex data pulls
• Experienced in Tableau Platfora Dash boarding In-Memory (OLAP) processing
• Extensive experience in dealing with Relational Database Management Systems, including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers and cursors.
• Good Experience withTeradata and Semantic Views.
• Strong understanding of Finance, Operations, Call Center data and key metrics.
• Ability to write reports, and create visual data presentations.
• Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and/or concrete variables.
• 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 teh team's productivity.
• Master in Tableau Charting, reusability, Leveraging variables and templates and building/deploying section access security models.
• Worked on different table calculations for different Scorecards.
• Published dashboards on Tableau public.Design and develop various reports and dashboards dat can be easily accessible through Tableau App in Ipads, iPhones, and other smart mobile phones.
• Worked closely with Tableau support team during tableau server upgrades to 8.1
• Worked on data blending and increased teh 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 with 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 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 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 with simple drag & drop Expert in generating complex, dashboard reports, adhoc, business views along with 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 with DBA's, system performance with System Architects.
• Involved in license management SLA's with 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 teh metric dashboard reports and identified teh formulas and functionality of teh dashboard reports and digitizing teh metric dashboards to Tableau application.
• Published teh dashboard reports to Tableau Server for navigating teh developed dashboards in web.
• Scheduled teh published dashboards from Tableau Server on weekly basis.
• Sending teh dashboards to users by emails with teh halp of admin team with subscriptions.
• Performance tuning of Reprots by creating Linked Universes, Joins, Contexts, Aliases for resolving loops and checked teh integrity of teh 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 teh business logic by customization.
• Created Data Connections, published on Tableau Server for usage with 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 teh 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 teh Stored Procedures to support teh System.
• Fixed bugs in teh existing in-house developed Software which is used to upload teh reports for teh end users to view teh reports.
• Designed, coded and tested several T-SQL Queries to Support teh System.
• Fixed bugs in teh software dat was used to support teh healthcare system.
• Designed, Coded, Tested, Implemented Stored Procedures to get data for teh reports.
• Designed teh reports using Crystal reports And SSRS to create reports for teh end users.
• Created ad-hoc reports, drill down, and drill through reports using Crystal Reports and SSRS.
• Scheduled meetings with teh end users and business owners and gathered requirements for teh system.
• Developed triggers on tables to support teh system.
• Created and configured SQL mail to send mail as events occur.
• Used teh SQL profiler to trace teh data and thus troubleshoot TEMPeffectively.
• Worked on SQLSMS to grant other users teh rights to teh needed stored procedures and table as required.
• Worked closely with teh business owner to understand teh 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 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.
• 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.
• Monitored Server Activity and Performance.
• Developed reports using complex formulas to query teh database to generate different types of ad-hoc reports using Crystal Reports.
• Experience working with ASP.NET as frontend team.
• Optimized teh performance of queries with 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 teh 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 teh backup and maintenance strategy on teh 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 teh 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.