SUMMARY

• 13+ years of progressive experience in the US in providing IT consulting to Fortune companies in Oil & Gas, Energy, Finance, Healthcare, Manufacturing as well as to Government sector entities.
• 13+ years of expertise in Data Conversion and Data Integration Architecture across large enterprises especially those with special data organizational requirements.
• Extensive experience architecting Data Integration and Data Conversion solutions including expertise in Oracle and/or SQL Server Databases and related tools such as Informatica, PL/SQL, Data loader and Complex SQL etc.,
• Expert in Data Conversions, Interfaces, and Implementations of SIEBEL CRM in automotive, sales, finance and call center modules
• Expert in Data Conversions, Interfaces, and Implementations of SALESFORCE.COM (SFDC) in Sales and Service modules.
• 5+ years as a Data Architect in designing, migrating and customizing business applications.
• Experience in Requirements gathering, Leading teams to define a solution, Collaboration with multiple vendors and in the end - users.
• 4+ years of expert experience providing Informatica Power Center solutions (5X to 9X) including core Development, Administration, Architecture and Upgrades.
• Knowledge of Informatica Data Quality (IDQ).
• 1+ years with Master Data Management (MDM) strategies and processes.
• Managed, Lead and Developed projects related to Data Integration, Data Conversions, Data Warehouses and Business Applications Implementations.
• Expert in working with offshore teams, multiple vendors, composite team build-ups and in delivering solutions successfully against aggressive time.

TECHNICAL SKILLS

Applications: Siebel 8.1/7.8/7.7.2.8//7.5 Tools, Configuration, Product Administration,EIM, Salesforce

Operating Sys: WIN 2000, WIN NT SERVER, Windows 2003 Server, WIN XP

Data Base: Oracle 11,10G, 9I, SQL Server 2000

ETL: Informatica 8.6, 9.6.1 OWB 10.2, PL/SQLBI QlikView 9.1

Languages: C++, JAVA, SQL, VB, Siebel eSCRIPT, PLC programming

Version Control: WinCVS2.0,VSS

Jobs Automation: Autosys, Application Manager

PROFESSIONAL EXPERIENCE

Confidential, San Mateo, CA

Data Migration Tech Lead

Responsibilities:

• Architect, Design and Create underlying data structures and data flows to customize MS Dynamics CRM business functionality.
• Architect, Lead and Develop data conversion and migration strategies usingInformatica and Salesforce data loader.
• Gather Business Requirements and translate them into Technical specifications.
• Design and Develop Source to Target Data migration mappings from legacy (SFDC objects) to target (MS CRM entities)
• Design complex SQL queries to assist end-users in data extraction.
• Supporting business and reporting teams with data and related issues for the conversion solutions.
• Implement ETL standards for the team and Validate and promote the development work into Production

Confidential, Carmel, IN

Solution Architect/Data Migration Architect

Responsibilities:

• Architect technical solutions based on the business requirements.
• Architect, Design and Create data models to support custom applications.
• Develop Data loader scripts for conversion of 13 year historical data using PL/SQL and SQL Loader scripts
• Architect, Design and develop Data Migrations and Conversions using Informatica power center.
• Migrated data from SAS to Salesforce.

Confidential, Albany, NY

Siebel EIM Lead/Data Migration Lead

Responsibilities:

• Expert on Siebel EIM data mapping debugging and improving EIM processes performance
• Strong in data analysis, data model of Siebel
• Worked on data mapping sheets to map IQ(source) fields to Target fields
• Oracle SQL/ PL SQL Scripts for Data Extraction, Configure EIM jobs
• Build or enhance Data Interfaces- Monitor Siebel DB and work with DBA
• Write Siebel EIM Routines for EIM Jobs.Identify EIM tables, create the ifb files, run the jobs and debug the errors.
• Create and modify Siebel EIM IFB files based on the requirements
• Maintain and Monitor daily batch load ETL processes. Implement enhancements, schedule changes and performance improvement activities for daily interfaces
• Extract the data to EIM Tables and run the EIM Task to load the data into Siebel Base tables.

Environment: Siebel Public sector, IP2016

Confidential, Alameda, CA

CRM consultant/Data Migration Lead

Responsibilities:

