We provide IT Staff Augmentation Services!

Data Architect Resume

2.00/5 (Submit Your Rating)

SUMMARY:

  • Highly accomplished System Engineer, Business System Analyst, Business Intelligence, Business Processes with excellent experience as a Project Coordinator, designing, developing, analyzing, testing, integrating, implementing and managing numerous database systems (ie., SharePoint Developer/Integrator, Oracle 11g, MS SQL Server/SSIS, SSRS, SSAS COTS and GOTS).
  • Broad - based knowledge of Business/Functional Requirements, Practices, Processes, Systems and Technical / General Business experience that has translated easily to a number of analysis and documentation of current systems/Recognized as a creative and effective troubleshooter with outstanding skills in communication and documentation.
  • Effective Leader, Facilitator, Manager, Coordinator, and Liaison that works well with a wide variety of personnel onsite, offsite and offshore. Able to analyze situations, prioritize tasks and manage multiple projects
  • Business: Requirement gathering / creating Standard Operation Procedures (SOP) manuals, Analyzing and documenting Business Processes / Conducting Systems Analysis, Use Case Development, BI Screen / Report design, User Interface Design, Business / Functional / Technical Specification development, Test Plan / Case development and Training / User Documentation
  • Leadership: Joint Application Development (JAD) / facilitate group sessions, delegation, consensus building, problem solving
  • Technical: Superb technical acumen with a wide variety of languages and software tools, including C#, Visual C#, C#.Net, VB 6.0, Java Script, Java, VB.NET, ASP.NET w/VS.Net, MS Access, MS SharePoint Developer 2007/2010, SharePoint Designer 2007/2010, Workflow Designer, SQL and PL/SQL
  • Communication: Presentations, demonstrations, documentation, staff training, liaison functions, information dissemination through multiple sources and across organizations/departments
  • System Development/Project Coordination: Analysis and documentation of current systems/Recognized as a creative and effective troubleshooter with outstanding skills in communication and documentation.

TECHNICAL SKILLS:

Development:  VB 6.0, Oracle 9i, Oracle 11g, Oracle/SQL DBA/SSIS, ASP.Net, ADO.NET, Visual C#.NET/VB.NET, Visual Studio 2003 (.NET), T-SQL, SQL Server 2000/2005, HTML, XML, KML, XSL, XSLT, MS Access, Crystal Reports XI/10/9, SQL Server Reporting, LINUX/UNIX

Software:  MS Visual Studio 2008/2010, SQL Server 2005/2008/SSIS/SSAS/SSRS, R2 Management Studio, MS Office, MS SharePoint Portal 2003/2007/2010 , MVS, TDDI, TRIM (EDMS), & FileMaker Pro Server, Software Development Process tools CMMI and RUP

Operating Systems:  Windows Server 2003, Microsoft Windows 2000/NT/9x, VMWare; Networks/Services NIPRNet, SIPRNet, JWICS, Stone Ghost, Global Command and Control System (GCCS), Web Enable Temporal Analytical System (WebTAS), VMWare

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect 

