OBJECTIVE:

I am a System Architect / Database Engineer / Oracle Consultant / Database Architect / Project and Technical Lead/Manager with approx. 15 years of experience in Database Design, Programming and Analysis of Database Information Systems. I am interested in using and improving my skills in a positive and high energy environment.

TECHNICAL SKILLS:

• Oracle 12c, 11.2g, 10g to 7
• Microsoft SQL Server 2012 to 2008
• PostGres 9.2.3, MySQL 5.0, Informatica 9.0, SQL Loader
• SQLPlus, PL/SQL, T - SQL, Packages, Procedures, Functions, Triggers, Database Design, Administration and Management
• Oracle Forms, Reports, Developer 2000, SSIS, SSRS, SSMA
• Designer 2000, CA Erwin Data Modeler, Embarcadero ERStudio Data Architect, IBM’s Rational Data Architect, Visio
• Oracle Enterprise Manager(OEM), TOAD, SQL Developer, SQL Navigator
• Microsoft Office: Word, Excel, Access, PowerPoint, Publisher, Outlook, Project
• Windows NT/2000/2003/XP, UNIX
• MKS Source Integrity, Visual Source Safe, Tortoise versioning, CVS versioning
• C++, C#.NET, VB.NET, ASP.NET, DBASE IV, COBOL
• CorelDraw, Photoshop, PageMaker, AutoCAD

DATABASE WORK EXPERIENCE:

• Database Management: Data Governance, Data Quality and Integrity, Master Data Management, Rules and Validation, Data Migration and Transformation, ETL
• Database Design: Architecture, designing, installation and configuration of the database, Design and Programming of the Database Access Layer
• Data analysis: Database conceptualization based on internal or external customer input I
• Database modeling: Generated conceptual, logical and physical Database Models. Reverse engineered source databases from varied platforms to a physical model to facilitate transportation between compatible target platforms.
• Database Security: Implemented views, Row level security (RLS/FGAC), DBMS obfuscation and data encryption, PL/SQL wrapping, roles and privileges and other security policies to enforce database security.
• Data Migration: Loaded and extracted data and from various sources (text file, ASCII files, excel spreadsheets, MS-Access, XML) using SQL Loader, data conversion tools and xml functions. Migrated data from other relational databases like MySQL, SQL Server using external vendor tools like Data Loader and PostGres using tools like PostGres Plus Advanced Server’s Enterprise Migration Toolkit.
• Performance Tuning: Tuned queries using Explain Plan. Analyzed query performance before and after the use of indexes. Generated statistics for database objects and made recommendations based on optimizer statistics and planner feedback.
• Database size: Worked with large databases greater than 4 Terabytes.
• Database Programming: Created, modified and deleted tables, views, indexes, clusters, synonyms, sequences, procedures, functions, packages, triggers and other database objects. Programmed using SQL, PL/SQL to select, create, update and delete data. Generated forms and reports.
• Quality Analysis and Testing: Created use cases to test database integrity and work flow as designed.
• Project Management: Created project plans, timelines, baselines, and work assignments. Worked with team members and across teams to enable timely execution of deliverables and work items as per project plan.
• Agile SDLC development: Used iterative and/or waterfall methods to plan database developmental work to fit project requirements and styles. Worked with client’s/business users to identify business requirements and technical requirements and prepared Functional and Technical documentation, Test case scenarios, User defined forms and reports and database documentation

PROFESSIONAL EXPERIENCE:

Confidential, Charlottesville, VA

Database Architect/Tech Lead

• Worked as the Sr. Database Architect/Modeler/Developer/Technical Lead n CBRNE (Chemical and Biological, Radiological, Nuclear, Explosive for Statistical and Meta-Analysis of Realistic Threats) Project-Phase I to stage data for migration between Oracle and Oracle, Oracle and SQL Server and MS-Access and SQL Server using tools like SQL, PL-SQL, T-SQL, SSMA (Access and SQL Server 6.0), SSIS packages and stored procedures and functions.
• Directed and facilitated work across cross functional teams and assisted with ensuring timely completion of project tasks. Designed target databases and reports for the client and the complete migration process. Interacted with front end users to assist with planning for web applications and design.
• Responsible for creating specifications for the Functional and Technical design of the database programming layer as well as the Database documentation. Created the foundation procedures and functions required by the web programs that selected data for Phase I.

