Post Job Free

Resume

Sign in

Sql Server Architect

Location:
Alexandria, VA
Posted:
October 13, 2014

Contact this candidate

Resume:

Mulikat Sarumi (MS & Associates)

Top Secret Clearance (Interviewed at the WhiteHouse)

**** ************ ***, ****** ****, MD ? acgc1m@r.postjobfree.com ? 240-535-

**** ? U.S. citizen.

Senior DBA and Enterprise Architect

Mulikat worked in the corporate industry for over 15years. She managed

several projects with the Department of State, Department of Defense,

Department of Navy, the Federal Bureau Investigative division and the

Department of Army. Her specialization includes Database Design and

Development - Database Management -Data Warehouse - Business Intelligence -

MS SQL Server Administrator - Enterprise Architecture- ETL/Informatica

Specialist.

MS & Associates

Consultant for MS & Associates

August - Present

Provided technical expertise and recommendations in assessing new IT

software and initiatives to support and enhance current based systems.

In an effort to improve the client's time tracking system, identified

opportunities that can improve efficiency of current Time-keeping system.

Logtech

Architect Jan

2013 - August

Developed new DoDAF work products; Capability Viewpoints.

Reviewed and broached the work products with all team members.

Work on new tasks/projects as assigned.

MS & Associates

Consultant for MS & Associates

June 2012 - Jan 2013

Provided technical expertise and recommendations in assessing new IT

software and initiatives to support and enhance current based systems.

In an effort to improve the client's time tracking system, identified

opportunities that can improve efficiency of current Time-keeping system.

SCCI

System Engineer for DoN Naval Surface Warfare Center using DoDAF

August 2011 - June 2012

Define & develop the Architecture Development Process for DODAF 2.0 in

accordance with DON architecture guidelines for the Strike Weapon Systems

Division.

Develop DoDAF 2.0 viewpoints (AVs, OVs, SVs & STDVs) using Object-Oriented

Methodology. Viewpoints were developed using Unified Profile for DoDAF by

the Object Management Group (OMG).

Review the developed DoDAF 2.0 viewpoints with Internal and External

Stakeholders within NSWC Division and implemented feedbacks back into the

viewpoint.

Conduct extensive Enterprise Architecture tool evaluation; Magicdraw, Sparx

Enterprise Architect & IBM System Architect.

Using Microsoft Project, develop & modify the NSWC Tomahawk Weapon System

Information Support Plan (ISP) V schedule.

Participate in 3-day weekly architecture meetings.

MS & Associates

Consultant for MS & Associates

June 2010 - July 2011

Clients: Analytical Research, LLC, Alta IT Services

Provided technical expertise and recommendations in assessing new IT

software and initiatives to support and enhance current based systems.

In an effort to improve the client's time tracking system, identified

opportunities that can improve efficiency of current Time-keeping system.

Enterprise Architect for the Department of Labor using FEAF

Managed Enterprise Architecture repository, Troux, for the Office of the

Chief Financial Officer.

Kept current newly distributed enterprise architecture compliant in the

database, Troux.

Used Federal Enterprise Architecture Framework to develop Enterprise

Architecture artifacts.

Aerotek

January 2010 - June 2010

Enterprise Architect for the Federal Aviation Administration (FAA) using

DoDAF 1.5

Gathered developed Federal Segment Architecture Methodology (FASM)

templates as guidance for Enterprise Architecture artifacts development.

Developed system views, DoDAF 1.5, for the EnRoute and Oceanic service

units, system engineering division.

Review the developed models with Internal Stakeholders (Chief Architect)

and implemented feedbacks back into the model.

Developed system views using IBM System Architect tool.

Managed Enterprise Architecture repository, IBM System Architect.

Buchanan & Edwards

Oct 2009 - Nov 2009

Data Technical Lead & ETL Developer for the FBI IDW Data Warehouse

Executed standard operating procedures to ensure that data ingest jobs are

completed on schedule.

Created workaround procedures when standard procedures fail and ensure

issues are resolved in a timely fashion.

Troubleshoot basic problems with data ingest jobs and supports simple

technical change requests in support of an applications data ingest

capability.

Imported data into Oracle via Informatica.

Execute data mining via Toad.

Document metrics from Informatica to shared drive for audit purposes

Lockheed Martin

Aug 2008 - Aug 2009

Senior DBA for the United States Air Force division; JPRA

Implemented and maintained smooth operation and physical design of

databases.

Reviewed database design and integration of systems, provides backup

recovery and makes recommendations regarding enhancements and/or

improvements; COMSEC using SQL Server.

Maintained security and integrity controls on both networks; NIPr & SIPr.

Formulated policies, procedures, and standards relating to database

management, and monitors transaction activity and utilization.

Responsibilities included: database loading; development and management of

operational procedures; environment management; database health (e.g.

monitoring, proactive and reactive responses).

