SUMMARY:

• Siebel 8 Certified Professional with extensive hands on experience with data migration and reporting
• 15+ years experience in System Implementation in various industries which include telecommunications, sales, marketing, banking, insurance, manufacturing, distribution and automotive
• In - depth background for process re-engineering, designing, developing, implementing and installing enterprise wide applications
• Worked in several full cycle technical development projects that include requirements of gathering, development, testing, and deployment
• Designed and developed Siebel EIM process to import data for various Siebel base tables in different Siebel Applications
• Solid understanding of Siebel Architecture and Siebel Data Model and Migration Methodologies
• Developed design flows, converted data from legacy systems, application configurations, and developed workflows, scripts, and batch files that automate customer transactions
• Exceptionally good communication skills with strong problem solving and troubleshooting skills
• Can work under pressure and complete tasks with high-quality deliverables ahead of time and budget

TECHNICAL SKILLS:

CRM: Siebel - Public Sector, Call Center, Sales and Marketing, eCommunications, Finance, Siebel Tools

Operating System: Windows NT 4.0/98/2000/NT/XP, UNIX, Sun Solaris, DOS

Programming Languages: MS Visual Basic, Siebel eScript / VB Script, SQL, Shell Script, XML

Databases: Oracle, MS SQL Server, Confidential DB2 UDB, Sybase, CA-Ingres, MS Access, CA-OpenRoad

Reports: Actuate, Crystal Reports

ETL Tools: Confidential WebSphere DataStage, MS SQL Server Integration Services (SSIS), Informatica 6.1 & 7, MS Query Analyzer, MS DTS Package

Others: ERWIN, Visio, MS Office, Win SCP, SSH Secure File Transfer, MS Sharepoint, Confidential Rational ClearQuest, Confidential Rational Portfolio Manager, MS Visual SourceSafe, MQ Series, FileNet, Trillium

PROFESSIONAL EXPERIENCE:

Data Migration Specialist

Confidential

Responsibilities:

• Responsible for designing the data export and delete process for Confidential ’s Closed Service Request, Service Request Notes, Attachments, Audit Trail, Activities and Survey
• Create the design documentation and the Siebel data mapping for the Confidential Siebel Data Archival Process
• Analyze the current production data for the export and delete process by constructing complex SQL scripts
• Create Siebel EIM Configuration Files (IFB Files) and SQL Scripts
• Test the developed SQL Scripts and Siebel IFB Files

Data Migration and Reporting Team Lead

Confidential, New York

Responsibilities:

• Solely responsible for the execution and implementation of the Siebel data migration and customized Actuate reports for Release 1
• Responsible for the submission of the Release 1 Siebel Actuate Reports Deliverables
• Addressed and troubleshoot all Release 1 migrated data and actuate report defects
• Supervised the team of 7 off-shore and 5 land resources for developing the Release 2 Case Management data migration process and 96 customized Actuate reports
• Standardized Release 2 deliverable templates such as Data Migration Plan, Siebel Data Mapping, and Reports Technical Specification
• Responsible for the analysis and development of the project (business requirements, design, coding, unit testing, integration testing, system testing, UAT and implementation)
• Thoroughly reviewed and maintained the Release 2 data migration and Actuate report deliverables prior to client sign-off
• Reduced the original 205 report requirements, from the Statement of Work, to 96 report requirements
• Created Siebel extension base table and base columns using Siebel Tools
• Provided weekly status report and updated the management of any data and reporting issues
• Designed, created and maintained the 95 report mock-ups
• Wrote complex SQL queries against other Legacy Systems to retrieve data used in the validation of the migrated data
• Involved in creating unit test case and in preparation of test logs used by designers to test the technical implementation

Data Migration Team Lead / Siebel EIM Developer

Confidential

Responsibilities:

