We provide IT Staff Augmentation Services!

Business Intelligence Developer Consultant Resume Profile

Dallas, TexaS

Summary:

5 Years OBIEE Developer ,Extensive Data modeling experience in Star Schema/Snowflake schema design, Fact and Dimensions tables, Physical and Logical Data Modeling. In deep knowledge on Fusion Middleware Technology and concepts. Design ETL process to extra data from various data source. Design and develop OBIEE Dashboards and answers. Assist with the development of complex ad-hoc queries using OBIEE tools like Answers. Design and develop Data Marts and the associated RPD's. Develops reports using BI Publisher. Participates in the day-to-day support of existing Dashboards and Reports. Development and design of ETL processes and the associated Data Marts and Operational Data Stores. Develop and govern standards relating to Data Warehouses, Business Intelligence and Reporting. Work with Managers to establish data quality baselines. Recommends data strategies and provides technical guidance to the organization, translating business and technical requirements into solution designs. 5Years of extensive experience with OBIEE version10g / 11ganalytical application architecture and development. Extensive experience with Fusion Middleware, DAC Support and ESSBASE cubes in 11g. Strong in OBIEE Metadata development including Projects, MUD Environment, Migration, Deployment, Applying patches, Maintenance etc., OBIEE metadata RPD design and development - including design and definition of logical tables, physical sources, dimensions, columns and aggregation rules. Responsible for the deployment and maintenance of the Physical Layer, Business Model and Presentation layers in OBIEE repository. Expertise in design andbuilding Dashboards Reports. Good foundation in industry standard Data Warehousing design concepts. 6 years of extensive experience in Database Administration include Database Design, Programming and Deployment in Oracle and MySQL. Proven working knowledge of star schemas and data warehousing modeling techniques Strong Oracle SQL Skills, PL/SQL, SQL Developer and Toad Skilled in writing SQL queries and optimization of SQL queries Responsible for ensuring compliance with performance criteria through database SQL and metadata/report tuning Ability to work independently with little or no supervision Good ELT/ETL knowledge, preferably ODI or Informatica Good written and verbal communication skill Flexible working schedule

Technical Skills:

Data Warehouse: Enterprise Fusion Middleware, Essbase,SQL Loader

Business Intelligence: Seibel Analytics, Informatica 8.2, OBIEE, Seibel Answers/Delivers, Security and Performance

Operating Systems:UNIX Sun Solaris, AIX, HP, Dell, Linux, Red Hat and Window Servers,

Database:Oracle 12c/11g/10g/9i, MySQL, SQL, Teradata

Data modeling: Erwin 3.1, Toad, SQL, SQL Developer

Tools:DAC 10.1.3.4.1, Siebel Analytics .7.8.2/7.7.1, Informatica 8.2, Toad, SQL, PL/SQL, WinZip, IBot, Source Anywhere, Microsoft Excel, Outlook, Messenger, PowerPoint, Word, Access, Visio, Golden Gate 11g, SecureCRT, Secure FX, WINSCP, Text Pad,MySQL Workbench,Note, JIRA, Source Anywhere, Password Manager, Nagois, OEM, Grid Control, Toad, Putty, Exceed, VM Ware, ASM, SQL, Oracle Enterprise Manager, RAC, Service Manager, JIRA, AWR, PKPROF, SQL Developer, HP Database and Middleware Automation Solutions.

Languages:SQL, PL/SQL, Java scripts, Visual Basic, UNIX Scripts, C , XML, Perl scripting, Shell Scripting, C , Visual C.

WORKING EXPERIENCE

Confidential

Business Intelligence Developer Consultant

