Summary:

• More than 15 years of experience in IT industry and more than 10 years as a Siebel/Actuate/OBIEE/BI Publisher Consultant.

• Six years of experience, strong in design, development and upgrade skills in multiple Actuate Reporting, custom scripting and parameterized, Crosstab, Master Detail etc. reporting Systems. Experience in Actuate to BI publisher conversion. Also developed new BI reports according to Business requirements.

• Strong Siebel skills with experience in Call Center, Siebel Financial Services, Field Service, Siebel Sales, Siebel Automotive, EIM, workflow management, Assignment manager. Experience in business components, business objects, applets Views, Screen, eScript and reporting using Actuate.

• Experience in implementation and customization of Siebel 7.x, Siebel 2000 Siebel 99.
• Good knowledge and working experience with Application Upgrading from Siebel 6.3 to Siebel 7.5
• Strong analytical skills used in business and requirements analysis for a variety of industries. Worked with Actuate e. Report Designer professional, eSpreadsheet designer, Actuate Active Portal, Actuate eReport Server, Actuate iServer, Actuate Management Console, Actuate e.Spreadsheet Engine.

• Experience and knowledge with web servers/proxy setup and administration such as Apache, Tomcat, IBM Websphere, IIS, PWS etc.

• Experience in developing stored procedures using PL/SQL, T-SQL and calling them from Actuate.
• Experience in analyzing the data, performance tuning the Actuate Reports and related SQL Queries.
• Experience in Banking, Health Care, Manufacture Industries.
• Strong technical skills in Java,VB, HTML, Java Script, VB Script, Crystal Reports, ASP, JSP, XML, Servlets, VBA and other web technologies.

• Strong database knowledge in Oracle, SQL Server. Knowledge in ODBC connectivity.
• Highly skilled in Oracle DBA activities like installation, Tablespace creation and management, performance tuning, backup recovery, RMAN, database triggers and procedures etc.
• Worked with windows based systems and UNIX systems.
• Good Experience in Manual and Automated-testing using WinRunner, TestDirector, QuickTestPro, Load Runner.
• Good experience in the development of test plans and test cases and possess expertise in Business Functionality Testing, Volume Testing, Stress Testing, Load Testing, Integration Testing, Documentation and Regression Testing.
• Very strong analytical and communication skills. Strong documentation and testing skills.
• Can work in a team and as an individual.

Skill Set and Experience:

Experience:

Confidential

Sr. Siebel/OBIEE/BI publisher

• Presently Working for Cummins as Sr. Siebel/OBIEE/BI publisher developer on Siebel Automotive module
• Gathered business requirements for reports, created Impact analysis Documents, High Level Solution Documents and Solution design documents.
• Created Integration objects and deployed on Server.
• Developed reports and attached reports to Siebel views.
• Created XML, RTF and XLIFF files for reports development.
• Used BIP Template coding for business requirements.
• Used sub template concept for BI publisher reports.
• Developed multi-lingual reports for Romania, Sweden, France, Nether Lands and Norway.
• Uploaded related language files on BI Publisher Server.
• Created various reports like Job Plan report, Service Invoice with Detail, Item Summary, Fixed Price Summary, Amount Summary, Credit Memo, Customer Quote, Parts Quote, Parts Return, Claims and Whole Goods Document Reports.
• Created customized BI publisher reports by using Analysis and Excel sheets in OBIEE 11g. Created JDBC connection and assigned roles.
• Created Datamodels, Datasets, Parameters, Lovs for BI publisher reports.
• Attached Reports to Dashboards. For Parameters used BI publisher link instead of creating Prompts.
• Used weblogic console for creating users and EM for Application roles, policies and log files.
• Migrated catalog Report folder from Dev to test, UAT and Production.

Technical Environment: Siebel Automotive 8.1.1.7, Siebel Tools, Clear case, MS Office, Oracle, OBIEE 11g, BI Publisher, Solaris.

Confidential

