OBJECTIVE:

Enthusiastic IT professional with 10 years’ experience,5 years in Tableau Developer, Data and business analytics with Strong analytical and problem solving and communication skills, ability to work to deadlines, result oriented, flexible and adaptable, sharp attention to details, excellent verbal and written communication skills, team player and ability to learn innovative technologies independently.

PROFESSIONAL SUMMARY:

• Over all 10+ years of experience in Business Intelligence(BI), Data Analytics, Database design and development of Dashboards, Reports and KPIs, IT Project Management,
• Expertise in designing and development of various Tableau Visualizations dashboards, Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Geographic Map reports, creating aggregates, Joins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters.
• Designed and develop various analytical reports from multiple data sources (SQL server, Excel/Flat data files, etc).
• Extensive experience in Relational Database Design (Conceptual, Logical and Physical database design) Normalization till BCNF
• In-depth experience in RDBMS concepts and constructs along with Objects creation such as Database, Table, User Defined Data Type, Indexes, Stored Procedures, Views, UDF, Cursors and Triggers.
• Extensive experience in Data Extraction and Transforming and Loading (ETL) using DTS package in SSIS in MS SQL Server 2005/2008R 2/2012/2014/2016 .
• Strong experience in creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services (SSRS) .
• Experienced in Analyzing the BI Needs, interpreting business user requirements and translating them into reports
• Team player with good communication and interpersonal skills.
• Excellent communication (multi-lingual) and writing skills with the ability to adapt to new and dynamic environments and work in multicultural settings
• Ability to multi-task, prioritize and work with time constraints while paying attention to details
• Good problem-solving, judgment, and decision-making skills
• Ability to work with all levels of management, willingness to learn and implement new ideas
• Ability to handle multiple tasks concurrently and meet the deadlines

TECHNOLOGY AND SKILLS:

Tableau: Tableau Desktop 9/10.4/10.5/2018.1/2018.2/ , Tableau Server 10.4/10.5

MS Business Intelligence: Power BI, BIDS,DTS, SQL SSIS, SSRS and SSAS

RDBMS: Database Development of MS SQL Server 2005/2008R 2/2012/2014/2016 ; MySQL / PostgreSQL

Data Modeling Tools: Lucid Chart, Erwin, Toad, SQL, MS Visio

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

Project Management and Agile Methods: MS Project, JIRA

Operating System: Windows Server 2008R2, 2012, .NET, Windows 10, 8, 8.1 and Windows 7 desktop

Virtualization: VMWare, Virtual Box

Cloud Technologies: AWS, Azure

PROFESSIONAL EXPERIENCE:

Confidential, Silver Spring, MD

Senior Tableau Developer

Responsibilities:

• Designed, developed, tested, and maintained Tableau functional reports based on user requirements
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau
• Involved in creating database objects like tables, views, procedures, triggers, functions using SQL definition, structure and to maintain data efficiently
• Extensively involved in creating graphs by using measures and dimensions data from various databases by using data blending concept
• Converted existing BO reports to tableau dashboards
• Converted different KPI using calculated key figures and Parameters
• Developed Tableau data visualization using Cross tabs, Heat Maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and tableau calculations
• Provided Production Support to Tableau users and wrote Custom SQL to support business requirements
• Utilized Tubule server to publish and share the reports with the business users

Environment: Tableau Desktop 10.4/ 2018.2/ for development and sandbox, Tableau Server 10.5/10.4/, SQL 2014, SISS, SRSS, Windows 2012R2 Server, Lucid Chart, MS Project 2016, JIRA, MS Office 2010/2007

Confidential, Washington, DC

Senior Tableau Developer

Responsibilities:

• Oversee the performance of design to develop technical solutions from Analysis documents.
• Created relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and Excel.
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and Tableau.
• Involved in creating views, stored procedures, and custom SQL queries to import data from SQL server to Tableau.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created Data Connections, Published on Tableau Server for usage with Operational or Monitoring Dashboards.
• Tableau Logs - Reviewing the Server logs for any errors or security issues that are unexpected.
• Performance Logs - Reviewing the performance metrics to determine if the baseline exceeded or for the slow points during the day that need to be reviewed.
• Tested reports and uploaded Tableau dashboards on to server and provided production support for Tableau users.
• Created Heat maps, Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server, MS Excel, and MS SQL Server to create various Tableau Dashboards and Reports.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report. Used Tableau advanced functions like LOD Level Of Detail, Lookup and Sets.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks and did performance tuning on various Tableau Reports, Dashboards.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets based on AWS Redshift Cloud data source.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand, needed information.
• Reviewed transactional database schemas (OLTP) and utilized Tableau software to build Reports and Dashboards.
• Involved in sprint planning sessions and sizing the user stories in AGILE SCRUM environment

Environment: Tableau Desktop 10.2.6, Tableau Online, Tableau Server, Tableau Administration, Jira, SQL Workbench, AWS Redshift, SQL Workbench, MS SQL Server 2012 and Windows Server 2012.

Confidential, Washington, DC

Tableau Developer

Responsibilities:

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• 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.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Designed dashboard templates as per the requirement and dashboard content which includes complex tabular reports.
• Utilized capabilities of Tableau such as Data extracts, Data blending, Dash board actions and Table calculations.
• Involved in migrating client's reports from excel (static) based solution to an interactive service.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Installed Tableau Server 8.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.
• Created incremental refreshes for data sources on Tableau server.
• Developed report level logic as per the requirement and DB constraints, creating POC for client approvals.
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Involved in license management SLA's with Tableau support.
• Worked on scheduling the extracts and setting up the permissions.
• Extensively used Tab admin and Tab commands in creating backups and restoring backups of Tableau repository.

Environment: Tableau Desktop 8.x, Tableau server / Administrator, Tableau drive, SQL developer, SQL 2012, Oracle 11g, DB2, JavaScript API, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007.and Windows Server 2008.

Confidential

SQL Server DBA

Responsibilities:

• Installed and Maintained SQL server 2008/2008R
• Upgraded SQL server databases from SQL 2000/2005 to SQL2008R2
• Recovered the databases from backup in disasters
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuild the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Performed SQL Server service pack and Windows Service pack upgrades.
• Worked with customers on Application rollouts and server migrations.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers.
• Troubleshoot performance problems and fine-tuning of databases.
• Involved in Index Analysis and Performance Tuning.
• Analyzed long running slow queries and tuned the same to optimize application and system performance.

Environment: SQL Server 2008/2005, Windows 2008, 2007, Windows 2003 Server, MS TFS, MS-Access.