SUMMARY

• High-energy process and results oriented Information Technology professional with over 10 years business analysis and data modeling experience. Skilled in allocating resources and manpower while adhering to tight budgetary constraints. Expertise in project management and planning analysis and design quality assurance and documentation. Key strengths in streamlining processes that improve productivity. Additional skills in database administration and development.
• Operating Systems IBM 3090 and MQ Series, 4341, z/OS, OS/390, 370, 360 MVS/XA or ESA, and Hardware: Windows XP/ME/2000/98/95, NT, UNIX
• Languages: Java, C , C, PL/SQL, SQL, VB.net/VB 6/5 ADO ASP.net COBOL/COBOLII X/HTML, XML, HTML, Java Script, VB Script
• Software Rational Software Architect RSA , Rational Functional Tester RFT , Visual Studio 2008/5/3, MS Project 2000, Power Designer, MS Office, Developer 2000,
• Tools: BRIO, Clear Quest, Clear Case, Cognos, CICS, Crystal Reports, Designer 11i, ERWIN, IE, IIS, Changeman, Endeavor, Xpediter, InterTest, TSO, ISPF, Excelerator, Lotus Notes, QMF, SMUII, SMP/E, ACF/VTAM, ISOTRAIN, Maximo, OOA/OOD, OMEGAMON,Trackwise, SQL/LIMS, CFR Part 11, , FrontPage, DreamWeaver , Mercury, MULTSESS, SPUFI, SQL PLUS, Toad, Golden, Requisite Pro, SOA, SCRUM, UltraEdit, UML, VISIO, WebSphere, XML Spy, Micro-strategy, TIBCO, Oracle Express
• Databases: Oracle 11/10G/9i,8i,7 SQL Server 2000/7, DB2 UDB9, ACCESS, IMS.DB/DC, Datacom DB, IDMS, INFORMATICA
• Networking: Novell 3.12/4.1/6.0, NT 4.0, PC Anywhere

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

Overview: Requirements facilitator with stakeholders Identified and documented: data sources, discovered business rules for base and derived data and data relationships. Broke out embedded legacy fields to atomic level. Determined data required for strategic decision making ie. Calculations, aggregations . Determined authoritative sources for data. Determined performance measures for data validity, and historical uses for data. Maintained corporate data model with Power Designer. Data Model/DW Data Mart Model presentation to all participants for review. During ETL: filtered,aggregated, and summarized data for reporting and creation of metrics. Separated OLTP data from analytical processing data gathering to reduce impact of data analytics on performance. Educated end-user in query creation to improve performance. Performed capacity planning. Created indexes to improve analytic response time. Developed project plans and monitored project/task deliverables, receiving sign-off by the Process Owners during each phase of the Project/System Development Life Cycle. Created/modified Business Rules, and disseminated the information to project personnel to ensure everyone is up-to-date with the requirements. Created functional and non-functional specifications, Systems Design through to development of the necessary modules. Created , documented and executed test plans manual and automated for QA of Business Rules and Deliverables. Created technical and training documentation. Projects for both on and off-site personnel in a diverse work environment, conferencing to remote sites to ensure a smooth flow of information and that project deadlines are met. Hours are flexed to accommodate implementation/production requirements. DB2, Oracle and SQL/Server applications. Created training materials/ presentations, such as white papers on emerging technology or alternatives to assist management decision making . Pivot tables, cubes, dimensional data models and forecasting predictive analytics and performance metrics Hyperion/Cognos/Excel legacy system re-write .NET/J2EE Platforms. Development DBA logical/physical wrote PL/SQL triggers/procedures. Web Project Management utilizing modified SCRUM, heavy QA with 98-99 accuracy. Utilized IBM Rational toolset RSA, Requisite Pro, Clear Case, Clear Quest, WebSphere, Business Objects, Financial Reporting. J2EE, Oracle 10G, DB2 UDB9, SQL/Server 2005/8/10, MQ, SOA ,TOAD,Crystal Reports Training. Micro strategy DPW - Database Analyst/Modeler responsible for review and approval of Logical/Physical Data Models Enterprise and Data Warehousing OLAP, OLTP Data Governance, MDM standards. HIPAA, SOX, Intranet/Portal Tools: AppSight, ERWIN, .NET 2008, Visual Studio 2008, SQL/Server 2008, Oracle 11, DB2 UDB9, XML/Spy . DAMA Assured conformance to data naming standards. Validated data name abbreviations. Assured all elements of data definitions were provided. Maintained metadata for data re-engineering/cleansing. Evaluated for normalization, primary key and foreign keys. Utilized ERWIN,EXCEL and VB Scripting. Data Dictionary creation. Use of Zachman framework principles to ensure scope is within enterprise context top-down conceptually and bottom-up with regard to data profiling to ensure domain values are complete, consistent for data quality and mapping. REVENUE - Created County Collection System XML Schema . Financial Reporting. DB29, Oracle 11, Java , MQ, SQL/Server 2008, XML/SPY, SOA . DAMA/SCRUM ERWIN, Cognos