Sr.Siebel/Actuate/BI publisher developer

• Worked for NARA as Sr. Siebel Actuate/BI publisher developer by using Siebel Sales 7.8
• Involved in OLTP Actuate BI Publisher and also in Siebel configuration.
• Involved as one man team for Actuate/BI publisher reports.
• Translate the business requirements into system requirements for the development or configuration.
• Involved in creation of Technical Design Documents based on functional specifications.
• Estimated the efforts of the requirements given by the client, by using Function Point analysis.
• Prototypes for Demos to client.
• Created Integration Objects in Siebel tools and deployed in Siebel client.
• Developed barcode reports, chart reports, Parameterized, Master Detail reports.
• Used sub template logic for complex report.
• Uploaded reports on report server.
• Generated reports in PDF format.
• Developed position based reports that will have 30 labels on each page where user can select any position from where labels can be started printing.
• Configured BIP connect strings as OBIEE source.
• Installed BIP as standalone and configured to connect to Siebel
• Attached reports to Siebel views.

Technical Environment: Siebel Sales 7.8, Siebel Tools, Oracle10g, Actuate 7, OBIEE 10g and BI Publisher, SP2, Windows NT 2003, Sun Solaris.

Confidential

Siebel/BI publisher Specialist

• Worked for GDF Suez energy as a Siebel/BI publisher Specialist by using Siebel Energy Module
• Gathered requirements from Business and Prepared Technical Design Documents for the business requirements.
• Created Business Components, Business Objects, Links, PickList, Screen, Views, Applets and Integration Objects by using Siebel tools.
• Created Reports Meter Summary Draft, Sales template Internal, Custom Template External, Product Presentment Generic Complex Reports.

BI XML Publisher Experience:

• Installed BI publisher Software.
• Created new reports from scratch by using BI publisher.
• Converted already existing crystal reports to BI publisher.
• Created Integration Objects for new Reports.
• Created new report templates designs by using MS Word.
• Used sub-template calling method for the report Product Presentment Generic PPMain.rtf is calling sub-templates PPProd1.rtf, PPProd2.rtf, PPSummary.rtf, ProductOverviewChoicesTemplates.rtf, RiskSpectrum.rtf .
• Created parameterized passing 9 parameter values with LOV, checkbox, label, TextArea , Scheduling and Custom Graphical reports used custom graph pyramid and spectrum with scaling values .
• Created integration objects in Siebel tools and deployed IO on Siebel client.
• Migrated reports from Dev to Test, Test to UAT, UAT to Production.
• Registered .rtf files by using Report Template Registration View and also Integration objects. Created XML file from the sample data file generation view and loaded it in .rtf file.
• Used generate XLIFF XML Localization Interchange File Format for exchanging localization data.
• Attached report to Siebel views by using view association.

Technical Environment: Siebel Energy 8.1.x, Oracle, MS Word, BI publisher, Crystal Reports, TOAD, Excel.

Confidential

Siebel/Actuate/OBIEE/BI publisher Developer

• Developed Service, Work orders, MOU, Inspections, Equipment, Assets applets, views and Screens.
• Developed 21 reports are in SGRM and 43 reports are in iNeed and 5 reports in COE projects.
• By using Siebel tools added required fields in Business component for required reports.
• Created required report Library files .rol from Siebel tools.
• Added reports to the required Siebel views and compiled SRF file.
• Designed reports in Actuate eReport Designer professional, wrote various methods and uploaded them on report server in DEV, TEST, UAT and PROD environment through actuate management console and tested reports.
• Used agile method for project work development.
• Involved in OBIEE installation, RPD development, Created Dash boards and attached Reports.
• Attended report status meetings.

