Application/data Architect Resume
0/5 (Submit Your Rating)
Alexandria, VA
SUMMARY:
- Senior IT Professional with 20+ years of experience in Information Technology.
- Masters in Cloud Computing Architecture, PMI Certified Project Management Professional, Oracle 12c Certified Professional.
- Extensive experience as a Data Architect, DBA, Technical Architect as well as an expert in Tuning Oracle based systems on Oracle 12c, 11g, 10g.
- Seasoned Project Manager with experience from Initiation to Closing in a multi - site development (off-shore/on-site) model.
- Experienced software developer using various technologies like Oracle Apex, Oracle 10g/11g Forms/Reports, Oracle PLSQL.
- Worked in a structured environment following various Software Methodologies like SEI-CMM (CMMI), ISO-9000, and Six Sigma and Agile methodologies for leading Fortune 100 clients like Confidential, Confidential, Confidential and Confidential - Department of Defense (DoD), Food and Drug Administration (FDA).
PROFESSIONAL EXPERIENCE:
Confidential, Alexandria, VA
Application/Data Architect
Responsibilities:
- Built and documented Architectural Standards, Guidelines and Best Practices for the division.
- Responsible for Standards on: Database Partitioning, Database Views, Database Links, Data Replication for the Branch.
- Built Implementation Guidelines and Standard for implementation of National Information Exchange
- Model (NIEM) data exchange with other agencies/departments.
- Built Data Models and Application Architectural artifacts using Sparx Enterprise Architect.
- Develop and enforce data modeling standards and best practices.
Confidential, Alexandria, VA
Data Architect/Enterprise Architect
Responsibilities:
- Built and documented the Operational Framework within the organization. This involved interviewing the business owners, building the process models, documenting the framework using DoDAF framework deliverables.
- Built, documented and presented a Draft Cloud Migration Strategy for the DHRA Enterprise.
- In an Advisory role offered technical solutions/recommendation to the CIO’s office.
Confidential, Rockville Maryland
Database Administrator/Developer
Responsibilities:
- Performed Oracle database administration tasks including configuration management, backup/recovery, performance optimization, and space management.
- Provided development and design assistance to development and other application support teams.
- Development of Batch Processing of Packages/Procedures in PLSQL.
- Performed database tuning, application tuning and performance monitoring.
- Lead and coordinated with cross functional Agile Teams for Releases of software in various environments - Development, Test, Pre-Production and Production.
Confidential, Rockville Maryland
Lead Architect
Responsibilities:
- Conceptualized, Designed and Implemented critical applications for the Center namely BITS-PTS (Pre-Submission tracking), BITS-COMP (Complaints and Inspections tracking), BITS-URVR (Blood Requalification and Variance and Requests), BITS-CATTS (Centers Time Tracking System), BITS-ABC (Animal Biologics) in Oracle Application Express.
- Built data models and application prototypes for approval from stakeholders.
- Designed and Configured the Security module of the application based on the FDA security standards.
- Managed and Monitored Development Team to ensure high quality of software on schedule.
- Planned, Coordinated and Scheduled deployment of deliverables using Agile Methodology.
- Performed Oracle database administration tasks including configuration management, backup/recovery, and space management on multiple instances in various environments.
- Provided development and design advise to development and other application support teams.
- Monitored Production database batch job processes.
- Performed performance optimization and tuning on databases for specific performance issues.
- Conducted Database migration from 10g to 11g, 11g to 12c in an Exadata environment.
- Part of the team responsible for the implementation of a pilot Golden Gate Replication Software.
- Lead and coordinate with the Application Development team for Releases of software in various environments - Development, Test, Pre-Production and Production.
- Developed conceptual and logical information models within the context of the Center’s Enterprise Information Architecture.
- Reviewed the mapping of data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality. Collaborated with Application project managers, address data related problems in regards to systems integration and compatibility, as well as act as a leader for addressing data related issues.
- Ensured that the appropriate standards and guidelines are used to develop the information models and database designs.
- Worked with the DBA to transform the logical information model into a physical database design for the targeted database.
- Developed and Maintained data architectural artifacts.
- Built Models for data exchange across FDA Centers or external agencies like NIH or CDC.
- Worked on RMS-BLA system which supports CBER’s Managed Review Process for the review and approval of applications for biological derived drugs, blood products and devices that are regulated by CBER. This was an Oracle 6i Forms and Reports system which was migrated to Web based Forms/Reports 10g based system.
- Creating database packages/procedures/triggers/views for the applications based on the requirements.
- Maintenance/Enhancements of Forms/Reports for each release.
- Designed and implemented the XML based interface for the eCTD Submissions of RMS-BLA/BIRAMS for the GS Review tool used by the Reviewers FDA wide.
Confidential, Herndon VA
Application DBA
Responsibilities:
- Provided PMLT users with a web-based application to manage and track the properties that Nextel owns through the U.S. Software was designed in Oracle 9i, Oracle 9iAS, and web server technologies. As an Application DBA was responsible for data modelling, development of stored procedures and packages in PL/SQL. This involved writing scripts for creating database objects-which included tables/views/indexes/sequences/packages, creating design documents, and promotional packages for moving the software from Development to Test/Pre-production and production environments.
Confidential, Rochester Hills MI
Project Leader/ DBA
Responsibilities:
- Lead a team of developers and DBA’s to create a web-based application which allowed clients to manage and track their cases with Immigration and Naturalization Services. As a Project leader and DBA, was responsible for gathering user requirements, creating the logical and physical database design, managing the development team, managing and scheduling staged releases in the production environment.
Confidential, Dearborn MI
Project Manager
Responsibilities:
- Developed a web site for the company which could be accessed by clients, new media, and employees from their 14 branches. As the project leader, worked to design the high-level system and design specification, wrote requirements in the form of use cases and use case specifications, designed the database and object model, budgeted time and cost estimates for development, monitored and managed the development work being done by the team in the offshore center at India, deployed and implemented the software in phases on schedule in the production environment.
Confidential, Dearborn MI
Team Leader
Responsibilities:
- Responsible for the design of the systems architecture, wrote system and design specifications for the Automobile Manufacturers Loyalty Management Program. Created the logical and physical database design using Oracle Designer, carried out time and cost estimates for development, trained junior developers and monitored and managed the development team.
Confidential, Cincinnati, OH
Oracle Developer
Responsibilities:
- Worked on a system designed for the consolidation of the statistical data pertaining to heavy vehicles coming from the manufacturers, and other agencies for the publications generated by the company. Involved in the speedy implementation of the project and the optimization of the entire application for better response time for the users.
Confidential
Team Leader, Developer
Responsibilities:
- The technologies for these assignments were Oracle Developer 2000, Designer 2000, Data warehousing tools using Oracle technology and Ingres Database.
