Lebenslauf Jose Erickson (HANA)

8
SEITE 1/8 JOSE ERICKSON Persönliche Daten Name Jose Erickson E-Mail [email protected] Twitter twitter.com/josejoaquinqe about.me https://about.me/jose.erickson XING xing.com/profile/Jose_Erickson geboren am Jul 16, 1972 Telefonnummer 0172/7698626 Berufliche Laufbahn April 2014 – heute Nestle S.A. Role: SAP Consultant ● Designed various reports evaluating the SAP Lumira Cloud and on premise capabilities. The reports where used as dashboards for sales and profit. ● High level design and implementation of data integration projects for all the markets ● Technical design and coding improvement initiatives ● Work with the major players in the data messaging and data integration technologies including SAP: SAP Process orchestration 7.4, SAP Data Services 4.2 ● Data Architect and data specialist ● Designed and developed number of Webdynpro applications for SAP HR: Leave Planning Tool, Organizational Chart, Timesheet, and Integration with SuccessFactors. ● Implementation of ESS/MSS 7.3 in SAP Portal for SAP HCM. Akademische Laufbahn Januar 1992 – Dezember 1997 Universidad Dominicana O & M Schwerpunkt: Bachelor-Abschluss in Informationstechnologie Rennbahnstraße 44, Frankfurt am Main, Germany [email protected] +49 0172 7698626 ● SAP HANA SP10 and SAP Developer Studio ● SAP Business Objects 4.1: Web Intelligence, Dashboards and Crystal ● SAP BODS 4.2 and Information Steward ● SAP BW 7.4, SAP LUMIRA Cloud Auszeichnungen 2002 TAW10 - ABAP Workbench Fundamentals 2003 TAW12 - ABAP Workbench Concepts 2004 JA100 - SAP J2SE Fundamentals 2005 JA310 - Java Web Dynpro Basics 2006 JA312 - Advanced Java Web Dynpro 2012 Webdynpro for ABAP 2013 SAP Data Services 2014 SAP Lumira, SAP Fiori, SAP Mobile LEBENSLAUF

description

Lebenslauf J

Transcript of Lebenslauf Jose Erickson (HANA)

Page 1: Lebenslauf Jose Erickson (HANA)

SEITE1/8

JOSEERICKSONPersönlicheDaten

Name JoseErickson

E-Mail [email protected]

Twitter twitter.com/josejoaquinqe

about.me https://about.me/jose.erickson

XING xing.com/profile/Jose_Erickson

geborenam Jul16,1972

Telefonnummer 0172/7698626

BeruflicheLaufbahn

April2014–heuteNestleS.A.

Role:SAPConsultant

● DesignedvariousreportsevaluatingtheSAPLumira

Cloudandonpremisecapabilities.Thereportswhere

usedasdashboardsforsalesandprofit.

● Highleveldesignandimplementationofdata

integrationprojectsforallthemarkets

● Technicaldesignandcodingimprovementinitiatives

● Workwiththemajorplayersinthedatamessagingand

dataintegrationtechnologiesincludingSAP:SAP

Processorchestration7.4,SAPDataServices4.2

● DataArchitectanddataspecialist

● DesignedanddevelopednumberofWebdynpro

applicationsforSAPHR:LeavePlanningTool,

OrganizationalChart,Timesheet,andIntegrationwith

SuccessFactors.

● ImplementationofESS/MSS7.3inSAPPortalforSAP

HCM.

AkademischeLaufbahn

Januar1992–Dezember1997UniversidadDominicanaO&M

Schwerpunkt:Bachelor-Abschlussin

Informationstechnologie

Rennbahnstraße44,FrankfurtamMain,Germany

[email protected]

+4901727698626

● SAPHANASP10andSAPDeveloperStudio

● SAPBusinessObjects4.1:WebIntelligence,Dashboards

andCrystal

● SAPBODS4.2andInformationSteward

● SAPBW7.4,SAPLUMIRACloud

Auszeichnungen

2002TAW10-ABAPWorkbenchFundamentals

2003TAW12-ABAPWorkbenchConcepts

2004JA100-SAPJ2SEFundamentals

2005JA310-JavaWebDynproBasics

