Candidates About

 

Siraj Quraishi

SUMMARY

Ø  12 years of solid Data/ETL and APPS architecture, design and implementation experiences on Oracle Enterprise Applications and Database Solution.

Ø  Experiences in Administering, Supporting and developing Oracle Business Intelligence in multiple industries Financials, Pharmaceutical, Governments, and Retails. 

Ø  Expert in gathering Business Requirements, analysis, design, development, testing and supporting Data Warehouse, Data Mart and Business Intelligence.

Ø  Expertise in data analysis, data mapping, data extraction, data staging, data movement, data aggregation, data version/cleansing, data load, performance tuning, data quality profiling, monitoring and resolution using ODI, BI APPS, Informatica and OBIA.

Ø  Installed, Build, design, RAC, Central Backup/Recovery, Clone, RMAN, Data Guard, Grid, OEM.

Ø  Expert in configuring ASM file system, OCR, ASMLIB, ACFS and Oracle Clusterware   Services.

Ø  Highly experienced in designing, building, implementing and maintaining large and complex heterogeneous Database Management Systems.

Ø  Generating complex metricsrequirements documents using MS Excel Spread Sheet.

Ø  Experienced in designing and implementing Relational and Dimensional modeling, OLAP, OLTP, Hierarchies and Partition huge tables.

Ø  Extensive experiences with Oracle Stored Procedures, UNIX embedded scripts and experienced in loading data into Data Warehouse/Data Marts using Informatica and SQL*Loader.

Ø   Generated Dashboard, Reports, Analysis and BI Publisher Reports using OBIEE Analytics.

Ø  Highly experiences in MS Access Database design and implementing small database inventory.

Ø  Created and documented project layout in Power Point and enhanced with Graphics and Charts.

Ø  Excellent problem solving skills with a strong technical background and good interpersonal skills.

 

 

 

TECHNICAL SKILLS

Systems	AIX, Linux, UNIX, Solaris, Windows NT 4.0/2000, Windows98/XP/07, IBM-PC (DOS), VAX 785 (VMS), and VAX 8600 and HP-UX
Databases	Oracle RDBMS 9/10g/11g, SQL Server 2000/2005/2007, DB2 UDB 7 /8.1, Sybase.
Languages	PL/SQL, ASP, NET, SQR, CGI, Perl, Korn, AWK, HTML, C++, PRO* C and Java.
Scripting	Autosys, Perl and Korn Shell Scripting and Vi editor.
Applications	EBS R11/EBS R12, OBIEE, WebLogic, RAC, OEM, Data Guard, Informatica, IBM WebSphere,AscentialDataStage, IBM RTC, Oracle Applications, Forms, Reports, API, , MetaStage, IBM Rational Applications Platinum ERwin, Informatica, Business Objects, Microsoft SQL, Sybase, Siebel, WebSphere MQ Series, Rational ClearCase, PVCS and Apache Web Server application.
Networking	SAN, NAS, NETAPPS, NIS, NIS+, DNS, DHCP, TCP/IP, RAID, NFS and SMTP.

 

 

 

 

 

 

EXPERIENCES

Global data Securities Equities and Fund (GSEF)                                                 October 2014 -Present

Senior Oracle Business Intelligence Developer

               

§  Implemented and Developed OBIEE 11g HRMS for GSEF Human Resources for employees more than 70 thousands.

§  Supported team with Administrative support needs for patch installation, securities, and upgrade in all BI environment.

§  Participated in Full upgrade and conversion of Informatica to ODI as part of new BI Applications.

§   Developed critical custom ETL in ODI and migrated many custom ETL from Informatica into ODI.

§  Helped and tuned slow performance load in Daily and Full Load batch.

§  Configured Payroll, OTL, Absence, TERM and Employees Detail Dashboard and Reports. 

 

        Environments: OBIEE 11.1.1.7,BIAPPS 11.1.1.8.1,ODI 11.1.1.7.0,EBS 12.1.0,DB 12.1.0,

        Informatica 8.6.1(HF 11),DAC 10.1.3.4.1,OBIEE 10.1.3.4.1,BIApps 7.9.6.2

        Exadata X7 Machine, Exadata System Software 18c (18.1.0)

 

Irvine Ranch Water District                                                                                            February 2013 - October 2014 

