SUMMARY

• 7 Years OBIEE Certified Developer, Extensive Data modeling experience in Star Schema/Snowflake schema design, Fact and Dimensions tables, Physical and Logical Data Modeling.
• Build Dashboard and Ad hoc reports.
• Working knowledge in ETL/Data integration using ODI and Informatica as a data source.
• Expert working knowledge of OBIEE dashboard Development.
• 20 plus Years of IT experience.
• In deep knowledge on Fusion Middleware Technology, concepts and data warehouse architecture.
• Setup ETL process to extra data from various data source.
• Design and develop OBIEE report, dashboards and answers.
• Developcomplex ad - hoc queries using OBIEE tools like Answers.
• Design and develop Repository (RPD’s).
• Expert in writing SQL statement to verify table content.
• Develops reports using BI Publisher and setup different agents.
• 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.
• 5 Years of extensive experience with OBIEE version 10g /11g analytical backend development.
• Extensive experience with Fusion Middleware with working knowledge of 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 with security.
• Expertise in design and building 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 Informatics.
• Good written and verbal communication skill.
• Flexible working schedule.

TECHNICAL SKILLS

Oracle: Business Intelligence Foundation Suite 11g Certified, Oracle Database 11g Certified, MySQL CertifiedTechnical Skills

Data Warehouse: Enterprise Fusion Middleware, Essbase, SQL Loader

Business Intelligence: Fusion Middleware 11.1.1.7, 11.1.1.6, 11.1.1.5, 10.1.3.4, 10.1.3.4.2 , 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, Secure CRT, 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.

PROFESSIONAL EXPERIENCE

Confidential, Portland, Oregon

Business Intelligence Developer

Responsibilities:

• Understand the business. Gathered Business requirements by interacting with various teams, users and managers.
• Defined subject areas for analytical data requirements. Identified source system OBIU (Oracle Business Intelligence Utilities) ODI, OMS and Informatica.
• Business requirements by interacting with various teams, users and managers, defined subject areas for analytical data requirements.
• Setup connection pool and the data model. Start developing physical layer. Determine fact tables, dimension tables, start creating aliases and joins.
• Build dashboard and Ad hoc report. Schedule report and setup agent to run report.
• Setup KPI (Key Performance Indicator)for business to make decision in a timely manner.
• Create Business and model layer by creating logical table, logical columns, dimension and hierarchy.
• Example years, half, quarter, month and day. Run consistency check to determine errors and correct them.
• Develop the presentation layer, setup presentation tables, apply security on the various tables, and build dashboards and reports.
• Create agent and schedule reports to run before business hours. Work in a MUD environment, check in and check out other projects.

Confidential, Dallas, Texas

Business Intelligence Developer

Responsibilities:

• 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 Project in 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.
• Build dashboard and analysis student performance including top subject area student register in Texas
• 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 project in RPD and check out project in 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 using 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 Actual vs. 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 Agents 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, Irving, Texas

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.
• Manage 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 for various user accesses.
• 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 Dashboards with Dashboard prompts, Charts, Pivot tables.
• Resolve performance issues on 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.
• Write and document RPD design process for intuitive understanding and future reference.
• Performed production support for the project.

Confidential, Irving Texas

Oracle Database Administrator

Responsibilities:

• Created and maintained 50+ Oracle 9i, 10g, 11g databases. Some configurations use Oracle Data Guard for the DR/Standby solution and RAC in a SAN platform.
• Use RMAN for backup and recovery; use oracle tool AWR/ADDM and OSWatcher to diagnose database problems.
• 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 Confidential the retail stores.
• User Golden Gate 11g for data replications and movement of large data from one platform to another platform with decision making...
• 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

Confidential, Grapevine, Texas

System Administrator

Responsibilities:

• Use tool and write scripts for mass installations in Window environment.
• Use tool like FTP in UNIX environment to copy and transfer files between systems.
• Resolve and load customer software and test and approve installations.
• Resync Aspect ACD Switches in (Windows and UNIX Platform).
• Administer Aspect Ray 6, 7, 8 & 9 Voice Switch (Unified Platform).
• Install Aspect Telset and bounce trunks.
• Run back up for, voice and data, setup IP for each telset to access, and monitor Agent and Supervisors on the Aspect Switch.
• Responsible for the daily maintenance of the Aspect ACD switch, servers and desktop applications