Lebenslauf Jose Erickson (HANA)
-
Upload
josejoaquinquezadaerickson -
Category
Documents
-
view
9 -
download
2
description
Transcript of 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
+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
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
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
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
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
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
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
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