Sandeep Penugonda Contact No: 903-***-****, 998-***-****

Email ID: adh93b@r.postjobfree.com

Summary:

Scrum Master/Project Manager (Save Nova Technologies – Mar,2020 to present)

Having 3.5 years of experience as ScrumMaster and below are my responsibilities

Own the Release Management lifecycle which includes scheduling, coordinating and the management of releases across the project for multiple applications

Used to interface and communicate with Test Managers, Dev Managers, IT Ops and off-course the PO on daily basis and at times provide updates to Senior IT Management like CIO & CTO as well as Business management

Plan release windows and cycles across a portfolio

Manage risks and resolves issues that affect release scope, schedule and quality

Measure and monitor progress to ensure application releases are delivered on time and MVP is achieved

Communicate all key project plans, commitments, and changes including requirements, QA plans, schedule, and scope changes to the team

Manage relationships and coordinate work between different teams at different locations

Conduct Release Readiness reviews, Milestone Reviews, and Business Go/No-Go reviews

Weekly Release Reporting

Communicate release details and schedules to the Business as required

Negotiate, plan and manage all release activities

Maintains the release schedule for all core services and ensure alignment across key partners and vendors.

Continually work towards making improvements in the release process

Participate in CAB meetings to discuss release scope and/or roadblocks

Maintains a release repository and manages key information such as build and release procedures, dependencies, and notification lists

Scrum Master/ETL Developer - Associate-2 (StateStreet Corporation)

Had around 3 years of Experience as Scrum master

Used to lead daily stand-ups and scrum ceremonies for our team

Used to work with Product Owner to groom the backlog and plan sprints

Collaborated with members like PO, Business and Engineering teams to develop and maintain Product backlogs

Used to track, escalate and remove impediments and report at daily Scrum

Used to track burn-down, issues and progress in RTC and worked with component teams to resolve issues

Improved team velocity by incorporating capacity planning into sprint planning sessions

Implemented issues tracking in RTC to effectively track impediments against user stories

Quickly became the recognized scrum master expert within organization

ETL developer experience (StateStreet Corporation)

About 5 years of Experience as ETL developer in tools like Netezza, Sybase, Oracle & MyState street (internal reporting tool)

Major strengths are in the use of Netezza, Sybase and Performance tuning

Project which I worked on involved extracting data from different sources and load into Netezza database

My role is to ensure that data loads without any intervention or loss and check that the data is transformed as per business logic and gets loaded into fact tables.

This includes writing PL/SQL queries, stored procs and basic shell scripting from which we used to call the PL/SQL queries

Also coordinated with QA and ensured that the test data is effective enough to run the tests with maximum coverage and perform regression for the reports at run time to keep the accuracy of the figures in check

Additionally, I used to interact with the business analysts for performing effort analysis for development of the stories and successfully delivering the quality product to provide value to our client’s business.

I extended my support to Production-Support team in resolving UAT and Prod issues as well

DevOps Associate (StateStreet Corporation)

Have good knowledge on DevOps tools like Maven, Ant and Nexus

Worked on Build tools like Jenkins-Enterprise version

Troubleshooting production issues by checking the logs using Putty & CB job logs

Have good hands-on experience on Jenkins integration with Nexus

Worked on Cloud Bees Migration from opensource Jenkins to Enterprise version

Worked on many new enablement’s for many applications directly on Cloud bees

Worked on some groovy scripts as well for user requirements

Worked on configuration of Jenkins jobs with GIT repository

Worked on AIS requests from offshore for the applications and provided support during their schedule deployments

Hands on experience in UAT and Production deployments for AIS application

Excellent team worker with strong communication and inter-personal skills. (Soft and Organization Strategy goal-oriented skills)

Software Engineer Associate (Accenture)

About 2 years of Experience in MS Business Intelligence Tools (SSRS & SSAS) and Analysis & Developing web-based applications using SQL Server 2008r2/2012

Major strengths are in the use of MSBI, SQL Server 2008r2, SQL server 2012 and Web Services