• Converted all actuate reports to BI publisher by using Conversion Assistant utility.
• Created new reports from scratch by using BI publisher.
• Created Integration Objects for new Reports.
• Created new report templates designs by using MS Word.
• Created parameterized, Scheduling and Graphical reports.
• Converted actuate layout .bas to rtf format.
• Created integration objects in Siebel tools.
• Opened several SRs in Oracle Support for BI Publisher related issues and involved in meetings with Oracle for workarounds.
• Registered .rtf files by using Report Template Registration View and also Integration objects. Created XML file from the sample data file generation view and loaded it in .rtf file.
• Used generate XLIFF XML Localization Interchange File Format for exchanging localization data.
• Attached report to views by using view association.

Technical Environment: Siebel Public Sector 8.0/8.1.x, Oracle, Agile, MS Word, OBIEE 11g/BI publisher, Actuate Report Designer Professional 8.0, TOAD, Xythose, JIRA, Excel.

Confidential

Siebel/Actuate Developer

Worked for Capital Blue Cross as a Siebel/Actuate Developer.

• Developed Opportunity, Compliances, Contact, and Accounts related Reports

• Developed Demographic Summary Report, Demographic Underwriting Census Report, Demographic New Business Detail Report, Demographic Underwriting Rate Report, Full SSR, Renewal SSR, Termination SSR, SSR Report Control sheet
• Installed Actuate Software.
• Evaluated reporting solutions for the client customized reports.
• Gathered report requirements from the business users.
• Given Actuate training to the internal IT developers.
• Created Conceptual Design and Detail Design documents for Work Requests.
• Developed Implementation Plan IP documents for Reports to be implemented by Production Support team.
• Analyzed project requirements developed Base Libraries .rol and report designs .rod , .sod with all the necessary controls and features required for the reports.
• Overwrote Fetch, Compare, Start, Finish, OnRow, OnRead etc methods to generate a Custom Reports.
• Developed Grouping, sub reports, Parameterized, Master Detail, Cross-tab reports etc
• Uploaded Reports to report sever by using Actuate management console.
• Generated Reports in PDF and excel format based on client requirements.
• Used MS Visual Source Safe for report file version control.
• Created Quotes Related Proposal like Simple Steps to Enrollment Check List, Commercial Proposal, SecureRx Proposal, LVC Proposal, SeniorBlue PPO Proposal, SeniorBlue HMO Proposal, Compliance Revised Rate Sheet and Commercial Renewal Proposal
• Created Special Business components for Proposals to pull specific Product related Highlight sheets attachments automatically.
• Configured required fields in Siebel tools for Proposal.
• Created Bookmark fields, search conditions for Proposal.

Technical Environment: Siebel Financial Services 7.8, Siebel Tools, Word 2007, Excel, Oracle 9i, and Actuate ERD pro 8.0, MS Visual Source Safe, Active Portal, iServer, eSpreadsheet Designer, JSP, VBA, Mercury Test Director 8.0.

Confidential

Actuate Developer

• Created and Updated Oracle Stored Procedures and Report Tables.
• Created Conceptual Design and Detail Design documents for Work Requests.
• Developed Implementation Plan IP documents for Reports to be implemented by Production Support team.
• Analyzed project requirements developed Base Libraries .rol and report designs .rod , .sod with all the necessary controls and features required for the reports.
• Analyzed cognos report-net based reports like cross tab, list, repeater and re-created them in actuate.

• Installed Actuate Software.
• Evaluated reporting solutions for the client customized reports.
• Gathered report requirements from the business users.
• Extensively used Callidus libraries for reports to be displayed in TrueCompViewer environment.
• Overwrote Fetch, Compare, Start, Finish, OnRow, OnRead etc methods to generate a Custom Reports.

Confidential

