NIDHI

Email: acxtj2@r.postjobfree.com,

Phone: +1-517-***-****

Professional Synopsis

Around 8+ Years of Experience in the field of Software Design, Development and Implementation with Proficiency in Oracle 8i/9i/10g,11g, SQL, PL/SQL that includes Complete System Development Life Cycle from Analysis and Design to Implementation.

Expertise in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.

Expertise in Partitioning Framework. Created List, Range, Hash and composite partitions to store Transaction and Historical Data.

Worked with query tools like Toad, PL/SQL Developer.

Manipulated Stored Procedures, Triggers, Views, Functions and Packages using TOAD.

Experience in Performance Tuning & Optimization of SQL statements.

Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications.

Created materialized views like primary key, rowid, and sub query materialized views.

Strong in writing Stored Procedures and SQL queries

Proficient in data loading/extraction using SQL*Loader and Oracle utilities.

Good understanding of the Oracle database, related utilities and tools.

Around 4 Years of Experience in UNIX Shell scripting.

Basic Knowledge of Hadoop, Mapper Reducer.

Hands on experience of SQOOP utility to load data from one database to another.

Have extensive experience in Performance tuning by analyzing the execution plans of the query

Hands on experience in tracking down the bottlenecks in query using trace files.

Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.

Excellent analytical and interpersonal skills, oral and written communication skills.

Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities.

Strong personal drive and ability to work individually and in team environments.

Ability to learn new tools, concepts and environments.

Ability to explain technical concepts and communicate with users and system administrators at all levels.

Technical Skills

Database Systems Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i, Oracle RAC (10g & 11g)

Operating Systems Sun Solaris, HP-UX, AIX, RHEL, Windows, VMware

Software’s/Utilities SQL*Plus, SQL*Loader, PL/SQL, Import/Export, UNIX Shell Scripting, Data pump, TKPROF,DBMS_SCHEDULER, TOAD, SQL Developer, Putty, SQL TRACE, Mapper Reducer

Languages SQL, PL/SQL, Shell Programming, Basic Hadoop, Hive

Education

Bachelor’s degree in Computer Engineering from Jaipur, India.

Certifications

Oracle9i Certified Associate (Database Administration)OCA

NSE Certified in Financial Markets(NCFM)

-Beginners Module-Capital Markets

-Beginners Module-Currency Derivatives

Professional Experience

Credit Suisse-BASEL III Singapore/New-York Aug’13 - Till date

Sr. Oracle PLSQL Developer

Basel III is a compréhensive set of reform measures, developed by the Basel Committee on Banking Supervision, to strengthen the régulation, supervision and risk management of the banking Sector. These measures aim to improve the Banking sector's ability to absorb shocks arising from financial and economic stress and risk management and governance.

STAR BASEL Team receive data from various upstream components (OPERA, DAL, Gateway, Insight, NTPA), process in DWH and send to down Stream components. This system receives data from upstreams in the form of flat files. Thèse flat files are loaded into STAR data warehouse using SQL Loader. Loaded data is further processed in STAR and send to Down Stream systems like DataMart, OBIEEE and AXIOM for Regulatory Reporting.

Major Achievements in the project:

Achieved “Excellence in Contribution” in Wipro Technologies for Excellent work done in BASEL III Project-2015

Achieved “Excellence in Contribution” in Wipro Technologies for Excellent work done in BASEL III Project-2014

Achieved “Feather in My cap” in Wipro Technologies for Excellent work done in BASEL III Project-2014

Worked as an SME on IHC (Intermediate Holding Company) Project for 2 Months from Singapore.

Worked on Performance tuning at Code level (after analyzing explain plan) and reduced execution time from 3 hours to 30minutes.

Delivered business critical applications in one third time and received client appreciation for the same.

Responsibilities:

Interacting with the business users to understand the functionality and their requirements.

Designed and developed custom packages, procedures, Triggers using PL/SQL.

Loaded data into Oracle using PL/SQL, Dynamic SQL UTL_FILE, SQL* Loader and extensive use of External Tables

Extensively worked on Oracle Packages, procedures and functions using PL/SQL, SQL, SQL Navigator and PL/SQL Developer.