2006JA312-AdvancedJavaWebDynpro

2012WebdynproforABAP

2013SAPDataServices2014SAPLumira,SAPFiori,SAPMobile

LEBENSLAUF

Page 2: Lebenslauf Jose Erickson (HANA)

Februar2014–Juni2014BHPBilliton

Role:SAPConsultant

● MigratedMSSQLDatabaseintoSAPHANA

● CreatedUsers,Roles,Privileges,Packages,Schemasas

partofHANASecurityandDevelopment

● DesignedandimplementedSAPHANAdatamodelling

usingAttributeView,AnalyticView,andCalculation

View.

● DevelopedcomplexSQLscriptsinCalculationviews

● ExecutedDataExtractionTransferLoading(ETL)using

SAPDataServices4.0toimportcsvfilesintoSAPHANA

tablesto

reflectexchangeliveratesapplication

● InvolvedinSAPHANASecurityincludingUser

Management,Roles,andPrivileges

● Reporting,AccessingAnalyticalandCalculationviews

fromExcel.

● InvolvedinInformationDesignToolCreationofData

Foundation,UniverseforHANAreporting.

● DevelopedWebServicesforSAPHANAdatabaseand

delivertoASP.NETdeveloperstoconsumedatain.net

basedapplications.

Mai2013–August2013WiproTechnologies

Role:SAPConsultant

● DesignedandimplementedtheDataProvisioningof

SAPHANA1.0usingSAPDATAServices.Essentially,I

createdaDataMartinsideHANAandontopofthatI

createdaUniversetobeusedwithexistingSAPBO

reportingtools.

● DataQualityprocess:IhavecreatedcustomData

CleansingpackagesforPlantMaintenance.Wehadto

harmonized,clean,mapandtransformthedatafrom

LegacysystemtoanewECC6.0

● ARISforSAPformodellingtheprocessofthemigration

andtheimpactinPMandHumanResources.

SEITE2/8

Page 3: Lebenslauf Jose Erickson (HANA)

Dezember2012–Mai2013ProspectaSoftware

Role:SAPConsultant

● DatamigrationusingSAPBusinessObjectsData

Services

● DevelopFinanceapplicationforusingBExWeb

ApplicationDesigner

● DefinethearchitectureforBOandWDAapplicationsin

theportal

● DevelopedanALVReporttodisplaytheVendor

information.Basedonthevendordisplaythevendor

BankDetails.

● DevelopaBAPItodisplaythesalesorderitemsand

statususingBAPI_SALEORDER_GETSTATUS.

● SAPMDGforcustomerdata

(corporate,company&salesrelateddata,partner

functions)

● EnhancementstotheMDGapplicationfoundationfor

furtherimprovedusabilityandprocessflexibility

● Continuedenhancementsof

SAPMDG’soutof-the-boxdatamodelsforstandard

masterdata

SEITE3/8

Page 4: Lebenslauf Jose Erickson (HANA)

September2011–November2012UXCOxygen

Role:SAPConsultant

● DataProfilingandDataCleansing

● Designing,developinganddeployingusingUniverse

Designer,WebIntelligence,DesktopIntelligence,Info

ViewandCMC.

● EnableddynamicreportlinkingbypassingVariables

(prompts)betweenreports

● CheckedtheUniversesforIntegrityandexportedtothe

Repositorytomakeresourcesavailabletotheusersand

groupsandCreatedAdhocReportsbyaccessingthe

UniverseCreatedAliasesandContextstoresolvethe

LoopsandTraps(fantrapsandchasmtraps).

● Involvedindeveloping,designingandmaintainingnew

andexistinguniversesbycreatingjoinsandcardinalities

responsibleforcreationoftheuniversewithClasses,

ObjectsandConditionObjects.

● DefinedBOClasses,Objects,intheUniverse,defined

Cardinalities,Contexts,JoinsandAliasesandresolved

loopsinUniversesusingTablealiasesandcontexts.

● InteractedwiththeBusinessUserstoanalysethe

businessprocessandgatheredtherequirements

● InvolvedindifferentphasesofSoftwareDevelopment

LifeCycle(SDLC)likerequirementsgathering,

preparationoftechnicalspecificationdocuments,