BearingPoint

Feb 2008 - Aug 2008

Business Consultant & Lead Enterprise Architect for the Army (PEO-EIS

Division)

Managed all IBM System Architect encyclopedias/repositories/databases.

Consolidated all Enterprise Architecture encyclopedias into a master copy.

As a team lead, provided support to team members as required by the project

manager.

Constructed DoDAF 1.5 system views (DoDAF SVs) for systems acquired by the

Acquisition domain using IBM System Architect.

Broached architecture views to owners for validation.

CTA, Inc

Nov 2006 - Feb 2008

Database Administrator & Analyst for the DOD Military Health System

Enterprise Architecture

Managed all IBM System Architect encyclopedias, databases and user accounts

on MHS EA MS SQL server.

Provided tool support to System Architect users.

Administrated MHS EA SQL server activities on both production and

development networks.

Developed manuals and system documentation as needed.

Helped Architect with Enterprise Architecture when needed using DoDAF 1.5

ICF, Intl

Aug 2006 - Nov 2006

FEAF Enterprise Architect for the United States Secret Service

Developed a Performance framework to be used to assess an organization's

work performance. The performance framework was built in accordance with

Federal Enterprise Architecture Framework Performance Reference Model.

Reviewed the Business, Application, Business, Service, Data, Technical

Reference Models.

Governance: Inputted new Products into the USSS SA EA repository.

Wrote VBscripts in System Architect to support reporting

Input DHS USSS Business Function Inventory, Organization Unit and Fisma

Systems Inventory into IBM SA.

CIT, Inc

April 2005 - Aug 2006

Sr. Systems Analyst for the State Department

Managed State Dpmt IRM EA repositories: Oracle databases and synchronized

EA artifacts btw EE & SA.

Managed State Dpmt Consular Affairs EA repositories. Developed and

maintained the CA EA's web site.

Responsibilities for both roles:

Managed all databases on SQL server as DBA & Tool Administrator; performed

repairs, updates and corrects all repository relationships of definitions,

symbols and diagrams. Created Packages using Data Transformation Service

(DTS) and stored procedures. Enhanced the functionality of Systems

Architect by programming in Visual Basic Application (VBA).

Managed user property (Usrprops) file including documentation of each of

its modifications.

Developed, constructed and manage the CA EA artifacts and web sites; CA EA

Baseline (current) artifact, Target (To Be), Information technology plan

(ITP) and IT governance artifacts. Tracked users who access developed web

sites into a secured database.

Developed handwritten and efficient VBscript code to clean all html

injection tags from System Architect files.

SunTrust Bank, Inc. Feb 2002 -

Aug 2004

Systems Analyst & ETL Developer for the SunTrust Collections Division

Database development and management: Using SDLC designed and implemented

Computer Access database, which contains employee profile with individual's

security access. Designed and implemented the summit database for the STI

collections department.

Built SQL code, stored procedures, triggers, indexes and creating views of

data structures and documenting systems.

Created a user-friendly front-end interface for employees to access the

summit database: Using file transfer protocol and DTS packages (ETL)

downloaded thousands of customer accounts from the dialer and imports to

the server for processing.

Processed and exports data using stored procedures from SQL server and

VB.net to Microsoft excel.

Exported and processes final summit rtf file from the server to Microsoft

excel, word and access.

M2 Ltd

June 2001 - Aug 2001

Intern

Supported in all phases of translation, localization and testing of

business materials and systems, such as software.

EDUCATION

Bachelor of Science in Information Systems, December 2001

University of Maryland Baltimore County - Baltimore, MD

Masters of Science in Management Information Systems, Projected 2013

The George Washington University - Washington, DC

CERTIFICATIONS

Microsoft Certified Professional Pending: Designing and Implementing

Databases 70-229 - State Department Cyber Security Awareness - DoD Cyber

Security Awareness - IBM DoDAF ABM Certification - Lean Six Sigma White

Belt

TECHNICAL SKILLS

Platforms: Windows 95/98/NT/2000/XP, UNIX, Linux, Mac OS.

Core Languages: UML, SysML, PL/SQL, SQL, SQL Plus, UNIX Shell Scripting,

VBA, C# & VB.Net, HTML, XML, C, DreamWeaver, Java, ETL.

Core Tools: MagicDraw, Sparx Enterprise Architect, Informatica

PowerCenter, IBM Systems Architect, MS SQL Server Suite, Oracle 11i,

Primavera (Previously ProSight), Metastorm Provision, DOORS, Rational

Requisite Pro, Clearcase and ClearQuest, Toad, Microsoft Project, FrontPage

& Visio, NVIVO, Adobe.

AWARD

SunTrust Employee Appreciation Award 2004

Baltimore County Schools Teacher Community Award

Membership

System Architect User Group

Global Enterprise Architect Organization



Contact this candidate