Project Management
Resume:
ROHIT ANDRADE
************@*****.***
I am an accomplished senior consultant with 9.5 years of experience in service fulfillment telecom OSS domain (Inventory
and Order Management) and media domain (SFDC CRM). I have extensive functional consulting experience on IT
transformation projects in the areas of mobility and enterprise business covering B2C & B2B business areas. My experience
has been primarily around COTS products like SFDC, Oracle OSM and Amdocs Cramer.
Professional Summary
• Expertise as business analyst on SFDC in interacting with clients for requirements gathering, writing system
functional specifications including use cases, high level design and ensuring sign off from the business users for the
functional specs.
• Hands on experience as an SFDC admin to configure the Service Cloud functionalities (SFDC Admin Certified).
• Hands on experience in using requirement gathering tools like Rally, Microsoft Visio.
• Expertise in UI design using tools like Balsamiq.
• Expertise on functional consulting for Oracle OSM that includes interacting with clients for requirements gathering,
fit gap analysis, documenting the functional OSM design. Have rich experience on working for 2 complete IT
transformations in the mobile and fixed line space.
• Hands on experience in designing OSM orchestration for OSM COM and OSM SOM and leveraging the RODOD /
RSDOD concepts and functional expertise on AIA PIPs
• Expertise in providing OSM estimates, high level inventory and order management solutions to multiple RFP
responses for Europe and Asia Pacific clients.
• Expertise in designing and implementing data migration scripts using PLSQL to migrate all the Cramer Metadata and
Instance Data from Cramer 4 to Cramer 6 for 2 network inventory projects at Cable & Wireless UK.
• Hands on experience on customizing the wizards, web reports and task engine customizations in Cramer 6.
• Sound knowledge of Cramer database model and ability to write complex queries using SQL.
• Exposure to preparation of the Test Strategy Documents, Test Planning and Testing Progress tracking using
Application Life Cycle Management (ALM).
• Hands on experience on designing and executing System Integration & Regression Testing for telecom projects
• Experience of working with Leading Telecom and DTH service providers worldwide: DirecTV, Level 3
Communications, CSL Hong Kong, Korea Telecom South Korea, Hutchison 3G UK and Cable & Wireless UK
Skillset
COTS Products known : SFDC, Oracle OSM 7.2, Amdocs Cramer 4, 5, 6.2
Solution Frameworks : RODOD, RSDOD
Network Technologies : PSTN, Internet, Mobile, IPVPN, MPLS, L2VPN, L3VPN, Wireless (2G, 3G, LTE),
SDH/PDH
Technologies known : Java, PL/SQL, XML
Requirement Gathering Tools :Rally
Databases : Oracle
Operating Systems : Windows, UNIX
Web/Application Servers : Tomcat, WebSphere Application Server
Tools (Development) : Eclipse, TOAD, PL/SQL Developer, XML SPY
(Testing) : Quality Center, Application Life Cycle Management (ALM)
-1-
(Office) : Microsoft Office, Open Office
(Config. Mgmt.) : VSS, MS Sharepoint
Certifications and Accomplishments
• Salesforce Admin Certified – Certification number 2336667
• Received Bravo award in Jan '14 for the significant contributions to Level3 PoC from OSM Track by coming up with
simplified processes, analyzing all the interfaces and guiding the development team for successful delivery
• Received Bravo award at Infosys in May ‘13 for exceeding expectations in the CSL Transformation project at onsite.
• Received FIMC award at Wipro for WES and PPC Cramer project for the significant contributions as an onsite SPOC
that let to smooth delivery of the project.
• Received FIMC award at Wipro for significant contributions at onsite for the MSP Cramer Enhancements project.
• SCJP 1.4 (Sun Certified Java Programmer)
Work Experience
SFDC Shopping Cart Mar 2014 – present
Directv, Los Angeles, CA
Business System Analyst
Directv was implementing SFDC CRM to support the shopping flow for the commercial business. This project involved
implementing the Service Cloud functionalities in SFDC and also developing a custom bespoke shopping cart application
that would be launched from SFDC. It provided the capabilities for the call center agents to order commercial products by
integrating with the Directv offer management system(C3), profile management system(ZLDS), billing system (STMS) and
order management system (OMS) via the middleware (ICAN).
Roles and Responsibilities:
• Analysis of business requirements and conducting requirement gathering sessions in the CRP
(Conference Room Pilot) model. Demo the out of the box SFDC capabilities during these workshop sessions.
• Translate the business requirements into functional specification documents for SFDC and the
custom shopping cart application.
• Identify the SFDC application functionality that may be introduced or impacted to satisfy business
requirements.
• Work closely with Enterprise Solution Architects at Solution Confirmation stage and help him
prepare the High Level Design Document
• Understanding and documenting impact analysis of the enhancement on the existing application as
the SFDC functional subject matter expert for the application.
• Preparing functional specifications documents using MS Word, MS Excel and MS Visio and cross
functional reviews.
• Analyze and review SAS, HLD and Change Requests documents to ensure they are correct and
complete
• Participate in the Initial Assessment meetings with Business Requester, BA Managers, Program
Manager and Development Manager and act as a subject matter expert for the SFDC application
• Work with the SFDC development teams during the development phase for any requirement
changes/clarifications.
• Preparing and executing manual test cases to test the SFDC development is in line with the business
requirements.
Environment:
SFDC Service Cloud, XML, MS Visio, MS Word, MS Excel, MS Windows, Application Lifecycle Management
-2-
Gradus Nov 2013 – Feb 2014
Level 3 Communication, Broomfield (Offshore Project)
Senior Consultant
Gradus was a program launched by Level 3 Communication to revamp their order management platform for their enterprise
products. As part of this project a POC was demonstrated to showcase the order management capabilities of the Oracle
platform and SFDC (Salesforce.com and Cloud Sense) platform that suited the Level 3 business requirements for enterprise
products.
Roles and Responsibilities:
• Analysis of business requirements that were defined for the POC scenarios.
• Document the end to end process flows specific to Siebel, Oracle OSM and AIA.
• Design and implementation of the oracle OSM solution that included leveraging RODOD concepts
available OOTB in the O2C PIP’s and to build Service orchestration in OSM.
• Integration of the Oracle OSM solution with third party vendors and supporting the testing of the
integrated system (Siebel AIA OSM).
• Support the demos from offshore to demonstrate the Oracle OSM product capabilities to the
business.
Environment:
Oracle OSM 7.2, XML, MS Windows, UNIX, MS Visio, Eclipse.
CSL Core System Replacement (CSR) Jan 2013 – Oct 2013
CSL, Hong Kong
Consultant
The CSL Core System Replacement (CSR) was a large business transformation program that was initiated to replace current
CSL core systems with Oracle solutions. It covered major functional blocks that included Customer Sales and Service, Retail
Store Operations, Customer Self Care, Convergent Billing, Order Fulfilment, Operations management, Business Intelligence,
Knowledge Management.
Roles and Responsibilities:
• Gathering business requirements in the requirement gathering workshops.
• Estimates and project planning for this work.
• Preparing the fit – gap analysis of the functional requirements from the Oracle OSM perspective.
• Preparing functional specifications and process design documents including sequence diagrams using
MS Visio.
• Interaction with the business users and external systems for the various interface requirements
required from the OSM COM and OSM SOM perspective
• Preparing the prototype OSM COM and OSM SOM cartridge to demonstrate an end to end scenario
for one use case.
Environment:
Oracle OSM 7.2, XML, UNIX, MS Visio, Eclipse.
kt BIT OSS R1.1 Feb 2012 – Nov 2012
Korea Telecom, South Korea
Technical Consultant
OSS Transformation is part of kt’s BIT (Business and Information systems Transformation) business transformation project.
This project involved transforming kt’s OSS stack from the legacy platform to the oracle solution.
Roles and Responsibilities:
-3-
• Interacting with business and capturing the functional requirements for PSTN, Internet and Mobile
services.
• Preparing and presenting the fit – gap analysis of the functional requirements from the Oracle OSM
perspective.
• Design and implementation of the oracle OSM solution that included leveraging RODOD/RSDOD
concepts to build Service orchestration, Service and Technical Delivery of services
• Leveraged on the AIA PIP’s, ESB to build the integration framework for automation of service
fulfillment process
• Interaction with the business users for the integration requirements of SOM with external legacy
systems to complete the fixed fulfillment process and update the same to the LLD.
• Preparing use case diagrams, class diagrams and sequence diagrams for the gathered requirements
and documenting the same in the low level design.
Environment:
Oracle OSM 7.2, XML, UNIX, MS Visio, Eclipse.
Cramer PPC and WES Migration June 2010 – Dec 2011
Cable and Wireless, UK
Solutions Design Lead
The scope of the project involved designing/modeling of new metadata models for BT WES devices and design of the new
SDH and PDH Circuit hierarchy for the PPC circuits. The project was to migrate the device and circuit data maintained in
spreadsheets to Cramer inventory. These would in turn help the client in better management and utilization of BT WES and
PPC circuits by using Cramer features.
Roles and Responsibilities:
• Lead a team of 3 offshore associates.
• Interact with business users for requirements and preparation of function specification documents.
• Preparing use case diagrams, class diagrams and sequence diagrams for the gathered requirements.
• Modelling new BT WES device models in Cramer Configurator.
• Modelling the SDH and PDH circuit hierarchy in Cramer equivalents to the existing PPC circuit
models.
• Implementation of an automation script using PLSQL to migrate the data maintained in spreadsheets
to Cramer using the Cramer API’s.
• Coordinating the system testing activities and getting the UAT signed off for the project.
Environment:
Amdocs Cramer 6, UNIX, MS Visio, Toad, HP Quality Center.
THUS CPE Modeling Oct 2009 – May 2010
Cable and Wireless, UK
Solutions Design Lead
THUS Telecom had an estate of L2 and L3 services terminating on CPE that needed to be modeled in Cramer 6 as part of the
integration effort before the services could be migrated to the MSP platform. THUS Cramer models the CPE devices of the
generic box type and is not sufficiently detailed to support the level of detail required and currently used in Cramer6 in C&W
for CPE connected to the MSP network. All the devices were hence configured in the C&W Cramer 6 based on their usage in
the MSP network.
Roles and Responsibilities:
• Lead a team of 3 offshore associates.
• Preparation of the design document which involved going through the product vendor’s website
(Cisco) understanding the device configuration, mapping with the client requirement in Cramer and
preparing the document.
• Modeling the devices in Cramer Configurator.
-4-
• Implementing the naming conventions for all the devices.
• Modeling of a new circuit type in Cramer which can be built over these new devices.
• Coordinating the system testing activities and getting the UAT signed off for the project.
Environment:
Amdocs Cramer 6.2, UNIX, MS Visio, Toad, HP Quality Center, WebLogic, Oracle 10g.
exYC and THUS Cramer Consolidation Jan 2009 – Sept 2009
Cable and Wireless, UK
Solutions Design Lead
The Talisker OSS IT Migration program was to migrate THUS OSS Cramer systems towards the C&W strategic systems
architecture. As part of this program, the ex YC and THUS Cramer 4 instances was merged with the existing C&W Cramer 6
transmission instance to ensure C&W is migrated to a single Cramer 6 platform thereby avoiding substantial license costs and
also to improve Network operations with one Cramer for Provide and Assure operations.
Roles and Responsibilities:
• Lead a team of 4 offshore associates.
• Solution design for the strategy to be followed for moving the existing Metadata, Instance Data and
Customizations from exYC and THUS Cramer4 to C&W Cramer6.
• Implement the migration scripts in PL/SQL to migrate the metadata from the exYC Cramer 4 to C&W
Cramer 6 by identifying and resolving all the metadata clashes and generating xml at the end of the process.
• Implement the migration scripts in PL/SQL to migrate all the Instance Data along with the Object
Status consolidation from exYC Cramer 4 to Cramer 6 by developing the Migration Scripts using PL/SQL
scripts.
• Understanding and documenting impact analysis and rewriting all the wizard customizations existing
in exYC Cramer 4 to Cramer 6.
• Reviewing the test strategy documents and test plans.
• During the System Integration & Regression Testing was involved in the testing of all the metadata
and the instance data on the consolidated system after migration.
• Coordinating the User Acceptance Testing and providing the Test Report at the end of the testing
phase.
Environment:
Amdocs Cramer 6.2, UNIX, MS Visio, VSS, Toad, HP Quality Center, WebLogic, Oracle 10g.
MSP Cramer 6 Consolidation Nov 2007 – Dec 2008
Cable and Wireless, UK
Solutions Design Lead
Cramer is the strategic inventory system for Cable & Wireless and there were two implementations of Cramer. One for
managing transmission network (a.k.a. Green Cramer) and the other for managing their IP network (a.k.a MSP/NGN
Cramer). The MSP Cramer 6 consolidation project involved consolidation of the two Cramer 6 systems to a single Cramer 6
System.
Roles and Responsibilities:
• Lead a team of 4 offshore associates.
• Solution design for the strategy to be followed for the consolidation and preparing use case diagrams, class
diagrams and sequence diagrams for all the customizations and the workflows that were migrated.
• Metadata Migration using the configurator for generating xml for the process.
• Implementing the Instance Data Migration Scripts and Object Status consolidation using PL/SQL scripts.
• Implementing the MSP Customizations of MSP Wizards currently in Java to PL SQL in Consolidated Cramer.
• Test Strategy Creation, Effort Estimation and Test Planning for the whole project.
• Redesigning of the regression test cases for all the modules of the existing Green Cramer System.
-5-
Environment:
Amdocs Cramer 6.2, UNIX, MS Visio, VSS, Toad, HP Quality Center, WebLogic, Oracle 10g.
Cramer 4 to Cramer 6 Upgrade (Offshore Project) Mar 2006 – Oct 2007
Cable and Wireless, UK
Senior Software Engineer
Cramer 4 was the Inventory Management product used by Cable and Wireless for their Network Inventory Management. The
project involved migrating all the data and the customizations from Cramer 4 to Cramer 6.
Roles and Responsibilities:
• Design and development of the customizations existing on homepages in the Cramer 4 PL SQL code.
• Prepare the design documents related to migration approach for the data and customizations on home pages
existing in PL SQL code of Cramer 4 to be replicated in Java on Cramer 6.
• Coding and unit testing of homepages for all the objects.
• Unit testing of naming conventions for all the objects.
Environment:
Amdocs Cramer 6.2, Java, JSP, UNIX, VSS, Toad, HP Quality Center, WebLogic, Oracle 10g.
Oct 2005 – Feb 2006
Initial Learning Program
Professional Experience
Date Designation Company
October 2005 to October 2012 Technical Consultant Wipro Technologies
November 2012 to till date Senior Consultant Infosys Technologies
Education Qualifications
Bachelor of Engineering in Computer Sciences (2005),
NMAMIT, Nitte (VTU)
Karnataka, India.
References
Available upon request
-6-
Contact this candidate