SUMMARY

• 12 years of experience in IT, including Business Analysis, Program Management, Development, System Analysis and Operations Support. Proficient in analyzing, understanding and creating Business Requirement Documents, System Requirement Specifications (SRS) and Use Cases. Experienced in creating detailed Test Scenarios and Test Cases. Having expertise in Waterfall & Agile Software Development, Software product engineering and High Availability Database systems.
• Having 12 years of experience in IT, including Development and Business Analyst, Program management. Skilled in implementation of business practices such as Benchmarking, Business Process Re - engineering (BPR), Business Process streamlining, Process optimization, Process mapping, and Operations analysis.
• Proficient in creating Use Case Diagrams, Work Flows, Activity Diagrams, and Wire frames.
• Exceptional technical, business, and people skills to build relationships across teams and halp facilitate Solutions to blocking Engineering problems.
• Coordinated with business, development, and testing teams and leverages relevant process and technology proficiency to propose optimal solution(s) options delivering required business capabilities.
• Proactively identified and TEMPeffectively assesses improvement opportunities (productivity/efficiency gains, cost savings, etc.)
• Utilized agile delivery methodologies and participates on scrum teams in execution of solution delivery projects.
• Strong understanding of Confidential Active Directory & related technologies (DNS, Group Policies, etc.). Knowledge of Network Protocols (TCP/IP) and port usage.
• Resolve network related issues. Setup Hardware load balance and ensuring High availability services.
• Worked with Engineering to develop Organization wide cross platform Deployment and Release Framework.
• Collaborated with development team in agile design/development of custom solution components. Performs code reviews as required.
• Provided Supports solution testing efforts by developing test plans, prepared test environments, performed test execution, and validate test results.
• Provide consulting expertise in design and development of full-scale BizTalk implementations utilizing ESB software model implementing communication between mutually interacting software applications in a service-oriented architecture (SOA).
• Expert Knowledge of Transact SQL (T-SQL), Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Created policies, best practices and guidelines for Software Release and Change Management, On Cloud Adoption across the Organization
• Demonstrable experience in System, Functionality, Positive, Negative, Security, Integration and User Acceptance Testing, Regression Testing, Load Testing, Stress Testing and Volume Testing.
• Support the implementation and roll out of the finalized product. Identify production issues and recommendation issues.

TECHNICAL SKILLS

• MS Office Suite 2013, Visual Studio Team foundation Server 2012
• Postgres, mysql, Oracle, SQL Server, PowerShell
• Visual Studio 2017, TFS, Windows Azure, MS SQL Server 2014-2008, SSRS- SSIS, Data Profiling, SQL Profiler, Perfmon, VM Ware Virtual Machines, Mercury Test Director
• Visual studio 2017/2013/2010/2008, Visual Source Safe, Windows Server, Active Directory, IIS, Clustering, Azure, PowerShell, Hyper-V, Network technologies, NLB, DNS, SCOM.
• Agile Software Development, Software Testing Methodologies, Object Oriented Analysis & Design.
• BizTalk 2016/2010/2009/2006 R2/2006
• EDI Transactions 270,271,276, 278, 810,820,824, 834, 835, 837, 850, 855,927, 940, 997 Versions (4010, 5010)
• SDLC, Waterfall, Agile, Scrum, Software Testing Methodologies.

PROFESSIONAL EXPERIENCE

Technical Program Manager

Confidential

Responsibilities:

