EXECUTIVE SUMMARY

• 24+ years of experience in the IT industry including Data Warehouse/Data Mart, Operational Data Store (ODS), E - Commerce and OLTP systems in the role of Architect, Data Quality Architect, Modeler/ Confidential, Analyst, Confidential, Database Administrator, Project Lead and Developer
• Experienced in Conceptual/Logical/Physical Relational/Dimensional Database Modeling & Designing and Application Architecture
• Experienced in extensive hands-on Oracle Performance Tuning including very large database (VLDB) - 250+ TB uncompressed size (25+ TB compressed size)
• Experienced in Oracle Application Database Administration
• Functional expertise - Regulatory Reporting OATS/TSP, Financial Compliance, Asset/Wealth Management, Investment Banking, Reference Data Hub (Master Data Management), Traffic Violation Processing, Pension & Health Benefits Administration, Banking, Energy, Business Insurance, Financial & Managerial Accounting
• Quick learner to new technology, team player, strong work ethic, excellent problem solving, analytical, communication and interpersonal skills

TECHNICAL SKILLS

RDBMS: Oracle Exadata 11g RAC, Oracle 11g RAC/10g RAC/9i RAC/8i/8.x/7.x, SQL Server

Languages: SQL, PL/SQL, Scripts (ksh, awk, perl), Python, HTML, JavaScript, Mod PL/SQL, Java, XML

Web/Application Servers: Oracle Application Server/Weblogic, IBM Websphere

Operating Systems: UNIX (IBM, Solaris, HP, SCO), Linux, Windows Servers & Clients, DOS

Data Modeling: Erwin, Embarcadero ER/Studio, Toad Data Modeler, SQL Developer Data Modeler

Data Integration: Oracle Warehouse Builder (OWB 9i)/Oracle Data Integrator, Informatica

ETL Related: Oracle Streams, SQL, PL/SQL, SQL*Loader, Export/Import, Oracle Data Pump, FTP/FTPS/SCP

Data Quality: Informatica DQ 9.6.1/10.1

BI Reporting: SQL*Plus, Oracle Reports, Business Objects

Job Scheduler: Control-M, CA-Unicenter, Autosys, Unix cron, Oracle Job scheduler

DB Tools: OEM, SQL*Plus, TOAD, SQL Developer, SQL Navigator, DBArtisan, PL/SQL Developer

Networking: Oracle Networking, TCP/IP, Windows Networking

Front End: Forms & Reports - Oracle 9iDS, Developer 6i, Developer/2000, CDE 2.0/1.0

VCS: SQL-Station, MKS Integrity, CVS, PVCS, Tortoise SVN, SourceTree/GIT, Perforce, MS TFS

Productivity: MS Office, MS Visio, MS-Project, HP Quality Center, SharePoint

PROFESSIONAL EXPERIENCE

Senior Database Architect, Modeler

Confidential, New York

Responsibilities:

• My responsibility includes supporting and enhancing existing FINRA regulatory reporting OATS and TSP Market Making for Virtu Financial that includes Darkpool, Algos, High Touch etc. I have created a new automated process for OATS rejected records pull and TSP unlink records from FINRA for manual repair and then automated FORE generation and submission to FINRA. Email notifications have been created for various statistical and alerting items that include inbound and outbound source data, OATS jobs completion and failure etc. Performance tuning has been done extensively to cut short time for Darkpool and Algos source data load and OATS processing. Archival process has been enhanced to tune the performance.
• All the jobs are scheduled using cron. It calls shell scripts which internally invokes SQL*Loader for data load and Oracle code for business rules. Performance tuning has been extensively done by parsing source data using Python scripts, parallelism in scripts, Oracle partitioning, compression, indexing, materialized views, proper SQL join mechanisms, parallelism etc.

Environment: Oracle 11gR2, SQL, PL/SQL, SQL*Loader, Toad, GIT, Linux, Windows 7, cron, ksh/awk/Python scripts

Senior Database Architect, Modeler

Confidential, New York

Responsibilities:

