PROFESSIONAL SUMMARY:

• Around 8 Years of IT experience in confidential(with 3.6 years of onsite experience) which includes Dashboard Development and Administration in Tableau 8.2 and 9, System Analysis, Support & Maintenance for MS SQL Server 2005/2012 in Production and Development Environments in MS SQL Server, Oracle 9i/10g Application DBA & PL/SQL in Solaris 9/10 environments
• Around 6 months of BPO experience as Technical Support executive at Sutherland for Norton/Symantec Products
• Extensive Experience in Tableau 9 server setup, configuration, upgrade, development and administration.
• Worked on Tableau dashboard development which includes Requirements Gathering, Analysis, Development, Implementation, and Acceptance Testing.
• Tableau administrator responsible for site creation, users and groups creation, user authentication and authorization, scheduling data extracts, implementing best practices, scalability and performance improvement, implementing alerts through Email and various other maintenance activities.
• Participated various seminars conducted by Tableau corporation on Visualization and best practices
• Conducted Tableau practitioner & advanced level to Cognizant internal associates through Cognizant Learning Academy.
• Good experience in Installation, Patching, Configuration and Administration of SQL Server 2005, SQL Server 2012
• Experienced in Downgrades, Upgrades & Migrations of legacy servers to the latest SQL Server Versions.
• Designed and implemented enterprise wide Backup\Recovery strategy on SQL Server.
• Well - versed in setup and configuration of High Availability solutions like Database Mirroring, Log shipping, Clustering & AlwaysON High Availability groups.
• Implemented the Replication Model using Mirroring & Snapshot techniques
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Hands on Experience in PL/SQL development and SQL Loader utilities.
• Good knowledge on UNIX commands and scripting.
• Good knowledge on Windows Batch scripting.

TECHNICAL SKILLS:

Languages: T-SQL, Unix Scripting, Windows Batch Scripting

DBMS: SQL Server 2012/2008/2005, Oracle 9i,10g

Front End: Tableau Desktop 8.2,9, Business Intelligence Development Studio(BIDS), SSMS, PL/SQL Developer

Operating Systems: Windows Server 2012/2008/2003/2000, Windows 10/7/Vista/XP, Solaris 9/10

ETL Tools: Knowledge on SSIS

SQL Server Tools: SSMS, SQL Sentry

Reporting Tools: Tableau 8.2, 9.0

PROFESSIONAL EXPERIENCE:

Confidential, Fort Worth, TX

Senior Tableau developer

Responsibilities:

• Requirement Analysis, design document and Unit testing in agile methodology
• Migration of Cognos dashboards to Tableau which also includes converting the Cognos queries to SQL queries, pull the needed data and build equivalent dashboards with similar functionalities in tableau.
• Creation of various other Table view reports like Academic Reports, Vision Care Call Details report, Internal Sales Representative report for All accounts and Territories, Just In Time shipment monthly reports and few other Surgical reports by connecting with SQL data sources.
• Creation of Adhoc data model in tableau by joining multiple data tables and hierarchies using Level of Detail expressions (LODs) and making the environment available for adhoc reporting. This also involves the business users to build adhoc reports.
• Developed Proof of Concept for Non-Alcon Owned Equipment reports by building invoice dashboards
• Developed an invoice dashboard for Non-Alcon Owned Equipment for different Territories and customer accounts with multilevel cascading filters
• Have used data security filter at the report level to provision only the necessary users who are a part of AD group to view the dashboards.
• Have used parameters to capture user input and pass it directly to database using live connection to bring only the necessary data to display the report in a desired manner.
• Have trained the business users at a high level to perform adhoc reporting by connecting to a published data source on the Tableau server leveraging Web Authoring feature.

Environment: Tableau 9.0 Desktop, Tableau 9.0.4 Server, SQL Server 2012, Cognos Power play9, Cognos 10.1.1

Confidential, Houston, TX

BI Developer

Responsibilities:

• Have Built Customer Analytics, Churn Analytics, Sales Analytics, Monthly and weekly metrics, Revenue Rates, Pre-paid customer reports, dashboard which involved count based reporting.
• Upgrade of Tableau server 8.2 to 9.0.1 in Production and other environments.
• Administering tableau server backup and restores.
• Administering data extracts and dashboards
• Assigning access to users for dashboards
• Requirements gathering and data analysis
• Tableau dashboard development and publishing to server environments
• Used SQL server 2012, Oracle 11 and excel sheets as data sources
• Created various kinds of adhoc reports based on business scenarios

Environment: Tableau 8.3, 9.0 Desktop, Tableau 9.0.1 Server, SQL Server 2012, Oracle 11g

Confidential, Rochester, NY

Tableau/BI Developer

Responsibilities:

• Installed and Configured MS SQL Server 2005 and 2012 Enterprise edition on Windows Server 2003 and 2008 on Development, QA and Production environments.
• Administered policies, standards, procedures and guidelines necessary to effectively maintain the database environment.
• Involved in Build, deploy, Test and Production Phase of various fractions of the project.
• Involved in 3rd party company discussions for migrating database and application from Oracle(Unix) environment to SQL Server 2005(Windows)
• Created Disaster Recovery Plan strategies.
• Created the Production database backup and restore strategy and implemented the Database recovery procedures.
• Configured and maintained DB Mirroring synchronously between production and UAT
• Responsible for Administering the Logins, Users and Roles in context of SQL Server security.
• Transferred data (ETL) to Data ware house Environment using SSIS.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested & implemented Backup strategies.
• Worked closely with the tape backup team to set up appropriate backup schedules for Production Servers based on the size of the databases.
• Developed automated jobs to back up and run DBCC scripts for databases and transaction logs, which has been scheduled as maintenance plans.
• Used SQL Server Integration Services (SSIS) an Extract Transform Loading (ETL) tool of SQL Server to populate Data from various data sources, created packages for different data loading operations for application.
• Created and scheduled various SQL server jobs to involve batch scripts, SSIS packages or other codes to perform various automated tasks.
• Used SQL Sentry tool to chain the SQL server jobs and monitor the performance of SQL Server.
• Played the role of Oracle Apps DBA
• Responsible for complete setup & configuration of Oracle database instances on Unix environment
• Done Oracle database upgrade from 9i to 10g in Unix environment
• Applied Oracle database patches on 9i and 10g in Unix environment
• Responsible for Oracle User Administration
• Responsible for Cold backup of databases and coordinated the Tape backup schedules.
• Responsible for Setup & Scheduling of various job in Crontab & FTP of files in Solaris environment
• Shell scripting in Solaris 9/10 environment for setup of jobs
• Install & configure Tableau 8.0 in 3 different environments
• Upgrade of Tableau server from 8.0 to 8.2.
• Setup of Tableau server backup and recovery strategy
• Was responsible for Site creation, User and Group administration, Scheduling extract refresh.
• Have built dashboards on enterprise consolidation and submission systems where users from all over the world submit financial data
• Performed Tableau reporting on top of SQL server, Excel
• Common reports across all regions were also developed, accessing region specific data through parameterized data access.
• Developed a community development dashboard with a creative visualization.

Environment: Tableau 8.2, SQL Server 2005,2012, Oracle 9i,10g, Solaris 9,10(Unix), BIDS 2005, SQL Sentry, PL/SQL Developer, SSMS.