SUMMARY:

Confidential is an Informatica, Siebel and Salesforce Certified Developer with extensive hands on experience with data migration and reporting. He has 15+ years’ experience in System Implementation in various industries which include: telecommunications, sales, marketing, banking, insurance, manufacturing, distribution and automotive. He has an in - depth background for process re-engineering, designing, developing, implementing, and installing enterprise wide applications. Confidential has worked in several full cycle technical development projects that include requirements of gathering, development, testing, and deployment. As he designed and developed Siebel EIM process to import data for various Siebel base tables in different Siebel Applications, he also has a solid understanding of Siebel Architecture and Siebel Data Model and Migration Methodologies. He developed design flows, converted data from legacy systems, application configurations, and developed workflows, scripts, and batch files that automate customer transactions. Confidential is able to coordinate and communicate with project team. He is able to work independently and as part of team. He has excellent analytical/problem-solving skills, self-initiative and fast to learn new skills/technologies, resourceful, committed, and smart-worker. He can work under pressure and complete tasks with high-quality deliverables ahead of time and budget.

TECHNICAL SKILLS:

Databases/OS: Oracle, MS SQL Server 2012/2010, IBM DB2 UDB, Sybase, CA-Ingres, Windows, Sun Solaris, and DOS.

Software/Cloud: Visio, MS Office, IBM Rational ClearQuest, IBM Rational Portfolio Manager, MS Visual SourceSafe, IBM WebSphere DataStage Client and Director 8.5, MS SQL Server Integration Services (SSIS), Informatica 8.6.1 / 9.5.x / 9.6.1, MS DTS Package, Siebel Public Sector, Siebel Call Center, Siebel Sales and Marketing, Siebel eCommunications, Siebel Finance, Siebel eMedia, Siebel Tools, MS Visual Basic, Salesforce and Informatica Cloud.

WORK EXPERIENCE:

Confidential

Sr. ETL Developer

Responsibilities:

• Redesigned the initial and incremental loads of 18 Salesforce Objects into SQL Server Reporting Tables from days to 5 hours with millions of data.
• Created and executed the DDL scripts to create the reporting tables and control table.
• Created a proof of concept of the initial data load between Informatica PowerCenter Designer versus Informatica Cloud.
• Created Informatica PowerCenter mappings and workflow sessions to load the SFDC to SQL Server.
• Tuned performance of the Informatica sessions to optimize the SFDC data load into SQL Server.
• Created Promotional Plan from Development Environment to Quality Assurance Environment.
• Presented ETL mappings, sessions and workflow during the code review with the Sutter Team.

Confidential

Sr. ETL Developer

Responsibilities:

• Gathered Salesforce and EPIC integration requirements for Inbound and Outbound processes.
• Contributed in the creation and updates of the Logical Data Mapping for Salesforce and EPIC integration.
• Designed, developed and unit tested the ETL Mappings and Staging Tables for the integration process.
• Created and executed the DDL Scripts for the staging tables and control table.
• Created unit and integration test cases and participated on System Integration Test activities.
• Created Promotional Plan from Development Environment to Quality Assurance Environment.
• Presented ETL mappings, sessions and workflow during the code review with the Sutter Team.

Confidential

Sr. ETL Developer

Responsibilities:

• Involved in requirement specifications, analysis, design, development, & testing of application.
• Designed and developed the staging database and loaded from source to staging and from staging to the Destination tables applying different transformations.
• Responsible in creating and maintaining the data mapping document for the Promotions and Customers project.
• Developed queries and ETL mappings to load the data into warehouse.
• Used Toad DataPoint for Data Profiling of legacy tables.
• Implemented Slowly Changing Dimension (SCD) type 2 to maintain Historical Data.
• Created deployment groups and promote ETL mappings / Workflows from Development to QA
• Created unit test scenarios and performed code reviews and applied naming standards.
• Provided assistance to testers on the developed ETL mappings and explaining the data mapping.

Confidential

ETL Developer

Responsibilities:

• Reviewed the current GCSD Data Dictionary
• Identified and documenting the gaps between GCSD and eVerge’s Pre-Built School Performance Assessment (SPA) data warehouse tables and columns.
• Analyzed the current production reports.
• Drafting the SQL Scripts in the creation of additional Dimension tables for the SPA Analytics.

Confidential

Lead Architect

Responsibilities:

• Gathered and prepared the data integration requirements between Oracle EBS and Salesforce.
• Designed and worked on the proof of concept for the Real-Time Integration between Salesforce and Oracle Stored Procedure using Informatica Cloud Integration Templates and creation of Salesforce Trigger and Workflow.
• Managed an offshore resource for the development of additional integrations from Oracle EBS to Salesforce.
• Written SOQL queries against Saleforce.com IDE.

Confidential

ETL Developer

Responsibilities:

• Gathered and reviewed the data integration requirements with the client for the HR Analytics.
• Reviewed existing HR and Payroll Stored Procedures, Tables/Columns, and applications.
• Analyzed the current production data.
• Created and maintained the data mapping for the HR Analytics.
• Developed and maintained SQL Scripts for the creation of new Staging, Fact, and Dimension tables and columns.
• Developed SSIS ETL solutions and packages for loading the Staging, Fact and Dimension tables of the HR Analytics.
• Established data warehousing standards.
• Reviewed the existing subject areas stored in the data warehouse and determined where data should be stored
• Constructed SQL scripts for the SSIS ETL packages.
• Validate the data in the database and test the developed routines.
• Assisted in several components of the overall ETL process and data warehouse system.
• Performed quality assurance testing of data integration and monitored data load operations.

