Application/database Developer Resume
Atlanta, GA
SUMMARY:
- Senior IT Professional with more than 9+ years of experience in Information Technology Industry with area of expertise being Oracle PL/SQL.
- Experience in all phases of Software Development Life Cycle (SDLC) in Enterprise System such as Oracle Relational Database Management System.
- Expertise in creating database objects such as Tables, Constraints, Indexes, Views, Stored Procedures, Functions and Triggers using Oracle.
- Proficient in SQL and PL/SQL programming like writing Joins, cursors, variables, Ref. cursors, nested tables, associative array, dynamic SQL and nested loops.
- Experienced in developing Reports using Argos 3.x/5.x, and Tableau 8.x.
- Expert level knowledge in Argos Reporting and experience in creating Data blocks and creating Excel, Banded and Extract report using Reporting Writing.
- Expertise in Oracle Reports and Oracle Forms.
- Knowledge in developing Banner Administrative and Self - Service pages/forms.
- Expertise in developing Banner Workflow Applications. Experienced in creating Business Components, Workflow Roles, Workflow users and assigning Users to the Roles. Created Context and Component Parameters using Banner Workflow Modeler.
- Knowledge in working on Banner 9, development environment, integration of Banner 8 Objects, migration of procedures.
- Specialized in Higher Education Domain, Extensive development work with Banner Student, Admissions, HR, Degree Works and Financial Aid modules.
- Executed/Developed routines for migration of Crystal Reports to Argos Reports and developed Customized Argos reports, based on the client requirement.
- Knowledge in setting up EC2 instances, security groups and Setting up databases in AWS using S3 bucket and configuring instance backups to S3 bucket.
- Worked in AGILE environment and Scrum Methodology.
- Experience in 24X7 Production support including on-call support.
- A Team player and have the ability to work effectively with senior management in accomplishing objectives and able to deliver results and meet deadlines.
TECHNICAL SKILLS:
Databases: Oracle 11g/10g, SQL Server 2008, 2012
Languages: PL/SQL, MS SQL, C, Python, Shell scripting, HTML, Groovy Grails, UNIX
ETL Tool: Informatica Power Center 8.x (Designer, Repository Manager, Workflow Manager, Workflow monitor)
Tools: /Utilities: PL/SQL Developer, SQL Server Management Studio, Oracle Forms 6i/10g, Oracle Reports, TOAD, SQL Developer, Jenkins, IntelliJ, Eclipse
Cloud Technology: Amazon Web Services(AWS)
Reporting Tools: Argos, Crystal Reports
Version Control: GIT, SVN
PROFESSIONAL EXPERIENCE:
Confidential, Atlanta, GA
Application/Database Developer
Responsibilities:
- Interacting with users of different departments to understand the current (Manual) process followed for creating Banner roles.
- Analysed the approval process followed currently and designed the process to be followed in Banner workflow.
- Responsible for Data Modeling of the workflow application.
- Development of Workflow application using HTML and JavaScript.
- Created roles in Banner workflow and assigned users to those roles.
- Automated the process of creating Banner roles using Ellucian Banner Workflow.
- Developed database objects in PL/SQL, i.e. writing Stored Procedures, Packages, and Queries.
- Used the procedures and queries to create Business components in Workflow.
- Developed reports for users using Argos.
- Support, develop and maintain Banner 9 Admin pages customizations.
- Responsible for performing Data Replication activities from DEV to TEST Instances.
Environment: Oracle 10g/11g, PL/SQL Developer, SQL Developer, Ellucian Banner Workflow, Argos 5.x, Banner 8.x, Putty, HTML, JavaScript, Unix, SVN, Fort client VPN, Groovy Grails, Eclipse
Confidential, New York, NY
Sr. Database Developer
Responsibilities:
- Interacting with users to gather Business requirements and Analyzing, Designing and Developing the procedures and packages.
- Involved in Understanding the various Asian and European Capital Markets.
- Wrote User Guide and did demo to Capital Markets Team (End Users).
- Analyze and Normalize Data of the relevant business processes.
- Customized and developed Trade Feed screens for various markets using Oracle Forms.
- Developed programs in PL/SQL, i.e. writing Stored Procedures, Packages, and Queries.
- Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
- Launching Amazon EC2 Cloud Instances utilizing Amazon Web Services (Linux) and Configuring propelled examples as for particular applications.
- Setup and build AWS infrastructure with various resources like VPC, EC2, S3, IAM, EBS, Security Group, Auto Scaling.
- Validating connections between APR Gloss and external systems.
- Review and Implement improvements to support process.
- Coordinated and managed Release Cycle.
- Configured Jenkins Jobs for new Linux Servers.
- Successfully supported UAT for the migration.
- As part of Devops Sessions, gained knowledge on Oracle Data Integrator (ODI).
- Knowledge on Configuring ODI connections between source and target systems in topology.
- Automating the code to be copied from SVN to different environments through Jenkins Jobs.
Environment: PL/SQL Developer, SQL Developer, Oracle Forms, Python, AWS, TOAD, Putty, UNIX, Linux, SNV, Scrum, Jenkins, IntelliJ, Capital Markets
Confidential, Irvine CA
Database Developer
Responsibilities:
- Interacting with users of the system to gather Business requirements and Analyzing according to requirements.
- Involved in the designing a prototype of the report using Argos, based on the requirements, for the approval.
- Implementing the functionality of categorizing the students into High, Medium and Low Priorities by writing SQL Queries.
- Created custom Database Objects (Tables, Sequences, and Views etc.) as per the requirements of the user.
- Developed programs in PL/SQL, i.e. writing Stored Procedures, Packages for Implementing the Email functionality.
- Involved in unit testing of the report to match with Banner data.
- Responsible for taking Backup of Database objects and performing Data Replication activities from DEV to TEST Instances.
Environment: PL/SQL Developer, SQL Developer, TOAD, Banner 8.x, SVN, Secure VPN, Argos, Banner Implementation, Java
Confidential, Dunwoody, GA
Database Developer
Responsibilities:
- Worked in Banner Recruiting, Admissions and Advising Modules.
- Involved in gathering system requirements, design, and development and testing phases of this project.
- Developed packages, procedures and functions based on the requirements.
- Involved in Code Review and verification of coding standards.
- Preparing technical documentation for the Student service Centre (SSC).
- Unit testing of written Stored Procedures and Queries with best execution plan.
- Obtaining the business process requirements for the workflow process.
- Implementing workflow in Letter Management process.
- Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
- Installed, upgraded, configured, compiled, support of various Modules for Prod, QA, staging and on development.
- Experience with SQL DDL/DML Triggers, Database Migration and Upgrading.
- Responsible for performing Data Replication activities between different database Instances.
- Troubleshoot day-to-day issues associated with SQL.
Environment: Oracle 10g/11g, PL/SQL Developer, SQL Developer, Banner 8.x, Putty, UNIX, SVN
Confidential, Toledo, OH
Database Developer
Responsibilities:
- Involved in gathering requirements, analysis and development of Reports to be developed using Oracle Report Builder.
- INB are forms created using Oracle Forms Builder. These Forms are customized to the requirements of the University.
- Involved in writing triggers for the actions performed on the forms.
- Involved in designing various forms.
- Involved in Unit testing and deployment of these forms.
- Worked on the migration of Crystal reports to Argos Reports.
- Involved in writing queries for generating reports.
- Created complex stored procedures, User defined functions, cursors.
- Responsible for performing Data Replication activities from DEV to TEST Instances.
- Attending daily SCRUM calls assign and update on stories to team members
- Creating develop tickets for moving code from QA to production using JIRA.
Environment: Oracle 10g/11g, PL/SQL Developer, Oracle Forms 10g, Oracle reports, ARGOS, Banner 8.x, SVN, Secure VPN
Confidential, Cookeville, TN
Database Developer
Responsibilities:
- Preparation of design documents.
- Developed packages and procedures for functionalities.
- Involved in Code Review and verification of coding standards.
- Developed complex programs in PL/SQL, writing Stored Procedures, Packages, Triggers and Queries with best execution plan and experience with testing.
- Experience with tuning complex queries.
- Resolution of critical issues on push to Banner.
- Maintenance of environment stability.
- Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
- Installed, upgraded, configured, compiled, support of various Modules for Prod, QA, staging and development.
- Responsible for Database Migration and Upgrading to setup local environment.
- Assisted other teams in stress-testing Mobile App, locating bottlenecks, and recommending possible solutions.
- Troubleshoot day-to-day issues associated with SQL.
- Used TOAD database development tool to interact with database.
Environment: Oracle 10g/11g, PL/SQL Developer, SQL Developer, TOAD, Banner 8.x, Putty, UNIX, SVN, Cisco VPN
Confidential, Westford, MA
Database Developer
Responsibilities:
- Involved in writing functional and technical documents.
- Discussed and analyzed business functionality with the client and the developers.
- Created and maintained PL/SQL scripts for deploying to Prod.
- Coded many generic routines (as functions), which could be called from other procedures.
- Used Oracle forms to check if the data was pushed to Banner correctly.
- Developed various Reports for the end users as per their requirements and created many reports to suit pre-printed format of the company.
- Writing stored procedures, Functions and Database triggers using PL/SQL.
- Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
- Developed Informatica Mappings and Workflows to load the data from different sources flat files, SQL server to Oracle database
- Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Work lets, Timer and Scheduling of the workflow.
- Used various complex Power Center Transformations like Lookup, Joiner, Expression, Router, Update strategy, Source Qualifier, Aggregator, SQL filter, Sequence Generator to accomplish the mapping design.
- Identifying bugs in existing mappings by analyzing the data flow, evaluating transformations by Debugging Mappings.
- Extensively created Master Child workflows to avoid the code redundancy.
- Created Re-usable Mapplets for Data Profiling and calculating the formulae.
- Monitored workflows and collected performance data to maximize the session performance.
- Performed tuning of Informatica Mappings for optimum performance of data loads and extracts and SQL overrides in place of homogeneous sources. Designed and coded rejected row handling process.
- Used TOAD database development tool to interact with database.
- Participated in 24Hr Production support for our environments.
- Provided proactive support to application issues across production and non-production environments.
Environment: Oracle 10g/11g, PL/SQL Developer, SVN, Secure VPN, TOAD, Oracle Forms, Banner 8.x, Infor matica Power Center 8.1, (Mapping Designer, Workflow Manager, Workflow monitor, Repository Manager), Cast Iron