• Confidential is the Order and Execution Management System that captures Equities real-time transactional data from the message queue in FIX 5.0 format and persists it in Normalized format in ODS/Staging schema and finally loads into Data Warehouse / Data Mart schema for Regulatory reporting such as OATS to FINRA, MiFID II etc. Data Quality for various business rules are enforced using Informatica DQ tool against the ODS/Staging schema. Portal is created for Scorecard and Trending graphs and drilling down into the business rules details by calling database API. Performance is extreme importance since there is close to a billion messages to process for a business day across all the three regions - AMRS, EMEA and APAC and the database size is 250+ TB uncompressed (25+ TB compressed). Oracle Exadata Half Rack 11gR2 is the data layer with 4 RAC compute nodes and 7 storage cells to achieve this extreme performance using various techniques and Exadata features like Hybrid Columnar Compression, Partitioning, Smart Scan, Bloom Filters, Storage Indexes, Cell Smart flash cache etc., just to name few. Control-M is the job scheduler that calls ksh/perl scripts which in turn calls Java/Oracle/Informatica. Java process consumes the messages from the queue and persists in ODS/Staging schema. SQL and PL/SQL code is used for the entire ETL process from ODS/Staging schema to Data Warehouse / Data Mart schema.
• Confidential is an automated solution for Citi to upload and review the reports for FINRA compliance, across various desks under APAC/EMEA/NAM regions’ Equities and Fixed Income businesses. Front end user interface (Java/Adobe Flex) interacts with Oracle database and most of the business logic is written using SQL and PL/SQL. All the jobs are created using Autosys with Unix scripts such as snapshot capture, Audit Reports Monthly/Weekly, Monthly Escalation Reports and Notifications to Overseeing Supervisors and Business Unit Managers. My responsibility includes review the existing system, eliminate all the existing issues (data and code), enhance the data model in both logical and physical model, SQL and PL/SQL development, extensive performance tuning, document the system, production deployment and business user support. I have designed and developed additional functionalities such as user entitlements, global holiday processing, review catalog versioning using SCD Type 2, globalization of the process across various time zones, revamp of email notifications, data abstraction layer for Business Objects etc. In a lead and architect role, I am managing a team of around 10 people both off-shore and on-site.
• Confidential is a wealth management company for institutional and private clients and manages sub-advised assets. It uses third party tools like LVTS, Charles River to trade Equity, Fixed Income Securities. Compliance Online Monitoring and Exception Tracking (COMET) is an in-house developed Oracle based compliance tool which is used to enforce Pre-Trade, Intra Day and Post-Trade/Batch guidelines.
• My responsibility is to create an automated regression test tool for COMET, enhance/bug fix the application, improve the database performance of the application, Data Mart and ETL process design and development for Fixed Income Performance Attribution from Jennison Data store (ODS) etc.

Environment: Oracle 11gR2 RAC, SQL, PL/SQL, SQL*Plus, Toad/SQL Developer, Toad Data Modeler, Microsoft TFS, Sun Solaris, Windows 7, Autosys

Senior Database Architect, Modeler

Confidential

Responsibilities:

• Interact with various project managers and business analysts to gather the system requirement
• Involve in the complete software development life cycle (SDLC) at all levels at Architect level including - analysis, create technical design documents, modeling/designing at Conceptual/logical/physical level using Embarcadero ER/Studio data modeling tool, developing and implementing the solution using Oracle, Linux and Autosys, Unit and Integration testing, creating production deployment scripts, release notes, checking all the objects into Perforce for deployment
• Co-ordinate with off-shore resources for software development
• Co-ordinate to setup and configure the infrastructure with Hardware (Server, Storage, Memory) and Software (Linux, Oracle) teams for High Availability, Active Data Guard, Backup & Recovery, Performance Tuning etc.
• Storage Capacity Planning
• Involve in the high level development using SQL & PL/SQL, Unix scripting using korn shell & awk
• Perform extensive and hands on SQL & PL/SQL performance tuning using CBO - Data Compression, Materialized Views, Historical tables that are aggregated and joined, Table & Index partitioning (Pruning), B*Tree, Bitmap, Function based indexes, Extensive Optimizer hints usage in Query and DML, Analyze DML and Query plans using Explain Plan, trace, TKPROF, TOAD tools, Incremental Stats collection using DBMS STATS, Parallel Query, DML & DDL, Distributed Query tuning, Oracle initialization parameters tuning, Design Data Abstraction Layer etc.

Environment: Oracle 11gR2 RAC, SQL, PL/SQL, SQL*Plus, Toad, Embarcadero ER/Studio, Perforce, Linux, Windows XP, HP Quality Center, Share Point, Autosys, RainStor

Senior Database Architect

Confidential, New York

Responsibilities:

