PROFILE:

• Highly motivated, detail oriented, innovative Information Technology Specialist with over two decades of valuable experience who uses collaborative and technical leadership skills to deliver quality results.
• Provides project management, system development, finance and accounting, data warehousing, business intelligence report process services.
• Consults, develops, manages, implements and supports Oracle EBS, data modeling of business application systems.
• Facilitates requirement gather sessions and documents requirements, validates requirements with stakeholders, and analyzes current environments and future trends.
• Adaptable individual rapidly assimilates to new techniques and procedures quickly and effortlessly.
• Expert in the analysis and improvement of business processes to deploy IT solutions and promote best practices to exceed organizational goals.
• Communicates effectively with a diverse group of individuals at all levels of an organization.
• Providing federal financials SME expertise to office of Chief Financial officer (CFO) for the last 16 years using Oracle E - Business Suite (EBS) Applications.

CORE COMPETENCIES:

• Software Development Lifecycle
• Strong Analytical Skills
• Business Process Improvement
• Cross-functional Collaboration
• Business Intelligence
• Reports Development
• Research & Consulting
• Project Management
• Financial Management
• Verbal & Written Communication Skills
• Troubleshooting & Reconciliation
• Data Warehousing - ETL Process
• Interpersonal Skills
• Finance and Accounting
• Complex Problem Solving
• Regulatory Compliance
• Exemplary Customer Service
• IT Solutions
• Conflict Resolution
• End-user Support

TECHNICAL SKILLS:

Oracle Federal Financial 11i and R12 1.3,12.2.7 Oracle Discoverer 4/10g/11g, Oracle Forms, Oracle Reports, Designer/2000, Oracle SQL, PL/SQL, Pro * C/C++, Java, SAP Business Objects Xi, Oracle database 10g/11g, OBIEE 11g, BI PublisherInformatica PowerCenter 9.6, HP ALM (QC), Service Now, MS Office Suite, MS Project, MS Visio, Adobe Acrobat. Unix, Toad, Oracle SQL Developer, SAMS

EXPERIENCE:

Confidential, Washington, DC

Oracle Federal Financials R12 Subject Matter Expert

Responsibilities:

• Lead and coordinate the requirements and design CRP sessions. Configured project types, project templates, projects, agreements, auto accounting and SLA rules, cost allocation rules and lookups.
• Developed custom Confidential Is involving complex requirements, designed different First-In-First-Out (FIFO) logic solutions for AR application and AP prepayment liquidation, to help ease, identify transactions to be applied in the complex WCF solution.
• Lead the Integration Testing (IT) and User Acceptance Testing (UAT) cycles, preparation and creation of testing approach and scenarios, setup HP ALM (QC) for domain, project, test plans, test labs and generate test runs execution reports.
• Acted as a defect and release manager, coordinate, liaison with 4 OpDivs, and understand customer defect issues, working with the multiple teams and providing defect resolutions meeting customer satisfaction, and finally closure of the outstanding defects.
• Lead the daily defect meetings and provided daily defect and execution status reports to the federal and project teams.
• Lead the go/no-go meetings, cutover and deployment activities and coordinated with cross-functional teams to ensure seamless deployments.
• Lead the Operational readiness review (ORR) meetings, Knowledge Transfer (KT) sessions, and created user guides to ensure smooth transition to Operation & Maintenance (O&M) teams.
• Leading the stabilization support activities, customer coordination, track, assign and resolve service now incidents.
• Reviewed and configured SLA rules (AAD, JLT and ADR) with respect to object class changes for the Data Act Implementation project.

Confidential, Arlington, VA

Process Improvement Manager (Oracle Financials)

Responsibilities:

• Design and Develop a business process to identify assets activity based on the data received from Sunflower Asset Management System (SAMS) and to ensure proper journal entries are generated.
• Analyze, research, and support the resolution of various reporting, accounting, prior period adjustments and sub-ledger to general ledger reconciliation discrepancies.
• Meet with key stakeholders to understand processes and identify opportunities for automation and performing other tasks as per statement of work.
• Handling and completing multiple complex tasks requiring flexibility in prioritizing as per client needs, and then proactively communicating any identified conflicts requiring management attention.
• Develop and implement monthly scorecards and improvement action plans.
• Perform gap analysis of policies and tools and provide input to client in an organized and knowledgeable manner.
• Build and maintain relationship with finance and accounting executives and stakeholders.
• Provide coaching and counseling to the team members collaborate with cross functional teams to provide support.

Confidential, Arlington, VA

Senior Project Manager/Technical Lead

Responsibilities:

• Developed project plans, roadmaps and managed task backlogs.
• Delivered production support, new developments, enhancements, process improvements, bug fixes, and setup changes as per client needs.
• Effectively communicated risks, issues, and status to all project stakeholders including senior management.
• Analyzed, researched, and supported the resolution of various reporting, application data, accounting, and sub-ledger to general ledger reconciliation discrepancies.
• Identified and resolved application setup issues related to customer/BPAC setups, GL parent/child rollups, SLA, security, and cross validation rules (CVR).
• Actively participated in the upgrade migration of Oracle Federal Financials from 11i to R12.
• Assisting in development and customization of R12 SLA journal line types (JLT), accounting derivation rules (ADR), journal line definitions (JLD), and application accounting definitions (AAD).
• Validated data to ensure SLA rules are generating accounting entries properly.
• Contributed in the configuration and change management activities.
• Served as a key player in R12 user acceptance testing (UAT) by discovering various system and reporting issues and providing timely resolution.
• Work with Delphi core users, budget analysts to resolve production support issues like fixing budget distributions with incorrect transaction codes, reconciling budget execution data entries with GL entries, expediting approval status on purchase orders, resolving holds on invoices. Monitored the progress of help desk tickets so that SLAs are not violated.
• Worked on Delphi Help Desk solving tickets and attended phone calls to resolve customer issues, performed root cause analysis and then provided issue resolutions or escalated as needed.
• Assisted in month end and year end closings activities such as ensuring sub ledger interfaces have run, verify un-posted journals, any PO stuck in ‘In Process’ status, review invoices on hold etc.
• Served as functional and technical reports lead, analyze and gather Confidential reports requirements, create and update MD60/65/70/120 documents, organize subject matter expert (SME) sessions, documented standard operating procedures and developed reporting inventory to meet customer requirements.
• Collaborated with FAA Enterprise Service Center (ESC), Oklahoma staff to establish strong working relationships and identified technical and functional needs of the application.
• Worked with different groups and stakeholders to determine priority of various needs identified.
• Analyzed, created, updated and documented business process.
• Managed all stages of software development life-cycle (SDLC) process to ensure an exceptional client experience, resolve issues in an effective and timely manner, and evaluate customer requests to determine level of effort (LOE).
• Served as primary point of contact between ESC and Confidential to ensure system requirements and report changes/requirements for the Confidential ’s core systems (DEPHI and PRISM) are successfully met.
• Developed communication plan, generate and provide report metrics and communicate strategic plans to senior management in a timely manner.
• Managed and mentored a team of developers, analysts and QA analysts.
• Analyzed and provided substantive comments on all major ESC’s OBIEE data mart related tasks and deliverables to ensure high quality and timely work products.
• Reviewed documentation including implementation strategy and roadmap, concept of operations, source system data dictionary, activity and context diagrams, functional and technical requirements, and reporting requirements.
• Facilitated and led weekly Confidential status meeting to provide continuous updates to COR, branch chief and senior management.
• Generated and provided monthly project status report to Confidential management team.
• Build relationship with OCFO finance and accounting stakeholders.
• Streamlined reports development lifecycle to decrease timeline for requirements elicitation to promotion of the report to production and retain high quality product while complying with proper internal controls.
• Familiarity with Oracle’s prebuilt business intelligence solution (OBIA).
• Delivered end user documents, organized and delivered end user sessions and generated the related documentation.
• Empowered the end user community to create ad hoc report changes by providing one on one sessions.

Confidential, Fairfax, VA

Team Lead/Solution Architect

Responsibilities:

• Served as a lead in the Oracle Financials ERP implementation from conversion through successful implementation.
• Served as reports lead in the discoverer reports development effort containing business areas development, folder development, workbook/report development, testing, quality assurance, reports implementation, and delivery.
• Organized and facilitated stand-ups meetings, retrospectives and reviews.
• Delivered 30 Confidential specific discoverer folders to meet Confidential ’s complex reporting requirements in the areas of accounts receivables, fixed assets, purchasing, accounts payables, general ledger, and budget execution modules.
• Delivered over 25 reports related to A/R module and provided on demand information for the disgorgement receivables invoices, debit/credit memos, adjustments, payments for both enforcement and non- Confidential data.
• Delivered over 20 reports related to G/L module and provided on demand fund status reporting, unliquidated obligations, budget distribution, filing fee, and EDGAR interfaces reconciliation.
• Delivered over 20 critical reports related to F/A, PO, and A/P modules and provided fixed assets inventory, asset detail register, UDO balances, travel payment details, and procure to pay details.
• Designed outbound data extracts from PO, AP, AR, FA and GL modules.
• Supported the validation of data for various conversion interfaces including customer, A/R invoices (auto invoice), purchasing documents, fixed assets, Fed-Traveler, and GL interfaces.
• Collaborated with FAA Enterprise Service Center (ESC), Oklahoma staffs daily to discuss deliverables, develop guidelines and design and development effort.
• Managed a team of up to 10 individuals through all phases of functional and technical development of discoverer business areas, folders, and reports. Provided guidance to junior team members and helped in peer review.
• Developed and implemented the design of the budget summary templates to control funds check to ensure clients’ needs were met.
• Tested as a proof of concept to add new sub allotment level in the budget levels.
• Performed fit/gap analysis to determine the usefulness of the existing Oracle standard reports as per Confidential requirements.
• Designed and delivered various reports requiring custom setups in the financial applications and dynamically generating data based on concurrent requests data processing.
• Updated the requirements traceability matrix (RTM).
• Designed, developed, and implemented fund status reports by parent organization and at agency level, unliquidated obligations reports meeting unique Confidential requirements.
• Implemented project as per scope, on time and within budget.
• Developed and reviewed various MD60, MD65, MD70, MD120, BR100 documents following Oracle’s Application Implementation Methodology (AIM).
• Conducted and participated in the Solution Design Lab (SDL) and System Integration Testing (SIT).
• Coordinated and conducted user acceptance testing (UAT) sessions.

