Data Maintenance

Debasis

Phone: 248-***-****

**********************@*****.***

Experience Summary

Over 9 years of experience in the Analysis, Design, Development, Testing and Documentation of Database applications with strong experience in various phases of Software Development Life Cycle (SDLC).

Expertise includes Oracle PL/SQL, SQL*Plus, Stored Procedures, Integrity Constraints, Trigger, Cursors, Exception handling, Functions, Views, Packages, REF Cursors and Collections.

Proficient in Unix and Linux environment and scripting.

Experience in Business requirement Analysis, Application design, Data modeling, and Data migration.

Extensive PL/SQL code Analysis, coding, performance tuning& modifications

Performed Application and SQL statement tuning using Explain Plan, Trace generation, Optimizer Hints and Partitioning etc.

ETL extraction batch development and support.

Experience on security related Implementation, OracleVirtual Private Database using Fine Grained Access Control.

Good knowledge on Data Modeling concept and Oracle internals.

Actively involved in System Integration testing, user acceptance testing, and migration ofdevelopment application to production.

Good exposure onOnsite-Offshore working model.

Involved in Database design, Modeling, Development, Performance Tuning, Query optimization,Report Generation. Developed Stored Procedures and Functions

Education

2005, B.Tech from Kalinga Institute of Industrial Technology, India

Technical Skills

RDBMS: Oracle 9i/10g/11g

Application Tools: SQL Developer, Toad, MS Visio, IBM Rational Clear Case, Kenan FX, Kenan Arbor (11.7), Autosys Job Scheduler, Oracle BI,SQL Loader, Microsoft Visual studio, Team foundation server, Ranger 5.4,HP Quality Center, JIRA,ERwin

Operating Systems: Windows NT/9X/ 2000/2003/2008 Servers, Windows XP, Windows 7, UNIX, SUN Solaris 5.8, Red Hat Linux

Scripting Languages: Shell Scripting in UNIX, Pro*C

Professional Experience

Lincoln Financial Group, Philadelphia Feb 2015 – Till Date

Sr. Oracle Developer

Maintain Lincoln Fixed Assets database schemas, batch process trouble-shooting for incoming files relating to Asset classification from multiple vendors. Involve in planning andmoving the inline queries from the application to database side for better performance and query tuning when necessary. Requirement analysis and development for the database catering to Lincoln Advisors’ used application to make informed decisions.

Responsibilities:

Feed file processing and bulk Loading from source system

Ref Cursors, Nested tables usage for better performance.

Business Logic implementation at Database level to reduce performance impact on UI service level.

PL/SQL code Analysis, coding, tuning, modifications, and new developments based on requirement

Legacy code maintenance, Package, Cursors,Schema design, Unix shell scripting,

Promoting code from lower environment to higher environment through QA testing and putting fix in a timely manner to adhere SLA.

Developed PLSQL procedures, functions required for ETL.

Reviewed code and validated unit test results.

Worked on fixing defects identified in UAT and Production environments.

Environment: Oracle 10g/11g Database, Windows NT/XP, UNIX Sun Solaris, Linux

Merrill Lynch-Bank of America,Pennington Sep 2013 – Jan 2015

Oracle Developer

Develop and transform new requirement to LLD, maintenance of existing object and enhancement request to cater the Retirement investment module. Award Choice platform supports the UI for the Web Admin, Plan sponsors, Participant and Financial Advisors managing the investment portfolio in Capital market. Extensive backend development to maintain Vesting schedule, Lapse Event, Dividend calculation, Stock option plan maintenance, Settlement of equity traded transaction.

Responsibilities:

Feed file processing and bulk Loading from source system

Ref Cursors, Nested tables, GT table,Type objects usage for better performance.

Understand the client requirement and prepare a design document, prepare LLD and brainstorm the complex scenarios.

Business Logic implementation at Database level to reduce performance impact on UI service level.

Release management using MS Team Foundation Server.

TKPROF, AWR, Explain plan use for code optimization and performance tuning.

PL/SQL code Analysis, coding, tuning, modifications, and new developments based on requirement

Package, Cursors,Views maintenance, Unix shell scripting,

Tracking Bug calls post Release fallouts and take up the QCs tracked through HP quality center for remediation.

Project planning, code reviews for the upcoming release and risk mitigation planning.

Environment: Oracle 10g/11g Database, Windows NT/XP, UNIX Sun Solaris, Linux

Bank of America, Pennington May 2012 – Aug 2013

Production Support

Design and develop solutions to complex application problems, system administration issues, or network concerns. Data warehousing is a foundational practice that supports enterprise reporting, business intelligence and decision support. It typically involves extracting and transforming data from operational or transactional databases and loading it to a repository for shared use, reporting and analysis.

