Senior Oracle Pl Developer Camp Hill, Pa
Executive Summary:
- 7 Years of experience in the Information Technology field with extensive experience in Database development, Perl Shell Scripting, Core Java, Requirement gathering and analysis, Unit Testing and monitoring, documentation and technical support, and with Telecom and Media and Insurance Domain knowledge.
- Strong analytical, problem solving and communication skills with strong focus towards goals and work ethics
- Experienced as Oracle developer / Perl / Unix Developer in large production environments with database implementation on UNIX and Windows.
- Experienced in developing the PERL Scripts and UNIX Shell Scripts to implement various business functionalities.
- Experienced in developing tools for automation of deployments and testing with PERL / SHELL.
- Experienced in coding on Core Java worked on Proviso customisation
- Experienced in SQL, PL/SQL procedures, packages, functions, database triggers with working knowledge of Oracle11g
- Experience in loading data, troubleshooting, Debugging of procedures and SQL queries
- Experienced in writing SQL queries creating different kinds of reports from large scale database.
- Extensively involved in troubleshooting, debugging and fixing the codes/scripts.
- Expertise in Query Writing and Reports generation.
- Experienced in providing technical production support.
- Involved in preparing the functional specification, technical documentation, schema documents, flow charts and user support documents.
- Working knowledge on CruiseControl tool tool for Nightly Build
- Working knowledge on Autosys Job Scheduling and JAWS Reporting tool for Autosys
- Experienced in customising front-end reports with technologies like HTML/CSS/Javascript
- Exposure to XML, Web Services and WebLogic tool
- Knowledge of the entire development process including specification, documentation, quality assurance and implementation SDLC
- Understanding the Business Requirements
- Designing the End-to-End flow
- Preparing Low Level Design documents for Development team's perusal
- Face-to-Face Interactions with stakeholders when at Onsite
- On call interactions with Clients/Stakeholders
- Test criteria test case design.
- Execution of the test cases.
- Experience in Regression testing.
- Testing of Application Packs and Fix Packs of Proviso .
- Experience in Bug Tracking, Reporting Bug fix verification.
- Knowledge of Bug reporting tools like BugZilla, ALM.
- Knowledge of complete Software Test Life Cycle.
- Knowledge of Selenium to perform Web Testing
- Good knowledge of Configuration Management with working knowledge of SVN.
- Good knowledge on Defect Prevention practices.
- Good Communication skills.
- Good Team Player.
Skillsets:
Languages : PL/SQL, Perl, Shell Programming , Core Java, HTML, XML, JavaScript, VB, C, C
Network Reporting Tools : IBM Tivoli Netcool / Proviso A Network Performance Management COTS Product SNMP Based data collection
Office Tools : MS Word, MS Excel, MS Power Point, MS Visio
DB Tools : SQL Developer, PLSQL Developer
IDEs : Eclipse, NetBeans
Operating Systems : Win 98/ XP/ 7, UNIX Solaris 9 / 10, HP UX , Linux Redhat
Bug Reporting Tools : Bugzilla, HP Quality Centre / ALM
Job Scheduling : Autosys, JAWS
Configuration Management : Subversion SVN
Build Management : CruiseControl
Career Profile:
Confidential
Role s : Senior Oracle PL Developer
Skillsets: Oracle 11G, JDK 1.6, Windows 7, JIRA, Oracle SQL Developer and WinSCP.
Brief Role Description: Working on Oracle, PL/SQL, Unit Testing and also working as a mentor to guide and help new joiners both on technical and domain front.
Responsibilities:
- Discussing New or Enhancement requirements with the business users.
- Preparing SQL Scripts, Stored Procedures, Functions and Views to implement the Business logic.
- Working on data fixes to correct the wrong data as per the business user request.
- Preparing the report to find out the corrupted/invalid business data and share with business.
- Writing Script/Procedure to fix the corrupted/in valid business data in Database.
- Supporting the production deployment for data fixes scripts on daily basis.
- Meeting with the Business analysts to discuss the data fix issues on daily basis.
- Analyzing the Existing data model and modify the data model to implement the New/Enhancement business requests.
- Creating New reports for data analysis using the Business Intelligence tool as well as Oracle database.
- Migrating Existing data into new Source system.
- Analyzing the gaps between the old source system and new source system and estimate the time frame to complete the gaps.
- Involving in Code review and Unit Testing of the new development.
- Preparing report data for validation for pre and post deployment process.
- Coordinating with onsite team members about the New/Enhancement Requirement analysis, Design and Development.
- Supporting off-shore development team to understand the problem and the fix that is required for the problem.
- Maintenance and support of the existing source codes and data.
Project Name: TAOS Tracking Activation Offer System
Confidential
Role s : Developer / Development Release Lead / Onsite Coordinator Multiple Roles handled in parallel
Skillsets: Oracle PL/SQL, Perl, Shell Programming, HP UX Operating System, SQL Developer, PL/SQL Developer
Responsibilities:
As a Developer:
- Worked on the PL/SQL packages, procedures, functions applying the business logic to load the customers on the database and issuing credits based on their eligibility.
- Created custom PL/SQL anonymous blocks to perform one-time operations
- Created custom triggers to automatically populate different tables.
- Design and developed the UNIX shell scripts to create table, views, indexes and sequence.
- Created the Shell Scripts to automate the execution of the PL/SQL subprograms and to move the data to store in historical/archive folders.
- Worked on Troubleshooting various production issues
- Developed tools in PERL to automate deployments and thereby reducing the deployment time and most importantly reducing human errors
- Used FTP to transfer the files into different servers as per needed by the business users.
- Involved in preparing functional document, user document, process flow diagram and flow charts.
- Created the test scripts and complex queries to test the application and to quality assurance of the data.
- Involved in creation/scheduling of Autosys Jobs JIL file generation
- Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
As a Development Release Lead:
- Interactions with the SQA Teams on upcoming Projects and Requirements
- Coordinating with the Development team and integrating various moving parts for a Release
- Reporting the management on the progress of releases, any delays, risks and mitigation plans
- Managing multiple releases, in a fast paced organization where release planned happens every month and need-based Off-Cycle / Emergency Releases
- Scheduling Off-Cycle / Emergency Releases by interacting with various Application Delivery Management and SQA teams when needed
- Preparing for the pre-release activities for the releases
- Supporting the Production Deployment of Planned Releases from Development Lead perspective to ensure smooth release
- Proactive Post-Release monitoring of jobs and impacted objects to detect early and plan for any complications
As an Onsite Co-Ordinator:
- Client Interactions
- White Board sessions to client on new design / design suggestions
- Demo on the solutions developed by the team and elucidation of its benefits
- Interactions with Offshore team to keep them appraised of the day-to-day events
- Assigning and tracking the work delegated to offshore to ensure correctness and quality
Confidential
Role s : Designer / Developer / Tester / Configuration Controller / Onsite Coordinator
Skillsets: Perl, Shell Programming, VI Editor, Core Java, Oracle DB, SQL, Sun Solaris Operating System 9 and 10 , IBM Tivoli Netcool Proviso
Brief Role Description: Started as a Tester Regression testing, testing of customised scripts, Application Packs, Fix Packs , honed as a Developer Development of Custom Perl scripts and coding in Core Java and Proviso Tool based development, Unit Testing QA Support and performed the role of Designer Understanding the Business Requirements, Designing the End-to-End flow, Performing PoCs Proof of Concepts , Low Level Design, Interactions with stakeholders including face to face and on call , also involved in estimating effort for the requirements .
Responsibilities:
As a Tester:
- Identification and execution of Regression test cases.
- Identification and execution of test cases for Proviso customizations Formulae, Rules etc. .
- Identification and execution of test cases for customized scripts Perl and Java .
- Identification and execution of test cases for complete Fix Pack testing.
- Worked with Selenium Tool to perform some part of the Web Testing
As a Developer:
- Participate in design reviews to ensure that designs meet customer requirements
- Provide inputs for overall implementation plan
- Unix Shell / Perl Scripting for customization of Proviso.
- Experience on VI Editor
- Core Java coding for customizing reports.
- Development of formulae SNMP based for Discovery of Network Devices Routers, Switches etc. and Collection of metrics.
- Perform independent testing and sign off the code for delivery to QA testing.
- Bug fixes for In-Life defects.
- Troubleshooting issues on UNIX platform
As a Configuration Controller:
- Configuration Management of the team's artifacts.
- Performing periodic CM audits on the team to ensure compliance
As a DP Team Member:
- Defect Prevention Analysis.
- Root Cause Analysis of the defects.
- Preparation of charts showing the Defects Trend.
- Awareness to team by conducting Weekly and Monthly Quizzes.
As a Component Representative for E2E Support:
- Troubleshooting of E2E defects
- Interactions with E2E testing team to provide clarifications
- Interactions on-call F2F with the E2E integrator to give status of the defects
- Reporting the status timely to the higher management
As a Component Designer:
- Understanding the Business Requirements
- Designing the End-to-End flow
- Performing PoCs Proof of Concepts
- Preparing Low Level Design documents for Development team's perusal
- Interactions with stakeholders including Face-to-Face and on call
As an Onsite Coordinator:
- Client Interactions
- White Board sessions to client on new design / design suggestions
- Demo on the solutions developed by the team and elucidation of its benefits