Winnith Resume

My LinkedIn Profile

CAREER OBJECTIVE:

To earn a suitable position as a Projent Manager in the IT field in providing Oracle database solutions, where my knowledge  and experience of the Oracle database and other scripting languages, keen desire to learn along with my functional knowledge in insurance and finance will be of great advantage to the organisation and myself.

Location preference.: Mumbai

TECHNICAL SUMMARY:

• Good analytical skills and problem solving abilities.
• Good work experience in the Oracle Database as a developer and lead
• Good knowledge, proficiency and experience in writing efficient queries, PL/SQL ,stored procedures/functions/triggers
• Good knowledge, proficiency and experience in sql query fine tuning and performance enhancement. Tools such awr, statspack and other oracle utilities for tuning
• Good team member and team management skills
• Designed and developed various banking, business and technical applications
• Good functional knowledge in insurance, retail, corporate and investment banking
• Effort estimation and conducting interviews

SKILLS ACQUIRED 

Databases	Oracle 19c/12c/11g/10g/9i/8i/7.3.4,
Operating Systems	Unix, Linux, Windows, MSDOS.
Languages Used	SQL, PL/SQL, Shell and Awk scripting, Python scripting, C, PRO*C
Database Tools	Toad, ERWin, PL SQL Developer, Sql Developer
Big Data	Setup and configuration of HDFS, spark, hive, pig, hbase, sqoop

 

QUALIFICATIONS:

BE – Mechanical,   VJTI, Mumbai University. - June ’93 –  June ‘97

CERTIFICATIONS:

Oracle 19c Database Administrator Certified Professional

    Month and Year of Certification : May 2024

Oracle 10g Database Administrator Certified Professional

    Month and Year of Certification : November 2007

 Oracle9i Database Administrator Certified Professional

    Month and Year of Certification : July 2006

 PROFESSIONAL TRAINING UNDERGONE:

Retail Banking and Trade Finance training for banking product ‘Finacle’ developed by Infosys.

Training in Investment Banking conducted by Oracle Financial Services formerly Iflex.

 Total Experience     –  26  Years 06 Months

 Annual CTC              – 21.41 lpa

 Education                 - BE, VJTI, Mumbai University

Author Of

https://theoraclereference.com/

 

PROJECT and WORK EXPERIENCE (in reverse chronological order)

 

Period                               :           Oct 2015 till Date

Employer                          :           TCS

Position                             :           Associate Consultant

Operating Systems            :           Linux/Unix/Windows

Software                            :           Oracle 19c/11g/10g PL/SQL, Shell and AWK scripting.

Role                                 :           Project Manager 

Responsibilities

• Project Manager for Derivatives segment for projects in CCIL, India
• Support for 11g to 19c migration, Proposed a PDB architecture for migrating the database from 11g to 19c.
• Implemented change notification for moving data from the main database to third party systems and for automatically refreshing mviews across PDBs in 19c
• Requirement gathering from the user and business analysts for various projects
• Design for various modules of the project, effort estimation, task allocation to team members,
• Development and guiding team members in development, resolving issues in system testing, UAT and in production.
• Database upgrade(10g to 11g) , table partitioning and Archiving
• Interactions with the client for database related issues
• Data Modelling/DB Design
• Involved in performance analysis and tuning activities
• Code Reviews. Guiding team members in proper coding techniques
• Helping team members in debugging and fixing bugs raised during Unit/System Testing
• Effort estimation      

Projects worked on

CCIL India –CCIL is a central counterparty to provide guaranteed clearing and settlement functions for transactions in Money, G-secs, Foreign Exchange and Derivatives Market.

Currently working as a Project Manager in Derivatives segment on and responsible for implementing Interest Rate Options ,Swaptions, IRExotics, FXExotics, Bond Forwards, Clearing Member, Stamp Duty Computation, MMFOR Benchmark, FX Options and various other features to enhance the Derivatives module.

ICICI Lombard – Database support and migration activities for ICICI Lombard, a leading general insurance, reinsurance, insurance claims management and investment management company

 

Period                         :           Dec 2009 till Sep 2015

