SUMMARY:

• IT professional for over 12 years with vast experience as a BS/BI analyst ­ EBS Financial functionalist, (OBIA/OBIEE) and EBS system configuration.
• Project management functions such as project initiation, planning, execution, monitoring and closing.
• Liaison between line of business, operations and technical teams.
• Worked with stakeholders, in defining problems and business solutions.
• Prioritized requirements drivers and communicated effectively with stakeholders, synthesized teams' work in alignment with business goals and needs.
• Documented process, procedures and workflows.
• Worked with technical in designing solutions, tests plans and monitored testing.
• Used global standard, practice and methodologies (traditional and Agile, AIM UOM) throughout the SDLC, IPEC& PEC EBS financial configurations, Siebel CRM enhancements, BI reporting, RPD development, business and data modeling, administered BI and Representation servers, testing, repository deployments.BO Universe and reporting.
• Vast in experience includes accounting, finance, banking, brokerage, mortgage, customer contact and service, CRM, procurement, spend, support and manufacturing.
• Good communications skills, well organized, adaptive, creative, goal oriented and multi­tasking.

TECHNICAL SKILLS:

• EBS configuration, chart of accounts, account setup, flexi fields, Intercompany accounts.
• Business analysis, planning and monitoring
• Enterprise analysis
• Elicitation of requirements
• Requirements analysis
• Requirements management and communication
• Solution design, writing use cases
• Solution assessment and validation
• Process and application re­engineering
• Management of Cross Functional Teams
• Project Management functions
• Business modeling and data mapping
• BI Publishing
• BI reporting, RPD development
• Data Warehouse
• Dashboard and KPIs
• Application Testing
• BI server Admin
• SQL Developer,
• MS Suite: SSRS SMSS,Visio,Visual Studio, MS project Access & Excel)
• Oracle EBS R12, OBIEE/OBIA, BI, Publisher and BO
• Toad for Oracle
• Red mine
• Clarity
• JIRA ­burndowns
• Informatica Power center 9.0
• Mainframe AS400,
• SIEBEL CRM, Black night­ MSP, DRI, Sawgrass
• Business change management control and change risk management
• Full SDLC, BPLC and IPEC
• Project and Delivery Methodologies:
• Adaptive i.e. Agile
• Predictive i.e. Waterfall
• UML, AIM and UOC

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati Area, KY

IT­CRM Professional

Responsibilities:

• Serves as a liaison between IT and business lines.
• Business analysis, defining business problems and solutions, requirements tracing
• Coordinated software development, conversions and system enhancements (Oracle Siebel CRM and other systems. System integrations.
• Coordinates business requirements definition, functional specifications, development, testing, implementation, defects, and support for new and existing systems. Identifies, researches and analyzes production problems, develops solutions and coordinates resolutions.
• CRM system enhancements and CRM Analytics (marketing, contact and service)
• IA/Wholesale BI report migration from OBIEE to Business Objects
• Project Management: Project Initiation, planning, execution, monitoring and closing.

Confidential, Miamisburg, OH

Business Systems Analyst

Responsibilities:

• Planned business approach, stakeholder analysis, business analysis actives, communication, requirements management for
• Re­engineering of Investors Information Database (IID), Default Mortgage: Loss Mitigation, and Default support, Breach and Referral Reporting, HMP and Treasury Reporting Databases
• Defined business needs, assessed capability gaps, determined solution approach and defined solution scope for various projects within The Greenfield Bridge initiatives
• Elicitation of business and technical requirements, enterprise analysis, requirement analysis, prioritized requirements and organized requirements utilizing Visio, Toad, word and excel
• Modeled requirements and defined solutions, business cases, assumptions and constraints
• Communicated and confirmed requirements to stakeholders using SharePoint, Clarity, Red mine and excel
• Wrote epics, user stories, use cases, assumptions, constraints, design and workflows using clear case, Visio, Excel and Word
• Managed project scopes and requirements, version control, tracing, approvals and artifact library and requirement package
• Assessed solutions and validations, basic/unit testing, assessed readiness for deployment and transition
• Create ongoing support documentation and submit to knowledge base for usability and visibility Change management control - utilized Clarity
• Defined stories, backlogs, task and sprints for the Mortgage default, Gatekeeping and
• Requirements prioritization and estimation based on story points, value points and using Fibonacci sequence and BFTB
• Organized scrum and sprint planning.
• Scrum and sprint meeting
• Sprint reviews and retrospective meetings
• Utilize Burndown charts for technical task level for developers to visualize sprint burn­downs towards project completion
• Gather business requirements, design business application requirements
• Documentation, artifact library and requirement package
• BI reporting using OBIEE 11g, BI publishing and KPIs

Confidential, Hebron, KY

BI Analyst/Reporting Analyst

Responsibilities:

• Developed BI repositories in OBIEE/OBIA for Technical Support, Depot Repair and Field Service
• Data modelling using various concepts, creating star and snowflake schemas
• Developed RPD, Business modeling and data mapping, creating hierarchies and logic columns
• Designed subject areas and dashboards, Agents and Actions
• Deployed RPDs into production and provided production user support.
• Monitored test plans, testing and signed off on UAT
• Facilitated training for analysts on how to OBIEE analytics /dashboard.
• Created SQL components need to support RPDs
• Administered the Presentation and BI Servers.
• Performs various administrative duties, installation, configuration and administration of OBIEE, Other duties include data extraction, loading and transformation.
• Report Development using Microsoft tools: Visual Studio, SSRS, and SSMS.
• Wrote business cases, case stories and cards. Elicited business requirements, Gap, risk, impact and benefit analysis.
• UAT testing and workflow and process documentation.
• EBS financial modules (GL,AP, CM, FSG)Created chart of accounts, account setup, flex fields
• Functional design on integrations, reports, workflow and extensions/customizations
• Ensure deliverables are tracked and delivered to the project schedule
• Translate challenging business requirements into solutions leveraging standard Oracle functionality in latest/current releases of Oracle
• Test & Support RICE components for Oracle Enterprise Business Suite Modules
• Elicitation of requirements/developing design documents (both BR100 and MD50/MD70)
• Problem solving i.e. challenging issues/bugs

Confidential, Florence, KY

Business Control Specialist/ BI Specialist

Responsibilities:

• MIS Control: Process, risk and gap analysis. Elicited business requirements, Prepared BRDs, FSDs and CRs. Revised existing document policy and procedures. Acted as liaison between stakeholders.
• Business Analysis: Strategic planning and business model analysis, identifying the organization's business needs, policies and procedures. Interpreting business rules and requirements i.e. Functional or non - functional specifications, standardizing workflows, processes and documentation. Project time logging, updates, JAD sessions, storming, mentoring and coaching. Ensuring teams work in alignment with business goals and needs, Production readiness, deployment and product certification.
• BI Reporting: Report development in OBIEE­ importing metadata into RPD, creating star schemas, business modeling and mapping (dimensions, hierarchies, aggregation, log levels, level based measures and attribute key levels) and creating subject area in the Presentation layer. Ensuring BI Server and Presentation working consistently. Creating dashboard, drilldowns and views, managed BI Answer Server and BI Catalog, scorecards and KPIs performance and tuning.
• Designed dashboards for Default mortgage and Loss mitigation CRMs: DRI, MSP, Sawgrass
• Administered BI and BI presentation servers: security, roles and groups
• Monitored report performance, modelling trouble shooting, cache purging and tuning
• Monitored report performance, trouble shooting, cache purging and tuning.
• Configured EBS Financials R12 modules: GL, AP, FA and CM
• Developed and support personalization, customizations/extensions in Oracle Forms, Reports, BI Publisher and Workflow
• Prepared user documentation and training.
• Participated in system Unit testing, integration testing and UAT.
• Implemented CRM, SC and OM: Procure to pay, order to pay life cycles, advanced supply chain planning
• Planner workbench, land cost, service contract, sales, i­store, profile options, pricing rules, price action and price control
• Prepared the BR100, BR110, MD050 & MD70 using AIM or UOM
• Prepared testing plans and scripts
• Produced intercompany monthly financial reports.
• Reviewed and analyzed cost centers reports and budgets
• Reconciled general ledger account reconciliations, budgets, accounts payable and receivables.
• Maintained the fixed assets and reconciled intercompany accounts
• Configured EBS Financials modules: GL (set of books) sub ledgers and chart of accounts,

Confidential, Murray Hill NJ

Accounting Assistant

Responsibilities:

• Maintained the fixed asset registers (Gas and fabrication business)
• Production of asset acquisitions, additions, disposals, depreciation schedules
• Accounts payable and receivables, Cash flow and budgets and reconciliations
• Prepared daily entries to support product processor interface processes
• Processed related activities (journals, variance analysis, reporting, etc.)
• Prepared account schedules and documentation for internal / external auditor requests
• Helped in mapping of control accounting systems, process controls and transaction flows