Used PIVOT, UNPIVOT, LISTAGG and many functions in Oracle 11G to transform complex source data as per mappings

Performed unit test on the developed code to ensure that its bug free.

Handled Production and UAT issues and manage the same in issue log.

Interacted with Business Analysts and Users in requirement gathering, built complex queries

Using SQL and wrote stored procedures using PL/SQL.

Involved in the database design for better understanding the relations, associations and dependencies within the database.

Designed Technical design document based on the business requirements.

Worked on SQL*Loader to perform bulk data loads into database tables from external data files.

Designed and developed Oracle PL/SQL Procedures, Functions, and Database Triggers and involved in creating and updating Packages to meet business requirements.

Created UNIX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources.

Wrote complex SQL queries to extract data from various source tables of data warehouse.

Created various Function Based Indexes to significantly improve performance.

Created tables, Correlated sub queries, Nested Queries, Views for Business Application Development.

Experience in Partitioning Framework. Created List, Range partitions to store Transaction and Historical Data.

Used Oracle packages like DBMS_STATS to collect statistics of many different kinds as an aid to improve the performance and UTL_FILE to read and write operating system text files.

Extensively used Bulk Collections to insert and update huge amount of data into target databases.

Extensively used advanced features of PL/SQL like Ref Cursors, Collections (Nested table and Varray) and Dynamic SQL.

Optimized SQL to improve query performance using SQL Navigator and PL/SQL Developer.

Understanding the requirements and preparing the business requirement and functional specification document.

Analyzing the reports requirement and designing the Dimensional model.

Environment: Oracle 10g/11g, PL/SQL, PL/SQL Developer, SQL Loader Unix.

Barclays India- Dodd Frank Reform Jul’12 - Aug‘13

Sr. Oracle PLSQL Developer

The Dodd Frank wall street reform & consumer protection act established a comprehensive framework for regulating the Over the counter swap markets –a market that previously had been excluded from regulatory oversight and that has grown exponentially in recent years. Basically Dodd Frank reporting generates various Reports (Commodities, FX Trades, Swap, Backloads) for Historical and Real Time Trades and sent to SRF.

Also, Generates Regulatory reports and sent to SRF further. Barclays capital is engaged with Sophis to use Sophis Risque(Sell Side) Application to book trades, calculate PNL, Risk.

Major Achievements in the project:

Achieved “Feather in My cap” in Wipro Technologies for Excellent work done in Dodd FrankProject-2013.

Generated Regulatory Reports like Commodities, Rates and Backload data for Regulators.

Worked on a complex requirement like Basket Instruments to identify Underlies for regulator.

Responsibilities:

Analyze the functional & technical requirements and of the project.

Performed unit test on the developed code to ensure that its bug free.

Handled Production and UAT issues and manage the same in issue log.

Interacted with Business Analysts and Users in requirement gathering, built complex queries using SQL and wrote stored procedures using PL/SQL.

Involved in the database design for better understanding the relations, associations and dependencies within the database.

Designed Technical design document based on the business requirements.

Involved in Logical and physical modeling.

Manage team of 3 people, create project plans, conduct meetings, perform code reviews.

Designed and developed ETL process from scratch for this new system using Oracle, PL/SQL and Unix.

Designed Fact and dimension tables and handled slowly changing dimensions.

Create new Tables, Indexes, Views, Materialized Views, Table Partitions as per the requirement.

Create SQL, PL/SQL Packages, Procedures, Functions and views as per the requirement.

Extensively used PL/SQL Collections, BULK Collect, Table Types, And Record Types, UTL_FILE

Wrote complex stored procedures and packages.

Create new Structures, Input/Output Events, and Sources in RDJ for new rules.

Create & Modify Transformation, Change, Balancing, Aggregate & Audit rules in RDJ8.3.2 as per the requirement.

Validate, extract and send the rules to File Manager, compile and move them to production.

Move data between databases using Import/Export.

Extensively used Explain Plan and TKProf utilities to fine tune and improve the performance of application.

Extensively used hints to tune & optimize queries using DB links.

Used DRIVING_SITE, HASH, INDEX, NO_USE_NL, etc hints to optimize queries.

