SUMMARY

• Over 9 years of experience in Software Design, Database Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms
• Strong Knowledge and hands on experience of SDLC methodologies like Agile Modeling and Waterfall model.
• Have good understanding of Tableau architecture, design, development and end user experience.
• 4+ years of Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions 6.x/7.x/8.x/9.x/10.x
• Have good understanding of Tableau architecture, design, development and end user experience.
• Perform business requirements analysis and transform those into plans and recommendations that are presented to company management.
• Worked on Tableau Desktop, Public and Tableau Server.
• Experience in using ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and loading using Informatica Power center 9.6.1/9.1/8.6.1
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Experience on Star schema and Snowflake schema.
• Experience in Tableau Desktop, Tableau Server in various versions of tableau including Tableau 7x and Tableau 8x,9.x Extensive Tableau Experience in Enterprise Environment and Tableau Administration experience including technical support, troubleshooting,report design and monitoring of system administration parameters.
• Extensive experience in troubleshooting, performance tuning and supporting Business reporting platforms.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Excellent in schedulingand deployment of reports in Tableau
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Understanding of Logical and Physical Data Model (LDM & PDM) on the new Ratings Stream data mart, and enhanced the existing EDW Physical Data Model.
• Expert in ETL process using Informatica Power Center Designer (8.6.1), Workflow manager, Workflow monitor, Informatica server and Repository Manager.
• Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, Sybase, and Teradata, Ms Access, Flat files into a staging area.
• Excellent in rendering reports, managing subscriptions, creating reports in Tableau
• Experience in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling the backups.
• Excellent analytical and problem solving using QlikView, tableau and SQL debugging skills.
• Experienced in developing rich Interactive reports and dashboards integrating various reporting components from multiple resources
• Excellent presentation, communication and interpersonal skills.
• Resourceful team player with excellent communication, interpersonal and managerial skills
• Extensive and successful experience in results - oriented business analysis for high-growth organizations.
• Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2000/2005/2008 in Development, Test and Production Environments on various business domains like Financial, Insurance.

TECHNICAL SKILLS

BI Reporting Tools: Tableau Suite of Tools10,9.18.1, 8.0. which includes Desktop, Server, online and Public and Administration of Tableau Server.Qlickview,SSRS,Cognos

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

Oracle Tools: Oracle Enterprise Manager, Quest TOAD, SQL*PLUS, SQL*Loader

Programming Languages: C, C++, Java, HTML, JavaScript, Visual Basic 6.0, UNIX Shell Scripting, SQL, SQL*PLUS, PL / SQL

Computer Skills: MS Office - Excel, Word, Access, Outlook, Publisher, PowerPoint, SharePoint.

Operating Systems: UNIX, HP, Sun Solaris 2.x / 7 / 8, Windows ME / / NT / XP, IBM AIX, Exceed (Editor)

Data Modeling Tools: ERWIN, Visio

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

Scripting Language: JavaScript, JQuery

PROFESSIONAL EXPERIENCE

Confidential, Stanford, CT

Tableau Developer/Administrator

Responsibilities:

• Created worksheets and dashboards by using custom queries and multiple tables.
• Created various interactive customized dashboards and stories.
• Created Rich dashboards using Tableau and prepared user stories to create compelling dashboards to deliver actionable insights.
• Worked in Tableau environment to create dashboardslike weekly, monthly, daily reports using tableau desktop& publish them to server.
• Developed Informatica Mappings and Workflows using various Transformations (Update Strategy, Router, Expression, and Aggregator) for extracting and loading data from various data sources.
• Used JavaScript API to set and create filters, select and highlight elements in the view, and process the view to retrieve updated data.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop. Involved in creating Tree Map, Heat maps and background maps.
• Used Tableau's JavaScript API to integrate Tableau visualizations into web applications.
• Involved in providing the best Teradata Informatica Loading strategies for ETL processing of getting data into Data mart.
• Involved in workload balancing through TASM.
• Performed query optimization and assisted ETL developers and users by analyzing DBQL data, explain plan and join strategy and Partitioning large tables to improve performance of sqls.
• Performed database health checks using Teradata Manager.
• Worked with Tableau administrators in integrating fully interactive Tableau views on external websites through Java API scripting.
• Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Completing the new development and enhancement tasks following the SDLC process
• Involved in Developing Tableau visualizations and dashboards using Tableau Desktop.
• Worked on Full life cycle development (SDLC) involving in all stages of development.
• Extensively used data blending in Tableau .
• Used Tableau Desktop to analyze and obtain insights into large data sets & also Generated Tableau reports with Trend lines.
• Experience in creating complex SQL queries from scratch, and tuning existing SQL queries for better performance.
• Had thorough study of the requirements and gathered the necessary information to start the report design
• Developed and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
• Generated tableau dashboards with combination charts for clear understanding using forecast and reference lines
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents
• Provided 24/7 production support for Tableau users
• Applied various types of filters like Data source filters, Quick filters and Context Filters.
• Regularly interacting with customer to resolve issues.
• Responsible for Preparing the Report Design specifications based on the User's requirement.
• Extracted data from various sources and performed data blending.
• Developed various types of complex reports like Cross tab reports, Drill Down and Master Detail Relationships.
• Created heat maps, line charts for data visualization.
• Coordinating with Business Analyst in validating report requirements.
• Designed, developed and documented the ETL processes using Informatica for extracting the data and data transformations.
• Applied the actions in the work sheets and dashboards.