Experience working with Enterprise applications in the Global Pharmaceutical Company. Teams worked for include INSIGHT & Data Warehouse

Experience in the areas of System Analysis, Design, Development, Testing, Implementation and Production Support of enterprise applications

Hands on experience in UAT and Production deployments

Hands on experience in Microsoft User Support/Production Support, installation, upgrade & configuration of MS SQL Server & Business Intelligence Tools

Excellent team worker with strong communication and inter-personal skills. (Soft and Organization Strategy goal-oriented skills)

Proficiency in Data Warehousing techniques including data cleansing, slowly changing dimension phenomenon

Strong Understanding of the principles of DW using fact tables, dimension tables and star schema modeling. Experience in data stage installations and patching

DataStage production job scheduling using the Data Stage Director

Implemented High Performance Methods in ETL processes. Involved in all the stages of Software Development Life Cycle

Designed and Developed data validation, load processes, test cases

Extensive experience in analyzing and documenting business requirements and System functional specifications including Use Cases

Excellent team player with strong written, communication, interpersonal, analytical skills. Capable of working in high stress environments with resource constraints

Good knowledge in using Excel functions

Domain expertise in a Global Pharmaceutical Company

Employment Details

Currently working as Scrum Master in SavenNova Technologies from March,2020 to till date

Worked as Scrum Master in State Street Corporation from November,2016 to August,2019

Worked as DevOps Associate in State Street Corporation from November,2016 to October,2017

Worked as Analyst in Accenture from February 2016 to November 2016.

Worked as a Software Engineer Associate in Accenture, Chennai from December 2013 to August 2016.

Qualification

Bachelor of Technology with major in Computer Science Engineering from JNT University, Hyderabad

Professional Skill Set:

Tools : Maven,ANT,PUTTY

Version control system : GIT

Continuous Integration tool : Jenkins

Web servers : Apache Tomcat

MSBI Tools : SSAS, SSRS, MS Business Intelligence Studio 2008

RDBMS : Netezza, Sybase,SQL Server 2008 R2 / 2012, Oracle 9i

Data Warehousing Tools : Web Sphere Data stage 8.1, IBM Data stage 7.5.1 Enterprise

Operating Systems : Windows Server 2003/2008/XP/7/8

Version Controller : Serena Dimensions

Debugging tools : HP Service center, Rational Team concert (RTC)

Web Servers : IIS 6.0

Packages : MS Office 2007/2010, SharePoint Designer

Experience:

1.Insight Global Data warehouse, Pfizer Inc

Associate Software Engineer

Insight Global Data warehouse deals with the Pfizer revenue. The project is highly critical to Pfizer sales. The data is extracted from various source systems and then loaded to the insight stg or Insight schema. Using DataStage as the ETL tool, various business logics are applied to the data and then loaded to the main Insight schema. Insight data is either further processed by Microsoft SQL Server Analysis Services (SSAS) or reported upon by Microsoft SQL Server Reporting Services (SSRS). The reports refreshed through this system are being viewed and analyzed by a number of end users in their decision-making process. In case of RCS the most important source for Insight, the data is incrementally extracted and loaded to the CDC schema using IBM Live Audit.

Responsibilities

Involved in direct discussion with the Functional/End-Users to study the system requirement to develop Technical specifications to meet their requirements

Developed the automation tools to avoid manual monitoring of jobs, memory threshold on each server and for year –end activities like partition management

Maintaining and monitoring reports using BI Reporting tool

Understanding the business process, data flow and logic derivation to load Datamart

Involved in requirement gathering, design and development of new enhancement, bug fixing and production support

Analyze and fix the production issues in time and track the issues using HP service center

Develop SSRS reports using BIDS and create subscriptions based on client requirements and do enhancement of existing cubes like partitions creation and adding dimensions to the existing cubes

Monitor and fix the cube failures and data issues

Ensure all the business critical process available to the end user at right time during the business critical hours to ensure there is no much impact