Confidential, Richmond, VA

Information Technology Specialist II / Data Architect

• Designed and developed a new Cardinal system to house data for VDAC’S new vendor related information.
• Extract, Transform and Load data from various sources into the new Cardinal system from VDACS cardinal data providers. Create processes and forms to validate and view vendor extracts.
• Create process to reconcile data based on monthly vendor extract report submissions.
• Create summarized reports based on that data and executive information forms and reports based on requirements.
• Analyzed business requirements and transformed them into Functional and Technical specifications. Designed sub systems to handle transactional data and historical data. Also improvised existing systems and improved their performance using performance tuning on existing objects and programs.

Confidential, Richmond, VA

Sr. Systems Developer / Systems Analyst

• Modified/Reviewed/Created existing/new designs for PPD’s Sample Management System, ASSIST and other related systems using tools like Oracle Forms and Reports.
• Migrated data from other systems within PPD and client sources, to ASSIST, using existing tools, as well as developed new tools and programs, wherever necessary. Principal system architect for the new system of reporting for the sample reporting functionality.

Confidential, Richmond, VA

Sr. Database Developer / Technical Architect / Data Architect

• Analyzed, designed, developed, tested, and implemented efficient solutions involving diverse platforms, software, technologies and tools.
• Provided complete technical management and leadership on large IT initiatives
• Accountable for effectiveness, quality, and timeliness of project design decisions in line with Enterprise wide Technical Architecture (EWTA)governance.
• Consulted business at the highest technical level on all phases of SDLC.
• Worked with management to identify and specify extremely complex business requirements and processes.
• Researched and evaluated alternative solutions and delivered proposals that met business needs.
• Analyzed existing systems against IT and business strategies and made well-defined recommendations
• Acted as expert technical resource to others on new technologies and design techniques
• Defined and managed technical standards including coding, testing, and methodology for team in accordance with EWTA governance.
• Designed and architected new systems or major enhancements to existing systems.
• Reviewed physical and technical designs of systems
• Provided regular, constructive feedback, guidance, and support.

Confidential, Roanoke, VA

Sr. Database Architect

• Established the database environment, classes, entities, programming objects, database programming layer and naming standards for the project areas for which they were assigned
• Managed issue identification and problem resolution process
• Addressed systems development and integration issues
• Created a prototype as part of design and estimation efforts
• Conducted code reviews on various sprints in the iteration
• Researched ETL tools and RDBMS to fit project requirements and finances
• Integrated test plans and conducted testing on assigned integration threads
• Production Staging, Launch, Piloting and Post Implementation assignments as required
• Populated the development, QA and staging environments with appropriate test data from AAIA
• Build bulk data load software for centralized EPC databases and/or data push software for Store databases
• Responsible for database security in the development and test environments
• Submission of reports on disk capacity estimates and database physical design information
• Monitored resources including CPU usage and space utilization in the development and test environments
• Executed and optimized queries on behalf of the development team and the business users, identifying potential barriers to project success and offering proactive solutions that align to the culture and operating model of the Company and the project team

Confidential, Roanoke, VA

Database Developer / Engineer

