We provide IT Staff Augmentation Services!

Senior Data Architect Resume Profile

5.00/5 (Submit Your Rating)

VA

OBJECTIVE:

To further career accomplishments as an Enterprise and Data Architect in a challenging business and technical environment requiring complex problem solving and to be the consultant of choice to my clients.

CAREER ACHIEVEMENTS:

  • Specialization as Enterprise/Data Architect for 25 years in an IT career spanning 34 yrs. Technical, managerial and consulting expertise for the design and build of logical OLTP/OLAP/knowledge based databases and object oriented repositories and migration to physical data storage. Utilization of OMB and GSA blueprints using compliant frameworks, tools, and orientations to include FEAF, FSAM, DoDAF/C4ISR, TOGAF, Zachman, CMMI, Information Engineering.
  • Define and build the core components of Enterprise Architecture, specifically, the business, application, information, technology architectures, processes and tools for solutions, and establishing the governance to ensure alignment during IT transformation and solution implementation.
  • Establishment of standards for database design, interface specifications, data convergence/ migration ETL , master data management MDM , source integration, data services within SOA, data strategy, data normalization, data governance, metadata management, error detection/correction, data consolidation, storage, distribution, governance, capacity planning, and risk management.
  • Adept at integrating Enterprise Resources Planning and COTS components to include product planning, purchasing, inventory maintenance, interfacing with suppliers/customers, order tracking, finance, and human resources/payroll/personnel with transactional or data warehouse databases.
  • Current on hardware platform technologies, CRM/ERP/BI/ETL/HR/financial applications and architectural tools.
  • Excellent communication skills including training/mentoring /presentation.
  • Granted Treasury/MBI, DHS/Public Trust, and active TS/Secret DOD/DOJ clearances.

DISCIPLINES:

  • Software: CRM: Siebel, SAP, Oracle Financials, PeopleSoft Financials, Pansophic/TELON, Teamwork, PVCS, Texas Instruments/IEF, McCormick Dodge/Financials, Human Resources, and Tools, , KBSystems/KBASE, Popkin/System Architect, CSA/Silverrun, SQL Financials, Sybase/System Designer, ERwin,BPwin, ERStudio, Cognos, Business Objects, IBM/Rational Rose, RequisitePro, SoDA, Clear Case/Quest, DOORS, Documentum, Crystal Reports, MEGA, Provision, Sparx Enterprise Architect
  • DBMS/Languages: Teradata, Oracle9i/10g, PL/SQL, CICS/VSAM, DB2, IMS DB/DC, IDMS, COBOL, Fortran, Assembler, Basic, Pascal, PL/I, Resource Description Framework/XML, IDEFx
  • Methodologies: Object Oriented Design, Information Engineering, Structured Analysis/Design, Joint Application Development JAD , Rapid Application Development RAD , UML/Rational Unified Process RUP , DDS/DDW Inmon, Kimball , Zachman, C4ISR Architectural Framework, DoDAF, TOGAF, FEAF, NIST Standards IT, Biometrics
  • Development Tools: TSO/ISPF, SPF/PC, Panvalet, Librarian, Easytrieve, SAS, JCL, IBM Utilities, DBAccess, Syncsort, WordPerfect, Word, Project, Visio, Powerpoint, TOAD
  • Training: CICS, DB2, IDMS, VSAM, Yourdan DeMarco Structured Analysis/ Design, Tandem Non-Stop/Non-StopII, TI/IEF Boot Camp, Pansophic CASE, Library, and Productivity Products, PowerBuilder, OOD/UML/Rational Rose, Project Management, Appian Enterprise BPM
  • Applications: Intelligence, Defense, Human Resources, General Ledger, Billing, Accounts Receivable/ Payable, Telecommunications, Health Care HL7 /Patient Accounting, Transportation, Aviation, Manufacturing, Insurance, Education, Banking, Securities, Federal/State/Local Governments, Agriculture, Taxation, Financial/Mortgage Banking, Pension Administration, Publishing, Acquisitions and e-Commerce/Retail.

CONSULTING CLIENTS PROFESSIONAL EXPERIENCE:

Confidential

Financial Crimes Enforcement Network FinCEN

Sr. Data Architect providing resolution of data architectural issues, identify and structure data to support probabilistic and deterministic search approaches used be SAS applications. Support agency's mission to safeguard financial systems from illicit use, money laundering, and promote national security.

