Sr. Software Developer Resume
SUMMARY:
Sr. Software Developer, with 11+ years of full time IT experience that includes 6+ years of experience in design and development in Oracle & PL/SQL, having excellent cross - functional team leadership skills.
TECHNICAL SKILLS & EXPERTISE:
Database: Oracle 8/10/11, PL/SQL, SQL Server, MS-Access
Language: VB6
Tools: Crystal Reports 8.1, SQL Developer and Toad
Scripts: Visual Basic script, Shell Script
EXPERIENCE:
Confidential
Sr. Software Developer
Environment: Oracle 12c, PL/SQL developer
Responsibilities:
- Developed CacheDB application for My Confidential Application and My Voadafone Business
- Requirement Gathering, Analyzing the requirement, designing database and Implementation
- Designing packages, stored procedure, functions as per functional Requirement.
- Developing/Testing/De-Bugging PLSQL Code for Live Migration from Oracle 11g to Oracle 12c environment (using in memory concept).
- Writing complex queries, functions, materialized views as per requirement.
- Debugging SPs for performance tuning. Creating Low-level design document.
- Creating batch jobs. Worked closed with EAI, Middleware team.
- Worked for IDEA and Confidential consolidation project .Design and developed process and programs for MVA and MVB data consolidation.
Confidential
Senior Software Engineer
Environment: Oracle 11g, PL/SQL developer, Unix, RPAS
Responsibilities:
- Designing packages, stored procedure, functions as per functional Requirement.
- Developing shell script for loading the data from Windows to Unix environment
- Writing complex queries, functions, materialized views as per requirement.
- Creating batch jobs, Testing all the classic related menus and functionality
- Worked on Oracle Retail Predictive Application Server (RPAS) application
Senior Software Engineer
Confidential
Environment: Oracle 11g, PL/SQL developer
Responsibilities:
- Designing packages, stored procedure, functions as per functional Requirement.
- Developing/Testing/De - Bugging PLSQL Code for Live Migration
- Involved in Delta Migration Activity
- Writing complex queries, functions, materialized views as per requirement.
- Debugging SPs for performance tuning.
- Creating batch jobs.
- Worked with performance testing team and automated their work by using control files and creating scripts using PLSQL
- Supporting Onsite Activity.
Confidential
Sr. Database Developer
Environment: Oracle 12C, PL/SQL developer, SQL developer, Shell Script
Responsibilities:
- Designing stored procedure as per process modelers.
- Scheduling and monitoring jobs.
- Writing complex queries, functions, materialized views as per financial analyst requirement.
- Writing control files to migrate the data and shell script to load files.
- Debugging SPs for performance tuning.
- Creating and tweaking procedures as per Java developers.
Confidential
Senior Software Engineer
Environment: Oracle 10g, PL SQL, SQL developer, TOAD
Responsibilities:
- Extracting, Analyzing, and Cleansing the Data from Classic system
- Creation of Dashboard, Automating the manual work using advance PL/SQL, Function, Materialized views.
- Generate discrepancy report at attribute and technical level, provide reports for testing team
- Ensures the data quality for the various attributes at agreed Level
- Identify the gaps in the process/design documents and ensure the gaps are removed
- Creating weekly status and monthly report
- Debugging SPs for performance tuning.
- Scheduling and monitoring the job, issue analysis and resolution.
- Guide the team and help leader for smooth process outflow and activities
- Involved in Migration from one product to another
Confidential
Senior Software EngineerResponsibilities:
- Extracting data from different systems
- Analyzing and cleansing the data for each customer
- Creation of Dashboard, Automating the manual work using advance PL/SQL, Function, Materialized views
- Debugging SPs for performance tuning.
- Generate discrepancy report at customer level
- Scheduling and monitoring the job, issue analysis and resolution.
- Guide the team and help leader for smooth process outflow and activities
Confidential
Production Support Engineer
Environment: VSAM, COBOL, JCL, DB2, CICS (Tools used Remedy, Peregrine, Maximo, Esmart)
Application: LPS, SSW, CIW, ACAPS, Pricing Engine, CRESS-VMS, CROSS, EBA, SpeedPay
Responsibility:
- Generating MIS reports, Weekly status reports, Scorecard reporting
- Automation of reports, using VBA in excel, MS-Access.
- Testing macros manually.
- Extraction of data from Siebel, orbit analytics and analyzing the same.