OBJECTIVE:

• To obtain a position with a world - class organization that will enable me to achieve my career potential.

SUMMARY:

• An experienced professional with a wide background including insurance and banking systems, data modeling, service layer architecture design and coding, systems analysis, project management, risk management, data mining, technical lead, and quality assurance.
• Over twenty (20) years of professional experience.
• Business Analyst experience including: gathering requirements, risk/reward analysis, creation of High-level and low-level requirements documents, project proposals, data flows, work flows, case studies, and software requirement specifications.
• Responsibilities have included Technical Lead, Data Analysis, Design, Specifications (including writing specifications for other programmers to follow), Extensive Coding, Testing, Documentation (including user manuals), and (both individual and small groups), creation and presentation of project, unit, division, and corporate financial and operational performance metrics for all levels of management.
• Business Intelligence development experience with Business Objects (six years), Crystal Reports (four years) and SAS (six years). Responsibilities included data modeling, analysis, development, quality assurance, documentation, user, project lead, Universe design, creation and maintenance, Desktop Intelligence and Web Intelligence implementations, and team lead.
• Experience as project tech lead in multi-platform development, including the supervision of off-shore development and QA personnel. Responsibilities included project sizing, scheduling, team assembly and management.
• Provides application expertise in insurance, banking, inventory control, accounting, risk management, call center, MIS, and operations research.
• Demonstrates excellent written and verbal communication skills.

PROFESSIONAL EXPERIENCE:

Confidential, Dearborn, Mi

Data Analyst/Data Modeler

Tools: et: ER Studio, Informatica, Oracle, Oracle Business Intelligence Enterprise, DB2, IBM Mainframe, MS Excel, MS Access, MS Project, MS Powerpoint, MS Outlook, SQL, Visio, TQM, and SDLC.

Responsibilities:

• Responsible for development and production support for the Automotive Services Datamart. Act as analyst, designer, and programmer of Oracle 11g data warehouse solution featuring multiple internal and external data sources; and corporate-wide userbase. Tasks include data analysis, data modeling, data mapping, ETL development and support, documentation, user, and production support.
• Implemented and acted as lead analyst/subject matter expert for ER Studio Data Repository and ER Studio Portal. System enabled collaborative modeling with concurrent model and object access, model and object version management, standardized enterprise data dictionary, real-time object status notification/conflict resolution, and data diagram/metadata reporting.
• Utilized Oracle Business Intelligence Enterprise to create reports and data analysis tools for user community. Tools created included dashboards for call center management featuring call center performance tracking, queue depth analysis, with scorecards for coverage analysis and agent scheduling performance.
• Supported Michigan mainframe application. System for autoclub and agent online support applications and related internal and external reporting requirements. System featured Cobol and EZtrieve programs, with DB2 and IMS databases in addition to ISAM, flat file processing. Software included Cobol, EZtrieve, JCL, DB2, and IMS.

Confidential, West Des Moines, Ia

Data Analyst/Data Modeler

Tools: et: Sybase PowerDesigner, Teradata, Ab Initio, MS Excel, MS Access, MS Project, MS Powerpoint, MS Outlook, SQL, Visio, TQM, and SDLC.

Responsibilities:

• Responsible for development and production support for the Mortgage Information Data Environment data warehouse. Acted as data analyst, modeler, and programmer of Teradata data warehouse solution featuring multiple internal and external data sources; and corporate-wide user base. Tasks include data analysis, data modeling, data mapping, ETL development with Ab Initio, and support, documentation, user, and production support.

Confidential, Southfield, Mi

Business Intelligence Analyst/Developer

Tools: et: DB2, VB6, SAS, SQL Server, IBM Mainframe, MS Excel, MS Access, MS Project, MS Powerpoint, MS Outlook, SQL, Visio, TQM, and SDLC.

Responsibilities:

• Responsible for development of and Provider network performance monitor system. Acted as analyst, designer, and programmer of data mining solution featuring multiple DB2, SQL Server and MS Access data sources and reporting via MS Access form driven pivot tables and charts. Tasks included project sizing and tracking, documentation, user, and support.
• Supported legacy and Provider network performance monitor system during the development of replacement system.

Confidential, Des Moines, Ia

Technical Lead

