SUMMARY

• 8+ years of Professional IT experience as BI Developer in diverse Sectors and Experience in Software Development Life Cycle (SDLC) phases like Requirement Gathering, Analysis, Design, Development, Integration and Testing, and Implementation.
• Extensive SQL and Tableau Development experience in Telecom and Healthcareindustries with a strong understanding of data and analytics.
• Highly proficient in the use of T - SQL for creating Tables, Views, Triggers, Cursors and developing complex Dynamic Stored Procedures, User Defined Functions, and other Transact-SQL (DDL, DML) statements.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Proficient in creating Calculated Fields, Calculations, Quick Table Calculations, Compute using, LOD Expressions and Groups, Sets, Parameters and Actions.
• Extensively Leveraged Formatting options on Marks (Color, Size, Text, Detail, Tool tip), Legends, Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Worked in Tableau Server for creating site, users, groups, and roles, administering extracts, refreshes and data sources and dashboards.
• Experience in data extraction and integration, data modeling and data rendering, cross database joins, unions, and data blending inTableau.
• Expert in utilizing Tableau Best Practices and performance tuning guidelines to increase performance and help make dashboard more visually appealing and user friendly.
• Managed Projects, SQL Database Views, SQL Data Sources and SQL Data Connections in multiple data sources.
• Worked on time sensitive deliverable in Sprint sessions. Developed Solution in Tableau to supporting and integrating a variety of financial operations systems.
• Created, customize, and publish interactive payer/claim/bad debt Dashboards, visualizations by using advanced functions in tableau/looker.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Analyzed complex business user needs, documents information requirements, Led the Quantitative analysis dashboards (Looker 6 X 7. Vx /Tableau)for globally shared business services of, the effectiveness of the Paid Marketing Campaigns (Co-op) for stakeholders, providing effectiveness and insights.
• Good understanding of Normalization /De-normalization, Normal Forms, and database design methodology.
• Designed and deployedreportswith Drill Down, Drill Through, Drop Down, Parameterized, Sub-reportsand Linkedreports.
• Experience in query optimization and performance tuning.
• Good communication, interpersonal and business analysis skills.

TECHNICAL SKILLS

RDBMS: MS SQL SERVER 2017/2012/2008/2005

Databases Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS),Database Engine Tuning Advisor, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, SSRS, SSIS, Visual Studio 2015

Programming Languages: SQL, TSQL, XML, PL/SQL, C, C++.

Operating Systems: Windows 95/98/2000/2003/2008/ XP/NT 4.0, MS-DOS.

Bi Tools: Looker 4.1 to 5.10,Tableau

Utility Tools: MS Office, MS Project, GITHUB, TFS.

Other Tools: PowerShell, Erwin 3.5.2,4.0, JAMS and Control-M

PROFESSIONAL EXPERIENCE

Confidential

BI Developer/Looker Consultant

Responsibilities:

• Defined the current reporting activities for the development of existing and future reporting procedures and models by charting existing processes.
• Developed routines and procedures for end - users to facilitate best practices use of reporting tools and applications.
• Experienced with report writing and technical requirements analysis, business process modeling/mapping, methodology development, performance tuning and data modeling.
• Worked on Data Modelling side like building architectures, validating excel sheets from the data downloads from Looker.
• Designed Looker data visualization utilizing cross tabs, maps, scatter plots, pies, and bar charts.
• Created Custom filters, and calculated sets for preparing dashboards and Looks in Looker.
• Wrote complex SQL, and LookML queries, and functions from our relational and dimensional databases and objects for end user consumption.
• Troubleshoots BI-related problems, fixes bugs and tunes for performance.
• Developed the visually appealing and attracting data visualization dashboards and looks which can enlighten a large audience with some advanced Looker features.
• Worked on support issues on data warehouse data issues, memory issues, production support issues, provide the ad-hoc dashboard environment for the business users. Using Looker dashboards as a front-end BI tool and MySQL as a back-end database designed and developed Looks, dashboards, custom filter page, and complex table calculations.
• Created complex formulas and calculations within Looker to meet the needs of complex business logic.
• Created drill through reports in dashboard.
• Created different Models in Looker for integration processes.
• Created advanced analytical dashboards using Reference Lines, and Trend Lines.
• Created Dashboards using Merged Results feature in Looker.
• Expertise in configuring the Looker to Git hub and publishing and deploying the LookML code to it.
• Troubleshoot Looker related issues and queries.
• Created the Specification document for Looks and dashboards.

Confidential

BI Developer/Tableau Developer

Responsibilities:

• Worked extensively on creating visualizations using different types of files, doing cross database joins and data blending with multiple data sources.
• Design interactive story telling dashboards, Charts and Visualizations in Tableau Desktop and published them in Tableau Server.
• Extensively worked on applying various types of Filters (Extract, Data source, Dimension, quick filter, context filter, user filter).
• Worked on data sources with Live and Extract connection data sources.
• Involved in Testing the data model, data source, dashboards and visualizations using various methodologies.
• Worked extensively on tableau server: updating logo, creating sites, projects, groups, and users.
• Managed Roles and User Access management across various sources (dashboards, sites, data sources etc.).
• Took care of Extract refreshes and failures, real-time errors, and issues.
• Designed Tableau Dashboards & Visualizations by connecting with cloud based data warehouses.

Confidential

BI Developer

Responsibilities:

• Wrote SQL Queries which helps in validating the reports.
• Performed Unit test plans and Unit test results for the reports.
• Published reports, created groups, users, and projects on tableau servers.
• Developed dashboards on the Tableau desktop and also created many Tableau visualizations.
• Expertise in Tableau calculations and applying all the compound and complex calculations to large data sets.
• Involved in discussions with Client architects, Project managers, Developers for implementation of solutions.
• Involved in developing the workbooks in tableau from various data sources using Data Blending.