• Interact with various project managers and business analysts to gather the system requirement
• Involve in the complete software development life cycle (SDLC) at all levels including - analysis, create technical design documents, modeling/designing at Conceptual/logical/physical level using ERwin data modeling tool, developing and implementing the solution using Oracle, Unix and Control-M, Unit and Integration testing, creating production deployment scripts, release notes, checking all the objects into SVN for deployment
• Involve in the high level development using SQL & PL/SQL, Unix scripting using korn shell & awk, Job scheduling using Control-M
• Perform extensive and hands on SQL & PL/SQL performance tuning using CBO - Table & Index partitioning (Pruning), B*Tree, Bitmap, Function based indexes, Extensive Optimizer hints usage in Query and DML, Analyze DML and Query plans using Explain Plan, trace, TKPROF, PL/SQL Developer and TOAD tools, Table & Index analysis using DBMS STATS to gather statistics, Parallel Query, DML & DDL, Distributed Query tuning, Oracle initialization parameters tuning

Environment: Oracle 10g RAC, SQL, PL/SQL, SQL*Plus, SQL*Loader, PL/SQL Developer, ERwin, SVN, Linux/Unix, Windows 7, HP Quality Center, Share Point, Control-M

Senior Database Architect

Confidential

Responsibilities:

• Interact with various project managers or leads to gather the system requirement
• Involve in the complete software development life cycle (SDLC) at all levels including - analysis, create technical design documents, modeling/designing at logical/physical level using ERwin data modeling tool, developing and implementing the solution using Oracle and Unix, Unit and Integration testing, creating production deployment scripts, writing user manual and run books, checking all the objects into SVN for deployment
• Involve in the high level development using SQL & PL/SQL (Used many new features including Analytical functions, Ref cursors, Collections, Partitioned, Global Temporary, External Tables etc.) and extensive Unix scripting using korn shell and awk.
• Perform extensive and hands on SQL and PL/SQL performance tuning using CBO - Table & Index partitioning (Pruning), B*Tree, Bitmap, Function based indexes, Extensive Optimizer hints usage in Query and DML, Analyze DML and Query plans using Explain Plan, trace, TKPROF and TOAD tools, Table & Index analysis using DBMS STATS to gather statistics, Parallel Query, DML & DDL, Distributed Query tuning, Oracle initialization parameters tuning

Environment: Oracle 10g RAC, SQL, PL/SQL, SQL*Plus, TOAD, ERwin, SVN, Linux/Unix, Windows XP

Senior Data Warehouse Architect

Confidential

Responsibilities:

• Interacted with various project managers and directors to gather the system requirement
• Involved in the complete software development life cycle (SDLC) at all levels including - analysis, create system design specification (SDS), modeling/designing at logical/physical level using ERwin data modeling tool, implement the solution using Oracle and Unix, create test plans & scripts for unit, system and regression tests, create UAT & production deployment scripts, write user manual
• Involved in the high level development using SQL, PL/SQL & Java Stored Procedures (Used many new features including Analytical functions, Ref cursors, Collections, Partitioned and External Tables etc.) and extensive Unix scripting using korn shell and awk.
• Performed extensive and hands on SQL and PL/SQL performance tuning using CBO - Table & Index partitioning (Pruning), B*Tree, Bitmap, Function based & Domain indexes, Extensive Optimizer hints usage in Query and DML, Analyze DML and Query plans using Explain Plan, trace, TKPROF and TOAD tools, Table & Index analysis using DBMS STATS to gather statistics, Parallel Query, DML & DDL, Distributed Query tuning, Oracle initialization parameters tuning, Tune production queries by refreshing into QA
• Involved in DB Administration - Oracle Export/Import Data Pump scripts creation, SQL Loader / External Tables scripts creation, Tablespace creation, Schema & DB objects creation, Oracle Streams

Environment: Oracle 10g RAC/9i RAC/8i, SQL, PL/SQL, Java, SQL*Plus, SQL* Loader, TOAD, ERwin, HP-UX, Windows Servers, Windows XP

Confidential

Oracle DBA

Responsibilities:

• Interacted with various project managers and solution analysts for the system requirement routed through the Workflow application, developers during development & unit tests, QA team during UAT & system tests, and Oracle DBA to effectively deploy the DB objects
• Involved in the complete software development life cycle (SDLC) at all levels including - analysis, create system design specification (SDS), modeling/designing at logical/physical level using ERwin data modeling tool, implemented the solution using Oracle, created test plans & scripts for unit, system and regression tests, created UAT & production deployment re-runnable scripts, coordinated the releases
• Involved in the development using SQL and PL/SQL (Used many new features including Analytical functions, Ref cursors, Collections etc.)
• Performed the review of the Java application code that interacts with Oracle DB
• Performed extensive and hands on SQL and PL/SQL performance tuning using CBO - Table & Index partitioning (Pruning), B*Tree, Bitmap, Function based & Domain indexes, Extensive Optimizer hints usage in Query and DML, Analyze DML and Query plans using Explain Plan, trace, TKPROF and TOAD tools, Materialized Views and Query Rewrite, Table & Index analysis using DBMS STATS to gather statistics, Parallel Query, DML & DDL, Distributed Query tuning, Oracle initialization parameters tuning, Tune production queries by refreshing in QA & Pre-Prod servers
• Involved in DB Administration – Automated tablespace (UNDO, TEMP and others) reduction using metadata for more than 300+ instances, Real Application Cluster (RAC) configuration, Data Guard configuration, Oracle Export/Import Data Pump scripts creation, Oracle Audit Vault configuration, RMAN backup, recovery and DB refresh using duplicate database of RMAN, Oracle Internet Directory (OID) configuration
• Used PVCS and Tortoise SVN tools for version control

Environment: Oracle 10g RAC/9i RAC, SQL, PL/SQL, Java, OEM Grid Control, DBArtisan, SQL*Plus, TOAD, PL/SQL Developer, ERwin, PVCS, Tortoise SVN, Workflow, Linux, Windows Servers, Windows XP

Data Warehouse Analyst

Confidential

Responsibilities:

• Interacted with VP and the project manager for the system requirement, with business end users & developers during development, UAT & implementation, with Unix administrators & other Oracle DBAs to discuss the project implementations
• Involved in the complete software development life cycle (SDLC) at all levels including - analysis, create system design specification (SDS), modeling/designing at logical and physical level using ERwin data model tool, implement the solution using Oracle and Unix, create the test plans & scripts for unit, system and regression tests, create UAT & production deployment instructions, perform the releases at Unix and Oracle level, create the user manual
• Involved in the Data Warehouse development (ETL) using SQL, PL/SQL, SQL*Loader, Export/Import, Unix scripts, FTP
• Used CVS tools for version control
• Performed all Oracle database administration activities of test database servers of multiple instances including but not limited to - instance startup & shutdown, instance tuning, DB space monitoring to allocate and shrink space in Undo, Temp & User tablespaces, manage user schemas and all DB objects
• Performed extensive performance tuning – Table & Index partitioning (Pruning), B*Tree, Bitmap & Function Based index creation, Cost Based Optimizer hints, Explain Plan, trace, TKPROF and TOAD tools, Table & Index analysis using DBMS STATS to gather statistics, Parallel DDL & DML, tune production queries by cloning in pseudo server
• Automated archive and purge of database tables using metadata repository
• Automated commodity symbols and prices FTP download from external servers through the firewall
• Created UNIX scripts for batch jobs (ETL) to schedule them in CA-Unicenter
• Created UNIX scripts for test cases, production files mirroring, comparison, files backup etc.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Loader, Export/Import, OEM, SQL*Plus, TOAD, Business Objects, ERwin, CVS, IBM AIX UNIX scripts (ksh, awk), CA-Unicenter, cron, Windows XP

Data Warehouse Analyst

Confidential

Responsibilities:

• Interacted with business analysts for the system requirement
• Involved in the complete software development life cycle (SDLC)
• Performed System Analysis and created System Design Specification (SDS)
• Performed System Design (conceptual, logical & physical) using ERwin data modeling tool to create star schema (Ralph Kimball’s Dimensional model) for Dimension and Fact tables
• Involved in the Data Warehouse Development (ETL) using SQL, PL/SQL, OWB and Unix scripts
• Created Test plans & scripts and Performed Unit, Integration, Regression & System tests
• Created QA and Production Deployment instructions
• Created the System Operating Documentation
• Used SQL-Station and MKS Integrity tools for version control
• Created the QA & Production releases in Change Tracker for tracking & supervisor approval
• Used Oracle 9iDS/6i Forms to create Forms for metadata capture
• Used Data mapping from source to target database using OWB
• Performed extensive performance tuning on this multi-terabytes data warehouse – Table & Index Partitioning (Pruning), B*Tree, Bitmap & Function Based index creation, Cost Based Optimizer hints, Explain Plan, trace, TKPROF and TOAD tools, Table & Index analysis using DBMS STATS to gather statistics, Parallel DDL and DML
• Used many packages of PL/SQL, new features and analytical & aggregate functions of SQL
• Created UNIX Test scripts
• Created UNIX scripts for Batch jobs to schedule in Control-M
• Interacted with UNIX and Oracle database administrators
• Provided 24x7 application & job support in Production