Responsibilities: Gathered Business requirements by interacting with various teams, users and managers, defined subject areas for analytical data requirements. Identified various source systems to better understand business needs. Design ETL to load data from data warehouse, Oracle, MySQL, SQL Server and Teradata to meet business needs. Advance knowledge and concepts on Essbase architecture. Setup Star Schema/Snowflake schema. Design Fact and Dimensions tables, Design Physical and logical data model mapping layer. Design Projectin MUD Environment, Migration, deployment, applying patches, maintenance and use ETL process to extra data from various data sources. OBIEE metadata RPD design and development - including design and definition of logical tables, physical sources, dimensions, columns and aggregation rules. Builddashboardand analysis student performance including top student in Texas and group thembyvarious Texas public schools. Responsible for the deployment and maintenance of the Physical Layer, Business Model and Presentation layers in OBIEE. Performed gap analysis and feasibility study for the given requirement. Created mockup reports and dashboards for review by the business users. Work in MUD project environment by check in RPD and check out RDP and later merge the RPD. Customized the OBIEE 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 to meet the business user needs. Worked on repository and session variables. Used the security settings in Siebel Analytics Admin tool to setup users, Groups and Access privileges. Created materialized views and aggregates to improve performance. Customized Activity and Revenue star schemas. Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance. Customized reporting with OBIEE Answers and integrated them into the Dashboards. Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector. Created dashboards with global prompts, column selectors, navigation, and automatic drill-down. Created user level security for intelligence dashboards based on Business Requirement. Customized and Developed OBIEE Analytics Reports Account Activity, Revenue on business segmentation, and Actualvs. Forecast Response rates, Segment and Offer responses. Created Dashboards with Dashboard prompts, Charts, Pivot tables. Performed Data Validation of data in the reports and dashboards. Extensively used SQL Tuning to improve performance. Created iBots to send pre-processed reports using OBIEE Delivers. Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results. Worked on evaluation of Oracle BI Enterprise Edition and its new utilities including BI Server, Answers, Delivers and Publisher. Document the project for future references. Performed production support for the project.

Confidential

Oracle Business Intelligence Developer

Responsibilities

Worked closely with the business users and managers to make sure that business requirements are correctly translated into database schemas and ultimately into the application. Interacted with end users and developers to validate the data model. Design ETL to load data from data warehouse, Oracle, MySQL, SQL Server and Teradata to meet business needs. . Design and develop repository for various groups and projects Requirement validation of the reports and drill downs with business users. Analysis of existing OLTP system and Identification of required dimensions and facts from the Database. Creation and Customization of the OBIEE Repository Physical, Business and Presentation layer . Responsible for creating users and maintaining visibility privileges using Analytics administration on the repository side. Expert in cache management, Repository migration, data level and object level security in OBIEE Analytics. Created connection pools, imported physical tables and defined joins in the physical layer of the repository. Worked on role-based dashboards in Retail sales. Created hierarchies based on the territory level for territorial level sales and contact reports. Modified Presentation Layer to add presentation tables and columns to meet the business user needs. Worked on repository and session variables. Created materialized views and aggregates to improve performance. Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance. Customized reporting with OBIEE Answers and integrated them into the Dashboards. Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector. Created dashboards with global prompts, column selectors, navigation, and automatic drill-down. Created user level security for intelligence dashboards based on Business Requirement. Created Dashboards with Dashboard prompts, Charts, Pivot tables. Performed Data Validation of data in the reports and dashboards. Extensively used SQL Tuning to improve performance. Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results. Worked on evaluation of Oracle BI Enterprise Edition and its new utilities including BI Server, Answers, Delivers and Publisher. Documented the design for intuitive understanding and future reference. Performed production support for the project.

Confidential

Oracle Database Administrator

  • Create and monitor 10 plus MySQL Databases in Solaris, Linux using MySQL Workbench to monitor databases.
  • MySQL installed on various versions.
  • Database changes and implementations follow strict Change management process.
  • Install patch and maintain all Oracle software.
  • Configure, Install and Troubleshoot RAC environment.
  • Write PL/SQL script to pull detail information on production performance issues using explain plans.
  • Monitor and configure RAC services and check alerts logs on the primary and standby database for error.
  • Tune Oracle instance components including MySQL, SQL and PL/SQL.
  • Design and implement backup and recovery systems.
  • Implement Oracle failover technology Data Guard.
  • Experience with OLTP, dimensional database design and code implementation.
  • Work closely with the Developers in resolving performance issues and implementing process.
  • Proactive personal with a proven track record of delivering responsibilities and task.
  • Work closely with the Business Intelligent Team with home grown application RMS Application to resolve issues at the retail stores.
  • User Golden Gate 11g for data replications and movement of large data from one platform to another platform with decision making...
  • Managing up to 40 Oracle databases on different UNIX platforms in SAN environment: Sun Solaris, Linux Red Hat and AIX, HP and Dell. Administered in releases from 11g/10g/9i. Task includes install, migrate and upgrade Oracle, create database, database maintenance, database security, performance tuning, backup and recovery. Provide 24x7 production supports for mission critical databases.
  • Use and configure RMAN for database backup and recovery.
  • Use Enterprise manager to monitor database health and check logs files for error.
  • Managed 20 databases for 5 different sites across Texas.
  • 24 x 7 worldwide rotations on call as last line system supports defense

Hire Now