Jaikumar L Lalwani
Recruiter: Dhirajkumar Desai
Email: dhirajkumar.desai@tCognition.com
SUMMARY: -
10-12 years of industry experience,
10-9 years of solid Siebel Application experience,
4 years of Siebel Analytics/Data Warehouse,
8-9 years of project management experience
EDUCATION:
Project Management Professional Certified (PMP/PMI)*
Oracle Certified Professional (OCP) 10g
Siebel 7.7 Data Warehouse Developer Certified
Siebel OnDemand Consultant Certified
Siebel 7.7 Analytics Server Certified
Siebel 7.7 Analytics Developer Certified
Siebel 7.7 Integration Consultant
Siebel 7.7 Certified Consultant
Masters in Computer Science, Southern New Hampshire University, Manchester
Certificate in Oracle Specialist Programmer, Gebbs Software India
Honors Degree in Business Management, Indian Institute for Management and
Commerce, Hyderabad, India.
Certificate in Software Technology and Systems Management, NIIT, Secunderabad,
India
WORK EXPERIENCE:
Presstek Incorporation (USA, NH) Mgr Progs/Projs Application Development
(Directly reporting to CIO)
March06-Present
Key Goals achieved: -
Increased Service Revenue by 40%
Customer Satisfaction went up by 66%
Through the improved process of Quotes/Agreements implemented, contract
administrators where able to save 75% of the creation time allowing them to
concentrate more on the strategy part of the business
Service Request creation process was simplified to such an extent that it
saved 80% of the valuable CSR time
Presstek Contracts group were able to accurately meet the 100% of Contractual
Terms and Conditions
Reduced Accounts Receivable by 70% by providing accurate Account credit status
on time
Provided accurate Inventory control to the Service organization where as a
result Auditors removed the red mark of materials weakness findings in the
subsequent year after the project went live
Responsibilities: -
Responsible for the overall development efforts of the application team
Responsible for proposing/development of new projects supporting the Corporate
vision
Guiding the executive leadership team for new projects as per the need
Used Agile software methodology for software development/enhancements
Implemented $2.5 million Siebel Field Service implementation for Presstek
Incs $40 million field service organization for workforce of 250 users
Served as Subject Matter expert for Technical areas of Siebel Architecture and
functionality of Siebel Field Service
Preparing the Project Plan and the outlining the scope of the projects
Communicating the progress of the project and milestone to appropriate
stakeholder
Measuring the Cost and Schedule of the project against the baseline
Escalating the issue to appropriate sponsors where ever their intervene is
required
Analyzing the Risk/Technical aspects of the project
Laying down the procedures for the change management
Handled offshore / onsite teams
Complete life cycle software implementation / development experience
Provide guidance /mentor junior member of the team
Providing on-going support to the user after Go-Live
Projects Handled
Siebel Field Service Implementation: -
Define the Project Charter and Scope of the project and used Use Case
methodology to gather requirements
Performed Gap Analysis between the Preventive Maintenance Engine of Siebel
Application to that of the legacy environment and laid down the design/procedures
for running the Preventive Maintenance engine in Siebel Application
Performed functional analysis of Siebel Appointment Booking System (ABS) in
conjunction with Assignment manager component and implemented as needed by the
Field Service Organization and laid down procedures to use Book Appointment Vs
Dispatch Board
Performed functional analysis on Optimizer engine and provided guidance to
business for its implementation
Designed and implemented the complete Quote and Contract Management in Siebel
Application
Installed and integrated the Actuate Report Server / Chart Works installation
to Siebel Application
Installed and Implemented Siebel Outlook Integration i.e. SSSE component
Designed proposals for Quote and Agreements
Administered Siebel Application on daily basis and sized Siebel Object
Managers for optimal performance
Controlled the Siebel SRF releases in the production environment
Single handedly managed the GO-LIVE weekend, responsible for the entire set up
for it
Developed and imparted training to the management and the end users for using
the application
Designed and Wrote about 10 - 12 Business Services / Workflow in order to meet
the functionality required as per the detailed scope the project
Tuned the Object manager parameters for 200 concurrent users
Siebel 7.8 Web Methods 6.5 AS400 integration: -
Architect the design between Siebel Application / Web Methods and JBA (AS400)
and implemented
Benchmark the performance / load testing the bridges
Developing bridges between Siebel and JBA (AS400 system), using Siebel Adapter
/ Web Method Adapters and Data Queue mechanics of JBA
Oracle 10g Implementation: -
Installed / Configured / Maintained the oracle database 10g and provided
guidance / strategy to IT group for backing up the database
Tuned the Oracle 10g database for optimum performance, for approx 400 users
Provided guidance / laid down procedures for refreshing development / test
environment
Sizing the Memory structures for the instances
Monitoring the database for performance and alerts and thereby resolving it
proactively
Upgraded the Oracle Database from 10.2.0.1 to 10.2.0.3 patch 30
Data Loading/Conversion: -
Wrote the complete Data loading procedures for initial data that need to be
loaded from legacy system JBA (AS400 system) to Siebel Application using the
Siebel COM methodology
Hesser College (USA, NH) Adjunct Professor July-09 - Present
Responsible for designing the syllabus
Contribute to the future development of courses
Delivering the classes as allocated
Oracle Corp (USA, MA) Senior Technical Analyst March01-March06
Gathering Business Requirements and then
Implementating/Configurating/Administrating Siebel Applications
horizontal/Vertical applications
Leading projects within the internal group/department for the enhancement of
the technical service organization
Trained the World Wide Technical Service Organization for the reporting module
of Siebel CRM
Lead for the Readiness project for Siebel Application 7, 7.7
Mentoring/Leading junior staff
Serve as a subject matter expert in the area of Siebel Enterprise Application
architecture, Analytics, Data Warehouse, Siebel Reports and Siebel Integration
Application development using the Object Types in the Data Objects Layer,
Business Objects Layer, and UserInterface Layer
Knowledge in use and manipulation of Business Components, Business Objects,
Joins, Links, MultivalueLinks, Applets (List, Form, MVG, Association,
PickApplets, Chart, Tree and Picklists), Views, Screens and Web Template
Configured new elements and made changes in all three levels - database,
business objects and user interface.
Integrating applications through EIM, EAI technologies, EBC, VBC
Configuring LDAP, Novell Directory with Siebel Application
Installed / Configured / Maintained the oracle database
Guiding Customers to resolve the Database related issues
Commerce TV (USA, MA) Software Engineer III Sep00-Feb01
Developed CCN architect/module using Oracle 8i, and SQL Navigator 3
Defining the Business Requirements to handle backend Database and thereby
developing the packages using PL/SQL in Oracle
Developed Database Triggers and Stored Procedures written in PL/SQL to update
the base Tables and impose integrity constraints
Create the unit test document (test strategy, Unit Test Plan, and test data
specification) and did the unit test based on that document
Oracle Debugging
Developed Web interface for Automation of Build Release
Lead the code review of the CCN architect/module among the various
stakeholders
Southern New Hampshire University (USA, NH) Lab consultant/instructor
Jan00-Aug00
Assisted students in their projects as Lab Consultant
Co-ordinated with staff in setting up the computer lab
Instructor for Visual basic
TATA Teleservices Ltd (INDIA) - Project Lead Data Warehousing
May99-Aug99
Gathered the Business requirements and the needs for Marketing Information
Systems for various stakeholders within the organization
Designed and developed Marketing Information Systems using (Seagates -
Crystal report Writer 4.5)
Developed the Data Dictionary for further References
Developed strategies based on the information derived from the database
Administered the report scheduling process as per the business needs
Lals Raymonds (INDIA) Project Manager Mar98-Jul98
Gathered the business requirement and the needs for developing the application
Created Entity-Relationship model and functional dependency diagram for an
Oracle application. Developing with Oracle PL/SQL, FORMS, and REPORTS
Developed the Sale process Application using Oracle7.3 and Developer 2000
Created Oracle PL/SQL triggers, packages, functions and procedures for
application.
Created complex queries using joins, outer joins, sub queries and relational
set operators
Design and Create report based on user requirement using Oracle Report
Developer
Developed and imparted training to the management and the end users for using
the application
Voluntary Work
PMI Chapter (USA, NH) - Dec07 Dec08
Mentoring/Teaching students (at Fidelity Investments) and PMI NH local chapter
preparing for PMP certification
Developing teaching strategy/methodology for PMP certification
Reviewing the course to align as per the latest release of PMBOK
|