SIVANANDA MOHAPATRA

Mobile: +918********* E-mail:actit2@r.postjobfree.com

Seeking assignments in Software Development with a growth oriented Organization

AN OVERVIEW:

Technically sophisticated professional with 4.7 years of experience in the area of software developing & programming in Oracle (Sql/Plsql) environment.

Experience in Implementation, Development, Testing, and Production support of Client Server applications and Banking applications.

Currently associated with BFSI consulting pvt. Ltd. as Associate Consultant.

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive Constructive skill in developing Stored Procedure, user defined functions, packages, application of cursors and runtime handling of error using exception.

Designed and created the Functional Design Documents for Finance Logic.

Working experience in banking domains.

Expertise in Client-Server application development using Oracle 11g/10g, PL/SQL, SQL *PLUS, SQL Developer and PL/SQL Developer.

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views and Query Re-Write.

Good knowledge on logical and physical Data Modeling using Normalizing Techniques.

Created Tables, Views, Constraints, Index (B Tree, Bitmap, Global and Local).

Developed database objects like Stored Procedures, Functions, Packages and Triggers.

Developed materialized views for data replication in distributed environments.

Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

Experience in Oracle supplied Packages, Dynamic SQL, Object type, Records and PL/SQL Tables.

Loaded Data into Oracle Tables using SQL Loader.

Worked extensively on Ref Cursor, External Tables and Collections.

Expertise in Dynamic SQL and Exception handling, Sub-queries and Hierarchical queries.

Effectively made use of View, Materialized view, Merge statement, Synonym, Sequence and Index.

Experience in SQL performance tuning using Cost-Based Optimization (CBO).

Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.

Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, TKPROF, AUTOTRACE and HINTS.

Experience in Analysis and Reporting including hands on experience with the Reporting tools such as Oracle Business intelligence Publisher (BIP) & Oracle Business Intelligent Enterprise Edition (OBIEE).

Developing the code according to the client’s requirement and provided back-end support to applications.

Involved in enhancement and maintenance of various applications developed in technologies like Oracle 10G/11G.

Work under general supervision with latitude for independent judgment.

TECHNICAL SKILLS:

Databases: Oracle 10g/11g (SQL, PL/SQL).

Tools: PL/SQL Developer, Toad, SQL Developer and SVN.

Reporting Tools: Business intelligence Publisher, Oracle Business Intelligent Enterprise Edition.

Operating Systems: Windows NT/98/2000/2008 & Windows XP.

Languages/Utilities: SQL, PL/SQL, JAVA SCRIPT, XML, XSL and HTML.

PROFESSIONAL EXPERIENCE:

BFSI Consulting Pvt. Ltd (Associate Consultant)

Aug 2011-Till Date

Onsite Assignments 1: (July 2015- Till Date)

Client : Land Bank, Philippines.

Project Title : FLEXCUBE Direct Banking 12.0.3 Implementation.

Team Size : 4

Duration : July 2015 till date.

Role : FLEXCUBE Direct banking Implementer, Developer, DBA.

Environment : ORACLE, FLEXCUBE Direct Banking, Websphere Application Server

Roles & Responsibilities:

Enhancements & customization Oracle FCDB for LAND Bank.

Integration of FCDB with Land Bank Systematics core banking system (third party integration) by using java API & Database Call.

Installation of ORACLE FLEXCUBE Direct banking 12.0.3.

ORACLE 11G DB installations, FLEXCUBE schema creation, Dump import, Table space creation.

Interface requirements gathering and Product walk through for FCDB.

WebSphere application server installation, ear deployment, JDBC creation and parameterization.

Worked on site specific customization and enhancement for customer & customer account creations.

Onsite Assignments 2: (May 2015- June 2015)

Client : Fujitsu, Japan.

Project Title : FLEXCUBE Direct Banking 12.0.1 Training.

Team Size : 2

Duration : May 2015- June 2015.

Role : Conducted training in Oracle FLEXCUBE Direct banking .

Roles & Responsibilities:

Conduct classroom and web-based training for ORACLE FLEXCUBE Direct banking 12.0.1.

Conduct for ORACLE BIP.

Report development Using ORACLE BIP based upon various business requirement.

Creating documents as per company standards (Requirement, Functional &Technical Specifications).

Onsite Assignments 3: (May 2013- Feb 2015)

Client : Bank of Beirut and Arab Countries, Lebanon.

Project Title : FLEXCUBE Direct Banking 12.0.1 Implementation.

Team Size : 4

Duration : May 2013- Feb 2015.

Role : FLEXCUBE Direct banking Implementer, Developer, DBA.

Environment : ORACLE, FLEXCUBE Direct Banking, Websphere Application Server

OS : Windows 2008

