SUMMARY:

• Perceptive Systems Analyst proficient at designing innovative IT and database solutions applicable to current business practices. Committed towards improving business productivity and efficiency by improvising on existing systems and solutions.
• Solid understanding of software development lifecycles and thorough knowledge of IT procedures, processes, and standards to set up an expedient IT infrastructure to boost productivity and reduce costs.
• Possess excellent analytical and troubleshooting skills.

TECHNICAL SKILLS:

• SQL, PL/SQL, Oracle Database 9i, 10g, 11g, MS Access 2007
• HTML, XML, CSS
• PERL, Erwin, UNIX Shell Script

PROFESSIONAL EXPERIENCE:

System Analyst Lead

Confidential,Alexandria, VA

• Performing database programming in Oracle to analyze, develop, and implement customized solutions for resolving complex XML data manipulation and ETL requirements for Department of Justice personnel.
• Developing complex programming scripts in SQL to analyze data processes and data architecture designs.
• Providing leadership and analytical support for full development life cycle of Oracle ADF document tracking and Court Exhibit applications.
• Contributed towards planning, delegation, and execution of strategic solutions to load images, OCR text, and XML metadata from third - party sources to Confidential 's proprietary on-line document repository system.
• Facilitating in the analysis and implementation of Linux Shell and PL/SQL based export tool to simplify execution of high volume document production.
• Establishing procedures for technical personnel to load, produce, and modify large number of documents in kCura’s Relativity SQL Server Database.
• Providing leadership and guidance to senior programmers in building software tools to meet DOJ’s loading and production requirements.
• Successfully migrated metadata of 4 million+ documents from third-party vendor database to Confidential 's OMEGA document repository application.
• Successfully led the development and deployment of solution to enable document coding at three different locations in Washington DC and New Orleans resulting in cost savings for the Department of Justice.

Developer | Consultant

Confidential,McLean, VA

• Consulted primarily for Confidential / DOJ client.
• Provided analytical and data architecture support in the creation of Document Tracking application; developed web application modules using Oracle JDeveloper 10g.
• Created numerous summary Litigation Claim reports using Oracle Web Portal.
• Developed MS Access databases, data entry forms, and QA Reports; coded scripts to export data into excel file format for Hurricane Katrina Litigation Return Mail and Privilege Review Project.

Data Warehouse Engineer

Confidential,Herndon, VA

• Developed SQL scripts and PL/SQL programs in UNIX environment to support data audit activities across various Oracle databases.
• Supported data warehouse production fulfillment system by analyzing and producing SQL, PL/SQL, and Perl scripts for data manipulation and data inconsistency resolution.
• Provided tier-3 and critical support to advanced Technical Support staff on corporate escalations and quality assurance requests.
• Extended support for database design, development schema setup, and database migrations for quarterly and off-cycle releases.

Data Management Specialist

Confidential,Herndon, VA

• Resolved data inconsistency issues for Confidential affiliate.
• Developed Oracle packages, stored procedures, functions, views, and triggers utilizing SQL and PL/SQL programming language to generate analytical and ad hoc reports using Quest's SQL Navigator on a daily basis.
• Performed periodic audits to ensure accuracy and efficiency of data in application tables by generating analytical reporting tools to identify behavioral trends and preliminary campaign criteria.
• Implemented Oracle database test environment to test program scripts and data loads, this involved installation of Oracle 10g, setting up Oracle Apache Database Access Descriptors, physical and logical storage planning, and recovery from a cold back up copy.
• Monitored the marketing application performance and physical growth of tablespaces and data files.
• Served as liaison between users and technical staff.
• Successfully built ETL applications to load 15 million+ records from 57 Confidential affiliates on a monthly basis to build 8-million piece national marketing strategies.

Database Manager | Developer

Confidential,Reston, VA

• Designed and implemented Oracle Web Application from concept to deployment.
• Analyzed existing information resources, designed new information architecture, and implemented an Import/Export Web Application using Apache and Oracle technologies including Oracle's mod PL/SQL.
• Converted a legacy database to Oracle 10g; established database backup and recovery strategies.
• Documented system architecture and maintenance procedures; created customized reports and intranet content for national and international clients.
• Managed the company's enterprise data warehouse (over 20 million records), intranet/extranet applications, and all information resources.
• Provided database and technical support to the organization's market research and strategy consultants.