Responsibilities:

Source all data from various source systems into the target database.

Identify the systems for consumption and map/model the required data into the warehouse.

Understand the client requirement and prepare a design document, prepare LLD and brainstorm the complex scenarios.

BI Report generation related SQL preparation.

Utilized TOAD 9.1, Oracle SQLPLUS for creating objects, modifications, import/export, trouble-shooting and resolving issues.

Utilized SQLLOADER for data loading – importing tables’ data in Oracle environment.

Utilized Microsoft Visual Team Foundation Server for checking-in/checking-out objects for both new developments and existing ones for movement into higher environments.

Using Packages, Procedures, Functions, Cursors, Jobs and Scheduler to develop the system.

Utilized the Autosys Job Schedulers and cronjobs to schedule various jobs.

Handled PL/SQL code Analysis, coding, performance tuning, modifications, and new developments based on requirement.

Report development and enhancement using Unix Shell scripting(awk,sed etc.)

Have hands on experience on perl and awk programming.

Handled retrieval and loading of data into downstream system on customer requirements via import/export/ftp mechanism.

Application enhancements, change control, Applications Migration, configurations.

Scheduled the Report script for taking the Backup of Full Data and Outline and related files etc.

Running Daily, Monitoring, Weekly, Monthly Data Processing RDR Loads in Production.

Environment: Oracle 11g Database, Windows NT/XP, UNIX Sun Solaris, VMware servers

British SKY Broadcasting, Edinburgh,Scotland Oct 2010 – Apr 2012

Oracle Developer

British Sky Broadcasting is one of leading company which provides DTH, Broadband and Telephony Services to Residential customers in United Kingdom with 10.5 million customer base with different products offered to its customer.This project involves the major changes across the IT systems CRM – Chordiant. Billing – Kenan FX 2.0 and Online Platform.

Responsibilities:

Preparing test plans for the new Releases and carrying Impact analysis on downstream systems for the APIs.

Responsible to design, code, document and test PL/SQL,Unix Shell scripts for test data generation for performance testing.

Involved in unix batch job scheduling using crontab.

Involved in code debugging for perl,awk scripts.

Worked on Oracle PL/SQL code modifications/enhancements to resolve issues.

Utilized HP Quality Centre to track defects and taking that to smooth resolution.

Working with BAU for the sign off for the Release.

Providing Billing expertise in the area involved.

Pl/SQL code tuning performing using explains plan and TKPROF utility.

Design, management, configuration and execution of tests on APIs in Quality Centre.

Ensured the integrity of the APIs used by the various billing components by validating MQ messages and verifying the source XML of the incoming and outgoing messages.

Liaison with the BAU team to identify and ensure prompt resolution of defect through subjected CR or BUG fix.

Utilized XMLSpy for XML data analysis.

Environment:UNIX, EAP Tool, Oracle 9i, HP Quality Centre

Tata Teleservices Limited, India Jan 2009 – Aug 2010

OSS/BSS Billing (Telecom)

Oracle Module Lead

In OSS Billing module, Kenan Arbor is a highly configurable billing and customer care system that can perform a variety of tasks. It is built around a Relational Management System that contains all customers and product information, as well as system configuration information.

This project involves Production support and development and implementation of the new functionality for the following systems:

Billing application (Kenan Arbor BP)

This project aims at timely billing and providing optimal solutions for change requests raised by the end user and implementing the various CR’s (Change Requests) raised by the Client to enhance or modify the existing functionalities/ business processes.

Responsibilities:

Preparing test plans for the new requirements

Configuring and testing various cross product discounts.

Testing the configurations by account creation and bill processing.

Lead the module of BIF(Bill invoice formatting)

Maintaining/developing the BIF code written in Pro*c and involved in performance improvement of this process.

Major performance improvement and code enhancement done for BIF module where the time for completion of Bill run was reduce from 72 hours to 34 hours .

Pro*c code is used to carry out the bill raw formatting which is in turn fed into a vendor application for user friendly bill generation

Maintaining the oracle objects and developing packages, cursors, external tables, views as per business need.

Analyzed data on a regular basis.

Created, updated, tuned and modified Oracle Procedures, Functions, Packages, Tables, and View for better performance.

Project scopes, test plans, executed the test plans, and assisted in projects implementation.

Various impact analysis and feasibility study of the change requests raised by client.

Debugging Unix Shells scripting, pl/sql codes for troubleshooting.

Worked on Account creation process from Kenan front end.

Worked on MPS (Message Processing System) and BIP.

Provide support for billing issues in production environment during scheduled bill runs and clearance of MIU cases.

