We provide IT Staff Augmentation Services!

Business Information/data Migration Lead Resume

0/5 (Submit Your Rating)

Alpharetta, GA

SUMMARY:

  • Dedicated and motivated data architect/analyst seeking a position in a fast - growth company, where my knowledge and experience is used to improve the data management system of the company. I have 12 years of extensive Siebel and SalesForce.com CRM applications experience with proven ability in developing Data Models
  • Data Migration, Data Quality and Data Analysis for Master Data Management at the enterprise level. Expert in using SQL Loader, PL/SQLs, Data Loader, Informatica ETL in OLTP and OLAP (DAC) systems and Demand Tools for data analysis, merge and update for SFDC.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, APEX, SSIS, Windows & AIX Shell scripting

Software: UNIX, Oracle, SQL Server, Data Loader, Informatica Power Center, DAC, SFDC Demand Tools, SOQL, SQL Loader and Siebel EIM

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, GA

Business Information/Data Migration Lead

Responsibilities:

  • Advise MDM team on architecting and designing data interfaces that safely and efficiently transfer data into cloud environment
  • Prepared Data Governance for SalesForce.com and developed plans, strategies and standards for master data for Sales Force application
  • Developed automated process for data merging, data duplicate management for Sales Force application using Demand Tools
  • Updated SFDC Customer master data from third party Definitive source
  • Identified duplicate customers and built a strategy thru Demand Tools for merge
  • Partnered and collaborated with other teams (MDM team, business information architecture team and SFDC developers team) to provide best solutions by maintaining the best standards of practice
  • Led Sales Force technical team of Confidential Technology Solutions in configuring/writing triggers and improved/wrote test classes to increase overall code coverage of SFDC instance
  • Integrated data into SalesForce.com from multiple sources by using Data Loader, Demand Tools Experience architecting and by building solutions within the Salesforce portal
  • Integrated Sales Force application with Qualtrics (online survey tool)
  • Maintained Customer and Product data in Siebel Sales application, assisted MDM team in data quality, responsible for data accuracy and quality in Siebel using PL/SQL and EIM
  • Successfully executed and supported data migration between Siebel and Big Machines (CPQ)
  • Supported sales operation team with data related activities like mass insert maintaining data integrity, update, delete and merge
  • Partnered with all other teams ( Confidential DB team, Siebel technical team, Business analysts team, Sales Team, MDM team) and business users to provide best solutions for business requirements by maintaining the best standards of practice
  • Executed mass data cleaning/merging procedures by removing old or irrelevant data in consultation with the teams
  • Supported Siebel Analytics (OBIEE), DAC and Informatica Power Center

Confidential, Baltimore, MD

Integration Team Lead

Responsibilities:

  • Executed the design, data mapping, development and implementation of inbound and outbound interfaces by coordinating two-member offshore team
  • Was responsible for developing data models and automation of the interface jobs

Confidential, Alpharetta, GA

Data Migration Lead and Data Model Architect

Responsibilities:

  • Supported all the data loads of OLTP and LOAP jobs
  • Fixed all the data related issues by wring PL/SQL, modifying Informatica Mappings, IFB and shell scripts
  • Supported the whole automation process for OLTP and OLAP loads which involves Siebel, Informatica ETL, DAC, Oracle PL/SQL and UNIX shell scripting technologies
  • Developed monitors on Production servers
  • Designed and developed the whole automation process to bring every day transactions from Equicom database to OLTP and then OLTP to OLAP databases.
  • Led the two-member offshore team working on Power Center Informatica ETL tool
  • Responsible for design and development of one time and ongoing ETL mappings
  • Implemented the Siebel EIM batch loading logic
  • Increased the performance of the ETL mappings by tuning the jobs
  • Automated all the Informatica workflows

Confidential, West Kingston, RI

Interface Team Lead/Data Migration Specialist

Responsibilities:

  • As a senior resource in Data Migration Team, was involved in Design, Development, Unit Testing and Deployment. Participated and executed the entire project cycle from analysis to implementation and testing.
  • Responsible for complete data migration from source Siebel 6 to target Siebel 7.8.2, including Informatica ETL load and EIM load. Have good experience in design/development of migrating data from Siebel 6 data model to the EIM tables of Siebel 7.8 Data model.

Confidential, Cincinnati, OH

Siebel Integration Team Lead

Responsibilities:

  • Built and executed more than 25 inbound interfaces and 3 outbound interfaces were developed for the data processing for which 12 interfaces run daily

We'd love your feedback!