Roles & Responsibilities:

Done enhancements & customization Oracle FCDB for the BBAC Bank.

Done integration of FCDB with BBAC Mysis Core banking solution(third party integration) by using java API.

Installation of ORACLE FLEXCUBE Direct banking 12.0.1.

ORACLE 11G DB installations, FLEXCUBE schema creation, Dump import, Table space creation.

Interface requirements gathering, Product walk through.

WebSphere application server installation, ear deployment, JDBC creation and parameterization.

Worked on site specific customization and enhancement for customer & customer account creations.

Implementation and supporting issues raised by user in UAT.

Debugging, analyzing issues raised by business user and bug fixing.

Report development Using ORACLE BIP based upon various business requirement.

Creating documents as per company standards (Requirement, Functional &Technical Specifications).

Implementation, Live/Post Live support, development, parameterization and testing using java, Oracle SQL, PL/SQL,Java Scripting, XSL, HTML,

Data migration and Patch set deployment.

Offshore Assignments 4: (Sep 2012- Feb 2013)

Client : GBTI Bank Guyana

Project Title : GBTI Bank Reports

Team Size : 3

Role : Design and Development of client specific Bank balance sheet reports.

Environment : ORACLE Business intelligence Enterprise Edition, SQL

The main objective of the GBTI Bank Reports is as follows

It is totally Banking Report Development project where different Reports requirements and the format sent by the client. Analyzing the Requirements of the report and writing the SQL as per requirements in PLSQL developer. Creating report using OBIEE .

Roles & Responsibilities:

Code enhancement according to the client's requirement.

Writing SQL code for reports

Responsible for solving query for clients.

Oracle Schema creation, Table space creation, dump file installation.

Basic Database maintenance like gathering Table statistics, compiling objects.

Creating report using OBIEE repository.

Developed Reports like Balance sheet, profit and loss statement, Trial balance, Loan related reports, GL based reports, and customer account based reports, Reports on ASSET and Liability.

Offshore Assignments 5: (Feb 2012- Aug 2012)

Client : VATTANAC Bank Cambodia

Project Title : VATTANAC Bank Interface

Team Size : 3

Role : Design and Development of client specific FLEXCUBE Interface

Environment : Oracle SQL, PL/SQL, MICON Tool.

Description :

The main objective of the VATTANAC Bank Interface is as follows

It is Interface Development project where different requirements sent by the client. Analyzing the Requirements and writing the code.

Roles & Responsibilities:

Code enhancement according to the client's requirement.

Writing SQL, PL/SQL code for interface.

FLEXCUBE front end screen designing using RADTOOL (MICON) tool.

Creating documents as per company standards (Technical Specifications).

Create new screen and Modified existing FCUBS frontend screen using RADTOOL (MICON), FLEXCUBE database Package modification for VATTANAC Bank Dual currency interface.

Added new fields in existing screen using MICON, SQL, PL/SQL and java script level.

Required changes for new passbook according to bank requirement.

Offshore Assignments 6: (Aug 2011- Jan 2012)

Client : Chase bank Kenya

Project Title : Chase Reports

Team Size : 5

Role : Design and Development of client specific reports.

Environment : Business intelligence publisher, SQL

Description :

The main objective of the Chase Reports is as follows

It is totally Banking Report Development project where different Reports requirements and the format sent by the client. Analyzing the Requirements of the report and writing the SQL as per requirements in PLSQL developer. Putting the SQL in BIP and formatting the report in XL, PDF etc.

Roles & Responsibilities:

Code enhancement according to the client's requirement.

Writing SQL code for reports

Responsible for solving query for clients.

Oracle Schema creation, Table space creation, dump file installation.

Basic Database maintenance like gathering Table statistics, compiling objects

Developing store procedure to meet specific requirements.

Developed Reports like Balance sheet, profit and loss statement, Trial balance, Loan related reports, GL based reports, and customer account based reports, Reports on ASSET and Liability.

Creating documents as per company standards (Technical Specifications).

Developing Stored Packages, Procedures, Functions for the application using new features like pipeline functions, lobs, ref cursors etc.

EDUCATIONAL QUALIFICATION:

Course

Institute

University

Specialization

Year of Passing

Percentage

B.Tech

DRIEMS

BPUT

Electronics & Telecommunication Engineering

2010

72%

PERSONAL DETAILS:

Date of Birth : 23/12/1987

Sex : Male

Marital Status : Single

Language Known : English, Hindi, Oriya.

Sports : Cricket, Football.

Interest : Listening to Hindi songs, watching movies.

DECLARATION:

I hereby declare that all the above stated information is true and correct to the best of my knowledge and belief.

Sivananda Mohapatra

Contact this candidate