Professional profile

I am an Oracle certified professional with extensive experience in designing and developing oracle database application and administering Oracle database systems. I have worked in the financial industry dealing with large datasets originating from Bloomberg, Reuters and Tick data. I have a strong technical competence in software development, problem identification, database administration, modeling, design, development, interacting with business users, design and development of reports.

Education / Certifications

• Bachelor Of Engineering.
• Oracle 9i Database Administrator Certified Professional (OCP)
• Oracle Certified PL/SQL Programmer

Skills

Operating system: Proficient in using Windows, Sun Solaris and Linux (Redhat) platforms
Databases: Administration, design and development experience with Oracle 9i, Oracle 10g, Oracle 11g, Postgres
Development Tools: Toad, SQL Navigator, Oracle SQL developer
Oracle Languages: SQL, PL/SQL
Script Language: Korn Shell, Bash Shell, Perl, Python
Tools: SQL Loader, Import, Export, SQL*PLUS, TKPROF, Oracle Enterprise Manager, RMAN, Microsoft Visual Source Safe, Microsoft Visio, Data Junction, CVS, Informatica Power Center
Reporting Tools: Oracle Reports 9i Developer, Crystal Reports 2008, Business Objects XI R2

Professional Experience

Software Engineer - Confidential, New York, NY
Nov 2007 - Mar 2010

Environment: Redhat Linux, Postgres, Oracle 10g RAC, Oracle PL/SQL, Toad, CVS, Bash shell, Perl, Business Objects XI R2, Crystal Reports 2008, Informatica Power Center 8

I worked as a Software Engineer for Business Intelligence and Data Warehouse group. Primary responsibilities included ETL processing - moving data from Postgres database to Oracle data warehouse, loading market data, generating reports using webI on Business objects and Crystal reports.

• Designed & implemented of star-schema based data warehouse
• Responsible for ETL processing - loading trading systems data from Postgres database to Oracle database. Also responsible for loading equity reference data from Bloomberg, Reuters, Tick data
• Wrote PL/SQL procedures, views to implement data dictionary for Reference data
• Designed dimensional data models using Ralph Kimball methodology
• Designed and improved performance of data warehouse by implementing Oracle Data warehousing features like Materialized views, table partitioning, Type 2 slowly changing dimensions and Star schema
• Resolved data issues associated Reuters, Bloomberg, Tick data feeds for Equity Pricing
• Performed gap analysis between trading systems OLTP database and Oracle data warehouse
• Monitored Bloomberg corporate actions - ticker changes, splits and dividends affecting trade.
• Wrote Perl/shell scripts to automate ETL processing
• Designed Informatica Mappings using Source, Target, Expression, Joiner, Filter, Lookup, Transformations, Informatica Workflows using sessions, events, command tasks and workflows
• Worked with the research team to gather requirements for market data analysis. Based on the requirements, I was responsible for designing and developing PL/SQL packages, procedures, functions, views
• Extensively used Oracle SQL analytical functions for implementing views, summarized tables based on users requirements
• Responsible for performance tuning using Explain Plan, Toad
• Created views/procedures to calculate 20D/90D/30D average daily volumes based on the Bloomberg North America data
• Generated Daily/Weekly/ Monthly, analytical reports - Market Share, Trending, Rank using Web Intelligence
• Published and scheduled reports using Info View

Application DBA - Confidential, New York, NY
Apr 2007 - Nov 2007

Environment: Redhat Linux, Oracle 10g RAC, Oracle PL/SQL, Toad, Windows XP

I served as an Oracle Application DBA for the database group. Primary responsibilities included PL/SQL development, shell programming, SQL tuning, backup and recovery, refreshing development database.

• Performed user & security administration activities, such as creating users, roles, granting privileges/roles to users, schema management (DML/DDL)
• Optimize database performance by analyzing objects, generating statistics and creating indexes
• Designed and implemented materialized views, PL/SQL packages, procedures, functions for the stated business requirements
• Created refreshable reports (spreadsheets) for business users
• Provided technical assistance in tuning SQL queries developed by Java developers
• Refreshed development database with production data on a weekly basis
• Installed Oracle client on the user machines

Database Developer / Analyst - Confidential, Armonk, NY
Nov 2005 - Nov 2006

Environment: MS Windows 2000 Server, HP-Unix, Oracle9i, Oracle PL/SQL, Toad, Data Junction, Business Objects

I served as a database developer/analyst for the Business Administration Group. Primary responsibilities included PL/SQL development, shell programming and gathering business requirements.

• Coordinated with the business group to identify, derive and define data mappings, identify and resolve data conflicts
• Validating data, documenting the analysis and results using pre-defined template
• Analyzing and transforming data received electronically from various insurance clients to Swiss Re data formats using Data Junction tool
• Designed and implemented views, materialized views, PL/SQL packages, procedures, functions as per the business requirements
• Tuned and optimized queries
• Designed and developed Universes for reporting purpose
• Generated reports using Web Intelligence based on the business requirements

Database Developer - STS
Client: Confidential, White Plains, NY
May 2005 - Oct 2005

Environment: MS Windows 2000 Server, Sun Solaris, Oracle9i, Oracle 10g, PL/SQL, Toad

I served as a contractor in Database Development/Administration group. Primary focus included writing stored procedures, functions, packages, triggers and day-to-day database administration activities.

• Exporting and importing data using Oracle Export / Import utilities
• Monitored table spaces, indexes, alert log
• Maintained data and database structure among development/test/production databases
• Migrated and upgraded databases from version 9i to 10g
• Implemented user-managed and RMAN backups. Created and maintained the catalog database for the RMAN backup operations.
• Performed database tuning using Oracle Enterprise Manager and STATSPACK
• Used ANALYZE, DBMS_STATS, EXPLAIN PLAN, SQL TRACE and TKPROF to tune SQL queries
• Wrote PL/SQL packages, procedures, triggers, views, materialized views according to the stated business and technical requirements
• Performed database account administration

PL/SQL Developer, Confidential, Briarcliff Manor, NY
Oct 2004 - May 2005

Environment: MS Windows 2000 Server, Oracle9i, PL/SQL, Toad

I served as a Database Developer for students, HR, Finance databases. Primary focus included writing stored procedures, functions, and packages according to stated business and technical requirements.

• Wrote stored procedures, functions, packages for the stated business requirements
• Loading data using SQL*Loader
• Assisted users to write SQL Queries
• Creating views for ADHOC requirements
• SQL Tuning using explain plan, TKPROF

Environment: MS Windows 2000 Server, Oracle9i, PL/SQL, SQL Navigator

I served as a Database Developer for an integrated logistics database. Primary focus included generating reports using Oracle Reports 9i, scheduling reports, writing stored procedures, functions, packages.

• Wrote stored procedures, functions, packages for the stated business and technical requirements
• Loaded data using SQL*Loader
• Developed/Refined reports for the shipment data
• Creating views/Materialized Views

Database Developer - Mind tree Consulting,
Bangalore, India
Client: Confidential
Nov 2003 - Apr2004

Environment: Windows 2000 Server, Oracle9i, PL/SQL, Toad, Unix - Solaris

I served as a Database Developer and junior DBA in the feasibility analysis and development for leveraging current architecture to utilize Enterprise warehouse as a single source for data in Oracle. Primary focus included data modeling, PL/SQL programming and database maintenance.

• Designed relational database model as per the business requirements
• Designed and developed stored procedures, functions, packages for the stated business and technical requirements
• Loaded data using SQL*Loader
• Tuned oracle SQL queries