SUMMARY

• 6+ years of IT experience in various sectors, including Healthcare, Pharma, Financial and Retail as a SQL Server BI Developer and DBA that includes Database Design, Development and Administration in various versions of MS SQL Server including 2014/2016.
• 5 years if expertise in development and administration of Tableau, Power BI.
• Involved in all phases of Software Development Life Cycle (SDLC) in different implementation models.
• Experience in Data Modeling, Database Design, SQL Scripting, Development and Implementation of Client - Server & Business Intelligence (SSIS, SSAS, SSRS) applications.
• Expertise in scripting T-SQL, U-SQL and PL/SQL queries, complex stored procedures, user defined functions (UDF), Database triggers.
• Perform environmental upgrades and apply patches using Unix shell scripting.
• Experience in writing complex DAX function in Power BI and Power Pivot.
• Experience in creating and Performance Tuning of SSIS packages.
• Experience in providing Logging, Error handling and Custom Logging for SSIS Packages.
• Expert in designing complex reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP and multi-dimensional Cube.
• Good knowledge on Data warehousing, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables using SSAS.
• Worked on Microsoft Azure Data Factory (ADF) and Azure Data Lake (ADL).
• Experience in Database Mirroring, Log Shipping, Database Replication, CDC and Database Snapshots
• Created and monitored Change Control and Active Directory process.
• Experience in configuring SSL, SSO, Proxy, AD on Tableau.
• Experience in Data Center Migrations and Server consolidation.
• Excellent communication, negotiation, facilitation and interpersonal skills and ability to present and articulate using a variety of verbal, written and visual methods where appropriate to a diverse range of audiences.
• Self-motivated and able to work primarily without direction.

TECHNICAL SKILLS

Databases: Microsoft SQL Server 2014, 2016, Oracle 10g/11g, Teradata, MS Access, NoSQL

Scripting: TSQL, PL/SQL, MDX, DAX, Python, PowerShell, Unix Shell Scripting, C++, C#

Business Intelligence and Reporting: SSRS, Power BI, Tableau, Crystal Reports, Business Objects

ETL Technologies: SSIS, Informatica

OLAP: SSAS, MDX

DBA: Profiler, Redgate

Microsoft Suite: Excel, Project, Visio

Cloud and DevOps CI: Microsoft Azure, Snowflake

Collaboration: Team Foundation Server, Git

PROFESSIONAL EXPERIENCE

Confidential, South Plainfield, NJ

SSIS/SQL Developer

Responsibilities:

• Work with various functional areas to understand the Global requirements for brand new projects.
• Created SQL stored procedures, views to disable and rebuild indexes to minimize the data loading process time, taking advantage of cursors, CTE’s, dynamic management views as well as temporary tables.
• Performed testing through different BI Tool sets like Power BI and Tableau for the Business Stakeholders.
• Experience on creating and developing C# scripts in script component of Visual Studio.
• Engineered complex reports and Dashboards for the users using Power BI.
• Tuned Indexes for maintaining the database for performance.
• Worked on creating various non-buildable scripts in VS 2017 to generate real time data on database.
• Created new and modified existing SSIS packages to suit the new Data sources and Tools.
• Created and delivered various SSRS reports for the Team and users.
• Involved in Dimensional modeling by identifying the fact and dimension tables and snowflake schemas for the SSAS.
• Created complex Excel reports and Dashboards for the users using Power BI.
• Created PowerShell scripts and developed SQL Server Utility Tools-SQLPS using PowerShell and Batch.
• Created and managed branches on GitHub, through GIT commands and resolved PR issues for assigned tasks.
• Performed Backups, Disaster Recovery Model, database maintenance, user authorizations, provided access to the users to the database based on the Ticketing system.

Environment: SQL Server 2016, Visual Studio 2017, SSIS, SSRS, MS Excel, Power BI, PowerShell

Confidential, MD

Technical Analyst

Responsibilities:

• Resolve program logic errors, performance upgrades and access data for clients.
• Perform Evaluate configurations, create projects in evaluate.
• Worked on creating SQL tables and views for Origenate and Evaluate.
• Created XMLs and Stylesheets to generate JSON output.
• Scripted many DAX function in Power BI to show good data analysis.
• Performed Python coding to generate scorecard bulk files.
• Implemented solutions to correct performance problems.
• Perform mapping Origenate with respect to client’s requirements.
• Perform Originate and evaluate environment upgrades and ability to apply patches.
• Coordinated and managed test activities for assigned application.
• Worked on documenting business and functional requirements.
• Performed various testing scenarios on UNIX to successfully process loan application.