Environment: Tableau(Desktop, Server),Oracle 11g,Informatica 9.1,MS Office Suite,Linux,Windows server OS,Teradata 13.0,Teradata SQl

Confidential, Baltimore, MD

Tableau Developer

Responsibilities:

• Deep experience with the design and development of Tableau visualization solutions.
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Performed database health checks using Teradata Manager.
• 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.
• Proven team leader and project manager able to coordinate daily operations and activities.
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary.
• Defined best practices for Tableau report development.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Exported data from a report to several file formats likes PDF, Image and Excel according to the needs of management.
• Exported reports into various formats like PDF, HTML, EXCEL and WORD for end users.
• Preparing Dashboards using calculations, parameters in Tableau.
• Understanding of relational database structures, theories, principles, and practices.
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Developed complex visualizations.
• Good understanding of NoSQL databases such as Cassandra, HBase and MongoDB.
• Experience in creating complex SQL queries from scratch, and tuning existing SQL queries for better performance.
• Working on generating various dashboards in Tableau server using various sources such as Teradata.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated
• Involved in license management SLA’s with Tableau support.
• Defined and created procedures to install Tableau desktop in silent mode.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Proof-read all documents and maintain accuracy of information and preparing SOP.
• Responsible for Developing a Dashboard and preparing ad-Hock Reporting.

Environment: Tableau Desktop 7.0, 8.0, 8.1, 8.2,Tableau server / Administrator Teradata, Teradata SQL Assistant, SQL,Agile-Scrum, UNIX, MS VISIO, Microsoft Office Suite. JQuery, JavaScript,OracleSQL Developer.

Confidential, Chicago, IL

BI Developer (SSRS/SSIS/SSAS)

Responsibilities:

• Created SQL server Reports using SSRS 2008.Identified the data source and defined them to build the data source views
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design(SSRS)
• Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2000 & 2005(SSAS)
• Used scripts and variables, email notifications for ETL process using Data Integrator.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Designed Data flows, Workflows and jobs to load data from source to target in BO Data Integrator.
• Enhancing and deploying the SSIS packages from development server to production server.
• Designed and built OLAP cubes to meet reporting needs.
• Performed Documentation for all kinds of reports and DTS and SSIS packages.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS). Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2005 Analysis Services (SSAS).
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created Packages in SSIS with error handling.
• Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc
• Created Time Dimensions on OLAP Cubes using SSAS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created complex SSIS packages using proper Control and Data flow elements.
• Used System Tables, System Stored Procedure, DBCC commands for Database maintenance.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• Involved in migration from SQL Server 2005 to SQL Server 2008.

Environment: MS SQL Server 2008 and 2005, T-SQL, SSRS, SSAS, SSIS Packages, SSRS,ETL, ODBC, Erwin, ASP.Net 3.0, Ado.Net 3.0, C#.Net, Excel, Business, Business Objects Data Integrator 6.5, SharePoint Server, MDX, ProClarity, OLAP, OLTP, DB2, Access, Windows 2003 Server, IIS 6.0.

Confidential, Detriot,MI

BI Developer (SSRS/SSIS/SSAS)

Responsibilities:

• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
• Created SSIS packages to load data from Oracle to Sql Server using various transformations in SSIS.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Analyzed the existing tool and participated in meetings with the business users to gather
• Requirements and design goals of data warehouse.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Used SQLCMD to write Stored Procedures in command line utility and it uses OLEDB to execute T-SQL batches.
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Defined appropriate measure groups and KPIs & deployed cubes.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS.
• Created report snapshots to improve the performance of SSRS.
• Combined Dundas chart control with .NET Grid view control and binded both of those controls to a common data source.
• Responsible for managing daily activities of department including compliance initiatives, group practice agreements, managing health care claim strategies and other.
• Responsible for helping manage the daily operation of the company, meeting with clients and brokers for brokerage, holding employee meetings, resolving conflicts.
• Created T-SQL Functions, Cursors, views, indexes, stored procedures and triggers.
• Migrated database from SQL server 2000 to SQL server 2005 using utilities i.e. exp/imp and attach/detach for SQL servers 2005 futures.

Environment: SQL Server 2005, Windows 2000/2003, Microsoft office 2003,XML,T-SQL, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, MS Excel 2003, Visual Studio 2005,.NET Frame Work 1.0,SharePoint 2007.