Profile Summary

• Around 7 years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Siebel and Data Warehousing using Informatica Powercenter.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Have extensively worked in developing ETL programs for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Understanding the business rules completely based on High Level document specifications and implementing the data transformation methodologies.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Extensive experience and knowledge in Siebel Design and Development including Requirements Gathering, Analysis, Configuration, Testing, Migration, Administration and Deployment for Siebel Enterprise.
• Strong knowledge and experience in Siebel EIM developing Configuration ifb files and EIM jobs.
• Proficient in developing and testing SQL, PL/SQL with various databases like Oracle,SQL server.
• Good understanding of Siebel UCM 8.1 / OCH. Involved in data migration for OCH and running BDM Workflows for Data Cleanse, Match and Standardization.
• Good understanding of Siebel Architecture and Data Model and proficient with Siebel Tools and Client in configuration and customization of Siebel Objects at multiple levels like Applets, Business Components, Screens, Views, Joins, Links, MVGs, Pick Lists and Drilldowns.
• Diversified experience covering all stages of life cycle implementation: Requirements gathering and analysis, design, development, data conversion, unit, integration and system testing, end user testing/training, Implementation, Post-implementation support.
• Have excellent analytical, problem solving, communication and interpersonal skills with ability to interact with individuals at all levels.
• Motivated team player and leader willing to accept exciting new challenges and with sound understanding of the IT industry.

Skills

• CRM : Siebel 8.1/8.0/7.7/7.5 eConsumer, ePharma, Call Center,Telecom,Lifesciences
• Data Warehousing : Informatica PowerCenter 8.6/8.1.1/5.1.2
• Methodologies : Siebel EIM, Configuration,Scripting,Workflows
• Web Technologies : HTML, JSP, Jscript, Siebel eScript
• Utilities : Eclipse, Toad, SQL Plus,SQL Loader, EditPlus
• Tool : Visual Source Safe,CVS,Quality Center
• Languages : Java, HTML, XML,SQL, PL/SQL
• RDBMS : Oracle 9i,10g,11g,SQL Server
• Operating Systems : Windows ,Linux
• Processes : IBM's QMS Quality Management System

Training Certifications

• Oracle Certified Siebel 8.0 Consultant Certification
• ITIL V3 Foundation Certification
• Siebel 8 Essentials Training, Siebel 8 Case Study Training
• Siebel 7.7, Siebel Tools
• Oracle 9i SQL, PL/SQL, Database Tuning
• Linux Basics
• QMS training
• Java MVC, Struts, Spring, Hibernate, Tapestry

Professional Experience

Confidential

Java Developer

Key Responsibilities:

• Involved in understanding the requirements and preparing Detailed Design Technical documents, attribute mapping sheet for Enrollment Planning, Provisioning, Subject Transfer, Ancillary Supplies entities.
• Configured the UI for Subjects screen to add a Subject Transfer view for Subjects transferred from one site to another, a view to display the Subject transfer history for a particular subject.
• Configured UI for Provisioning to support associating multiple external systems to a Team History /Contact record and Protocol/Country /Site level.
• Developed Informatica Mappings using Source Analyzer, Warehouse Designer, Aggregator, and SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Scheduling and monitoring Workflows, validating the data loaded into staging tables as per the business requirements.

• Involved in writing huge procedures/IFB files for Inbound/Outbound data for Protocol/Site/Country Contacts and Team History.
• Involved in writing complex PL/SQL for Subject Load, Subject Visit load and Subject Transfer process.
• Preparing test data files, test scripts and doing end to end testing.
• Interacted with client/on-site team on regular basis.

Confidential

Role : Data Migration Consultant Environment

Key Responsibilities:

• Involved in understanding the requirements and preparing Detailed Design Technical documents, attribute mapping sheet.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup Connected and Un-Connected , Aggregate, Normalizer, Joiner, Router.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Played the key role of an EIM Analyst and Involved in Data Mapping for loading the Legacy data from staging to EIM tables to Siebel base tables.
• Worked with data IMPORT/EXPORT of legacy systems for Accounts, Opportunities, Service Request, Partners, and Activity entities.
• Involved in preparing control files, PL/SQLs, IFB files, batch script for automation.
• Preparing test data files, test scripts and doing end to end testing.
• Provided Knowledge sharing sessions to junior resources on Informatica/Siebel EIM and its usage in the project and received appreciation for the same.

Confidential

Role : Siebel Config/EIM Consultant

Environment : Oracle 11g, Siebel 8.0, Toad

Key Responsibilities:

• Involved in preparing LLD documents.
• Customized the vanilla application by creating and modifying business objects, business components, views, screens and applets for the entities Account, Address, Action, Opportunity, Service Agreement, and Orders.
• Created new BCs, modified existing BCs, configured the UI, extended columns in table.
• Prepared data mapping sheet, SQLs, IFBs for loading data using EIM jobs.
• Prepared the EIM jobs integrating with the external system for bulk import of data.
• Written SQL queries for validating the data and transformation logic as per business requirements.
• Configured buttons in UI and worked on scripting like date logic, populating few fields based on parent-child relationship for Service Agreement, Order entities according to business requirements.
• Prepared test data files and involved in end to testing. Was involved in all the phases of testing.
• Interacted with client/on-site team on regular basis.

Confidential

Role : Siebel Data Migration Consultant

Environment : Oracle 10g, Siebel 8.1.1, Toad

Key Responsibilities:

• Involved in preparing Detailed Design Technical documents.
• Involved in preparing Attribute mapping sheet, File definition format sheet for Address, Account, Contacts, Billing Profile and their association.
• Preparing technical design docs.
• Extending columns in Siebel SDH and Best version tables and creating EIM mappings.
• Preparing control files, SQLs, IFB files for running EIM job, running BDM workflows to cleanse/match data and move it from SDH to Best version tables and maintain cross-referencing
• Preparing test data files and doing end to end testing from external system to OCH system to CRM.

Confidential

Role : Interface Support-Team Member

Environment : Oracle 9i, Siebel7.8, Toad, Informatica 8.1.1

Key Responsibilities:

• Part of Level 2/3 team
• Supporting data interface related issues
• Dispatching interface tickets to the team members.
• Analyzing tickets, replicating the issue in local environment, and giving the user a solution as quickly as possible depending on the severity of the tickets.
• Working on EIM Change request for enhancement and bug fixes Creating CR, test plan, test labs using Quality Centre and implementing the CR in Production, after getting necessary approvals
• Preparing data load report for different affiliates Spain, Italy, UK, Germany, Brazil for daily monitoring purpose
• Internal Reviewer of Test Scripts, Test Lab CR's for EIM related tickets.
• Have performed Data Analysis using Informatica ETL tool involving simple and complex ETL mappings and handled ETL development activities.
• Have professionally coordinated with external interface teams on behalf of OneLilly for their cutover activities and ensured that OneLilly statuses are updated in the daily stand up meetings regularly.
• Have attended Client calls CCB to present the change requests and get appropriate approvals.
• Have provided Knowledge sharing sessions to the new resources on Informatica ETL tool and its usage in the project.

Confidential

Role : Siebel EIM Consultant

Environment : Oracle 9i, Siebel8, SQL Loader

Key Responsibilities:

• Preparation of Design Documents.
• Preparing control file for loading data to staging tables through SQL Loader.
• Writing PL/SQLs to perform validations according to business requirements.
• Creating custom tables,Extending columns in base tables and mapping them to EIM tables.
• Preparing IFB files, batch script, and stored procedures.
• Preparing sample test data for unit testing and executing EIM job and testing results.
• Involving in Unit Testing, Maintenance and Online interaction with clients.

Confidential

Role : Siebel EIM Consultant

Environment : Siebel 7.5, Oracle 9i

Key Responsibilities:

• Studied the requirement and high-level design document and prepared the Low-level design document to configure the application and interfacing of the system with external systems with Siebel Integration capabilities.
• Customized the out-of-the-box using Siebel Tools creating and modifying business objects, business components, views, screens and applets.
• Involved in the configuration of Static Dynamic Picklists using Joins and LOVs.
• Customized Pick Applets, Associate and Shuttle applets and configured MVGs using Links, MVLs and MVFs.
• Involved in Administration activities migrating the repository from development to testing environment, and assisting the production support team during deployment activities.
• Customized Business Components, Business Objects, Applets, Picklists, Links and Joins. Created new Views and Templates for Applets. Customized Views related to Accounts, Events, Annual Discounts, Products and Funds modules.
• Created and extended custom columns in Tables.
• Performed Data transformation for import and export data to and from Interface tables respectively INBOUND/OUTBOUND . Involved in data loading process Inbound and Outbound through IFBs in Siebel EIM.
• Involved in the creation and execution of interface mappings, sessions through Informatica Powercenter.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sequence Generator transformations.
• Used Server Manager to schedule sessions and batches.
• Extensively involved in writing stored procedures to implement business rules and validations during data load.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Involved in testing and fixing bugs of interfaces using Siebel log files.
• Have provided extensive support by performing health check-up servers , data clean-up and resolving the high priority issues.
• Prepared technical documents interacted with client/on-site team on regular basis.
• Documented various issues resolved for future reference.

Confidential

Role : Siebel EIM/Config Developer

Environment : Siebel 7.7.2.9, Oracle 10g,Toad

Key Responsibilities:

• Created Views with visibility All Across and My Organization Views .
• VINCI was deployed multi-lingual, the application required creation of symbolic strings, and created them where required.
• Siebel VB scripting was written at BC level to update selected fields based on requirements.
• Created and extended columns, created joins, join fields and exposed on applet.
• Was involved with System Integration Testing for the release.
• Prepared technical documents.
• Interacted with client/on-site team on regular basis.
• Documented various issues resolved for future reference.

Confidential

Role : Java Developer

Environment : JDK 1.5, JSP, Servlets, XML, HTML, Jscript, Oracle 10g

Key Responsibilities:

• Only resource for this maintenance project.
• Analysis of maintenance requests.
• Preparation of estimate.
• Database design.
• Preparation of LUT/RQSD.
• Coding.
• Preparation of Test Reports.
• Unit Testing.
• Deployment of package as well as db scripts in both offshore and onsite servers and testing.
• Client interaction.

Confidential

Role : Java Developer

Environment : JDK1.4.2, Tapestry3.0.2, POJO class, Hibernate3.0, Spring1.2, Oracle 10g

Tools : Apache Tomcat 5.0.28, Eclipse 3.1, Toad, EditPlus

Key Responsibilities:

• Preparation of estimate, LUT for maintenance requests MR .
• Coding.
• Preparation of Test Reports.
• Unit Testing.
• Deployment of packages in offshore, onsite servers and testing.
• Release.