• Lead technical support for database design, development, and client enhancements.• Wrote SQL scripts to identify incorrect patient tracking data and update the patient tracking database with the correct data to ensure accurate reporting.• Assisted with mission critical, 7x365 required SQL reporting (daily, weekly monthly, ad hoc) used for presented to General Officer and Staff. • Developed and provided client demonstrations of potential Business Intelligence solutions—goal was to establish benefits of dynamic reporting as it relates to patient data analysis.• Served as database administrator (DBA); responsible for maintaining optimal database performance, managing user accounts, and generating reports as required.• Worked as a data modeler in support of the senior data architect; developed logical data models from data requirements gathered during JAD sessions with the business stakeholders.• Analyzed data relationships, data output and reporting capabilities.• Worked with client to determine informational needs, functional and technical requirements.• Evaluated existing access database and SQL Server database and proposed design changes which would normalize the current data.• Created and executed test cases for requested enhancements made to the application.• Successfully coordinated the migration of the Patient Tracking Team database platform from Access 2007 to SQL Server.• CMMI Level 3 Team Lead.

• Worked on the migration of the old client/server WDJ application to the XRM Web (web based system).• Developed and successfully tested Java code on windows and Unix environment to take the place of a stored procedure call, it was more efficient to call a Webservice from an external team for the necessary ordering data.• Created ant scripts to compile all Java code.• Created Informix and Oracle triggers on east and west user tables. Executives wanted to know how many users were created, deleted, and updated in XRM Web so an audit trail table needed to be created.• Provided support with the Informix to Oracle migration. All west tables (Informix) had to be ported over to the east database (Oracle).• Wrote SQL script to analyze all data was successfully migrated.• Created, updated, and maintained all XRM Web configuration files on Unix servers to ensure application was successfully deployed and all functionality was working.• Worked with XRM Web interfacing applications to make sure MQ, Webservices, socket connections, and database connections worked properly in the Project North environments.• Served as XRM Web point of contact for SIGS to XRM table migration. Confirmed all tables and columns used by XRM Web were prevalent in XRM database.• Investigated and worked on XRM Web production issues.• Worked with system testers to provide as much support as possible and ensure fast turnaround on all XRM Web coding issues.

• Created various SQL queries from bundle qualification and trouble management databases for executive reporting. These reports were used to track progress of the excessive amount of bundle qualification order fallout and trouble tickets.• Performed analysis on special bundled telephone/internet service (FIOS and PSTN) order fallout to identify root cause which resulted in team implementing code fixes and reflowing 30K orders successfully.• Worked with external teams to determine best way to obtain the necessary data needed from their system via web service, sftp, ftp, stored procedure. This data help reduced fallout and trouble ticket count.• Created and executed test cases for internal Verizon applications.• Responded to all firewall requests for the 70 employee IT Revenue Assurance Organization which allowed consultants to have access to the network as well as capability for external systems to communicate with internal systems. Without these request being implemented important initiatives couldn’t be completed

• Developed a new application for local wholesale service using J2EE technology, servicing up to 30K external customers with 10K hits per day. Applications required ~ 24/7 availability and were subject to FCC fines for poor performance/downtime. LSI reduced fines by 90%.• Utilized MVC architecture isolating business logic from input and presentation, permitting independent development, testing and maintenance of each.• Developed LSI web tier using JSPs, HTML, Servlets, and XML.• Used Java Script to check user information and provide real time error messages if data was incorrect.• Developed parts of functional website for both internal use and external companies wanting to gain access to systems. Users requesting access online instead of contacting Verizon representatives allowed Verizon to cut resources from the user administration team by 50%. Functionalities developed included reports, system access request, metrics, documentation, dashboard, calendar and file uploading.• Created ant scripts to compile all Java code.• Used UNIX commands to check application and weblogic log files when errors occur in application. Also used commands when asked to move files to another directory.• Responsible for source code Versioning, Branching, Merging and Managing releases using CVS and CMSynergy.• Participated in Technical discussions, Requirement analysis, Release Management and determined LOE’s for initiatives.• Assisted in implementation of Disaster Recovery Project; successfully replicated and configured database and application to run from alternate site with minimal downtime.• Worked in multi-leveled development environment-development, system test, integration test, clec testing, ste, and production. Also served as point of contact for any issues found by testers and had to make sure all issues were resolved before code deployment to production.