Employer                    :           CMC

Position                       :           IT Manager

Operating Systems      :           Linux/Unix/Windows

Software                      :           11g/10g PL/SQL, Shell and AWK scripting.

Role                             :           Module Lead/Database Administrator 

Responsibilities

• Module Lead for projects worked on
• Handling database activities and administration for projects worked on
• Development and DB Lead for database support activities
• Interactions with the client for database related issues
• Data Modelling/DB Design
• Data migration from DB2 to Oracle for for insurance product owned by TATA AIG
• Involved in performance analysis and tuning activities
• Code Reviews. Guiding team members in proper coding techniques
• Helping team members in debugging and fixing bugs raised during Unit/System Testing
• Effort estimation

Projects worked on

TATA AIG

Is a leading international insurance and financial services organization. Worked at client site for 2 years for database migration and support activities.

Bloomberg –  Fixed Income
The projects involve gathering financial/securities data from various sources and storing it on the system in a central repository. Based on the nature of data in different projects, this data is formatted as per user requirements and workitems are created so that analyst can work on this data. This data is then used by business for various activities as per requirement.

Some of the project include

Mutual Fund (M13F) – Loading the M13F from (A government form) on to the system in a predetermined format. Analysts work on this loaded data, and perform a Market Value check on this data, and this verified data is then exported to a file and used for further business process activities.

Mutual Fund – This project included loading key information at fund and security level from financial documents. Analysts then do a verification/correction of this data before exporting it for various other business activities.

 

PROJECT and WORK EXPERIENCE (in reverse chronological order)

Period                          :           July 2007 till April 2009

Employer                     :           Capgemini Consulting and Outsourcing Ltd.

Position                        :           Senior Consultant.

Operating Systems       :           Linux/Unix/Windows

Software                       :           Oracle 10g/9i PL/SQL, Shell and AWK scripting.

Role                              :           Database Administration/Developer/Tech Lead

Responsibilitiies

• Data modeling using ERWin for projects worked on
• Design document preparation for various modules of the project on
• Interactions with the client for clarifications of requirements and other database related activities
• Development and guiding team members in development activities
• Data Modelling/DB Design
• Debugging and fixing bugs raised during Unit/System Testing
• Involved in performance analysis and tuning activities
• Code Reviews. Guiding team members in proper coding techniques
• Helping team members in debugging and fixing bugs raised during Unit/System Testing

Projects worked on

Netjets – Netjets is a company in the airline industry which deals in partial ownerhip of airplanes.
They have a large number of databases based in various regions in the US. An offshore team was set up to monitor database activities for these databases. The other role was of application db support where database requests for tuning queries, writing queries and procedures for updating the database for a particular event.

Role – Database Administrator/Tech Lead

Telia Sonera – It is a Swedish Telecommunications company. An offshore development and dba team was set up for development and maintenance activities. DBA activities included support to offshore development team for development activities. Support and maintenance of databases onsite by including offshore db changes to the deployment scripts. These deployment scripts were then sent to the onsite dba to sync the onsite development and testing databases with the changes made offshore.

Role – Offshore support Database Administrator

PROJECT and WORK EXPERIENCE (in reverse chronological order)

Period                               :           October 2004 till June 2007

Employer                          :           Oracle Financial Services previously I-flex Solutions Ltd.

Position                            :           Associate Consultant.

Operating Systems            :           Linux/Unix/Windows

Software                           :           Oracle 10g/9i/8i/PL/SQL, Shell and AWK scripting.

Role                                  :           Developer/Database Administration 

 

Responsibilities 

• Doing database setup and administration for projects worked on
• Studying the functional specifications and proposed a database design for the money markets trading project.
• Interactions with the client and gathering details of the existing Database Architecture and clarified issues in the existing and proposed database setup
• Prepared the erwin diagram/data dictionary for the  proposed database design.
• Prepared the necessary design documents for various modules
• Finalised the schemas/table design for the Trading/Reporting/Treasury Databases for money markets
• Created the Trading/Reporting/Treasury Databases. Created the necessary database objects - tablespaces, schemas, tables, synonyms, queues, roles with the necessary grants in each of these schemas
• Wrote the stored procedures, functions and triggers. Made use of Oracle Collections. Used Bulk Inserts and Updates for performance aspect.
• Code review of the procedures
• Debugging and fixing bugs raised during Unit/System Testing
• Implemented Oracle Advanced Queues for transferring data from Trading Database to the Reporting Database
• Involved in performance analysis and tuning for various projects
• Conducting recruitment interviews