• Worked with enhancements of TrueComp Viewer, Actuate Active Portal, eReport Server and eSpreadsheet designer.
• Used tables like Credit, Measurement, Incentive, Period, Balance, Balance Payment trace, Deposit, Payment, Position, Position Assignment, and Participant etc for developing Reports.
• Developed reports like Order detail, Bonus Payments, Pay Roll, Comp Statement, Approved Adjustment, Module Report, Employee Ranking, Partner Performance, Partner Ranking, Sales Incentive Summary, Performance Detail Reports etc.
• Created Database SQL scripts for Update, Insert, Delete etc.
• Generated Reports in both excel and pdf formats.
• Developed some internal reports through Java/JDBC.
• Created test scripts and Report unit test documentations.
• Uploaded updated Version Control DD, CD and IP documents in sharepoint.
• Worked on version control software called Harvest. Uploaded all script files and Report files to Harvest Package.
• Involved in System test and UAT, resolved issues and closed tickets in Mercury Test Director.
• Helped production support team resolve Production Issues.
• Monitored daily report runs. Fixed failed reports.
• All the above reports were developed from data available in TrueComp data mart. All these reports were developed to be viewed in TrueComp Viewer.

Technical Environment: Oracle 8.x, TrueComp 3.x/5.x and Actuate e.Report Designer Professional 5.0/8.0, Mercury Test Director 8.0, eSpreadsheet Designer, Actuate e.Spreadsheet EngineVBA, iServer, Active Portal, JSP, Servlets, Excel, JAVA, AllFusion Harvest Change Manager 7.1.

Confidential

Siebel/Actuate Developer

Worked for Siemens Medical Systems as a Siebel/Actuate Developer.

• Analyzed project requirements developed Base Libraries .rol and Report object design .rod with all the necessary controls required in the project.
• Created Single Report but it works like in 19 ways according to client Requirement.
• Developed Proposal related Reports by using Actuate.
• Developed Opportunity, Proposals, Orders, Accounts, Contacts and Quotes related Reports.
• Installed Actuate Software.
• Evaluated reporting soulutions for the client customized reports.
• Gathered report requirements from the business users.
• Created Position based Reports.
• Updated Siebel Application fields from Actuate Report.
• Upgraded Reports from 4.x to 6.0/7.0.
• Developed Grouping, Parameterized, Master Detail, Cross-tab reports etc.
• Worked with Actuate Active Portal and eReport Server.
• Scheduled Report runs on Actuate eReport Server.
• Used Sequential, Grouping, Single Input filter, Composite DataStream etc.
• Uploaded rox files through Actuate management console.
• Resolved Production issues.
• Involved in System test and UAT, resolved issues and closed tickets in Mercury Test Director.
• Created test scripts.
• Attached Reports to the Views.

Technical Environment: Siebel Sales 6.x/7.7, Siebel Tools, DB2, and Actuate e.Report Designer Professional 6.0/7.0, Mercury Test Director 8.0.

Confidential

Siebel/Actuate Developer

• Configured Siebel repository objects like views, screens, applets, business components, joins, MVLs, etc .
• Configured joins, links, workflows, LOVs etc.
• Analyzed project requirements developed Base Libraries .rol and Report object design .rod , .sod with all the necessary controls required in the project.
• Installed Actuate Software.
• Evaluated reporting soulutions for the client customized reports.
• Gathered report requirements from the business users.
• Developed Grouping, Parameterized, Master Detail, Cross-tab reports etc.
• Overrode Fetch, Compare, Start, Finish, OnRow, OnRead etc methods to generate a Custom Reports.
• Developed reports through Oracle stored Procedures.
• Created new Actuate reports which are in Crystal reports format.
• Scheduled Report runs on Actuate eReport Server.
• Uploaded rox files through Actuate management console.
• Attached Reports to the views and Dashboards.
• Created Page Level Security Reports.
• Worked with Actuate Active Portal and eReport Server
• Developed Reports for field sales compensation, Sales Rep Performance Overview Report, Seasonal Rep Performance Report, Strategic Team Performance, Invoice Line Item Detail Inline Reps, Invoice Line Item Detail Golf Reps, Pay Detail Report, Performance Analysis, Sales Rep Payout Summary etc.
• Developed some internal reports through Java/JDBC.
• All the above reports were developed from data available in True Comp data mart. All these reports were developed for them to view in True comp viewer.

