SUMMARY

• Extensive Experience working as a Sr. Business Analyst having advanced knowledge of Software Development Life Cycle(SDLC) phases like Requirement, Analysis, Design, Deployment, Testing, IT Project Management, Process management including Waterfall, Agile Methodology
• Well versed in holding stakeholder sessions and understanding business needs; strategy; processes and challenges and providing a robust solution in a timely fashion
• Adept at creating, editing, and coordinating extensive communication networks through the facilitation of Joint application design (JAD) sessions and interviews, written correspondence
• Extensive experience to analyze and document Business requirements BRD and Functional specification document(FSD).
• Experienced in full SDLC life cycle, from requirements gathering and Business case development to rollout and maintenance
• Having experience and knowledge of Informatica, Exadata andOBIEE
• Good Understanding on OFSAA Solution like FSDF, EPM (PFT).
• Wide experience in interacting with end - users to gather and document the reporting requirements and giving training to the end user
• Worked on the development of Dashboard reports for the Key Performance Indicators(KPI’s) for the top management
• Hands on experience on BI tools such asOBIEE11g, BI Publisher reports with design of ETL processes using Informatica Power Center
• Extensive experience in gathering Functional user requirements, creating Use Cases and creating Functional Requirement Document (FRD) as per user requirements in addition to creating Business Requirements Document (BRD)
• Experience in developing detailed functional specs through JAD sessions, interviews, on site meetings with business users & development team
• Experience working in modifying and maneuvering of data in MS Access Database and OBIEE Analytical tool.
• Strong experience in data mapping, extraction and manipulation of data in SQL and SAS Enterprise Guide
• Good understanding about how data is stored in OFSAA Database. Experience in interviewing Business users & SME providing recommendations to resolve issues for various business/technical groups & defining strategic solutions to business problems in a multiple project environment
• Excellent communication skills, documentation skills, team problem solving ability, analytical and programming skills in high speed, quality conscious, and Multitasked environment

TECHNICAL SKILLS

• Informatica
• BI Apps
• OBIEE
• Oracle
• Oracle EBS
• UNIX/Linux
• SQL Developer
• ODI.Shell scripting
• TOAD
• SharePoint
• DAC
• BI Publisher
• Oracle SQL Loader
• Informatica Power Center
• PL/SQL

PROFESSIONAL EXPERIENCE

Sr. OBIEE Business Analyst

Confidential, Dallas,TX

Responsibilities:

• Understanding business requirement and accordingly mapping data elements from various source systems to the appropriate table and column in OFSAA FSDF data model for referential as well as transactional data for FR Y9-C, FR Y14-Q FR Y14-A, FFIEC, PPNR, FR 2052 reports.
• Designing and modifying SCD and T2T (Table to Table) transformations in OFSAA to facilitate the flow of data from Staging to Results
• Coordinate with Credit Risk & Regulatory Automation Project designed to enhance production efficiencies while decreasing operational risk by using automated reporting application AXIOM SL/ Oracle/OFSAACredit Management
• Work with other line of business on initiative of identifying, researching, and rectifying gaps and discrepancies in regulatory reporting application AXIOM SL/ Oracle/OFSAACredit Management
• Work as part of the AXIOM SL/ Oracle/OFSAACredit Management team on the business rules and the change requests
• Assessed and analyzed the business processes and recommended performance improvement in some keyOBIEEareas
• Assisted in implementing the Liquidity Module ofOFSAA(Oracle Financial Services Analytical Applications) for LCR / Federal reporting.
• Implementing FSDF solution on top of OFSAAI to generate the financial reports.
• Deliver the Business Information to the end users via web-based end user tools (OBIEE) in the form of standard reports, dashboards/scorecards, and ad-hoc query capability
• Ensured the correctness of data uploaded toOFSAAstaging, development and production tables by validating it against the source system data.
• Writing Procedures, Functions and T2T Creation, Extraction and Transformation by using Data warehouse ETL Tool i.e. Data Integrator
• Developed and lead team for Liquidity Risk Management (LRM) application onOFSAA
• Worked extensively across LOB in identifying reporting needs, properly organizing financial metrics and data for ad-hoc reporting needs. Created automated reports in Dashboard using Oracle Business Intelligence (OBIEE)
• Developed end to end documentation for forms framework andOFSAAplatform
• Developed good practices for risk modelling procedures related to CCAR/DFAST
• Involved in implementing formula and data analysis for FRY 14A form from Data Dictionary
• Coordinate data set up in production for CCAR regulatory activities.
• Merging, cleansing, manipulating and loading the data using SAS functions and procedures
• Work with SME's of different groups to gain detailed knowledge of Investments and Capital Market and also to understand the cross impacts of the system
• Ensure the regulatory submission and internal audit requirements were properly gathered and identified from the Subject Matter Entities (SMEs) via meetings, phone interviews, workshops, surveys, site visits, and JAD sessions
• Involve in the design of the User Interface (UI) Prototypes for the internal consolidated platform
• Figure out the potential changes to existing data status, and mapped data from sources to target database using MS Excel creating Risk Weighted Assets (RWA), VaR models and updating automated calculation engine required by regulations
• Liaised between system technology & finance control forOFSAA(Oracle Financial Services Analytical Applications) data modeling star schema functionalities system enhancements
• Assist inOFSAA(Oracle Financial Services Analytical Applications) data modeling star schema functionalities and testing in end to end cycle and analyze the star schema of data modeling & provide timely manner deliverables for business line, and profitability insights
• Conduct the ETL Process, extract data from sources and transform the data into the proper format and structure them to write queries and form analysis as well as load it into system
• Perform data validation using SQL queries and implement validation constraints, drew the Data Flow Diagram and Entity Relationship diagram in MS Visio
• Maintain detailed documentation of the BRD, FRD and the User Story using the UML diagrams
• Use roadmap to create theProductbacklog, Release Backlog and the Sprint backlog, and keep the burn down chart up to date in a dynamic environment
• Perform business analysis and impact studies, manage the conflict and negotiated the scope and solution by identifying business risk, dependences and constraints
• Collaborate with Quality Assurance team in functional testing of components, Systems Integration Testing (SIT), Regression Testing and UAT Testing