Projects worked on

Participant Record Keeping System (PRKS) – CMP to SP conversion project – StateStreet - PRKS is an Invest ment banking module which deals with maintenance of Funds, Account Holders in these funds and the distribution of Capital Gains, Income generated by these funds. This is a migration project which required migration of the Java application code from Weblogic 7 to Weblogic 9.2, migration of database from Oracle 8i to Oracle 10g and conversion of all SQL in the application into Stored. Procedures. Using ERWin templates to generate generic code.

Role – Developer/Database Administration

Money Markets for FxAll trading platform - FXall is an electronic trading platform offering customers foreign currency trade execution, access to research, and straight through processing (STP).  FXall has a trading platform for foreign exchange trading. A similar platform was to be created for Money Markets trading.

Role – Developer/Database Administration

RKS – Report Extracts – StateStreet - These are reports of data extracted from the RKS system. The user extracts are to facilitate business users of the RKS system to pull data out of the intermediate staging database (RKS Outbound Repository) where pertinent RKS system data would be populated at a predefined interval.

Role – Developer/Database Administration 

Portfolio View System –StateStreet -  This is a project for viewing the portfolio data for a customer to analyse the health of the portfolio over a period of time. The customer can also maintain multiple portfolios in a single group and compare the portfolios on dates, currencies etc for various features of the portfolio. This was a reporting project to analyse the portfolio details of the customers.

Role – Developer/Database Administration 

Period                                  :           June 2003 – October 2004

Employer                             :           ABN AMRO Central Enterprise Services.

Position                               :           Senior Officer.

Operating Systems               :           Linux/Unix/Windows

Software                              :           Oracle 8i/7.3.4, C, PL/SQL,Shell and AWK scripting, JAVA, JSP, JAVASCRIPT

Role                                     :           Developer/Team Lead. 

Responsibilities 

• Developer and team lead involved in Customisation for Finacle.
• Communicating with the business team to gather functional requirements and preparing the High Level and Low Level Design for the same.
• Maintaining a bug tracking system of bugs/customized project/enhancements
• Analysing feasibility of the requirements with respect to the existing architecture.
• Writing queries, stored procedures/functions/triggers and performance tuning.
• Shell and AWK scripting
• Programming in C
• Conducting recruitment interviews 

Projects worked on:

Tuning of EOD jobs – Effectively fine tuned some EOD jobs to reduce the timings to acceptable levels. This was done by parallelizing the jobs, tuning the queries to use appropriate indexes and modifying the overall structure of the program. Explaining tuning methodologies to team members

Fine Tuned Debit Card Fee Charging Module, Collection Download Module for Loans

Role – Team Leader/Developer

Customisation for ABN AMRO India – Responsibilities included gathering requirements from the business team for various enhancements/customized projects. Clarifying issues in requirements. Analysing feasibility of the requirements with respect to the existing architecture. Development and providing guidance to the developers during the development stage.  Development of some of the modules. Fixing bugs in various customized modules.

Some of the customized modules include

Enhancements to DSA Incentive logic to give Incentives for Credit Card and Insurance sales along with Saving and Current Account sales. Amortisation of fees collected from the Customer for a Loan granted, development of various reports required by the bank.

Role -  Team Lead/Developer

Customer Telecalling Project – This is a project where the bank required a telecalling module for the call center to get feedback from the customer on services rendered and also informing him about the new features the bank offers. Gathering the requirements for the project from business team, preparing the design document, designing the database table architecture, guiding a team of developers, developing some of the modules.

Role -  Team Lead/Developer 

Period                                      :           February 1999 – July 2002

