Naresh Dalua

Contact No: 732-***-**** (Cell),

E-Mail: adhz5l@r.postjobfree.com

Status: US Citizen

CAREER HIGHLIGHTS:

Over 20 years of extensive experience in the complete software development life cycle (SDLC) involved in requirement analysis, architecture and design, development, testing and deployment of internet and business applications in industries such as financial (Risk and Margin), banking, pharmaceutical and manufacturing.

Experienced in partnering with business and technology stakeholders and cross-functional teams to manage the exceptions and timely delivery of the projects.

Developed conceptual and logical information models for Prime Brokerage, Wealth Management and Agency Lending line of business risk applications.

Manage 2 risk applications with 40 terabytes of database size in equity prime brokerage and global wealth management line of businesses.

Good knowledge of big data and data warehouse architecture and designing star schema, snow flake schema, fact and dimensional tables, physical and logical data modeling using Erwin, Oracle Designer.

Domain knowledge in reference data, data warehouse, data mining, ETL processes, data modeling and regulatory reporting.

Hands on experience in design, development and implementation of large-scale database systems using Oracle and Big Data.

Extensive experience with ORACLE database version(s) 11g/12c and extensive PL/SQL development, development of stored procedures, functions, triggers, views, metalized views and UNIX shell scripting.

Expert knowledge of Oracle partitioning and performance related design.

Exposure to Agile Methodology.

Demonstrated competence in interfacing with clients for ascertaining requirements and delivering appropriate product solutions.

Resolve support/operational issues in liaison with project managers & business group.

Experience in leading geographically dispersed teams in USA, UK and India.

TECHNICAL SKILLS:

Big Data Technologies: Sqoop, HDFS, Hive, Impala, Yarn, Apache Spark

Hadoop Distributions: Cloudera

Databases: Oracle 11g/12c (RAC), Cassandra

Data Modeling: Erwin, Power Designer and Oracle Designer

OLAP Tools: At-Scale 6.5, Jethro

Visualization Tools: Tableau 2019

ETL/Data Warehouse Tools: Informatica, Ascential Datastage

Reporting Tools: Actuate (E-spreadsheet designer)

Programming Languages: C, Java, Visual Basic, Unix Shell Scripting, HTML, ASP 3.0,

PL/SQL, Pro*C, Click View, SQL Loader

PROJECTS:

JP Morgan Chase, Jersey City, NJ 04/07 – Till Date

Project: Risk Analysis and Control System

Role: Data Architect/Technical Team Lead

The Risk Analysis and Control System (RACS) is a global risk management reporting system within Prime Brokerage (Global Clearing Services), Agency Lending and Global Wealth Management Technology, which analyzes every portfolio prior to the opening of the market, as well as on an intra-day basis. Using Stress Testing Methodology, risk measure, which simulates the loss to a portfolio over a range of extreme market scenarios. The market scenarios that can be simulated include: Market price stocks, volatility stocks, time travel, and interest/credit spread shocks As opposed to Value at Risk (VAR) - A statistical risk measure which measures the market risk of a portfolio using probabilities based on a common confidence level (e.g. 95%) and time horizon (e.g. 1 Day).

Responsibilities:

Lead/Manage database development team in risk system

Manage 2 lines of business applications with 40 terabytes of space

Architected and designed risk system for Prime Brokerage and Global Wealth Management clients

In-depth Oracle experience writing PL/SQL packages, stored procedures, SQL Loader scripts, familiar with optimization techniques, and developed high-volume, time-critical systems with Oracle RAC 11g/12c.

Extensively used Table Partitioning/Sub-Partitions, Local Indexes

Performance tuning of the entire risk system.

Data architect using Erwin design tool for Oracle and Big Data.

Designed and architected the data model for the converged application into Big Data platform.

Architected dashboard reports using Tableau and Impala.

Architected very large database initiative to meet 4 hours RTO by designing active/archive data model.

12c migration - Worked with PM, solution architect, build and project DBA teams to acquire and refresh the database from 11g to 12c using TTS approach. Worked with operation and application DBA teams to implement and optimized the application.

Citigroup, Warren, NJ 07/06 – 03/07

Project: Plan View Implementation

Role: Data Architect/Technical Design Analyst

PlanView Enterprise Portfolio Management creates enterprise-wide visibility allowing decision makers to analyze and manage business risk, prioritize strategies and use scenario planning to prepare for change and uncertainty. Plan View Project Portfolio Management provides the tools to effectively estimate and plan project work. This robust software package allows users at all levels to identify and mitigate project risks, collaborate on work and manage project lifecycles from request to closure. Plan View Service Portfolio Management collects and manages the total cost of labor, software, hardware, infrastructure and outsourcing involved in business systems delivery.

PlanView's service delivery software includes:

Financial Planning

Service topology

Application inventory

Disaster recovery planning

Service lifecycles

Dendrite International Inc., Bedminster, NJ 08/01 – 07/06

Project: Sales Force Automation for Pfizer and Lilly

Role: Senior Developer

This Project captured pharmaceutical sales representative's data (maintained on Laptops and hand held devices) to an operational database. The data is transferred to a data mart via a data warehouse before it is sent to Pfizer’s Sales force. There is a regular exchange of data between the Laptop and the Dendrite centralized database and finally replicated these data to Pfizer’s database.

DSQ Software Limited, Chennai, India 05/97 – 07/01

Project: Warehouse System for Mercury International (UK)

Role: System Analyst

This system was developed to automate the warehouse system of all sites of Mercury International Limited, a wholly subsidy of Ocean International Logistics Limited located in United Kingdom. Upon receiving customer consignments, each site deals with their own job processing like – sorting, packaging, wrapping, pick & pack, mailing, shipping and forwarding to regular mail service providers and also doing fleet management operations

Escorts Limited, Faridabad, India 08/96 – 04/97

Project: ERP Implementation

Role: Developer

This project was executed for Escorts Ltd. India. This package is an integrated family of manufacturing, distribution and financial applications consisting of 12 modules - Inventory Management, Order Entry, Purchasing, Shop Floor Control, Bill of Material, Material Requirement Planning, Master Scheduling, Capacity Requirement Planning at Rough Cut and Detailed levels, Accounts Receivable, Account Payable and General Ledger. Along with these modules a number of other modules, namely Plant Maintenance, Tool Management and Quality Assurance were developed. Also developed number of transition systems to gather requisite data to meet AVALON specifications. A process Bill of Material to structure demand dependency has also been developed for the first time.

Educational / Technical Background:

1Master of Computer Applications (MCA) awarded by Ram Manohar Lohia University, India

2Bachelor of Science (Honors) from Utkal University, India

References: Available upon request

Contact this candidate