Tools: et: Cobol, DB2, CICS, Java, Informatica, VB6, SQL Server, IBM Mainframe, Rational Application Developer, SAS, Business Objects, Crystal Reports, MS Excel, MS Access, MS Project, MS Powerpoint, MS Outlook, SQL, Visio, TQM, and SDLC.

Responsibilities:

• Maintenance and support of Group and Individual Life, Disability and Health Insurance marketer pay, bonus, credential validation and marketer setup system (Cobol, DB2, JCL, TSO, Java, VB6, SQL Server, SAS, Unix, Windows XP, IBM Mainframe, Business Objects, Crystal Reports, Informatica)
• Programming and support of processing for Group Medical and Non-Medical Insurance Pay, Bonus, and reward programs. Applications included internal, auditor, and government reporting. SQL Server, VB6, Access, SAS, FTP, Cobol, DB2, JCL, FTP, Business Objects.
• Launch of new Disability Insurance product. Responsiblities included: analysis and design of mainframe and distributed system, and data model, and security and documentation, creation and maintenance of reports including SQL fine-tuning, intranet publishing, and business customer /support. Led multiple developer team including offshore and 3rd party resources.
• Project planning, requirement analysis, data modeling, service layer design (including stored procedures, controllers, business services and table handlers), and ETL process design for Anti-Money Laundering system. DB2, Informatica, Cobol, stored procedures, Java, service layer architecture, and SDLC . System included feeds from 3rd party vendors and lead of offshore designers and developers.
• Launch of new Variable life insurance products, including multiple riders requiring new DB2 tables, new issuance and pay programs and new CICS screens to facilitate business operations support of products. Analysis, design, Cobol, DB2, data modeling, and lead of multiple developer team including offshore resources.
• Design of Service Layers including stored procedure, controllers, business service modules, and table handlers for Chase IFT project. System serves as part of on-going corporate effort to automate accreditation process for 3rd party marketers. Cobol, DB2, Service Oriented Layered Architecture, Informatica, and Java.
• Led major rewrite of agent payroll advance system. Responsibilities included analysis design and coding of Cobol, DB2, IMS, JCL, and CICS changes. Also led multiple developer team including offshore resources during the project.
• Programming and analysis for a major effort to expand and improve the division mainframe test environment for concurrency and symbolics. New test regions including ETL processes to duplicate production environment. Also, changes to Jobs, Procs, system support libraries and scheduling. Informatica, DB2 utilities, JCL, CA7.
• Conversion of division workstations from Windows 2000 to Windows XP

Confidential, Southfield, Mi

Lead Programmer/Analyst

Tools: et: SQLWindows, Oracle, Java, Business Objects, SAS, Symantic, MS Windows XP, MS Server, MS Excel, MS Access, MS Project, MS Outlook, SQL, Visio, TQM, and SDLC.

Responsibilities:

• Design, development, testing, documentation and support of payday advance/check cashing/retail financial services Point-of-Sale application. Conversion from CS to thin-client Web Services architecture (SQLWindows, Oracle, SQL). Responsibilities included: business requirements analysis, system design, project management, system testing, database design, coding, documentation, deployment, and user .
• Design, development, testing, documentation, and support of collections management application (SQLWindows, Oracle, SQL).
• Design, development, testing, documentation, and support of customer contact/support helpdesk application (SQLWindows, Oracle, and SQL).
• Design, development, testing, documentation, and support of MIS reporting (MS Excel, MS Access, Business Objects, SAS, SQL)
• Project mgmt/support for server-hosting outsourcing initiative.
• Project support for company-wide voice over IP (VOIP) conversion.
• System security support: including databases, server, and client firewall and anti-virus selection, implementation, and support.
• Server maintenance and support for multiple application/database servers: including hardware, communications, security, backup, load-balancing, and OS support.
• Installation and support of system hardware, software, security and communications for company-wide point-of-sale store network. Duties included on-site and central-point end-user . Help-desk and on-site support for hardware, application software, database, security, and communications.
• Business Intelligence application development with IBM mainframe, DB2 and Oracle databases, Business Objects, Cobol, JCL, Visual Basic and SAS. Project management utilizing SDLC, TQM, MS Project, Erwin, and Visio. Responsibilities included business requirements analysis, system design, tool selection, project management, system testing (including unit test, system integration test, user acceptance test, and security test), system documentation, and performance analysis.
• Business Objects administration, universe design, table creation and maintenance, documentation, security, SQL fine-tuning, and reporting. and support of users.
• Information system and communications support, security, hardware, networking, data backup and recovery, Quicken, MS Server, MS Windows XP, MS Office applications support and
• Business planning, requirements analysis, and information technology strategic and operational advice and consent
• ETL development with Informatica.
• Web development utilizing Java, JSP, J2EE, JavaScript, Java Web Services, HTML, Coldfusion, Dreamweaver, XML, Struts, Tomcat, WebSphere, Eclipse, and .Net