designinganddevelopingreports,unittestingandUAT.

● CreatedWEBIreports&Crystalreportsanddeployed

themthroughBILaunchPadwithBExQueriesas

source.UsedVariables,Userdefinedobjects,Scopeof

analysis,Drillmode,Sliceanddicemode,Prompts,and

Conditionstomakereportsaccurateandeasierfor

analysis.Createdmonthlyandsummaryreportsin

WEBI4.0forthedifferentdomainslikeFinance,

MarketingandHRdomains.

● DevelopedWEBIreportsonSAPBExQueriesusingBICS

inWebiRichclient.

● ModifiedBWqueriesintogenerateWEBIreportsusing

BILaunchPadinBOtomeetuserrequirements.

● WebdynproapplicationforHumanResourcesmodule,

versionECC6.0.

● ETLextractionsinBW.

SEITE4/8

Page 5: Lebenslauf Jose Erickson (HANA)

Januar2011–September2011BeagleIT(Spain)

Role:SAPConsultant

● CoordinatedoffshoreETLefforts,includingmeetings

andansweringofdailyquestions.

● Championedstandardizationoffieldmappings,data

dictionary,anduniverseandreportdocuments.

● DesignedandimplementedBusinessObjects

architecture,includinghardwareandsoftware

requirements,CMSinformation,security,andmigration

fromXIr2toXIr3.

● Ledreportdevelopmenteffort,includingcreationof

manyWebIntelligencereports.

● Constructeduniverseandrelatedstarschema

database,withfocusonuser-friendlyconfigurationof

classesandobjects.Universeautomaticallyupdated

withself-createdautomationtool.

● Guidedandplayedkeyroleindesigndocument

production,includingETLfieldmappingsfor500+fields

infoursystems(2000+fieldstotal),datadictionary,

universeandreportdocuments,andDDLscripts.

März2010–Oktober2010Cybersearch

Role:SAPConsultant

● FullDataMigrationcycle:Extraction,Transformation

(DataCleansingaswell),EnrichmentandLoading.

● Experienceinproductionsupport,dataloads,

validationandtroubleshootingoftransactiondataand

masterdata,changemanagement,transport

management,rolesandsecurity,systemchecks,

performancetuningandprocesschain

● Extensivelyused0FIGL_C10cubefor‘ProfitCentre

VarianceAnalysis’annualreporting.

● DevelopedProcessChainstoloadHRMasterDataand

transactiondata,scheduledtheprocesschainsfor

daily,weeklyandmonthlyloads.Monitoringtheprocess

chainsinthedevelopmentbox

● InvolvedinanalysingBIDataLoadSchedulesforHR

MasterDataandtransactiondata.

● ImplementedInfoCubeslikeLineItem(0FIAR_C03),

PaymentHistory(0FIAR_C05),andCostandAllocation

(0CCA_11)andcustomizedthoseusingUpdateRules.

CreatedODS,InfoCubesandMultiProviderforqueries

● Migrateddataflows,workflows,scripts,andjobs

betweenrepositories.

● Fulllifecycleprojectfocusingonsurveys,includingData

ServicesandDesigner(universe)components.

Troubleshootingandperformancetuningwhich

reducedseveraljobsfromseveralhourstolessthan

one.

● Designed,created,implemented,andtesteddataflows,

workflows,scripts,andjobsformultipleprojects.

SEITE5/8

Page 6: Lebenslauf Jose Erickson (HANA)

August2009–April2010AllinConsulting

Role:SAPConsultant

● CreatedandranETLjobstoloadandmanipulate

MaterialMasterandVendorSAPinformation.

● Generated,putintosuccessfulproduction,andtrained

othersindatavalidation/testingtool,usingData

ServicesandSQLServerproceduresandfunctions.

● UpgradeofFirstLogic/DataQualitytoDataServices,

withdataandmultiplecountryaddresscleansing.

● Developed,published,andscheduledbatchandreal-

timejobs.

● ProducedcontactduplicatecheckingETLproject,

includingmatchtransformsandadjustableparameters.

● Constructeddashboardstoreviewdatavalidation

results.

April2008–Oktober2008Neoris

Role:SAPConsultant

