SUMMARY:

• Industrious, motivated and Certified (OCA) Oracle/Data warehousing/Market Risk Consultant with good business knowledge in Finance, Banking and Telecom and having 12 + years experience with IT, Management Consulting and Financials Firms namely; JP Morgan, Accenture Consulting, Confidential and Indian institute of science (research institute).
• Development of complex business systems and processes using various software and hardware platforms deploying object/relational oriented techniques using Oracle - Pl/Sql, Sql Server T/Sql, Unix, Business objects, XML Publisher, Core Java, Hadoop ecosystem.
• Experience in drawing ER diagrams, Data Flow/Process Diagrams.
• Expert in RDBMS including Conceptual/logical & physical Database Design using MS Visio and Erwin for data modeling.
• Experience in performance tuning using SQL Trace, Explain Plan, TkProf, Indexing, Hints, including Design Level, Sql Level, Procedural level and Instance Level tuning. XML generation in Oracle using Latest standards of SQLX (recently published white paper from IBM).
• Strong knowledge in requirements gathering, analysis, design, development, testing and deployment of Data warehouse(OLAP) including data warehouse architecture, designing star schema, snow flake schema, it s implementation, ETL and reporting tools using Business Objects and Sql Server (Analysis, Integration and Reporting Services.
• Expert in using Oracle Collections, partitions, Index Organized tables, Materialized views, Dynamic Sql, Tables, Views, Triggers, SQL* Loader, stored procedures and Integrity constraints.
• Maintaining multiplexed control files, online redo logs, Export/Import, DBVerify, running database in archived log mode. Monitoring trace files and alert logs for any oracle errors and fixing. Automated database tasks using AUTOSYS and CRONTAB.
• Excellent experience in managing table spaces, data files, undo spaces, database objects, Job queues, Partitioned tables & indexes, Space and security Management.
• Established productive working relationship with Management, Clients and Team Members. Self-starter, entrepreneurial, highly motivated team-player with excellent communication problem-solving skills.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Data Engineer/Consultant

Responsibilities:

• Responsible for developing, enhancing, modifying and/or maintaining application in the global markets environment
• Involve in the Oracle RAC Setup in UAT/PROD; Responsible for User Acceptance Benchmark Testing and migration
• Designed, analyzed end-2-end business requirements with clients, created FRD, complex models/calculations for Solvent wind down project within very tight time schedule.
• Develop framework using SQL and Python to migrate Data from SQL Server to Oracle Database.
• Create database objects such as Packages, Procedures, Functions, Tables, and Indexes (B-tree and Bit Map Index) for the business requirements.
• Review the database objects and improve the performance of the table using the Segment advisor and OEM.
• Write SQL queries for the complex dataset querying for the business requirements.
• Involve in the Infrastructure Capacity Planning, Setting up database environment for UAT/SIT Testing, Increasing SGA/PGA, add disk space/SAN, historical data archiving and purging and tweaking database parameters.
• Proactively monitor the database during the CCAR cycle; Fix the SQL Query plan using the SQL optimizer techniques.
• Responsible for Database code management and release in Production and UAT (User Acceptance Testing) environment.
• Tune the performance of the various SQL using Explain Plan, ASH, and Oracle AWR/ADDM Reports

Environment: Python 2.7 Programming, Oracle 11g, Oracle PL/SQL, Data warehouse, Data Pipelines, ETL, SVN, JIRA, UNIX Shell script

Confidential, NJ

Senior Database Developer Consultant

Responsibilities:

• Responsible for developing, enhancing, modifying and/or maintaining application in the global markets environment
• Review existing process to have a better understanding of the current processes and procedure. Explore the current design and structure to have glimpse on how the data feed were structured.
• Work on the user request to create new or modify the Equities/Deposit/Loans feed that populate the fact table. Update or create new metadata as part of the report and analytic setup.
• Interaction with business analysts, end-clients and technical team to finalize project requirements and system design for collateral & derivatives feed’s 24-Month lookback financial calculations & PDE’s.
• Create PL/SQL procedure and packages that will be used in the new processing and report based on the business requirement.
• Making sure all process and queries undergone rigid testing and tuning for better performance. Creating new workflow to use exchange partition to have high availability for fact data.
• Investigate on user data issues or inquiries on FED5G report and recommend a solution and/or explain possible causes on how the data was derived.
• Using OEM to tune complex queries/plan, collect metrics, cpu/memory details e.tc
• Create post release validation script and will be executed after the code deployment in production.

Environment: Quartz Framework, Python 2.7 Programming, Oracle 12C, Oracle PL/SQL, Data warehouse, Data Pipelines, IBM Netezza, ETL, SVN, JIRA, UNIX Shell script, TOAD, DBATools

Confidential, NJ

Senior Database Developer Consultant

Responsibilities:

• Participated in gathering business requirements with functional team to add new features to dmart from pst and cdw source databases on oracle and redshift.
• Analysis of source systems to translate the requirements for technical analysis.
• Defining underlying data sources and transformation requirements using datanet and eden jobs.
• Implementing transformation logic using XML tags parsed by Perl interpreter.
• Designing suitable logical and physical data model and implementing as tables on oracle and redshift.
• Developing the metadata for the Data Warehouse/Analytical Reporting team to migrate data from Oracle to redshift. Tableau for reporting on top of redshift.
• Implementation of redshift clusters for prod, adhoc, primary, sandbox and BI functionalities.
• Developing routines for data extraction and loading by using efficient development techniques, standards and guidelines.
• Provided technical/user documentation and ; perform peer reviews of work items produced at various stages of the project.

Environment: Oracle 11g, Confidential Redshift 1.0.1012, Unix Shell Scripts, Perl, Oracle SQL Developer, Erwin modeler 7.3, Tableau

Confidential, NJ

Senior Oracle Developer/Architect

Responsibilities:

• Designed Staging Database for Integration with Salesforce CRM system.
• Conduct technical analysis, reverse engineering of existing Siebel database, feasibility study and implementation of workflow integration from Database side.
• Converting reports from existing Siebel system into Salesforce-based Sql Reports and reconciliation between source and target systems.
• Designing database for the reports in data warehouse environment based on business date bucket table-columns dynamically linked to metadata, which is controlled by end clients.
• Interaction with business analysts, end-clients and technical team to finalize project requirements and system design.
• Assigning tasks, reviewing code for teams working at different locations globally. Preparing the design and maintenance documents along with best practices guide for development team and end users.

Environment: Oracle 11g, Unix Shell Scripts, Oracle SQL Developer, Siebel CRM 8.0, Erwin modeler 7.3

Confidential, NJ

Senior Oracle Developer/Architect/Business Analyst

Responsibilities:

• Started with critical ETL layer (BSER) database design using Erwin, workflow design using Embarcadero ER studio, development of ETL code using Talend Tool. Deployment of Java code by Talend on web logic servers.
• Designed OCRM database, a critical metrics dashboard used by UK clients. Developed multiple Asset classes like Cash securities, FX and OTC for OCRM application.
• Designing Datamart for the reports in Data warehouse environment for DSS system.
• PL/SQL object development such as packages, triggers, procedures, functions etc. including deploying the scheduled jobs using the AUTOSYS and UNIX shell scripts.

Environment: Talend 3.1/3.2/4.2, Oracle 11g, Red Hat Linux 5, UNIX Shell Scripts, Oracle SQL Developer, Embarcadero ER Studio DataArchitect/Repository 8.5

Confidential, NJ

Senior Oracle Developer/Architect

Responsibilities:

• This is Input Staging Database used as a base to launch different applications dependent on real-time activities and reconciliation of Geneva reports with mainframe systems

Environment: PL/SQL, Shell Scripts, Oracle 10g, Sql Server 2005, UNIX, Java, Business Objects

Confidential, NY

Senior Oracle DBA/Developer/Designer

Responsibilities:

• This product comes with intelligent software which combines risk, compliance, regulatory and control disciplines with an integrated process management framework. This includes physical/intellectual property risks and provides ways to minimize loses by estimating, calculating using real time systems. There are 4 distinct centersphere modules namely; operational risk management, organizational management & accountability definition, business process management, data collection and monitoring. The combination of enterprise OpRiskCenter’s component can be used to meet individual firm’s needs.

Environment: PL/SQL, Shell Scripts, Oracle 10g, Sql Server 2005, UNIX, Java, Ant, Business Objects

Confidential

Senior Oracle Developer/Designer/DBA

Responsibilities:

• Confidential provides an optimized workflow solution for investment bankers, enabling users to monitor the markets, identify trends of holdings, find targets for public issues, compare companies, assess historical deals and create presentation-ready public information books based on the latest market information.
• Ownership is a part of Confidential, web based product which provides ownership data in an easy to use workflow application. It has an extensive coverage of data, which includes Institutional Data, Buy-Side vs. Sell-Side, UK Share Registers, Declarable Stake Data, Mutual Fund Data, portfolio data of the investors, historical holdings, contacts information, insider information and multi-dimensional data about the variousholdersofthesecurities.

Environment: PL/SQL, T-Sql, Shell Scripts, Oracle 10g, UNIX, SQL*Loader, Sql Server 2000/2005

Confidential

Oracle Consultant through Accenture Services

Responsibilities:

• The UNIT system has been developed for an Internet Service Provider (ISP) based in Italy and spread across more than 12 countries. The system architecture involves three systems, viz. IMS which is a web based information management system serving as a Front-End, Siebel E-communications module for the customer support personnel and maintenance, and Geneva Billing system for handling the Billing operations. Also there are various interfaces for communication and data flow between these systems which are developed in VB and PL/SQL.

Environment: PL/SQL, Shell Scripts, Java, Business Objects, Oracle 9i, Sun Solaris, VSS

Confidential

Developer

Responsibilities:

• Network Address Translator is built as a kernel module in C for Linux kernel series of 2.4 XX used for converting local network to the global address at network layer using IP layer Hooks. This module consists of two Sub Modules called Conntrack module and Address Translator module.

Environment: C, C++, UNIX, Linux and Oracle