• Lead the data migration plan and Primary owner to get all Environment access for DM team members.
• Onsite point of contact of all DM related queries/concerns and independently drive Technical, design/functional discussion.
• Implement solutions to support and sustain the effectiveness of Salesforce.com datamanagement, deal registration, contacts, leads, campaigns, opportunities, dashboardsand reporting.
• Maintain Salesforce.com user roles, security, profiles and workflow rules.
• Maintain integrations between Salesforce.com, ERP, Point-of-Sales.
• Translate business goals to tools, reports, prompts and interfaces that support thosegoals
• Lead the data migration plan and Primary owner to get all Environment access for DM team members.
• Onsite point of contact of all DM related queries/concerns and independently drive Technical, design/functional discussion
• Working with Operations Manager and users to determine business requirements, provide administrative support and design /implement solutions in Salesforce.com CRM.
• Prepare data extraction/migration production go-live activity document
• Review all DM documents (such as design documents etc.) before final submission.
• Worked on Informatica to develop ETL mapping and transformations
• Worked on Salesforce Apex data loader to load data into SFDC
• Involved in analysis, gathering requirements for the High - Level design
• Created Workflow Rules, Page Layouts, Approval Process, Tasks, Email Alerts, Field Updates and Outbound Messages to manage the Workflow & Approvals.
• Created Profiles, Roles based on Organization role hierarchy and implemented Record-Level and Field-Level security and configured their sharing settings.
• Responsible for enabling network-based security and organization-wide list of trusted IP address.
• Created the workflows for automated lead routing, lead escalation and email alerts.
• Worked as enhancement team member and performed the roles of Salesforce.com Administrator in the organization.
• Worked closely with sales team and business analysts and performed detailed analysis of business and technical requirements and designed the solution by customizing various standard objects of SalesForce.com (SFDC).
• Involved in the maintenance of the previous versions of the product by addressing bugs and client issues.
• Defining integration architecture, documenting technical requirements, and identifying success criteria.

Environment: Oracle11, Salesforce.com,SQL tools, Informatica 9.6.1

Confidential, San Jose, CA

Senior Data Conversion and CRM consultant

Responsibilities:

• Lead Data Migration Efforts - Data extraction from Siebel CRM to Salesforce CRM.
• Involved in requirement gathering, data analysis, data cleansing and feasibility study
• Developed SQL and PL/SQL code to extract data from Siebel as per the business requirement
• Migrated data from Siebel to Salesforce using Informatica power center
• Worked on Jitterbit to develop ETL mapping and transformations
• Worked on Salesforce Apex data loader to load data into SFDC
• Preparation of project documents, Summary and status reports
• Worked on data mapping sheets to map Siebel fields to SFDC fields
• Designed Data insert /update and upsert logic while moving data to salesforce
• Worked on Siebel EIM to update existing data in Siebel
• Defect tracking and bug fixing
• Data cleansing on Account, Contacts and address
• Developed scripts to adjust data model changes between source and target system
• Troubleshooting issues related to Siebel and Sales force migration and database issues.
• Estimated Time Efforts for completion of implementing
• Porting the Siebel servers with TNT drive and Amazon S3 drive for Siebel attachments.

Environment: Siebel 8.1.1.11Call center, Oracle11, Salesforce.com,SQL tools1.5, TNT drive 3.5.3, Amazon S3,Jitterbit, Informatica 9.6.1, J

Confidential, Nashville, TN

Senior Data Integration and CRM consultant

Responsibilities:

• End-to-end expertise in Siebel-to-SFDC Data-Migration
• Siebel-to-SFDC System Field Mapping,Siebel View creation and optimization,SFDC Load file creation
• Data migration SIT/ UAT conduction and issue resolution
• Lead / Assist with user requirement sessions and document user requirements to address changing business needs
• Contribute on the technical side of business projects and create solutions to meet challenges (including performing detailed analysis of technical and business requirements)
• Gather requirements, collaborate with the team to define a solution and assist in buildingit and the users.
• Ability to work independently and engage supervisor as needed.Ability to handle full workload and meet proposed deadlines.
• Regularly assess CRM applications and tools to identify and implement efficiencies and potential opportunities for improvement.
• Performed gap analysis and drafting the Technical Design documents from the Functional Requirements provided by the Business Team.
• Data Migration complete end to end process from Siebel to Salesforce.com
• Implementation of LOV’s, Activity PlansPick Lists and Business Component User properties to achieve the client business functionality
• Estimated Time Efforts for completion of implementing
• Created .ifb files for the (Used the shell Process for creating the ifb files).
• Extract the data to EIM Tables and run the EIM Task to load the data into Siebel Base tables.
• Developed new functionality (scripts) or modified existing scripts for data conversion and loaded bulk data into Siebel applications using EIM.
• Modified the Batch Execution processes for executing the steps for importing data from the External database to EIM tables and then kick-off EIM tasks to load Siebel DB based on the business request.
• Debugged the Log file for fixing the Errors and Post import analysis for errors and rejects and re-importing.

Environment: Siebel 7.7.2.12eFinance, Oracle 11, Salesforce.com, Rapid SQL, Unix