Nilanchal Behera

Cell phone: 916-***-****

Email: ac7r5r@r.postjobfree.com

Objective:

To work in the most challenging position with an organization that provides ample opportunities to learn and to contribute.

Certification:

1Z0-051 Oracle Database 11g: SQL Fundamentals

Registration: 258298029

94% aggregate from Oracle.

Done RHCE certification course from Indian Institution of Hardware Technologies (IIHT).

Educational Qualification:

MCA from ICFAI School of IT - Hyderabad (2011)

BCOM from University of Calcutta - Kolkata (2008)

10+2 from ISC (Delhi Board) - Kolkata (2005)

10TH from ICSE (Delhi Board) - Kolkata (2003)

Profile Snapshot:

Having 5.6 years of IT Experience working in Oracle PLSQL.

As of now working as a Sr. Software Engineer for System Analysis, Designing, Testing Development & Support of Oracle 10g & 11g in Production, Development environments..

Experience in financial, Banking and telecom domain.

Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.

In-depth knowledge of database performance tuning, including complex query optimization.

Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.

Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan.

Strong knowledge in Oracle utilities like SQL*Loader.

Extensive experience with all phases of the Software Development Life Cycle including analysis, Resource Planning, code development, testing, implementing and maintenance.

Strong interpersonal and communication skills in dealing with customers.

Work experience:

Worked as Sr. Software Engineer in IBM(JK Technosoft) Bangalore from Nov 2016 to June 2017.

Worked as Sr. Software Engineer in Wipro Infotech(O2F Solutions Pvt Ltd) Kolkata from June 2016 to Nov 2016.

Worked as Software Engineer in Wipro Infotech(Skyonn Technologies Pvt Ltd) Kolkata from Nov 2015 to May 2016.

Worked as Software Engineer in Omegacube Techsystems Pvt Ltd, Bangalore from March 2014 to Sept 2014.

Worked as PL/SQL Developer in Convergent IT Solution Pvt Ltd, Kolkata from Oct 2010 – Feb 2014.

Technical Skills:

Databases : Oracle10g/9i and 11g.

OS : Unix, Windows 7, XP.

Tools : Pl/sql Developer, Toad, Sql Developer.

Languages : PL/SQL, SQL, Shell Scripts.

Developer Tools : REPX Reports, List Reports, XML Publisher, BI Publisher.

Professional experience:

Project 1:

Project: LIMS(Century Link Project)

Client: IBM

Tools Used: Oracle SQL Developer.

Team Size: 10

The project is based on providing telecom service to the customers through LIMS Application. The main aim of the project is to develop and deliver a good quality telecom service for customer's benefit, and through which they can operate and track their customer service.

Roles:

Analyzed data to check for Data Integrity and Referential Integrity when loaded to source-staging tables.

Created tables to capture errors and data that failed Validation Checks.

Re-validated corrected data from source and re-processed to get them loaded to the oracle target.

Re-worked on the BAD Files that were generated by SQL Loader.

Designed and Created Database objects and Written PL/SQL PROGRAMMING for data extraction.

Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.

Project 2:

Client Name: Vodafone, Pune

Tools Used: Toad, Oracle M6(TBS).

Team Size: 15

The project is based on providing telecom service to the customers. The main aim of the project is to develop and deliver a good quality telecom service for customer's benefit, and through which they can operate and track their customer service.

The project focusses on 2 main parts:

1. Order management (via OSM tool)

2. Inventory management (Metasolv M6).

The activities involved are namely:

1. Development of new CR.

2. Debugging.

3. User support.

Roles:

Developing packages, procedures, functions, and triggers for the application.

Design, Testing and implementation of Equipment / Connectivity/ Circuits-Endpoints reconciliation tool for Metasolv.

Modeling of Equipment Specifications of Multi vendor SDH/WDM equipments.

Modeling and Implementation of Network Templates and Methodologies for technologies such as MPLS, DWDM, Ethernet over SDH (EoSDH), ISP.

Performing a complete analysis of the circuits found in the dump for loading in Metasolv.

Network and Inventory reconciliation of Metasolv database with NMS data via Oracle PL/SQL scripts.

Writing PL/SQL code using the technical and functional specifications.

Creating Oracle objects like tables, types, packages, procedures and functions.

Developed the SQL*Loader scripts to load data into the staging tables from the flat files.

Writing PL/SQL code using the technical and functional specifications.

Performing the tests on the newly coded procedures and documenting the same.

Writing technical documents using the functional specifications.

Project 3:

Client Name: Grameen Phone, Bangladesh

Tools Used: Toad, Oracle M6.

Team Size: 5

The project is based on providing telecom service to the customers. The main aim of the project is to develop and deliver a good quality telecom service for customer's benefit, and through which they can operate and track their customer service.

