SUMMARY

• Over six years of extensive IT experience including experience in analysis, design, development and implementation of database centric corporate intelligence solutions including Data warehousing, Data Migration and all phases of Data warehouse Development Life Cycle
• Specific business domain knowledge includes technology, insurance, and healthcare
• Expertise in Oracle Stored subprograms, Packaged subprograms, Cursors, Cursor Variables, Collections, Triggers, Native Dynamic SQL
• Developed and maintained UNIX Shell Scripts (Korn Shell, Bourne Shell) for automating Batch Transfers, User Group Maintenance, Security and Custom Report Generation
• Proficient in Oracle Tools and Utilities such as SQL*Loader, Import/Export and TKPROF
• Proven abilities in creating complex reports by linking data from multiple data providers and using free hand SQL
• Designed and Developed Data Warehouse/Data Mart systems, using various RDBMS (Oracle, MS - SQL Server), PL/SQL, MS Access, and ETL tools (Informatica PowerCenter)
• Hands on experience in preparing Business, Functional and User Requirement documents, Technical Design and Solution Definition documents, UAT and other related documents
• Good experience in using data modeling tools such as MS Visio, ERwin for designing database models and system specifications using UML
• Involved in Physical and Logical database design, and performance tuning for development, testing and production environments
• Effective Communicator with good Analytical and Inter-Personnel skills
• Excellent Team player and can work with minimum supervision

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2000/2005

DB Tools: SQL*Plus, SQL*Loader, SQL Developer, TKPROF, TOAD 7.0/7.6/9.1

Development Languages: SQL, PL/SQL, T-SQL, UNIX Shell Scripting, Java

ETL Tools: Informatica PowerCenter 8.6/8.1/7.1/6.2 , Pentaho 4.3

BI Tools: OBIEE (Oracle Business Intelligence) 10.1.3.4.1

Operating Systems: WINDOWS 3.x/95/98/2000/XP/7, Win NT 4.0, Linux-Centos, RHEL

Data Modeling Tools: MS Visio, Erwin

Web Programming: HTML

Scripting Languages: Python and Shell Script

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

PL/SQL/Oracle Developer

Responsibilities:

• Maintain and modify existing Pentaho jobs and Python scripts to pull Omniture data and load into the EDW.
• Create Informatica transformations to fetch contract sales data from data sources (flat files, oracle) into the oracle applications warehouse.
• Create Pentaho jobs to pull listing information from MLS’s and load them into the listing database.
• Create Pentaho transformations to de-dupe listing information from MLS’s.
• Involved in troubleshooting and maintenance of production environment
• Analyze and compare Omniture data with internal clickstream data.
• Write PL/SQL Stored Procedures, Functions, and Packages according to the ETL requirement.

Environment: Pentaho Data Integration, Informatica 8.6, Oracle 10g, Windows XP, Toad 9.1, SQL *Plus 9.2

Confidential, Santa Cruz, CA

Oracle PL/SQL Developer

Responsibilities:

• Gathered project requirement information from users and thoroughly analyzed the requirement
• Involved in all phases of SDLC(Software development life cycle) from design to support
• As part of ETL process, loaded data from Oracle tables into target Oracle based Enterprise Data Warehouse
• Created Tables, SQL scripts, indexes, Views, Sequences as per the database design
• Created Packages, Stored Procedures, Functions as per the ETL framework design
• SQL statement Tuning using Explain Plans and SQL Trace using TKPROF utility and AUTOTRACE utility
• Responsible for monitoring and troubleshooting daily processes in Production environment
• Prepared Unit Test plans for data validation
• Fine tuned database, queries, transformations and mappings for better performance
• Responsible for unit testing and validating the data loaded in to Target tables by using excel, SQL queries in TOAD, SQL *Plus and by generating reports using Business Objects
• Designed new database tables and modified existing ones to meet business information needs. Created and modified indexes, synonyms as necessary
• Designed and Maintained Data warehouse Oracle ETL Processes, PL/SQL scripts, DB Procedures, DB functions

Environment: Oracle 9i/10g, PL/SQL, SQL, SQL *Plus 9.2, Toad 9.1, Informatica 8.6/8.1, Business Objects 6.5, OBIEE (Oracle Business Intelligence 10.1.3.4.1 ), Windows XP, Sun Solaris

Confidential, Los Angeles CA

Oracle PL/SQL Developer

Responsibilities:

• Participated in the initial building of the various Data Marts
• Created Tables, indexes, Views, Sequences as per the database design
• Involved in analyzing the systems
• Extensively used PL/SQL, Built in Oracle Packages, stored procedures, functions, triggers, cursors and views for processing data, enforcing referential integrity and needed business rules
• Worked with Ref Cursors, Collections and External tables
• Performed SQL tuning for reducing the processing time of the queries.
• Fine tuned a number of queries using explain plan for reducing performance bottlenecks
• Expertise with Exception handling and Collections
• Good knowledge on PL/SQL Tables, Oracle supplied packages, Records and Dynamic SQL
• Used Bulk collect and Materialized views for improving performance
• Involved in Data profiling
• Involved in Unit Testing and prepared Test Cases.

Environment: Oracle 9i, SQL Navigator, SQL *PLUS, SQL *LOADER, PL/SQL, Informatica 7.1, Windows 2000, UNIX (Solaris)

Confidential, San Jose, CA

Oracle/ETL Developer

Responsibilities:

• Was involved in preparing ETL design documents and designing and documenting the ETL process.
• Worked extensively on transformations such as Lookup, Aggregator, Expression, Joiner, Filter, Router, Stored Procedure, Rank, Update Strategy, Source Qualifier and Sequence Generator and performed performance tuning of ETL process.
• Used Workflow Manager for creating, validating, testing and running sequential and concurrent batches and tasks including sessions, decision tasks, assignment tasks, command tasks, event wait tasks, event raise tasks, timer and scheduling them to run at specified time.
• Wrote Pre and post session Shell scripts for extracting data from files, remove duplicates and sorting in the database to optimize performance.
• Designed database tables, functions and procedures for loading of data.
• Written a number of complex queries for extraction of data.
• Improvised query performance by using explain plan.
• Improved performance by creating materialized views.
• Interacted with Product Manager, and Business Analysts to understand and document the requirements and translate the requirements to technical specifications for Universes in Business Objects.
• Involved in technical documentation, Unit Testing, Integration testing and in writing test plans.

Environment: Informatica 7.1, Oracle 9i, Shell Scripts (Korn), PL/SQL, TOAD 7.0, ERwin 4.1, UNIX (Solaris).