Sachin Rana

Cell: 425-***-****) Email: acrqlp@r.postjobfree.com

Infrastructure Architect, Operations Support and Release Manager

Skills

Language

MS SQL, C# .Net, PowerShell, HTML, Java Script

Tools

Visual Studio, TFS 2013, Git, Windows Azure, Azure Management Studio, Dynamic CRM, Splunk, Zen Desk, JIRA, SCOM-SCCM 2012, Infor Epiphany 7.2.2 EM-OM, EMC SAN Replication Manager, Perfmon, VMWare Virtual Machines- Test Labs, FileNet IDM, Report Manager, Rational Performance Tester, Web Load 7.0, Mercury Test Director

Big Data/RDBMS

Cosmos- Big Data, MS SQL Server 2014-2008, SSRS Reports, SSIS, Data Profiling, SQL Profiler, SQL High Availability, Replication, Mirroring, Log Shipping

Whitepaper

Certification

Methodologies

Written Whitepaper on “Adopting Virtualization for cost effective Test Management” published by HCL Technologies Ltd

Certificate in Software Engineering from QAI USA, Roger S Pressman

Six Sigma Yellow belt Training, CMM process compliance

Agile Software Development, Software Testing Methodologies, OOAD

Summary

Seasoned Infrastructure and Operations Architect with 10 years of E2E experience in leading Cloud Enterprise BI Solutions, Release Management, Release Readiness, Builds and Deployment Strategies, Planning, Implementation, Operations and E2E Support structure, DRBC and Business Continuity Plans. Successfully delivered mission critical e-Commerce web applications, High Availability data driven worldwide Cloud based application systems, Win 8 Modern Apps- App Portals and BI Solutions in an Agile development environment.

Ensuring application engineering adhere to the Enterprise Governance Risk and Compliance (Organizational IT Security Standards and best practices), including ITIL standards. Defined practices for PII, HBI and Sensitive customer data, Information Privacy. Rich exposure in ISO, CMM and Configuration Control as a Product Quality Analyst, Configuration Management, process improvement. Established System KPI, benchmarks. Achieving Operational Compliance of all Production processes within established SLA.

Highlights:

Exceptional technical, business, and people skills to build relationships across teams and help facilitate Solutions to blocking Engineering problems

Worked in Software Asset Management, E-commerce, Online Services Ad Display, Enterprise Content Management, Insurance Domains and RFID, Smart Cards and Bio-Metric devices

Worked with Engineering to develop organization wide Deployment and Release Framework. Establish Software Release and Change Control Process, Create Continuous Integration Build Platforms, Release Plans, guidelines, Deployment Strategy. Ensure organization wide Audit and compliance

Define Implemented policies, best practices and guidelines for Software Release Change Management, Cloud Adoption across the Organization, Instrumentation, Monitoring, Alerting

Plan, Design and Architect Infrastructure, Operational and Support requirements for complex High Availability Distributed Systems, Databases and SAN Infrastructure

Project environments are allocated/Re Deployed efficiently across Engineering and other teams

Ensure processes, Environmental and Software boundaries including Third party are being followed

Work with Engineering and Solution Architect, provide feedback, Identify Design, Implementation, System limitations and bottlenecks.

Implement High Availability Distributed Systems and Databases

Define Business level SLA and Operation SLA. Adhere to ITIL best practices and guidelines

Implement Incident and Escalation Management process, minimizing downtime and Business Impact

Create Request for Proposal (RFP) for Enterprise application support and Infrastructure procurement

TFS Administrator for Builds, Release Management. Product Delivery/ Release Reports

Identifying issues with existing processes, deploy effective and efficient Production systems

Out-standing ability to adapt to new and fast paced project environments quickly

Work Experience

Inviso Corporation, Bellevue, WA Duration: 17 Sep 2012 – Present

Project: SAM Partner WorkSpace

Role: Infrastructure Architect, Operations Support and Release Manager

Client: Microsoft Corp, Redmond

Overview: Workspace is a Worldwide Cloud based application system for Microsoft license assessment and planning process. Securely collect, process and stores customer license inventory data using Azure Cloud Services.

Responsibilities & Achievements:

Design and Architect Infrastructure needs both on Premise and On Cloud

Ensure Solution is developed per Enterprise Governance Risk and Compliance ITSM. Took ownership of critical business systems and engaging relationships with key business stakeholders

Defining, Implementing Security requirements, Audit and Privacy Compliance of PII, HBI and Sensitive data. Successful ITSM and Compliance approvals for World Wide web based application system

Work with Legal and Security Champions to ensure EULA requirements, Production worthiness of the application system in an Agile Development cycle. Ensuring critical project deadlines are met

Define guidelines and implemented process for Data handling, data access to and from upstream-downstream systems. Mitigated User concerns from Europe and other geo’s

Release Management- defining the Build criteria, Definitions, Release Readiness and Deployment practices and tools. Participating in Release Approval Go-No-Go meetings, flag Risks to Business. Ensured on time Releases and Deployments from V1 to V2 Production Releases

Identify and Implement Business Roadmap. Establish requirements for Infrastructure, Operations and Support – Ticketing System, SCOM and other Tools and Processes. Created Feedback loop from Operations and Support to Business and Engineering, help flag Areas of High Risk and Impact. Driving Customer satisfaction experience

Implemented E2E Support Structure Tiers, Hire, Ramp up Team with excellent Customer Reviews

Proposed simple and efficient solutions to complex business, engineering, Production Issues

