SQL Developer Resume Profile

SUMMARY OF PROFILE

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

BUSINESS CONSULTING EXPERIENCE

Worked with customer to identify the entities that has to be migrated from legacy system and to understand the business rules to transform the data as per the requirement.

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,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

Projects:

Confidential

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

Weekly Account and Materials data loads for the data from MDM System to Siebel.

Environment: Siebel CRM 7.8, Oracle 9i

Confidential

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

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
Account
Contact
Employee
Opportunities
Activity
Attachment
Consumer Goods
Catalog Category Levels
Period
Zero Base Lines

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

Confidential

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
Account
Agreement
Contact
Device
Service Request
Service Order

Environment: Siebel eMedical, Siebel Tools, Oracle 9i

Confidential

Responsibilities:

Worked with Data Migration Team to indentify the tables Columns relationship of following entities from siebel DataBase for migrating data from AXEM siebel DB to SalesLogix DB. Accounts contacts Address Contact Address

Environment: Oracle 9i,Siebel Sales, Siebel Tools.

Confidential.

Responsibilities:

Back end development for feature development and Data issues for the releases 6.0,7.0 8.0. Prepared tech design documents, writing unit test cases, developing SQL Agent jobs, executing the EIM tasks, unit testing the data and performance tuning.

Environment: MS SQL Server 2005

Confidential

Responsibilities:

Prepared detailed Technical Specification for migrating the data from AS-IS to TO-BE System.
Prepared mapping Document for the following
Physical TO-BE to Logical AS-IS
Physical TO-BE to Physical AS-IS
Conversion rules required for Data migration Developed SSIS package for migrating data from AS-IS to TO-BE system

Environment: MS SQL Server 2005 and SSIS

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship