We provide IT Staff Augmentation Services!

Sr.software Engineer Resume

PROFESSIONAL SNAPSHOTS:

  • 11+ years of experience in Oracle SQL, PL - SQL Development, Data Modeling in Power Designer and Web services testing via Soap UI in Investment Banking Domain, BFSI and Oil-Gas Domain. I’ve worked as an Associate at Deutsche Bank Operations International (DBOI) Bangalore, India. Prior to which, I held the post of Module Lead at Confidential Technologies.
  • Extensively worked on skills like Oracle, SQL, PL-SQL, Data Modeling and Web Services.
  • Extract/Transform/Load (ETL) from multiple data sources via staging, integration and loading into the Staging.
  • Data Manipulation by reformatting, processing, cleansing and integrating data.
  • Performed SQL tuning and indexes, partitioning and XML file processing.
  • Developed database objects including tables, Indexes, views, sequences, packages, synonyms, triggers, procedures, partitioning, functions and collections.
  • Partitioning and Purging on Existing Tables, BLOB cleanup and reclaim space.
  • Shell Scripting, Control-M Scheduler etc.
  • Handling Technical team.
  • Intense knowledge of SDLC methodology including Agile Methodology.
  • Tools: Jira, Bit Bucket, SQL developer, SQL navigator, Toad and Power Designer.

PROFESSIONAL SUMMARY:

  • Working knowledge in Agile Methodology, Software Development Life Cycle, System study, Design, Documentation, Oracle database Architecture designing, Development and Implementation.
  • Areas of expertise include Strong Oracle Sql, Pl/sql Performance tuning and good in UNIX Shell Scripting.
  • Worked for Oil and Gas Domain (Consumer Goods).
  • Worked for Banking (Securities And Capital Markets - Investment).
  • Done Performance Tuning at DBA level and SQL as per requirement.
  • Build entire database setup for new application (Oracle 12c) and created Development, Test, QA environment for application.
  • Hands on knowledge on the data modeling and data Architect.
  • Develop script for future issues (like Sequence generation for migration project).
  • Develop sql script for verifying data validations, NULL values and Master data.
  • Develop script for checking the integrity of database schema as per requirement Doc.
  • Automation of data purging as per Rules configured in system.
  • Deployment of backend code in non-production environment and reducing deployment time by stats refinement, tuning etc.
  • Data loading and report generation as on when required.
  • Remediation scripts to clean up, scheduled job to clean BLOB data as per retention period defined and downstream XML files generation.
  • Scheduling the file processing as per max Row limit definition etc.
  • New field integration which includes Design approval via Power Designer,Web service changes, field value storage & retrieval, Replication logic, and getting the static data approval via Autobhan ..etc.
  • Bulk file logic implementation to process the bulk data.
  • Data validations on input/output data.
  • Worked as database Architect, DBA, Senior Developer.
  • Handled Technical Team.
  • Understanding requirement and Effort estimation for CRs and Issues.
  • Impact Analysis of new changes or new functionality amendment.
  • Code review as per coding standards.
  • Responsible for creating Test Data for application.
  • Performance tuning via Explain Plan, STATS, Trace File.
  • JSON file generation using an index.
  • Scheduling job to process the bulk files and reclaim LOB space.
  • Integration of new fields and Bulk file integration.

SPECIALITY:

Oracle PLSQL Programming, Design, Development, Modeling and Web service.

TECHNICAL SKILLS:

Programming Language: Oracle SQL and PL-SQL

Database: Oracle9i,Oracle10g,Oracle11g,Oracle 12c

Database(Oracle)Utilities: Export and Import.

Operating Systems: Windows2000/XP,Linuxcentos5.

Tool Used: Toad, Plsql developer, SQL developer

Domain Knowledge: Banking Operation, Oil and Gas and Investment banking.

ORGANISATIONAL EXPERIENCE:

Confidential

Sr.Software Engineer

Technologies: Oracle 12c - Oracle SQL, PL/SQL and Power Designer

Responsibilities:

  • Data Modeling and PDM changes using Power designer.
  • Development using PLSQL Developer and testing as per agile methodology.
  • Web service changes using Java and testing via SoapUI.
  • Bulk file processing implementation/remediation, if any..
  • Bug fixes if any in SIT/UAT phase.
  • Non-production deployment activity

Confidential

Sr.Software Engineer

Technologies: Oracle 12c - Oracle SQL & PL/SQL.

Responsibilities:

  • Data Modeling
  • Working on Logical and relational Modeling using SQL Developer Tool.
  • Generating DDL scripts from Relational Model and deploy it in Database.
  • Data Migration from different sources.
  • DBA and PL/SQL developer tasks.
  • Bug fixes.
  • Deployment Tasks

