Project Manager
Resume:
SHULABH NIGAM
********@*****.***
Jersey City, NJ
Prologue
An Oracle PL/SQL professional with over 10 years of IT
experience having depth knowledge of Analysis, Design,
Development, Performance Tuning, Support, Testing and Team
management. Actively involved in CMMI level 5 methodologies
and implemented quality assurance standards at every stage
of the application development.
Career Summary
Strong experience in Oracle (8i/9i/10g/11g) & PL/SQL on Windows / UNIX
environment including software development, support, recruitment, training
etc. Extensive knowledge in design and development of stored procedures /
functions / packages / database triggers / SQL Loader. I have succeeded in
various significant roles that have been entrusted to me-
1. Project Initiation, Planning, Execution, Monitoring and Closure
2. Strong experience in Oracle (8i/9i/10g/11g) with Windows / UNIX
environment. Extensive knowledge in database design, development of
stored procedures / functions / Packages / database triggers. Tuning
queries for higher performance (Using Hints, HWM concepts, explain
Plain, Tkprof etc).
3. Extensive Experience in back end development including Database
design, complex stored procedure, Database triggers, functions
packages, views, materialized views( using Complete, fast and force
refresh), Database links, Partitions, indexes, Synonyms, Dynamic SQL
using ORACLE SQL and PL/SQL
4. Strong working knowledge of advance PL/SQL concepts- records &
collections, bulk collect, forall etc.
5. Good experience in handling large data volume.
6. Good knowledge of Oracle XML features.
7. Knowledge of UNIX & Shell scripting.
8. Working knowledge of Sybase 12.5.
9. Effort and schedule estimation, client Engagement
10. Requirement gathering & Management
11. Communication Management - including Weekly Progress Report to the
Client & Status Updates & SCRUM
12. People Management & Team Building - Developing and grooming the team
13. Knowledge Management managing internal and external training
requirements.
14. Experience of job scheduling tools Autosys & Control-M.
15. Experience on the generic system of mutual fund business, knowledge of
different transactional components.
16. Business exposure of Derivatives.
17. Knowledge of quality processes.
18. Experience of data migration.
Professional Qualification
1. Master of Computer Application (MCA Full Time, 1999-2002) from
Visvesvaraya Technological University, Belgaum.
2. MBA(2006-2008) from Sikkim Manipal University.
Current Employment
Employer : TATA Consultancy Services Ltd.
End Client : JP Morgan Chase, Jersey City, NJ
Designation : Project Manager (onsite coordinator)/Assistant
Consultant
Location : Jersey City NJ, USA
Core Technical Skills
Operating Systems : Microsoft Windows from 98 to XP; Multiple Unix
variants.
Languages : SQL, PL/SQL, Sybase T-SQL, Shell Scripting
RDBMS : Oracle 8i/9i/10g/11g, Sybase
Reporting : Oracle Reports 6i
ERP : Oracle E-Business Suite Release11.0.3-HRMS
Alerts & Reports development
SCM Tools : Rational Clear Case, Subversion, Microsoft VSS
Job Scheduling Tools : Control-M, Autosys
Build & Release Tool : ITG Kintana, JIRA
Other Tools : TOAD, SQL Navigator, PL/SQL Developer, Rapid SQL,
Aquadata
Project#1
Title : Pre Employment Administration EXchange: Lotus Notes
- Oracle
Migration
Company : JP Morgan Chase
Role : Project Lead
Duration : Oct-10 - till date
Platform : Windows XP/Sun OS
Environment : PL/SQL, JAVA, JSF, Control-M
Database : Oracle11g
Team size : 12
Brief :
The project involves migration of all employee's legacy Data managed in
Lotus Notes ever since its existence to PEAX for all its location spread
over multiple continents and processing all future employee data through
external and internal interfaces. The data is migrated using a generic tool
developed by TCS. PEAX is a web based integrated centralized global system
being developed by TCS. It consists of employee Background Check, Drug
Test, Fingerprints & Security Scan integrated as components of PEAX.
XML files are loaded through tool into Oracle Database with Data Integrity
Check. The data loaded in the staging tables are first validated. The
erroneous records involved in all components are removed using Final Cycle
Error handling techniques. These erroneous records are corrected and given
at a later stage by JPMC for migration. The pure data is then transformed
into the PEAX database from where live transactions are started for
servicing across any location.
My role and responsibility include:
1. Development and maintenance of Data Migration tool.
2. Mentor database team.
3. Analyze client requirements and have a clear understanding of
Technology deliverables. Design and develop the most ideal technology
solution for the client to ensure client requirements are met.
4. Ensure all project deliverables are completed on time and every
details of the project are documented.
5. Customer Focus, Quality & Improvement Focus.
Technical Responsibilities:
1. Development of internal/external interfaces to load XML files into the
Oracle database from multiple external vendors.
2. Performance tuning.
3. Writing properties files to provide/load data to downstream systems.
4. Writing packages/functions/stored procedures to fit complex business
logic.
Project#2
Title : Pyramid Trade Processing (PTP) Feeds -A derivative
trading
application component
Company : JP Morgan Chase
Role : Investment Banking Technology Associate
Platform : Windows XP/ Multiple Unix variants
Environment : T-SQL, Unix Shell Scripting, Control-M, erebus
Database : Sybase 12.5
Team size : 8
1 Brief :
Pyramid is a suite of applications, a database and a messaging system that
together provide transaction lifecycle processing for OTC derivative
instruments(equities, credit and rates) and exchange traded products(future
and options), including trade capture, event management, risk management
and feed to corporate and back office systems(STS, VARS, GlobalNet, Sampras
etc)
Pyramid Application consists of:
Pyramid Trade Processing - trade capture and position management
Parada- risk analysis
Archimedes- risk management
Merlin- pricing and risk calculation
Erebus is an ETL tool allows new feeds to be written and released into
production by creating just a cron tab /Control-M job and properties file.
Responsibilities:
Worked as an individual contributor and aligned with Vice President -
Investment Banking Technology group of JP Morgan Chase UK. My role and
responsibility include:
1. Analyze client requirements and have a clear understanding of Technology
deliverables. Design and develop the most ideal technology solution for
the client to ensure client requirements are met.
2. Planning and Scheduling: Maintain and schedule an activities calendar
for the projects as per priorities and provide status and progress report
to all concerned as per the agreed reporting interval.
3. Ensure all project deliverables are completed on time and every details
of the project are documented.
4. Customer Focus, Quality & Improvement Focus.
Technical Responsibilities:
5. Understanding the business logic.
6. Writing properties files to provide/load data to downstream systems.
7. Writing stored procedures to fit complex business logic.
8. Performance Tuning.
9. Coordination with London/Glasgow/New York technical/functional teams.
10. Writing design/technical documents
11. Configuration of Control-M Jobs.
12. Developing Shell scripts and Sybase store procedures.
13. Third level production support.
Project#3
Title : Fixed Income - Portfolio Order Management System
(POMS)
implementation
Company : Fidelity Investments
Duration : 02/2008 - 03/09
Platform : Windows XP/Sun OS
Environment : PL/SQL, Informatica8.1, Autosys, Perl
Database : Oracle 10g
Team size : 6
2 Brief :
The Bloomberg Portfolio Order Management System (POMS) is a complete front-
end solution for the institutional asset managers. This project involves
two way data movement, i.e. batch data feeds from Fidelity Fixed Income
environment to Bloomberg POMS and batch feeds back from Bloomberg POMS to
Fidelity fixed income environment. Fidelity is responsible for generating
feeds files in the format required by Bloomberg POMS including header and
trailer using Informatica workflows and supply to market data group. Market
data group will then encrypt the files and send to POMS. Same process will
happen in reverse in order to put data back to Fidelity Fixed environment
from POMS.
Technical Responsibilities
1. Understanding the business logic.
2. Identify gaps between POMS and Fidelity fixed income environment and
provide solutions.
3. Coordination with Bloomberg POMS technical/functional team.
4. Writing design documents
5. Database design and development.
6. Writing scripts to pull data from fixed income environment.
7. Configuration of Autosys Jobs.
8. Developing Informatica workflows
9. Writing Shell scripts and PL/SQL code.
Additional Responsibilities:
1. Ownership and Accountability: Manage all aspects of the project
execution including: scope definition, requirements gathering, project
planning and reporting. To be overall responsible for quality and
timeliness of deliverables for the projects, execute and be involved
with various project activities.
2. Involved in requirement Analysis, Solution Designing, Planning and
Scheduling, Reporting, Delivery and Timeline, Documentation, Change
Control, and Communication of the project.
3. Customer Focus, communication, meet milestones and delivery dates and
Interact with clients to effectively address business and project
issues.
4. Drive the development and execution of project plan by working with
project team to define, sequence, and estimate duration of activities
and determine schedules to meet project objectives.
5. Extensive experience in managing change and engaging team members.
Leading change, Team Leadership and Decision-making and ability
provide direction and leadership. Having the team motivated and
effective towards meeting projects and organizational objectives.
6. Perform the role of systems analyst/Solution Architect and contribute
to application design and architecture on a high-level workflow and
data model development.
Project#4
Title : Oracle E-Business Suite HRMS Release 11i
Implementation on
Onsite-Offshore Model
Company : Fidelity Investments
Duration : 03/2006 to 2/2008
Client : Multiple Oracle Apps E-Business Suite
Outsourcing Clienteles
in the United States, one
full implementation for 'The Hartford'
Platform : Windows XP, Multiple Unix variants
Environment : Oracle Apps R11i instances implemented and supported
through
Remote VPN and VNC Connectivity, Rational ClearCase,
TOAD
Database : Oracle10g
Languages : SQL & PL/SQL
3 Brief :
This project involves the development/enhancement/maintenance of Oracle
Applications-HRMS implemented by Fidelity Employer Services Co. for
multiple clients in United States in addition of other products developed
by Fidelity such as Talent Planer, Compensation Planer & Performance
Management etc. as a part of its HRMS services. Project covers all new
customization requirements for specific client and common customization
requests for multiple clients together as well.
Technical Responsibilities:
My primary responsibility is to write PL/SQL Procedures/Functions/Packages
on Oracle 9i.
1. Understanding the business requirements to fit it into HRMS
2. Building and enhancing custom reports using Oracle Reports6i and
integrate them with Oracle Applications.
3. Building and enhancing HRMS Alerts
4. Development PL/SQL functions, procedures & packages.
5. Development of HRMS Alerts.
6. Performance Tuning of SQL queries.
7. Developing reports using Oracle Reports6i for HRMS.
8. Follow the quality processes
9. Unit testing and result verification
Project#5
Title : HDFC FCIS-FC@ Interface
Company : i-flex solutions ltd. Bangalore
Duration : 12/2005 - 03/2006
Client : HDFC Mutual Fund
Platform : Windows2000
Environment : Microsoft.NET 2003, PL/SQL
Database : Oracle 10g
Team size : 5
4 Brief :
This project involves the addition of Mutual Fund Net Banking into the
existing HDFC Net Banking. Project covers all the data hand off and data
upload requirements for HDFC FC@ system to interact with FCIS that will be
newly required or will be undergoing changes from existing Functionality.
Existing FCIS-FleXML gateway is used to achieve the XML message support for
HDFC-FC@ Mutual Fund Net Banking. Additionally FCIS to Finware interface
has been developed for automatic clearing of investment amount from
customer account. An XML request for a customer will be sent to FINWARE for
subscription transaction made at FCIS branch, investor's CASA account in
FINWARE should be debited with the gross amount of the subscription. Also
this amount will be credited to AMC pool account. This activity will be
trigged as an authorization event. The settlement will take place just
before transaction save and if a successful response is received from
FINWARE then FCIS will go ahead with the transaction save. FCIS will be
posting the debit/credit request to FC@Connect who will send the actual
request to FINWARE and build the response as expected by FCIS and send the
response.
Responsibilities:
1. Understanding the business logic
2. Writing backend Procedures/Package to interact with external system.
3. Performance Tuning of SQL queries
4. Generation and validation of XML messages
5. Unit testing and result verification
Project#6
Title : FLEXCUBE Investor service & SWIFT net funds
Company : i-flex solutions ltd. Bangalore
Duration : 09/2005 - 12/2005
Client : HSBC/Asia Fund Services, Singapore
Platform : Windows2000
Environment : Microsoft.NET 2003, Crystal Reports,
MS Visual Source Safe, TOAD
Database : Oracle 10g
Team size : 7
5 Brief :
FLEXCUBE Investor Services (FC-IS), is a product developed by i-flex
solutions limited, to cater to the requirements of the mutual fund
industry. Developed on the latest generation technology platform that
leverages on the capabilities of client-server technology to provide
complete scalability for rapidly growing businesses, FC-IS is designed on
an n-tiered architecture with the web enabled client connected to a
centralized remote database server through a multi-layered architecture of
WEB & Application servers. The objective of the project is to enhance FCIS
to support Swift Net Funds. Swift Net Funds is one of the products of
SWIFT, designed for Mutual Fund industry in XML format.
Job Responsibilities
1. Understanding the business logic
2. Developing PL/SQL functions and procedure for all outgoing messages
3. XML schema(XSD) registration into Oracle database
4. Performance Tuning of SQL queries
5. Generation and validation of XML messages
Project#7
Title : FLEXCUBE Investor service Migration
Company : i-flex solutions ltd. Bangalore
Duration : 06/2005 - 09/2005
Platform : Windows2000
Environment : Microsoft.NET 2003
Database : Oracle 10g
Team size : 5
6 Brief :
FLEXCUBE Investor Services (FC-IS), has been developed with a specific
focus on helping Mutual Fund Companies to attain their objectives of
efficient investor servicing and designing innovative products that help
them to stay ahead of the competition. Initially product was designed using
Visual Basic6.0 and ASP. The objective of the project was to migrate it
into Microsoft.NET platform.
Job Responsibilities
1. Identify the pre migration issues and resolve them.
2. Execution of migration utility.
3. Perform the post migration activities
4. Review and testing of migrated components.
Project#8
Title : UTI Generic Data Migration.
Company : Unit Trust of India, Mumbai
Duration : 4/2004-02/2005
Platform : Sun Solaris
Environment : Oracle F o r m s5.0, PL/SQL
Database : Oracle 8i
Team size : 6
7 Brief :
The project involves migration of all legacy Data managed by UTI ever since
its existence (i.e. 1964) to common Generic Software for all its 85
schemes/Funds spread over 53 Branches. The flat file is loaded through SQL
Loader into Oracle Database with Data Integrity Check. The data loaded in
the tables are first validated. The erroneous records involved in all
components are removed using Final Cycle Error handling techniques. These
erroneous records are corrected and given at a later stage by UTI for
migration. The pure data is then transformed into the Generic System from
where live transactions are started for servicing across any location. The
Control Statistics is taken for transformed records to match entities like
investors, units, amounts, instruments etc for each data owner. This is the
largest data migration in Asia done till date.
Job Responsibilities
1. Understanding the business logic
2. Developing PL/SQL programs, scripts
3. Performance Tuning of SQL queries
4. Testing & implementation of Data Migration Tool.
5. Generating Statistics of Migrated Data.
Project#9
Title : UTI Generic System
Company : Unit Trust of India
Duration : 4/2004-02/2005
Environment : Oracle8i, Sun Solaris, PL/SQL
8 Tools : Oracle 6i Reports, TOAD
Brief :
Generic Software system is developed for UTI using three-tier
architecture. It involves a Java/Applet (GUI/WEB) Presentation layer (Thin
Client), Application Process layer (consisting of a Security Server,
Transaction server and Application Server, which forms the middle ware) and
Database (Oracle 8.1.5). The middleware was developed using Tuxedo 6.5,
providing C++ services, which could cater to both JAVA application and WEB
application using BEA Jolt.
Job Responsibility:
1. Understanding the project requirements for fixes & enhancement.
2. Developing batches, packages, procedures & functions in PL/SQL
3. Developing reports in Oracle 6i Reports
Previous Employment
Employer : JP Mrogan Chase
Designation : Associate -Investment Banking Technology
2 Employer : Fidelity Investments
3 Designation : Senior Software Engineer
4 Employer : Oracle Financial Services Software Ltd.
5 Designation : Associate Consultant
Employer : Unit Trust of India Technology Services Ltd.
Designation : Project Associate
Personal Details
Passport : Valid
Marital Status : Married
Permanent Address : #21, MLA Suits
Mallital, Nainital-260036
Uttranchal, India
Contact this candidate