Data Manager

ANNEXURE

Infosys Technologies Limited Sep-** till date

Title: Sustainability Data Control

Role: Technology Architect (Database) ( Deutsche Bank – Onsite : New York – US )

Period: Aug’18 till date

Description:

Deutsche Bank AG, a company organised under the laws of Germany, with its registered office at

Taunusanlage 12, D-60325, Frankfurt. The purpose of new system is to collect evidence of effective data management control of business information being created by AFC( Anti Financial Crime) systems for monitoring and surveillance purpose.

Role:

Requirement gathering and analysis

Design and Develop Data Models

Create High Level and Low Level design

Development and various testing

Working on SLA critical solution for performance enhancement

Design and Code review

Mentoring Team members for quality deliveries

Title: Faxhub and eFRAS

Role: Technology Architect (Database) ( Fidelity Investments )

Period: Dec’17 to Jul’18

Description:

Fidelity Investments is a leading US based financial services corporation. Fidelity manages a large family of mutual funds, provides fund distribution and investment advice services, retirement services, wealth management and multiple other services.

FaxHub and eFRAS are DB2 to Oracle 12C migration projects

Role:

Requirement gathering and analysis Requirement gathering, Analysis and Understanding Scope of Work

Evaluation of various tools and technique for DB2 to Oracle Migration

Performed POC on migration of LOB objects

Designing Data Model and Logging Framework using Log4PLSQL for target database

Development and Data Validation

Create High Level and Low Level design

Development and various testing

Working on SLA critical solution for performance enhancement

Design and Code review

Mentoring Team members for quality deliveries

Title: Finance Interface Gateway

Role: Technology Architect (Database) ( Bank Of America – Onsite : New Jersey – US )

Period: Oct’15 to Nov’17

Description:

FIG is common interface to multiple General Ledges (SAP ECC, Merrill Oracle, and FCS).Allows source application to send files in current layout to be mapped/translated to the target ledger. Performs standard validation of all files, including duplicate checks and attributes such as currencies and segment values. Performs automated suspense posting for disabled segments, out of balance etc. Transforms legacy format data into the standard chart of accounts structure. Provides notifications of details of execution, errors and suspense entries. Summarizes and balances data based on code block. Accepts balance lines to be posted as transactions using the squeeze logic. Performs large amount splitting and document splitting logic to accommodate SAP ECC performance restrictions.

Role:

Requirement gathering and analysis

Working on clear choice method to select technologies as per Bank Technology stack

Designing End To End solution

Design and Develop Data Models

Create High Level and Low Level design

Development and various testing

Working on SLA critical solution for performance enhancement

Design and Code review

Mentoring Team members for quality deliveries

Interview panel for clients

Title: AIMIA

Role: Technology Architect (Database)

Period: Jan’14 to Feb’15

Description:

AIMIA owns flagship Proprietary Loyalty product Connect-RM through an acquisition in 2009.

Provides support for multiple clients and programs providing unique and distinct program rules within a single implementation

Role:

Designing, Coding and implementing various database

Mentoring Team of 20+ located across Pune, Hyderabad, Chennai, Bangalore and London (UK)

Reviews of Technical Design and code.

Application DBA

Overseeing the implementation of the various modules from performance enhancement perspective.

Title: Mid Office (ABN AMRO)

Role: Technology Architect (Database)

Period: Sep’12 to Sep’13

Description:

Mid Office application is hub of routing mechanism in the value chain of corporate payment processing and caters to very large and varied corporate customer base of ABN.

Modules

Payment Router - Used to route payments to various Back Offices and has connection to various client channels.

Report Router - Receives end of day and intraday reports from Back Offices and enriches reports to be sent to various

Channels for reconciliation purposes

Track n Trace - Tracing mechanism for payments and reports. Used by Special Service Desk and also planned to be rolled

Out to customers.

Billing - Generates billing count of reports and payments and send its feed to Billing Event Store for further processing

Role:

Designing, Coding and implementing various database solutions ( Framework for Daily Maintenance, Partition Strategy and Implementation, Batch Loading )

Mentoring Team of 20+ located across Pune, Chandigarh and Netherland

Data Modeling and documentation using Erwin, SQL Developer Data Modeler

Reviews of Technical Design and code.

Application DBA

Overseeing the implementation of the various modules from performance enhancement perspective.

HSBC Software Development India Pvt Ltd Apr-05 to Sep-12

Title: Eos and MI Development

Role: Sr. Consultant Specialist

Period: Jun’09 to Sep’12

Description:

