Resume

Sign in

Data Developer

Location:
Linden, New Jersey, United States
Posted:
February 22, 2018

Contact this candidate

NIRAJ DINESHCHANDRA AMIN

*** **** ***** ***, ******* Park, NJ 07204.

Phone : 908-***-**** ©

908-***-**** ®

ac4kr5@r.postjobfree.com

Status : U S Citizen.

SUMMARY:

Extensive experience in different phases of the software development life cycle including requirements gathering and analysis, data modeling and database design (Dimensional/Star schema and 3NF), client interface design, preparation of detailed business requirements and technical specifications documents, prototyping, development, testing and implementation of business technology solutions.

In-depth experience in database development/ datawarehousing using Oracle.

Ability to work independently, lead a team of programmers, be a key team player, effectively promote team work and get the job done.

Excellent problem solving, analytical, communication, interpersonal, team management and leadership skills.

Working on various projects gained valuable experience and knowledge in Financial Industry (Equities, Fixed Income, Asset Management, Equity derivatives (futures, options and swaps), P-Notes) as well as in Pharmaceutical Industry.

TECHNICAL SKILLS:

Oracle 11G/10G, PL/SQL, Python, Oracle Forms 10G, Developer 2000 (Oracle Forms

6i,Oracle Reports 6i, Oracle Graphics 2.5), SQL, Unix Shell programming, Cognos, JAVA, XML, Javascript, Servlets, JSP, HTML, JDBC/ODBC, PRO*C,, SQL*Plus, TOAD, SQL*Loader, SQL*Navigator, ERWin, Visio, Oracle Designer, Sybase PowerDesigner 9, Autosys, Informatica 9.0,Microsoft Project.

PROFESSIONAL EXPERIENCE:

Jennison Associates, New York May 2015 – Dec 2017

Senior Oracle Database Developer / Data Architect

Project: Compliance Online Monitoring and Exception Tracking System

Charles River Fixed Income Trading System

Responsibilities:

Create Oracle stored procedures to implement various new investment guidelines compliance.

Perform impact analysis prior to implementing major enhancements and changes to the existing system.

Create Oracle stored procedures to implement logic for automation of Investment Guideline Compliance Monitoring Process.

Create Oracle stored procedures to implement logic for reports customized for Compliance Analysts and Portfolio managers.

