SUMMARY:

• Passionate about driving effective business results through utilizing the power of data and developing scalable and effective applications.
• 9.5 years as Oracle technical/functional consultant.
• 2 Oracle E - Business Suite and 1 SAP HCM large-scale implementations.
• Proficient in PL/SQL programming for RICEF, web application, ETL, batch processing, ad-hoc reporting, and proactive monitoring.
• Experienced in al l ph ase s o f t h e S o ft w ar e De vel o pme n t L i fe Cy cl e.
• Domain experience includes Supply Chain (software licensing, risk management, compliance and trade, new product introduction, and order fulfillment) and Finance (general ledger and account payables).
• Industry experience includes network equipment, electronics, retail, and food & beverage.

TECHNICAL SKILLS:

• PL/SQL
• SQL
• Oracle DB
• Java
• Microsoft Access
• Tableau
• SAP Business Objects
• Unix Shell Scripting
• Performance Tuning
• Oracle EBS
• Jdeveloper 9i with OA Extensions
• SQL*Plus
• TOAD
• DataStage
• Lotus Notes
• Quality Center
• Web Services
• IBM Event Scheduler Program(ESP)
• Dollar Universe ($U)
• Informatica

PROFESSIONAL EXPERIENCE:

Confidential, C al i for ni a

Project Manager

Responsibilities:

• Engaged product family owners to take new software license products to market without missing a deadline.
• Provided Tier 3 support and resolved escalated incidents involving high-valued customers.
• Constructed a proposal to improve customer’s purchasing experience.
• Operated in the Agile Scrum methodology.

Project Manager

Responsibilities:

• Developed ad-hoc reports that quantify the amount of revenue at risk using SQL, which reduced the exposure by 20% over two quarters.
• Created an automated program that enabled the measurement of over 2,000 suppliers’ risk ratings and reduced exposure to sourcing risks.
• Advised the data sourcing and data modeling practices to create a new dashboard for the SCVP program.
• Coordinated business continuity activities resulting in 100% compliance from all supply chain functional teams.
• Utilized reports in Tableau and SAP Business Objects to assess risk reports to take necessary mitigation or recovery actions.
• Collaborated with end users and IT development teams to create enhancements to reports in SAP Business Objects.
• Collaborated with component engineers and commodity managers, reducing the sourcing risks for thousands of high-risk components.
• Conducted User Acceptance Testing with the offshore migration teams during a large platform migration, resulting in minimal post-migration issues.

Technical Lead

Responsibilities:

• Developed an automated, end-to-end proactive monitoring solution, enabling proactive issue resolution and led to no compliance violations.
• Created automated scripts to verify the data integrity of a customer facing product list, which improved the Sales Team’s confidence and reduced customer dissatisfaction.
• Resolved Pl/P2 issues within SLA.
• Root caused, developed, and deployed emergency bug fixes, production data fixes, and long term code fixes.
• Provided 24/7 application support.
• Collaborated with cross-functional teams to resolve order fulfillment issues for Federal Sales Orders.
• Assisted the program stakeholders in the development of the TAA Center of Excellence.
• Constructed and presented weekly and quarterly metrics to business stakeholders.

Software E n g i n ee r

Responsibilities:

• Coordinated da i l y s t at u s meetings w i t h IT ke y s t ake h o l der s for a large database migration, which led t o m ini ma l post migration issues.
• Constructed technical specification documents (MD70s) for custom interfaces and enhancements.
• Developed an interface between an Oracle database and an in-house manufacturing & engineering system using PL/SQL.
• Developed a data replication program using J2EE.
• Developed and hosted w e b ser vi ce s that provided consuming programs acces s t o car t o n, AS N, a n d sal e s o r de r in fo rma ti o n
• Le d da i l y mee tin g s w i t h o ffs h o r e QA t ea m resulting in ti mel y a n d successful c o m ple ti o n o f o ffsh o r e testing and deployment ac ti vi ti es .

Software E n g i n ee r

Responsibilities:

• C o n fi g u re d IBM Dat aS t ag e and developed SQL scripts t o extract, transform, and load (ETL) larg e vo l u m e o f in vo i ce s fr o m t h e t ra din g par tn er s s y s t e m t o O racl e Account Payable .
• Automated the val i dati o n, the redemption of discount codes, the pa y me n t, and the posting o f i n vo i ce s from trading partners using PL/SQL.
• C rea t e d U NI X S h el l scr i pt s fo r ba t c h pr o cess in g a n d j o b sc h e du l in g .
• Se t u p pr o fi l e val u e s i n Oracle Acco un t Pa y ables, e n s u r in g pr o pe r di sco u n t c o de s a ppl i e d t o in v o i ces .
• C o llec t e d b u s in es s req u i reme nt s fr o m b u s in es s par tn er s t o c o n s t r u c t T O -B E a n d Fit- Ga p a n al y s i s do c u me nt s fo r i de nti f yin g s o l u t i o n s t o cl i e nt ’s b u s in es s req u i reme nt s .
• Pr o du ce d f u n c t i o n al (MD50) and t ech ni cal (MD70).
• Implemented and coordinated testing activities throughout t h e e n t i r e t es tin g ph as e, w h i c h le d t o n o ma j o r de fec t s fo un d du r in g GO -L IV E .
• C oo r din a t e d Pr o du c t t o S u pp o r t (P T S ) ac ti vi ti e s w i t h t h e o ffs h o r e t ea m res u l tin g i n n o Ser vi c e Le ve l Agr e eme n t (SL A) i ss u e s du ri n g t h e P T S t ra n s iti o n .

Software Engineer

Responsibilities:

• Developed PL / S Q L s t o re d pr o ce du re s a n d fu n ct i o n s, S Q L scr i pt s, dat a co n vers i o n pr o grams, c o n c u rre n t pr o grams, and j a va scr i pt s.
• C o de d U NI X S h el l scr i pt s fo r j o b sc h ed u l in g a n d ba t c h pr o cess in g .
• C rea t e d a n d exec u t e d t es t a n d c u t o ve r pla n s t h ro u g h o u t t h e i m pleme nt a ti o n l i fec y cle .
• C oo r din a t e d da t abas e re fr es h e s o f t h e pr o d u ct i o n e n vi ronme n t t o t h e de vel o pme n t e n v i r o n me nt .
• O rga niz e d Pr o du c t i o n t o S u pp o r t (P T S ) ac ti vi t i e s w i t h O r acl e Ba s el in e t ea m r e s u l tin g i n n o Ser vi c e Le ve l Agre e me n t i ss u es .
• Receive first ever perfect score from E n gageme n t Fee dba c k .
• Aw ar de d Pe pS t a r r ec o g niti o n fo r q u al it y wo r k a n d excee din g c u st o me r ex pec t a ti o n s .

Software Engineer

Responsibilities:

• B u i l t c u s t o mi z e d fo rm s to upload vendor configuration files and price lists u ti l iz i n g O racl e Appl i ca ti o n Frame wo r k (O AF) .
• De vel o pe d c u s t o m iz e d re po r t s a n d e n h a n ce d ex i s t i n g re po r t s fo r t h e O r de r Ma n ageme n t Mo du le .
• Constructed de t a i le d MD5 0 a n d MD7 0 d o c u me nt s .
• Le ver a ge d Gl o b a l Del i ver y Mo de l (GDM) t o c oo r di n a t e t es tin g ac ti vi t i e s w i t h o ffsh o r e t eam s i n C h in a, I n di a, a n d Mex i c o .