SUMMARY:

• Microsoft Certified Professional with around 5 + years of IT experience in the Data Analysis, Design, Development, SDLC life cycle, Requirements Gathering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite.
• Experienced in developing logical and physical data models using data modeling tools such as Erwin and ER/Studio.
• Experienced in Database Backup, Recovery and Disaster Recovery procedures and in monitoring and tuning Server and database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Designed and developed Data Warehouses, Data marts and Business Intelligence using multi - dimensional models such as Star Schemas and Snowflake Schema for developing Cubes using MDX in SSAS.
• Adapted to enterprise environment security in order to provide ongoing support for PowerShell .
• Developed and implemented DR solutions for top critical databases for an organization using solutions like SQL Server Clustering, Database Mirroring, Log Shipping, Replication and Always on Availability Groups.
• Provided support for SSIS and SSRS deployment in production by deploying, scheduling, monitoring and troubleshooting SSIS packages and SSRS reports.

TECHNICAL SKILLS:

Databases: MS SQL Server 2016/ 2014/2012/2008 /2005/2000

Programming: T-SQL, PowerShell, MySQL

SQL Server Tools: Management Studio, Business Intelligence Development Studio, Visual Studio 2005, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, DTS, Log Shipping, Server Network Utility, Database Tuning Wizard, Index Tuning Wizard, SSIS, SSAS, SSRS, Microsoft Clustering Services (MSCS).

Report Tools: SQL Server Reporting Services, Business Objects.

Others: Solar winds, Lite Speed, Red gate, Embarcadero, Tableau reporting tool, Power BI,Minitab

PROFESSIONAL EXPERIENCE:

Confidential, Fort Lauderdale, FL

Data Analyst

Responsibilities:

• Created various forms of reports such as tabular, matrix, charts, drill down and parametrized reports and deployed them to report server.
• Expertise in troubleshooting failed SSIS, SSRS jobs, performance tuning long running queries, resolving high CPU usage, I/O memory, rewriting stored procedures to meet the customer specifications
• Involved in data visualization, managing existing cubes and reports using Power BI and SSAS
• Worked in installing and implementation of software like Python, R software for the Analytics team.

Environment: SQL Server 2016, 2008 R2, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Windows Server 2008,2012,2014,2016, Power BI

Confidential , Bakersfield, CA

Data Analyst

Responsibilities:

• Developed T-SQL queries through Stored Procedures, Functions, Triggers, Cursors, etc.
• Migrated SQL Server 2008 database to Windows Azure SQL Database and updating the Connection Strings based on this
• Extensive experience on building dashboards using Tableau.
• Gained hands on experience on Data Modeling and reverse engineering using Embarcadero Tool

Environment: MS SQL Reporting Services, SQL Server 2005, 2008, 2008R2, 2012, 2014,2016, Tableau

Confidential, San Antonio, Texas

SQL Developer

Responsibilities:

• Created entity relationship diagrams and multidimensional data models, reports and diagrams for various applications.
• Worked on Logical Administration of application objects within database, maintenance of business requirements for database, database schema, data maps, ERDs, application objects.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, data mining models, developing reports using MDX and SQL.
• Worked extensively on implementation of Ola Hallengren Maintenance solution scripts for running native backups on production and development environments.

Environment: MS SQL Reporting Services, SQL Server 2005, 2008, 2008R2, 2012, 2014,2016, Power BI

Confidential, Tyler, Texas

SQL Assistant

Responsibilities:

• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains
• Experience in using ERWIN tool for designing the reporting databases.
• Generated reports from SSRS (SQL server reporting services) and SSAS.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.

Environment: SQL Server 2014/2012/2008 R2, Windows 2012/2008 Servers, T-SQL.

Confidential

SQL BI Consultant

Responsibilities:

• Actively involved in different stages of SDLC Project Life Cycle.
• Actively participated in gathering User Requirements and System Specifications.
• Created new database logical and physical design to fit new business requirements, and implemented new design in SQL Server 2005/2000.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Actively participated in User Acceptance Testing, and debugging of the system.

Environment: SQL Server 2005/2000, SQL Profiler, Windows 2003/2000 Server, Import & Export Data.

Confidential

Analytics Intern

Responsibilities:

• Collected and analyzed data to measure surface roughness and residual stresses during high speed dry turning of Inconel 718.
• Conducted scientific design of experiments methodology to check manufacturability and study process design and validation
• Evaluated the performance using statistical analysis by Taguchi Grey Relational Analysis, Mat lab and Minitab.

Environment: SQL Server 2014, Advanced Excel, Minitab, Visio, UML tools.