SUMMARY

• Over 20 years of IT experience in enterprise architecture, design and development of integrated business systems, SAP ECC, SAP Business Objects with specialization in SAP Business Object Data Services/Data QualityIn Data Warehouse Design Data Modeling, Data Architecture and Design including Star Schema, SAP HANA modeling.
• Creating relational and OLAP Connections and Universes.
• Writing Crystal Enterprise/Web Intelligence/Explorer Information Spaces against universes .unv and .unx as well as BICS connections on SAP ECC and BW Data.
• Migrated Connections, Universes, Users, Groups, Reports from Dev to QA to Prod using the Promotion Manager.
• Configured Users and Groups security.
• Created Repositories using the SAP Data Services Repository Manager and Job Servers using The Server Manager (Windows). Managed Dev/QA/PROD Code migrations.
• Processing data as source and target - SAP ECC, SAP BW, SAP HANA, Oracle, SQL Server, DB2, MySQL, Flat Files, XML, IDOCS, BAPIs, RFCs. Configured Users and Groups security.
• Proven track record in the delivery of various projects: Implementation, Upgrade, Production & User-Support, and Defects & Enhancements.
• In SAP Data Services 4.2 /Information Steward 4.2
• Profiled data, created master records using the match wizard. Created Workbench jobs from the Data Quality Advisor in Information Steward based on choices made during Data Quality Advisor. Created Pre Load and Post Load jobs in SAP Data Services and Workbench.
• Participated in executing SAP/Non-SAP Projects in various levels, such as an Architect, Lead Consultant, Business Analyst, and Senior Consultant.
• Experience is gained in variety of industry sectors including Aerospace, Utilities, Retail, Health Care/Pharma, Insurance, Banking/Financial, Education, Construction, Real Estate, IT Services & Products.

PROFESSIONAL EXPERIENCE

Confidential

Senior SAP Data Migration Developer

Responsibilities:

