SUMMARY

• Subject matter expert in Oracle Financial applications areas - Expertise in Project Accounting (PA) dat includes Project Billing and Project Costing, Project Management, OTL integration wif Project Accounting, Receivables, Payables, Assets, General Ledger and Cash Management, Oracle me-procurement and Purchasing, GRC ( Governance, Risk and Controls)
• Managing and implementing Oracle Financials applications in a multi-site environment for global solution design and architecture of the financial systems considering the GAAP requirements.
• Consulting wif clients to define business requirements; conducting gap analysis between delivered functionality & client requirements and recommending solutions.
• Helping clients achieve high performance wif Oracle Solutions by combining world-class technology experience wif business expertise.
• Spearheading full life cycle Oracle ERP implementations; implementing projects including planning, analysis & design, configuration, development, conversions, system testing, cutover and production support.
• Designing, planning, and implementing systems as they relate to Oracle Applications.
• Monitoring / tracking projects wif respect to budgeted cost, demand forecasts, time over-runs to ensure timely execution of projects.
• Supervising application design & architecture components and functional design activities.
• Creating functional requirements as an input to application design; developing and testing detailed functional designs for business solution components and prototypes.
• Supervising application build, test, and deploy activities; designing and specifying functional & technical solutions; providing project management through solution implementation.
• Undertaking Post Implementation Review of Oracle Application as part of Sanity checks for releasing to clients.
• Managing pre-sales activities including health check, demonstrations, presentations, responding to RFPs and gap analysis workshops.
• Taking ownership of problems or support issues dat arise in the operation of assigned applications, ensuring dat all issues are resolved in an expedient fashion and to user satisfaction.
• Managing & leading teams; guiding team members during the project till final delivery.
• Building know-how and delivering knowledge to junior members in the team.

TECHNICAL SKILLS

• SQL Data Warehousing ETL mapping
• Microsoft SQL Server
• SQL Server Integration Services
• SQL Server Management Services
• Windows Server OS Windows Mac OS, Unix
• MS Access Languages SQL, Java, J2EE, C, C++, C#,
• Modeling UML, MS Visio, Erwin
• ALM - Application Lifecycle Management
• QualityCenter, JIRA, QTP, LoadRunner, ClearQuest
• BI Tools Business Objects, Crystal Reports, Datastage
• Documenting functional and non functional requirements (BRD/FRD/FRS/TRS/SDD)
• Regulatory Framework: CCAR, BASEL
• MS Office, MS Project, MS OneNote, MS SharePoint, RALLY, Wiki, Confluence
• Performance Tuning

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, Ohio

Sr. Business Analyst

Responsibilities:

• Worked as a member of Credit Analytics Team to develop the model for CCAR submission for a financial Institution
• Worked on a Risk Management System, which supplies users wif end-of-day speeds as well as credit and market risk information
• Build and maintain CCAR (Comprehensive Capital Analysis & Review) operating rhythm and governance framework. Liaise wif FR Y-14 template owners to ensure compliance wif instructions and report timing
• Interacting wif the business users to gather requirements based on the CCAR Regulation for Financial Statements, FRY9C and Investment Securities
• Construct and developed the SharePoint Site for each CCAR cycle which is utilized for CCAR communication, storage of key CCAR files including business models, and automatic audit trail dat is sent to internal audit team
• Establish cross-functional reconciliation framework for tie points between FR-Y9C and FR-Y14 reporting data templates
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Extracted data from Oracle database wif MS Access, and performed SQL query, data analysis and verification.
• Performed analysis of approaches as well as to assist in investigation, escalation and resolution of the data issues

Confidential, CA

Business Analyst

Responsibilities:

• Formulates and defines large project/system scope and objectives, develops detailed systems specifications from which programs will be written and dat fit wif the Banks system architecture standards
• Evaluates existing systems and procedures to identify deficiencies and makes recommendations to maintain more TEMPeffective data handling, conversion, input/output requirements, and storage
• Analyses, develops and revises existing system logic difficulties and documentation as necessary and works on all phases of applications systems analysis activities
• Conducts feasibility studies, including fiscal evaluations of proposed and existing systems, and recommends new or enhanced applications software to meet business needs
• Develops test plans, test conditions, and scripts using highly complex concepts of business knowledge
• Monthly monitoring and forecast of Credit card portfolio for delinquency, charge-off and other Key performance Indicators
• Performed data analysis, data reconciliation and data retrieval from various systems along wif identification of data gaps and data quality issues for Basel II Credit Risk Mitigation System (CRMT)
• Overlapping waterfall model was used for requirements gathering
• Once Scope is approved, Draft SRS master document was prepared and detailed business requirements were captured
• Implemented business processes and related company policies under BASEL III standard compliance
• Prepared Test Plans, Formulated test strategies for conducting quality assurance tests on the SDR systems as part of Title VII of Dodd Frank Regulatory reporting requirements in conformance wif Part-43 and Part46 reporting by end users
• Establish documentation for agile methodology for implementation wif a very water-fall-centric development team

Confidential, New York, NY

Business Analyst

Responsibilities:

• Proactively prepared RASCI Charts and Cross-Functional Flowcharts using MS Excel 2003 and MS VISIO 2003 respectively.
• Instrumental in discussing the Billing generation logic and implementation wif Dev and Business to successfully test the Billing Module to realize revenue from Clients participating in Real-time reporting as part of their Dodd-Frank reporting Obligations.
• Used Agile Software Development process viz. Scrum, as this was a time bound project.
• Responsible for business analysis of customizing the BPS Risk Management product wif involvement through the whole SDLC
• Authored Business Requirements Document BRD wif project teams. Extracted, discussed, and refined business requirements from business users and SME’s.
• Experience in business domains like BASEL II, Loan Loss Reserves and CCAR as Business Analyst and Quality Assurance Analyst.
• Interacting wif the business users to gather requirements based on the CCAR Regulation for Financial Statements, Interest Rate, Credit Ratings, FRY9C and Investment Securities.
• Prepared Use cases and Activity flow diagrams and Work flow diagrams, considering the scope of the project wif MS VISIO 2003.
• Created a new risk and regulatory reporting system to deliver accurate and timely reports through a central data warehouse and Axiom's Regulatory Reporting System
• Conducted status report meetings wif the business and the IT team on a weekly basis, as the most important aspect of the project was Data Mapping.
• Exposed to SQL queries while churning out relevant information from company’s database.
• Assisted in system and user acceptance testing (UAT), free-trial demos, performed client presentations.
• Submitted change requests and worked wif change request records in Clear Quest.

Confidential, Randolph, NJ

Business Analyst

Responsibilities:

• Worked wif the business community to define business requirements and analyse the possible technical solutions
• Requirement gathering, Business Process flow, Business Process Modelling and Business Analysis
• Worked wif the Business community, Tech Lead and 3rd party vendors in gathering their requirements and data transaction information related to OLTP, OLAP and ASP
• Gathered requirements from the business and wrote use cases for development of customer facing order entry tool 'Axiom
• Completed the business requirement documents (BRD) to establish the economic capital calculation processes.
• Assisted in requirement verification and validation during various phases of Software Development Life Cycle (SDLC)
• Worked wif business sponsors to elicit business/functional requirements and generated use cases in accordance wif Agile Best Practices
• Assisted in User Acceptance Test (UAT), analysed and reconciled the outcomes from loss estimation, and coordinated wif stakeholders to identify potential issues and provide recommendations and solutions to remove problems and improve performance
• Design and develop the data load process using Informatica Power enter and XML Style sheets
• Run the SQL queries using TOAD and SQL Navigator. Wrote SQL statements to extract data from the Tables
• Helped wif ETL Data Mapping between the data mart and the Source Systems
• Developed and implemented processes and tools for requirements gathering, analysis, planning, tracking and delivery using Rational Rose requisite pro - RUP
• Performed Gap Analysis for new functionality requirements, as well as prioritized them based on actual business needs so as to align them wif the product release roadmap
• Designed and developed Use Cases and UML models using Microsoft Visio