We provide IT Staff Augmentation Services!

Sql Developer Resume Profile

4.00/5 (Submit Your Rating)

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'd love your feedback!