• Closely worked with the Subject Matter Experts (SMEs) to understand and document the key drawbacks in the current risk management system.
• Managed new information technology documentation design and development strategies, while actively leading documentation tools and processes fortechnicalwriting groups in multiple geographic locations.
• Collaborate with technology and business leadership on annual strategic planning for the program.
• Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
• Assisted in User Acceptance testing (UAT) and halped user select and write cases for UAT.
• Leadership for team that played key role in reducing escalation volume by > 80% and reduced Invalid Escalation volume from over 30% to less TEMPthan 5%; resulting in Customer Service and Support Outstanding Team Award.
• Designed an Internal SharePoint for the Intake Quality Team to standardize data collection, feedback, and reporting.
• Coordinated day to day productivity, reporting, and staffing for team of up to 60 escalation agents supporting Confidential Xbox services as the Xbox Live Case Administrator
• Developed internal team reporting and case management processes.
• Refined training process reduced amount of time required before New Agents can TEMPeffectively assist customers.
• Created and improved troubleshooting steps for Tier 1 to improve first-call resolutions for customers.
• Gathered requirements and halped with Content Management and UI design.
• Planned Disaster Recovery mechanisms in place across all the systems (DEV, SIT, UAT &PRODUCTION) and responsible in driving the implementations of recovery exercises accordingly (planned & Unplanned) in a year.
• Delivered multiple migration within timelines. Review the Technical, function specification documents
• Performed analysis to measure performance and identify efficiency opportunities and develop and maintain business rules for functions and processes.
• Coordinated and facilitated extensive interviews and workshops with user, manager and product owner to gather and analyze requirements and create themes, epics and user stories.
• Created Training Manual for the enhanced Risk Management System for the End-Users and Stakeholders.
• Implemented standards and procedures to streamline writing processes; participated in strategic planning initiatives for product documentation.

DevOps Engineer

Confidential

Responsibilities:

• Developed, tested, deployed Active and Passive runners proactively to capture various infrastructure and hardware related issues like
• No compute Availability, Storage unavailability, memory unavailability and send alerts.
• Developed, tested, deployed reporting tool to show High Availability Servers provisioning such as create or drop servers and Login
• failures due to system crashes, load balancing, Update Slow etc.
• Decommissioning of IAAS servers usingAzurePortal or PowerShell. Add/Remove Storage Disks forAzureVMs.
• Implemented high availability withAzureClassic andAzureResource Manager deployment models.
• Ownership of Buildout deployments on Production servers including monitoring and testing.
• CI / CD setup monitor day-to-day builds deployments. Make changes to the definition as needed.
• Analyze the crash dumps, Debug System\User Failures for RCA and fix them in sprint plan.
• Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.
• Responsible to Configuring and managing Virtual Machines, Storage, network and applications using WindowsAzureportal.
• Plan and coordinate the administration of PostgreSQL databases to ensure accurate, appropriate, and TEMPeffective use of data, including database definition, structure, documentation, long-range requirements, and operational guidelines.
• Expertise in trouble shooting the database performance issues along the with query optimization.
• On Call support to customer\runner, incidents halping SE team with Kusto queries, scripts for triage.
• Built Perf & Stress environment to kick off runs after successful CI Runs.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Created different types of Tabular reports like Cascaded Parameters, Drill through, Drilldown, sub-reports and Matrix reports and developed some graphical reports using Report Designer.
• Query Optimization for the better performance of theMySQLserver.
• Set up slave servers for reporting purposes.
• Trouble shooting and tuningmysqlparameters for better performance.
• Migratedmysqlmulti instances into new server hardware.
• Optimizing queries with EXPLAIN andMySQLQuery Optimizer.

Test Engineer/ Business Analyst

Confidential

Responsibilities:

• Acted as a primary point of contact for issue escalation related to Digital Operations and OED business channel issues.
• Managed a team of 3-5 testers to complete deliverables related to testing. (Requirements analysis, Test Case writing, and Test Case execution)
• Engaged in communication and collaboration between external and internal teams for the purposes of analyzing and understanding the complexities of internal systems in End-to-End testing
• Coordinated the planning and execution of all User Acceptance Testing (UAT) related to the OED and Digital Operations Channels.
• Ensured all active and resolved defects are regressed and closed/reactivated in a timely manner and aligned with business objectives
• Attended regular project meetings to identify the scope of required test efforts for the Transactional Phase and run rate post go-live
• Created and maintained test documentation, PnP's and training material.
• Updated and executed scripts, data sets and other programmatic test tools as required for executing test plans.
• Engaged communication between external and internal teams for the purposes of understanding the complexities of internal systems in End-to-End testing
• Managed the requirements and developed a Traceability matrix
• Support UAT for scorecards liaising directly with Confidential business groups (OEM, Windows, STB,EPG,SMSG, Marketing, CCG, Licensing, Subsidiary, MYR, Services)
• Working as first point of contact to business for all production issues and queries.
• Analyzing and providing solutions for high priority & critical production issues related to Excel scorecards and web FY13 ROB, STB & MYR scorecards hosted on SharePoint based issues tracker tool.
• Test & Develop change requests (CR) raised in Score builder tool related to user interface of scorecards in UAT and production environment.
• Working on SharePoint platform to Develop, edit and test Scorecards. Edit the web parts on to make the required changes for Scorecards.
• Sending status reports daily to managers and team members. Attending daily/weekly status meetings and participating in it.
• Use Visual studio team foundation for keeping & updating Scorecards, Documents to maintain the version history.
• Working with SQL queries to update, delete & insert data in tables. Run Store procedure to update table data on demand.

Senior EDI Support Engineer

Confidential

Responsibilities:

• Developed mapping guides for all the suppliers.
• Coordinate end to end implementation and testing of new business processes and scheduling with customers.
• Created and documented EDI business process requirements.
• Monitor the flow of data through EDI applications to ensure all operational systems are functioning properly when needed.
• Developed ANSI X12 transactions like 834, 835. 837, 270, 271, 276, 277, 997.
• Worked with various Services and Adapters to develop/modify and test Business Processes in SI 5.2.
• Migrated MS SQL Server table data from SQL Server 2005 to 2008R2 and migrate SI objects like Business Processes, Maps, Envelopes, AS2 partner setups from GIS to SI
• Developed SQL scripts (queries, stored procedures) in MS SQL server 2008 R2/ 2008.
• Worked with communication channels like SFTP and FTP.
• Created Monitor business processes for AS2 send/receive errors.
• Primary On Call support personnel on 24/7 basis.

BizTalk Consultant

Confidential

Responsibilities

• Involved in Requirement, Design and Development of the application.
• Develop BizTalk Orchestrations, Maps, and Pipeline. Developed Custom Pipeline for CSV file.
• Create stored procedure to retrieve data from Data mart & Developed WCF service to return data to BizTalk server for transformation.
• Create BizTalk maps for EDI/ XML/ Flat file transformations using advanced functoids, including Inline
• Involved in end to end system and integration testing.Used BizTalk deployment framework for deployment packages.Used TFS 2010 for build and MSI with bindings.
• Involved in end to end system and integration testing.Used BizTalk deployment framework for deployment packages.Configured EDI Party in BizTalk Admin Console and created an agreement for both inbound &outbound transaction.Migration of Servers and SQL 2000/2005/2008 Database platforms across Data Centers
• Index Tuning and Optimization, Troubleshooting performance bottleneck. Manage Database files and disk space
• Assisted Dev team in Design Reviews, Review of deployment documents and planning
• Automation writing SQL scripts and Stored Procedures. Data Operations, SSIS, SSRS Reports
• Managing DRBC Backups and Restore of Databases, Assigning Database Roles
• Installing Oracle database servers and web servers using Oracle 9I. Installation of new servers using OS like win 2003, Win XP
• Writing and running Automation tool scripts using tool like QTP, Win Runner, and Silk. Creating Bugs using PVCS tracker and tracking till resolved.
• Understanding use cases and functional requirement documents. Test plan creation, defining scope, providing estimates.
• Preparing test case scenarios, data set. Writing and executing test cases. Test cases review.
• Defect reporting using defect tracking tool Bugzilla. Defect disposition report generation.
• Manage team of 2 test engineers. Review work carried out by team members.
• Weekly QE status report preparation.