• Senior Technical Data Lead for Hydrocarbon Supply Chain work stream.
• Developed ETL with Pre-Vals and Post-load reports for
• C HSC 016-Transport Units, C HSC 009-Routes, C HSC 015-Vehicles, C HSC 013-TSW Location,C HSC 010-Transport System, C HSC 017-Partner Roles, C HSC 034 Open Contracts(Product Excahnges), C HSC 039 Pricing Condition Records (Transfer Pricing), C HSC 022 Open Freight Agreements, C HSC 033 Open Deals (Commercial & MM-PRA Contracts), C HSC 036 Open Throughput/Terminal Logistics Agreements, C HSC 037 - Pricing Condition Assignment (Exchanges & Freight, C HSC 024 Inventory Balance, C HSC 023 Open Exchange Balances, C PTP 110-Batch numbers
• Extracted data from multiple legacy sources and loaded into SAP 4 HANA using SAP BODS 4.2 SP9.

Confidential

Microsoft/Salesforce EDW Consultant

Responsibilities:

• Re-architected current ETL loads to save over 3 hours on load time utilizing SAP Data Services best practices with bulk inserts, Server Memory Configuration.
• Converted many slow running SQL server stored procedures to ETL interfaces.
• Source data from File formats, SAP ECC FICO/SD/PS/MM/HCM using ABAP data flows and extractors, Salesforce and SQL Server 2012 data.
• Target Data SQL Server 2012.
• Mentored staff on Best practices for ETL Development, Administration, and Server Configuration for SAP Data Services.
• Created tables/views in SQL Server.
• Was user facing with many Customers requiring system development.
• Did On Call support and troubleshooting of job failures.
• Created SQL test scripts to validate data.
• Migrated ETL Code in Data Management Console from dev to qa to prod.
• Migrated table structures/Views from dev to qa to prod.
• Created SQL scripts to migrate new changes to existing table structures.

Confidential

SAP Data Services ETL Lead EDW Consultant

Responsibilities:

• Developed over 100 SAP Data Services interfaces staging data from SAP ECC FICO/SD/PS/MM/HCM on Hana, Sales Force, MySQL, Multiple Legacy SQL Server 2012 Sources, Cloud, and Flat files into a Reporting EDW on SQL Server 2012.
• The EDW was built with a Staging, Acquisition Layer, Core Normalized Layer and CORE BI denormalized layer for reporting.
• Created tables/views in SQL Server.
• Held workshops with users to go thru requirements.
• Was user facing with many Customers requiring system development.
• Did On Call support and troubleshooting of job failures.
• Created SQL test scripts to validate data.
• Migrated ETL Code in Data Management Console from dev to qa to prod.
• Migrated table structures/Views from dev to qa to prod.
• Created SQL scripts to migrate new changes to existing table structures.
• Developed a POC to pull Salesforce Account data directly into SAP ECC via RFC Call.

Confidential, Irvine, CA

SAP Data Services ETL Lead EDW Consultant

Responsibilities:

• Developed SAP Data Services jobs to load source data from Prowess MLM Software, Oracle 11i EBS Accounting and other disparate sources as well. Designed EDW Star Schemas and did the ddl using SQL Server 2012 as the database.
• Mentored other ETL developers on SAP Data Services.
• Worked with Business Users on validation of data and EDW needs requests.
• Did all of the SAP Data Services 4.2 Administration and code migration.
• Architected the ETL Solution.

Confidential, Renton WA

SAP Lead Data Migration Consultant

Responsibilities:

• Developed SAP Data Services jobs to do both Pre load and Post load validations of data being loaded from legacy sources into SAP ECC.
• Created jobs for work streams:
• Profiled data, created master records using the match wizard. Created Workbench jobs from the Data Quality Advisor in Information Steward based on choices made during Data Quality Advisor.
• IMWM(Material Master, Stock Balance, Storage Bins)
• PDM(Material Master, BOM, Document Info Records, Classification, Equipment).
• OTC(Open Releases)
• MRO(Independent Requirements, Routing Recipe)
• P2P(Vendor Master, Source List, Request For Quote, Contract, Inbound Shipping Notification, Purchase Info, Purchase Order)
• Developed ABAP data flows to stage SAP data to be used in Post Load Reconciliation Reports.

Confidential, San Francisco CA

SAP Lead Data Services Architect

Responsibilities:

• POC to show how the process to convert 1000 Data Stage ETL Jobs to SAP Data Services.
• Developed Jobs in SAP Data Services Workbench 4.2 utilizing data mapping templates and mass flat file loading to allow faster development.
• Profiled data using the Data Quality advisor in Information Steward 4.2 to help optimize the Data Services Jobs.
• All jobs took advantage of SAP Data Services 4.2 speed/efficiency techniques including
• Bulk loading of new data, merging of updates with Auto Correct Load with full pushdown, Degrees of parallelism which allowed extracting from very large dimension tables > 1 million rows data very quickly. Data stage processes that took 32 jobs to execute were rewritten in SAP Data Services in 4 jobs.
• Environment SAP Data Services 4.2 sp1. Oracle 11g, SAP ECC.
• Created Tables, Views, Stored Procedures in Oracle 11g. Wrote Oracle SQL statements to test ETL jobs.

Confidential

Principle SAP Data Services Consultant

Responsibilities:

• Architected and developed the ETL processes to move data to and from Salesforce CRM using the Salesforce Adapter in SAP Data Services 4.1 to a SQL Server 2012 Data Warehouse.
• Created Tables, Views and Stored Procedures in SQL Server 2012 and Oracle 11g.
• Converted and migrated existing .unv universes to .unx universes.
• Updated corresponding .unx universes using the Information Design Tool.
• Created/modified reports using Web Intelligence, Crystal Reports and Crystal Enterprise Reports .
• Developed SAP Explorer Information spaces for user consumption.
• Promoted users, universes, OLAP and Relational connections and reports with the promotion management tool.
• Wrote SAP Data Services ETL processes to load into a SAP Hana Instance from multiple disparate sources.
• Modeled Attribute Views, Analytic Views and Calculation Views for report consumption.
• The environment is SAP Data Services 4.1, BOBJ 4.1, SAP Hana SP05, Oracle 11g, SQL Server 2012.

Confidential, Chandler AZ

Business Objects Architect/Developer

Responsibilities:

• Supported 4 different BOBJ XI 3.1 Reporting environments. Administered the reporting servers, configured security, and migrated changes from dev to pre-prod to prod.
• Developed new BOBJ XI 3.1 Universes and Web Intelligence reports for each of the reporting environments.
• Mentored power users on Web Intelligence Reporting best practices.
• Created/Maintained the SQL Server 2008 R2 Stored Procedures and Jobs that were executed twice a day to load the reporting Data Warehouse/Data Marts.
• Created/Maintained the SQL Server 2008 R2 views that were used in the BOBJ XI 3.1 Universes.
• Configured both field level and row level security in the universes as well.
• Made all bug fixes and re-deployments of the BOBJ XI 3.1 universes.
• Mentored SAP developers on using Crystal Reports/Web Intelligence using BICS.
• Developed SSRS 2008 R2 Reports for 3 Different applications reporting on SSAS CUBES, SQL Server 2008 R2 Stored Procedures, Views.
• Developed all of the TSQL code used by the Business Objects Reports as well as the SSRS 2008 R2 Reports.

Confidential, San Diego CA

Business Objects Architect/Developer

Responsibilities:

• Developed BOBJ XI 3.1 Universes and Web Intelligence reports to track business diversity allocation.
• The reports tracked how the company donated funds to Diverse Business Enterprises to qualify for government funding.

Environment: SAP BW 7.1, BOBJ XI 3.1 Sp2

Confidential

Business Objects Architect/Developer

Responsibilities:

• Lead Data Services XI 3.2 Developer on a team that created ETL scripts to pull disclosure data from world wide entities into SQL Server 2005 Data Warehouse/Data Marts (Star Schema) utilized Business Objects Data Services XI 3.2.
• Modeled the data for the marts/warehouse.
• Created all SQL scripts for tables, views and stored procedures as well as all ETL.
• Built universes and reports based on the marts/warehouse utilizing Web Intelligence

Confidential

Business Objects Architect/Developer

Responsibilities:

• Lead Data Services XI 3.2 Developer on a team that created ETL scripts to pull worldwide data from France, Sweden and the US and load into Sql Server 2005 Data Warehouse/Data Marts (Star Schema) utilizing Business Objects Data Services XI 3.2
• Mentored staff on methods of Data Integrator ETL scripting to the most efficient processing of the information.
• Modeled the data for the marts/warehouse.
• Created all SQL scripts for tables, views and stored procedures and created all of the ETL.
• Built universes and reports based on the marts/warehouse utilizing Web Intelligence/Universe Designer XI 3.1.

Confidential

Business Objects Architect/Developer

Responsibilities:

• Loaded member company information and load into Sql Server 2005 Data Warehouse/Data Marts (Star Schema) utilizing Business Objects Data Services XI 3.1
• Wrote extensive SQL Server 2005 TSQL.
• Mentored staff on methods of Data Integrator ETL scripting to the most efficient processing of the information.
• Modeled the data for the marts/warehouse.
• Created all SQL scripts for tables, views and stored procedures and created all of the etl.
• Built universes and reports based on the marts/warehouse utilizing Web Intelligence/Universe Designer XI 3.1

Confidential

Business Objects/Crystal Reports Developer

Responsibilities:

• Developed 12 Crystal Reports XI R2 Reports for Confidential & Industries.
• Utilized Cascading prompts and Business Views with a SQL Server 2005 Back-end database
• Wrote SQL Server Command Objects to use for data sources for the reports.
• Mentored staff on Crystal Reports Development.
• Mentored users on Infoview use.
• Made BOE XI R2 configuration recommendations to staff.
• Created Demo installation of BOE XI 3.0 and crystal reports 2008.

Confidential, Chicago Illinois

Business Objects Architect/Developer

Responsibilities:

• Used Data Integrator 11.7 to stage data from Mainframe and SQL Server 2000 database and integrated the two into a new data warehouse used for reporting.
• Major report development moving key reports from the IBM Mainframe to Crystal Reports XI R2 Server environment.
• Extensive IBM DB2 SQL development used for the data sources for key production reports utilizing Advanced Query Tool (AQT).
• Crystal Reports XI R2
• IBM DB2 Version 9.1.0.356
• Utilized IBM ODBC connection for the reports.
• Mentored staff on Crystal Reports Development.
• Mentored staff on IBM SQL development and how to use with Crystal Reports the most effectively.

Confidential

Business Objects Architect/Developer

Responsibilities:

• Installed BOE XI R2 SP3 Premium Server on Virtual development and test environments.
• The environment included Web Intelligence XI R2
• Performance manager XI R2
• Crystal Reports XI R2
• Migrated current Crystal Reports CE 10 environment to BOE XI R2.
• Configured Windows AD with Java environment Tomcat web server.
• Created dimensional Data marts.
• Created universes connected to the data marts in IBM DB2 environment.
• Created Web Intelligence reports off of the universes.
• Stress tested the reports with large datasets.
• Provided training related to the administration, installation and management of the Crystal Reports solution for staff.
• Trained developers in new features of CR XI R2.
• Documented the installation process.

Confidential, Scottsdale AZ

Sr Consultant

Responsibilities:

• Managed major Business Objects Initiative for the company to utilize all the new Business Intelligence technology (Universes, Olap, Dashboards etc.)
• Interviewed and hired BO support personnel to support customer base on BO training and tech support issues.
• Developed the support process utilizing issue tracking software to manage customer call tracking and completion including escalation process etc.
• Managed other BO developers and mentored them on good techniques with all the software in the BO/Crystal XI R2 suite.
• Created procedures and prototypes to migrate existing customer’s universes from BO 5.1/6.5 to BO XI R2. Trained other BO personnel on the process.
• Trained BO on-site customer support staff on B XI R2.
• Wrote Desktop Intelligence and WEBI Ad-Hoc reports for customers.

Confidential

Sr Crystal Reports Developer

Responsibilities:

• Migrated Crystal Enterprise 9 to Crystal Enterprise 10.
• Migrated all Business Views, Users, Groups and over 300 reports
• Reports databases used on this project PeopleSoft Queries using DB2, SQL Server 2000, Oracle 9i
• Wrote all views, stored procedures used as report data sources utilizing PL/SQL for Oracle 9i and TSQL for Sql Server.
• Configured Windows AD and Peoplesoft Single sign-on authentication.
• Mentored reporting staff (5 people) on Crystal Enterprise duties.

Confidential, Las Vegas NV

Sr Business Objects Consultant

Responsibilities:

• Installed Crystal Reports Server XI, created users and groups, configured security for system for 100+ users to access reports that were scheduled as well as ad-hoc.
• Created Business Views complete with row and column security.
• Assisted Java developer team on how to deploy reports via Java Viewer.
• Reports databases used on this project Sybase Oracle 10g.
• Mentored reporting staff (5 people) on advanced Crystal Reports XI development, Creating Business views, Configuring report, row level, column security,
• Worked with tech writer to create documentation of this as well.

Confidential, Irvine CA

Sr Crystal Reports Developer

Responsibilities:

• Rewrote 3 key reports that took 30 minutes to run they took 2 minutes to run.
• Knowledge transfer to their key Crystal Reports XI employee.
• SQL Server 2000 stored procedures were the data sources.
• Developed all the reports in Crystal Reports Xi R1.
• Reports were deployed using Business Objects XI Enterprise.

Confidential

Sr Crystal Reports Developer

Responsibilities:

• Converted 150 Reports written with Crystal Reports 8 using Sybase Store Procedures as data sources to Crystal Reports XI utilizing universes as data sources.
• These reports were then brought into BO XI Enterprise utilizing universes and enterprise level security.
• AD Hoc reporting off of universes were created using BO XI Web Intelligence software.
• Developed reports in Crystal Reports XI.
• Reports were deployed using Business Objects XI Enterprise.

Confidential

Sr Crystal Reports Developer

Responsibilities:

• Writing Partner Reports.
• Crystal Enterprise 10/ Business Views/ User Configuration.
• Oracle 8i/9i Data Warehouse fed by Siebel
• Wrote all views, stored procedures used as report data sources utilizing PL/SQL for Oracle 8i/9i.

Confidential, Phoenix, AZ

Sr Crystal Reports Developer

Responsibilities:

• Responsible for Crystal Enterprise 9/Report Definition and deployment.
• Designed the Tables, Relations, Indexes, Stored Procedures, Views, DTS Packages using SQL Server 2000.
• Developed all the reports in Crystal Reports 9.

Confidential, Tempe, AZ

Sr Crystal Reports Developer

Responsibilities:

• Completed Business Loan Application Reporting System
• Designed the Tables, Relations, Indexes, Metrics database, Stored Procedures, Views, DTS Packages using SQL Server 2000.
• Used Oracle 8i/9i.
• Wrote all views, stored procedures used as report data sources utilizing PL/SQL for Oracle 8i/9i.
• Responsible for Crystal Enterprise 10/User Configuration/Report Definition and deployment.
• Developed all the reports (25 of them) in Crystal Reports 10.
• Documented all of the system level documentation.
• Performed extensive testing on the Report Metric Calculations

Confidential, Phoenix AZ

Sr Crystal Reports Developer

Responsibilities:

• Responsible for Crystal Enterprise 9/User Configuration/Report Definition and deployment.
• Wrote all views, stored procedures, User Defined Functions used as report data sources utilizing PL/SQL for Oracle 8i/9i.
• Developed Business Reports for Airplane tracking system.
• Developed all the reports (15 of them) in Crystal Reports 9.
• Performed all of the report level documentation.

Confidential

Sr Crystal Reports Developer

Responsibilities:

• Developed Report Extract System for a large Mortgage Company in Phoenix, in which 200 reports were run daily from.
• SQL Server 2000 Back-end.
• Wrote over 50 SQL Server Stored Procedures and Views utilizing TSQL for SQL Server.
• Wrote many Visual Basic 6, ASP, ASP.NET, VB.NET interface programs that extracted data from the main Mortgage Software (Interact from Alltel).
• Wrote over 150 reports in Crystal Reports 8.5.
• Performed all testing and system documentation on my projects.
• Developed Access 2000 front-ends, this application was for users to print accounting reports in a fund accounting charter schools system.
• System consisted of Access 2000, Crystal Reports 8.5, SQL Server 7 Stored Procedures Called from ACCESS.
• Developed Inventory Management System.
• System consisted of VB6, Crystal Reports 8.5 using Access 2000 Back-End.
• Performed all testing and system documentation on my projects.