Alex Panuganti
Siebel CRM Certified Core Consultant
IBM Certified IT Architect
PMI Certified Project Manager (PMP)
Summary: Alex has over twelve years of IT expertise (working for IBM, Oracle) as Business
Analyst/ Solution Architect, in the areas of leading, managing and implementation of custom
applications and packaged software’s, ERPs.
Work Experience:
Quintiles Inc Sep 09 – Feb 2011
Sr. Business Analyst/Integration Team Lead
Worked with the clients Business architects to review and establish processes for supporting
CTMS (Clinical Trials Management System) (Siebel eClinical Application).
Conducted JAR sessions to re-engineer business processes to CTMS, identify areas that need
process re-engineering work, establish gaps and list requirements for customization.
Reviewed configuration changes needed with architects and developers to implemented modified
processes.
Established data requirements from legacy applications to supposed re-engineered processes,
and worked with legacy application owners to set up and architect integration design parameters
for connectivity.
Prepared the FDD documents for client’s review and approval.
Worked with developers to ensure that all the UI requirements, data model changes are
established and detailed.
Coordinated with all the integration developers, client architects, legacy application owners to
design, develop and test all the interfaces.
Prepared the detailed project plan for implementing 18 interfaces, including batch and realtime
interfaces.
Worked on debugging defects and re-testing the adjusted configurations.
Updated and reviewed development and testing progress with the program management team
and the stake holders on a weekly basis.
AT&T Mar 09 – Sep 09
Sr. Business Analyst
Worked on implementing an integration solution for supporting customer, billing
•
and service applications.
Conducted review sessions with stake holders, established process parameters,
•
finalized data mapping between legacy and Siebel systems.
Worked on evaluating and establishing integration methodologies for batch and
•
real time interfaces.
Oracle Consulting June 08 – Feb 09
Client:High Tech Manufacturing Company
Business Analyst
Implementation of Oracle Siebel v8.0 and integrating CRM with legacy backend
•
applications to support Customer data, Order Management and fulfillment.
Gathered business requirements, supporting transaction processing.
•
Conducted requirements analysis using a Use Case driven approach and produced
•
detailed use cases for all the interfaces.
Used Rational Rose and UML to produce use case models, and sequence diagrams, as
•
part of the detailed design of interfaces.
Established strategic partnerships with the business units to develop a solid understanding
•
of the business line; including the business plan, products, and process and revenue
streams.
Functioned as a primary bridge between the business, operations, and the technical areas
•
throughout the project cycle.
Identified and validated high potential business opportunities for stakeholders and
•
developed customized business strategies that are aligned with corporate strategic
objectives
Planned and supervised stakeholder review sessions, fit gap analysis, managed change
•
control and project costs and budgets.
Wrote and maintained other technical documentation (including issues lists, flow charts,
•
risk assessments, and use cases) as required for new technologies and/or regulatory
compliance, e.g., in support of SDLC, SOX, change control, and problem management
processes.
Prepared test cases for manual testing at all stages, SIT, UAT etc
•
Designed interfaces to integrate CRM and legacy systems, using SOA, Web services and
•
messaging.
Worked on data mapping work to import legacy data in to Siebel Db, wrote SQL scripts to
•
extract data for analysis and extracting data.
Client:Healthcare Company
Solution Architect/Business Analyst Apr 08- June 09
Conducted the upgrade assessment work to upgrade the order management
•
system.
Worked with business owners and development teams to support applications that
•
comprise components from different vendors; develops RFI’s, RFP’s, and business cases;
monitors SLA’s and Disaster Recovery requirements / testing with vendors.
Reviewed current customizations, configurations and workflows supporting Sales
•
and Service functions. Reviewed all data migration jobs/ EAI interfaces and performed a
detailed study of replacing them with available new technologies and features from v8.0.
Performed detailed data mapping work to analyze data model changes.
•
Conducted stake holder reviews to assess requirements to support new business
•
functions and designed solutions to support them.
Worked with CRM solution sales to design CRM solutions for clients and prepare
•
responses to RFP’s. Prepared estimates, and performed detailed cost analysis.
IBM Corporation Nov 00- April 08
Client:Healthcare provider, Detroit, Michigan
Business Analyst/Architect
Negotiated deliverables from initial requirements to final implementation by leading
•
communication between business units and IT.
Analyzed requirements and prepared functional and technical design documents.
•
Worked on implementation of Siebel 7.5 Call Center application to support their sales
•
operations.
Implementation of Siebel CTI feature with Genesis software.
•
Integration of Siebel with other legacy customer databases using Integration middleware,
•
WBI.
Worked on Assignment Manager to assign Opportunities to team members.
•
Implemented the e Service module to support assignment and follow-up on service
•
requests across the country.
Setup the internal organization structure, access controls and visibility
•
Internal project
Sr. Business Analyst/Team Lead
Worked with customers across 25 countries to setup a customer facing portal to help IBM
•
account mangers and customer employees to collaborate and exchange information.
Portal helps customers to login, look at all the IBM assets installed at their location, SLA
•
details, search and place orders for products that are relevant to their organization.
Portal helps customer employees to update their content, search knowledgebase, submit
•
RFP’s and interact with any IBM group.
Integrated with backend IBM products, pricing and sales information supporting
•
applications
As the key liaison between IBM execs and customer, interacted with multiple groups,
•
conducted stake holder review sessions, requirements analysis, standardization,
coordinating the look and feel of the web pages, static and dynamic content, portlet
placements, and graphics.
Worked on collecting translations for all the labels and menus and coordinated with
•
content mgmt teams.
Tools used are Websphere portal server, application server, Netweaver and ECM
•
(Enterprise content mgmt systems),
Client: Major Bank, Detroit, MI
The project was about participating in the research and development of Enterprise Supporting
System to support Asset Mgmt, Risk Mgmt and Marketing team of the Tata AIG to develop new
business opportunities for their prospective customers. Automation included Special Billing,
Auditing, and Cash Value Estimates.
• Gathered business requirements, supporting transaction processing.
• Conducted requirements analysis using a Use Case driven approach and produced
detailed use cases for all the interfaces.
• Used Rational Rose and UML to produce use case models, and sequence diagrams, as
part of the detailed design of interfaces.
• Established strategic partnerships with the business units to develop a solid understanding
of the business line; including the business plan, products, and process and revenue
streams.
• Functioned as a primary bridge between the business, operations, and the technical areas
throughout the project cycle.
• Identified and validated high potential business opportunities for stakeholders and
developed customized business strategies that are aligned with corporate strategic
objectives.
• Provided analysis, understanding and business perspectives on many financial and
operational issues.
• Conducted several Requirement Gathering Sessions (RGS) for gaining detailed
requirements and finalizing Business Requirement Document (BRD).
• Used Telelogic DOORS for requirements management and saved requirements modules
of database.
• Used Rational Unified Process (RUP) for streamlining the team’s development activities.
• Translated Business requirements to functional and technical language with the help of
Use cases and UML diagrams for developers.
• Involved in preparing a simple and detailed User manual for the application, for an
intended novice user.
Client:Consumer Industry Sector
Managed a team of 22 members, worldwide, implementing Siebel v7.7 for Sales
•
Operations, and Service.
Coordinated long-term solution design strategies, legacy application transformation,
•
application upgrades, implementation of SOA and ESB’s.
Worked on Solution design, integrating Siebel with other legacy applications using Siebel
•
UAN, EIM and other object level interfaces for real time and batch transfer of data and
information.
Responsible for client interaction, requirements definition, mapping and project planning
•
Implemented Siebel (PRM) Partner Relationship Management, Partner Portal, Partner
•
manager modules.
Worked briefly in implementation of Siebel Analytics, including designing the star schema
•
data model, Siebel answers. Intelligence Dashboards, Siebel Delivers.
•
Client: Mortagage company, New York
• Participated in the identification, definition and documentation of impending work flows for
the purpose of migrating to a superior version of party information system.
• Facilitated (JAD) Joint Application Development sessions to identify business rules and
requirements and then documented them in a format that can be reviewed and understood
by both business people and technical people.
• Translated Business requirements to functional and technical language with the help of
Use cases and UML diagrams for developers
• Conducted requirement workshops among all project stakeholders to verify and validate
the business requirements in UI designs.
• Facilitated JAD sessions to allow different stakeholders to communicate their perspectives
with each other, resolve any issues and come to an agreement quickly.
• Performed gathering, analysis, review and signoff of business requirements and
conducting of interviews, sessions etc
Client:Pharmaceutical Company, Chicago, IL
Team Lead
Worked towards requirement gathering, interviews with stakeholder requirement analysis,
•
GAP, designed and deployed required interfaces using EAI, and data loads with EIM.
Worked on implementation of Siebel call center and eService.
•
Worked extensively on EIM, Workflow Manager and Assignment Manager
•
Mergers & Acquisitions experience
IBM acquisition of Rational Software products...2004...Worked as the lead liaison to build basic
strategy of migrating business rules, data migration (batch/real-time), and user migration. Worked
on identifying solutions for daily data migration jobs. Upgrading Siebel to accommodate Rational’s
business processes and data transformation.
IBM acquisition of “Ascential Inc” worked with Ascential business owners to migrate all open and
closed Opportunities, merging of sales methodologies/cycles, data migration, one time and also
on going. Built architecture to support user interface merge and business rules incorporation in the
new release.
Accomplishments at other IBM Client engagements
Functioned as the consultant lead for the manufacturing process team in the implementation
•
of SAP at an automotive tier-1 supplier. Worked on all phases of the implementation and
helped integrate the PDM and Configuration management processes in the new system, in
addition to the core manufacturing processes. This was the first ERP implementation for this
client and achieved significant business process improvements as a result of the
implementation.
Planned, designed and deployed a tool to support Solution design and delivery process.
•
Technologies including Portal server, WebSphere application server, MQ Workflow, DB2 and
WebSphere Business Integrator.
Architected an integrated solution to help resolve customer credit rating issues from Siebel,
•
using xml, web services and Enterprise service bus.
Integrated multiple applications to support customer information, billing, and service using
•
application middleware’s, java data bean adapters, on UNIX. Oracle database.
Miracle Software Systems Inc, Detroit, MI 1999 – 2000
IT Sales Manager
Looked after sales and project implementation of ERP and Siebel software’s.
•
Complete lead management, qualifying opportunities, proposals, customer presentations and
•
contract finalization.
As an engagement manager, looked after Project Management, resources planning and client
•
interaction
Technical Skills
Project Domain: Business Analysis, Fit gap, JAR sessions, Requirements, Solution
Design, Application Development, Business Process Re-
Engineering, Data modeling, SQL, testing, Production support, etc
Operating Systems: Windows, Unix
Programming Languages: Java, HTML, XML, ABAP 4, eScript
Databases: DB2, Oracle, SQL Server
Applications: Siebel CRM v6.3/ v7.0/ v7.5/ v7.7 and v8.1, SAP R/3,
. Oracle EBS, MS Projects, Visio
2000, MS Office
Other: Brio, Erwin, Qwaliware, Crystal Reports, Actuate Reports,
Education & Training: Bachelor of Science, Maths - Andhra University, India
Bachelor of Engineering - Mysore University, India
Siebel CRM Certified Core Consultant
IBM Certified IT Architect
PMI Certified Project Manager (PMP)