Project EOS is database for Global Portfolio Management. The ultimate goal is to store data for the many legal entities that make up the Corporate Banking portfolio on a global basis.

Its main objectives and features are:

Create a professional infrastructure to support active portfolio management

Develop a platform for business strategy, portfolio and relationship management

Integrate CIB management related information from different applications into one flexible system.

Provide a platform to support the necessary data and analytical requirements to rebalance and optimise the CIB portfolio.

Provide a systematic means to track Relationship Management, Client, Product, and Region performance

Support strategic, capital allocation, and compensation decisions

Role:

Handling the database delivery management

Leading PL-SQL team of 5+ members distributed in India, UK and Hong-Kong

Data Modeling and documentation using Erwin

Understanding the client requirements and providing estimates for the development/enhancement tasks

Designing and coding of the Back End Packages, Procedure, Functions, Triggers

Managing the Migration from Oracle 10g to 11g

Overseeing the implementation of the project

Functioning as a UAT support and monitoring the preparation of user guide

Title: Global Fund Centre (GFC) Audit Functionality

Role: Consultant Specialist

Period: Nov’08 to May’09

Description:

Global Fund Centre (GFC) is repository of mainly fund's static data and also caters to performance data in very small proportion.

GFC static application, a Web based application is used to maintain this data repository. Main objective of the project was to enhance current application with introduction of audit functionality. This was done to track every change being done to the repository.

Role:

Understood the client requirements and providing estimates for the development/enhancement tasks

Designed and coded the Back End Packages, Procedure, Functions, Triggers

Oversaw the implementation of the project

Performed as UAT support and preparation of user guide

Title: Global Performance Reporting (GPR)

Role: Technical Specialist

Period: Dec’07 – Oct’08

Description:

The Global Performance Team which is part of Investment IT is responsible for collating performance returns from all global offices and aggregating the returns to report to the senior management of HSBC Investments. Global performance reporting is the project initiated with below objectives:

To provide significant improvement in the quality and accuracy of the data presented

To reduce key areas of business risk

To reduce the amount of manual processing and intervention to deliver the reports

Role:

Troubleshot any technical issues, helping in SQL PL/SQL performance tuning, shell scripts, etc.

Title: MDU Development (Market Data Utility)

Role: Technical Specialist

Period: Apr’05 – Dec’07

Description:

MDU - Market Data Utility, provide the Group with a single reference data utility for traded financial instruments to support all relevant Group activities including Research, Trading, Settlement, Custody and Risk operations

The key functionalities include: Non-real time data exchange/electronic data delivered by internal/external data vendors (such as Reuters and EDI, exchanges, agent banks, clients and internal sources) which is processed internally by MDU and supplied to the clients/customers in a customer specific format

Role:

Built team and Knowledge Transfer

Ensured SLA is met for the support activities and if any possible risk escalating it to the management and the client

Coal India Limited Jul-97 to Apr-05

Title: Daily Attendance System

Role: Technical Specialist

Period: Aug’04 – Mar’05

Description:

Capturing of Daily attendance (in FoxPro)

Generation of attendance summary at Month End

Entry of leaves and Over Time Figures and Omitted Attendance (in Excel)

Updation of FoxPro Data incorporating any changes in Attendance in Excel Data reporting changes made

Generation of data salary input data for Oracle

Role:

Gathered System requirement specifications and analysis

Designed functional specifications

Title: Payroll and Attendance.

Role: Technical Specialist

Period: Jan’03 – Jul’04

Description:

The project included:

Salary Calculation

Bonus and other Incentives

Arrears Calculation

PF, Gratuity and VRS Calculation

Executive Information System – Reports

Title: Sales, Delivery, Billing

Role: Technical Specialist

Period: Feb’02 – Dec’03

Description:

Caters to the Sales, Delivery and Billing of the coal dispatched that caters to1449 customers, spread across 6 different regions for 4 hundred thousand tonnes/month of coal sold out. The system incorporates features like:

Quotations

Sales Orders.

Dispatches and Transportation

Billing and Subsequent Settlements

Title: Financials and Asset Accounting

Role: Senior Developer

Period: Apr’01 – Jan’02

Description:

Developed for to the Centralized Financial and Assets Accounting for the entire Area covering 7 mines. The system incorporates features like:

Valuation of machines and other assets

Depreciation Calculation and current valuation of assets

Title: Non Executive / Executive Information System

Role: Senior Developer

Period: Aug’00 – Mar’01

Description:

Aids to the need of Capturing and Maintaining information about Employees like Education Qualification, Family members and addresses, etc. The system incorporates features like:

