Objective:

Seeking a position where I can leverage my knowledge of OBIEE business intelligences, data analytics, accounting, and financial reporting to lead the development of OBIEE Business intelligence solutions. I have experience in client facing role by understanding the business requirements and translating it to a functional needs analysis. I'm comfortable dealing with personnel at all levels of an organization with varying degrees of technical ability and can speak the language of business and incorporate technology to bridge the gap between management and IT to deliver BI solutions that ensures business goals are accurately met. I have a clear understanding of the OBIEE Project Life Cycle.

Professional summary:

• 4 years' developing and supporting OBIEE business intelligence solutions.
• Collect and translate business requirements, document business processes, and understand the functional needs of a business.
• Conceptual designing of physicaland logical data dimensional modeling by using Star/Snowflake Schema and identified Facts, Dimension, KPIs for different business models.
• Metadata Repository .rpd modeling on Physical, BMM, and Presentation Layers by creation of Connection Pools,setting Alias Tables, Dimensional Hierarchy Modeling, creating Logical Column, Aggregates, Time Series functions, Calculation Wizards, applying business logic and etc
• Identified the Aggregate levels for each source and created Dimension sources for each level of Aggregates.
• Reporting on Multiple Fact Tables using Conformed Dimensions.
• Customized Reports Dashboards, Answers, BI Publisher and integrate them into Dashboards.
• BI Answers - developed reports/dashboards in different subject areas with different analytical views narrative, chart view, graphs, pivot table, column selector, view selector with drill down capacity, and etc .
• Add users, groups, and assign permissions by configuring security in Web Logic Console and manage security privileges for each Subject Area and Dashboards accordingly.
• Performance Tuning experience includes setting user log Variables to diagnose performance issues, Cache Management, Aggregation, Event Polling Tables, and usage Tracking Tables.
• Operated in Multi-User Development Environments MUDE .
• Experience with Test Planning including System Integration Testing Units and User Acceptance Testing UAT .
• Identify reporting issues to troubleshoot and fix problems.
• Knowledge of Data Access requirements, including transactional data, business query, and analytics.
• Conceptual knowledge of Data Warehousing and ETL tools.
• Corporate Accounting Policies, General Ledger Operation, Accounts Payable Receivable, Financial Analysis, Cost Analysis, Trend Analysis, Variance Analysis, Financial Reporting, Regulatory Filings, Treasury Operations, Acquisitions, Investors Accounting Reporting, Private Securities Reconciliations.
• Front-Line Underwriting, Manual AUS/DU, Foreclosures, REO, QA, Due Diligence, IRS Tax Forms All Schedules, Credit Income Analysis, Cash-Flow Analysis, Risk Assessment, DTI Ratios, LTV Ratios 1003,1008 , Appraisal Reviews 1004,1073 , Flood, Hazard, Title, MIP, Escrow T I , Closing Funding, Private, Conventional, FHA, VA, USDA, Non-Conforming Loans, FHA Connection.

Technical skills:

• Business Intelligence : OBIEE 10g/11g Version 11.1.1.5, Version 10.1.3.4.1
• OBIEE Tools : Oracle BI Administration Tools, Answers, Dashboards, Presentation Services, BI Delivers
• Platforms : Windows 2003/2007 Server, Window XP/NT/2000/98/Vista/7/8
• Databases : Oracle BI Server 11g, Oracle DB, Oracle MS SQL, SQL Server Studio 2008 Microsoft ,
• SQL Developer 10g/11g
• Applications Tools : MS Office Advanced, MS Excel PivotTables, Vlookups, Macros,
• Accounting Tools : NetSuite, SAP, Avantis, Agris, PTS, Inflinium, Monarch, IBS
• Underwriting Tools : Unifi, Empower, AS400, MSP, LPS, DWS, LIS, Legacy, Pega, Weber, LenderLive,

Experience:

Confidential

OBIEE Developer/ BI Apps Developer

• Member of a team responsible for enterprise reporting for a rapidly growing mortgage servicing consulting company.
• Assigned to a team to Design and Implement OBIEE reports and dashboards for all 4 SEG sites.
• Full life cycle development gathering requirements, documentation, participating in design, development, testingand deploying BI solutions using Oracle 11g Version 11.1.1.5.0. Created Reports and Dashboards to provide insight into agents/teams daily, weekly, and monthly production data.
• Configure pre-packaged reports/dashboards for Financial and HR Analytics. Developed .rpd and reports Dashboards, Answers, BI Publisher throughout the System Development Life Cycle. Create new reports, dashboards, and dashboard prompts in Oracle Answers.
• Analyze and document business processes, user requirements, functional needs, and provide solutions.
• Identified reporting issues to troubleshoot and fix discrepancy.Developed Reports and Dashboards using features like Pivot tables, charts, view selector and developed Oracle BIEE Metadata repository .rpd model using aggregates, dimensions, hierarchies amp time series functions.Implemented user level security for dashboards and reports based on business users requirements.
• Create users/groups and manage their permissions within the web catalog.Managed appropriate security privileges on subject areas and dashboards.

Confidential

OBIEE Consultant Team Lead