● WorkedonBuildingandenhancingBIobjectsthat

includeInfoObjects,DataSources,Transformations,

DTP,DSO,InfoCubes,Multi-providers,Infosetand

OpenHub.

● WorkedinDataModellingusingBIExtendedStar

Schema.

● WorkedinBusinessExplorerAnalyserforReporting.

CustomizedandmaintainedDataSourcesfortheFICO,

COPAModule

● ResponsibleforcreatingBusinessObjectsuniverses

andreportstoprovideinformationonclinicaltrials.

● DevelopedasolutionforNCF(FiscalNumber),atax

controlrequiredbylaw.

● FB60,FB65andMIROtransactionsenhancements.

ALE/EDIprogrammingforMMHRprogrammingusing

PNPLogicDatabaseandPayroll

● Workflowforreturnedsalesordermodifiedfrom

updatingthebillingblocktothedeliveryblock.

● Severalsub-workflowswereusedheretocontrol

approvalprocess.

● Workflowforparkedinvoicesmodifiedtoreleaseand

postingthedocument.

SEITE6/8

Page 7: Lebenslauf Jose Erickson (HANA)

Dezember2006–März2008LatCapitalSolutionsVBI

Role:SAPConsultant

● ExtractedDatafromSAPSD,FICOofR/3intoSAPBW.

● ImplementedLOstructuresforPurchasing,Inventory,

filledsetuptablesforInitloadsandscheduledV3

updatesusingcockpitafterinitializationofdelta

processes.

● WorkedonOperationalDataStore(ODS)tostagethe

databeforetransferringittotheInfoCubes.

● WorkedonExtraction,Transformation,Loadingon

workingwithR/3,legacyandFlatfileSystems.

● ABAPInterfaces,BADI’s,UserExitsandReports.

März2002–August2006Exagon

Role:SAPConsultant

● MasterdataConsolidationHarmonizationCentral

● MasterDataManagement

● ExtractedDatafromSAPSD,FICOofR/3intoSAPBW.

● ImplementedLOstructuresforPurchasing,Inventory,

filledsetuptablesforInitloadsandscheduledV3

updatesusingcockpitafterinitializationofdelta

processes.

● WorkedonOperationalDataStore(ODS)tostagethe

databeforetransferringittotheInfoCubes.

● WorkedonExtraction,Transformation,Loadingon

workingwithR/3,legacyandFlatfileSystems.

● ABAPInterfaces,BADI’s,UserExitsandReports.

SEITE7/8

Page 8: Lebenslauf Jose Erickson (HANA)

Mar-2002–Aug-2006CodetelClaro

Role:SAPConsultant

● Leveragebusinessnetworksformasterdataexchange

acrosscompanyboundariesandintegratewithcloud-

basedsolutionsformasterdatacreationand

consumption

● Furtherintegrationwithallbusinessapplicationsto

providemasterdataastheDNAoftheenterprise

● Ibuildfunctionmodulestoencapsulatethebusiness

logic:BAPI

● Internalandexternaldocumentation.

● Searching,matching,andenrichmentusingSAPBODS

● MassdatacapabilitiesusingSAPMDM

● Processanddataqualityanalyticswithremediation

● DatareplicationtoallsystemsusingSAPBODS

● Workingwithdifferenttypesoftables¦·Flat¦·Qualifier

¦·Taxonomy¦·Hierarchy¦·Specialtables¦·Objecttables

● SAPMDMImportManager:¦·ImportManagerOverview

¦·ConfigureImportManager¦·ImportMapFile¦·Pre-

requisitesforDataImport¦·MonitoringImportStatus

¦·PerformingDataImport¦·Transformations¦·Table

JoinsandLookup¦·Splittingfields¦·BuildingHierarchy

¦·PartitioningFields¦·FieldMapping/ValueMapping

¦·ValueConversion¦·mdisfile¦·Batchprocessin

Sonstiges

SprachenEnglisch:Fließend

Spanisch:Muttersprache

Französisch:Grundkenntnisse

Deutsch:Grundkenntnisse

QualifikationenBachelor-AbschlussinInformationstechnologie

OrganisationenApache,Oracle,SAP

SEITE8/8