Database Developer Resume Profile
SUMMARY
- Over 16 years of experience in analysis, design, development, quality assurance and system support of variety of client/server, web and reporting applications for major companies.
- Highly dedicated, self motivated professional with effective leadership, communication skills.
- Demonstrated analytical and problem solving skills in delivering high quality Tier-1, Tier-2 and Tier-3 production support for numerous applications
- Excellent team player committed to delivering high quality results to the organization.
- Fully experienced in all phases of SDLC, ranging from requirement analysis to transitioning the system into production.
- Strong knowledge and experience in UNIX, Windows
- Very strong experience in Oracle 9i,10g, 11g, PL/SQL, SQL, Business Objects, Brio, Sun Solaris, Perl/Shell scripting.
- Active development experience of web sites, database and reporting applications such as, VB, HTML, DHTML, XML
- Proficient with functional, integration, performance testing of web, back end, client/server applications.
- Flexible, Open Minded, Committed, Rises to the occasion without imposing any barriers and often considered as the person to go-to, Go-Getter
- Excellent written, communication and presentation skills.
SKILLS
- Operating systems UNIX, Mainframe, Windows, MS- DOS
- RDBMS Oracle, Sybase, MS Access, FoxPro and DB2
- Web Technologies HTML, DHTML, XML, JavaScript, VBScript, ASP, J2EE, Front Page
- Reporting Technologies Brio, Business Objects, MS Access, Oracle Reports
- Methodologies SDLC, RUP, ITIL, CMMI, Agile
- Analysis Use Case Models, Sequence Diagrams, Data Flow Diagrams, Context Diagrams, Flow Charts
- Databases Conceptual/Logical/Physical Data Modeling, ER Diagrams, Normalization, Physical Database Design, Database Sizing, Database Object Creation Tables, Indexes, Synonyms , PL/SQL Programming Packages, Procedures, Functions, Views, Triggers , Query Tuning, Access Control, Oracle Forms, SQL PLUS, SQL Loader, BCP
- Programming SQL, PL/SQL, Java, VB, HTML, DHTML, SQL, Transact-SQL, Perl, Shell Scripting, XML
- Testing Quality Center, WinRunner, Load Runner, ClearQuest
- Others ERWin, Informatica, AutoSys, Visio, Cron, DreamWeaver, Image Composer, PVCS, CVS, SVN, TOAD, Benthic, SQL Developer, PL/SQL Developer, Case Complete, ClearCase, Remedy
EXPERIENCE
Confidential
- Working as a senior oracle consultant on EDM project for World Bank. World Bank Treasury, in partnership with the Finance Complex's Information Management Technology group, is implementing a solution to address its data management needs, replace existing Operational Data Store TODS with a more robust, industry standard Data Warehouse DW . Provide standard definition and labels in business terms to all data elements. Clean and consolidate data, and establish a governance process to manage data.
- Work on migrating data from old system TODS to new system, EDM
- Create necessary pl/sql packages, views, materialized views to support datawarehouse reporting.
- Perform data analysis to trouble shoot application issues.
- Involved in the performance tuning of SQL queries
- Provide support to product test, system test and customer acceptance testing on the system validations.
Environment: Oracle 11g, PL/SQL, SQL, Windows 7, Business Objects
Confidential
- Defense Occupational and Environmental Health Readiness System DOEHRS is a comprehensive, automated information system for assembling, comparing, evaluating, using and storing occupational personnel exposure information workplace environmental monitoring data, personnel protective equipment usage data, observation of work practices data, and employee health hazard educational data. DOEHRS integrates with other DoD systems.
- Develop Logical and physical data models using Erwin, generate Structured Query Language SQL scripts and generate Data Dictionary.
- Participate in requirements definition meetings and documentation activities.
- Develop database design artifacts from high-level requirements.
- Work with different software development teams to refine entity models based on requirements.
- Create and execute database scripts to maintain and upgrade standalone, Oracle advanced replication master-to-master and materialized view environments.
- Provide database support in all phases of software development.
- Perform tablet testing, backup databases.
Environment: Oracle 11g, PL/SQL, SQL, Erwin 7.3.4, Shell scripting, Windows XP, Solaris 10
Confidential
- Worked as a Sr. Database Developer on a data warehouse project , SASP for USPS.
- Extracting visibility data from various scan sources, transforming and uploading into target database that supports Business intelligence reporting.
- Creating mappings, defining run-time properties using work flow manager.
- Worked on data conversion process for major releases.
- Work with DBA and CM teams to deploy database builds to product test, system and integration testing, customer acceptance testing and production environments.
- Address all the defects opened during the test cycles and resolve and troubleshoot them and get a sign off from the client for production deployment.
- Extensively used bulk collect for batch processing of rows and PL/SQL Collections for data processing.
- Creating materialized views on Business Intelligence application to support reports performance.
- Perform SQL tuning and SQL query execution using hints to reduce processing times and collect data.
- Perform data analysis to trouble shoot application issues.
- Involved in the performance tuning of SQL queries
- Provide support to product test, system test and customer acceptance testing on the system validations.
- Developed technical design documents from high level requirements.
- Served as a career counselor for new database developers, provided mentoring support. Involved in annual performance review process.
Environment: Oracle 10g, PL/SQL, SQL, Shell scripting, Solaris 9, Windows XP, Informatica 8.6, sqlloader, Benthic, Erwin
Confidential
- Worked as a Sr. Database Developer on the re-engineering project, Mail.DAT and Mail.XML for USPS.
- Worked on system enhancements, and leading rest of the team.
- Worked with DBA and CM teams to deploy database builds to product test, system and integration testing, customer acceptance testing and production environments.
- Address all the defects opened during the test cycles and resolve and troubleshoot them and get a sign off from the client for production deployment.
- Primary responsibilities include server side validation of the files submitted by the mailers
- Uploading the files into target database, transforming data into intermediate structures to support reporting.
- Extensively used bulk collect for batch processing of rows and PL/SQL Collections for data processing.
- Perform SQL tuning and SQL query execution using hints to reduce processing times and collect data.
- Perform data analysis to trouble shoot Mail.dat, Mail.xml application issues.
- Involved in the performance tuning of SQL queries
- Provide support to product test, system test and customer acceptance testing on the system validations.
- Lead a small database team for a major release. Mentor new database developers, helped them with project domain knowledge, and reviewed their work products.
- Involved in performance management process, provided feedback for the team members.
Environment: Oracle 10g, PL/SQL, SQL, XML, Shell scripting, Solaris 9, Windows XP
Confidential
Total Circuit Order Management System TCOMS Reporting
- Worked as a sr. database developer in maintaining and providing Tier-3 support for TCOMS reporting system. TCOMS system generates various transactional reports, adhoc reporting, feeds to other systems and performance reporting to the management.
- Gathered business requirements, performing impact analysis on the system components,
- Created the design specifications and implementing the changes on the database, reports and the interfaces.
- Managed the Business Objects Universe and user management functions.
- Participated in several iterations of the development from inception through transition phases.
- Assisted QA team on the system validation.
- Involved in migration of an Image port based fax monitoring system on a UNIX platform to windows based system using RightFax.
- Analyzed the Fax monitor system current capabilities, developing system use cases, designing the transition of the old system into the new system, working with off shore team on the coding, coordinating the QA efforts and transition the system into production.
- Additional responsibilities also include the production support at all tiers.
Environment: Oracle 9i, PL/SQL, SQL, Business Objects 6.5, Brio 8.3, Solaris 9, Perl/Shell scripting, Autosys, C , Windows 2000
Confidential
- I worked as the Sr. Developer on the ongoing maintenance of the ASR System. ASR system sends orders between LECs and carriers via ASRs as per ASOG rules. Eastland has been the outsourced vendor for supporting the ASR functionality.
- Analyzed the requirements, assessed the impacts on the systems, and reviewed design/implementation from the vendor and implemented database and data loading script changes.
- Given the number of systems involved with the ASR functionality.
- Coordinated the integrated system testing in preparation for the production deployment.
- Responsibilities on that front include planning the test phase, environment setup/coordination,
- Involved in the preparation of test data, execution and preliminary investigation into the issues and follow up activities on their closure.
- Prepared the test data that's consistent across all the environments has been a challenge.
- Wrote several data scripts to create base data in appropriate systems.
Environment: Oracle 9i, PL/SQL, SQL, C , Shell/Perl Scripting, Autosys, Solaris 9.
Confidential
- I worked as a Database Developer in Migrating Order Data from NSPS System, MCI order provisioning system into TCOMS WorldCom order provisioning system .
- Involved in loading the data extracts from NSPS system into TCOMS system.
- Assisted NSPS system preparing the data extracts.
- Helped QA team perform back end system validation.
- Involved in upgrading TCOMS system in support of the underlying technology upgrades.
- Upgrades include Business Objects from 5.1 to 6.5, Brio from 6.5 to 8.3 and Oracle 8i to 9i.
- Primary responsibilities include the impact analysis for reporting components.
- Prepared the specifications and implemented the changes on the database, reports and the interfaces.
- Worked very closely with system/database administration group, Configuration Management group in setting up the environments.
- Assisted the Quality Assurance group in performing back end validation.
- Acted as the primary point of contact of production support when the system was transitioned into production.
Environment: Oracle 8i/9i, Business Objects 5.1/6.5, Brio 6.5/8.3, PL/SQL, SQL, Solaris 9, HP-UX 10, Perl/Shell scripting, MS Access
Confidential
- I worked as a developer in building the ASR System. ASR system sends orders between LECs and carriers via ASRs as per ASOG rules. Eastland is the primary outsourced vendor to deliver the ASR functionality.
- Primary responsibilities include automation of file transfers between MCI Worldcom and external systems,
- Performing database changes, automation scripts to load and unload data files into ASR database.
- Developed a monitoring system to check the health of the ASR interface and sending status notifications to the recipients of ASR orders.
- Assisted QA team with automation scripts in performing the validation across various systems.
Environment: Oracle 8i, SQL, PL/SQL, C , Shell/Perl Scripting, Autosys, Solaris 9
Confidential
- I worked as a Database Developer in migrating workflow related data from LSAT system, MCI workflow management system into AM WorldCom workflow management system .
- Primary responsibilities include generating extracts for open orders from LSAT system and delivering them to AM team.
- Worked as the database developer in providing nightly data changes on LSAT system to METIS system MCI reporting system .
- Primary responsibilities included the creation of triggers on LSAT tables to capture changes, creation of procedures and interface programs to flush the changes into data files.
- Web Site Development for Production Support
- Worked as the developer in creating a home page for Production support group. This site was intended to include some static content such as maintenance windows, schedule of recurring activities. It's also used to publish the reports, extracts generated by production support group for general access.
Environment: Oracle 8i, PL/SQL, HP-UX 10, Perl/Shell scripting, MSFrontPage, DreamWeaver, ImageComposer, ASP, MS Access, VB
Confidential
- LSAT system. LSAT system is the hub workflow management system, implemented using CORBA, with interfaces to Provisioning system NSPS , translation systems TPS , Order entry system SRMS and Number portability system NPSM and Operational Report Generation for LSAT system.
- Involved in identification, trouble shooting and resolution of issues in production.
- Additionally, in the early stages of production, LSAT suffered significant performance issues in delivering data to the interfaced applications.
- To troubleshoot issues worked on generating periodic data extracts for each of the systems and wrote procedures to update workstep completions on behalf of the LSAT interfaces.
- In the early stages of LSAT, application didn't completely address the management reporting needs.
- To fill the gap, a light weight reporting system has been generated in MS Access by pulling data from LSAT database.
- Responsibilities included creation of additional structures to support reporting, writing procedures to populate the reporting structures and accessing these structures for reporting needs.
- In order to meet the aggressive response times of LSAT system, it's required to archive the older data of the system.
- Wrote the database procedures to move data from online tables to historical tables based on the aging criteria defined.
Environment: Oracle 7.3, PL/SQL, HP-UX 10, Perl/Shell scripting, MS Access.
Confidential
- I worked as a system developer in building payroll and inventory systems for a financial Organization.
- Primary activities include development and testing of reports module.
- Oracle Reports is used to generate daily and management reports.
- Developed Access Database for Pay Roll inventory separately for each module.
Environment: Oracle 7.x, MS Access, SQL, PL/SQL, Oracle Forms 3.0, Reports 2.0, Windows NT.