We provide IT Staff Augmentation Services!

Data Integration Analyst Resume Profile

Experience

confidential

confidential

confidential

Project Mangement/Business Analyst Financial Industry Shareowner Services Systems

  • Contractor responsible for Customer data, document and content capture and integration to support Share Owner Services for a 160 billion corporation.
  • Responsibilities included:
  • Managing the Shareowner Services Customer Information and Image Capture application and technical environment for Document and Content Management includes Kofax Capture administration, defining new imaging and document capture requirements and procedures, establishing and maintaining change/release management procedures, establishing and maintaining integration procedures between imaging services and other Shareowner Services applications
  • Facilitate definition of requirements, development, QA and implementation for application and technical environment with Business, Operations, IT and Vendor Services
  • Establishing and gaining approval for Project Planning and coordination for defined tasks, timelines, milestones, and technical upgrade budget.
  • Generation of management reporting for IT and operations that included weekly status reporting as well as operational productivity improvement reporting aligned to Corporate objectives
  • Deployment of capture software including upgrade of Kofax Capture Development, Unit Testing and Production Environment to current version of Software includes server, fax import server, scan workstation and workstation upgrade. Also included installing distributed processing for validation.
  • Establishing Document Management Testing Scripts and Change/ Release Management Practices to ensure seamless implementation of enhancements between front end capture systems and backend applications
  • Training IT and Operations Management personnel to support established imaging and data capture functions for Data, Document and Content capture and application integration

confidential

confidential

confidential

Business Promotional Analyst Supermarket and Pharmacy Industry Retail and Wholesale

  • Responsible for direct contribution to the Supply Chain Services for an 8 billion corporation. Applied Business and IT discipline provided the basis for establishing and implementing enhanced procedures to the Supply Chain organization
  • Responsibilities included:
  • Facilitate definition of requirements, development, QA and implementation for Retail and Wholesale promotional processes and procedures to automate vendor relationship and contract management
  • Establishing Vendor Promotional Tracking System that include Vendor Promotion Intake, Tracking and automated Vendor Followup
  • Establishing Buyers Fair Vendor Funding Contract automation to Support Fiscal Year Goals and Budget
  • Work with various Data Warehouse and Application Databases to define Best Source of Data for Promotional Reporting and Operation Control
  • Establish Financial reporting for Order tracking and Trimester Goal Reporting
  • Establishing and Maintaining Supply Chain Week Ads for all Regions

confidential

confidential

confidential

Project Management/Business Analysis IT Consulting
  • Consultant for IT Consulting Firm: Responsible for overall project management, data and process architecture and technical consulting solutions for critical business and IT projects. Managed the project initiation, planning and control, execution, and communication activities pertaining to technology and business solutions. Responsibilities included:
  • Preparing and presenting Requests for Proposals for various business and IT projects
  • Preparing business analysis reports
  • Defining business process and data information and architecture requirements
  • Defining process work flows and data integration processes
  • Product evaluation and implementation strategy for Content Management and Imaging Software.
  • Participating in the incremental development of the data marts including dimensional modeling of data marts and data definitions for extract, transformation, load and BI reporting

confidential

confidential

confidential

Project Management/Data Analyst Content Management/Data Integration Health Care Systems
  • Enterprise Content Management System: Responsible for Information Architecture for CMS Enterprise Content Management ECM Project Team to establish the Content Management infrastructure including IBM's DB2 Content Management and Kofax Ascent Capture. Responsibilities included:
  • Establishing unstructured data management standards
  • Defining transaction load requirements for CMS content
  • Defining content management and data integration requirements for business applications and content scanning
  • Defining imaging metadata and process standards for Kofax Capture.
  • Operating as first level technical and business support for Kofax Capture.
  • Defining analytical reporting requirements for Medicaid content using BI
  • Conducting quality control reviews for content and integration
  • Defining and facilitating change management processes and activities
  • Defining data archive standards for content management unstructured data

confidential

confidential

confidential

  • Project Management/Business Analysis/Process Data Architect Case Management/Content Management Legal Systems
  • Integrated Case Management System: Responsible for selection and implementation of Case Management Prolaw and Content Management Stellent system for national law firm. Responsibilities included:
  • Facilitate business users to define case management process and data requirements
  • Product evaluation and implementation strategy for Content Management and Imaging Software.
  • Defining an attorney and client case management BI infrastructure
  • Defining ETL processing for loading the content
  • Generating case management process and data design documents
  • Defining data and process models to integrate the new case management and content management systems with existing business applications
  • Designing a fully functional extranet web service using online analytical processing that used ODS technology to leveraged the new case management and content management systems
  • Administer the ETL processing to load content into the new content management system

