PROFESSIONAL SUMMARY:

• SQL Server Database Administrator & Engineer with 11+ years of experience in design, development and delivery of data and database solutions, System Optimization, Performance Tuning, Problem Analysis, Data Engineering, Automation and Scripting.
• Developed and deployed ETL packages and OLAP Cubes through SQL Server BI Services supporting projects ranging from shorter - term strategic questions from executives, to analysis around the correlation between behavioral activities and outcomes, to longer-term predictive and prescriptive analytical questions.
• Expert Level understanding of BI Best Practices/Methodologies, relational structures, dimensional data modeling, structured query language (SQL) skills, data warehouse and reporting techniques.
• Significant knowledge of data modeling and understanding of different data structures and their benefits and limitations in practical applications.
• Evaluated multiple business requirements and deployed appropriate technical solutions in a clustered environment systems.
• Highly skilled in n-tier architecture data solutions, resource scaling (On-premises and Azure Infrastructure), Service Health & Efficiency, System Telemetry.
• Extensive background in Service Engineering & Operations, Release Engineering, Production Support, Application Programming.
• Well-versed with Supply chain management, Agile, Scrum & ITIL Project models.
• Intermediate-level expertise in PHP & MySQL Programming.
• Entry-level expertise in SQL Server Machine learning services such as R Services (In-Database) and Python Integration. Also, do have a good knowledge & understanding on Hadoop framework

SKILLS & TECHNOLOGIES:

Core Skill Set: SQL Azure, SQL Server Administration (2012, 2014 & 2016 Versions), SQL BI Services and TSQL coding. Data Engineering and Analysis, Telemetry, Problem Analysis, Bug Fix and Feature deployments, Power-shell scripting, Automation and Power BI Reporting. GTM, Hadoop, Python and R

Tools: & Technologies worked: Azure Technologies, Azure Operations Manager suite, Azure Application insights, IIS (7.0) administration, Confidential Precise, GTM Load balancing, AppFabric caching, NetScaler Load balancing, Content Switching & Akamai, Biztalk Server 2006, My SQL, Gentran Server and a basic knowledge in share point.

Coding & Scripting: C#.Net and Open source technologies

Operating Systems: Windows Azure, Windows 2014, Windows 2012, Windows 2008 R2, Windows server 2000, 2003Windows 8 & Linux

Web Related/Open Source Technologies: PHP, HTML, Java Script and CSS, MySQL Development and Administration

Confidential Tools & Utilities: Visual Studio.Net, Confidential SCOM, Windows TFS (Bug tracking and Source Safe Server) and Eclipse.

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

Database Engineering, Administrator & Analyst

Responsibilities:

