Sql Developer Resume Profile
2.00/5 (Submit Your Rating)
OBJECTIVE: To obtain challenging position that will contribute to the growth and enhancement of the company by utilizing my experience and knowledge.
WORK EXPERIENCE:
Confidential
- Tasked to build, maintain, and administer SQL Server 2005 database for clients. ETLs were built using multiple programming languages such as SAS, T-SQL, SSIS, Javascript, Cscript, and conversions DTX packages
- Built, maintain, and administer Oracle instance and its databases to use for development and testing of client data and processes
- Converted client SQL Server T-SQL packages into Oracle PL/SQL packages
- Developed automated jobs to import data, cleanse and process the data, export and upload the data in various forms, create reports, and send out email notifications
- Developed a Crystal Reports scheduling system off of a preexisting software to meet internal needs and functionality
- Used Crystal Reports to create monthly reporting for client's marketing campaigns
- Used SAS to program intelligent targeted marketing campaigns using proprietary models for multiple clients
- Implement proprietary models for client production processes for marketing and business rules
- Created reports using C .NET, MS Excel, and VBA to produce formatted reports from raw data and unformatted reports
- Develop internal software and code libraries
- Internal office duties include: IT support/setup, support for IP phones, system administrator for servers, and server backups
Confidential
- Pro-active/reactive troubleshooting and resolution of issues related to the maintenance of a reporting system and its data warehouse for Xerox Services
- Development of code for data loads and the web application for any defects found in the existing code, business requirement changes, and workaround scripts
- Plan, support, and monitor data loads across multiple Oracle databases in two different reporting applications
- Tuning of PL/SQL and SQL used in data loads
- Converted data loads using Pro C to use CSH scripting, SQL Loader, SQL, PL/SQL procedures for old, new, and retired data feeds
- Daily communication and interaction with business customers to provide support for business data
- Server migrations working with an SA remotely in order to successfully move web applications, services, and other server settings to another server
- Created and updated documentation of data loads and related troubleshooting guides
- Coordinated production releases between development team, project managers, and production support group
Confidential
- Worked with business mangers and subject matter experts in order to define and develop SDLC for a project, including migrating reports from a legacy reporting system to a newer reporting system using languages such as WebFocus, Visual Basic, SQL, PL/SQL, HTML, JavaScript, VB Script, VBA
- Developed new functionality for the legacy and new reporting systems
- Implemented and/or changed processes to align with new business requirements
- Created an MS Access application to load external data from an Excel file into an Oracle using VBA, SQL, and PL/SQL
- Maintained the new and legacy reporting systems
- Produced adhoc requests for the business
- SUMMARY OF Ability to work as a team member and independently
- QUALIFICATIONS: Strong analytical skills and the ability to learn quickly
- Capable to stay on task to achieve a goal
- Willingness and able to adapt to new working environments and technologies
- Experience working with relational data