Responsibilities:
  • Provided technical consulting to the Air Force IT PMO contract to provide Reports, Interfaces, Conversions and Extensions (RICE) for the NexGen System
  • Developed Extraction, Transformation and Load (ETL) mappings from the existing legacy systems (ie.,Cobol, etc.) to Oracle database platform to support user interface to manage, monitor and provide reports for realty property assets
  • Designed and develop stragetic plans and SSIS ETL packages to migrate data from disparate data sources to SHARP production database platform to support an user interface in order to manage, monitor military litigated sexual assault cases
  • Designed and Developed SSIS packages for Data Migration from existing system to re-designed system
  • Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2005
  • Migrated SSIS packages from SQL Server 2005 to SQL Server 2008
  • Developed reliable ETL Packages by implementing Logging, Error Handling, and Checkpoints
  • Optimized SSIS package performance to reach the expected timeframe for data loading
  • Worked on all phases of data warehouse development life cycle, from gathering requirements to testing, implementation, and support using SSAS
  • Developed Complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs
  • Created Stored Procedures, User-Defined Functions, Triggers, Cursors, and Views.
  • Designed and deployed Tabular, Matrix, Chart, Linked, Drill-down, and Drill-through Reports with drop down list of parameterized options in SSRS
  • Developed reports on SSAS Cubes as data source
  • Configured Report Server and SharePoint, and Deployed SSRS Reports, Report Models, Shared Data Sources to the Document Library of SharePoint
  • Actively involved in brainstorming discussions on design, development, and implementation of Business Intelligence and Database
  • Dedicated SSIS consultant to build new packages and convert DTS packages
  • Created mission critical SSIS packages - extracting, transforming and loading complex flat files from mainframe data of clients that had huge number of records with varied lengths
  • Applied various data transformation tasks like Slowly Changing Dimensions, Multicasting, Conditional Split, Derived Column and all other transformations available in the SSIS toolbox
  • Created and used variables and expressions and wrote scripts in script component task
  • Scheduled jobs for executing SSIS packages and processes to function orderly and smoothly in multi-user environment
  • Designed facts and dimension tables and defined relationship between facts and dimensions with Star Schema and Snowflake Schema in SSAS
  • Developed, modified and optimized complex queries to data retrieval and modification
  • Involved in Performance tuning, optimization of stored procedures and queries
  • Created various management and analytical reports using SSRS
  • Met with SMEs, end-users, software developer and network engineers to assess and document the technical and functional data requirements in order to sanitize and migrate legacy data across multiple systems to oracle database platform 
  • Developed and refined the SQL/Business Rules that are used to in the data framework layer to move data from multiple legacy systems into the COTS native Oracle database infrastructure based on system and data requirements. 
  • Collaborated with RICE Team members to decompose documentation and project scope related to SQL Business Rule task.
  • Met with RICE Team members (Lead Architect, Systems Engineers, etc.) to discuss and review the project requirements and status/progress and Way-Ahead  
  • Analyzed the Oracle data pump load process in order to improve and optimize the automated process to retrieve the tablespace, schema and table name for every table in the Oracle Data Pump Export file.
  • Configured and developed a data migration environment in the Oracle platform by establishing multiple Staging and External Tables definitions for the Data Architecture and mappings between COBOL and Oracle Datatypes.
  • Met with stakeholders and users to discuss business processes and gather requirements
  • Designed and Developed custom C# SharePoint 2010 WebParts, Workflows, Event Receivers, Scheduled Timer Jobs, and Branding
  • Designed and Developed custom SharePoint 2010 applications using SharePoint Designer and Visual Studio 2010
  • Created custom SharePoint 2010 applications using InfoDesign and Develop Microsoft Office SharePoint applications using C#
  • Upgraded SharePoint 2007 Intranet and Public site to SharePoint 2010
  • Designed and Developed custom branding project for SharePoint 2010 InfoPath and C#
  • Configured web services and excel services to manage monthly reports

Confidential, Ft Meade, MD

Systems Engineer/Web Developer - Active TS/SCI w/CI Poly Clearance