Technical Environment: Siebel Incentive Compensation Management 7.7, Siebel Sales, Oracle 9i, Crystal Reports, JAVA, VBA, Servlets, Actuate e.Spreadsheet Engine, eSpreadsheet Designer and Actuate e.Report Designer Professional 7.0.

Confidential

Siebel/Actuate Developer

• Designed and Created Business Components BC , Business Objects BO , Screens, Views, and Applets
• Developed Orders, Accounts, Contacts, Opportunity, Quotes, Pricing and Proposal etc.
• Worked for Philips Medical systems as a Siebel/Actuate Developer on Siebel Sales Module version 7.7 and Actuate 6.0/7.0
• Designed and Created List Applets, Form Applets, Entry Applets, Tree Applets, and Chart Applets
• Designed and Created Toggles, Drilldown objects, created static pick lists, Dynamic pick lists.
• Created MVG's, MVL's, Links, Joins.
• Invoked workflow using eScript.
• Used Siebel Business Services and Validation Routines Siebel eScript .
• Data Models, Data Mappings, Unit Test Case Scenarios and identification of Informatica process flows and transformation rules.
• Extensively used ETL to load data from Oracle databases and Flat files to Siebel eim tables.
• Informatica is used for cleansing, transforming, integrating and loading to siebel EIM tables from staging database.
• After Data migration to siebel application Reports were created through Analytics
• Data mapping from various sources like etc to staging database and than to EIM tables using Informatica 6.2
• Was involved in the analysis and design of various interfaces
• Developed Reports for Orders, Accounts, Contacts, Opportunity, Quote and Proposals etc.

Confidential

• Analyzed project requirements developed Base Libraries .rol and Base Document .rod with all the necessary controls required in the project.
• Worked with Actuate Active Portal and eReport Server.
• Scheduled Report runs on Actuate eReport Server.
• Uploaded rox files through Actuate management console.
• Created Multilingual Reports.
• Attached Reports to the views.
• Created RPD, Dash boards and Reports by Siebel Analytics now calling as OBIEE

Technical Environment: Siebel Sales 6.x/7.7, Siebel Analytics, Siebel Tools, Oracle 9i, and Actuate e.Report Designer Professional 6.0/7.0.

Siebel/Actuate Developer

• Used Siebel Business Services and Validation Routines Siebel eScript .
• Created MVG's, MVL's, Links, Joins
• Designed and Created Business Components BC , Business Objects BO , Screens, Views, and Applets
• Created Accounts, Activities, Categories, Contacts, Milestone, Projects Opportunity , Properties, and Prospects etc.
• Worked for Marriott, Bethesda, MD as a Siebel/Actuate Developer on Siebel Sales Module version7.7 and Actuate 7.0
• Designed and Created List Applets, Form Applets, Entry Applets, Tree Applets, and Chart Applets
• Designed and Created Toggles, Drilldown objects, created static pick lists, Dynamic pick lists.
• Invoked workflow using eScript
• Migrated reports from Access and Actuate 4.1 to Actuate 7.0.
• Analyzed project requirements developed Base Libraries .rol and Base Document .rod with all the necessary controls required in the project.
• Used Composite DataStream.
• Used Sequential, Parallel, Grouping, Parameterized, Master Detail, Single Input filter etc. Worked with Actuate Active Portal and eReport Server.
• Scheduled report runs on Actuate E-Report Server.
• Uploaded rox files through Actuate management console.
• Attached Reports to the views.
• Train employees to develop and maintain actuate reports.

Technical Environment: Siebel Sales 7.7, Siebel Tools, Oracle 9i, and Actuate e.Report Designer Professional 7.0.

Confidential

Siebel/Actuate/Analytics Developer