• Conducted regular and baseline upgrades and testing on the core database both local and client, including changes to the design, documentation, data conversions, query optimization, data modeling and performance tuning during various upgrade cycles.
• Helped in migrating of the RDBMS to the recent database versions (Oracle 9i to 10g to 11i and SQL Server 2005 to 2008), as well as data migration.
• Also been an integral part of customer database upgrades including (error identification, rectification, importing and processing data from xml files to improve the upgrade performance, monitoring and reporting.
• Programmed simultaneously in SQL, TSQL and PL/SQL to support applications on dual platforms.
• Identified problems, created tasks, work items, determined work assignments and recommended problem resolutions
• Monitored performance and grid locks to assist in smooth conduct of operations.
• Researched software and other products to solve current and future needs of the organization. Studied trends and emerging technologies that could affect growth and future direction of the organizational needs and goals. Conducted a study on cloud computing to determine changes that may need to be effected to promote the migration of existing technology in this direction.

Confidential, New Carrollton, Maryland

Oracle Consultant

• Migrated XML type data from staging tables to the main database
• Performance tuning of data
• SQL and PL/SQL programming
• Used tools like Designer, TOAD, SQL Developer, Developer suite and Beyond Compare.

Confidential, Blacksburg, Virginia

Database Engineer / Administrator / Project Lead

• Assisted Lead Scientist in Proteomics project management tasks in the capacity of a Project Manager by working with software designers and research scientists by being an integral part of the SDLC of the project. Created baselines/timelines, requirement documents, held meetings and follow ups to manage the project.
• Developed, maintained and monitored databases using tools like ERWIN and OEM
• Migrated data from flat files, tab-delimited, XML files to oracle.
• Scheduled regular exports, imports, data pumps, hot and cold backups
• Conducted regular study of data storage, usability, audit, performance statistics
• Created schema and schema objects like tables, views, packages, procedures, functions and triggers, and rules like roles and privileges
• Designed the data access layer using SQL and PL/SQL programming
• Used tools like TOAD and Microsoft Project.
• Other DBA and oracle programmer related activities

Confidential, Roanoke, Virginia

Programmer Analyst

• Worked on Modernization of existing applications by moving them to a .NET platform using C#, ASP.NET, VB.NET.
• Analyzed various Systems and designed numerous applications and programs for the Real Property Management system of the Department of Defense using Oracle 8i/9i, Macromedia-Authorware and MS-SQL server.
• Designed and developed The Interactive Timecard System (Payroll, Employee, Project records) using CASE Tools like Designer and Developer.
• Worked as the Lead programmer for the Real Property Inventory System - Phase I for the NAVY & Marine Coors with Oracle 9i and SQL Server as the backend RDBMS and Microsoft .NET as the interface.
• Developed an Interactive Computer Based Training for the Real Property Planning of US Military Installations using Macromedia Authorware.
• Designed, Administered and Managed Oracle databases (Performance tuning, Optimization, Planning, Exports, Imports)
• Creation and development of reports using SQL and PL/SQL (Packages, Procedures, Functions and Triggers).

Confidential, Richmond, Virginia

Graduate Assistant (Administrative Assistant / Summer Intern / Database Administration

• Analyzed, Designed and developed an EIS system for the Graduate Admissions Office at the University
• Planned and executed project to effect Query optimization, security and concurrency control on Oracle databases.
• Designed web pages and brochures for the Graduate School of Business using FrontPage, PageMaker and Photoshop.
• Web integration of student databases, record processing and report management
• Processed student applicants for admissions and communicated with students and administrative departmental heads with reference all matters from application to admissions
• Performed secretarial duties and interacted with other departments within the university, for dissemination and procuring of vital information, correspondences and reports on a timely and ad hoc basis.
• Faxed correspondences, maintained cross functional departmental functions, interacted with local and international students, departmental heads and other clientele on a daily basis and attended to their needs and queries personally and through other means of social media.
• Scheduled and attended meetings, created presentations, arranged appointments, Created and maintained file systems, Letter writing, Created agendas
• Recruited, trained and supervised junior staff and delegated work as necessary.
• Event planning
• Supervised graduate student classes and labs for professors and created teaching and grading assignments for them
• Graded class assignments and assisted students during lab and prior to lab by being the prime administrator and supervisor of their accounts
• Worked on many school projects with students and professors that involved team work.