Responsibilities:
  • Provided technical support to improve processes and systems by assessing and decomposing inadequacies and inefficiencies of current business processes and systems and established an interoperability enterprise content management system
  • Assisted government Knowledge Management (KM) and Requirement Management (RM) personnel with gathering and quantifying user requirements to develop a scope of work for web application development for US Cyber Command personnel
  • Met with business and functional representatives to assess and decompose workflow and data requirements
  • Supported, maintained and upgraded existing web applications and databases 
  • Collaborated with stakeholders and end-users to understand business processes and workflows to gather requirements to develop enterprise web applications capabilities using ASP.NET and SQL Server to manage and monitor sensitive data gathered for data warehousing of multiple agencies network information and other personnel management system.
  • Assisted with the design and development of prototype constructs using Windows Professional Foundation (WFP) to standardize and quicken application development for deployment
  • Designed and developed ASP.Net C# applications using MS Visual Studio 2008 to create and manage various objects and components (e.g, classes, references, aspx/aspx.cs (e.g, .Net Web Forms, Code Behind UI Logic), acsx pages (e.g, web server controls, user controls), web services, sql datasource configurations, tables and stored procedures using (SQL Server 2005), etc.) for Cyber Command directorate personnel
  • Developed, customized and integrated new and existing web pages/portals to support various directorates and cross-cutting enclaves for collaboration using MOSS 2007/ 2010 SharePoint Designer 2007/2010 and WSS 3.0. which included:
  • Inserting Text, ScreenTips and Hyperlinks
  • Inserting Web Components
  • Inserting Images
  • Add Client-side interactivity
  • Creating table layouts
  • Modifying Default Page and Page Layouts
  • Inserting Web Part Zones
  • Creating List View Web Part
  • Creating Data Views
  • Working with Data Sources
  • Inserting and modifying server controls in web pages
  • Customizing Master Page
  • Creating and modifying Cascading Style Sheets (CSS)
  • Managing Web Content
  • Creating and modifying multi-step workflows
  • Configuring and identifying Contributor settings
  • Integrate multi-sites using Windows SharePoint Services 3.0
  • Creating reports
  • Developed system back-ends using SQL Server and ASP.Net web services
  • Operated as a systems analysts by providing technical support in developing new capabilities and maintaining and troubleshoot legacy systems for the Cyber Command
  • Assisted in a technical consulting role by assessing and including cross-cutting sections requirements within the Cyber Command and other agencies to develop an interoperability enterprise infrastructure to support the Global Information Grid (GIG)

Confidential, Washington DC

Systems Engineer - TS/SCI Clearance

Responsibilities:

  • Installed and upgrade SQL server and application tools
  • Managed and allocated system storage space and plan future storage requirements for the database system
  • Establish connectivity to various disparate database platforms
  • Created primary database storage structures (tablespaces) to support user requirements for integration to the analytical system
  • Created primary objects (tables, views, indexes) to support user requirements for integration to the analytical system
  • Modified the database structure, as necessary, from requirements provide by analysts
  • Enrolled users and maintain system security
  • Ensured compliance with your SQL Server license agreement
  • Controlled and monitored user access to the database
  • Monitored and optimized the performance of the database
  • Performed back-ups and restored the database
  • Prepared briefs and training material to communicate and train government and military personnel

Confidential, Tampa, FL

Systems Analyst V/Programmer - Active TS/SCI Clearance

Responsibilities:
  • Operate as the technical project lead to implement a JTIC-Certified, 5015.2 Compliant Electronic Records Management (ERM) system to support coalition command military work-centers for 5000 users on the NIPR, SIPR and JWICS networks
  • Gathered business and functional requirements from various organizational departments in order to architect, configure and implement an integrated enterprise content management system
  • Met with key stackholders, SMEs, end-users, network architects and developers to document and obtain approvals for Business and Technical Requirements for enhancements to existing systems
  • Identified and designed the system architecture of an end-to-end hardware/component collaboration system
  • Configured and integrated the enterprise content management web part with Microsoft Share Point Portal.
  • Identified and configured Software Development Kit (SDK) package to integrate with COTS capabilities
  • Performs various TRIM Administrator tasks as needed (e.g, System Performance and Monitoring tools)
  • Planned, implemented, tested, documented, and maintained solutions for the integration and testing of in-house developed and COTS/GOTS components as USCENTCOM appointed Electronic Information Systems Manager
  • Provided functional and technical standard operation procedures, troubleshoot hardware/software interface problems, defined and tested input/output parameters, and established integration configuration of the enterprise content management system
  • Identified and documented security and risk impact to implement an enterprise content management system across multi-network infrastructure
  • Identified the hardware and logical architectural security design to support releasable and non-releasable data in a shared secured environment
  • Analyzed and designed standards to implement a centralized enterprise content management system to support various work center requirements
  • Configured centralized enterprise content management system to secure records and content using access controls
  • Designed and developed technical user manuals and end-users interactive training presentations to train 5000 users
  • Designed and configured various logical file plan structures for directorates and organizations which enabled trained File Custodians manage and access records and information seamlessly in the virtual electronic records management environment
  • Trained end-users to function operate logical enterprise management content structures to manage records, documents and content per work center for the Command
  • Create various automated processes with stored procedures and triggers.
  • Install and upgrade SQL server and application tools
  • Manage and allocate system storage space and plan future storage requirements for the database system
  • Create primary database storage structures (tablespaces) after application developers have designed an application
  • Create primary objects (tables, views, indexes) once application developers have designed an application
  • Modify the database structure, as necessary, from information given by application developers
  • Enroll users and maintain system security
  • Ensure compliance with your SQL Server license agreement
  • Control and monitor user access to the database
  • Monitor and optimize the performance of the database
  • Plan for backup and recovery of database information
  • Maintain archived data on tape
  • Back-up and restore the database
  • Contact Microsoft Corporation for SQL Server technical support

