SUMMARY

• BI Engineer/Site Reliability engineer with a demonstrated history in Power BI, Kusto, Automation, Cloud technologies, Database administration.
• Expertise in Business Intelligence Applications (7.8.6 & 7.9.6.3) using Oracle Business Intelligence (OBIEE) in Financial Analytics. Sales Analytics, Service Analytics, HR Analytics, Supply Chain, Marketing Analytics.
• Extensive expertise in ETL using Informatica to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systems.
• Experience in translating user requirements into functional, technical and system specifications, managing clients/vendors/ partners relationships, ensuring service delivery and tracking requests for system enhancements improvements from end - users /customers.
• Handled multiple teams On Shore - Offshore Model managing bigger projects meeting deadlines.
• Expertise in Data Modelling - design, analyse and implement - conceptual, logical, and physical data model, Data conversion, Data integration and Data Mining specialisation in the area of Data Warehouse and Business Intelligence.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository.
• Strong aptitude for learning and understanding business process and needs.

PROFESSIONAL EXPERIENCE

Confidential, REDMOND, WA

Power BI developer

Responsibilities:

• My work involved developing and maintaining Power BI dashboards for worldwide Azure solution assessments team.
• Collaborated with senior management, SMEs to understand business requirements and transform them to functional work items.
• Developed complex calculated measures using DAX.
• Created complex SQL stored procedures, CTE’s to transform the data and to support Power BI reports.
• Designed, developed ETL strategy to populate data from multiple source systems
• Good hands-on creating data factories in ADF, creating pipelines to automate the workflows and refresh PowerBI with latest data.
• Hands on using Scala in Azure data bricks for extraction, transformation and loading data from Azure data lake storage to Azure SQL.
• Address customer and stake holders’ issues and queries on Power BI reports.

Confidential, Redmond, WA

Power BI developer

Responsibilities:

• My work involved creating Power BI reports to monitor and investigate system logs of Azure Compute hardware.
• Helped create different charts and visuals to show volume of different errors and error severity at an aggregate level and help drill down to system event log to help investigate root cause analysis.
• Created complex Kusto queries and functions and used it as an input to create Power BI dashboards.
• Optimized Kusto queries involving millions of rows for better performance and better report refresh.
• Created PowerShell scripts for automate creating json log files from Kusto telemetry data.
• Code fixes to Python based tool to help it generate logs for a newer Sku.
• Created automation to collect json log files from Kusto and parse them through a python-based tool to create summary files.
• Created Paretos to help analyze count of different parameters from the log files.
• Good working knowledge of DAX language.

Confidential, Redmond, WA

Power BI developer

Responsibilities:

• My work involved in providing T2 support for around 21 GDC Power BI reports which are extensively viewed and used by various internal stake holders across Confidential .
• Provide through support and problem resolution for customers.
• Train T1 and T2 team on the processes to be followed and guide them on tickets
• Creating Trouble shooting guides for T1 and T2
• Work on creating and enhancing Power Bi visualization solutions like Dashboards, Standard Reports, Scorecards, charts and AD-hoc Reports.
• Work on validating the data in reports with the data in cube and other data sources
• Make sure refresh jobs are running correctly and data is getting refreshed in reports as per expectations.
• Modifying SQL stored procedures and queries to fix data issues
• Worked in Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel
• Strong Knowledge in dimensional Star Schema and Snowflakes Schema.

Confidential, Redmond, WA

Site RELIABILITY ENGINEER

Responsibilities:

