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