We provide IT Staff Augmentation Services!

Technical Lead Resume

Lexington, KY

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.

Hire Now