Ramkumar Kashyap
PHONE: 416-***-**** ( **********@*****.***
Summary - CRM and Business Intelligence
A Senior Solution Architect with six years experience providing innovative,
award winning CRM and Business Intelligence solutions in Public Sector,
Pharmaceutical and LifeSciences, Telecommunications and Utilities. Covered
all functional and technical aspects on Request for Proposals on projects
from $2million to $48 million covering requirements from hardware,
software, solution, resourcing and budgeting. Providing quality leadership
in managing technical teams to deliver solutions that meet strategic
business initiatives. MBA from Rotman School of Management, University of
Toronto.
Expertise Highlights
Siebel/OBIEE System Integration and Delivery
Project Management Infrastructure Planning and Sizing
Business and Functional Analysis Systems Security & Disaster Recovery
CRM/Analytics Strategy and Planning
Solutioning Testing/Scripting/Documentation
Service Oriented Architecture (SOA)
Professional Experience
Pradyun inc - Mississauga 2004 to Present
Skura Corporation 2005-2008
Solution Architect
Designed and implemented Colon Cancer InScreen screening program at Cancer
Care Ontario using Siebel Public Sector CRM framework, Informatica for ETL
and Microstrategy for reporting. The solution interacted with various
Ministry of Health and Long Term Care (MOHLTC) databases such as the
Registered Persons Database (RPDB), the Laboratory Reporting Tool (LRT),
Colonoscopy Interim Reporting Tool (CIRT), Ontario Laboratories Information
System (OLIS) and Ontario Cancer Registry Information System (OCRIS).. The
InScreen project was HIPAA and HL7 2.x/3.0 compliant. Project was awarded
the ITAC award for Healthcare Informatics.
Designed and implemented Laboratory and Waterworks Information Systems
(LWIS) for the Ministry of the Environment, Ontario. The solution was a
first to utilize the Siebel CRM framework to implement Inspection,
Compliance and Case Management. The project was showcased as a best
practices implementation for Public Sector in Siebel World.
Acted as subject matter expert (SME) for the Ontario Ministry of
Agriculture, Food and Rural Affairs (OMAFRA) inspections division. Provided
expertise in infrastructure architecture, software and hardware sizing,
case management and compliance, incident management, reporting and
analysis.
Gathered and assessed needs from internal business units; conducted
workshops and facilitated Joint Analysis and Design (JAD) sessions.
Managed teams of four to twenty developers, configurators, and data and ETL
specialists.
Analyzed all aspects of project including business requirements, fit gap
analysis, legacy data migration, hardware sizing, performance tuning, and
testing
Documented functional requirements, fit-gap, design, workflows, data
mapping.
Designed and implemented Sales Force Automation (SFA), Key Account
Management, Clinical Trial Management Systems (CTMS), Territory Management
and Alignment, Reporting and Dashboards for Pharmaceutical, Biotech and
Lifesciences clients.
Documented complete testing methodology from unit testing, integrated
testing, performance and load testing, and user acceptance testing
Conducted knowledge transfer sessions for the technical support teams to
ensure smooth transition once applications went live
Provided 2nd tier and 3rd tier support for production issues
CGI - Markham 2002 to 2004
Technical Lead/Senior Consultant
Worked closely with Bell Business analysts and end users to understand
business requirements and architect optimal solutions
Conducted walk-throughs and code reviews with Bell IS/IT specialists
Conducted client interviews and workshops to understand Call Center
requirements, call volumes, processing times
Writing Business Requirements Definitions (BRD), System Requirements
Specifications (SRS), and design documents for the client.
Responsible for sizing the development, QA, Apptest, User Acceptance
Testing (UAT) and production.
Created program and project WBS. Level of effort and cost estimation for
program and project.
Key member of team responsible for developing and fostering a mentoring
program for new hires
SPatial DImensions Inc - Bridgewater/Oakville 1998 to 2002
Principal Consultant
Built prototype to demonstrate Call Center Solutions using Siebel 99 with a
subset of ACN Energy customers. Customers for Baltimore Gas & Electric
(BGE) were chosen. Client information was stored in an LDAP server
Established link from Siebel 99 to Oracle Financials for Customer tracking,
billing issues, payment information and payment issues, new service/s,
terminating service/s
Implemented Oracle Financials, with secure integration to multiple utility
companies using WebMethods, EDI
Implemented online bill payment and presentment system which was integrated
with Oracle Financials
Conducted audits for Y2K compliance
Designed and developed B2B netmarkets application for the Paint and
Chemical industry.
Education
Rotman School of Management- Toronto
Masters in Business Administration, 2007
Technology Summary
Certification Siebel Certified Consultant 7/2000, Siebel Analytics Server
s: Architect, Achieved PMP designation in 2003, Masters
Certificate in Project Management
Applications: Microsoft SQL Enterprise Manager, Microsoft SQL Query Analyzer,
Siebel Tools, Siebel Analytics/OBIEE, Microsoft Project,
Microsoft Visio, Igrafx, Sparx Enterprise Architect, ERWin,
Microsoft Access, Microsoft FrontPage, Microsoft Office
Methodologies Siebel eRoadMap, Rational Unified Process (RUP), PMI, Zachman
: Architecture Framework, Knowledge of TOGAF 8.1.1/9.0
Systems: Windows, Linux, Solaris,
Languages: Javascript/eScript, SQL, PL/SQL, CSS, PERL, Python, HTML,
Visual Basic and Visual Basic for Applications (VBA)
Currently have Reliability Clearance for Federal Government.