Environment: SUN Solaris 5.8, Oracle 9i, Windows 2000 for servers/clients. Kenan Arbor (11.7) (Telecom Billing Product)

Nortel NetworksToronto, Canada Oct 2008 – Dec 2008

(Telecom)

Developer

Standardizing information systems have become a major activity for many major companies in recent times. They are converting all information systems from legacy to standard ones, mainly for the ease of development & maintenance and thereby the cost factors also. Nortel Networks having wide range Information System applications is very aggressive in standardizing all legacy applications, which are critical to their business. Nortel Networks has bundled set of applications and has given TCS the maintenance contracts for these applications. The project needs skills ranging from Mainframe, J2EE, and C to databases like MS-SQL Server, DB2 & Oracle. TCS is going to facilitate this for Nortel using various tools. TCS has been requested to provide the following services: Application Development & Maintenance Support for SAP, WEB and Legacy applications. Interact with Nortel and Business users on day-to-day activities and develop a detailed understanding of issues of the operation to meet business requirements.

Responsibilities:

Business Requirements Analysis, Functional Analysis, Discussion and sign off from stakeholders for Business Critical Applications in Nortel.

Technical Ownership, Development, Sustainment and Maintenance activities of Nortel Deployment and Environment.

Resolve Issues, train end users on the applications and provide production support for Nortel Applications.

Suggest Process improvements within existing applications for scalability, reliability and performance and provide proof of concepts for the same.

Assist QA Leads in planning/developing a test plan which includes regression testing

Environment:Oracle 10g

Tata Teleservices Limited, India Aug 2006 -Sept 2008

Fraud Management System (Telecom)

Production Support Executive

Fraud Management System is the Total Telecom Fraud Management Solution. It addressed different types of telecom fraud by using advanced technologies and by employing a variety of closely integrated modules. It helps in revenue maximization to the network operator by timely detection of both internal and external fraudsters. It proficiently handles all the operations from the time an individual applies to become a subscriber until the individual ceases to be a subscriber of the network. Application has interfaces with TIBCO, Kenan-FX (Comverse) and Mediation (AMD from Comptel) for Customer Data, billing data & Call Records respectively and IN (intelligent Network, from Alcatel and Telcordia).

Help the client manage the Frauds in the telecom network. Activities include maintenance of Fraud Management System Server and Software and related issues to provide back-end support for the team at the client site. Also help the team manage the activities of Fraud management and related issues to provide back-end support for the team at the client site. Been involved in end to end testing on releases made to ensure proper functioning of the application.

Responsibilities:

Automation of various scripts.

Applied performance-engineering techniques to increase the throughput of procedures, packages and database objects.

Procedures, Views, Triggers, Synonyms, Indexes, Functions, Packages, and Snapshots.

Utilized AWR Report, Explain plans in oracle to address the performance bottle-necks in the application

Resolved discrepancies and enabling events like Invalid Subscriber, Call Velocity and Call Collision (help in catching cloning frauds).

Responsible for creating and assigning roles and profiles to Database users

Responsible for creating Procedures, Functions, Views, Packages, Tables, Sequences, Synonyms.

Testing of the Releases given by Vendor before applying the same on production.

Data Gathering and Hardware resizing of FMS system as per business projections.

Performed Functional and data requirement analysis, and some light DBA work.

Migration of Data from the current system to new system.

Impact analysis on the upstream/downstream systems during the Migration of the system into new environment and doing the required changes in the scripts.

Involved in unit testing and provided required support to business during the UAT and soft launch phase of the project.

Coordinated with Vendor in resolving the major issues like subscriber precheck, Auto threshold etc.

Environment: SUN Solaris 5.10, Windows 2000 for servers/clients, Ranger 4.0, Nikira 5.4, Oracle 10g

ICT Solution for Andhra Pradesh Government, India Nov 2005 -July 2006

Developer

The project involves the analysis, design, development and implementation of a comprehensive Information Communication Technology (ICT) cum Decision Support System (DSS) to cater to the Nation Rural Employment Guarantee Scheme of Government of Andhra Pradesh.

The system caters to the techno-economical estimation and execution of works taken up under the scheme. The system also provides for complete financial accounting and MIS support to administrative officials. The system involves a development effort of 7 person years spread over a period of 2 calendar years. The project team consisted of 14 members.

Responsibilities

Discussion with Rural Development Dept, Government of Andhra Pradesh, India, Centre for Good Governance and scope of work.

System design and maintenance of apps server

Developed Application software and Web portal using JSP, Oracle, Java

Documentation (MS-VSS)

Trainings to officials

Environment:JSP, PL/SQL, Core Java, Windows Server 2003, Oracle DB 10g R2, MS SQL Server 2000.

Contact this candidate