Confidential, Dearborn, Mi

Risk Analyst/Lead Developer

Tools: et: Business Objects, Cobol, DB2, SAS, Visual Basic, IBM Mainframe, HP-Unix, MS Excel, MS Access, MS Project, MS Powerpoint, MS Outlook, SQL, Visio, TQM, SDLC, and Six Sigma.

Responsibilities:

• Maintenance and support of Wholesale Commercial Lending system (Cobol, DB2, Expediter, Endeavor, JCL, TSO, AbendAid, Fileaid, IBM Mainframe)
• Conversion of legacy reporting systems to Business Objects. Responsibilities included: design of BO Universes, ETL of legacy DB2, SAS, and gdg dataset data into BO Universes, maintenance of Universes including security and documentation, creation and maintenance of reports including SQL fine-tuning, intranet publishing, and business customer /support.
• Loan Depreciation Reporting system maintenance and Y2K conversion (Focus).
• Conversion of mainframe Credit Application Analysis Expert System to Client/Server architecture (Visual Basic, Art Enterprise).
• Project planning and analysis for Global Dealer Credit Package, including Fusion process and documentation, dataflow analysis, workflow analysis, project staffing, project budgeting, project timeline, hardware requirements, software requirements, global rollout planning and timeline following SDLC and TQM guidelines and procedures.
• Data analysis and sample creation for Debt Manager collections scorecard development. (SAS, DB2, Excel)
• Consumer credit portfolio analysis, collection strategy development, implementation, and monitoring. Collections reporting including dollars-at-risk and incident open/closure analysis by company, division, product line, product type, region, and risk level Credit extensions model development (SAS, Cobol, DB2, Excel, Unix, Teradata, MS Project).
• Vehicle valuation/depreciation curve analysis (SAS).
• Six Sigma

Confidential, Detroit, Mi

Analyst/Developer

Tools: et: MS Excel, MS Project, MS Access, MS Word, MS Powerpoint, Visual Basic, Cobol, DB2, Oracle, SQL, SDLC, TQM.

Responsibilities:

• Project planning and management utilizing MS Project, SDLC and TQM guidelines and procedures, intra and inter organizational and departmental coordination and documentation, platform and technology tools selection, and, rollout planning, budgeting and staffing.
• Conversion of legacy Escheats processing system from mainframe Cobol to C/S Visual Basic/Oracle platform.
• Developed and implemented report distribution system including end-user documentation and utilizing MS Access with Visual Basic add-ins.

Confidential, Dearborn, Mi

Analyst/Developer

Tools: et: Cobol, MS Excel, MS Project, MS Word, MS Powerpoint

Responsibilities:

• Conversion of online teller, loan officer, and ATM Banking Applications to Confidential A Series mainframe utilizing MS Project, SDLC, and TQM procedures and guidelines.

Confidential, Oak Park, Mi

Analyst/Developer

Tools: et: Visual Basic, Cobol, DB2, IMS, Expediter, Endeavor, MS Excel, MS Access, MS Word, Visio, SDLC, and TQM.

Responsibilities:

• Conversion of Customer Billing system to IBM ES9000 mainframe. Project included development of system reporting, dataflow and workflow analysis, design, and implementation. Project technology included: Cobol, DB2, TSO, JCL, Endeavor, Expediter, Focus, Fileaid, CICS, and FTP.
• Project management utilizing SDLC and TQM guidelines and procedures, analysis, development, maintenance, and support of Customer Service reporting system. Responsibilities included intra and inter organizational and departmental coordination and documentation, platform and technology tools selection, as well as reporting requirements, dataflow, workflow, and development and support staffing requirement analysis.
• Developed and implemented team/project/application trouble reporting-tracking-resolution system to address difficulties in managing multiple concurrent complex intra-organizational projects.

