Technical Lead Resume

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

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

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.

Confidential

EIM Developer

Responsibilities:

Prepared detailed Technical Specification for migrating the data from Source to Destination System. Prepared mapping Document for the following.
Source to Destination
EIM Table to Base 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 eMedical, Siebel Tools, Oracle 9i