Resume

Sign in

Data Software Engineer

Location:
Apex, North Carolina, United States
Posted:
March 08, 2018

Contact this candidate

MADHAVI KONDA ac4qyo@r.postjobfree.com

Ph. 919-***-****

OBJECTIVE: Looking for a challenging position in an organization where my technical skills can be utilized to contribute towards success of organization and also give me an opportunity to learn and implement new technologies to enhance career.

PROFESSIONAL SUMMARY:

Over 10 years of Software Engineering experience in Insurance, Telecom and Banking domains

Software Professional with sound technical knowledge in Oracle 9i/10g/11g,

PL/SQL, NETEZZA and UNIX SHELL/PERL SCRIPTING

Experienced with Packages, Procedures, functions, BLOBs, CLOBs, Triggers, Collections and etc.,

Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.

Experienced in all phases of Software Development Life Cycle– Project Analysis, Requirements capture, Design Documentation, Development, Testing, L3 Support and Maintenance

Involved in Oracle Exadata migration

Replicate the data using Attunity Replicate(Similar to Oracle Golden gate) to all the regional hubs

Performance monitoring using OEM tool of our databases and analyzing AWR reports.

Reference data distribution and Index/ETF adoptions.

Knowledge on RDBMS and Data warehousing concepts.

Knowledge on Oracle 12c new features.

Knowledge on Oracle DBA activities.

Worked on on-boarding IDQ for Quorum DQ checks.

Experienced with Netezza database.

Experienced on HADOOP workflows to load the data from the source into our NETEZZA staging environment.

Experienced with SQL Server and DB2 UDB

Working experience with Agile and SDLC methodologies.

Experience with diagram drawing tools such as Visio etc

Experienced Software professional with track record of success and ability to accomplish a given task with in scheduled time and continuously strived to meet and exceed customer expectations.

TECHNICAL SKILLS:

Operating Systems

UNIX/LINUX, Windows

Languages

Oracle(SQL,PL/SQL),Netezza(SQL,PL/SQL),Oracle DBA skills, Visual Basic 5.0

Databases

Oracle 9i/10g/11g,Netezza 5.0,DB2 UDB

Scripting Languages

UNIX SHELL/PERL Scripting,HTML

Development tools

SQL* PLUS, PL/SQL Developer, SQL Devloper,Toad,Attunity Replicate 5.5,IDQ,OEM 12c,Netezza workbench, IBM Netezza Admin,Autosys,Control-M 8.0,JIRA,Sybase Power designer and Erwin data modeling tools,SDPA,Putty,Tectia, iNet Soft Reporting tool and IHM

Configuration tools

Serena Dimensions, Tortoise SVN and GIT

Code inspection tools

Understand Pro* C, Clinical SAS, Visual Basic 5.0 and Core Java

EDUCATIONAL QUALIFICATION:

2005, Bachelor of Technology in Electronics and Communications Engineering, JNTU, Hyderabad, India.

2007, Master of Engineering in Embedded System Technologies, Anna University, Chennai, India.

Professional Training and Continuing Education:

Oracle 9i (1Z0-007) Technical Certification

Certification on Credit Risk Analysis and Report Writing

INS-21(Insurance Domain Certification)

Certification in Telecom V2.0(TCS Internal Certification)

PROJECT PROFILE:

Project #1 : (June 2015 to till date)

Project Name : Quorum-Instruments

Client : Deutsche Bank

Operating Systems : UNIX/LINUX, WINDOWS

Software : Oracle PL/SQL(11g), UNIX SHELL/PERL Scripting,Attunity replicate 5.5

Development Tools : PL/SQL Developer, Control-M,GIT, Tortoise SVN, OEM 12c, IDQ Designation : Sr. Oracle PL/SQL developer

Quorum Instruments takes data as an input from different providing services (iRDS, DBI, OCC, Quantum, pRDS) and then provides the data for all downstream applications to consume. Quorum-Instrument is the reference data mart for applications across GME. In addition to enabling the GME

platform to function with the best available source for reference data, Quorum also provides augmenting data

for systems to simplify the provision of reference data. Quorum is designed to distribute and

manage reference data at department level rather than application level. Quorum is the authoritative source for Index, ETP (Exchange Traded Products) and Custom Basket composition data. Quorum receives this data from the vendor Markit (now IHS-Markit) and their product SOLA. Markit is a consolidator for the Index and ETF data it receives from various providers of the data such as S&P, MSCI, NASDAQ, DBIQ etc. Once the data received from the providers is consolidated, Markit pushes this data into their distribution layer which will be picked up their DDM process hosted by Quorum using their Web Services API into their data structures hosted in Quorum database. This data will be then processed into a set of de-normalized tables which forms the Index Data marts.

