SUMMARY:

• Over 18 years of experience in Application design, development and data architecture on a wide variety of platforms, operating systems and databases mainly in Banking and Finance domain.
• Extensive experience managing and supporting multiple projects involving design and development of OLTP & Data warehouse databases in Oracle 12c/11.2/10g, Teradata, Netezza, NoSQL databases - Cassandra, SQL Server across multiple industries such as Banking, Insurance, Financial, Taxation.
• More than 8 years of experience as Data architect involved in design and implementation of database solutions, data integration techniques, D ata modeling, Master Data management & data governance, data quality/data profiling techniques
• Extensive experience in Oracle Sql & PLSQL code development, writing and reviewing procedures, functions, packages, managing indexes and partitions, reviewing execution plans for query tuning and optimization, OEM database monitoring, OBIEE repositories and dashboards
• Experience handling high volume data load using SQL*Loader, external tables, exchange partition, Oracle Data Pump, Implemented data compression in Oracle Exadata to reduce storage and improve performance for certain queries in Oracle Exadata
• Providing technical guidance to project teams in all phases of SLDC, creating test cases and providing support during testing and implementation, UI integration and production releases
• Experience in handling ETL tools like Informatica, Datastage, Unix shells scripting
• Familiar with Hadoop information architecture, NoSql Database - Caasandra
• As Technical lead supervising progress of development and testing activities using Agile methodology, daily status call, tracking project deliverables
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS:

RDBMS: ORACLE 12.2/11.2/10 g/9i, Teradata, Netezza, SQL Server, Access, Hadoop ecosystem Hive, MapReduce, NoSQL DB- Cassandra

Tools: SQL, PLSQL, Oracle Enterprise Manager, OBIEE 11g, SQL* Loader, DataPump, Export and Import Utilities, Erwin, TOAD, Rational Clearcase, ClearQuest, Business Object, Cognos

Scripting Languages: Python, SQL, PL/SQL, SQL*Plus, Unix Shell Scripting

ETL Tools: Informatica-Power Center 9.6, Datastage

Version Control Tools: Cleacase, clearquest, SVN, Jira

PROFESSIONAL EXPERIENCE:

Confidential, NY

Sr. Oracle Developer /Data Architect

• Involved in design and implementation of data warehouse environment including database architecture, metadata, and repository creation, technical specifications, Logical and physical data modeling, dimensional modeling, star schema, fact and dimensions
• Design and development of reporting database, source system analysis and mapping entities from source to target, loading data from various source system onto an ETL layer and then cleansed, scrubbed for anomalies, business transformation logic applied and transformed data is then loaded onto staging layer in the Database.
• Responsible for designing database structures, Oracle 11.2 SQL and PLSQL code development writing and restructuring packages, procedures & functions, using collections, analytical functions, implementing data masking to establish business rules
• Reviewing and restructuring sql queries & PLSQL code, join strategies, indexes & table partitions, reviewing explain plan, hints, query execution plans, AWR reports, parallel loading techniques using staging tables, implementing data compression on large tables
• Interacting with architect and support team for design and development of solutions using technologies like Hadoop, MapReduce, Cassandra etc.
• Troubleshoot database issues in UAT and production environments

Environment: Oracle 12/11.2, NoSQL DB-Cassandra, MapReduce, Toad, SQL Navigator, Erwin, MS Visual Studio, Relational ClearQuest, Clearcase, MS-Visio, Unix shell scripting, Data Pump, Autosys

Confidential, Hoboken, NJ

Sr. Oracle Developer

• Involved in various phases of development lifecycle, requirements gathering, understanding business processes, source system analysis, creating logical and physical Data models, defining data quality and data profiling techniques, creating Source file layout mapping specifications & metadata repository
• As a Database Technical Lead, responsible for designing database structures, Oracle 11.2 SQL and PLSQL code development, writing packages, procedures/functions and triggers, analytical functions, managing join strategies, performance indexes & table partitions, data masking using data redaction
• Responsible for Sql query optimization & PLSQL code tuning using Explain Plan, gathering statistics, monitoring database performance using OEM, AWR reports
• Experience in defining high volume data load using exchange partition technique, loading data from various source file formats (csv, xml, txt, excel, unstructured data) using external tables, Sql*Loader, Utl file, utilities like export import and Data Pump, scheduling jobs,
• Creating OBIEE RPDs for the data structures, designing dashboards and reporting queries, configuring reporting schedules for business users
• Providing support for ETL processes, test plans and integration testing, production support (24/7) for resolving critical data issues managing, mentoring development team
• Monitoring progress of development and testing activities using Agile methodology, daily status call, tracking project deliverables

Environment: Oracle 12.2/11.2, Informatica 9.6,, Toad, SQL Navigator, OBIEE 11g, Erwin, MS Visual Studio, MS-Visio, Unix shell scripting, Data Pump, Autosys

Confidential, Warren, NJ

Oracle Developer-DBA