Confidential, Vienna, VA

Project Lead

Responsibilities:

• Designed and developed various RICE (reports, interfaces, conversions, and enhancements) components.
• Developed, implemented, and tested various outbound data extracts from PO, AP, AR, PA, and GL modules.
• Developed unit and system test plans by identifying test data needed and executing test plans as part of system integration testing (COTS and custom).
• Troubleshot and resolved issues identified during testing.
• Documented test results in a timely manner.
• Researched and troubleshot complex system issues, functional, financial, and accounting issues to resolve issues in a timely manner.
• Established value sets, parent-child relationships, configuration of 3C’s, SOB, fund symbol, cross validation rules (CVR), security rules, roll up groups, summary templates, and populating data by using data loader.
• Drove continuous improvement for end to end process flow by identifying, analyzing, and recommending operational efficiencies.
• Acted as system administrator to create user, buyers, employees, request group sets, and assign user responsibilities.
• Collaborated with business transformation team for iSupplier requirements, R12 upgrade, and OMB Accounting Classification Structure (ACS) CGAC implementation initiatives.
• Analyzed, designed, and implemented Financials Data Warehouse by extracting, transforming and loading (ETL) data.
• Delivered various business objects universes to meet FHWA’s complex reporting requirements in the areas of purchasing, accounts payables, general ledger, and interacting with the Legacy federal aid highway program system.
• Delivered over 50 business object reports based on the Financials Data Warehouse created.
• Designed and implemented optimal month-end accrual processes for obligations and invoices.
• Used Oracle Discoverer to support ad hoc data query requests.
• Supported monthly, quarterly, and yearly financial close schedules.
• Resolved daily and monthly reconciliation issues between Legacy system and Oracle Application Interfaces (OI and AP) by using Oracle SQL and PL/SQL to data mine.
• Developed processes and procedures for subsidiary ledger to general ledger reconciliation and undelivered order (UDO) reconciliation.
• Addressed quarterly requests from department auditors and provided various data requests (flux analysis, improper payments, and grants accrual).
• Organized web conferences nationwide to deliver user .

Confidential, El Dorado Hills, CA

Software Consultant

Responsibilities:

• Used Oracle (PL/SQL) and Transact SQL to design and develop different database objects including triggers, complex stored procedures/functions, and packages.
• Designed and developed online simple to complex screens including multi-form, tab canvas, master-detail, and image file inclusion screens using Developer Forms 6/6i.
• Developed batches and reports using Pro * C/C++, and Oracle Report 6/6i.
• Used SQLloader and PL/SQL for data conversion scripts.
• Delivered performance tuning and optimization of SQL queries using tools like explain plan, tkprof.
• Identified product issues and implemented corrective actions.
• De-escalated client issues in a timely manner and provided production support.
• Implemented configuration and change control.
• Developed and implemented concurrency strategy for intermittent commit needed for batch processes.

Confidential, Alpharetta, GA

Programmer

Responsibilities:

• Developed reports using Pro * C and Oracle Report v3.
• Used PL/SQL to design and develop triggers, stored procedures/functions, and packages.
• Provided performance tuning and optimization of various queries and processes.
• Developed system test plan specification and delivered software testing procedures.
• Used SQL * Loader, PL/SQL scripts for conversion and uploading data into TIMSS tables.
• Performed impact analysis during client testing.

Confidential

Technical Team Leader, Module Leader / IT Analyst

Responsibilities:

• Designed the database model using Designer/2000.
• Prepared design documents, designed various tables, constraints, validation checks, database triggers, procedures, packages, interfaces, writing processes, menu navigation, online screens, and reports.
• Trained and mentored team members and delegated assigned roles and responsibilities.
• Installed and tuned performance of Oracle Client, SQL Net, Forms 5, Reports 3, and Designer 2000 (Repository).
• Implemented configuration and change control for project.
• Implemented TCS QMS.
• Designed and analyzed payroll module.
• Developed complex PL/SQL batch processes.
• Designed the database model using Designer/2000.
• Created screens consisting of control block, master-detail, multi-form in Forms 4.5, Oracle Reports using v2.5, reports, and batches using Pro*C.
• Enforced changes in design during development phase which would impact analysis and final inspection of the module.
• Evaluated and implemented client change requests on software to support clients during acceptance testing.
• Created Unit Test Plan and System Test Plan documents to submit in a timely manner.
• Performed code walkthrough, unit testing, and system testing.
• Wrote user documents.
• Conducted project management review sessions to gather information and provide feedback.
• Served as production support to resolve client issues and answer inquiries in a timely manner.
• Provided quarterly project status updates and budget updates to the upper management.