Addition of New Employees

Updation of any data of existing employee.

Title Chargaon Opencast Mines

Role: Under manager

Period: Jul’97 – Jul’00

Description:

This was one of the five opencast mines in the region was responsible for producing 1.5 million te/annum of coal.

PHOTO

MOHAMMAD SAYEEF

(: +1-201-***-**** WhatsApp Number- +91-982*******

:: ********@*****.***

H: C/O Mr Jignesh Patel, Apartment - D, 41 Saint Andrews Blvd, Clifton NJ - 07012

SKILLS

Oracle

UNIX

SQL

Erwin

OBJECTIVE

Aspiring for senior level assignments in Data Warehouse, Data Modeling/ Database Development/ Maintenance with a growth oriented organization of repute in the IT / Banking sector.

SUMMARY

Highly productive, Database Architect with successful 17+ year’s track record delivering technical solutions to business requirements within the financial services industry.

Proven ability to innovate, design, and implement project as well as enterprise databases along with supporting ETL and application interfaces. Specializing in Data Analysis, Data Modeling, Data Architecture, project management, database design, problem solving, and documentation. Experienced leader delivering quality database systems on time and within budget within a fast-paced, multi-project, multi-organization environment.

Expertise in Data Modeling and Performance Tuning Data Modeling: Conceptual, Logical, Physical, Dimensional

Improved Database performance by implementing advanced Oracle Data Warehousing features: Materialized Views, Partitioning, External Tables, Dimensions and Parallel Execution.

Hands-on-experience in full lifecycle of database development which includes requirement gathering from the business, studying the existing process, documentation of requirement, involvement of technical & functional aspects and design specification

Well versed with Oracle SQL and PL-SQL concepts like Procedures, Functions, Packages, Triggers, Indexes, SQL* Loader, UTL_FILE, Schema/Table level Gather Stats, Oracle Hints(Hash, Nested Loops and Sort Merge), Explain plans, Bulk collects, TKPROF,SQL Profiler, ADDM, Oracle tuning Advisor,Oracle Access Advisor, AWR Reports Analysis, Result cache ( SQL and Function), .

Oracle advanced features like Virtual Private Database, Oracle Label Security, DML error logging, Online Redefinition, Total Recall (Flashback Data Archive), Data Compression.

Exploring the oracle 12c new features like defining sequence, invisible index, in-memory database, pluggable database etc.

TECHNICAL SKILLS

Database: Oracle 7.x/8.x/9.x/10g/11g

Operating System: Unix/Linux/Solaris/Win-XP

Languages: SQL, PL/SQL, Shell Scripting

Tools: Erwin, Toad, Oracle Enterprise Manager, SQL Developer Data Modeler and SQL

Navigator

ETL Tool Exposure to Informatica

NOSQL Mongo DB

WORK EXPERIENCE

Infosys Limited as Technology Architect: Since Sep’12

HSBC Software Development India Pvt. Ltd., Pune as Sr. Consultant Specialist: Apr’05 – Sep’12

Western Coalfields Ltd. (Subsidiary of Coal India Ltd.), Nagpur as Sr. Under Manager (Systems): Jul’97 – Mar’05

Nippon Denro Ispat Ltd. (Central India Coal Company), Nagpur as Management Trainee: Mar’95 – Apr’97

For projects please refer to the annexure

Key Result Areas:

Managing requirement gathering, system analysis & finalization of technical / functional specifications

Understanding business process, study and analyse workflow to design solutions (To-Be, Why-Why Analysis as well as Freezing)

Guiding the set up and customisation of release procedures for classification of various internal as well as external documents

Coordinating with the development team for development / customisation of software

Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models

Create logical and physical data models using best practices to ensure high data quality along with reduced redundancy

CERTIFICATION

British English Council Certificate

AWARDS

EDUCATION

B.E. (Mining) from Nagpur University, R.E.C Nagpur in 1994 with 78.96%

12th from Maharashtra Board, O.F.H.S.S, Chanda in 1990 with 90.5%

10th from Maharashtra Board, O.F.H.S.S, Chanda in 1988 with 85%

PERSONAL DETAILS

Date of Birth: 2nd March 1972

Nationality: Indian

Passport: Z2985178

Visa Status: H1-B

Marital Status: Single

No. of Dependants: None

Languages: English, Hindi & Marathi

Permanent Address: Kashish Building Plot No 7, SR No 107/53 – A, Aashirwad Nagar

Opp Gajanan Mandir Laxmi Nagar Sarkar Nagar Chandrapur (M.S) 442401

Contact this candidate