• As an Siebel/Actuate/Analytics Developer involved in the following activities:
• WebMD is healthcare technology providing services like INTERGY, ULTIA, client services and also HIPPA Health Insurance Portability and Accountability Act . This is a Siebel sales as well as Siebel Call Center application. This application provides different services like help physicians automate appointment scheduling and billing of payers and patients maintain medical histories and charts and access healthcare information. And this also provides Clinical transaction services such as electronic prescribing and ordering and reporting of lab letters.
• Used Service, Contacts, Activities, Accounts, Products, Pricing, Campaign, Orders, Quotes etc
• Designed and Created Business Components BC , Business Objects BO , Screens, Views, and Applets.
• Implemented Application related WFs on Service Request Closure and Escalation of Activities.
• Implemented a Business Service for CTI Inbound functionality using eScript.
• Converted client requirement into Functional and Technical specifications and delve on schedule. Written Custom scripting and created parameterized reporting
• Created various reports like Standard, Group, Master detail, Parameterized Crosstab, Dynamic Crosstab, Scheduled reports.
• Generated Reports like Service Request, Account, Contact, Products, Orders, Quotes, Pricing, and Campaigns by using Actuate.

• Analyzed project requirements developed Base Libraries .rol and Base Document .rod with all the necessary controls required in the project.
• Developed reports using multiple input filters, procedures, composite data streams and created reusable objects for use across reports.
• Attached Reports to the Siebel Application Views.
• Customized Siebel Repository.
• Created Dashboards.
• Created Users and Groups
• Assigning permissions to users
• Worked with siebel Analytics Repository by setting preferences and Quering. Gathered information for building Business model
• Experienced in dimensional databases

Technical Environment: Siebel Call center 7.5.3, Siebel sales, Siebel Analytics, Siebel Tools, Workflows, eScript, Oracle 8i, and Actuate e.Report Designer Professional 6.0.

Confidential

Siebel/Actuate Developer

As Project Apollo, Pitney Bowes has embarked on the implementation of a Siebel Field Service, Siebel sales in order to transform its Customer Service organization. This is a far-reaching project with many touch-points across many other systems, groups and projects within the PB infrastructure. The project is currently scheduled to have two major releases - in November of 2003, to 300 Professional Service Users and 80 Technical Call Center Users, and in February of 2004, to 1500 Field Service Representatives and managers using a wireless application to perform traditional field service work. As part of the project, several legacy systems will be retired replaced by Siebel and data will be shared with many other systems, including SAP.

• Created User Interface and Business Object layers
• Used Service, Contacts, Activities, Smart Scripts, Products, Calendar and Accounts
• Designed and Created Business Components BC , Business Objects BO , Screens, Views, and Applets
• Designed and Created List Applets, Form Applets, Entry Applets, Tree Applets, and Chart Applets
• Designed and Created Toggles, Drilldown objects, created static pick lists, Dynamic pick lists.
• Created MVG's, MVL's, Links, Joins.
• Created workflow policies
• Implemented Application related WFs on Service Request Closure and Escalation of Activities.
• Designed and developed a batch WF for closing Web Related Questions for eService Application.
• Implemented a Business Service for CTI Inbound functionality using eScript.
• Design EIM specifications and performing the data mapping between interface tables to base tables.

• Involved in troubleshooting.

• Performed full life cycle development and implementation of Actuate Reports.
• Generated Reports like Service Request with Barcode, Activity, Account, Contact, Products, and Orders by using Actuate.
• Converted client requirement into Functional and Technical specifications and delve on schedule.
• Created various reports like Standard, Group, Master detail, Parameter and Crosstab reports.
• Migrated reports from Actuate V5 to Actuate V6.
• Developed reports using multiple input filters, stored procedures, and created reusable objects for use across reports.
• Analyzed project requirements developed Base Libraries .rol and Base Document .rod with all the necessary controls required in the project.
• Attached Reports to the Siebel Application Views.
• Generated Reports in PDF, HTML format.
• Uploaded .Rox files to the Report Server through Actuate Management Console.

Technical Environment: Siebel Field Service 7.5, Siebel Call center, Siebel Tools, eService, EIM, Oracle 8i, PL/SQL, Unix, Work Flows, and Actuate Reports 5.0/6.0.