Confidential

Managed migration of all database changes, stored procedures, and batch programs from development to system test and production. Maintained IS Training Database. Performed conceptual and physical data modeling through to DDL generation, utilizing Power Designer. Developed and maintained web sites for Contract Management System for statewide bid and response tracking. Heavy DBA work/QA . Upgraded invoicing sub-system to migrate to Windows XP/MTS platform. Wrote Visual Basic Procedural Interface between Lotus Notes and DB2. Performed QA of Application Contract/Vendor Deliverables Query Performance/Tuning to resolve Production resource issues.Online and batch Maintenance including but not limited to use of: Oracle, DB2, VB, COBOL, ASP, Java Script, VB Script and Lotus Notes Technologies. Application security. Power Designer. SQL. Sybase-InfoMaker.Documented all DBA procedures regarding Power Designer and DB2 mainframe requirements.

SAP Interface.

.NET Developer

Analysis and Development of WIC Store Application on SQL/Server 2003. IIS. Coordinated and interfaced with cross-departmental staff, vendors and contracting staff. Researched and recommended COTS Vendor ERWIN. Software/Hardware solutions with GSA comparison, ROI, justification for 5 Year Plan/budget. Completed .NET course track and SQL/Server Database Administration coursework at Intellimark.

Confidential

Sr. Engineer/Database Administrator

Developed user and functional requirements and data model for the document tracking system, consolidating departmental into plant-wide tracking. Hyperion-BRIO, Oracle Financials, SCADA, Power Designer,SAP, UNIX Performed database installation, creation, monitoring and backup recovery utilizing Oracle 8i, for 24X7 SCADA, and Intranet development systems reducing response time 1 hour to 60 seconds.

• Obtained budget and resources to accomplish training of site-wide IS courses. Researched and selected vendors adhering to budget requirements. Scheduled Project Management Training, that in turn enhanced site-wide ability to perform project management.
• Upgraded, revised, and reviewed SOPs for all SCADA systems and Oracle database administration that resulted in the ability to cross-train personnel.
• Created validation protocols for the SCADA system and participated in execution ensuring they were performed in accordance with vendor specifications to meet sustainable compliance goals.
• Collaborated with Human Resources to create and implement a security procedure to deactivate or add new users implementing Novell Administration protocols increasing site security measures.
• Developed Intranet site for Plant-wide use with links to Corporate Web site

Confidential

Systems Analyst

• Developed an online programming package for the cigarette program in Developer 2000, Designer 11i, Crystal Reports, VB6.
• Confidential
• Independent consultant for computer contracting companies working within governmental businesses, health care, banking and manufacturing. Assignments included:

Confidential

Solutions Technology

Created online application for HMO/POS provider database utilizing IMS DB/DC online and batch programming. Converted existing applications from IMS to DB2 for data warehousing project. Year 2000 date logic.

Confidential

Project Manager

• Bid and responded to state, federal and local RFPs. Created marketing and sales database, Analysis/Reporting.
• Charged with on-time delivery of company-wide client deliverables in compliance with RFP.
• Responsible for computer acquisitions, software installation and training. Created automated procedures designed to enhance operations.
• Created environmental reporting system utilizing Oracle on an NT platform. Obtained and implemented downloads from agency files, dial-up access and reporting for inclusion in automated report process.
• Developed online and batch programs as a database management specialist for the NTT project. IMS DB/DC, Datacom DB, MicroFocus Cobol .
• Supported the PBGC project as the technical support manager with oversight for systems programming, help-desk and production control.
• Analysis IRS Auditing methodologies.
• Tasked with emergency contract turnaround in the position of DBA/Task Leader for an IRS EMS project. Successfully produced 1.5M deliverables. Database Management Specialist for IRS Automated Collection Service Case System project. Conducted extensive client interviews to produce logical and physical database model utilizing Yourdon and Martin-Date methodologies, and IRM standards.

Confidential

Database SE/Team Leader

• Analyzed various OTS products for recommendation prior to system design for a
• Project Management Cost Schedule Control System.
• Performed systems design, database design and data modeling.
• Assisted in conversion from UNIVAC DMS/1100 to IDMS for the NAVICP Management System
• Assisted in proposal and RFP response for a database design to convert DMS/1100 database structure for GM
• Conducted extensive research and business analysis resulting in a high-level logical database design that would allow management to decrease manpower requirements at C P Telephone.