PROFESSIONAL SUMMARY:

• 12+ years of IT experience in various sectors, including Healthcare, Pharma, Financial and Retail as a SQLServerBIDeveloper and DBA that includes Database Design, Development and Administrationin various versions of MS SQL Serverincluding2014/2012.
• 5 years if expertise in development and administration of Tableau,Power BI, Toad, QlikView and Hubble.
• Knowledge of Statistical analytical scripting like SAS and R.
• 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-SQLand PL/SQLqueries, complex stored procedures, user defined functions (UDF), Database triggers.
• Experience working on Azure Architecture and Analysis Services.
• Experience in creating and monitoring Hyperion applications including Planning, Essbase, DRM, FDM and other related automated process.
• Experience in performing various activities like importing and exporting data stage projects.
• Experience working on Fannie Mae RDW/EDI data.
• Perform environmental upgrades and apply patches using Unix shell scripting.
• Experience in writing complex DAX function in Power BI and Power Pivot.
• Involved in performance tuning of Datastage jobs at stage level.
• Experience in creating and PerformanceTuningof 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 OLAPand multi-dimensional Cube.
• Planned and implemented MS SQL Server Security and database access.
• Experience in Database Mirroring, Log Shipping,Database Replication, CDC and Database Snapshots
• Created and monitored Change Control and Active Directory process.
• Troubleshoot performance issues and bottlenecks using PerfMon and Profiler for monitoring dead locks and long running queries.
• 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 2005, 2008/R2, 2012, 2014, 2016, Oracle 10g/11g, Teradata, MS Access, NoSQL

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

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

ETL Technologies: SSIS, Informatica, SAP PI

OLAP: SSAS, MDX

DBA: Profiler, Automate, Idera, Redgate

Microsoft Suite: Excel, Project, Visio

Cloud and DevOps CI: Microsoft Azure, Jenkins, Chef, Ruby, Puppet

Collaboration: Team Foundation Server, Git

PROFESSIONAL EXPERIENCE:

Confidential, MD

SQL Developer

Responsibilities:

• Resolve program logic errors, performance upgrades and access data for clients.
• Perform Evaluate configurations, create projects in evaluate.
• Created Numerous simple to complex queries involving self joins, correlated subqueries and XML techniques for diverse business requirements.
• 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.
• Individually authored, installed, deployed and managed reports using SSRS for a library database.
• Created a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the import and export of data using CSV and SSIS.
• Performed evaluation and selection of performance tools.
• Implemented new processes for consolidating multiple sources using Continuous Integration DEVOPS on Azure Cloud.
• Scripted many DAX function in Power BI to show good data analysis.
• Performed Python coding to generate scorecard bulk files.
• Worked on Azure CLI, Microsoft PowerShell and Microsoft .net.
• Performed ETL coding, extensively used stages available to redesign dataStage jobs for performing the required integration.
• Performing unit/string testing on QlikView 11 application development
• Isolated and resolved complex problems using appropriate diagnostic tools.
• Used SQL Profiler tool to monitor SQL server performance, particularly to analyze stored procedures.
• 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,IBM DataStage v8.5, v8.7 and v9.1, SQL Developer, FileZilla, putty, Excel, Toad, Python, Java script.

Confidential, FL

SQL Developer/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 PowerBI 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 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 SQL Data model for creating the Dashboards.
• Extensively used DataStage Tools like Infosphere DataStage Designer, Infosphere DataStage Director for developing jobs and to view log files for execution errors.
• Responsible to createTableau Dashboards andPower 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, IBM DataStage v8.5,Power BI, Informatica.

Confidential, FL

Sr. BI Lead/ Tableau Admin

Responsibilities:

• Worked with variousfunctional areas to understand the Global requirements for brand new projects.
• Implemented new processes for consolidating multiple sources using Continuous Integration DEVOPSon Azure Cloud.
• Maintained the Database while providing always ON availability of the server.
• Created GBI Cube for the creating various dashboards using PowerBIfor 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.
• Lead the Off-shore team to implement and develop the requirements and involved in managing the end User interactions for all the BI requirements.
• Extensively used DataStage Tools like Infosphere DataStage Designer, Infosphere DataStage Director for developing jobs and to view log files for execution errors.
• Tuned Indexes for maintaining the database for performance.
• Work on internal projects to design, develop and deploy Qlik (QlikView and Qlik Sense) applications
• 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.
• Developed effective training and coaching methods intended to increase Analyst capabilities in BI toolsets, solutions and information content, for the purposes of empowering users with new skills that drive business innovation and discovery.
• 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.
• Provided analytical capability to help the Business User to understand and use their data.
• Involved in Performance monitoring & tuning of the Data warehouse.
• Provided On-call support for production systems, job streams, and processes
• Active Database backup (archive) & recovery and Business continuity planning
• Provided access to the users to the database based on the Remedy Force Ticketing system.
• 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, Jenkins, Chef, Ruby, Excel, Power BI, Python, Hubble Insights, ProClarity.

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.

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

Confidential, South San Francisco, CA

Sr. BI Analyst/ SQL Server / QlikViewDeveloper

Responsibilities:

• Involved in requirements gathering for the dashboards, Troubleshoot Data issues and validate the data sources.
• Responsible for creating source to destination data mapping documentsand architecting ETL solutions using SQL server integration services (SSIS).
• Managed Off shore 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.
• Responsible for creating QlikView Dashboards and creating triggers for dashboard refresh.
• Responsible for maintaining user access to the dashboards & Licensing Users for access.
• Created a Technical Design Documentsfor the project’s development.
• Responsible for providing on call support for 24/7 server availability and Production Support.
• Responsible for coordination & communication with the offshore team for the project development effort.

Environment: Windows server 2008, Oracle 11G, SQL Server 2012, QlikView 11, Excel, SSIS, SSRS.

Confidential, San Francisco, CA

MS SQL Server Developer/SSRS/SSIS/DBA

Responsibilities:

• Migrated Data from MS SQL 2005 to MS SQL 2008.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Created packages to migrate data from different data sources to Data warehouse.
• Created packages for database maintenance.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• CreatedSSIS Packages for importing data to Salesforce from different data sources and other ongoing tasks for mapping.
• Created SQL Server Reports using SSRS 2005 for the clients.
• Deployed the developed reports and upgraded the system.
• Deployment of the developed reports on to the server for the end users.
• Fine-tuned the existing SQL queries for maximum efficiency and performance.
• Supported 24/7 for the production system for post deployment Reports on the server.
• Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.

Environment: Windows 7/XP, MS SQL Server 2008/2005, SQL Server Reporting services, PL/SQL,SQL Server Integration Services.