The project focusses on 2 main parts:

1. Order management (via BPM tool)

2. Inventory management (Metasolv M6).

The activities involved are namely:

1. Development of new CR.

2. Debugging.

3. User support.

Roles:

Developing packages, procedures, functions, and triggers for the application.

Design, Testing and implementation of Equipment / Connectivity/ Circuits-Endpoints reconciliation tool for Metasolv.

Modeling of Equipment Specifications of Multi vendor SDH/WDM equipments.

Modeling and Implementation of Network Templates and Methodologies for technologies such as MPLS, DWDM, Ethernet over SDH (EoSDH), ISP.

Performing a complete analysis of the circuits found in the dump for loading in Metasolv.

Network and Inventory reconciliation of Metasolv database with NMS data via Oracle PL/SQL scripts.

Writing PL/SQL code using the technical and functional specifications.

Creating Oracle objects like tables, types, packages, procedures and functions.

Developed the SQL*Loader scripts to load data into the staging tables from the flat files.

Writing PL/SQL code using the technical and functional specifications.

Performing the tests on the newly coded procedures and documenting the same.

Writing technical documents using the functional specifications.

Project 4:

Client Name: Valley Custom Woodworks Inc, Chicago

Tools Used: SQL Developer, Omegacube Tools( Edgedev), EUD Designer.

Team Size: 5

Valley Custom Woodwork, Inc. is a Custom Casework manufacturer specializing in the production of high-pressure plastic laminate and hardwood veneer Institutional Cabinetry, Countertops, and related Casegood Products. We also manufacture office furniture, computer workstations, nurse’s stations & reception desks, message centers, window sills, toilet partitions, closet systems and melamine shelving as well as distribute a line of cultured marble, hardware and related items to compliment our product lines.

Roles:

Expertise in designing, implementing, customizing Oracle Applications modules (PO, AP, INV,

BOM, OM, GL, AR). Creating Reports called XML Publisher, REPX, List Report, CS Reports on End User Designer and Power ERP.

Developing PL/SQL programs for data manipulation.

Creating and managing stored procedures and triggers, database optimization, determining common performance problems, monitoring and efficient in handling front-ends activities.

Project 5:

Project: BANC724

Client Name: Bank of Maharastra, Kolkata

Tools Used: Toad, Convergent Tools

Team Size: 5

BANC724 is a Banking Domain project implemented in various banking sectors.This project has various modules like, cash receipt, cash payment, transfer module, where 1st. have to debit & then credit the same amount for a tallying scroll. Various deposit scheme modules like MMDC, MIQR, QIDR, RDS and CMDS.

Cancellation module helps for cancelling the scrolls, if any mistake done at the time of posting by bankers.

It helps customers by providing all type of account balance statements.

Also helps bankers by providing daily statement of cash receipt, payment, transfer, bank balance house keeping & on tally reports.

GLB & accounts balance tallying report, also difference report.

Helpful patches are available to update the amount difference between GLB & account balance.

It has also facility for day open, re-open & close, accordingly to calendar date wise.

So, BANC724 is a banking product developed on advanced technology with rigorous testing procedures that ensures stability, reliability and scalability.

Roles :

Involved in the whole life cycle of the project.

Interacted with clients to understand their requirements.

Involved in screen design using convergent Tools.

Involved in Table Design.

Involved in creating Views, Sequence, Synonyms and Indexes.

Programmed Packages, Procedures, Queries, and Triggers on Oracle 10g.

Giving the Production Support to the client.

Project 6:

Project: Shop2Host

Tools Used: Toad, Convergent Tools

Team Size: 5

Shop2host provides services like SEO, Unlimited Space Unlimited Emails, ASP.Net

3.5/4.0 Framework, Instant Setup, Webmail Service, FTP Account Creation, Free Domain in/co.in).

Domain Theft Protection, FTP Account Management This website is continuously changing due to competitive prices and plans. CMS is also integrated with the system. As registered users can buy the products directly from their site itself integration of online money transaction is also handled.

People took hosting solution from shop2host can login to the system.

Roles:

Analyzed data to check for Data Integrity and Referential Integrity when loaded to source-staging tables.

Created tables to capture errors and data that failed Validation Checks.

Re-validated corrected data from source and re-processed to get them loaded to the oracle target.

Re-worked on the BAD Files that were generated by SQL Loader.

Designed and Created Database objects and Written PL/SQL PROGRAMMING for data extraction.

Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.

Personal details:

Date of Birth : 04th Sept 1984.

Marital Status : Married.

Languages Known : English, Hindi, and Bengali.

Passport No : J7612872.

Current Address : No 3, Govind Swami Street, Dr M.G.R Street, Sholinganallur, Chennai-600119.

Contact this candidate