Implement Dual Authentication for Corp Federated and Microsoft Account users. First project to do so

Project: Data Management Platform(DMP)

Role: Infrastructure Architect, Operations Support and Continuous Delivery Release Management

Client: Microsoft Corp, Redmond

Overview: DMP is a Backend data processing pipeline for Office 365 customer data. Acquires and processes data across data sources (SQL Server, Cloud, REST API, Cosmos Big Data store). The data is acquired, processed using Data transfer utilities on Cosmos Big Data platform. Sending Event based Marketing campaign emails.

Responsibilities & Achievements:

Built and Deployed Data Collectors, Data Transfer Utilities, Rest API Services.

Architected Infrastructure Roadmap, planning and budgeting for on Premise, Cloud/ Cosmos Platform

Build system Infrastructure for High Availability, DRBC. Data Custodian for the entire Infrastructure and Application system

Established framework for Continuous Builds, Integration, Deployment and Release. Established Deployment Platform and Strategy, Change Control, Release Approval process and tools

Define requirements and Ensure Solution developed as per Enterprise Governance Risk and Compliance

Worked with Data Source Owners, Define and Enforced Security, Audit and Privacy Compliance of PII, HBI and Sensitive data. Minimizing Data Privacy and compliance risks

Setting up Operational and Support Infrastructure – Achieved uniform Ticketing System, SCCM and SCOM for Instrumentation, Monitoring and Alerting

Unblocked Engineering by collaborating and creating working relationships

Played Central role in Resolving cross team conflicts and priorities within Operations team

Won Star Achiever and Outstanding Contribution team awards

Project: Windows Apportal (Generator, Viewer) & Sales Productivity Solution

Role: Operations Support and Release Manager

Client: Microsoft Corp, Redmond

Overview: Development of Window Apportal Prototype Generator and Apportal Prototype Viewer. Prototype generator creates a demo Apportal, aggregates data from diverse sources and displays the data in a Windows 8.1 Hub view through Hub screen, Groups, Tiles, Embedded Apps, Report views and deep linking.

Responsibilities & Achievements:

Identified Hosting Solution, Publishing and distribution process for Enterprise Windows Modern Apps. First to Design and build Windows Apportal for Enterprise BI Sales and Marketing teams

Code Signing of Line Of Business app and establish Partner distribution channel

Define ITSM requirements, Ensure Solution developed as per Enterprise Governance and Compliance

Setting up Operations and Deployment Framework using System Center Configuration Manager

Defining the Release criteria, Builds, Release Readiness and Deployment platform and publishing tools. Identified and overcome challenges with Enterprise -Partner distribution and publishing platform.

Epi Pro LLC, Redmond USA Duration: 21 Mar, 2011 – Sep 2012

Project: Microsoft Commerce BI, Microsoft Ad Display Operations

Role: SQL Server DBA, Service Engineer- Epiphany EM/OM Administration, Release Management

Client: Microsoft Corp, Redmond

Overview: Managing Mission critical E-commerce OLTP system. Maintain Large Scale and High Availability SQL Servers and EPNY CRM EM/OM system. Collect and process Terabytes of Data on Cosmos Big Data. Update Privacy Data for over 2.5 Billion users. Sending Event Based Marketing Email Campaigns

Responsibilities & Achievements:

Collect, Process 100 TB of data in Cosmos-Big Data. Achieved 96% processing time

Responsible for SQL Server Database Administration. Maintaining Replication and SQL Cluster Environments. Achieved optimal performance and benchmarks

Managing OLTP Backend system, ensuring key transaction thresholds are maintained

Responsible for Administration of Epiphany CRM and Operations. Achieved sending 300 M + emails

Maintaining and monitoring SCOM, Production security compliance, minimizing downtime. Ensured Application Security compliance within high 90%

SQL Server Performance and Index tuning and bottlenecks. Mitigated End user Performance issues.

Streamlined database file growth issues in UAT/INT/PROD. Reducing Alerts and SAN disk issues

Migration of Servers and SQL Server Databases across Data Centers. Established DRBC platform

Assisted Dev team in Design Reviews, Review of deployment documents and planning

Automation writing SQL scripts and Stored Procedures. Data Operations, SSIS, SSRS Reports

HCL Technologies America Inc Duration: Oct, 2006 – 18 Mar 2011

Projects: Microsoft AD Centre, MSN Display Ops, MIO-RXD, IBM- File Net IDM Suite/ACENZA

Roles: Technical Lead DBA at Onsite, Data Quality Analyst team. Test Lead- PQA and Quality Control

Client: Microsoft Corp, Redmond, FileNet Corp, IBM

Overview: FileNet application suite is an Enterprise Content Management Product - packaged business process management solution that uses workflow, document capture, and document management capabilities.

Responsibilities & Activities:

Coordinating in-process reviews, internal project audits. Identifying process improvements and standards for key practices in software engineering, testing and release management

Release Management, Risk Management. Estimation, Planning and Schedule Management

QA owner of the Project. Understanding Customer Requirements, Regression and Test planning

Managing End to end Release Cycle, Estimates. Report preparation and HFP delivery

SQL DBA, Index Tuning and Performance Optimization. Maintaining Database files and disk space

Onsite/Offshore Coordination, team Mentoring. Defect Management with Global Development Teams

Conducting In process reviews, Design Spec Reviews, Test Spec and Deployment reviews/improvements

Education

Bachelors of Software Engineering. GGS IP University, New Delhi, India

Contact this candidate