SUMMARY:

• Technology leader with expertise in managing operations for large-scale retailers, distributors, travel industry and portfolio management organizations. Experience includes process re-engineering, infrastructure, solution design and implementation, system integration, high profile strategic initiatives, change management and managing and developing a team of technical and functional resources.
• Extensive knowledge in all Oracle Technologies, Architectures and ERP solutions including Retail, E-Business Suite, Business Intelligence and the databases.
• Strong relationships with business partners and leadership based on vast knowledge of technology, business and priorities, providing guidance and support in day to day business activities and support of strategic vision. Expert in understanding cross-functional processes and data integration within the landscape of solutions leveraged to manage all facets of business operations.
• Recognized as a strong leader, team builder and strategic thinker.

TECHNICAL SKILLS:

Oracle Retail: R13.2.x of RMS, ALLOC, ReIM, RPM, SIM

Planning: RPAS, RDF, MFP, IP

Analytics: OBIEE 11.1.1.x, Retail Analytics 13.2.x, OBIA 7.9.6.4

E-Biz Suite: GL, AP, CM, HRMS

Application Server: Weblogic 11g, OAS

ETL Tools: ODI 11.1.1.7, Informatica 9.1.x, DAC 11g

Release Management: HP PPM, SVN

Scheduler: UC4, CAWA

PROFESSIONAL EXPERIENCE:

Confidential, Katy, TX

Retail Admin

Responsibilities:

• Worked on RPM (13.2.4) batches - NewItemLoc and LocationMove for performance and data issues
• Part of the production support team
• Setting up debug and traces, analyzing tkprof’d files and suggesting solutions
• Applying patches

Confidential

Sr. Tech Architect

Responsibilities:

• Led highly skilled and diversed teams (implementation partner--Accenture) along with the group IT (local IT) on the high profile Oracle ERP implementation project (CORE)
• Reverse engineered the technical architecture and infrastructure design
• Troubleshot numerous implementation/architecture issues/opportunities
• Introduced technical architecture standards and best practices
• Orchestrated the code migration process
• Streamlined the instance strategy process that includes WM9 (distribution/warehouse management application)
• Provided white papers (recommendations) to encompass the performance, future data growth, enhancements, scalability and sustainability of the systems

Confidential

IT Consultant

Responsibilities:

• Working on the Oracle Retail and BI infrastructure design solutions
• Collaborating with different groups, teams and vendors for the successful delivery of CRPs/Demos
• Delivering 13.2.5 instances of RMS, ReSA, ReIM, ALLOC, RPM, RIB, SIM and Retail Analytics
• Designing oracle Retail and BI architecture
• Working on the capacity planning
• Developing instance strategy
• Working as an integrator among the different architectures and applications
• Designing and preparing OBIEE, OBIA-- HR, Financials, Procurement Spend, Retail Analytics
• Assisting the SSO and provisioning for Business Intelligence and Retail Suites.
• Installing and Configuring tools for conversion and analytics—ODI and Informatica

Confidential ., New York, NY

(MFP/IP Conversion Lead)

Responsibilities:

• Analyzed data from the Netezza Data Warehouse, JDA Manugistics and several other legacy applications for conversion to RPAS planning modules
• Held meetings with the business users to verify/approve the data needed
• Created functional documents for SKU and Merchandise Financial Planning data conversion
• Helped offshore team (Accenture) to develop the technical documentations based on the functional documents
• Assisted in configuring RPAS (SKU and MFP) and worked on creating the domains
• Worked with the QA team on testing RPAS conversion scripts and batches

Confidential, Plano, TX

Oracle Retail DBA/Analyst

Responsibilities:

• Implement, support and maintain Oracle Retail applications (RMS, RPAS, RDF, ReIM, ALLOC) and custom built (Pricing & Promotions, Store Replenishments and Costing Solution)
• Work with three offshore development teams (IBM Global Services)
• Manage deployment, configuration and support of RPAS, Webutil, database and middleware servers
• Work as a liaison with development teams, Business, QA and the Release Management to ensure proper propagation of codes and Releases in QA,UAT and Production
• Capacity planning and furnishing the environment needs for each project/group
• Plan and schedule refreshes and new development/project environments
• Setting up coding standards
• Designing the whole process of bug identification and bug fixing
• Data architecting across different applications (integrations) using RIB and TIBCO
• Proactively work with business owners/users and developers on data validations, releases, defects and hot fixes
• Investigate, research and trouble-shoot to resolution as opportunities arise
• Documentation and knowledge transfer to the respective teams
• Oracle SR creation, support and escalation for timely resolution of problems
• Worked as a technical architect to plan and design the solutions
• Integrator to make sure the right data and flow to the right applications
• Applied industry best practices to leverage the business investments on IT

Confidential, Dallas, TX

Sr. Oracle Apps Specialist

Responsibilities:

• Worked on bringing stability to Oracle Financial’s Consolidation process across multiple set of books
• Helped consolidating the E-Biz infrastructure (cutting down the cost of different regional instances plus enhance the performance and productivity)
• Helped the team to clean up the suppliers (foreign and domestic) and helped stabilizing the AP business process
• Worked and presented the importance of project instances to the IT department for the company’s benefits - revenue dollars and work hours.
• Worked as a liaison during the implementation of Oracle HRMS

Confidential, Chicago, IL

Apps Team Lead

Responsibilities:

• Worked with the integrator (IBM) in setting up the infrastructure and implementation of Oracle Solution
• Managed upgrades of ERP production from 11.5.7 to 11.5.10 CU2 and then to R12
• Managed and administered upgrades of ERP systems
• Setup and managed fully automate cloning/refreshing procedures
• Assisted development teams on the custom data purge and archive applications

Confidential, Elk Grove Twp., IL

Sr. Applications DBA

Responsibilities:

• Managed upgrades of Oracle Apps 11.5.8 (32 bit 8.1.7.4 RDBMS) to 64-bit 9.2.0.6
• Managed offshore team of Oracle Application DBAs
• Set up auditing for Sarbanes-Oxley requirements
• Responsible for backup/restore strategy - using RMAN and Veritas Netbackup

Confidential, Troy, MI

Systems Analyst/Sr. Oracle DBA

Responsibilities:

• Administered Oracle E-Biz Suite and custom applications
• Worked on Retail custom built applications -- Order Replenishment, Assortment, Promotions, Allocations and Demand Forecasting with the partners (Modis and Oracle)
• Collaborated with consulting teams (Oracle and Deloitte) during the implementation of Purchasing and Order Management
• Provided 24x7 support

Confidential, North York, Ontario

Sr. Analyst

Responsibilities:

• Worked as a techno-functional lead for the Production Reporting Module of the existing STEELMAN applications for the steel-mills
• Gathered requirements from the business users (steel mill in Warren, Ohio) and transform them into functional specs
• Designed the whole Production Reporting Module and integrate it with the existing Data Model of the STEELMAN suite of applications.

Confidential, Ontario

Applications Developer

Responsibilities:

• Worked on the development of a very complex Taxation System for the five cities of Metro Toronto
• Created Front-end forms, reports and back-end dB triggers, stored procedures and packages for the application
• Populated oracle tables using SQL*LOADER scripts and PL/SQL procedures
• Wrote PL/SQL and SQL*Loader scripts for data fixing/loading run-time problems
• Received several awards for performances