Work with the team in identifying and improving areas that would favor a stable environment for production upscale

Scheduling the training for the team on regular basis for new joiners

Involved in Accenture audit activities and performed PQA role. Also, followed the SOX compliance quality process for all the code change involved in the existing system

Performing various administrator activities like user creation, table/view access privilege, oracle threads monitoring, tablespace capturing, cleanup of tablespace, clearing materialized logs, granting privileges, creating DB links, automated the process to kill the session which are not active

Implemented various Continuous Improvement process in the system

Successful in regenerating errors to solve unmanageable errors on UAT boxes

Sound knowledge of legacy systems

Scheduled jobs to stop and restart the Data stage engine at server problem

Support for solutions of the bugs and change requests raised by the client to incorporate the correct/additional functionality

Monitoring the jobs in DataStage director and in UNIX

Implementing the new developed automation jobs based on the client requirements on Agile Methodology

Involved in exporting and importing the Data Stage jobs using Version Control

Scheduling the jobs in CRON TAB and UC4 scheduler

Preparing the Unit Testing Plan, the Unit test cases, Change Code document and Code review checklist

Maintaining the Weekly status report

Gathered DW project database requirements from the users through use of questioners and analyzed them in terms of the measurable dimensions and facts

Created 2-3 reconciliation reports to validate the data accuracy

Implemented various Continuous Improvement process in the system

Environment

Ascential Data Stage 8.1,7.5.2/7.0/PX, Oracle RDBMS 9.2(W/Partitioning)/11g, IBM Live Audit, UNIX Shell Scripting (Korn/KSH), SQL*plus, LINUX, Sequential Files,AS400,Datastage Version Control, UC4 scheduler, IBM Live Audit, TOAD 9.1.0,Microsoft SharePoint Server 2007,MS SQL Server,AS-400, Microsoft SQL Server 2005, Microsoft SSRS 2005.

2.DevOps specialist

Associate-2

Worked in this project which has many applications nearly 200+ on each server where we troubleshoot the issue if app team struck in.Having sound knowledge in Jenkins,Git & Nexus.

Troubleshooting production issues by checking the logs using Putty & CB job logs

Have good hands-on experience on Jenkins integration with Nexus

Have legacy knowledge in UNIX

Worked on configuration of Jenkins jobs and with GIT repository

Worked on Cloudbees Migration from opensource Jenkins to Enterprise version

Worked on many new enablements for many applications directly on Cloudbees

Worked on AIS requests from offshore for the applications and provided support during their schedule deployments

Worked on some groovy scripts as well for user requirements

3.ETL Developer

Currently working in this project involved extracting data from different sources and load into Netezza database. I used to ensure that data loads without any intervention or loss and check that the data is transformed as per business logic and gets loaded into fact tables. This includes writing PL/SQL queries, stored procs and basic shell scripting from which we used to call the PL/SQL queries and Unix scripts. Also coordinated with QA and ensured that the test data is effective enough to run the tests with maximum coverage and perform regression for the reports at run time to keep the accuracy of the figures in check. Additionally, I used to interact with the business analysts for performing effort analysis for development of the stories and successfully delivering the quality product to provide value to our client’s business. I extended my support to Production-Support team in resolving UAT and Prod issues as well

Achievement:

Awarded as best Outstanding Performer for Insight Project [Pfizer] by Accenture.

Awarded as Best for having good continuous performance for Spam-ops project in Accenture.

Strengths:

Dynamic Team Player, Excellent Communication Skills, Creative and Resourceful

Personal Details

Date of Birth : 15th September 1990

Age : 29 years

Sex : Male

Marital Status : Single

Father Name : P. Satyanarayana Murthy

Nationality : Indian

Languages Known : English, Telugu & Hindi

Passport Details

Passport No : J0244667

Declaration:

I hereby declare that, the above details are true to the best of my knowledge and belief.

Thanking You

Yours Sincerely,

(Sandeep Penugonda)

Contact this candidate