Sr. Systems Analyst Resume Profile
LortoN
Accomplished Enterprise Architect/strategist, Thought leader
Professional Highlights:
Sr. Enterprise Architect/OCIO IT Strategist: 21 years of IT experience involving Strategic consulting to C level IT management, IT governance, technical architecture design and large application software solution implementations using Information Engineering for both commercial and government sector clients. Proven experience in creating technical architecture and Information Management solutions on IBM Mainframes and in client server environments. Sound knowledge of various business domains such as Government Defense and Civilian Business Department of Defense, Homeland Security, Labor, Taxation, Public Welfare, DMV, United Nations , Telecommunications, Auto/Home Insurance, Finance/Loan systems, HR Payroll accounting. Extensive experience in working directly with application developers and customers to define needs to produce quality enterprise solutions on time and under budget.
Security Clearances:
- Internal Revenue Service MBI Active
- Department of Defense Secret Active
- Department of Homeland Security Full Background Active
Enterprise Architecture Framework:
- Federal Enterprise Architecture Framework FEAF
- DODAF 2.0 Defense /BTA's BEA Practices
- TOGAF Open Group Framework
- Zachman Framework
- Gartner EA Guidance
- FDIC EA Framework
White Papers:
- Info-Cycle Ongoing lifecycle to leverage information, Innovate and increase enterprise agility showcased at IBM Information on-Demand Global Conference in October 2008
- Enterprise Data Warehouse Framework, presented to University of Winnipeg, Canada and IBM Research lab for research, August 2008
- Business Intelligence and Enterprise Agility, presented to CSC papers in May 2007
- IT Asset and Service Management to Optimize IT Portfolio DISA, 2009
- Enterprise Software Migration Strategy and Planning DOL, 2010
- Enterprise Information Management The Way Forward DOL, 2011
- Integrated Search Strategy for Investigative Case Management DHS, 2011
- Trainings: FEAF and FDIC Enterprise Architecture Roadmap at FDIC TROUX Metadata repository at FDIC IBM's Information on Demand Speciality DB2 Version 9 IBM's Rational Unified Process RUP at FDIC STAR team at FDIC Platinum Data Repository Training at FDIC. Embarcadero ETL tool, CA-Datacom/Ideal/DB at Food and Agriculture Organization of the United Nations, Rome 1992 CICS Web Support/3270 Bridge for Web projects at IBM
- Strengths: Excellent business, technical and inter personal abilities to serve as a Lead Enterprise Architect and facilitate proactive communication and collobaration to create effective solution architectures. Experience with Enterprise Information Management EIM . Good understanding of Enterprise Data Warehouse EDW and its role in Enterprise Architecture. Strong SOA knowledge, DBA manager DB2, CA-Datacom/DB on IBM Mainframes SQL server . Strong Systems Development Abilities Technical Architecture topology Definition and Implementation N-tier, online, batch development RUP and Configuration Management.
ConfidentialExperience:
Lead Architect ICE OCIO Architecture/TECS Mod Program
- Lead effort to create Data Migration Strategy for TECS Mod program including Initial Data Acquisition and Change Data Capture via Informatica
- Draft MoU for CBP support to migrate Mainframe Datacom Data to Oracle
- Facilitate Inter agency workgroup to address data migration issues on IBM Mainframe and/or in Modernized Oracle environment
- Develop Data Model at Conceptual, Logical and Physical levels and align with Enterprise data Models at ICE
- Create scripts to extract, filter, compress and sftp data from CBP Mainframe
- Assist on data discovery/integrated search subject area from TECS Mod and EIM perspective.
- Perform Capacity Planning tasks for TECS Mod program
- Perform Audit Planning tasks for TECS Mod program
Confidential
Lead Enterprise Architect/IT Architecture Strategist EA/IT Strategy Team at DOL OCIO
Technology Focus:
- Focus on Federal CIO's 25 point plan with emphasis on Cloud First Policy to support Data Center Virtualization/Consolidation efforts.
- Currently evaluating DOL applications and technologies that can be moved into government or industry cloud Software, Platform, Infrastructure and Data as a Service vendor .
- Responsible for creating solution architectures by collaborating with Business Owner and technical teams to create Business Process architecture, Information Architecture and technical architectures, Security and network architectures. Underlying theme being 'solutions are business aligned, technology enabled'
- Redefine Standards Management lifecycle process and enable using DOL central EA repository DEAMS . This involves categorizing DOL technologies in DOL Technical Reference Model, continue to tract standards lifecycle and research emerging technologies to be included on the DOL Technical standards catalog and ensure that DOL application technology stacks are sound and do not impose risk to DOL investments.
- Present requirement to strengthen and expand net-centric SoA environment by engaging DOL EA federation strategy Define UDDI Repository, Expose web services and publish WSDLs
- Develop function requirements and detail design to enable new standards process. Present to workgroup and steering committees for comments and final approval.
- Create new Technology Assessment process for standards management leveraging NIST standards, research papers and Vender information.
- Review and refine DOL Technical Reference Model TRM and it's relationships with Service Reference Model SRM , Business Reference Model BRM layers for clear line of sight.
Data Focus:
- Define DOL Data Reference Model DRM Description, Context and Sharing for EA program office and assist with National Information Exchange Model NIEM and open government initiatives
- Create 'To-Be' Harmonized Enterprise Logical Data Models, Enterprise Data Dictionary and ELDM Enterprise service to enable cross boundary data sharing at DOL.
- Create functional requirements for EA data visualization and services reports, dashboards, ELDM services, BPMN artifacts EA program office portal
- Review and refine DOL Business Reference Model BRM and create notional BPMN artifacts for stakeholder collaboration for further development
- Conduct data and Technology workgroups, prepare and make presentations at EA and IT Sub-committees
OCIO Key Management Activities:
- Assist with EA control reviews OMB E300, E53, EASR
- Create work breakdown structure WBS for EA program office
- Enhance baseline and future state EA meta-models using Troux 9
- Create Dashboard, reports visibility for DOL architecture data
- Use Troux 9 oftware modules such as Standards management including collection process and eaGov FTF, E300/E53, Segment architecture etc. .
- Knowledge of OMB's 5 step Federal Segment Architecture Methodology FSAM and assist with DOL Segment Architecture mapping
- Knowledge of OMB performance lifecycle architect, invest, implement approach
- Knowledge of EA, CPIC, SDLC and Security lifecycle and their mappings
- Performed Performance Budget Issue paper PBIP reviews and provided EA comments
- Knowledge of OMB investments and EA maturity assessment process complete, use, result approach
- Conduct internal EA assessments for DOL agencies
- Update EA repository security plan per Risk Management Framework RMF using FIPS and NIST guidance
- Provide a high level Business transformation Approach to DOL EA program
Confidential
Lead Enterprise Architect
- Supervise a team of 3 architects and ensure that IT Asset Management project deliverables best practices, as-is, to-be, transition plan and campaign plan are met on time, on budget per previously identified critical path. This involved review of several IT asset management papers from IBM, Gartner Research and Forrester Wave and software solutions such as Symantec Altiris, IBM Maximo and HPOpenview products.
- Make presentation to business and technology leadership, Business modernization boards and working groups to enable collaboration between stakeholders to create a Net Centric IT Asset Management Solution.
- Work as Lead Enterprise Architect to translate business vision and strategy into effective Information Technology Asset Management ITAM process by defining requirements, key principles and models to create To-be architecture and a transition plan to close the gap between current state and future state architecture using DoDAF products
- Focus area is to Rationalize IT asset process, integrate ITIL/ITSM with ITAM, increase accountability and enable visibility of IT assets. Produce vision/strategy and best practices documents.
- Leverage Business Transformation Agency's BTA Business Enterprise Architecture BEA 6.2 and Business Enterprise Priorities BEP as best practices to create To-Be Architecture.
- Understand DISA Campaign Plan, Global Information Grid GIG / Net-Centricity concepts
- Use IBM System Architect to create DoDAF artifacts AV,OV,SV and TVs
- Evaluate ITAM products such as Altiris, IBM's Maximo, Netcracker etc. and rationalize user process to reduce silos, prevent duplication and employ concept of federation to make architectures visible, accessible and interoperable.
- Create ITAM OV7 logical data model and derive ontology/taxonomy to support fuzzy search for Net Centric ITAM solution
- Standardize service support and service delivery for service desk and support IT Service Management program. Use ITIL guidance to mature the ITSM program.
- Addressing other problem area leveraging EA to standardize Knowledge Management, Reduce number of Order Entry system, Consolidate Admin. Networks etc.
Confidential
Sr. Enterprise Data Architecture Manager
- Extensive DB2 DBA support Version 9 for CADE legacy modernization effort at IRS.
- Managed a team of 4 Sr. DB2 DBAs/Data architects to define Enterprise Data Architecture, make management decision on scope, time and cost to deploy resolutions in production environment. Responsible to report and suggest time and cost correction to any deviation from previously identified scope for the task order.
- Support IRS CADE release 2.2, 3.2, 4.2 and 5 under z/OS, DB2 v 8 using IBM DB2 Admin, RUP, Rational Products ClearCase, ClearQuest, Rose , TMON, STROBE, Endevor, Control-M etc.
- Discuss dependencies and constraints, risk assessment and deployment of releases in production environment to balance risk with return.
- Create Business Performance Reference Model PRM metrics containing Measurement category, Activity measurement such as value of/from inputs, processes, and outputs, Operational measurement such as quantities or qualities of the activities.
- Provide Database Architecture and Design Guidance to CADE project IRS's legacy modernization project .
- Participate and make decisions related to Enterprise Data Architecture, Database Administration, Performance Engineering, Information management discussions.
- Participate in Data sensitivity and compliance discussions
Confidential
Sr. Enterprise Architect/Lead Central DBA
- Extensive exposure to FDIC Enterprise Architecture framework based on Zachman and Gartner EA Framework to enhance relationship between IT and Business and create an agile organization to embrace Change.
- Participate in the process of creating, communicating and improving key principles and models that describe future state architecture
- Experience with FDIC PRM is based on Federal Enterprise Architecture Program Office's FEAPMO PRM with four measurement areas: Mission and Business Results, Customer Results, Processes and Activities, and Technology.
- Measure key performance elements related to IT initiatives. Measure Processes and Activities to capture the outputs that are the direct result of the process that an IT initiative supports. That in turn provide how well is the customer served and mission has advanced. PRM leverages approaches such as Balanced Scorecard, Value Measurement Methodology, program logic models, the value chain, and the theory of constraints.
- Follow FEAF maturity model to measure architectural program maturity Maturity level 1-5 . Capture Maturity level on Current vs. Future state on Gartner maturity model views.
- Extensive domain knowledge of FDIC business and IT applications supporting it.
- Participate in Enterprise Data Warehouse EDW development, a tool to leverage enterprise information for improved customer and business view at all levels.
- Experience with several new initiatives and their adoption in business and technology at FDIC such as Rational Unified Process RUP for Software Development, Data sensitivity and classification benchmarking, role based security, data sanitization ETL tools such as Embarcadero , EA-Rep meta data management repository using TROUX and CA-platinum metadata repository , GAO recommendations such as AC24 Physical separation of production from non-production environments .
- Extensive Database Administration/Design support for over 100 FDIC databases and applications under z/OS Mainframe Operating system.
- Discuss adoption of SOA approach for Bulk data transfer between FDIC, Federal Reserve Board and Office of the Comptroller of the Currency.
- Hands on DBA manager coordinating database schema changes/migrations and data movement between environments.
- Process improvement by automating team activities by writing routines in Rexx and other programming languages
- Supported massive database conversion from CA-Datacom/DB to DB2 by writing utilities and automating the process
- Supported ROSCOE RPFs conversion project Rexx under TSO thus eliminate overhead cost of keeping redundant technologies.
- Technology used: z/OS DB2 V 7.1 BMC TOOLS DB2 Connect STARSQL Platinum Repository Data shopper Info refiner ETL tool NDM Network Data Mover now known as Connect: Direct, XML, XBRL, DB2 XML extenders. Neon shadow direct Data query Ideal data dictionary CICS TS 1.3 Endevor Control-M Xpeditor for DB2 stored procedures etc.
Confidential
Sr. DB2 DBA and CM Manager
- Extensive domain knowledge of DMV functions.
- Lead Architecture group for Overall application design, Interfaces, Database Admin and Change control processes.
- Hands on Data Architect experience as Data Modeler and DBA using ERWIN software and BMC Change manager. Automate process to Change Database Schema.
- Coordinate migration of database schema changes via BMC change manager's migrate work-lists
- Generate Database Health check reports and support performance engineering.
- Facilitated execution of load/unload/DSN1COPY of data for database conversion team.
- Coordinate Security and Network management for user access or system outage related issues.
- Architect interfaces like AAMVANet DMV network , AFP printing, Barcode printing, name search, CICS socket programming, Credit card interface etc.
- Support batch architecture and job schedule.
- Support volume testing effort using Load and win Runner by simulating virtual load.
- Create and implement Change Management process
- Software used: IBM/3090 OS/390 , DB2, BMC tools Catalog Manager, Change Manager, DASD Manager, Recovery Manager , DB2 Connect, QMF, DB2I, ERWIN, CICS, VS COBOL II, JCL, TSO/ISPF, CA-PANAPT, Panvalet, Omegamon for CICS, DB2 and MVS, Abend-Aid, File-Aid, AVERS, CA7, RACF, ABR, PC workstations on LAN, Load-runner, Win-runner, SSA, BPF4.4.2, AFP, CICS Universal Client, Visual-Age Interspace, Outlook Express.
Confidential
Role: DB2 Database Administrator/Data Modeler
Client Management Facility/Daily Drafting Project CMF : This system maintains customer check service accounts and draft policies under it for premium due on a given withdrawal day each month. Project planning, Impact on Systems and Data, Establish high level work estimates.
Confidential
Role: DB2 Database Administrator/Data Modeler
Student Loan System: this system co-ordinates approval, recovery of student loans between schools and lenders under state of New York guidelines.
Confidential
Role: DB2 Database Administrator Project size
Automobile Insurance - Auto Policy Processing System APPS : APPS is an auto insurance system that provides various processing options insurance quotes and claims related assistance to the customer.
Confidential
Role: DB2 Database Administrator
New Commercial Billing System NCBS : DB2 Database Administration support to Discount Enrollment Database system of NCBS system. NCBS provides MCI with the means to bill large and mid-size commercial customer for use of virtual network-related services such as Vision and V-net.
Confidential
Role: Sr. Systems Analyst
Wisconsin Client Assistance for Re-employment Economic Support CARES System: CARES is a large scale computerized welfare application automated for public assistance for the State of Wisconsin with Aid to families with dependent children AFDC , Food Stamps, and Medicaid and JOBs programs.
Confidential
Role: Systems Analyst
Financial and Personnel Systems FINSYS/PERSYS : FINSYS/PERSYS is a computerized system that provides personnel management and multi-currency financial, budgetary and payroll accounting support to FAOs staff, Vendors, Food programs and Projects all over the world WORKGROUPS.
Confidential
Role: Programmer/Analyst
Financial Applications of L T: A comprehensive accounting system that handles posting of accounting transactions to the general ledger in batch and printing books and ledgers