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 teh 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 noledge 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 noledge & understanding on Hadoop framework

TECHNICAL SKILLS

• 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,
• Tools & Technologies worked: Azure Technologies, Azure Operations Manager suite, Azure Application insights, IIS (7.0) administration, Microsoft Precise, GTM Load balancing, AppFabric caching, NetScaler Load balancing, Content Switching & Akamai, Biztalk Server 2006, My SQL, Gentran Server and a basic noledge 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,
• Microsoft Tools & Utilities: Visual Studio.Net, Microsoft SCOM, Windows TFS (Bug tracking and Source Safe Server) and Eclipse,
• Domain Knowledge: eCommerce, Integration services, Finance, Supply chain management and Change release management,
• Called by name Teh Real Geek for being able to pin point SQL Server feature issues.
• Recognition for being Innovative, productive and goal oriented resource.
• Proven to lead a team of >5 in teh early days of my career as me got appreciated with a title called “Young Leader”.
• Grown as a Technical analyst from Developer within 3 years since me started my career.
• “Key Associate” in our project for teh year 2009.
• Identified as SME and a most valuable resource in our project.

PROFESSIONAL EXPERIENCE

Service Engineering and Operations,

Confidential, Redmond, WA,

Responsibilities:

• SESIT-BI is a key portfolio in teh space of Microsoft's revenue hosting highly critical applications in Microsoft.
• Feedstore Azure, DPL & Power-BI are some of teh applications in BI space and these does teh functionality of generating Sales, Finance and revenue reports.
• Building & Administering ‘ N ’ node clustered environments.
• Feedstore Azure is teh central database repository application which maintains all teh Microsoft's revenue related data and it behaves as upstream for all teh other applications who uses teh data according to their requirements, DPL is an application which consumes all teh revenue related data from different publishers and it acts as a DataMart server which serves as a publisher to all teh downstream systems
• In terms of Service Health (such as, OLTP System Tuning, Data Freshness SLA's, Data Analysis & Telemetry). Not too far from teh day me took charge, have shown a significant difference in Data processing & SLA metrics.
• 20% improvement in job processing time than teh Original.
• Analyzed Disk me/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 teh Real Business need (Less volumes - fast processing)
• 12 out of 42 datasets are permanently out of SLA breach (30% Improvement)
• While teh 20% improvement in Job processing time TEMPhas impacted teh SLA's, teh remaining 10% does required teh right engagement & Co-ordination with Publisher
• 15% of OLAP processing performance by demonstrating teh impact,
• Identifying costly queries to tune & implant bad Joins & Selects
• Cube partitions & TEMPEffective 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)

Example: Server Patching (UAT vs PROD), File share monitoring, OMS, Server Deployments, Self-healing through Alert responses using run book.

Service Engineering and Operations,

Confidential, Redmond, WA,

Responsibilities:

• Outbound royalties is a key property in CFIT where it got a separate release and project management methodology along with Agile since teh applications in it are holding very securable and confidential policies.
• Data flow from up streams like Xbox and Windows Phone etc., via SQL Azure is received and processed to store teh data on On-Premise databases.
• Processed data will tan be used as a warehouse and delivers data to reporting servers/distribution servers for teh down streams to view Month End, Quarter End and Year End reports.
• End users are always teh business and big officials from finance and revenue teams.
• Data flow statistics and metrics will be reviewed using SQL Reports and submitted to SOX auditing.
• My job in this project is more than just teh Service operations & Release engineer role as me 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 teh 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 teh systems.
• Have to play a key role in release management as well to take teh authority/responsibility from Service operations before teh deployments or major releases.
• Involved in writing scripts and identifying issues by scanning and monitoring teh 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.

Administrator & Analyst,

Microsoft, Redmond, WA,

Responsibilities:

• BI-PLATFORM is a key portfolio in teh space of microsoft's revenue hosting highly critical applications in microsoft.
• Feedstore, EDW, Cosco, CBI, MSCloud, Velocity, MDM, BI-Sales and BI-Finance are few of teh applications in BI space and these does teh functionality of generating Sales, Finance and revenue reports.
• Feedstore is teh central database repository application which maintains all teh microsoft's revenue related data and it behaves as upstream for all teh other applications who uses teh data according to their requirements, MSCloud is an application which consumes cloud related data from different publishers and it acts as a datamart server where teh data is distributed to multiple middle ware servers for teh availability of customers who uses MSRA and EBI worker as teh user interfaces to view MSCloud revenue reports
• At a higher level, me describe my roles as Service operations having noledge in service related applications having high visibility in Microsoft 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 teh applications developing or on boarded.
• Scheduled Server patching, Server upgrading, building ‘ N ’ node clustered environments, keeping all teh systems updated by testing on teh new upgraded versions of SQL & windows server products.
• High visibility monitoring systems are in place to act upon any issues according to teh set priorities. At any point of time, operations should be available on-call depending on teh criticality of teh 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 teh reports in
• SQL server reporting services (SSRS).
• Responsible for scheduling teh subscription reports with teh subscription report wizard in SQL server reporting services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on teh financial data for analyzing performance counters using SQL server reporting services (SSRS).

Service Engineering and Operations,

Confidential, Redmond, WA

Responsibilities:

• At a higher level, me describe my roles as a Release engineer having noledge in service related applications and to be involved in Build deployments, Application troubleshooting (POC) & Environment building.
• Since me 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 teh application issues.
• Automation using batch & power-shell scripts for reducing manual intervention.
• Since teh position being Senior System admin, me should be switching myself from between SQL and IIS while troubleshooting teh application issues.
• Used DTS/SSIS to perform teh ETL tasks from source to target.
• ETL capabilities of SSIS were used to define imports of teh 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 teh 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 teh index as well as create error log for every event during data load.
• Import/Export and successfully migrated teh 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 teh database to perform efficiently by managing databases.
• For transferring, used data import and Export utility and BCP command line utility

SQL BI Engineering and Administrator,

Microsoft,

Responsibilities:

• At a higher level, me 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 me have to take care of teh complete process along with handling escalations and major incidents.
• Monitoring team activities and application functionality closely to avoid major incidents which will further halp in reducing teh 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 teh 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 teh data using SSIS from OLTP to OLAP.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services (SSRS).

Software Engineer/Application Developer,

Confidential, USA

Responsibilities:

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

Software Engineer/Application Developer,

Confidential,

Responsibilities:

• Involved in data modeling and designing halping team during teh development phase.
• System monitoring, Reporting, Performance tuning. Troubleshooting Stored Procedures (Incl., Confidential ).
• Involved in writing teh code for some of teh modules distributed across teh team.

Software Engineer/Application Developer,

Confidential,

, Responsibilities:

• Involved in data modeling and designing halping team during teh development phase.
• System monitoring, Reporting, Performance tuning. Troubleshooting Stored Procedures (Including Confidential ).
• Implementing CSV Importing wizard both in .Net (Server Side Confidential ) and JavaScript (Client Side Confidential )
• Developed Admin Panel.

Software Engineer/Application Developer,

Confidential,

Responsibilities:

• Involved in data modeling and designing halping team during teh development phase.
• System monitoring, Reporting, Performance tuning. Troubleshooting Stored Procedures (Including Confidential ).
• Participated in analysis phase of e-commerce integration.
• Involved in implementing teh payment gateway process.
• Developed teh keyword parser using Handlers. Designed teh configuration of redirecting teh URL’s.
• Database designing, querying and Stored Procedures.