SUMMARY

• Pramod has very extensive IT projects experience of 14+ years in the analysis design development and configuration of various client/server and CRM applications.
• Around 7+ years with Siebel CRM (8.x,7.x, 6.x, 5.x) in design, configuration (using Siebel Tools), scripting (using Siebel eScript), Siebel Reports - spanning eEnergy Call Center, eService, Marketing, eCommunications, eConsumersector, Sales, Service, call center and Financial industry.
• Pramod has worked as Siebel Team Lead, Configuration lead, Siebel Administration, Analytics Metadata, Analytics DW, Production Support Lead and Reports Lead in various projects that involve full Application Software Development, testing and Maintenance.
• Pramod has very strong working experience and sound understanding of Siebel’s multi-tier architecture, Siebel eRoadmap and design on all the three main layers in Siebel 2000, Siebel 7.x and Siebel Analytics 7.5.3/7.7.2. He acts as development team leader and project manager in complex projects involving sophisticated configurations and dynamic business requirements.

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Siebel Technical Architect

Responsibilities:

• Managed the Overall project as Technical architect and Solutions Architect for Siebel Marketing Implementation.
• Installation of the Siebel Environment including Siebel Servers, Informatica and Siebel Analytics across the environments.
• Perform migration tasks including migration of databases, workflows, repositories and schemas to new environments
• Development of technical team processes for code migration and testing environments.
• Developed custom reports/Ad-hoc queries using Siebel Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Migration of Webcat and Analytics Repository.
• Automated the Repository Migration Process across the environments consistently.
• Created and tuned the Informatica sessions to increase performance and to accomplish business results.
• Migration of Informatica Mapping and sessions.
• Loaded third party data through EIM and handling 24 Interfaces.
• Managed Unit testing team and Analytics team of 8 developers.
• Major responsibility as a Technical/Solutions resolve issues around EIM/Analytics/Configuration/Server administration
• Experience in dealing with Siebel Support and Expert services.
• Establishing and maintaining application/information practices and standards that support Siebel.
• Maintain expertise in the area of architecture, including industry trends, strategies, and products to ensure that assets are effectively and efficiently utilized.
• Provide technical expertise to peers and associates on the overall infrastructure architecture.
• Responsible for Sizing Analysis and trends of the usage of the Siebel application.
• Responsible for monitoring processes and procedures of the Siebel application

Confidential, New York

Technical Architect

Responsibilities:

• Working closely with Solution designer to understand business requirement.
• Worked on Technical design and prototyping solutions as per requirement
• Managed team of developers and mentor for successful achieve the delivery dates.
• Worked as a Build Manager and monitor day to day development work
• Worked as a Solutions Architect
• Worked on CTI prototype and development for new functionality
• Worked on CTI Genesys integration.
• Worked on modifying Events and Commands based on the business requirement
• Worked on 4 way conferencing, updated events and commands for the same
• Worked on escript and configuration

New York, NY

Responsibilities:

• Participated in Client Meetings to understand Business Requirements and presented the proposed solution to business sponsors.
• Analyzing requirements
• Prepare Software Requirement Specification
• Involved in preparing Business Process Flow Diagram (Process Modeling)
• Performed Gap Analysis.
• Involved in Data Modeling (ER Diagrams) based on business requirements.
• Demo OOTB functionality.
• Work on prototype and Proof of Concept (POC).

Confidential, Bethesda, MD

Technical Architect and Siebel Administrator Lead

Responsibilities:

• Managing Confidential QA Environment.
• Managing every week new build and release
• Working closing with DBA and Testing team for any issues
• Understand the requirement and test case for eHospitality application
• Server administrator - installation, repository migration.
• Environment Configuration Lead
• Managing Offshore and onsite resources
• Gap analysis of requirement and development work.
• Provide technical expertise to peers and associates on overall application
• Responsible to identify difference of environment from Confidential QA and Client environments
• Resolve environmental issues (Workflow,Server component, Document Server)
• Deal with Test infrastructure and Data team for conversion and DB issues.
• Technical expert and environment advisor.
• Managing the QA process,build new process to streamline the testing process
• Worked as Technical lead for design phase.
• Created a prototype for complex requirement and mentor team member with technical solutions.
• Created a design build process and worked closely with project manager to streamline it.
• Help customer administrator to install and resolve issues with Siebel 8.0 GESM product.

Confidential, Washington, DC

Siebel Administrator/Technical Architect

Responsibilities:

• Server Administrator lead responsible for managing a team of 5
• Experience in Siebel server installation, Upgrades, Repository Migration (devToProd), creating and distributing Siebel Anywhere Kits to the clients, Identifying and troubleshooting specific performance issues.
• Detail understanding of Siebel architecture on Microsoft platform including OM configuration, SWE, Server components, Resonate.
• Strong knowledge in Microsoft SQL Server database Administration and able to identify SQL Server database specific issues related to Siebel processes and worked with DBA group in resolving those issues.
• Experience in dealing with Siebel Support and Expert services.
• Establishing and maintaining application/information practices and standards that support Siebel.
• Maintain expertise in the area of architecture, including industry trends, strategies, and products to ensure that assets are effectively and efficiently utilized.
• Provide technical expertise to peers and associates on the overall infrastructure architecture.
• Responsible for Sizing Analysis and trends of the usage of the Siebel application.
• Responsible for monitoring processes and procedures of the Siebel application.
• Provide guidance to off-shore development team and help troubleshoot development issues Life Science Industry

Confidential, Parsippany, NJ

Siebel Analytics Technical Architect and Siebel Configuration Lead

Responsibilities:

• Worked with Business to understand the requirements
• Manage team of 4
• Created the Business Model using star schema.
• Created Fact and Dimension tables based on the requirements.
• Modified existing Fact and Dimension tables.
• Worked on Repositories, Physical, Logical and Presentation Layer using Siebel Analytics Administration tool
• Created Primary keys, Complex joins in Business layer.
• Involved in creating Dimensions in the Business Model and Mapping Layer
• Developed role based Dashboards
• Worked on configuration of web catalog file
• Developed Reports, Filters, Dashboards and ibots using Siebel Analytics Web
• Integrated Analytics with Siebel CRM application.
• Configured Applets, Views, Screens and Applications in the Siebel Tools
• Modified standard SIEBEL business objects and created new objects
• Created and configured business objects, business components, screens, views, applets, multi-value links and MVG to reflect all the changes made according the requirements.
• Configured Joins, Links, Pick lists and Drilldowns as a part of customization
• Created Static and Dynamic Pick Lists
• Used eScript for data validations and additional functionalities
• Configured Thread Bar and History Bar for effective navigation

Confidential, Mt Olive, NJ

Siebel Analytics Technical Lead and Siebel Administrator

Responsibilities:

• Technical Production support and maintenance of the application.
• Global coordination with all the teams
• Monitoring daily informatica loads and troubleshooting issues.
• Working as a Siebel Analytics administrator to set up users, groups, access privileges and query privileges.
• Provide to offshore candidates about the application.
• Migration of repository and webcat from test to production
• Migration of informatica sessions and mappings from test to production.
• Merging of repository and webcats and web administration
• Developed role-based dashboards, pages for Managers and Business Heads to track sales volume and event performance.
• Development of new reports and pages and troubleshooting issues with metadata
• Customization of pre-built dashboards.
• Managed the Overall Architecture of Mercury V4.0 Implementation at Mars Inc.
• Installation of the Siebel Environment including Siebel Servers, Informatica and Siebel Analytics across the environments.
• Perform migration tasks including migration of databases, workflows, repositories and schemas to new environments
• Loaded third party data through EIM and handling 24 Interfaces.
• Development of technical team processes for code migration and testing environments.
• Managed and Troubleshooted the Remote environment and prepared Siebel Anywhere Upgrade Kits for Remote Users.
• Automated the Repository Migration Process across the environments consistently.
• Created a utility to monitor the Transaction Processor and Transaction router component.
• Wrote a Mobile Client synchronization automation script.
• Automated the functionality including Populate Locks, Build Tree Process of eConsumersector by developing external scripts and scheduling those scripts through Maestro.

Confidential, Beverly, MA

Senior Configurator and Business Analyst

Responsibilities:

