Engineer Software

Pinusmita Behera

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

Contact No: +1-812*******

PROFESSIONALSUMMARY

* Over 4 years of experience as software Developer in the field of database programming with strong knowledge of SQL and PL/SQL.

* Excellent SQL, PL/SQL Developer skills including Database Queries, Triggers, Cursors, Stored Procedures, Functions, Packages in PL/SQL creating databases, generating web reports through mod_plsql.

*Have been involved in analysis, coding and modifications to generate oracle web server based reports using mod_plsql.

* Involved in development, enhancement and maintenance of various applications.

* Strong Communication & Management skills besides being an excellent team player.

* Adaptive in learning new technologies and diversified work environment.

* Have theoretical knowledge in Python.

CURRENT EMPLOYER

Company Name: Accenture

Designation : Application Development Analyst

Duration : August 2018 till date

PREVIOUS EMPLOYERS

Company Name: HCL Technologies Ltd.

Designation : Senior Software Engineer

Duration : September 2013 till February 2016

Company Name: Altisource Business Solutions Pvt Ltd. Designation: Associate Software Engineer

Duration: December 2011 to September 2013

TECHNICAL SKILL

Operating Systems: Windows,UNIX

Languages: SQL, PL/SQL, mod_plsql, Python( Theoretical knowledge) Database: Oracle 10g/11g

Tools: Toad, Control M, Alteryx

WORK and PROJECT SUMMARY

Project #1: CW1037668 CFT GDCE Support

Duration: June 2019- Dec 2019

Skills: SQL/PLSQL, Test execution and Management, Data audit and profiling Role: Tester

Team Size: 20

Roles and Responsibilities:

* Provide expertise in the planning, constructing and execution of test scripts.

* Apply business and functional knowledge including testing standards, guidelines, and testing methodology to meet the teams overall test objectives.

* Ensure all testing results are easily accessible and understandable.

* Track defects to closer and let defect repository up-to-date. Project #2: ARW R2

Duration: Oct 2018- Dec 2018

Skills: PL/SQL

Role: Application Developer

Team Size: 20

Roles and Responsibilities:

*Design, build and configure applications to meet business process and application requirements. Project #3: DSS (Domestic Security Services)

Duration : Sept 2013 –Feb 2016

Environment : Oracle 10G, PL/SQL

Tools : Control-M

Role : Development and Maintenance

Team Size : 12

db-Smart-DSS is based on own data warehouse and provides corresponding business domain with reporting,data analysis and MIS tools and OLAP cubes for daily business operations monitoring,reporting and analysis, db-Smart-DSS is a Domestic Security Services application, which runs & completes first among all other dbsmart applications Domestic Security Services(DSS) runs a MIS for the purpose of transparency about product performance.DSS is a data warehouse and an MIS tool. This application provides data to the Business users and to the downstream applications, db Smart as the standard tool for reporting, analysis and MIS in the db trader area will be used thereby as platform for data analysis and collector for data aggregation from dbTraderEE2source system. Roles and Responsibilities:

* Understanding of existing system model and client requirements.

* Communicate and discuss with client and support team in order to research and resolve the issues.

* Investigate for possible reasons of errors by studying backend code, and scripting as needed to resolve issues.

* Created views, Mviews, functions, stored procedures, triggers, packages by using PL/SQL to efficiently incorporate business rules

* Sub queries and Joins were extensively used in stored procedures

* Updating Stored Procedures, Functions and Packages.

* Created indexes on some columns of tables to increase the application's performance.

* Have worked on Replication of database.

*Generating feed files and reports on feeds and sending them through mail.

* Involved in Preparation of test cases.

* Preparation of Technical Specification document.

* Reviewed various programs, coded by team members.

* Done Unit Testing, Analyzing Bugs and Bug Fixation of existing codes.

* Scheduling and developing the business validation constraints.

* Customized existing Unix scripts for report generation and job scheduling.

* Used Control M tool for Job creation and scheduling for replication and report generation.

*Analyzed and modified mod_plsql codes for oracle web server based reports Project #4: Order and Bonus point System for Credit Card Management System Duration: April 2013 - September 2013

Environment: Oracle 10G, PL/SQL

Role: Development and Maintenance

Team Size: 11

OBPS is an Order and Bonus point System. It is used to create an order tracking system that allows credit card holders to order merchandize through mail orders. The system will be capable of processing order request, send order to merchant, follow up on orders, bill customer and pay merchant. Purchases/Bonus redemption made by the credit card holder by using the proposed mail order system will be in the scope of this requirement. The mail order system would include Order management, Bonus Points redemption through FAX/MAIL, reporting order status, creation of the merchants and merchandize in the system. The Bonus System will calculate bonus points of customers, record redemption requests by customers, dispatch redemption requests to the merchants and will track the status of redemption request

Roles and Responsibilities:

* Understanding of Existing system model and Client requirements.

* Understanding the process and interacting with functional team to resolve the issues in given objects.

* Created tables, views, indexes, sequences and developed procedures, functions, stored procedures. Creation of PL/SQL package and number of database objects for building distribution table and enforcing all validation rules.

* Involved in Preparation of test cases.

* Preparation of Technical Specification document.

* Investigate for possible reasons of errors by studying backend code, and scripting as needed to resolve issues.

* Sub queries and Joins were extensively used in stored procedures

* Updating Stored Procedures, Functions and Packages.

* Done Unit Testing, Analyzing Bugs and Bug Fixation of existing codes.

* Scheduling and developing the business validation constraints.

* Customized existing Unix scripts and writing database codes for report generation and job scheduling

Project #5: I-Loan System

Duration: December 2011 - Apr 2013

Environment: Oracle 10G, PL/SQL

Role: Developing and Maintenance

Team Size: 9

The objective of this project is to offers various kind of loan to its esteemed customers. I-Loan System includes a wide range of modules which deal with nearly all stages of the Loan life cycle. It is a Web-based Transaction Processing and Front-End Loan Application System providing a one-glance view of all customer details for Customer Service and Application Processing. It's a thin client application designed for an internet WAN having User-friendly screen navigation with online data-entry and loan-view capability. It helps the users to find out the eligible existing customers for cross sell to another loan. Telecallers will follow-up these customers and updates the feedback using sell notepad.

Roles and Responsibilities:

* Understanding of Existing system model and Client requirements.

* Understanding the process and interacting with functional team to resolve the issues in given objects.

* Created tables, views, indexes, sequences and developed procedures, functions, stored procedures.

* Writing SQL queries for Report generation

* Involved in Preparation of test cases.

* Preparation of Technical Specification document.

EDUCATIONAL QUALIFICATION

* Master in Computer Application (2010), BijuPatnaik University of Technology, Odisha

* Bachelor of Computer Science (2007), Utkal University, Odisha

* Intermediate in Science (2004), Orissa University of Agriculture and Technology, Odisha

*10

th

(2002), Odisha Board of Secondary Education, Odisha

Contact this candidate