Employer                                  :           Infosys Technologies Ltd.

Position                                    :           Software Engineer

Operating Systems                    :           Linux/Unix/Windows

Software                                   :           Oracle 8i/7.3.4, C, PL/SQL, shell, AWK and Python scripting.

Role                                         :           Developer

Responsibilities 

  Ø  Involved in design and development of various projects for Finacle like Certificates of Deposits, Database Consistency Checks, Menu Option Automation Process
Ø  Finacle Maintenance and support Team involved in solving bugs in the code
Ø  On Site at ICICI bank for Customised Project development and support activities.
Ø  Involved in system study, design and development.
Ø  Programming in  C, PL/SQL, sql tuning,  scripting, preparing reports.
Ø  Unit Testing, Module Testing and Baseline Integration of code

On Site Customisation : On site at ICICI bank, Mumbai for customized projects and support activities. Was involved in the discussions to get the requirements from the customer and design and develop a module for linking the customer account to a Mutual Fund Account to enable sweeps and reverse sweeps to and from the Mutual Fund Account.

Automated the menu Options for

• Mass DD Issue
• generation of Interest Rates for different time and amount slabs
• account opening
• Developed a module for auditing of Customised Projects which involved
• developing a code generator in PYTHON to automatically generate the functions for audit  
  maintenance
• providing a menu option for the user to Inquire on all Audit related data.

Support activities included resolving issued raised by the customer, providing on site fixes, providing temporary solutions/workarounds to urgent issues, escalating the matter to Infosys for baseline fixes to code.

Role – Developer

Finacle Maintenance Team: Was part of the FINACLE maintenance team responsible for analyzing and solving bugs in code raised by the testing team and by the customer.

Role –Developer

Database Consistency Checks : Considering the large number of tables in FINACLE, the volumes of data they handle, the interdependence of data between tables  and the complexity of the software there is a great risk of data becoming inconsistent either due to bugs in the code or due to database updates made on site. A batch program was developed which would run checks on data in related tables and generate a report of all inconsistent records.

Role – Developer

Certificates of Deposit: It is a type of Term Deposit. Was part of the development team for this project and was responsible for 
•  upload program for validating and uploading data from a flat file
•  generating the Certificates and spooling them to the printer.

Role – Developer

Non IT Related Experience

Period                                      :           August 1997 – January 1999

Employer                                  :           Tata Consulting Engineers.

Position                                    :           Assistant Engineer.

Operating Systems                    :           MSDOS, Windows

Software                                   :           Autocad, Microsoft Excel, Word

Role                                         :           Designer

 

   Ø  involved in central Air Conditioning System Design and System selection,
Ø  cooling load estimation,
Ø  duct routing and sizing for various areas,
Ø  specifications for chillers, FCUs and fan selection.
Ø  Preparing the air conditioning Piping Flow Diagrams

Projects –

Air Conditioning for Grand Maratha, ITC Hotel Project, Sahara

Air Conditioning System Design and System selection, cooling load estimation, duct routing and sizing for various areas, specifications for chillers, FCUs and fan selection, Preparing the air conditioning Piping Flow Diagrams .

Role – Assistant Engineer

 Air Conditioning for Owens Corning, Taloja

Air Conditioning System Design and System selection, cooling load estimation, duct routing and sizing for various areas, specifications for chillers, FCUs and fan selection, Preparing the air conditioning Piping Flow Diagrams  for Owens Corning India

Role – Trainee Engineer

KEY PERSONAL STRENGTHS:

Good Problem Solving Approach

Good at Logical and Analytical Reasoning

Good team skills

Effective Interpersonal Communication Skills

PERSONAL DETAILS:

Date Of Birth                             :   20^th August 1975.

Age                                             :   50.

Nationality                                 :   Indian

Marital Status                              :   Married

Religion                                       :   Christian

Language’s Known                    :   English, Hindi, Marathi, Konkani

 

WINNITH REBELLO

For surely I know the plans I have for you, say the LORD.

Plans for your welfare and not for harm.

Plans to give you a future with hope.

Jeremiah 29:11