• Coordinated with the offshore team in providing resolutions to issues, fixing bugs and daily updates on changing design along with development
• Participated in Development Iteration Reviews conducted periodically during the development phase
• Onsite-offshore model, had to test the design and development before the actual development was done at offshore.
• SRF files and sif files were received on weekly basis from offshore, which had to be updated, and weekly build had to be replicated on the development server onsite.
• Unit testing on the development server to report issues and resolve issues on a daily basis
• Gathering requirements for the main functionality from various business groups
• Understanding the AS IS process and designing the TO BE process for incorporating the existing integration with Siebel in MS Visio
• Designed Siebel Technical Design Documents for requirements that were discussed in the discovery phase
• Created design documents for all of the Configuration, Workflow, Assignments, and reports.
• Created Logical Entity relationship diagram based on the requirement
• Created data dictionary based on requirements
• Created Applet, Screen, Views design documents
• Created prototype based on the requirements
• Created and maintained BC mapping sheet.
• Prepared the Repository for merge by logging into Siebel tools and selecting the ‘Prepare Repository Option
• Configured Visual Source Safe for version control of projects in tools
• Siebel reports server and Actuate report server configured and maintain the users, roles and privileges for users.
• Performance Tuning for Siebel Configuration, Assignment Manager, EIM, Escript and Actuate reports
• Created workflow policies, workflow groups using workflow manager to automate the process the rules were defined and created workflow process using the Siebel workflow administration.
• Used the process designer to create the steps for the workflow process
• Used the process simulator to test the workflow and activated the workflow.
• Created Assignment Objects and modified the existing ones using assignment manager and Siebel tools.
• Configured assignment object, assignment criteria, assignment rule, worked on defining the position and position skills for assignment.
• Created Assignment rules and assigned it to the assignment candidates.
• Invoked the Assignment Manager in Batch Mode
• Configured event logs to view results

Confidential, Houston TX

EIM Lead/Report Lead/Configuration specialist

Responsibilities:

• Siebel EIM to load the data from Legacy to Siebel Database.
• Performance Tuning of Database / Queries for better performance.
• Drastically Improved users’ throughput by tuning the application & database
• Involved in design and data mapping for the data loads
• Configured IFB files and prepared batch files to run EIM process in batch mode.
• Developed scripts for loading different entities from flat files into Siebel EIM tables
• Data mapping from legacy system to Siebel EIM table.
• Both EIM tables and Siebel tables were extended to add based on functionality.
• The columns were mapped using Siebel tools
• EIM batch files were run in parallel to speed the loading data in base tables
• Troubleshoot EIM process failures by investigating EIM log files and making appropriate changes i.e. fixing failed batches (if row stat=’IN PROGRESS’).
• Extensively used SQL language to make sure data accurately loaded into EIM tables and Siebel base tables
• Coded Siebel VB Code to modify the existing look and feel of the applet, screens, Views as per user requirement.
• Done basic Configuration using Siebel tools, Generated Applet, Screens, and Views. Creating Business components, generating links, Creating Pick Applet, Multi Value Groups
• Created Smartscripts for intake
• Configured Applets, Views, Screens and Applications in the Siebel Tools
• Modified standard SIEBEL business objects and created new objects
• Created and configured business objects, business components, screens, views, applets, multi-value links and MVG to reflect all the changes made according the requirements.
• Configured Joins, Links, Pick lists and Drilldowns as a part of customization
• Created Static and Dynamic Pick Lists
• Used eScript for data validations and additional functionalities
• HP-UX 10.01
• Design and developed new reports using Actuate Developer Workbench.
• Was involved in Documentation for Actuate reports
• Configured Report object definitions and generated libraries for all of the reports using Siebel Tools.
• Used various Actuate Report features like Combined Data Stream, Composite Data Stream and filters like sort filter and select filter for complex reporting requirements.
• Create and published Component libraries for the system.
• Modified Standard Siebel Report using Actuate Workbench as per Business requirement
• Designed Smart reports, which included Organizational Chart, cross tab report.
• Overridden Method for Fetch, On Row, Start, and Finish.
• Configured Siebel reports and customized as per the client requirements

TECHNICAL SKILLS

Siebel

• Hospitality
• Public Sector
• Financial
• Call Center
• Marketing
• Consumer sector
• Insurance
• Real Estate
• Energy and Oil

Databases

• Confidential 8i,10g
• DB2 OS390/UNIX
• SQL Server 7.5, 2000,2003

Hardware & Operating Systems

• Windows NT
• Windows 2000
• AIX 5.3

Programming Languages

• Java
• Visual Basic
• UNIX
• PL/SQL

Engagement Experience

Tools:

• CRM Applications Development
• Data Conversion
• Server administration
• Project Management
• Siebel Technical Architect
• Informatica
• Win runner
• Visual Source Safe
• Siebel Analytics Server Architect
• Siebel Analytics Developer
• Siebel Configuration
• Informatica developer
• QA and Testing
• BI Publisher
• Maestro
• Actuate