Environment: Oracle 9i, SQL, PL/SQL, Oracle Warehouse Builder 9i, Oracle 9iDS/6i Forms, SQL*Plus, OEM, TOAD, Business Objects, ERwin, SQL-Station, MKS Integrity, IBM AIX UNIX scripts, Control-M, Windows XP

Data Warehouse Consultant

Confidential

Responsibilities:

• Interacted with business analysts for the system requirement
• Involved in the complete software development life cycle (SDLC)
• Performed System Analysis and created System Design Specification (SDS)
• Performed System Design (logical & physical) using ERwin data modeling tool
• Involved in the Data Warehouse Development (ETL) using SQL, PL/SQL, SQL Loader and Unix scripts to extract the data from source systems, transform and load into the data warehouse database
• Involved in the Application Development using SQL, PL/SQL, Mod PL/SQL, HTML, JavaScript, Developer 9iDS/6i Reports, Business Objects (Web Intelligence)
• Involved in Testing, Created Test plans and Performed Unit, Integration, Regression & System tests
• Created the System Operating Documentation and Deployment instructions
• Performed the database release of the objects
• Performed extensive performance tuning – Table & Index Partitioning (Pruning), B*Tree, Bitmap & Function Based index creation, Cost Based Optimizer hints, Explain Plan, trace, TKPROF and SQL Navigator tools, Table & Index analysis using DBMS STATS to gather statistics, Materialized Views, Parallel DDL and DML
• Used Oracle Loader to load data from the source to the staging tables
• Used many packages of PL/SQL, new features and analytical & aggregate functions of SQL
• Created UNIX Test scripts
• Created UNIX scripts for Batch jobs to schedule in Autosys
• Interacted with the business customers
• Provided 24x7 application & job support in Production

Environment: Oracle 9i/8i/8.x, Oracle 9iAS, Oracle Application Server 4.x/3.x, SQL, PL/SQL, Mod PL/SQL, HTML, JavaScript, Oracle 9iDS/6i Reports, SQL*Loader, SQL*Plus, OEM, SQL Navigator, Business Objects, ERwin, Sun Solaris scripts, Autosys, Windows XP/2000/98/95

Project Lead and Oracle DBA

Confidential

Responsibilities:

• Performed leading a team of 2 members
• Performed interaction with business analysts for the system requirement
• Involved in the complete software development life cycle (SDLC)
• Performed System Analysis and created high level documents
• Performed System Design (logical & physical) using ERwin data modeling tool
• Performed Resource Allocation by distributing the jobs
• Involved in the Development using Developer/2000 Forms, Reports & Menu, SQL, PL/SQL
• Involved in Testing, Created Test plans and performed Unit, Integration & System tests
• Performed the database release of the objects
• Created the System Documentation
• Created UNIX scripts for Test plans and Batch jobs
• Provided application support in Production

Oracle DBA

Confidential

Responsibilities:

• Installed Oracle Server (8.x & 7.x) on HP UNIX and Windows NT 4.0
• Installed Oracle Server Patches
• Installed Oracle Client software - Developer/2000
• Performed network configuration using SQL*Net, Net8 and TCP/IP protocols
• Performed Database creation in archive log mode (logical & physical)
• Performed Control and Redo log file multiplexing for database recovery process
• Performed Database instance tuning using parameter file
• Responsible for Database startup, shutdown, session & load monitoring
• Performed Hot and Cold Backup as regular backup mechanism
• Performed export and import for logical backup and restore within and across Oracle databases
• Performed data loading into Oracle tables from the flat files using SQL Loader
• Performed configuration of the users, roles, grants, database links for the above applications
• Performed database object creation and maintenance - tables, indexes, constraints, views, synonyms, sequences, stored procedures/functions/packages, database triggers for the above applications
• Performed the tuning of the applications – SQL tuning using Explain Plan, trace, TKPROF, Rule and Cost Based Optimization, B*Tree indexes
• Performed periodic index and table reorganization to avoid fragmentation
• Provided 24x7 on call production support

Environment: Oracle 8.x & 7.x, SQL, PL/SQL, Developer/2000, SQL*Plus, OEM, SQL*Loader, Oracle Export/Import, Oracle Network Configuration, ERwin, HP UNIX scripts, Windows NT 4.0/Windows 9