Enhance the current system to handle Equity derivatives trades (futures, options, swaps and p-notes.

Perform data analysis and data modeling as required.

Perform end to end testing after all the pieces are put together and ensure delivery of high quality application.

Ensure application perform well consistently by developing and implementing effective indexing strategies, partitioning strategies and SQL Optimization.

Contribute to various oracle code enhancements to the Charles River Fixed Income Trading System

Provide status updates to all involved stakeholders.

Create Technical documentation.

Environment: Oracle 11G, PL/SQL, Unix Shell Scripting, TOAD V9.5, Erwin, Linux ES Release 4, Autosys, Windows XP, Visual Studio Source control.

Bank of America /Merrill Lynch, New Jersey Dec 2014 – May 2015

Senior Database / Data Warehouse Developer

Project: Compliance and Surveillance Datawarehouse

Responsibilities:

Performed impact and gap analysis between various new and existing source feeds as a part of feeds migration projects. Communicate and resolve the gaps to upstream and downstream users and systems.

Worked with ETL teams to implement and test the changes with respect to the new feeds.

Developed/wrote Oracle stored procedures using Oracle PL/SQL for any transformations required to the data in the Datawarehouse.

Created Oracle stored procedures to implement logic for various Trade and Investment surveillance models and reports for Equities, Bonds and Fx trades for various regions globally as per the respective rules and regulations.

Performed data analysis, data mapping, data modeling and data reconciliation as required.

Performed end to end testing after all the pieces are put together and ensure delivery of high quality data, applications and solutions.

Ensured applications perform well consistently by developing and implementing effective indexing strategies, partitioning strategies and SQL Optimization.

Provided status updates to all involved stakeholders.

Environment: Oracle 11G, PL/SQL, Unix Shell Scripting, TOAD V9.5, Erwin, Informatica 9.0, Actimize, Linux ES Release 4, Sybase ASE 15, Windows XP.

KCG Holdings Inc, New Jersey Jun 2008 – Sep 2014

Senior Datawarehouse / Database Developer / Data Architect

Project(s): BondPoint ECN Datamart and BI Reporting System.

BondPoint ECN Brokerage Calculation and Invoicing System.

Fixed Income Datamart and BI Reporting System.

Fixed Income Sales Commission Payout System.

Equities BI Reporting System.

Responsibilities:

Developed/wrote ETL processes using Unix Shell scripts to extract and load data into the datawarehouse from various trading systems.

Developed/wrote Oracle stored procedures using Oracle PL/SQL to append final/transformed data into the Datawarehouse.

Created Oracle stored procedures to perform various calculations such as Brokerage fees, SEC fees, Trade Credits, Payment for Order flow, Trader/Salesperson Commissions etc.

Created Oracle stored procedures to populate various summary tables used by various reports.

Responsible for designing, data modeling, developing and implementing data marts/data warehouse, management and BI/Compliance Reporting Systems and Brokerage Fees Invoicing/Sales Commission Payout Systems for the Equities and Fixed Income businesses.

Performed data sourcing, data profiling, data analysis, data mapping, data reconciliation and data integration (from different trading systems such as BRASS Equities Trading system, Sentry Bank Loan/Debt Trading system, CAS Reverse Mortgage Trading system, Bloomberg Fixed Income Trading system etc)

Performed end to end testing after all the pieces are put together and ensured delivery of high quality applications and solutions.

Ensured applications perform well consistently by developing and implementing effective indexing strategies, partitioning strategies, SQL Optimization and most logic is written in Oracle PL/SQL stored procedures.

Environment: Oracle 11G, PL/SQL, Unix Shell Scripting, Python, TOAD V9.5, Erwin, Cognos PowerPlay Transfer 7.3, DB Maestro, JSP, JDK 1.5, JQuery V1.3, Javascript, HTML, Eclipse 3.4.2, Apache Tomcat 5.5, Linux ES Release 4, Dataguard, Sybase ASE 15, Windows XP, Visual Studio.

UBS Global Asset Management Inc, New York Mar 2007 – May 2008

Database Developer/Data Modeler

Project(s): COSMOS – Portfolio Management.

COSMOS – Product Development & Management Integration.

Responsibilities:

Attended meetings with project sponsors and business users to understand business requirements.

Analyzed the business requirements and prepared detailed functional and technical specifications documents including Data Flow diagrams and ER diagrams.

Designed and created the logical and physical data model using PowerDesigner and Erwin by applying relational data modeling and data normalization principles.

Designed and created physical database objects such as tables, views, sequences, indexes, packages, procedures etc.

Sized the database objects for better performance and efficiency. Developed indexing strategies for better performance. Managed and deployed schema changes.

Came up with a more efficient partitioning strategy for already partitioned tables to improve performance.

Wrote Oracle PL/SQL stored procedures and Oracle PL/SQL stored packages for implementing business logic, auditing and enforcing data integrity.

Wrote unix shell scripts, SQL Loader scripts and PL/SQL procedures for loading the data.

Monitored active database sessions using DBA tools to find out resource usage and SQL queries that take a long time to execute.

Performed application tuning and SQL Optimization for better performance.

Provide detailed production deployment instructions to DBAs.

Provided production support and help troubleshoot/resolve production issues.

Developed stored packages that can be used by all developers for similar support tasks. Train other developers and give demo regarding its usage.

Environment: Oracle 10G, PL/SQL, Unix Shell Scripting, Visio, Erwin, Sybase PowerDesigner 9, JAVA, JSP, Autosys, SQL*Loader, TOAD, PVCS, Sun Solaris, Windows XP.

Pfizer Inc, New York Oct 2006 – Mar 2007

Datawarehouse Developer/Architect

Project: Sales and Marketing Data Warehouse System.

Involved in the datawarehouse development and maintenance related projects.

Wrote unix shell scripts and PL/SQL procedures for extraction, transformation and loading of data(coming from external vendors such as IMS, NDC, Milliman etc) into the datawarehouse.

Wrote Oracle PL/SQL stored procedures and Oracle PL/SQL stored packages for auditing, enforcing data integrity and business logic

Wrote and automated QA scripts using korn shell and PL/SQL.

Automated jobs using Autosys.

Prepared detailed technical specifications documents including Data Flow diagrams and ER diagrams.

Designed database objects such as tables, views, indexes etc.

Involved in application tuning and SQL optimization for better performance.

Mitsui O.S.K. Lines, New Jersey Dec 2003 – Oct 2006

Application Developer/Business Analyst

Project: Equipment Storage System. Maintenance And Repair System (CONMO module).

Environment: Oracle 10G, Oracle Forms 10G, Developer 2000 (Oracle Forms 6i, Oracle Reports 6i), PL/SQL, PL/SQL server pages, XML, Javascript, TOAD, PVCS, Sun Solaris, Windows XP.

JPMorgan Chase Bank, New York Jul 2001 – Nov 2003

Jul 1998 – Oct 1999

Application Developer/Data Analyst

Project: ORIoN (Online Reporting Information Network)

Environment:

Oracle 9i, Developer 2000 (Oracle Forms 6i, Oracle Reports 6i), PL/SQL, PRO*C, Visual Basic, Java, Actuate, SQL Navigator, ERWin, WebSphere, Autosys, Sun Solaris, Windows NT 4.0

EDUCATION:

Bachelor of Engineering, Computer Engineering, University of Pune (India).

Diploma in Electronics & Telecommunication Engineering, Mumbai(India).

CERTIFICATION AND/OR TRAINING:

Oracle7.3 DBA Certification.

Project Management.

Java Development for the Enterprise.

XML for Web Development.

Building J2EE Web Applications using Java Servlets & JavaServer Pages.

Javascript.

Python.



Contact this candidate