Confidential

Sr. Systems Architect providing architectural vision and design to modernize the client's incident reporting applications via communicating the technical needs, opportunities, and constraints. Lead on systems design, architecture and integration and offered design leadership before execution to define strategy, solutions, and architecture services to minimize risk and manage tradeoffs as they pertained to key system components, interfaces, infrastructure, and communications.

Confidential

Data Warehouse/Business Intelligence Architect responsible for the recommendation of current and future management of corporate analytics. Developed strategy to incorporate Enterprise Architecture and Information Architecture for inclusion of IT modernization initiatives.

Confidential

Sr. Data and Business Architect responsible for developing agency's segment architecture supporting the overall agency Enterprise Architecture. Involved in new development, ongoing review of current models, the development of best practices, policies and procedures, submission of architecture artifacts for compliance with DHS and creation of BRM, TRM, and DRM components. Utilized Erwin and iGrafx in an Oracle, IDMS, and Siebel environment.

Confidential

Sr. Data Modeller responsible for the design of the enterprise logical/physical model for the Civilian Information Services Division supporting tactical/strategic goals. Provide recommendations for architectural improvements and the implementation of data management strategies. Supported customer application requirements for physical table design changes. Utilized ERStudio and TOAD in an Oracle environment.

Confidential

Application Relocation Manager responsible for ICE data center migration. Developed communications infrastructure logical diagrams, relocation plans and migration strategy for 64 applications as part of major agency consolidation effort. Coordinated application cutover activities with technical, business and management staff.

Confidential

Sr. Enterprise Architect responsible for the development of the architecture at the enterprise level and authored the Enterprise Transition Strategy in conjunction with agency OCIO. Refined the technology architecture strategy and process that aligned IT projects with business developed and implemented enterprise architecture governance developed EA artifacts at OCIO and program levels, including segment architecture methodology, business and technical processes and program management. Conformance to NIST standards, federal mandates and FEAF.

Confidential

SOA Architect responsible for the support of the Enterprise Continuous Monitoring Capability enterprise architecture as the unified framework for DOD and intel community. Work involved the articulation of data sources, data extraction, data storage, analytical processes to support monitoring requirements and presentation of data for decision support.

Confidential

Sr. Enterprise Data/Solutions Architect responsible for leveraging Enterprise Architecture principals and methodologies to enable Air Force CIO office evaluate and implement service delivery plans across organization. Design and build development processes and mechanisms to support client's strategy and development plans for services for compliance and accuracy. Tools utilized include Agilian and Sparx Enterprise Architect.

Confidential

Sr. Enterprise Data Architect responsible for the design and build of the enterprise logical data model using Erwin and Provision and its integration with corporate global strategy and policies. Assessed industry model for applicability, provided guidance, training, and authored governance documents in order to support a more agile, strategic IT vision, data management and data dependencies related to SOA, SaaS, and Data Warehousing. Focused domains included CRM, accounting/billing, merchandising, inventory and purchasing systems.

Confidential

Sr. Enterprise Data Architect responsible for the integration and design for the Aeronautical Information Model AIM standard under NextGen. Responsibilities included analysis/design for the Aeronautical Information Exchange Model AIXM utilizing UML/Rational Rose, System Architect, SOA, DoDAF component views to support the global air navigation data and exchange format to accommodate GML, WXXM and ICAO standards, industry requirements, and civilian/military aeronautical data. Support provided for XML schemas for electronic transmission for system to system interchange.

Confidential

Sr. Enterprise Architect responsible for the support of the FEA Federal Enterprise Architecture initiative providing analysis and design support utilizing the MEGA tools and repository. Established guidelines for systems architecture, capacity planning, and security policies. Ensure NIST SP 800 compliance for networks, endpoints, web applications , end users by providing explicit proof of compliance and associated documentation and compliance to NEIM dbms standards.

Confidential

Sr. Enterprise/Data Architect responsible for reengineering client's federal acquisitioning of process and services using business process management tools. Utilized Appian Enterprise BPM. Facilitated security policies and system level standards archiving strategies, and quality standard guidelines for database deliverables within client's organization

Confidential