Senior Oracle ApplicationsDBA

Responsibilities:

 

Ø  Configured and created instances of Business Intelligence OBIEE in ASM and RAC environment.

Ø  Developed and configured Oracle custom reports in OBIEE for Oracle Projects.

Ø  Upgraded Oracle database, Informatica, OBI, OBIEE and OEM to 12c.

Ø  Supported Oracle Utilities and Customer Care Billing for new implementation.

Ø  Configured and created instances of EBS R12 Databases on Linux in ASM and RAC environments.

Ø  Developed Life Cycle management of Oracle EBS Applications using Change Management Application.

Ø  Enhanced Applications while applying update patches and code changes.

Ø  Helped migration team to successfully migrate EBS from Legacy ERP.

Ø  Configured EBS concurrent managers for optimal performance.

Ø  Setup and Synced Failover Disaster Recover (DR) for ERP and Reports systems.

Ø  Applied and updated EBS HRMS tax codes with VERTEX.

 

 

Environments: RDBMS 12c/11g/10g, OBIA 11g, ODI 11g, EBS R12, Rational Team Concert(RTC), Novell Service Desk, AS400, DB2, DBMS, OBIEE, OEM, Informatica, DAC, OBI, Weblogic, OID, Fusion, ASM, RAC, Toad, NetAPPS, Linux, VMWare.

                                               

County of Los Angeles                                                                                                   November 2011 - February 2013

Senior Oracle Applications DBA

Responsibilities:

 

Worked in County of Los Angeles, home for more than 244,000 businesses. One of the biggest county in United States with budget $25 billion. It is the nation top international trade, manufacture and public services center.

• Government public sector division of Internal Service division (ISD) I deployed maintained and administrated Oracle Applications and Infra structures.
• Participated in the upgrading Enterprise Resource Planning (EBS) Financials to release R12.1.1. 
• Centralized Applications authentication using Oracle Directory (OID) and Single Sign On (SSO). 
• Integrated Business process using Service Oriented Architecture (SOA) and BPEL.
• Deployed Oracle fusion applications such as case management and benefits using Weblogic and OHS.
• Upgraded APEX applications with oracle Forms, Reports and Discoverer.
• Day to day maintenance included patching, cloning, and administration of concurrent manage process, Users, Forms, Reports and performance issues.
• Participated in Oracle Access Manager implementation, which centralized and enhanced users and applications authorization with Active Directory.

 

Environment: EBS R12, SMS change Management, SOA, Fusion, Weblogic, APEX, OAS, OID, SSO, OAM, AD, ADF, OC4J, BPEL, VMWARE, Apache, OHS, JAR, WAR, AIX, Linux, Windows, Mainframe, Oracle, DB2.

Application: YBN, LAGAN, CAMS, PCMS, CDMS, CHHRS, CBO, DPW, CSC.

 

 

 

TIRECO INC                                                                                                                         March 2011 – November 2011

Senior Oracle EBS Application Lead

Responsibilities:

 

• Installed, configured and upgraded Tireco Enterprise Databases. Cloned EBS 11.2.0.7 for their DEV and TEST environments. Applied patches and automate many tasks to make Database run optimal performance and pro-actively alert databases health check.
• Administered Oracle EBS Application, applied rollup patches, configured CONTEXT files and customized Oracle Forms, menu, and workflows.
• Design and implemented single Node Instance into Multi node Oracle RAC environment for reliability and scalability. Also configured Data Guard hot standby for business critical.
• Migrated and upgraded EBS 11i Unix Solaris environment to Linux (OEL VM).
• Tuned database for higher performance, analyze, explained and trace sessions for bottleneck queries, and configured instance optimal parameter setting.
• Worked with Developer team to create interfaces for other Applications interact with Databases.
• Designed and configured RMAN as their central backup and recovery for their entire Enterprise Databases. Configured RMAN for hot incremental and full backup with compression.
• Implemented Data Model, Data Design, and Normalized Data for Data warehouse, and configured ETL jobs for Reporting and Dashboard.
• Supported daily Database call for maintenance and administration such as performance, connections, locks, refresh data and security issues.

Environment: Oracle Database 9i/10g/11g RAC, RMAN, Data Guard, Oracle EBS 11i, Unix Solaris, Linux Vmware, SharePoint, Logility Demand Planning, NetBackup, Discoverer

 

 

 

