SUMMARY

• Fifteen years of diversified IT experience in delivering Business Intelligence solutions by gathering requirements, analysis, Data ware house development, Data modelling, testing, reporting and implementation using Business Analytics Tools like OBIEE 11.1.1.7/10.1.3. x, ODI 11.1.1.7/12 C, OWB, Informatica Power Center 9.x/8.x/7.x for various Business Intelligence (BI) applications.
• Solid understanding of Relation database design and developed various data model - using Designer.
• Experienced in Installation, Configuration, Upgrade, Migration and Administration of Oracle Business Intelligence Enterprise Edition (OBIEE), Informatica & Oracle Data Integrator (ODI).
• Five years of experience in analysis, design, development, and testing of business applications in OLTP, web based Client/Server architectures.
• Five years of hands-on experience using Oracle Data Integrator (ODI).
• Proficient in analyzing the end user requirements and converting them into efficient Technical Solutions.
• Experience in performance tuning at the Database level by creating aggregate tables, Bitmap, B Tree Indexes, RPD level by creating Database hints in physical Layer, Tuning Reports.
• Expertise in implementing Security Models for Dashboards, Row level, Object Level, Role Level, Dashboard Level.
• Extensively worked on Oracle Data Integrator (ODI) Topology manager, Designer, Operator and troubleshooting of the packages.
• Expertise includes analysis, design, and development, testing of data warehousing application using Oracle Data Integrator ODI (Topology Manager, Security Manager, Designer, Knowledge Modules and Operator).
• Experience in Designing Process flows, deploying and populating Staging Area objects, defining and populating the Enterprise Data Warehouse.
• Experience in all stages of project development life cycle including design, development, testing, implementation and product support.
• Five years of experience in Installation, Upgrades, Patches to ODI 10g/11g/12c application.
• Designing, developing, testing, and tuning in ORACLE with PL/SQL.
• Knowledge in developing packages, functions, stored procedures, triggers, tables, table spaces, indexes, customized views utilizing ORACLE PL/SQL database programming language.
• Excellent knowledge and experience in PL/SQL Packages, Stored Procedures, Functions, Cursors, triggers and Dynamic SQL.
• Excellent knowledge and experience in Microsoft Excel and PowerPoint .
• Developed PL/SQL code for efficient retrieval and manipulation of complex data sets using back end PL/SQL packages, procedures, functions, triggers.
• Proficient in all DBA responsibilities such as user management (synonyms/privileges, roles, quotas, table, table partitioning, index, sequence), space management (table spaces, rollback segment), monitoring (alert log, memory, disk I/O, CPU, network activity).
• Experience in Performance Tuning & Optimization of SQL statements.
• Experience in Installation, Upgrades, Patches and Data Migration.
• Outstanding in Production Support, Testing, Documentation and End-Users Training.
• Extensive experience of Performance tuning of various aspects of the database using utilities like TKprof, Explain Plan.
• Performed few tasks of DBA like Installing oracle software, planning the database, creating and opening database, back up the data base and enroll system Users.
• Excel at loading data from FLAT files and other databases, Responsible for Data loading using SQL*Loader for clients
• In addition to excellent technical abilities possesses strong oral and written communications skills, analytical and interpersonal skills.
• Good team spirit and organized working habits with a willingness to learn new concepts.
• Experience in designing Data Model using Erwin

TECHNICAL SKILLS

Languages: SQL, PL/SQL, T-SQL, UNIX Shell Scripting, C,VB,HTML,OOPS and java

Certification: Oracle and CCNA

BI/Reporting Tools: OBIEE 11.1.1.7/10.1.3. x, Discoverer4i/9i/10g, BI Publisher, Oracle Business Intelligence Applications, Table, Tableau.

DWH/ETL Tools: Oracle Data Integrator 11.1.1.7, 12.2.1.0, Informatica Power center 9x/8x/7x,OWB,DAC, Golden Gate

RDBMS: Oracle 10g/9i/8i/7.x, SQL Server 2000, MS Access, COBAL,C#

Operating Systems: UNIX (SUN SOLARIS, HP-UX), Windows

Tools: SQL*Plus, SQL *Loader, SQL Navigator, DTS designer, Oracle Discoverer, TOAD, PL/SQL Developer, SQL Developer, MS Visio, Accurev, JIRA, Beyond Compare2, ODI10g, ODI 11g, OWB 11, OBIEE 11g, OWB, ODI 12c HP Quality Center 11, Concurrent Version System(CVS) 1.12.5

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

Lead ETL Developer

Responsibilities:

• Analyzed the Business requirement for OWB and Mapped the Architecture.
• Created packages with several interconnected mappings and variables to conform to the standard source to target mapping requirements.
• Developed ETL mappings using OWB 11gr2 to load data from sources system into the staging. Developed mappings using OWB for data loading. Created Process flow & monitored session.
• Modified OWB Mappings that populated large confidential tables.
• Developed various Oracle sub functions like Stored Procedures, Functions, and Packages using PL/SQL as per the Design Documents.
• Modified scripts that were built to call custom procedures and report errors
• Modified custom PL/SQL packages to clean out redundant code and replace existing code with more efficient joins and procedure calls.
• Involved in the process of migrating mappings across environments - development to test and eventually to production and building migration documents (transport documents).
• Extensively used Oracle Analytic functions to select specific records based on predefined business rules. With the large data warehouse environment, any updates or back population were performed over the extensive partitioning applied on the tables.
• Optimized and performance tuned existing reports.
• Analyzed, converted, tested, reconciled and implemented reports.
• Implemented complex business requirements in the backend using efficient SQL queries and facilitated easy implementation of front end applications.
• Built efficient, complex, parameterized SQL queries and stored procedures to produce output data sets.
• Implemented best Confidential to reduce maintenance overhead and complexity.
• Created mapping specification documents to define and document source and target attributes
• Implemented user level security by creating a table that stored usernames, user groups and their specific permissions.
• Migrated all the mappings from OWB to ODI 12c.
• Implemented the golden gate for replicating the transaction schema.
• AWS is in progress to move all the mappings to cloud environment.

Environment: ODI 12c, Golden Gate, AWS, Oracle Warehouse Builder 11gR2, Toad 8.5.1.6, Oracle 11g, SVN, SQL plus, PL/SQL, OBIEE (11.1.1.3), Oracle Enterprise Manager/Grid (10g, 12c), SQL Developer (3.2.x, 4.0).

Confidential, DC

Lead ETL Developer

Responsibilities:

• Design data marts (star schema) for new data warehouse applications.
• Modifications and Upgrades to existing star schemas to suit the current reporting requirements
• Design ETL mappings using Oracle Warehouse builder tool to extract, transform and load the star schema.
• Design and create database objects for data marts.
• Create process flows to load the data in conditional manner and schedule the process flows to automate the loading process. Customized OBIEE UI as per the courts requirements by replacing oracle logo with the Confidential logo and providing help links in order to contact BI support team.
• Automate the KPI process to extract the KPI data from excel sheets and load data to KPI data mart.
• Prepare Data for Daily Case load report for Family Division
• Voucher Tracking Data Mart.
• Web Mediation Data Mart
• Web Voucher Data Mart.
• Juvenile Probation case management system.
• Migrate from OWB to ODI.
• Performed Performance Tuning to make the process intraday run.
• Court of Appeals case management system (SQL Server)

Tools: Cherwell, BeyondCompare2, Notepad++.