Environment: Unix, SQL Developer, FileZilla, putty, Excel, Toad, Python, Java script.

Confidential, FL

Dashboard Specialist

Responsibilities:

• Reviewed the existing ETL Frame work- Informatica to build the data warehouse.
• Worked directly with the Business to understand the existing BI Model.
• Created Power BI Dashboards for the financial team.
• Created Tableau Dashboards for Executive Leadership.
• Write & maintain data load rules, calc scripts and business rules in Hyperion Essbase and Hyperion Planning.
• Created complex SQL Data model for creating the Dashboards.
• Responsible to create Tableau Dashboards and Power BI at an organizational level.
• Served as a Tableau Server Admin for creating roles grant permissions.
• Created Roles and Security for Power BI Dashboards.
• Deployed the Dashboards in the App Workspaces and share with the business users.

Environment: SAP, SQL Server 2014, MS Azure, Excel, Power BI, Informatica.

Confidential, FL

Sr. BI Lead/ Tableau Admin

Responsibilities:

• Worked with various functional areas to understand the Global requirements for brand new projects.
• Implemented new processes for consolidating multiple sources using Continuous Integration DEVOPS on Azure Cloud.
• Maintained the Database while providing always ON availability of the server.
• Created GBI Cube for the creating various dashboards using Power BI for Business users on a Global scale.
• Tested different BI Tool sets like Power BI and Tableau for the Business Stakeholders.
• Engineered highly complex reports and Dashboards for the users using Power pivot, Hubble and Power BI.
• Tuned Indexes for maintaining the database for performance.
• Created new and modified existing SSIS packages to suit the new Data sources and Tools.
• Created and delivered various SSRS reports to SharePoint for the Leadership Team and Super Users.
• Created complex Excel reports and Dashboards for the users using Power pivot and Power BI.
• Lead the Off-shore team to make sure the requirements have been correctly translated.
• Worked towards increase in adoption of BI and Analytical applications by demonstrating the business value that can be generated from the use of existing information assets.
• Provided support to internal stakeholders with respect to information sourcing and their appropriate uses for commercial data, based on an understanding of the current data sources and business rules.
• Involved in complete design discussions, requirement gathering and development phases of the Break Free Global BI project.

Environment: SQL Server 2014, SQL Server 2012, SSIS, SSAS, SSRS, MS Azure, Chef, Excel, Power BI, Python

Confidential, Mansfield, MA

Tableau Admin/ Data Analyst

Responsibilities:

• Involved in revamping the existing Tableau dashboards by switching the data source to Microsoft Analysis Cube.
• Worked with cross functional teams to understand the report dashboard requirements.
• Created Tableau Dashboards using the Microsoft Analysis Services Cube and responsible for deployment to various environments.
• Involved in testing the dashboards by comparing the dashboard data to the RDBMS Data.
• Responsible for Tableau Administration - both as Site and Server Admins.
• Participated in conversations with Tableau Phone Support to improve performance and implement various modules on the integration of Tableau with Microsoft Analysis Services.
• Responsible to improve the performance of Dashboards when connected to Microsoft Analysis Services.
• Responsible for creating source to destination data mapping documents and architecting ETL solutions using SQL server integration services (SSIS).
• Managed Offshore team for timely delivery of the dashboards.
• Responsible for unit testing & deploying code to production.
• Responsible for scheduling ETL (SSIS) packages using SQL server job scheduler.
• Involved in performance tuning of SQL queries &SSIS packages.

Environment: SQL Server 2014, Tableau 9.3, SSAS, MDX.

Confidential 

Jr. SQL Developer

Responsibilities:

• Development of SQL scripts for backup restore.
• Creation of stored procedures for application development.
• Performance tuning of SQL statements using stored procedures and indexes.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Replication of data using transactional method.
• Created crystal reports, ODBC and database connections.
• Worked with Oracle and MS SQL Server databases to create reports using Crystal Reports.
• Formatting of reports for various output formats as per the convenience of the end users.
• Scheduling of alerts.

Environment: MS SQL Server 2000, MS Access, DTS, Erwin, SQL Query Analyzer, Crystal Reports.