Confidential

Hyperion Report Developer

Responsibilities:

• Gathered and reviewed the reporting requirements with the client.
• Developed 8 customized using Financial Reporting Studio.
• Demonstrated the developed reports to the stakeholders.

Confidential

Data Migration Specialist

Responsibilities:

• Gathered and reviewed the data migration requirements with the client.
• Analyzed and familiarized the Confidential Enterprise Customer Master (ECM) data model and designed the solution accordingly to fit into Siebel data model.
• Designed and developed the data migration from several legacy systems: ECM, TotalSource, StateNet and Product Master.
• Prepared Data Migration Strategy document.
• Identified the Siebel EIM tables, created the Siebel Data Mappings, and Siebel Configuration EIM files (IFB) for 28 entities.
• Modified the Siebel Database Schema by extending columns in the Siebel EIM and Base Tables.
• Developed several Extract, Transform, and Load (ETL) with IBM WebSphere DataStage from Confidential ECM and TotalSource to the Siebel EIM Tables.
• Created EIM Server task, set the Configuration parameters, run the EIM Server tasks.
• Validated the migrated data in Siebel by using SQL Scripts and by analyzing the Siebel Log Files.
• Worked closely with Siebel Database Administrators to improve the Siebel Data Load performance.
• Resolved tickets that are logged into the HP Application Lifecycle Management (ALM) and Confidential Ticketing Tool (WebStar).
• Benchmarked the process by using various IFB file parameters to increase the performance.
• Assisted deployment into Test environment and provide application support.
• Communicated risk, issues and status of deliverables to project stakeholders.

Confidential

Data Migration Specialist / OBIA Developer

Responsibilities:

• Gathered and documented data requirements from multiple external sources to the Oracle Business Intelligence Data Warehouse.
• Developed several ETL mappings (SIL and SDE), Workflows and DAC Server Configuration to set up data extraction and load, identified and resolved missing data or related data issues, targets, mappings, and sessions.
• Participated in designing dimensional models such as star schemas.
• Worked on mapping multiple legacy extract sources to Oracle Business Analytics data model.
• Contributed in design and development of data load components using Informatica.
• Contributed in the end to end Unit and System test of Data Conversion which includes Record Count Verification, and Data Integrity Report Verification.
• Analyzed the data models, data elements and data structures of the legacy applications.
• Contributed in the development of the DAC execution plans, Tasks, and Subject Areas.
• Standardized templates for Data Migration such as the Data Migration Plan, Siebel Data Mapping and Data Extract File Format.
• Created Siebel extension base table and base columns using Siebel Tools.
• Created Siebel EIM Configuration Files (IFB Files) and SQL Scripts.
• 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.
• Reviewed and identified gaps with the data migration designs for other Fidelity projects.

Confidential

Data Migration Specialist

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.
• Created the design documentation and the Siebel data mapping for the Confidential Siebel Data Archival Process.
• Analyzed the current production data for the export and delete process by constructing complex SQL scripts.
• Created Siebel EIM Configuration Files (IFB Files) and SQL Scripts.
• Tested the developed SQL Scripts and Siebel IFB Files.
• Created a detailed Step-By-Step Data Archival Process and provided knowledge transfer to Confidential staffs.

Confidential, New York

Data Migration and Reporting Team Lead

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.

Confidential, Kansas

EIM Developer / Siebel Analyst

Responsibilities:

• Conducted and facilitated Data Migration Workshops.
• Led 4 team members for the design and development of the KDOL Siebel Data Migration.
• Standardized templates the Data Migration Plan, Siebel Data Mapping and Data Extract File Format.
• Responsible for understanding, articulating, documenting and presenting DB requirements on the assigned projects.
• Interacted with DB, Applications analysts and Business users for requirements gathering and validation.
• Worked with quality assurance team to build test plans to validate that new systems meet the business requirements.
• Gathered the data requirements and analyzed the legacy data elements.
• Prepared DB logical and physical models based on requirements.
• Reviewed and obtained sign off on data models from infrastructure team.
• Created legacy data extract files and formats and resolved issues encountered.
• 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 IBM employees for the Siebel EIM Data Migration Process.
• Applied best practices with the data migration designs that include batch processing and performance.

Confidential

Actuate Developer / Data Migration / Siebel Tester

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.
• Assisted in populating test data in the testing environment.
• Written test scenarios and created test cases, executing test cases and tracking results and defects in Rational.

Confidential, New Jersey

Data Migration Team Lead / ETL Specialist / Siebel Developer

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.

Confidential, North Carolina

Data Analyst / Siebel EIM & ETL Developer / Siebel Tester

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.
• 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.
• Provided technical support for the existing production data issues by analyzing the existing system to determine on how to integrate the different fixes.
• Written test scenarios and created test cases, executing test cases and tracking results and defects in Rational.
• Issued defect reports daily to all IBM and client teams, including Management, and reported on test status weekly.

Confidential, Michigan

Data Migration Team Lead / Data Architect / ETL Developer

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 IBM WebSphere DataStage from legacy to Siebel EIM Tables.
• Developed processes for cleansing, transforming, extracting, integrating and loading data with the use of DataStage.
• Responsible for using different type of Stages such as FTP, Hashed File, Sequential File, Sort Aggregator, Transformer and ODBC to develop different jobs.