Sr. Enterprise Data Architect/Modeler responsible for the design, modeling, and implementation for business areas to support the corporate initiative of the Merchandising Systems Transformation project. Client environment utilized Erwin,Teradata, Oracle 9i. Implemented revised data maintenance policies, data migration and loading strategies and facilitated collaboration between business, management and technical team members. Business systems analyzed included sales, billing, accounting, merchandising, and customer relationship management CRM .

Confidential

Sr. Enterprise Data Architect/Modeler responsible for providing support to assist in the transition to new dbms platforms and the re-design of existing and new applications. Utilized System Architect and Rational Rose. Additionally organized and developed the system architecture using the FEA and DoDAF Operational View OV , Systems and Services View SV , and Technical View TV .

Confidential

Chief Data Architect responsible for the augmentation of the IAFIS systems. Responsible for the review, consolidation and management of requirements, translate into data warehouse/marts design, utilizing SOA, and support implementation effort with document specifications. Functioned as consultant to program manager and managed the integration of multiple implementation teams. Ensure NIST ITL compliance for Biometrics.

Confidential

Sr. Data Architect/Modeler providing analysis and design of data warehouse models in order to facilitate the integration of sales, customer retention, business operations, equipment tracking and financial/billing applications. CASE tools utilized Erwin and Oracle.

Confidential

Sr. Data Architect/Modeler providing data administration, governance, integration and quality for information sharing across the enterprise and provided design and enterprise architecture support for client's internal information technology office. Utilized ERStudio, DBMS/Teradata, Sybase, RDF/XML. . Ensure NIST SP 800 compliance for networks, endpoints, web applications and end users by providing explicit proof of compliance and associated documentation.

Confidential

Sr. Data Architect/data modeling providing support of the Enterprise Architecture Development of the Business Management Modernization Program BMMP for Defense Finance and Accounting Services DFAS . Introduced guidelines and procedures and utilized Popkin/System Architect and applied the Zachman and DoDAF/C4ISR frameworks with included specific view deliverable AV, OV, SV, TV.

Confidential

Sr. Business Analyst/Modeler providing data warehouse support for the single family amortization re-design project. Delivery of process and data components utilizing structured methodologies ERDs, DFDs, use cases , knowledge of financial accounting, mortgage banking, and systems development.

Confidential

Sr. Data/Enterprise Architect providing Enterprise Architecture support and development for multiple government clients Veterans Administration VA , Dept. of Education DOE , Dept. of Labor DOL , and National Science Foundation NSF . Additionally provided support to augment approach and deliverables for EA department. Frameworks utilized included Zachman, IDEFX, C4ISR, DoDAF- specific components included AV, OV and SV, TOGAF Architectural Framework and Information Engineering. All clients conformed to OMB CCA guidelines pertaining to Enterprise Architecture and my participation in these reviews was ongoing.

Confidential

Sr. Data/Enterprise Architect/Modeler for the CORE project assisted in maintaining the data warehouse for periodic releases by identifying and integrating change requests and provided support for the tracking of database changes. Analyzed and integrated modification to enterprise data model and corresponding data dictionary that depicted the processing and financial management of client's single family loan portfolio. CASE tool utilized was ERwin and Abinitio for ETL processing. Interfaced with very large business users groups spanning multiple locations.

Confidential

Senior Data Architect responsible for the assessment and guidance of the data warehouse initiative. Evaluated business systems and OLAP/OLTP database systems. Environment was Oracle 8i, SQL Server, and re-engineered dbms utilizing Erwin and Cognos. Utilized DoDAF and TOGAF architectural framework.

Confidential

Senior Data/Enterprise Architect/Modeler responsible for the analysis and design of the Customer Account Management Project involving requirements and process definition, OLTP database design, CRM/PeopleSoft evaluation and the management of project artifacts using Rational Rose and the Rational Unified Process RUP . Developed requirement and test scenarios for PeopleSoft within integrated lab. Managed staff consisting of subject area experts and consulting personnel 20 both administratively and technically. Project is one of several integration efforts in the ongoing IRS modernization effort. Interfaced with and mentored development, business, and management staff. DBMS was DB2.

Confidential