Responsibilities:

Consuming, processing and distributing the data using Oracle PL/SQL(11g), UNIX SHELL/PERL scripting to various data sources.

Reviewing the requirements with Business Analysts and coordinating with all the stakeholders.

Query tuning for database consumers

Creating DQ reports and DQ checks using Oracle PL/SQL and SHELL/PERL scripting.

Extensively used Oracle AQs, Packages and other Oracle advanced concepts.

Worked on automating database scripts deployment using dbVersion.

Replicate the data to all the regional hubs using Attunity replicate5.5 software.

Reference data distribution and Involved in Index/ETF adoptions.

Upgraded the Attunity replicate software versions.

Knowledge and experience on Oracle DBA activities

Performance monitoring using OEM and analyzing AWR reports

Used Control-M 8.0 for scheduling jobs

Involved in Oracle Exadata database migration.

Worked on on-boarding IDQ for Quorum DQ checks.

Preparing Test cases and Test Results and making Unit Test Plans and involving in Integration testing.

Performance tuning, Bug fixing and L3 support on rotation basis.

Project #2 : (Sep2013 to April 2015)

Project Name : EVEREST.

Client : Bank Of America(BACI)

Operating Systems : UNIX, WINDOWS,MS-DOS

Software : Oracle, Netezza, UNIX SHELL/PERL Scripting,HTML

Development Tools : : IBM NETEZZA ADMIN,PL/SQL Developer,TECTIA,AUTOSYS

Designation : Analyst Apps1 Prog

Everest is an aggregated risk platform designed to meet GBAM credit risk management function. Everest is a comprehensive one stop solution platform, hosting aggregated commercial loan, derivative and any other needed data in additional. Everest will provide ad-hoc standard reporting tools, data analysis tools at risk virtualization portal. Everest will also have a sandbox environment that will be mirroring production environment and offering flexible data for any ad-hoc or urgent need.

Responsibilities:

Creating Technical Design documents.

Creating Estimation documents from the requirement documents

Loading the files from Hadoop cluster to Netezza db and doing business validations and checks.

Worked on HADOOP workflows to load the data from the source into our NETEZZA staging environment.

Worked on Troubleshooting various errors incurred during the HADOOP loads into NETEZZA environment.

Developed ETL processes using Oracle PL/SQL and UNIX SHELL/PERL scripts.

Worked on partitioned tables, ref cursors,MVs and collections and other Oracle advanced concepts.

Loading the files from Teradata, Oracle db to Netezza db and doing business validations

Job scheduling with Autosys, Parsing of log files and feed files using Shell Scripts

Automating the validation checks and DQ checks using SQL and Shell Scripts.

Solving User queries and providing the solutions to EVERESTHELP user queries.

Designing interface programs for calculating the credit risk

Preparing Ad hoc Queries for credit analysis.

Preparing Test cases and Test Results and making Unit Test Plans and involving in Integration testing.

Performance tuning, Bug fixing, Customer support.

Project #3 : (Feb2011 to Aug 2013)

Project Name : BMRC.

Client : BNP Paribas Bank(CGI)

Operating Systems : UNIX, WINDOWS and MS-DOS

Software : Oracle, Netezza, UNIX SHELL/PERL Scripting, HTML

Development Tools : PL/SQL Developer, IBM NETEZZA ADMIN, TECTIA, AUTOSYS

Designation : Sr. Software Engineer