Confidential, Washington, DC

Business Systems Analyst V/Programmer - Secret Clearance

Responsibilities:
  • Met with key stackholders, SMEs, end-users, network architects and developers to document business processes and current systems architecture functionalities for the development and inclusion of the Vessel and Cargo Characteristics system
  • Developed and implemented Department of Transportation/Army Corps of Engineers Vessel Management System, Census Cargo System and Schedule K System. Created relational database repositories, search engines, and report menus. Built and deployed research and file update modules.
  • Designed Data Integration Oracle Portals as Oracle DBA used to transport data between relational database systems and Oracle back-end for data warehousing
  • Designed and create stored procedures in Oracle for creating tables and manipulating data.
  • Automated numerous vessel movement workflow processes for greater efficiency.
  • Designed automated processes to store and correct anomalous data to monitor and report vessel movement and cargo activities
  • Applied appropriate problem-solving methodologies to the analysis and develop solutions of Corp database system problems.
  • Developed a multi-function, in-production system that assists in tracking and monitoring of vessel movement and cargo characteristics for the US Confidential and US Maritime Administration.
  • Install and upgrade Oracle server and application tools
  • Allocate system storage and plan future storage requirements for the database system
  • Create primary database storage structures (tablespaces) after application developers have designed an application
  • Create primary objects (tables, views, indexes) once application developers have designed an application
  • Modify the database structure, as necessary, from information given by application developers
  • Enroll users and maintain system security
  • Ensure compliance with your Oracle license agreement
  • Control and monitor user access to the database
  • Monitor and optimize the performance of the database
  • Plan for backup and recovery of database information
  • Maintain archived data on tape
  • Back-up and restore the database
  • Contact Oracle Corporation for technical support

Confidential, Washington DC

Computer Specialist/Programmer

Responsibilities:
  • Met with key stackholders, SMEs, end-users, network architects and software developers to document and obtain approvals for Business and Technical Requirements for development of a centralized multi-user system Collection Management System to capture, store, manage and deliver records and content to support centralized workflow and processes for departmental team (e.g, records management, reference and statistics, preservation, and arrangements and description).
  • Developed secured environment to enforce end user permissions and restriction of sensitive information.
  • Earned Smithsonian Institution Outstanding Performance Awards, 1999 and 2000.

Confidential, New York, NY

Database Systems Developer

Responsibilities:
  • Met with key stackholders, SMEs, end-users, network architects and developers to document and obtain approvals for Business and Technical Requirements for the development and implementation of a Meeting Planning - multi-user system to manage events and generate various types of reports
  • Created budgetary calculation analysis solutions for client transaction activity.
  • Streamlined workflow through automation, standardization, and centralization.

Confidential, Anchorage, AK

Information Management Specialist/Programmer

Responsibilities:
  • Developed procedures to review and approve sensitive equipment information.
  • Identified and designed IT solutions integration across enterprise network infrastructure
  • Designed and programmed relational-database systems for remote stations
  • Met with key stackholders, SMEs, end-users, project managers, engineers and technicians to document and obtain approvals for Business and Technical Requirements for deployment of new systems to manage and monitor project information

We'd love your feedback!