Sr. Software Engineer/Sr. Data Architect/Modeler responsible for the analysis and design of the corporate Data Warehouse/DDS. Managed group of business/development support and data modeling staff 9 . Adherence to techniques espoused by Inmon methodology. Source systems include Siebel CRM and Oracle Financials and Developer. Evaluated ERP and reporting products for infrastructure development. Provided support for data extraction from Oracle applications/dbms Oracle 8i/middleware and utilized RDF/XML for web page description. Required strong knowledge of supply chain management, financial services, and customer relationship management. Interfaced with marketing/sales, business units, upper management, and all levels of the development staff. Provided ongoing training related to the development and benefits of decision support systems to upper/middle management and business/financial personnel.

Confidential

Chief Architect for the development and deployment of telephony related database and associated applications for the Customer Communications Project. Additionally functioned as the senior technical architect and data modeler utilizing ERwin, Rational Rose, and System Architect. Responsible for the coordination of effort of 26 team members. Additional experience providing analysis/design for the Customer Account Data Base modernization project. Utilized System Architect, Rational Rose/Rational Unified Process, and Cool Gen, and Erwin, DOORS. Client DBMS was DB2 and Oracle. Interfaced with all levels of business users, management, and development personnel. Primary responsibility was the design and implementation of the transactional dbms to replace legacy account and tax payer applications and also played a pivotal role in the forward development of the corporate account financial data warehouse. Lead evaluation of vendor products to include Informatica. Provided training/mentoring with respect to database design and the redesign of the telephony applications.

Confidential

Senior Data Architect/Modeler/manager responsible for the re-design/analysis of the corporate entity model integrating the sales support, provisioning, customer support, and billing and accounting systems. Additionally involved with the design of the data warehouse/DDS utilizing Cognos and Inmon methodology. Case tool employed was Erwin and Cognos dbms was Oracle. Managed and trained development and business client on use of CASE tools for OLTP and OLAP development. Evaluated ETL and data warehouse tools.

Confidential

Chief Architect/project manager providing business process and data analysis/definition and requirements specification to launch a retail e-commerce site. Responsible for the evaluation and integration of partner vendors in the integration of CRM store front, web content, call center, financial accounting, chat, graphical rendering, security systems, and sales/fulfillment. Utilized RDF/XML, object oriented and structured analysis/design methodologies employing System Architect Data Architect and Process Analyst and use case development. Client dbms was Oracle. Managed and trained/mentored financial staff on implementing SAP with respect to the accounting, order entry, billing and fulfillment functionality. Client objective to launch site in aggressive four month time frame was accomplished. Analysis and developed architecture resulted in the solid foundation of software and business structures which resulted in the acquisition of the company.

Confidential

Senior Data Architect/Modeler responsible for providing business process re-engineering, data architecture, and logical database design support for the centralization of 2000 sites/agency applications within the USDA. Managed group 4 of data modelers System Designer and ERwin were the utilized CASE tools. Trained/mentored user on Erwin CASE tool and Zachman methodology.

Confidential

Senior Systems Architect/Modeler/Manager providing business process re-engineering, training and logical database design support for the conversion of all corporate business systems in a mainframe environment, DB2 to an Oracle based client server. Analysis included definition of process models, and impact analysis of vendor software with current procedures. Case tool utilized was S-Designer. This effort supported the legacy applications related to Year 2000 remediation and the re-engineering of new business systems. Support provided was analysis, design, implementation, and testing. Financial applications that were integrated included McCormack and Dodge and PeopleSoft H/R. Managed team of four subject area experts and enterprise architect.

Confidential

Senior Data Architect/Modeler responsible for the development of the Desktop Underwriter applications. Rapid application iterations were designed with user and development groups using Rational Rose and RUP. Development cycle spanned analysis/design to code/implementation. Applications supported were large scale, complex in nature, and supported very large user base.

Confidential

Senior Business Analyst providing engineering support for proprietary defined contributions software with responsibilities to include analyses of the current system, definition of business, functional, technical, and operational specifications, and the management of client/State Street Bank business requirements integration. Utilized CASE tool was ERwin, DBMS was Oracle. Devised training strategies for implementation of newly developed applications.

Confidential

Senior Systems Analyst/team lead providing comprehensive technical expertise for the Dun Bradstreet HR:M series of products. Responsible for the analysis, design, and implementation of all facets of the payroll, personnel, and benefits systems in support of the corporate conversion effort from M D to MSA. DBMS was DB2.

Confidential

Senior Systems Analyst responsible for the re-engineering of sales and financial systems to provide the management and analysis of financial information of corporate network assets. Methodology and tools utilized include Information Engineering, System Architect, and SAS.

