Data Software Engineer
Resume:
MADHAVI KONDA *******.**@*****.***
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