• In terms of Service Health (such as, OLTP System Tuning, Data Freshness SLA's, Data Analysis & Telemetry). Not too far from the day I took charge, have shown a significant difference in Data processing & SLA metrics.
• 20% improvement in job processing time than the Original.
• Analyzed Disk I/O, Memory & CPU from Counters
• Avoided unused indexes
• Data compression
• Possible filters through covering Indexes
• Converting to delta logic wherever possible (Than Full) - DTE01
• Change in run times considering the Real Business need (Less volumes - fast processing)
• 12 out of 42 datasets are permanently out of SLA breach (30% Improvement)
• While the 20% improvement in Job processing time has impacted the SLA's, the remaining 10% does required the right engagement & Co-ordination with Publisher
• 15% of OLAP processing performance by demonstrating the impact
• Index tuning
• Identifying costly queries to tune & implant bad Joins & Selects
• Cube partitions & Effective application of Aggregations
• Maintaining different infrastructure for OLAP & Mart (Costly though)
• Service Automation (Ex: PowerShell)
• 30% improvement both in Time & Performance compared to Original (Initial friction does require some baby seating though)
• Infrastructure Scaling
• 15% Improvement in Infrastructure by reducing possible redundancy
• Methodologies for Seamless infrastructure migration through Domain & Technical expertise.
• Regular connects with Business, Engineering & Support relating to (Pending, Ongoing & Future releases) that includes bug fixes & feature releases. This happens through Daily Triage, Daily Scrum, Sprint & Iterations
• Service Improvements through the latest technologies (Ex: OnPremises to Azure, Azure resource budget)
• Problem Analysis & Optimization (Through VSO's)
• Planned/Unplanned business continuity exercises & POC's
• Generated Reports using Global Variables, Expressions and Functions for the reports in SQL server reporting services (SSRS) & Power BI.

Confidential, Redmond, WA

Database Engineering, Administrator & Analyst

Responsibilities:

• My job in this project is more than just the Service operations & Release engineer role as I should be an SME in set of applications and participate in Data modeling and Data designing reviews. My role demands extensive project management and release management as a secondary skill while the primary role is still a Service Operations.
• Owning 3 set of applications to support and playing a key role in sharing technical views in team while building or stabilizing the systems.
• Have to play a key role in release management as well to take the authority/responsibility from Service operations before the deployments or major releases.
• Involved in writing scripts and identifying issues by scanning and monitoring the current systems and should go through Automation process to reduce unnecessary human efforts and workarounds.
• Data Analysis, Automation, Service Engineering and Operations, Bug Fix and Feature deployments.

Confidential, Redmond, WA

Database Engineering, Administrator & Analyst

Responsibilities:

• At a higher level, I describe my roles as Service operations having knowledge in service related applications having high visibility in Confidential IT space for handling application related escalations as well.
• Service Operations role in BI-PLATFORMs is to own some set of applications ensuring no downtimes and smooth functionality at any point of time.
• Providing anytime assistance in case of any downtimes or SQL issues for the applications developing or on boarded.
• Scheduled Server patching, Server upgrading, building ‘ N ’ node clustered environments, keeping all the systems updated by testing on the new upgraded versions of SQL & windows server products.
• High visibility monitoring systems are in place to act upon any issues according to the set priorities. At any point of time, operations should be available on-call depending on the criticality of the issues.
• Coordinating with multiple teams like SAP, Non-SAP, Data protection management and Server support teams to get rid of any processing or infrastructure challenges during financial year end period.
• Generated Reports using Global Variables, Expressions and Functions for the reports in
• SQL server reporting services (SSRS).
• Responsible for scheduling the subscription reports with the subscription report wizard in SQL server reporting services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on the financial data for analyzing performance counters using SQL server reporting services (SSRS).

Confidential, Redmond, WA

Database Engineering, Administrator & Analyst

Responsibilities:

• At a higher level, I describe my roles as a Release engineer having knowledge in service related applications and to be involved in Build deployments, Application troubleshooting (POC) & Environment building.
• Since I have a good expertise in T-SQL & IIS administration, my job is not just to act as a senior SQL consultant but also to involve in regular deployments and troubleshooting the application issues.
• Automation using batch & power-shell scripts for reducing manual intervention.
• Since the position being Senior System admin, I should be switching myself from between SQL and IIS while troubleshooting the application issues.
• Used DTS/SSIS to perform the ETL tasks from source to target.
• ETL capabilities of SSIS were used to define imports of the data, build scheduling packages to define integration flow, log data error exceptions and orphaned data and to define Database Maintenance Plans and send emails.
• Migrated Organization, Orders, Adjustments, Objectives and data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Automation using batch & power-shell scripts for reducing manual intervention.
• Schedule and Deploy schema changes, data conversion, data fixes and data movement through packages using SSIS.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all.
• Created SSIS packages to automate database back up, update statistics, re-build the index as well as create error log for every event during data load.
• Import/Export and successfully migrated the Databases such as Mainframes to SQL Server2005 using SSIS.
• Created SSIS packages to integrated window application to DTS and set control file path and timeout value.
• Tuned the database to perform efficiently by managing databases.
• For transferring, used data import and Export utility and BCP command line utility

Confidential

SQL BI Engineering and Administrator

Responsibilities:

• At a higher level, I describe my roles as support analyst who got promoted to senior lead analyst during my tenure in this project.
• Playing a key role as an Incident Coordinator where I have to take care of the complete process along with handling escalations and major incidents.
• Monitoring team activities and application functionality closely to avoid major incidents which will further help in reducing the criticalities during FISCAL year end.
• Automation using batch & power-shell scripts for reducing manual intervention.
• Mostly involved in data distribution using Replications and 3DAPI techniques using Linked servers.
• Involved in the activities like Back up, restoration, log shipping, server patches and server fail over.
• Involved in troubleshooting failed jobs and alerts configured at different servers.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services (SSRS).

Confidential

Software Engineer/Application Developer

Responsibilities:

• Involved in data modeling and designing helping team during the development phase.
• System monitoring, Reporting, Performance tuning. Troubleshooting Stored Procedures (Including CLR).
• Involved in writing the code for some of the modules distributed across the team.