• My work involves supporting different applications which are used right from device deployment to helping users manage their load balancers.
• Planned and implemented moving several SQL and web servers to IAAS for different services in Azure Tools team. This involved capacity planning, VM sizing, performance, cost analysis and networking.
• Develop PowerShell scripts and ARM/JSON templates to automate the provisioning and deployment process.
• Design of production, staging, QA and development Cloud Infrastructures running in 24x7 environments
• Migrating load balancing from GTM to Azure Traffic Manager
• Migrating to Azure Key vault for password management
• Migrating resources from one subscription to another
• Migration subscriptions from one domain to another
• Using Azure storage solutions for managing metric and logs generating from large scale infrastructure
• Automated migrating 100's of html pages of a website to Azure wiki using PowerShell and Python languages
• Deep understanding and working knowledge of PAAS services and Azure Active Directory
• Good working knowledge in Azure AD Connect,
• Set Active Directory (AD) group policies and managed user security for critical Hyper-V hop servers.
• Maintained different Organizational units like user, group and computer accounts and GPO’s in Active Directory (AD)
• Good knowledge in configuring DNS, DHCP on the servers.
• Handled large scale Bare metal servers decommission project
• Worked on creating, improving monitoring, alerting, scaling, and analytics.
• Ensuring systems are highly available by configuring a robust and scalable environment. Load balancing the applications on webserver level and configuring High availability and Disaster Recovery technology including Replication, Mirroring and Always ON.
• SMTP SQL email alerts deprecation and ICM alerting onboarding using PowerShell
• Configuring, deploying and managing large scale production application servers using Autopilot.
• Working on bug fixes and improvements on the legacy applications.
• Worked on analyzing application logs in Azure Data Explorer with Kusto queries
• Hands-on working on deployments using Azure DevOps, Agile methodologies and using GIT to make bug fixes.
• Gained knowledge on building and maintaining Azure VSTS CI CD pipelines.
• Used MS Flow to create VSTS bugs for tracking from customer emails.

Confidential, Redmond, WA

Service engineering

Responsibilities:

• Managing Large scale infrastructure of outlook services.
• Experience in troubleshooting SQL and Web server performance issues and query optimization strategies.
• Participated in BCDR drills.
• Demonstrated experience in handling live site issues and partner bridge calls by engaging the right teams.
• Demonstrated experience working with Engineering teams to identify repair items and do RCA analysis.
• Experience in identifying telemetry, monitoring gaps, and creating actionable ICM alerts.
• Migrated legacy monitoring and alerting to newer and advanced monitoring systems like Geneva, Xpert and ICM ensuring the teams align with Confidential ’s Cloud policies.
• Automated creating bulk alerts in Xpert from templates using PowerShell
• Interacting with networking teams and setting up required acl’s for services.
• Proactively monitor and investigate Production Issues as a part of Incident management.
• Operations application support includes supporting front end and backend of MSN contact services.
• Monitoring the telemetry of top Incoming and Outgoing API’s in Xpert tool and proactively working on improvements.
• Deploying code on a frequent basis on preprod and prod environments using AutoPilot tool and XTS tool.
• Worked on creating TSG's on fixing live site issues. Created additional monitoring to identify service disruptions.
• Handled high availability configurations like AlwaysOn and Mirroring.
• Rebuilding / Monitoring the indexes at regular intervals for better performance.
• Ensured that all sql databases have full backups, tlogs backup jobs running successfully.
• Worked on regular admin tasks like network issues, Access control lists, network shares and open shares.
• Given KT sessions to team mates on the new tools and worked closely with offshore and onsite.
• Identify repetitive manual tasks and automate them using PowerShell like deployments, managing shares on servers, disk space issues,

Confidential, REDMOND, WA

Service engineering\service operations

Responsibilities:

• Line 3 operations application support includes delivering key application support.
• Worked on supporting Nova which is the data storage and analytics solution for big operational data generated by millions of devices in GFS-managed data centers all over the globe.
• Worked on Azure subscriptions managing blobs, storage, Azure DB, service bus.
• Versed with BulkInsert commands to copy data from databases to tables as per customer requests.
• Worked on supporting tool which collects performance counter data from machines used in teams all over GFS domain. Managing content which is generated by Cosmos queries which collect the data from Lync and AutoPilot machines.
• Worked on Cosmos queries, HDM site clusters and LinQpad.
• Configuring and troubleshooting SQL jobs for monitoring the application.
• Worked on creating SCOM monitoring.
• Worked on creating PowerShell scripts to automate and monitoring.
• Interacted with customers to resolve critical application issues.
• Resolve tickets as per the given SLAs.
• Proactively identify areas for improvement and perform change management activities (standard production changes to new architecture deployments),
• Worked on resolving cube and warehouse related issues.
• Documented key issues and circulated to the team for future reference.
• Worked on Visual Studio for tracking and monitoring work items and source code check-in’s

Confidential, REDMOND, WA

Service engineering\service operations

Responsibilities:

• Deploying web and sql builds and patches in Development, Test, UAT and Prod environments.
• Good experience in using Octopus and In Release tools for deployments.
• Implemented IAAS as service
• Understanding the functionality of Internal Applications and working on trouble shooting issues.
• Installing SQL server and setting up Always on and Availability Groups
• Working on DB activities like fixing drive space issues, shrinking log files, taking backups and restoring.
• Experience in configuring and troubleshooting Windows failover clusters.
• Managed multiple web applications by configuring multiple IPs, Host headers and port numbers
• Experience in configuring and troubleshooting SQL jobs.
• Experience in trouble shooting IIS issues.
• Experience in working with load balancing, adding and removing nodes from my VIPs.
• Experience working with configuring IIS certificates.
• Experience working on ASA scans and fixing issues.
• Tracking tickets in Visual Studio and Bugger tool.
• Installed software, patching, upgrading and maintenance of operating system.
• Configured SQL - Database connectivity parameters in the web.config and by using ODBC settings.
• Attended sync up calls with the team to discuss the status of the issues raised

Confidential, REDMOND, WA

Service engineering\SQLSERVER DBA

Responsibilities:

• Performed key role in SharePoint site Migrations from on-premises to O-365.
• Tested different tools and technologies for successful migration site content like Quest, Meta vise, Prime and Kemon.
• Copied site content from intranet to extranet using MS-Deploy, ROBOCOPY Tools. Used Azure blob storage and used AZ commands to copy the data quickly.
• Team followed Agile methodology and regular Scrum meetings to ensure meeting timelines.
• Worked closely with customers and resolved issues related to Migrations on time.
• Huge scale data migration involved planning the work effectively and collaborating with customers worldwide.
• Created SharePoint sites, lists, shared documents, users, owners, and web parts for effective testing.
• Used PowerShell to query the grid manager and automated tasks.
• Created Excel VB scripts to automate time taking tasks.
• Running deployments and other maintenance activities across servers belonging to datacenters located in different regions.
• Regular database activities like Data file Shrinks, Log file Shrinks, Database splits, VLF count reduction and Database moves, fixing space issues in sql servers.
• Creating PowerShell scripts for activities like finding drive spaces across all the servers,
• Implementing Clustered and Non-Clustered Indexeson data structures.
• Experience in using tools like Database Engine Tuning Advisor,SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Troubleshooting database Mirroring issues.
• Provided 24x7 support for Production environment.

Confidential

ETL/SQL SERVER DBA

Responsibilities:

• Understanding the Requirement Specifications documents, Creating Test Plan, Test Strategy, Test Estimates and Release Management documents.
• Writing complex SQL queries for validating the data covering all kinds of data validation checks to ensure that data is not having duplicates, null invalid or erroneous data and creating queries for report data.
• Testing the data which is loaded from pipeline files to the different layers of warehouse like Staging, Dimension and Fact.
• Checking log files and bad files in Unix operating system.
• Creating stored procedures which will analyze the trends of daily records count on a 2-sigma level.
• Automating the testing by creating stored procedures containing these test cases and so that they can be run daily.
• Deploying QA code in Perforce.
• Performance Analysis and Query Optimization.
• Reporting the bugs in Bug base and got them resolved in time.
• Followed V-Model test methodology.
• UI Testing of the reports by checking columns labels, drop down lists, links, graph format, fonts etc.
• Analyzed the graphs and trends and reported of any anomalous issues.
• Performance testing of OBIEE reports.

Confidential

ETL/SENIOR TEST ENGINEER

Responsibilities:

• Studied the System Requirements document and sorted out in scope and out of scope requirements.
• Organized review meeting with Developers and Designer and finalized the requirements which can be tested in ST Environment.
• Preparation of Test Plan Document, Test cases in Quality Centre and Requirements Traceability Mapping Document in QC.
• Communication with Environment Team and got the Credentials for the related Databases and UNIX environment.
• Preparation and execution of test cases.
• Ran ETL Ab-initio scripts in UNIX environment into database tables.
• Extracted and loaded the data into Artemis database and EDW database (TERA DATA or P-CARD).
• Verified the data loaded with the help of Data mapping Documents.
• Developed a good knowledge on the Software Life Cycle.
• Written Quality Gate Test Completion Report