Technical Skills

• Business Intelligence Tools: OBIEE 10.1.3. /11.1.1.5/11.1.1.6/11.1.1.7
• Languages: SQL, PL/SQL, HTML.
• DBMS, RDBMS : Oracle 10g, 11g, SQL Server , MS Access, MYSQL,
• Oracle Tools/Utilities : SQL Developer, TOAD, SQL PLUS
• Proficient and advanced knowledge in WindowsXP 98/2000/2003/Win7 8,Vista.

Confidential

OBIEE Developer

• Five years experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Business Intelligence.
• Expertise in complete lifecycle implementation of B.I. utilizing Star and Snow flake Schemas using Ralph Kimball and Bill Inmon Methodology
• Proficient in designing schema using Facts, Dimensions, Physical, Logical, and Alias tables.
• Strong experience in OBIEE 11.1.1.7, which includes design and development of OBIEE Repositories at three levels: Physical Layer, Business Model and Mapping, and Presentation Layer.
• Expertise in building star and snowflake schemas in the repository as well as using the New Foreign Key link in the physical layer and the new Complex Join Key in the Business Model and Mapping layer
• Extensive Experience in OBIEE Administrative Tool, OBIEE Answers/Analysis, OBIEE Dashboards, OBIEE Delivers and BI Publisher.
• Expertise in developing Logical Tables and Columns, Dimensional Hierarchies, Level Based Measures, Time Series Function, Repository and Session Variables.
• Proficient in defining Key Performance Indicators/Metrics KPIs , creating reports using Action Links and establishing relationships using Master-Detail linking of different views.
• Highly experienced with repository development, configured metadata objects Subject Areas, Tables and Columns and Web Catalog objects Dashboards, Pages, Folders, Reports .
• Experienced and highly skilled in designing customized interactive dashboards using guided navigation, prompts, filters, variables, and drill down features.
• Extensively worked with DBAs and Business Analysts towards performance tuning in OBIEE and Data Warehouse environment using cache management, aggregate tables, query rewrites and indexes.
• Experience in managing users and groups, setting up their privileges and administering the Object Level Security and Data Level Security.
• Experience in administering the Web logic Console and Oracle Fusion Middleware Enterprise Manager.
• Experience in using and troubleshooting the main servers: Oracle BI Server, Oracle Presentation Server and Oracle BI Scheduler.
• Knowledge and proficiency working in a Multi User Development Environment MUDE , defining projects and pulling RPD from versioning tool to common directory and making changes to meet business requirements.
• Expertise in managing the NQSCONFIG.INI files to manage the RPD, and other parameters.
• Experience and knowledge of OBIEE Enterprise installations, upgrade, patching and configurations.

Professional Experience

Confidential

OBIEE Developer

• Worked closely with the Senior Business Intelligence Developer and team members to develop, schedule and maintain custom queries as assigned.
• Defined, designed and provided reporting at all levels for the Corporate and Investment Banking Vice Presidents
• Provided insights into the Corporate and Investment Banking client bases
• Worked seamlessly with end users and IT personnel on problem resolution tasks for data warehouse and business intelligence
• Implemented and executed Information Technology and Business Intelligence based strategies to help improve products, enhance customer relationships, and make better, well informed forecasts based on market trends, handle competition, manage risk and increase operational efficiency.
• Incorporated BI tools to analyze the banks data from various branches, employees, deposits, loans, sales, and expenses, profit and loss into business metrics such as product profitability, and new market opportunities.
• Assisted in the collection and organization of regulatory compliance data with particular focus on the federally approved formats.
• Successfully modeled and analyzed customer-level data on product offerings, channel activity and profitability to improve the targeted account sign-up applications in Retail Banking.
• Created different types of customized reports including charts and tables to meet the bank's departmental immediate and long-term business reporting needs.

Confidential

BI Developer

• Served as an active duty Marine with a security clearance, and received an Honorable discharge.
• Communicated with the Commanding Officers from the 1st Logistics Group to gather requirements and define the requirement specifications document.
• Developed reports, charts and graphs based on end-user reporting requirements using data available in the deployed financial systems.
• Developed data marts for the Deployed Regiment Supply System based on the Commanding Officer's needs and requirements from Department of Defense.
• Utilized Structured Query Language SQL through SQL editor and report writing tools.
• Provided training and guidance to end-user groups
• Coordinated departmental activities with other Regiments, Administrators as well as provided assistance to various departments as per request.
• Compiled data and research results for use in meeting information requests, decision support systems and Business Intelligence activities.
• Assisted in evaluating accountability measures, program evaluation, military aptitude testing and prepared summary and detailed statistics and reports.
• Designed schema using the predefined KPIs, using the Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Identified and set up the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement.
• Exported various dashboard reports and catalog objects to Excel and PowerPoint to aid with reporting and presentations.
• Implemented Data level as well as Object level security, managed the daily .rpd, Scheduler, and iBots/Agents.
• Created numerous executive level reports and dashboards catering to provide insight into the financial data and student and staff performance.
• Created ad-hoc reports using BI Answers as per Commanding Officer requirements.