Kaiser Permanente                                                                                                         February 2010 – March 2011

Senior Oracle Applications DBA

Responsibilities:

 

• Architected designed and implemented Oracle EBS 11.2.0, and integrate with Kaiser Learning Management Solution. Detailed Mapped out HR modules for interfaces.
• Developed and performed planning of architecture, functions, modules, recovery, standards and implementation of robust database using the best performance and High availability of data.
• Installed, configured and upgraded (LMS) with newer database Oracle 11G in RAC environment.
• Managed the Storage system with ASM, deployed Clusterware, disk grouping and partitioning.
• Participated in enhanced environment and performance of Database Oracle 11G RDBMS.
• Written interfaces scripts to migrate Data between LMS and Oracle Database.
• Configured backup and recovery method using Oracle TSM, RMAN, monitored RAC system using Toad and OEM.
• Continuous monitored table spaces and utilized the best practice, garneted Ad-hoc reporting and views, also maintain knowledge of support documents.  
•  Integrated the LMS system with Human Resources for real time reporting and compliance courses available to newly hired employee. 

Environment: Linux 5, Oracle Database 11G, 10g, Learning Management System SABA 4.5, StarTeam, Remedy, Toad 10.5

 

 

 

IBM Global Services                                                                                       June 2008 – February 2010

Senior Oracle Applications DBA

Responsibilities:

• Designed and implemented BI solution with CRM, EBS, SOA, ETL, OBI and OBIEE for one of IBM’s biggest client Juniper Network.
• Performed specification documentation using MS Excel for each implementation process based on client’s requirements.
• Installed and configured Oracle Enterprise Business Suite Application R11/R12, and implemented in multi-tier IBM AIX 5L environment with multi-nodes on remote server.
• Upgraded Oracle Application R11i to R12 using Rapid Install in multiple nodes created configuration file, and applied RUP6. Also upgraded to 12.1.1.
• Implemented Oracle Centralized backup using RMAN, Tivoli and TSM for more than 70 Database in a group. Also, automated scheduled Full and Incremental backup.
• Wrote PL/SQL Stored Procedures for processing Business Logic in the database to sanity check and pre-load of Data into Staging.
• Participated with Data Warehouse Team in analyzing and creating Dimensions and Fact tables for the Data Warehouse database using DAC tools.
• Working with team to migrate, clone, apply patches, trouble shoot and tuned databases and applications.
• Presented the team with highlighted work layout in MS Power Point and generated reports.
• Responsible for monitoring the workflows that were scheduled, running completed and failed.
• Involved in debugging the Mappings that failed.

Environment:  AIX 4L, Oracle Database 9i,10g,11g, Oracle E-business Suite 11i,12.1i, Siebel, Fusion, Informatica DAC ,OBIEE MS Words, MS Excel, MS Power Point, MS Access 2007.

                                               

Medimpact Corporation (PBM)                                                            October 2006 - June 2008

Senior Oracle Application Analyst

Responsibilities:

·         Worked on highly complex home built Pharmacy Benefit Management software application for  Health Benefit provider.

·         Analyzed and demonstrated high quality Relational and Dimensional Modeling concepts. Designed and reviewed Relational, Normalization and Dimensional Data Warehouse.  

·         Participated in development and enhancement of production application such as MedAccess and MedResult.

·         Created the databases, tablespaces, tables, data objects, constraints, setting privileges, user logins and resetting password.

·         Designed, reviewed, wrote, debug and unit tested the code.

·         Supported development teams throughout application development life cycle.

·         Scheduled batches and sessions for hourly, daily, weekly and monthly jobs.

·         Written UNIX configuration and environment scripts, and unix embedded functions and procedures which integrate databases using PL/SQL.

·         Wrote extensive Procedures, Functions and Packages using PL/SQL. 

·         Tuned the application for faster performances.

·         Supported claims and prior authorization functional part of productions.

·         Applied patches to databases running Oracle 9i/10g running on Solaris 8 in development, and Staging environment.

·         Setup, configured and used Tuning Tool, TKPROF, Explain Plan, Statspack.

·         Created schemas on new servers that involved creating tables and indexes with scripts to create userid, granting privileges, creating roles etc.

·         Supported and maintained databases and environment 24/7 and on call.