Confidential

Chief Data Architect responsible for the development/augmentation of the Multi-Family Loan Portfolio in performing the following functions: impact assessment upon the Enterprise model and existing data bases, assessed business and performance risks, leveraged legacy development, defined/modeled data and process requirements, logical to physical database design, developed data dictionary, validated model to business requirements, and transitioned for design. Managed and mentored client on methodology and CASE tool usage. Client's target platform: Unix/Sybase, methodology and tools utilized: Information Engineering and Silverrun. Business model design was at the enterprise level and supported a large user base 4500 representing complex systems and applications.

Confidential

Senior Systems Analyst responsible for data and process modeling in conjunction with Business Process Re-engineering target platform: VAX/Rdb/C of telecommunications business product lines CRM, order entry, billing and distribution . Methodology and tools utilized included Information Engineering, System Architect and Rational Rose and Rational Unified Process RUP .

Confidential

Senior Business Analyst/Modeler responsible for the analysis, evaluation, design, and maintenance of specific financial securities products. Utilized data/process modeling via IE/IEF and JAD. Functioned as the managing liaison and mentor between the user and software engineering groups. Interfaced with PeopleSoft H/R and financials for the incorporation of data model. Client dbms was Oracle.

Confidential

DBA responsible for the development and implementation of applications for the

KBASE analysis/retrieval package in the corporate VAX environment. Responsible for the analysis, design, and extraction of patient and financial data and functioned as the DBA to assurance and provided ongoing technical and developmental services for client base. Mentored business user on utilizing KBASE for report generation.

DIRECTOR, BUSINESS DEVELOPMENT

Confidential

  • Responsible for the development and implementation of marketing and sales programs for a consulting practice specializing in CASE architecture to include
  • IEF, TELON, Teamwork, Pacbase/Paclan, and IEW/ADW. Implemented innovative programs to promote training and consulting services, targeted at 1M in
  • revenues. Additionally functioned as project manager and instructor for IEF implementations State government client BSD through Construction , Federal Defense client
  • RAD through Construction , and a major airline client RAD through Construction using IEF and TELON .

SENIOR SYSTEMS CONSULTANT / ACCOUNT MANAGER

Confidential

Provided comprehensive system support for proprietary CASE products including TELON, Teamwork, TDIF and PVCS. Active implementation, training, and support efforts for client base in DB2, CICS, IMS DB/DC, and IDMS environments. Responsible for trial/benchmark management, beta testing for new product releases, and technical sales strategies. Proficient in deliverable phases of Analysis/Design through Construction. Consistently utilized and facilitated JAD and RAD sessions for development.

SALES ANALYST / ACCOUNT MANAGER

Confidential

Provided pre-sales, implementation, and production support for the IEF and IEM. Responsible for client management during evaluation and benchmark phases providing technical assistance, training, and integration services. Proficient in deliverable phases of BAA I/II, BSD, Technical Design, Construction, RAD, and JAD. Benchmark achievements included major insurance and manufacturing clients where IE/IEF standards were evaluated, prototyped financial models, and generated complex code utilizing IEF.

SENIOR SUPPORT CONSULTANT / ACCOUNT MANAGER

Confidential

Responsible for the pre-sales, implementation, and production support for the General Ledger, Accounts Payable/Receivables, Fixed Assets Tools, and Human Resources Products in the Mid-Atlantic district. Provided demonstration, installation, instruction, integration services, and system tuning support while serving as client manager. Additionally assisted in product augmentation and quality assurance on an ongoing basis.

STAFF CONSULTANT / SYSTEMS ANALYST

Confidential

Developed and implemented proprietary and customized system software. Served as client manager 15 consultants responsible for project management, mentoring, and implementation for DB2/CICS, IMS and IDMS environments. Additionally responsible for staffing personnel requirements on a project basis and generating additional project revenue. Utilized productivity/development tools SAS, Easytrieve , CASE tools IEF, IEW, System Architect , and Information Engineering methodology.

PROGRAMMER ANALYST

Confidential

Developed, installed, migrated and maintained corporate software for order entry, accounts receivable/payable, and collection systems. Interfaced with data administration, user, and production teams in order to identify and facilitate information requirements for new development. DBMS included DB2 and ADAbase.

We'd love your feedback!