Wrote complex shell scripts for processing of rules.

Extensive usage of Oracle External Table Concept to extract Data from feed File sent to FTP feed file location.

Monitoring the schedules and timely escalations to the project management and client in case of any slippages.

Extensively involved in using HINTS to direct the optimizer to choose an optimum query execution plan.

Environment: Oracle 11g,10g, 9i, PLSQL, Windows NT, SQL Developer, SQL loader, Shell scripting

Fiserv India Oracle PL/SQL Developer Aug’11 – Jul’12

Project:

Trade Flow Aug’11 – Jul’12

Oracle PLSQL Developer

Trade Flow is a market-leading product for post-trade securities processing (Electronic Trade Confirmation and Electronic Trade Settlement), introducing the additional benefits of transaction process management to traditional straight-through processing (STP) projects. Trade Flow does the Reconciliation and Matching and Settlement of various financial transactions/trading done on the Stock Exchange and in Over the Counter markets. It supports Securities, Foreign exchange, Money Markets, Derivatives trades. Also, It creates a Settlement Instructions in standard SWIFT format which is a global carrier of Financial Messages.

Responsibilities:

Used the merge statements to select rows from one or more sources for update and insertion into one or more tables.

Used PL/SQL collections (Nested Tables and Varray) in complex backend packages.

Coded UNIX shell scripts to call SQL scripts and to manipulate the returned data.

Developed test plan documents for all back end database modules.

Extensively worked on Explain Plans and various hints for Performance tuning.

Wrote Database triggers for audit and to implement complex business logic.

Discussed and analyzed business functionality with the client and the developers.

Involved in the database design for better understanding the relations, associations and dependencies within the data base.

Created bitmap indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.

Involved in writing functional and technical documents.

Generated SQL scripts for crating tables, Views, Primary keys, Indexes, Constraints, Sequences and Synonyms.

Developed and modified PL/SQL packages, procedures, functions as per customer requirement to make new enhancements or resolve problems.

Wrote complex SQL queries to retrieve information from the database depending on user requirement.

Created PL/SQL program units to implement DML, DDL statements using dynamic SQL.

Wrote control files and loaded the data into oracle database with SQL*Loader.

Used PL/SQL Developer tool to do the backend development.

Wrote complex oracle SQL using joins, sub queries and correlated sub queries.

Implemented Materialized View for extracting the data.

Handled various Exceptions to trouble-shoot PL/SQL code.

Environment: Oracle 10g, PL/SQL,Toad 7.5.2.0, UNIX.

IBM India Oracle PL/SQL Developer Oct’08 – Feb’11

Project:

Deutsche Bank - eSpear DLM Project Oct’08 – Feb’11

Oracle PLSQL Developer

Data Lifecycle Management (DLM) is part of the eSpear Infrastructure Program.

It is to be implemented in two stages – the first stage is an initial data reduction by re-implementing eSpear, migrating to the new system only data on open trades, this will reduce the eSpear Production data footprint to a fraction of the current size. Data which is not migrated will remain in the legacy system and be available for reference. The second stage of DLM will be to implement an archiving strategy within this partitioned environment.

Major Achievements in the project:

Won the “Team Excellence Award” in I BM India for Excellent work done in Securities Operations project-2010.

Reduced the production data footprint to a fraction of the current size.

Implemented an archiving strategy within this partitioned environment

Responsibilities:

Wrote stored PL/SQL Procedures for reports.

Developed PL/SQL scripts for data processing.

Created Indexes, Views and Tables

Optimized the existing UNIX scripts to achieve better performance.

Wrote triggers and procedures to handle the data processing.

Created scripts to trigger nightly batch processes.

Involved in Developing and Generating Reports.

Experience with Enterprise Guide in generating analytical reports.

Preparing Unit test scripts, setting up a test environment and unit testing the code.

Tuning of the SQL statements for application developers.

Writing validation packages using PL/SQL package.

Used PL/SQL to validate data and to populate billing tables.

Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.

Experience in Partitioning Framework. Created List, Range partitions to store Transaction and Historical Data.

Environment: Oracle 10g, PL/SQL, Toad 7.5.2.0, Unix.

Contact this candidate