Sr. Business Analyst

Confidential, Bentonville, AR

Responsibilities:

• Liaised between system technology & finance control forOFSAA(Oracle Financial Services Analytical Applications) data modeling star schema functionalities system enhancements
• Assist inOFSAA(Oracle Financial Services Analytical Applications) data modeling star schema functionalities and testing in end to end cycle and analyze the star schema of data modeling & provide timely manner deliverables forbusiness line, and profitability insights
• Controller View (CV) delivers data lineage, risk aggregation, workflow automation, validation and audit functionality and supports disclosures in multiple formats, including XBRL.
• GRC (Governance, Risk and Compliance) duties - Work with Audit, IT, Governance, Risk, & Compliance, and the Lines of Business to standardize provisioning and recertification processes to ensure proper Data Security Administration practices
• Developed SQL Scripts for the Online Editing Application for the Client interface
• Retrieved and analyzed data using T-SQL, Excel, SSRS
• Used the SQL queries to pull and analyze historical data to determine appropriate loan size, terms, and pricing for the customer
• Developed the Interfaces in SQL for Data calculations and data manipulations
• Assisted in implementing the Liquidity Module ofOFSAA(Oracle Financial Services Analytical Applications) for LCR / Federal reporting
• Ensured the correctness of data uploaded toOFSAAstaging, development and production tables by validating this against the source system data
• Developed and lead team for Liquidity Risk Management (LRM) application onOFSAA
• Developed end to end documentation for forms framework andOFSAAplatform
• Documented an addendum FSR (Functional Spec requirement) for FR Y -9C HC - D, V and E schedules line items
• Involved in modifications of the physical, the BMM, and the presentation layers of metadata repository (RPD) usingOBIEEAdministration Tool
• Delivered online customer analyses, such as: Customer Segmentation, record Retention Analysis and Lifetime Value Analysis. Experience INOFSAAFramework and Profitability
• Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector) usingOracleBI Presentation Services
• ExecutedOBIEEadministrative tasks such asOBIEEserver installation, security set up, migration, Scheduler Schema Upgrade and user maintenance
• Navigated between reports inOBIEEusing java scripts and variables to accomplish user needs
• Supported and executed the migration of multipleOBIEEprojects through platform upgrades from 10g to 11g
• Extensive experience in creating executive reports with BI Publisher integrated withOBIEEand performing features like bursting and passing parameters
• Developed Informatica Mappings, Workflows with Worklets and Tasks in the Task Developer and Workflow Designer respectively in Workflow Manager
• Involved in Unit Testing and comparing the expected and actual results with data in source to that of target by running SQL queries
• Conducted Presentations for End Users on BI Publisher.

OBIEE Consultant

Confidential, Cleveland, OH

Responsibilities:

• Identified the granularity level of the data required to be available for analysis.
• Interacted with business representatives and end users for requirements analysis and to define business and functional specifications
• Drafted prototypes with entailed KPI's and key metrics
• Defining customized T2T, F2T, and DT as per the client requirement.
• Communicated with developer on the business requirement needs
• Assessed and analyzed the business processes and recommended performance improvement in some keyOBIEEareas
• Developed Metadata repository (rpd), Physical layer & Business Model and Mapping, Web Catalog Objects as per data requirements usingOBIEE11G Admin and Web tool.
• Worked onoracleforms and also used SQL developer in performance tuning
• Worked on BI Answers to build Interactive Dashboards with drill-down capabilities
• Designed the business model conforming to functional mapping, defined logical and complex joins for the dimension tables
• Configured the territorial hierarchy and worked with time series objects
• Continually collaborated with developers to deliver Basel required results using theOFSAA/Reveleus solution
• Experience with requirements management, test management and defect management tools like Rally, QC
• Responsible for updating of theOFSAA/Reveleus Metadata documentation to keep documentation in-line with the solution
• Advising other assets engaged in the project onOFSAAconfiguration details
• Configured Sales and Distribution Facts using analytics and generated reports according to the business requirement
• Implemented comprehensive security functionality by creating users & web groups, external table security using session variables, test and validate the model usingOBIEEAdmin tool and associating catalog objects and Web modules with the created users and groups
• Used Filters and provided Customized dashboard prompts appropriately to avoid excessive data showing up Reports
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates
• Assisted in creation of pivot table request allowing manager to analyze the business from different perspectives, provided optimized analytics request using column selector
• Created comprehensive and easy-to-understand Documentation of the complete implementation of Analytics that includes (rpd, Dashboards, Security etc.)
• Generated queries and placed filters inOracleBI Answers and created numerous executive level reports. 'Dashboards' were generated to provide insight into the sales/marketing/financial data
• Performed proof of concepts onOracleBI publisher