SUMMARY

• 12+ Years of overall software experience with around 6 years in Data Migration \ Backend Development.
• Expertise across the Siebel EIM, SSIS and having good knowledge on Data Migration.
• Experience creating technical design documentation including data Mappings, flow diagrams, ERD, data dictionaries, etc
• Experience in Data Loads using SQL Loader, SSIS and Stored Procedure
• Experience creating functional design documents and process flow diagrams
• Expertise in Oracle, SQL Server, SSIS, SQL Loader
• Knowledge in technologies likes C, C++, Siebel UCM, Informatica
• Experienced on Data Analysis for Migrating data from legacy systems
• Experience in relational database concepts, Siebel Data Model.
• Experience in Conceptual/Logical and Physical Modeling.
• Strong knowledge on Siebel Data Model and Performed Data Mapping between Siebel and External Systems
• Skills in back - end testing using SQL queries on Oracle, SQL Server and generating reports to ensure data integrity and validate business rules.
• Experience in testing integration solutions for Data import, Export and Migration using EIM (Enterprise Integration Manager)

TECHNICAL SKILLS

Applications: Siebel, Siebel Tools.

Business Areas: CRM, Sales Force Management, HR & Payroll

Languages: Java, Java Script, C++, PL-SQL, VB

Operating Systems: Window 95/98/2000/NT/XP

Data Bases: Oracle 9i,Microsft SQL Server 7,2000.2005,SQL*Loader, PL/SQL

Other: HTML,XML

Reporting Tools: Business Objects and Cognos.

ETL Tool: SSIS

Internet Technologies: ASP,JSP

Other Tools: Visual InterDev 6.0, MS Office 2000

PROFESSIONAL EXPERIENCE

Confidential, Lexington, KY

Technical Lead

Responsibilities:

• Prepared Technical Design Document for migrating data from Source to Destination System.
• Prepared mapping Document from EIM Table to Base Table.
• Prepared Pre - Validation and post validation script to validate the data populated into EIM tables.
• Production Support

Environment: Siebel CRM 7.8, Oracle 9i

Confidential, Sunnyvale, CA

Technical Lead

Responsibilities:

• Prepared Technical Design Document for migrating data from Source to Destination System.
• Prepared mapping Document from EIM Table to Base Table.
• Prepared Pre - Validation and post validation script to validate the data populated into EIM tables.

Environment: Siebel UCM, Siebel CRM 7.8, Oracle 9i

Confidential, Lexington, KY

Offshore Development Lead

Responsibilities:

• Prepared detailed Technical Specification / Scope Document for migrating data from Source to Destination System.
• Prepared mapping Document EIM Table to Base Table.
• Created Stored Procedure, CTL and Batch file to Load data into EIM table.
• Prepared Pre - Validation script to validate the data populated into EIM tables. IFB file creation for EIM process. Script to validate the data imported by EIM process after execution
• Following are the entities imported into Siebel DB

Environment: Siebel Call Center, Siebel CG, Siebel Tools, Oracle 9i, SQL Loader.