• Conducted and facilitated Data Migration Workshops
• Led 4 team members for the design and development of the KDOL Siebel Data Migration
• Standardized templates for Data Migration such as the Data Migration Plan, Siebel Data Mapping and Data Extract File Format
• Gathered the business requirements and analyzed the legacy data elements
• Created legacy data extract files and formats and resolved issues encountered
• Consolidation of the Siebel List-Of-Values, Position and Responsibilities
• Worked with data import / export and integration with legacy systems
• Modified and designed batch jobs to import / export data between Siebel database and legacy systems
• Utilized MS SSIS ETL Tool for the creation of several packages (extracting data, loading data and data flow transformation)
• Owned and responsible for maintaining the Siebel Data Mapping, prepared complex SQL queries, configured and optimized configuration (.IFB) files to run EIM job for data load
• Created multiple test cases for the data migration
• Trained several KDOL and Confidential employees for the Siebel EIM Data Migration Process

Actuate Developer / Data Migration Specialist

Confidential

Responsibilities:

• Gathered, organized and verified Confidential ’s reporting requirements for the construction of the customized Siebel Actuate Reports
• Created several technical reporting specification documentation and report mock-ups
• Developed several metric reports for the Service Requests, Activities, and Solutions Objects
• Mentored team members on how to create, modify, and deploy the Siebel Actuate Reports
• Designed and constructed data Migration of the legacy data into Siebel database using the MS SQL DTS Package
• Identified the Siebel EIM tables, created the Siebel Data Mappings, File Layouts, and Siebel Configuration EIM files (IFB)
• Validated the converted data in Siebel by using SQL Scripts and analyzing the Siebel Log Files

Data Migration Team Lead / ETL Specialist / Siebel Developer

Confidential

Responsibilities:

• Conducted and facilitated Data Migration Workshops with Business Owner and Technical Staff
• Designed and developed data Migration and interface from several legacy applications in Siebel
• Analyzed the legacy data model, data structure and legacy applications.
• Performed gap analysis between the legacy and Siebel’s data model
• Defined and documented the legacy data transformation to conform the Siebel standards and ensured the uniqueness of each record
• Identified the Siebel EIM tables, created the Siebel Data Mappings and File Layouts, and Siebel Configuration EIM files (IFB)
• Created crontab scripts to schedule the nightly batch process from the legacy applications into Siebel database
• Log analysis to identify errors with in the data extract file and then corrected extracted data
• Validated the converted data in Siebel by using SQL Scripts and analyzing the Siebel Log Files
• Involved in the configuration of Static & Dynamic Picklists using Joins and LOVs.
• Customized Pick Applets, Associate and Shuttle applets and configured MVGs using Links, MVLs and MVFs

Data Analyst / Siebel EIM Developer / ETL Developer

Confidential

Responsibilities:

• Responsible for the data Migration of several legacy applications into Siebel
• Prepared several Siebel data mappings by working with the Business Team in identifying the legacy fields that were required for the data Migration
• Developed and implemented the coding of Informatica Mapping for the different states of ETL
• Fixed the invalid mappings and troubleshoot the technical problems of the database
• Debug the sessions by utilizing the logs of the sessions
• Done extensive testing and wrote queries in SQL to ensure the loading and validation of the data
• Identified the Siebel EIM Tables and provided directions for required transformation of multiple data to conform Siebel standards and ensures uniqueness of each record
• Developed several automated scripts to convert the legacy data to Siebel
• Provided technical support for the existing production data issues by analyzing the existing system to determine on how to integrate the different fixes

Data Migration Team Lead / Data Architect / ETL Developer

Confidential

Responsibilities:

• Led 5 team members and mainly responsible in analyzing the multiple legacy system
• Responsible for understanding the Business Process and managing with Business users to meet specific user requirements
• Worked with client and different teams within the project to gather requirements, to understand the current system and design the data Migration strategy to the new application
• Created and maintained the tracking spreadsheet and data Migration design documents
• Developed several Extract, Transform, and Load (ETL) with Confidential WebSphere DataStage from legacy to Siebel EIM Tables
• Developed processes for cleansing, transforming, extracting, integrating and loading data with the use of DataStage
• Written complex queries to facilitate the supply of data to other teams
• Responsible for using different type of Stages such as FTP, Hashed File, Sequential File, Sort Aggregator, Transformer and ODBC to develop different jobs

Data Migration Specialist

Confidential

Responsibilities:

• Provided services related to data Migration by performing data mapping of the legacy system to Siebel
• Developed several stored procedures to capture the delta data and convert it to the Siebel Application in an aggressive timeframe

Data Migration Specialist

Confidential

Responsibilities:

• Responsible in the data Migration of the agreements, agreement line items, and agreement attributes from the current system to the Siebel database
• Identified other missing related data to be converted into Siebel by cross-referencing the legacy with the target data structure
• Created the file format definition documents of the data extract files
• Identified errors with in the data extract files and worked with the legacy data team to correct the extracted data
• Developed several automated scripts to convert legacy data to Siebel

Data Architect / Developer

Confidential

Responsibilities:

• Analyzed the legacy systems data and redefined substantial processes for data migration, verification, validation and documentation
• Conducted and facilitated meetings with the Navy staff for data migration requirements
• Provided technical and expert guidance for the data migration approach
• Setup data cleansing rules and guides for Navy I.T. personnel
• Created scripts and procedures using DB2 utilities, SQL, and MS Access programs to import the data into Siebel EIM Tables

Lead Data Architect / Data Migration Developer

Confidential

Responsibilities:

• Gathered business requirements for the initial data load from the legacy database to the Siebel database
• Modified the Siebel Database Schema by extending columns in the Siebel EIM and Base Tables
• Performed the Siebel data mapping and ensured data consistency prior to the data migration process
• Created SQL Scripts to load data from the flat files to the Siebel EIM Tables
• Designed and constructed the automation of the Siebel EIM import process through the Siebel Server Manager Command-Line and batch files
• Participated in the installation of the Siebel Gateway Server, Siebel Server, and Siebel Database Server against DB2 UDB

Siebel Developer and Actuate Developer

Confidential

Responsibilities:

• Gathered, organized, documented and verified client’s business requirements for the construction of several customized Siebel Actuate Reports
• Mentored team members in creating Siebel Actuate reports
• Installed Siebel Gateway Servers, Siebel Severs and Siebel Database Server against Oracle
• Responsible for the migration of the Siebel Repository from the development environment to different environments
• Developed and used Siebel EIM to import several data into Siebel
• Created and modified Siebel objects in Siebel Tools and customized Siebel Actuate Reports to the Siebel Client Users
• Responsible in performing the Siebel Upgrade from Siebel 99 to Siebel 2000

Siebel Developer

Confidential

Responsibilities:

• Performed Siebel Configuration to implement Siebel COM to generate proposals by providing data from the Siebel database to the MS Word Templates
• Designed and developed several modules using Siebel Visual Basic
• Performed customization of the Siebel GUI by creating Siebel Views and Applets
• Provided assistance to other Siebel Developers with their technical challenges

Siebel Actuate Lead Developer / Siebel Developer

Confidential

Responsibilities:

• Developed several highly complex and customized Siebel Actuate reports
• Conducted a Siebel Actuate for Confidential Development Team

Siebel Developer

Confidential

Responsibilities:

• Configured Siebel application and extended the Siebel EIM and Base Tables
• Developed and customized functionality for the application using Siebel Visual Basic

Siebel Developer

Confidential

Responsibilities:

• Designed and programmed the automation of the Siebel EIM export process using MS Visual Basic, Siebel Server Manager Command-Line, and Batch Files
• Installed and configured the Siebel Server and Siebel workstations
• Customized the Siebel GUI to better suit the business needs by creating and modifying views, applets using existing Siebel Business Objects and Components
• Performed Siebel Database Extract for mobile users through the Siebel Server Task process

Application Developer

Confidential

Responsibilities:

• Designed and developed the Credit Vetting module in CableTel’s existing application
• Re-designed and re-engineered the existing application with the Sales Order Processing application using MS Visual Basic
• Participated in the design and development of the new application by creating design flows, technical design documentation, develop programming codes, and test scripts

Application Developer

Confidential

Responsibilities:

• Performed gap analysis to determine areas for improvement
• Designed and developed a module to track the status of the merchandise that the customer purchased
• Designed and developed the bar-coding inventory of the company’s resources to keep track if the company was short of supplies