Visa Status: Green Card Holder (will become US Citizen in 2010)

Objective:

Seeking a position as Data warehouse/Oracle BI developer in your company that will allow me to apply my skills and knowledge in data warehouse design, development and testing

Summary:

Oracle Data warehouse/BI Developer with 4+ years of experience primarily in Data warehouse development, ETL, Business Intelligence areas:

• Solid Knowledge of Data warehousing (Star Schema and Snow flake Schema)
• Good knowledge of Data modeling, E/R diagrams, normalization and de-normalization as per business requirements
• Solid Knowledge of Oracle business intelligence (OBIEE) tool like Seibel Analytics , OBIEE Administration and Oracle BI Analytics Applications
• Solid knowledge of ETL methods and Experience in ETL tools like Informatica Power Center 7.1.4, OWB and Hyperion Extended Analytics
• Good knowledge of creating and managing OLAP 10g Cude and used against OBIEE
• Good knowledge of indexing, materialized views and table partitioning
• Strong Experience in Oracle database Maintenance and Support with SQL, PL/SQL, SQL*Loader, Unix Shell Scripts
• Extensively used PL/SQL, built in Oracle Packages, stored procedures, functions, triggers, cursors and views for processing data, enforcing referential integrity for business rules
• Good knowledge of Oracle E-Business Suite 11i and Oracle Business Intelligence Applications (Pre-Built)
• Good Knowledge of Cube Database Hyperion EssBase
• Knowledge of Business Objects like Oracle reports and Oracle Discoverer
• Good knowledge of query optimization
• Excellent analytical and problem solving skills and can work independently
• Excellent Communication and responsible team player
• Quick learner with an ability master new concepts and applications

TECHNICAL SKILLS:

Operating Systems

Windows NT/2000/2003, Solaris 9, HP-UX 10/11, Linux

Programming languages

C, C++, VC++, C#.NET, Java, PL/SQL Programming

Web Technologies

HTML, XML, IIS

Script Languages

Unix Shell scripting

Tools

Toad, Informatica Power Center 7.1.4, OEM, Oracle AWM, OWB, Oracle Reports, SQL Developer, OBI Answers (Seibel Analytics), MS Office, OBI Administration, Oracle Discoverer. Hyperion Extended Analytics, Oracle E-Business Suite 11i

Database

Oracle 10G/9i/8i/8

Others

Object Oriented Designing Methodology, UML, RDBMS Concepts, Data warehousing concepts

Educational Qualifications:

Master of Science in Computer Engineering, (May 2007)
Farleigh Dickinson University, Teaneck, NJ GPA: 3.57

Bachelor of Engineering in Computer Engineering, (May 2004)
Dharmsinh Desai Institute of Technology, India GPA: 3.0

Certifications and other Credentials:

Oracle Certified Associate Developer (Introduction to Oracle SQL)
Oracle 10G DBA-1 workshop
Oracle Hyperion EssBase boot camp instructor based training Workshop

Work Experience:

Confidential,

Client Name: US General Services Administration
Project Name: Infowizard Migration

• Involved in installation and Configuration of OBIEE
• Involved in creation of Different layers in RPD, Drilldowns, Time Series functions, Variables etc
• Configured Standalone OBIEE RPD to include concepts like Dimension binning to make OBI EE generate valid queries
• Involved in setting up Data level security for the OBIEE Reports and handled the security and privileges from the Database to the Oracle repository.
• Involved in Analysis, Design, development and customization Dashboards
• Implemented the delivery of iBots using Delivers to alert the associated teams
• Created OLAP Cube in Oracle 10g by Oracle AWM tool and configured OBIEE RPD against OLAP Cube
• Involved in writing complex SQL query to calculate complex result
• Involved in installation and Configuration of OBIEE components
• Involved in formulating the process of repository and web cat migrations from DEV to UAT and PROD Environments
• Involved in configuring OLAP excel add-in on top of OLAP Cube

Environment: Windows 2000 professional, UNIX, TOAD, Oracle SQL Developer, OBIEE Administration, OBIEE Answers, AWM, Oracle OLAP Excel Add-in

Confidential,
Project Name: National Measures Migration