• Involved in gathering business requirements, liaising with Finance, Risk, Technology and FRO teams across the organizations, developing the end-to-end data warehouse solution architecture and documenting the technical specifications, build and manage Logical and Physical Data Model, designing extraction and loading techniques from various source systems like Oracle, Netezza, Teradata, Sybase
• Defined and documented source to target mappings, attributes, data types, cardinality, data quality standards for banking products namely -Deposits, Mortgages, Securities, Loans, Derivatives for both wholesale and Retail.
• Responsible for Oracle 10g/11g Sql & PLSQL code development, procedures, functions, packages, procedures, cursors, collections methods, bulk binding technique, managing indexes and table partitions, managing indexes and partitions
• Involved in SQL query optimization & PLSQL code tuning using Explain Plan, gathering statistics, SQL Analyzer and tuning packs for performance monitoring.
• Experience using Oracle Data Pump, SQL *Loader, Unix shell scripting, Autosys, Creating and managing reports using Business Objects, MS-Excel, familiar with Oracle Exadata architecture
• Technical lead, supervising progress of development and testing activities using Agile methodology, tracking project deliverables, monitoring milestones in daily status call
• Developing quality assurance / User Acceptance test plans, providing support to testing teams in System test & user acceptance testing phases, Implementation & production phase, post production roll out phase

Environment: Oracle 11g, Teradata 13.10, Erwin, Relational ClearQuest, Clearcase, MS-Visio, unix shell scripting, Autosys, File management-SVN &Perforce

Confidential

Data Architect

• As Data Architect, actively involved in gathering requirements, data analysis,logical and physical data modeling
• Involved in preparing functional and technical design documents, source to target mapping, ETL mapping specification, data cleansing and profiling data, developing reusable components & services, Source data extraction from Sybase, Sql Server and Teradata, Netezza
• As a Development lead - creating Oracle stored procedures, functions, packages, triggers, reviewing indexes and join strategies, managing table partitions, data masking for formatting and handling sensitive financial data, reviewing execution plans for sql query tuning and optimization
• Map data between source systems, data warehouses, and data marts, creating new reports using Business objects, maintain existing reports including selection criteria and documentation
• Developing test plans, providing support to testing teams in System test & user acceptance testing phases, implementation & production phase, post production roll out phase
• Providing technical guidance to project teams throughout the software development life-cycle.

Environment: oracle 11.2/ 10.2, Teradata 13/13.10, Fastload, Multiload,, Erwin, Relational ClearQuest, Clearcase, MS-Visio, DataStage, Informatica Power Center 9.1, Erwin, Reporting tool Business Object, unix shell scripting, Tivoli Scheduler

Confidential, NYC

Oracle Development-DBA

• Involved in various phases of development lifecycle, from gathering requirements, designing and creating logical/physical data models based on business requirements, technical design specifications
• Designed, developed and successfully implemented in-house PL/SQL coded ETL (Extraction, Transformation & Loading) process for the highly complex reporting system.
• Data-migration lead DBA/analyst responsible for getting government agencies on-board “City time” including the likes of NYPD, FDNY and other agencies
• As Database Lead Developer - responsible for Oracle 10g Sql & PLSQL code development, writing and reviewing procedures, functions, packages, procedures, using cursors, collections & bulk binding technique, managing indexes and table partitions,reviewing execution plans for query tuning and optimization
• Managing indexes, materialized views, table and index partitions (local indexes), ETL processes, designing Business Objects universes and complex reports
• Involved in SQL query optimization & PLSQL code tuning using Explain Plan, using oracle utilities like Data Pump, SQL*Loader for loading data
• Maintaining database schema objects, version control, configuration & release management, tracking all changes to database objects using ClearQuest, Clearcase

Environment: Oracle 10.2/11.2, SQL, PL/SQL, TOAD, Teradata 12.0, DataPump, Import/Export Scripts, Erwin, Relational ClearQuest, ClearCase, Informatica (7.1 & 8.5.1), Business Objects, unix shell scripting.

Confidential, Stamfor, Connecticut

Oracle Developer - Legal and Compliance

• Involved in designing and developing Oracle 10g database schema objects Oracle PL/SQL packages, functions, and procedures, triggers
• Extensively used advanced PLSQL techniques, collection methods, bulk binding techniques, Ref Cursors, dynamic SQL in PL/SQL, managing joins, indexes, table partitions, materialized views and logs
• Managed database security through user administration and granting correct roles and privileges, using data masking techniques
• Experience working with large volumes of data, using exchange partition, loading export import, Sql*Loader utilities
• Providing support in testing, deployment and implementation phase.
• In-depth experience with Unix operating systems, shell scripts

Environment: Oracle 9i/10.2, SQL, PL/SQL, TOAD, data Guard, DataPump, SQL-Backtrack, SQL*Loader/Import /Export Scripts, Erwin, Informatica (6.1)

Confidential

Programmer (Oracle Developer)

• Developing and creating schema objects, coding procedures, functions, triggers, packages, cursors, dynamic Sql, bulk binding techniques using oracle 9i.
• Managing Indexes, materialized views and table partitions, user privileges and access.
• Managing Test Databases for testing and data analysis.

Environment: Sun Solaris 7, Oracle 9i/8i, Oracle Enterprise Manager Diagnostics Pack and Tuning pack, RMAN, SQL, PL/SQL, shell scripting, SQL*Loader/Import/Export Scripts, Erwin, Toad

Confidential

Programmer

• Involved in analysis, design and development of the system
• Created database objects tables, indexes, views, synonyms, stored procedures, functions, triggers, implementing and maintaining integrity constraints, indexes on database tables, created Forms and reports using Visual Basic.
• Performed testing and debugging, preparing documentation and providing user training

Environment: Oracle 7.3, SQL, PL/SQL, Visual Basic 5.0, Crystal Reports