Project Manager
Resume:
Umashankar Gummadidala
Umashankar Gummadidala is an IT Professional with QA Manager/Lead
8+ year's experience, which includes around 7 Business Analyst
years experience in SIEBEL as a QA Manager/Lead, Project Lead
and support in other technologies. He has worked SIEBEL
for about 7 years of Siebel applications like
Call center, ePharma, Sales, e-communications and
Financial services. Umashankar Gummadidala holds
a Masters Degree in International Business from
GITAM Institute of foreign trade (India).
Performed, as a QA MANAGER/LEAD to define Test
roadmaps, set up processes, manage to test,
validate and document the business needs.
Experienced in Test Project Management and Test
Strategy and Planning.
Worked on multiple B2B and B2C applications and
environments.
Extensive Pharma experience (Worked with 4 major
Pharma giants)
Experienced in managing Functional, Regression,
Performance, Integration and Validation testing.
Extensive experience in QA processes and Software
development life cycle.
Strong individual contributor with minimum
supervision and excellent communication skills.
TECHNICAL SKILLS
Area Skills
Operating Systems MS Windows XP/NT/2000/95/98, Windows
for workgroups, UNIX, MAC OSX, DOS
6.22.
Programming Languages SQL
Databases Oracle 7.x/8.x/8i, 9i,10g Access 2002,
CRM Siebel Siebel 7.5/8, 8.0 (e-Communication,
e-Clinical, Sales, SFA), Familiar with
SIEBEL ANALYTICS/ Oracle BI
Server Software Siebel CRM, Oracle RDBMS, Microsoft
SQL Server DBMS
Tools Toad, Visio, MS Project & MS office
Testing Tools Quality Center, Win Runner, QTP 8.2,
Load runner, Bugzilla, DOORS
(Requirement gathering), JIRA
Training/Specific Skills - Siebel 7 Core Consultant 3 week
Course.
- Siebel 7 Business Analyst 1 week
Course.
- In house certified for GDP with
Schering Plough.
- Trained on Telelogic's DOORS tool.
- Trained in UML
- Advanced Internet Power Programming
(JAVA).
Multimedia Photoshop, Flash; Premiere Pro, Flash,
Final Cut Pro, 3D Max, Director, Shake
4.0.
Training Undergone
Siebel 7 Business Analyst 1 week Course.
Siebel Core Consultant 3 week Course.
Siebel 7.7 Migration training 1 week Course.
Tele Logic "DOORS"
Trained on GDP (Good Documentation Practices) at Schering Plough.
Advanced Internet Power Programming (JAVA).
EXPERIENCE DETAILS:
Project Title SFX e-viewer
Client Boehringer Ingelheim (Feb '10 to
Present)
Tools SKURA SFX, Siebel 7.8, Toad,
Quality Center
DESCRIPTION OF THE PROJECT:
The SFX e viewer is a tool designed to help reps with closed loop
marketing. This tool is installed on top of Siebel application. The data is
captured from Siebel database and the activities performed on SFX would be
recorded back to Siebel. Testable activities within SFX would be Pre-call,
Presentation and Post call. As a part of the testing effort an end to end
verification was done from a validation perspective.
Responsibilities: Test Lead
. Participate in the requirements gathering sessions.
. Handled a testing team size of 4 resources.
. Create testing roadmaps.
. Regular interaction with various client teams to define the scope for
testing.
. Coordinate the Test Dry Runs.
. Coordinate the Validation Testing effort
. Defect management.
Project Title XU Upgrade
Client Merck (November '09 to Feb '10)
Tools Siperian, BDD, Quality Center,
Sharepoint
DESCRIPTION OF THE PROJECT:
Merck's XU upgrade project is a Siperian and BDD upgrade project. This
project is going through three cycles of SIT.
Responsibilities: Project Coordinator
. Coordinate the data load processes for performing SIT.
. Handled a team size of 8 resources.
. Manage schedules and plan system down times.
. Create and Manage data refresh and code migration workflows.
. Ensure over all project timelines are met.
. Perform scheduled tasks of restarting app servers to ensure smooth
code changes.
. Coordinate and manage the testing efforts.
Project Title Domestic Home Entertainment to Global
Siebel
Client 20th Century Fox (July '09 to November
'09)
Tools Oracle BIEE, Toad, Excel, Share Point
DESCRIPTION OF THE PROJECT:
Fox's Domestic Home Entertainment (DHE) division focuses on the sales of
media through DVD's & Blue Ray disks. The current project was to migrate
the newly developed functionality of the DHE to Global Siebel to be a part
of the application that is used in the rest of the world. The analytics
segment of this migration needed a thorough testing of the Dashboard
reports, Metadata through answers and validate against the sales planning
data mart.
Responsibilities: QA MANAGER
. Develop and maintain the consolidated Test Strategy and Test Plan.
. Handled a team size of 2 resources.
. Coordinate through extensive sessions with the business to work on the
existing screen mock-ups to develop use cases and test cases.
. Setting up the documenting standards to maintain traceability.
. Manage creation and execution of test cases.
. Coordinate the test execution effort using Share Point and test cases
using customized excel spreadsheets.
. Handle day-to-day testing efforts under extremely tight deadlines and
changing scope and last minute code and requirement changes.
. Work with the user groups on UAT and training sessions to ensure
successful project deliverables.
Project Title Siebel Upgrade
Client VISTAKON (J&J Company) (May '09 to
June '09)
Tools Excel, PPT
DESCRIPTION OF THE PROJECT:
Vistakon is a J&J company that specializes in eye care. They were using
Siebel call center module and wanted to upgrade to 8.0 and include many
processes that were handled by extensive excel documents and emails.
Responsibilities: Business Analyst
. Developed the FRS document for the project after extensive JAD
sessions with both business users and IT groups.
. Created Siebel screen mockups to get the business buy in on the
process shift from excel documents to Siebel workflows.
. Developed a project timeline and schedule for the implementation after
discussing with internal technical experts.
Project Title 1. US Commercial Model D Analytics
1.0
2. Customer Connect Model B
Analytics 1.2
Client Merck (October '08 to May '09)
Tools Oracle Business Intelligence
(Analytics), Quality Center, QTP,
UNIX, JIRA, UML
DESCRIPTION OF THE PROJECT:
Merck's Commercial Model D and B Analytics are Analytics projects that
focus on the sales data for US and Europe markets. These sales figures are
derived from various source systems like Siebel CRM, PIMS, IMS, Customer
Master, Alignment Master and ESA. As a part of the testing it would be
inherent to test the data flow from the source systems to the target
systems via the staging tables through the ETL process. As a part of the
testing 10 KPI's and an aggregate of 50 Dimensions were considered.
Responsibilities: QA LEAD
. Define Testing scope, Test Strategy and Plan.
. Handled a team size of 5 resources.
. Create extensive process diagrams for testing with all the systems in
scope to define data and process flows.
. Coordinate through extensive sessions with the business to break down
high level requirements to testable process oriented requirements.
. Setting up the documenting standards to maintain traceability.
. Maintained the Requirement Traceability Matrix for the project.
. Coordinated the testing effort using Quality Center.
. Handled day-to-day testing efforts under extremely tight deadlines and
changing scope and last minute code and requirement changes.
. Tested the data sanity, format and mapping from various source systems
to the target Analytics UI.
. Managed Automation as well as manual testing effort.
Project Title CTMS (Clinical Trials Management
System)
Client Schering Plough (April '08 to
October '08)
Tools Siebel 8.0, DOORS
DESCRIPTION OF THE PROJECT:
SPeCTRuM is the tool that is being designed by Schering Plough to manage
Clinical Trials. The legacy system PROSIT would be migrated to Siebel 8.
This project was at its infant stage where the best practices for migration
were being defined. In the initial phase of this implementation the testing
team identified the Scope, Strategy and Plan for the implementation along
with understanding the legacy system and its complexity.
Responsibilities: QA MANAGER / LEAD
. Participate in the JAD/Requirement gathering sessions to define the
Testing Scope.
. Design the testing road map.
. Defining Scope, Testing Strategy and Plan.
. Setting up the documenting standards to maintain traceability.
. Coordinate the test case preparation for POC.
. Trained in all valid SOP's and GxP procedures at Schering Plough.
Project Title Siebel upgrade - 6.3 to 7.8
Client Abbott Labs, IL (March '07 to
March '08)
Tools Siebel 6.3, 7.8 Test Director
DESCRIPTION OF THE PROJECT:
MAX 3.0 is Abbott's SFA application that helps field sales representatives
to interact with the target Industry professionals with distribution of
Product samples and information. It's an integrated system that connects
with multiple systems such as Nuke Pharma, OMEGA and KEYSTONE to store the
synchronized data on a representative's tablet.
Responsibilities: QA MANAGER / LEAD
. Prepared Test plan for the Alignment process (Siebel Assignment
Manager)
. Handled a team size of 15 resources both onsite as well as offshore.
. Worked closely with client side Business Analysts to gather and
document requirements.
. Assist in updating business requirements documents.
. Coordinated System, Integration and Alignments testing.
. Migrated manual Validation testing to Test Director for test
management.
. Documented and structured requirements and set up testing process.
. Perform regular connection/smoke tests for patch upgrades.
. Successfully coordinated the test case preparation for the upgrade of
the entire application. This includes preparing of functional test
cases, Interface test cases and Alignment test cases.
. Structured test results and defect tracking on Test Director.
. Coordinate with offshore resources for knowledge transfer and day-to-
day test progress.
. Abbott has very stringent rules in preparation of test cases and
protocols that is backed by FDA rules and regulations. This was
strictly implemented through out the test case preparation and
execution process. The key role as the QA lead was to ensure that
these rules are addressed during the entire testing cycle.
Project Title Siebel upgrade - 7.5.3.12 to
7.5.3.15
Client Novartis Pharmaceuticals, NJ (Oct
'06 to Feb '07)
Tools Siebel 7.5, Test Director
DESCRIPTION OF THE PROJECT:
SONIC is a CRM tool for scientific liaisons within Novartis. The
application is used to define and administer Key opinion leaders (KOL). KOL
organization is the key to the success of the business for Novartis. SONIC
covers General Medicine, Ophthalmology, Oncology and Transplant therapeutic
areas. SONIC was on SIEBEL 7.5.3.12 and Novartis had scheduled to upgrade
the application to SIEBEL 7.5.3.15 with some product enhancements.
Responsibilities: QA LEAD
. Worked as a Business Analyst and gathered requirements for testing.
. Conducted extensive JAD sessions for requirements.
. Performed FIT GAP Analysis.
. Assist in updating requirement documentation.
. Prepared detailed IVP's.
. Prepared the baselines with the business for Validation Testing.
. Delivered a long term Test Strategy on the QA practice within
Novartis.
. Successfully completed 3 cycles of System and regression testing for
the entire application and all therapeutic areas for the upgrade.
. Support in performing QA operations beyond SONIC space.
. Perform regular connection tests for patch upgrades.
. Performed remote testing using inbuilt SIEBEL synchronization and also
used AFARIA to synchronize.
. Structured test results and defect tracking on Test Director.
Project Title ITREK
Client Schneider National, Wisconsin
(March '06 to August '06)
Tools Siebel 7.7, Bugzilla, Silk
Performer
DESCRIPTION OF THE PROJECT:
ITREK is Schneider National's CRM implementation using Siebel 7.7 Call
center. The system is designed as a shift from their existing application
on Mainframe. The system is designed for supporting customer service
representatives online at high call volume. With a testing team of 4
testers, there were 3 regression cycles and an ongoing performance testing.
Responsibilities: QA LEAD
. Assist Business Analyst's for updating Use Cases.
. Lead a team size of 8 resources.
. Assist in presenting for high-level presentations for future projects
Sales Force Automation.
. Documenting existing process and information flow for the entire
organization.
. Documenting pre deployment IVP's.
. Writing Use cases, Test plans and Test cases for new projects.
. Perform regular Connection and Smoke tests for pre deployment.
. Coordinate with offshore resources on a daily basis for both
functional and performance testing.
. Documenting user-friendly Smoke and Connections tests for users.
Project Title Appcom Technology Inc
Client Appcom Technology Inc (Jan'02 to
Aug '06)
Tools Siebel 6.3,7.7.1/7.5.3.8, Test
Director, Win Runner
DESCRIPTION OF THE PROJECT:
Worked with Appcom Technology Inc at their client locations for various
projects that include communication, health care and Internet technologies.
Responsibilities: QA Lead / BUSINESS ANALYST
. Interaction with development teams for smooth problem resolution and
error free rollouts. Extensively used Visio and MS Project.
. Developed Test Plans, Test cases, Test Procedures and Process for UAT
testing.
. Identifying the Test Requirements based on User Requirements and
Design Specifications. Understanding the Requirements for the case
study.
. Validated functional requirements, analyzing the responses to what
test cases are required for Regression testing. Analyzing responses to
requests for a system to go live.
. Created Test Scripts for Workflows, Group Cancellations, Validating
LOV's, MVG's, Drop down, Menus for all List and Form Applets and
Manual Scripts for Accounts, Contacts, Opportunities, Activities,
Partners, Polices & Broker/Consultants.
. Performed manual and automated testing for applications, using Mercury
Interactive Tool (Test Director, Win Runner, Load Runner).
. Generated test record and modified scripts to do regression test
. Created Business Requirements and Functional Requirements.
. Designed and developed Interactive training CD ROM's and Java enabled
web courses for Siebel employee training.
Contact this candidate