confidential

confidential

confidential

Project Management/ IT Architecture/Business Analysis/Data Integration Analyst Public Safety and Property Systems
  • Integrated Case Management: IT Architect focused on integration of Attorney, Police and Property Systems. Responsibilities included:
  • Defining data integration architecture to integrate case systems
  • Defining conceptual data model
  • Defining Case Management ODS to support Government and Public information access requirements
  • Analyzing and designing Intranet/Internet application for public access to case information
  • Developing new application testing strategies

confidential

confidential

confidential

Project Management/Business Analysis/Data Integration Analyst Financial Systems
  • Enterprise financial systems: Responsible for implementation of financial suite of products for brokerage firm. Responsibilities included:
  • Facilitate business users and IT support resources to identify and document integration requirements for collecting financial data to load into new general ledger system
  • Prepare design documentation for ETL of financial data into General Ledger
  • Prepare testing strategy and test case scenarios
  • Conducting testing and quality control reviews for ETL
  • Defining and facilitating change management processes and activities

confidential

confidential

confidential

Project Management/Data Warehouse Analyst/DBA Financial Systems
  • Enterprise Data Warehouse Financial System: Lead member of Data Architecture team to develop financial data warehouse for national banking institution. Responsibilities included:
  • Facilitate the identification of data requirements for the financial warehouse using BI methods
  • Preparation of data models utilizing dimensional modeling and the concepts defined in IBM's CMIM financial model
  • Generation of physical database tables from established data model
  • Preparing data models for effective data extract, transformation and load into warehouse ETL

confidential

confidential

confidential

Project Management/Process Data Analyst/ Developer Retail Systems
  • Retail consumer refunds system: Responsible for Development of consumer refund system using IEF Case tools. Responsibilities included:
  • Facilitate the identification of process and data requirements for the refund system
  • Designing and develop process and data model for online and batch processes utilizing IEF Case tools.
  • Designing ETL processes for loading existing refund data
  • Generating and testing application and data bases
  • Facilitating user testing of application
  • Implementing refund system into production

confidential

confidential

confidential

Project Management/ Data Architect/JAD Facilitator Health Care Systems
  • State of Missouri Social Services Health Care System SHCS : Data Architect responsible for development of State Health care system. Responsibilities included:
  • Conducting JAD sessions with 20 users to define business requirements, data model, data architecture, and process model
  • Maintain the data and process model in a IEF Case tool
  • Facilitate bi-weekly sessions to present and validate the model with project sponsors and other IT team members

confidential

confidential

confidential

Project Management/Data Analyst/Data Warehouse Analyst/DBA Mortgage Systems
  • Mortgage services client server based application and warehouse: Key member of data team. Responsibilities included:
  • Develop conceptual, logical and physical corporate data models utilizing dimensional modeling and concepts represented in IBM's FSDM financial model
  • Developing the data architecture and data model for specific service functions of the business
  • Designing ETL processes to load existing data
  • Conducting coordination session with other modeling groups to validate the combined model
  • Converting logical models to physical models related to specific mortgage services.
Technical Skills

Hardware

Apple/Mac, Compaq, Dell, IBM, Various SANs

Operating Systems

IBM OS/MVS, Novell NetWare, PC DOS, Windows, Windows NT, UNIX

Telecommunications Network

Novell, PC AnyWhere, TCPIP, NT

Databases

IBM DB2, MS Access, MS SQL Server, Oracle, Paradox, Focus, Sybase, Teradata, FileNet

Programming Languages

Basic, COBOL, Visual Basic, Visual Interdev, MS Cobol, MS Access, MS Excel Macro, Teradata SQL, SBL

Software Packages Tools

DATAMANAGER, DESIGN-MANAGER, MS Office Excel, PowerPoint, Word , MS Outlook, MS Project, McAfee, Norton, Utilities, Visio, IBM DB2 Content Manager, Kofax Capture certified , Stellent Content Manager, Front Page, Spectra Property Management, ePromotions

Internet Related

ActiveX, Internet Explorer Netscape Navigator

Case Tools

ADW, Erwin, Bachman, Excelerator, IEF, Systems Architect

Methodologies

Dimensional Modeling, Business Intelligence BI , ETL, OLAP, System Development Life Cycle, Information Engineering Methodology, Waterfall, Agile

Repository Tools

DataManager and Manager View, Infospan's IRMS, ManagerView, Microsoft Repository, PC Dictionary, Platinum Repository, Rochade, Informatica

Hire Now