Confidential, Troy, Mi

Analyst/Developer

Tools: et: Visual Basic, Cobol, MS Excel, MS Access, MS Word, Visio, SDLC, and TQM.

Responsibilities:

• Maintenance and support of Customer Account Reporting system.

Confidential, Bingham Farms, Mi

Lead Analyst

Responsibilities:

• Responsibilities have included Analysis, Design, Specifications (including writing specifications for other programmers to follow), Extensive Coding, Testing, Documentation (including user manuals), and (both individual and small groups), Preparations and Presentation of project, unit, division, and corporate financial and operational performance metrics for all levels of management. Project management including technical requirements, staffing, budgeting, process leadership and quality monitoring.
• Data mapping, introduction, and maintenance of 810, 820, 835, 840, 850, 855, 856, 858, 860, 865, 869, 870, and 997 transaction sets for multiple trading partners utilizing Confidential EaDIplus software as part of Nintendo of America EDI order/invoice/distribution network. f trading partner personnel in usage and support of EDI network software and hardware.
• Trading partner technical staff consultation including launching and on-going technical support for required transaction sets, and integration of legacy accounting, manufacturing, and distribution systems into EDI network including data flow, work flow, security, and communications.
• Coordination of EDI activities with relevant VAN organizations, including GEIS, Wal-Mart, and IBM.
• Unix system administration for U6000 systems including security, system software support, end-user support, and trading partner and VAN technical staff liaison/support.
• System performance reporting, including creation, maintenance, and support of scheduled and adhoc reporting.
• General helpdesk support for entire application.
• System hardware, software, and operational support including security, data communications, and data backup for U6000 systems.
• Authored technical specifications including data flow, work flow, system architecture, data communications network, hardware and software requirements, personnel requirements, scheduling, project timeline, and budgeting as a part of Statements of Work, Requests for Proposal, project work plans, and other various technical documents required to support outsourcing business. All activities followed SDLC and TQM guidelines and procedures. Tools utilized included, MS Project, MS Excel, MS Word.
• Supported outsourcing of Ford NewHolland manufacturing, inventory control, marketing, and personnel systems. Provided support for conversion of systems from Confidential to IBM platform. Tools included: Cobol, DB2, IMS, TSO, FTP, JCL, and CICS.
• Supported outsourcing of Ford SOLMIS system. Provided support for conversion of system from Confidential to IBM platform. Tools included: Cobol, IMS, TSO, FTP and JCL.
• Supported outsourcing of Champion Products manufacturing, inventory control, accounts payable, account receivable, and customer relations systems. Provided support for conversion of systems to Confidential Unix platform, including data communications and data center operations.
• Supported outsourcing of Dairy Mart inventory control, marketing, accounts payable, accounts receivable, Human Resources, and payroll systems. Provided support for conversion to Confidential Unix platform.
• Supported outsourcing of FTD Florist order/inventory system. Provided support for conversion from Confidential to IBM platform. Tools included: Cobol, Focus, DB2, JCL, and CICS.
• Lead programmer analyst for online customer support telephone tracking system. System provided call prioritization queuing, coverage verification, incident resolution log including analyst id and time stamping, access to product support databases.
• Scheduled and adhoc reporting of customer support and product support information systems.
• Developed human resources skill mapping/tracking database. Developed and maintained manpower reporting system.
• Developed and maintained installed customer hardware/software system that enabled quicker verification of support.
• Mentored associate programmer analysts as part of lead analyst function
• Authored systems/programs specifications.
• Documented systems/programs including data, work, and process flowcharts.
• Supervised and/or performed Phase I, II, II, IV testing and verification for systems; followed SDLC and TQM procedures and guidelines for all activities.
• Supervised data center with three mainframe (Burroughs B69xx Series), four midrange (IBM System 38, ATT System 7, Burroughs B19xx) systems with accompanying multi-site terminal/peripheral network, tape library, and documentation library.
• Responsible for supervising staff of seven employees.
• Scheduled employees and system workflows.
• Completed conversion of dumb terminal to PC network, including PC ordering, staging, installation, and of end-users.
• Supervised helpdesk providing 7/24 application/datacom coverage.
• Performed inventory on installed hardware and software.
• Budgeted and purchased hardware, software, supplies, and support services.
• Acted as executive liaison to upper management, user base, and horizontal organizational entities.