PROFESSIONAL SUMMARY

Extensive experience in data architecture, data and process modeling, enterprise data and process sharing strategies, business and systems analysis, requirements definition, project planning, full lifecycle system development, data warehouse design, business intelligence, process improvement and technical documentation.

POSITIONS Advanced Systems Engineer

Business Analyst

Consultant Specialist

Data Administrator / Architect / Analyst / Modeler

Programmer Analyst

Systems Analyst

• BUSINESS AREAS Airline: Aircraft Maintenance Planning
• Auto: Enterprise Data / Process Modeling, Warranty
• Claims, International Trade, Logistics
• Government: Benefits, Customs, Law Enforcement, Training
• Financial: Unit Trust Valuation
• Insurance: Actuarial, Billing, Claims, Finance, Policy Issue
• HR: Staff / Shift Allocation
• Real Estate: Sales, Marketing, Contract Negotiation
• Retail: Accounting, Ordering, Distribution
• Service: Purchasing
• TECHNICAL Altova UModel Hyperion Int. Rptng. SQL Server
• Altova XML Spy IEF - Cool:GEN Serena Dimensions
• CA AllFusion ERwin ClearCase Toad
• DB2 Informatica Visual Basic.NET
• MS Office Oracle ArgoUML
• Hyperion Essbase InfoSphere Data Architect

PROFESSIONAL EXPERIENCE

Data Modeler

• Create logical and physical data models to support the re-design of patent processing systems Patent End to End initiative within USPTO.
• Develop data models and generate DDL using IBM InfoSphere Data Architect 7.5.3 IDA in a MySQL environment.
• Review Developers' DDL for correct and complete data naming, indexes, constraints and audit fields.
• Manage versioning of artifacts in ClearCase.
• Meet with Subject Area Experts to ascertain system and data requirements.
• Attend Agile / Scrum sprint meetings.
• Participate in data model reviews.
• Participate in development of common data objects to facilitate enterprise data sharing.

Data Analyst

• Performed analysis within the data architecture team supporting federal government immigration and customs enforcement data warehouse projects.
• Performed data mapping from relational source through dimensional warehouse to XML target.
• Used CA ERwin 7.3 to create data models.
• Used Toad 9.0 and SQL Developer 2.1 to query Oracle 10g source and warehouse data, verified correct mappings and generated data for testing Informatica ETL procedures.
• Used Hyperion Interactive Reporting Studio 9.3 for custom and ad hoc reports.
• Responded to customer service requests concerning reporting issues and coordinated their resolution using the JIRA 4.2 issue tracking tool.
• Prepared documentation including Data Management Plans.

Data Administrator

As a member of the enterprise data management group supporting customs and border protection projects within the federal government, was responsible for defining and ensuring adherence to organizational data standards.

• Used CA ERwin Data Modeler 7.3 to create, enhance, and maintain logical and physical models.
• Generated Oracle 10g ddl for new development as well as for modifications to existing tables.
• Developed Information Exchange Package Documentation IEPD using the National Information Exchange Model NIEM for sharing data within the bureau as well as with other components, agencies and governments. Used ArgoUML, Altova Umodel and XMLSpy to generate UML models and XML schemas for the exchanges.
• Provided project planning estimates for data administration / data sharing activities.
• Reviewed Data Management Plans at program office, bureau and agency level.
• Evaluated software tools and performed cost / benefit analysis.
• Developed procedures for data administration process improvement.
• Designed business processes around use of the Serena Dimensions tool to manage workflow and version control.
• Designed and built a prototype for a new Data Engineering intranet site.
• Developed design and functional requirements, use cases, and test cases within the SEI CMM Level 3 framework for a web-based contract reporting system. Utilized SQL Server DTS to transform source data and Hyperion Essbase multi-dimensional database for OLAP reporting.
• Coordinated title and financing requirements reviewed closing documents.
• Wrote, reviewed and negotiated contracts.
• Developed marketing materials, plans and presentations.
• Prepared comparative market analysis.
• Participated in developing a new system design methodology for the bureau.
• Provided guidance and mentoring for members of team.
• Utilized the Informatica PowerMart ETL tool to extract, transform and load data from purchasing system data sources to an Oracle data warehouse. Analyzed user requirements for data. Produced a data dictionary describing data elements and their progression from source to warehouse dimension and fact tables.
• Assisted in creating a Request for Proposal RFP to be sent to multiple vendors for the development of a web-based dealer inventory system.
• Analyzed data architecture requirements and performed project planning, using MS-Project, for an OLAP system that extracts data from various operational sources and stores it in a data mart. Data was subsequently loaded into a multi-dimensional database Hyperion Essbase to allow for decision support related to high level business metrics including quality, safety and cost.
• Researched analytical and reporting software and made recommendations concerning data exploitation tools for a project developing a web-based service level metrics reporting system.
• Performed project startup activities for a retail product promotion system. Produced the project plan in MS-Project. Created the intranet project workbook. Utilized the PM2 methodology.
• Evaluated system development software for potential inclusion in the corporate Common Tool Infrastructure.
• Produced integrated enterprise data and process models using the IEF / Cool:Gen toolset.
• Defined and piloted enterprise data and process sharing strategies using IEF / Cool:Gen tools and SDP-21 methodology.
• Designed and constructed a global client / server, GUI, logistics application using IEF / Cool:Gen and Oracle DBMS on a MS Windows / HP UNIX platform.
• Developed and deployed a system to manage trade and tax requirements for US and Mexican customs using IEF / Cool:Gen.

Systems Analyst

• Performed business analysis for a federal government project developing a system to integrate training, course development, course delivery, skills assessment and work assignment.
• Conducted training in Information Engineering, Requirements Gathering and IEF full life cycle usage.
• Submitted recommendations regarding the client's implementation of IE and IEF CASE tool.
• Developed the Project Plan and created Work Breakdown Structure.