• Extensively involved in creating and managing repository by OBIEE Administration tool
• Involved in creation of Different layers in RPD, Drilldowns, Time Series functions, Variables etc
• Involved in setting up Data level security for the OBIEE Reports and handled the security and privileges from the Database to the Oracle repository.
• Involved in installation and Configuration of OBIEE
• Involved in Analysis, Design, development and customization Dashboards
• Created different types of view like Pivot table, Column Selector, View selector, Graphs etc
• Extensively involved in Data Extraction, Transformation and Loading(ETL)
• Involved in writing complex SQL query to calculate complex result
• Involved in installation and Configuration of Oracle BI tools
• Created and maintained Materialized Views, Partition table and table index for Database performance
• Extensively involved in writing Oracle PL/SQL procedures, triggers, views, packages, sequences

Environment: Windows 2000 professional, UNIX, OWB, PL/SQL, Oracle, TOAD, Oracle Reports, Oracle SQL Developer, OBIEE Administration, OBIEE Answers

Confidential,

• Extensively involved in creating and managing repository by OBIEE Repository tool (Oracle Administration tool)
• Extensively involved in developing dashboards by OBIEE (Siebel Analytics) Answer
• Configured Prebuilt Oracle Business Intelligence Application
• Extensively involved in modifying Prebuilt (Oracle BI Analytics Applications) Dashboards and Metadata Repository
• Configured DAC to include Subject Areas for Financial Analytics and to include custom tasks to execute custom Informatica mappings
• Developed Data stage mapping for moving data from Source to Staging tables (SDL) and Staging to Target data warehouse (SIL) by Informatica Power Center
• Extensively involved in modifying Prebuilt (Oracle BI Analytics Applications) Informatica Mappings
• Involved creating Sessions, Worklet and Workflows in Workflow manager and Scheduling ETL job(workflows) by Informatica Workflow Monitor
• Created and maintained Materialized Views, Partition table and table index for Database performance
• Extensively involved in writing Oracle PL/SQL procedures, triggers, views, packages, sequences
• Involved in huge amount of data loading using SQL Loader
• Involved in Extracting data from Hyperion Financial Manager (HFM) by Hyperion Extended Analytics
• Worked in Oracle E-Business Suites 11i INV, OM, HR, PA,AR,AP and PO module to develop reports by Oracle Reports
• Wrote UNIX shell script to Automate ETL
• Involved in writing complex SQL query to calculate complex result
• Involved in installation and Configuration of OBIEE and Informatica Powercenter

Environment: Windows 2000 professional, Informatica Power Center 7.1.4, PL/SQL, Oracle, TOAD, Oracle Reports, Oracle SQL Developer, OBI Answers, Oracle EBS 11i

Confidential,

I was working as a database developer

• Created many complex queries for providing the solutions for front-end developer in development phase
• Created PL/SQL stored procedures, packages and functions by analyzing the data and identify format and value discrepancies
• Created views to resolve complex queries
• Creating, modifying and enhancing procedures for new releases

Environment: Windows 2000 professional, PL/SQL UNIX Shell Scripting, Oracle, TOAD

Confidential,
India Dec 2003-May 2004
I was working as an intern student in Icubix InfoTech.

• Created PL/SQL stored procedures, packages and functions by analyzing the data and identify format and value discrepancies
• Created views to resolve complex queries
• Monitoring existing SQL code and performance tuning
• Created materialized views and partition tables
• Loading a data into tables from flat files by SQL*Loader and external tables
• Running and monitoring Unix shell scripts
• Scheduling Jobs by Crontab and by oracle inbuilt packages

Environment: Windows 2000 professional, PL/SQL UNIX Shell Scripting, Oracle, TOAD, Oracle Reporting

Academic Projects

Casino Database Designing [Oracle, UNIX]
Description: These projects were database-designing project. It included logical and physical design of casino database. It also included an actual implementation of tables by SQL by using of Indexing and triggers. It also included some PL/SQL procedures for insertion and updating a data.

Online ordering System (Music Store) [Object oriented analysis & Design using UML]
Description: This system analyzed and designed using Unified Modeling Language (UML). The system took care of online ordering of Audio CDs, checking there availability and making the order current back-order or advance order, online payments. It also generated invoice and bills for the same.

Railway Reservation Project - DBMS Project [Java, Oracle]
Description:The system gave detailed information about availability of seats, fare of different routes, concessions for all classes, train schedules. It also, allowed booking and cancellation of train tickets and generated reports for the total transactions daily and weekly.

References available upon request