SUMMARY

• Seasoned database administrator wif experience across multiple domains and technologies. Dedicated problem solver, go - to resource around 7 years of extensive experience in DB, BI, ELT/ETL and DW Development and Support wif expertise in Microsoft SQL Technologies, R, Python and MS Azure Cloud platforms.
• Expertise in skills related to Statistical modeling, Regression Analysis, Data Wrangling and Data Analysis. Knowledge and expertise in ML algorithms and sampling schemes. Data visualization and Tabular Model Analysis services experience and modeling experience. Experience in Supply Chain Analytics, Real Time Analytics, Web Analytics and Stream Analytics.
• Over 6+ years of MS SQL Server Support experience in Telecom, Banking, Retail & Manufacturing, and Internal Infrastructure Services domains wif expertise in MS SQL Server 2000/2005/2008/2008R2 and Microsoft’s suite of products like SSIS, SSAS, and SSRS.
• Highly proficient in teh use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Rules, Defaults, User Defined Functions, views, indexes, user profiles, Relational Database models, query writing and SQL joins.
• Expert in Performance Tuning, Handling Indexes, and Query Optimization
• Developed, Monitored and Deployed SSIS Packages from Development environment to Production environment.
• Developed ETL packages using SQL Server 2008/2012 Integration Services to populate data from different sources like flat files/CSV Files to Staging Databases. Teh packages include wide variety of transformations like Look Up, Aggregate, Derived Column, Conditional Split, Multi-Cast and data conversion, Script tasks.
• Worked on script components is SSIS using VB.NET scripts and schedule Jobs and Alerts using SQL Server Agent.
• Involve in testing teh XML files and checked whether data is parsed and loaded to staging tables.
• Perform all scenarios of testing Transformation Rules, Referential Integrity, Data Integrity, Scenario Based Testing and creating statistical reports which include Pie Charts, Bar Charts using SSRS.
• Responsible for Database Backups and Restore on Daily Basis.
• Migrate Databases from one environment to another environment.
• Maintain versions using TFS / Azure DevOps / GitHub.
• Test several stored procedures.
• Test teh ETL Process for both before validation and after data validation process. Test teh messages published by ETL tool and data loaded into various databases.
• Experience in working in SCOM, SCSM and STAR User Stories in Service Eng. Architecture in Microsoft.
• Experience in working in SQL Azure and Windows Azure (IaaS and PaaS)
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, DTS, Bulk Insert and BCP.
• Experience in working wif SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Experienced in Designing large data warehouses using MS Stack and MS Azure Stack end to end.

TECHNICAL SKILLS

RDBMS: SQL Server 2016/2014/2012/2008R2/2008/2005/2000, MS Access.

Tools and Packages: SQL Server Management studio, SSIS, SSRS, SSAS, DTS, Microsoft Visual Source Safe, SQL Query Editor, Crystal Reports XI, Informatica, SAP BO XI, GitHub, R Studio

Languages: T-SQL, HTML, XML, SQL, C, VB.Net, ASP.Net, jQuery. R, Java, JavaScript

Operating Systems: Windows vista/XP/2003/2000/NT 4.0/9x/10, MS-DOS

Web Technologies: HTML, XML, XSL, IIS (4.0/5.0/6.0/7.0), JSON

Application Packages: MS Office, MS Outlook (Microsoft Office Suite)

BI / Stat Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Power Pivot, Power BI, TABLEAU Modal and Multi-Dimensional Modal, MS, Business Objects XI (SAP BO XI), Crystal Reports, Azure Analysis Services, DAX, MDX

Middle Ware Technologies: Biz Talk Server, Share point

Monitoring tools: SCOM, SCSM, STAR User Stories in Service Eng. at Microsoft, Jira, BitBucket, Azure DevOps

PROFESSIONAL EXPERIENCE

Confidential, Chattanooga, Tennessee

Database Administrator

Responsibilities:

• Installed Sql Server 2012-2017 on Standalone VM Server.
• Responsible to Design and Support Database Environment’s running MS-SQL Server 2014,2016.
• Involved in multiple migration project to migrate On-Prem databases to Cloud on Managed Instance and on Azure Pass DB.
• Developed Database Objects like Tables, Stored Procedures, Views, and Triggers.
• Involved in storage\capacity SAN (EMC) meetings for teh upcoming projects.
• Extensively involved in implanting RFC and Change Board Activity.
• Responsible to work wif other Database administrator on projects and complex issues.
• Collaborate wif other Data Architects for Data Model management and version control.
• Establish users wif appropriate permissions.
• Successfully migrated production servers from MS-SQL Server 2008 to 2014.
• Perform User Account management and health checks.
• Ensure Data Warehouse and Data Mart designs efficiently support BI and end users.
• Responsible to create Database/Tables/Views/Roles/Users as needed.
• Help Data Modelers in Create new objects wifin teh database’s
• Created an automated process to migrate data from Production to Development and QA boxes. Also helped teh client in developing a strategy to efficiently perform and maintain their monthly backups on a common share avoiding storage issues on servers.
• Created more advanced backup and restore Strategy.
• Work wif teh Management team to understand requirements for upcoming projects.
• Supported optimal performance of databases by gathering statistics and indexes and Query tuning.
• Created and managed Data Replication across different Environments.
• Responsible to Install & Maintain SQL Servers running in Production and non-production Environments.
• Involved in identifying performance issues.
• Provided 24x7 on-call support.

Confidential, Toronto, ON

Database Administrator

Responsibilities:

• Assist in setting and maintaining standards for teh SQL environments concerning security, installation, and upgrades.
• Perform routine database administration duties and provide documentation and change control logs where needed. Schedule jobs and queries.
• Make infrastructure recommendations (Server \s memory, CPU, or upgrades).
• Perform some application development, including stored procedures, triggers, design changes and improvements, using transact-SQL or PL/SQL.
• Database Backups and Restores.
• Data Transfers using Microsoft DTS.
• Database Roles and Security.
• Use database replication/synchronization techniques.
• Create Reports and Scripts which is being used by billing.
• Database Clustering (Active\Passive).
• Proactively monitoring teh performance and tuning of SQL server databases. Monitor teh daily performance of teh production database.
• Provided 24x7 on-call support.

Confidential

Data Engineer

Responsibilities:

• Part of MCIO (Microsoft Cloud Infrastructure Operations) Org - CSDF (Cloud Services Demand Forecasting) Data Engineering Team
• Developing features in Azure Analysis services for various cubes offered to partners - forecasters and Data Scientists.
• Azure Automation Runbooks to develop power shell scripts for automatic load of data into Tabular Cubes.
• Analyzing Telemetry data in source Azure SQL DB, Azure SQL DW from Cosmos, ADF pipelines.
• Developing SQL Stored Procs, Acquiring Data from Blobs (No-SQL), Cosmos (Scope scripts) and from cosmos / ADLS streams, Azure SQL DW into Azure SQL DB database for AAS (Azure Analysis services) and Power BI dashboards.
• Worked wif Spark R, Data bricks to develop R scripts to assist data science team in forecast modelling.
• U-SQL scripts in Cosmos scope scripts to do data wrangling and transformation to meet business requirements for dashboards.
• Develop DAX expressions for AAS cubes. Refactoring and Re-engineering existing AAS cubes to reduce from higher tier to lower tier in terms of storage and compute and cost effectiveness to teh team.
• Bus matrix, Deck presentations during scrum brown bags for feature demonstration to partners and other teams (upstream/downstream) and wifin teh team for noledge transfer.
• Leveraging Big data technologies of Microsoft and other open-source technologies to create data sets which are large and complex to create dashboards.
• Created pipelines, data sets, linked services in ADF v2.0
• Develop Python, R and Spark SQL scripts using Azure Data bricks.
• Developed Forecast Perf Dashboard for Short Term Forecasts using Cosmos scripts and using ADLS, ADLA and R scripts.