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.