Confidential

Sr.Software Engineer

Technologies: Oracle 11g - Oracle SQL & PL/SQL.

Responsibilities:

  • Work on Sustain/ enhancement Items which is tracked through SM9tool.
  • Supporting Production release.
  • Make sure that the DDL changes are reflected in Data Model (SA) .
  • For any new Sustain item, implement the System of Records (SOR) logic.
  • Performance Tuning includes Compression, De-normalization and Modifying existing joins… etc.
  • Identify repeated issues, perform operations based root cause analysis (RCA) & complete documentation of problems and solutions.
  • Preparing document for all enhancement/Sustain items and uploading in SharePoint once UAT sign-off is done.
  • Give KT to support team/new joiners before production deployment.
  • Emergency releases in case, if any.
  • Give KT on Confidential database objects and SOR end to end logic to new joiners.
  • Guide my database team members to achieve their goals and objectives and supporting the team to come out with the desired results.
  • Conducting weekly offshore meeting/activities on round robin basis.
  • Updating the process document in case, if any change related to DB.

Confidential

Sr.Software Engineer

Technologies: Privilege Password Management - PPM - Cyber Ark.

Responsibilities:

  • Implementation of Cyber Ark PIM 8.6 version solution for leading Manufacturing organization of US, for managing privileged accounts intheir environment for different servers like Windows, UNIX and also integrated with different tools like WInSCP, VSphere, VNC.
  • Integration of new flat files using SQL Loader and output report generation as per the business requirements.
  • Migration of COBOL to PL/SQL for upload and download report generation based on regions.
  • Handling of Adhoc requests (Report history generation), and helping production team on resolving critical fixes.
  • Performance tuning when job takes more than the expected.
  • Interact with customers to understand the business requirement and giving update on all open items that we work and prioritize the tasks etc.
  • Lead and help team members in case if they need any help and make sure that all changes are in track and deliver them on/before expected time lines.

Tools: used: UMR & Quality Center

Confidential

Module Lead

Technologies: Oracle 11g - PL/SQL, Shell Scripting, Control-M and Informatica.

Responsibilities:

  • Taking ownership of all major development like new interface building for Liquidity/new instrument feed creation and extract feed which meets the requirement.
  • Interact with Europe customers to understand the business requirement and giving update on all open items that we work and prioritize the tasks etc.
  • Handle requirement such as Price formula change / source table changes i.e. execution of change request and test case preparation and raise a ticket for release management.
  • Extraction of Stock, Cash and FX contract for Booked and Disposed holdings from source systems by applying some filter logic change (very rare) and addition of new instrument type business logic in View and feed file companion & getting user sign-off for the same.
  • Migration of source system, portfolios handling and currency conversion with the help of FX rates and weight calculation at share class.
  • Handling of some Adhoc requests (Seed cap weekly & Monthly load), EC holdings, Index History load etc.
  • Lead and help team members in case if they need any help and make sure that all changes are in track and deliver them on/before expected time lines.
  • Performance tuning when job takes more than the expected time around a week.
  • Integrated new downstream/upstream system to send/receive new Benchmark data in single/multi-index format.
  • Integration of new series, indices, and files under existing series in the oracle application database called IDMS (Index Data Maintenance Systems).
  • Coding, Testing and rework in non-production environment and release it into production through Remedy tool.
  • Writing/Modifying shell scripts for performance tuning, splitting/Merging the vendor files and also written few new shell scripts to design a file according to new downstream Specification etc.
  • Created few Tables and set of jobs under the table in Control-M to extract and deliver files to downstream within the specified time.
  • Developed a piece of code to generate the daily incident reports and send it to the mangers and all the team members to notify about the current status of all the open issues in Remedy.
  • I was part of database migration testing (from Oracle9i to Oracle 11g), UNIX to Solaris server, Autosys to Control-M jobs migration for IDMS application from duration.
  • Performance tuning when migrated from Oracle 9i to oracle 11g around six months and as and when required.
  • Quarterly once we have to do Partition/Purging activities for set of IDMS core tables.
  • Worked on below Value-adds in Index Data management systems to stabilize the application:
  • Written a new procedure to sync the production sequence value with that of the non-production if there is any mismatch due to manual entry.
  • Written a generic procedure to MAP assets that comes Via MAP files automatically (to reduce manual effort involved in asset mapping and release management).
  • Written new procedure to setup any single index existing downstream for new series integration.
  • Bloomberg Change: Implemented three logics to automate index addition/Removal in request file based on master table, removal of hard coding series cd in put file shell scripting and to fetch vendor file availability time from oracle table instead from request file.

Hire Now