• In this project, I worked in two separate departments Financial Reporting Automation Loan Servicing Department on 4 projects involving modeling, designing, developing, and testing of Oracle OBIEE 11g based Business intelligence reporting.
• Main objectives were to achieve reliable financial reporting to comply with increased federal regulations on corporate accountability and to enhance Vice President Level decision making.
• Team Lead role responsible for supervising the transfer/acquisition of Saxon Mortgage loans by Ocwen Financial.
• Team project involved in creating business intelligence solutions for various work streams agent's productions, compensation, compliance, finance by using Oracle Business Intelligence reporting, dashboard tools, and Microsoft SQL Server databases as the development platform.
• Worked with management and data warehouse engineers to identify the source of reporting objects to satisfy the business reporting requirements.
• Created Repository modeling from Physical tables/views into Business/Logical Table Relationships. Assist with the design, development, testing, and documentation of BI/Reports.
• Skilled in Data modeling i.e. conceptual, logical and physical model design, Star Schema/Snowflake schema design, Fact and Dimensions tables, Physical and logical data modeling .
• Customized reports with OBIEE Answers and integrated them into Dashboards. Developed reports dashboards using pivot tables, charts, view selector etc.
• Reporting on Multiple Fact Tables using Conformed Dimensions. Understand the fundamentals of ETL tools, data warehouse life cycle, data management, dimensional modeling, and performance tuning troubleshooting.

Confidential

OBIEE Developer

• Assigned to a team to gathered business requirements by collaborating with AVP and managers to defined subject areas. Created reports to provide insight into the financial and production data.
• Customized Repository physical, BMM, and presentation layers .
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Modified Presentation Layer to add presentation tables and columns.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created Customized Reports Drilldown, Aggregation. Built Business model and established relationships Foreign Keys Physical Logical between tables.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables. Created business reports using BI Answers per requirements.
• Develop Analytics Reports using global and local filters. Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Added users and configured security in web logic console of OBIEE 11g and managed security privileges for each subject area and dashboards accordingly.
• Trained users about OBIEE Tools. Used SQL Tuning to improve performance.

Confidential

Staff Accountant Consultant

• Worked on a team of associate accountant for the company's call center in Lewisville, Texas.
• Performed Cost Accounting, Accounts Payable, Accounts Receivable, General Ledger, Financial Reporting, Fixed Assets, Inventory Control, and Payroll.
• On a team that controlled about 1.5M of capital project. Work closely with business managers to review cost improvement, reconcile variances, and identify areas for productivity.
• Perform comprehensive variance analysis and determine root-cause for each variance accordingly. Working with various department heads to review historical activities, trends, and future obligations.
• Manage month-end closing cycle.
• Key member of SAP implementation team for Standard Cost, AP, and GL/Financial Reporting modules.
• Teamed with internal auditor and Controller to revise internal inventory reporting processes resulting in reconciliation of variance if needed.
• Reconcile inventory at multiple foreign and domestic warehouses and adjust journal entries to balance general ledger with perpetual inventory system.

Confidential

Level III FNMA Underwriter

• Front-line origination underwriting of residential mortgage loans in accordance with Private Investors, Conventional, and FHA/VA guidelines.
• Evaluated the financial strength of borrowers to determine risk and repayment capacity.
• Thorough knowledge of FannieMae and Freddie Mac guidelines.
• Ensured loan submittals meet eligibility requirements per investor's guidelines.
• Fannie Mae Level III underwriting mainly self-employed income and FHA/VA loan requests.
• Restructure loans recommended for denial and present counter-offer on loans that complies with guidelines at an acceptable level of risk.
• Thorough knowledge of complex personal and business financials and expertise in all IRS Tax Returns with All Schedules.
• Analyzed credit, income, assets, appraisal, and title prior to final approval.
• Maintained compliance with lending, underwriting and government requirements.
• Follow-through with borrowers, loan processors, loan originators, and management throughout all phases of the underwriting process.

Confidential

Sr. BI Analyst / OBIEE Developer

• Member of a team using MS Access, MS Excel, and SQL to pull data from production for comparisons and analysis.
• Created production reports using pivot tables, vlookups, macros, and advanced formulas in MS Excel.
• Manage tasks/activities, manipulating data, reporting, importing/exporting of data, and writing queries for reports.
• Query and mine large data sets to discover transaction patterns, examine financial data, and filter for targeted information.
• Collecting and translating business requirements into functional design documents.
• Gained advanced Microsoft Office skills MS Access, Visio, Excel, and Project and exposure to Business Intelligence tools e.g., OBIEE 10g/11g.Worked with data warehouse administrator and other team members to design and implement changes to support and troubleshoot any problems to the reporting environments through Oracle Business Intelligence OBIEE 10g 11g.
• Work directly with decision maker, business analysts, and other IT staff to translate requirements into accurate reporting solutions.
• Worked closely with data administrator and ETL developer to extract, transform, and load new data requirements for use by OBIEE in reporting.
• Advance OBIEE Development and Dimensional Data Modeling with conceptual, physical and logical data modeling, Star/Snowflake schema design, Facts and Dimensions tables.
• Metadata Repository .rpd modeling on Physical, BMM, and Presentation Layers using aggregates, dimensions, hierarchies amp time series functions etc.
• Developed .rpd and Reports Dashboards, Answers, BI Publisher throughout the OBIEE Development Life Cycle.
• Customized reports with OBIEE Answers and integrated them into Dashboards. Developed reports dashboards using pivot tables, charts, view selector etc.
• Reporting on Multiple Fact Tables using Conformed Dimensions.
• Identified reporting issues to troubleshoot and fix problems. Create users/groups and manage their permissions within the web catalog.
• Implemented user level security for dashboards and reports based on business requirements.
• Collaborated with IT and business decision maker to support project management, requirements, design, test, and implementnew projects/reporting.

Confidential

Associate Accountant

• General Ledger Operation - Prepare, review, and approve journal entries, GL Maintenance, review of balance sheet and P L.
• Daily account payable function full cycle, from coding, data entry to payment process monitor and support employees expense reporting and accounts reconciliation, analysis, and year-end audits.
• Prepare and review of revenue, expense variance, and trend analysis.
• Financial Reporting - preparation presentation of monthly revenues and expenses.
• Treasury Operations - Monitor daily cash movements and transfers. Regulatory Reporting - Ensure regulatory reporting with county and local regulators are accurate and filed before due date.