·         Setup user profiles and roles as per the access level of user for the data and application security.

·         Assisted and performed adhoc reorganization tasks using EXP/IMP or Table MOVE/Index REBUILD option as and when required.

·         Scripted and automated such procedures for Oracle 9i and 10g environments.

·         Involved with Senior DBA’s in evaluating Oracle 10g RAC prospect for various OLTP applications.

·         Used SQL Loader, Export/Import utilities for data loading.

Environment:  Oracle 8i/9i and 10g, IBM (AIX), SUN (Solaris), Forms 6i/11 PL/SQL, AutoSys, Shell, Perl, Business Objects, PRO*C, TOAD 8, FileNet 8, InformaticaPowerCenter MS Access, MS Excel, MS Power Point.

               

 

Experian Corporation                                                                         November 2005 - October 2006

Oracle Application Technical Consultant

Responsibilities:

·         Supported the Oracle HR, Payroll, Benefits Conversions, Interfaces and Extracts including API’s, Inbound and Outbound Interfaces.

·         Configured Self Service Benefits enrollments processes, setting up the Compensation Workbench plans, Payroll Elements and Balances Data Conversions using Batch Element Entry and Balance Load API’s.

·         Worked with Oracle HR, Payroll and Benefits modules implementations and post production activities.

·         Worked on Oracle Interfaces using Oracle Financial API’s/TCA Architecture.

·          Involved in design, analysis, development, testing and deployment of reports, interfaces, conversion programs and extensions in and around Oracle Applications Financials 11i (GL, AR and AP).

·         Designed and developed numerous packages and procedures utilizing various seeded APIs to load data from temporary tables into Oracle base tables.

·         Created temporary tables and developed SQL*Loader control files to load data from external systems such as NCS into temporary tables.

·         Wrote a PL/SQL package to perform the validations on the imported data and then loaded the data to the Interface tables.

·         Coordinated between business operational user, end user and project manager.

·         Developed Open Interfaces for receivables, invoices and customer import from external system to Oracle Receivables using PL/SQL Procedures, Functions, Packages, SQL*Loader and UNIX Shell Scripts.

·         Developed custom reports using Report 6i and also customized seeded reports.

Environment: Oracle Applications 11i GL, AR, AP, BOM, WIP, OM, ORACLE 8i, SQL, PL/SQL FORMS6i, REPORTS6i, Windows NT and UNIX.

 

Boeing Corporation                                                                               March 2005 - November 2005

Database Warehouse Technical Analyst

Responsibilities:

·         Supported ETL functionality.

·         Worked on project called SDS (Sustainment Data System).

·         Used Supply Chain Management System as a source and management Data Warehouse.

·         Acted as an ETL Technical Analyst. Utilized UNIX Shell Scripts to setup the environment and parameter profile with embedded shell scripts to control the launch of ETL Informatica jobs.

·         Used Autosys Scheduler to initiate the ETL jobs used file watcher functionality.

·         Uploaded the data and used teradata utilities FastLoad and MultiLoad.

·         Designed and implemented Informatica jobs: Jobs, Sequences, Transforms, routines and shared container.

·         Loaded Metadata into Informatica and created environment parameter.

·         Wrote heavy PL/SQL to generate metrics for different fleet.

·         Generated various performance, maintenance and engineering analytical metrics using cursors, functions, packages triggers and procedures.

·         Used Business Object Crystal Report to generate reporting in a formal business ways, so the business requirement would be fulfilled.

·         Documented the application and designed complete data flow diagram from SCM to ODS and then PMWEB.

Environment: Oracle 9i, Teradata, HP-UNIX 11, Informatica 7.5, Humming Bird 9, TOAD 8.5, Autosys 7, WebSphere 5.1, Rational, Windows CVS 1.3 and Business Object 6.                           

                                               

Janus Capital Group                                                                             November 2004 - March 2005

Database Warehouse Analyst/Developer

Responsibilities:

·         Analyzed and developed datawarehouse strategies for data movement between Janus datawarehouse and syndicated data.

·         Used Autosys schedule to automate hundreds of Informatica jobs.

·         Wrote Shell Scripts, Stored Procedures and JIL.

·         Extracted data from source (SOR) and loaded into Central Database (ODS).

·         Created lookup cross reference file for downstream applications.

<span style="font-size:11