BMRC is developed for BNP Paribas Bank, France. The main functionalities of this BMRC are to calculate the credit risk. The BNP Paribas Bank provides Loans to the customers and other Banks and States based on the analysis of the BMRC applications. The main aim is to produce all the consolidated reporting relative to credit risk (loans, titles Of the BNP Paribas Group. These reports include an internal and a regulatory section. They are divided into country risk reporting, credit risk reporting (Financial information, Major Risks etc.), economic capital and regulatory reporting (BFI, Group) as well as the IAS provisions on the portfolio base. The architecture of the BMRC allows to measure the risks as per different methodologies and to produce all the reports from the same data.

Responsibilities:

Creating Technical Design documents.

Creating Estimation documents from the functional documents

Loading the files from Hadoop cluster to Netezza db and doing business validations and checks.

Direct interaction with the client

Worked on partitioned tables, ref cursors,MVs and collections.

Designing interface programs for calculating the credit risk

Developed ETL processes using Oracle PL/SQL and UNIX SHELL/PERL scripts.

Develop logical and physical data models using Sybase power Designer

Worked on adhoc requirements from other sister teams.

Job scheduling with CRON, Parsing of log files and feed files using Shell Scripts

Preparing Ad hoc Queries for credit analysis.

Preparing Test cases and Test Results and making Unit Test Plans and involving in Integration testing.

Conducting knowledge transfer sessions within the team.

Performance tuning, Bug fixing, Customer support.

Project #4 : (Sep2009 to Jan2011)

Project Name : Credit Control system.

Client : AIG DBG(TCS)

Operating Systems : UNIX, WINDOWS and MS-DOS

Software : Oracle 9i/10g/11g, UNIX SHELL/PERL Scripting, Pro* C, HTML

Development Tools : SQL* PLUS, PL/SQL Developer, Sybase Power designer data modeling

Tool, SDPA, iNet Soft Reporting tool and IHM

Designation : Software Engineer

Credit Control system is used by internal employees of American International Group. This

Repository is used to track all credit related information of accounts which includes Financial Review Details, Security Held, Security and Legal Documents Required, Actuarial Exposure Data and Receivables. The application will allow all users to utilize core functionality as well as business specific functionality based on user log on ID. Credit Control System generates Reports which are useful to management for the decision making and analysis purpose. To implement this we have used java/j2ee technologies in the front end and

universal database as Backend and InetSoft's Style Report for generating reports.

Responsibilities:

Gathering and Understanding the requirements, Analysis, Estimation and Preparing of technical documents

Direct interaction with the client

Application development using Oracle PL/SQL and UNIX Perl/SHELL scripts.

Working on Native Dynamic SQL statements

Prepared/customized UNIX Perl/SHELL scripts for batch processing

Develop logical and physical data models using Sybase power Designer

Developed processes to manage daily work flow of information by communicating, redesigning, and establishing follow up techniques to prioritize tasks, manage scheduling conflicts, and direct priority items to attention of managers

Used Collections and Ref cursors to process array of records.

Preparation of Unit Test plans and System Test plans and end-to-end testing.

Defect fixing and customer support

Effective Interaction with System administrators, Network Administrators and Production Support and other Application groups through on call for high priority issues and write shell script for daily processes

Generating Reports Using Style Report tool.

Participated in Knowledge transfer sessions, status calls and team meetings.

Acting as a back-up PL and actively participated in PMRs, Audits and all quality related activities.

Project #5 : (Apr2007 to Aug2009)

Project Name : DBG-EzAudit Field Expansion (Phase: II)

Client : AIG DBG(TCS)

Operating Systems : UNIX, WINDOWS and MS-DOS

Software : Oracle 9i/10g/11g, UNIX SHELL Scripting, HTML, Pro* C, XML, VB5.0

Development Tools : SQL* PLUS,PL/SQL Developer,

Designation : Software Engineer

EzAudit Field Expansion (Phase-II) under DBG is about expanding the policy number and Producer number from 7 digits to 9 digits and 5 digits to 7 digits respectively. EzAudit/Premium Audit deals with auditing of policies. The auditors based on the audit information provided by the Premium Audit Division carry out the audit activities. The work allocation is done in WTS System and audit data is obtained from AIWCS. Auditors key in the audited policy information in the EZ-Audit Application. This data is transferred back in the form of ZIP files to the EZ-Audit server for further processing. Later the accepted audits are sent to AIWCS via the MQ Interface. Approved audits will be downloaded in AIWCS through EZ-Audit – AIWCS interface. Edit checks would be performed on the downloaded Audits after which they would be pulled out from the WIP and committed automatically to AIWCS.

Responsibilities:

Involved in User Interface and Coding.

Enhancements, Bug Fix, Unit Testing, System Testing, Interface Testing and UAT.

Co-ordinate deliverables with Onsite team.

Worked with users on application problems. When these problems were the result of code bugs, fixed the bugs and worked with quality assurance analysts to verify the corrections.

Participated in Knowledge transfer sessions, status calls and team meetings.

Creating Technical Design documents.

Creating Estimation documents from the functional documents.

Creating Packages, Procedures, functions and triggers.

Working on Native Dynamic SQL statements.

Used Collections and Ref cursors to process array of records.

Granting Privileges to other users.

Technical trainings:

Oracle DBA training

Clinical SAS training



Contact this candidate