SUMMARY

• High-energy process and results oriented Information Technology professional with over 10 years business analysis and data modeling experience.
• Skills include: allocation of resources and manpower while adhering to tight budgetary constraints.
• Expertise includes: project management and planning analysis and design quality assurance and documentation.
• Key strength lies in streamlining processes that improve productivity QA, Data Governance, MDM, database modeling and administration.
• 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, Jason, MySQL, JQuery, AJAX,
• Software: Rational Software Architect RSA , Rational Functional Tester RFT , Visual HP Quality Center, 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, OA/OOD, OMEGAMON, Trackwise, SQL/LIMS, CFR Part 11, , FrontPage, Dream Weaver, Mercury, Omegamon, MULTSESS, SPUFI, SQL PLUS, Toad, Golden, Requisite Pro, SOA, SCRUM, UltraEdit, VISIO, WebSphere, XML Spy, BOI, MicroStrategy, TIBCO, Oracle Express, Toad for Oracle ER Studio, Solution Architect QlikView, WebEx Sharepoint
• Databases: Oracle 11/10G/9i/8i/7 SQL Server 2000/3/5/7/8/10, DB2 UDB9, ACCESS, IMS.DB/DC, Datacom DB, IDMS, Informatica, Netezza appliance Metadata Manager
• Networking: Novell 3.12/4.1/6.0, NT 4.0, PC Anywhere

PROFESSIONAL EXPERIENCE

Confidential

DW Data Architect

• Data Architecture Design and Process Review DW Data Architect/Data Management Supporting Single-Source of Truth MDM efforts through data analysis/profiling 14TB Teradata
• Support for Customer, Member, Medial Claims/Medicare Advantage, Provider, Pharmacy subject areas for EDW SQL/Server, Oracle, Toad10g, Informatica, ERWIN, Solution Architect, Metadata Manager BOI, Cognos

Confidential

Enterprise Data Architect/Data Modeler

• Team participant in the development of the Enterprise Architecture Roadmap
• Reverse Engineering of Existing Physical data models ERWIN/Postgres SQL/ER Studio to modify existing data models and to collect metadata for the metadata repository.
• Developed PII VB solution for identification of non-PII and Suspect PII and subsequent verification with SMEs to identify elements requiring masking/encryption.
• Metadata Repository management Global ID
• SharePoint Team Site certified for Team Portal development/management
• Groups supported: CRM, SRM and DW/BI Oracle 11, Netezza, Qlikview

Confidential

Business Process Leader/BA

BPL responsible for ensuring on-going operations are through usage of agile Scrum methodology, teleconferencing and messaging to coordinate activities of the team with other cross-functional areas distributed nationwide.

Confidential

Conversion Data/Business Analyst

• MDM using proprietary HP software to ensure that the Enterprise Data Dictionary with its Business Rules is consistent across all counties.
• Tasks included: data analysis, data mapping and translation, ERWIN data model review, SSIS application support, client business rule development, and data quality assurance to ensure that the source to Intermediate Data conversion/translations adhere to stated business rules.
• QA testing to ensure that the extract, translation and load of the intermediate databases meet expected result.
• Co-authored In-House procedural manual for business analyst procedures and testing methods. JAD Sessions with client for data gathering and business rule clarification. T-SQL queries and procedures are utilized for testing and data verification. ACCESS and EXCEL are heavily used during analysis. MS SQL Server 2008.

Confidential

Data Architect/Analyst/Modeler

• Requirements facilitator with stakeholder s Identified and documented: data sources, discovered business rules for base and derived data and data relationships.
• Broke out multi-use, embedded legacy fields to atomic level.
• Determined data required for strategic decision making calculations, aggregations .
• Tasks included determination of authoritative sources for data, performance measures for data validity, and historical uses for data and maintenance of enterprise data model with Power Designer.
• Performed data model and DW Data Mart review and presentations.
• ETL performed filtering, aggregation and summary of data for reporting and creation of metrics.
• Separated OLTP data from analytical processing to reduce impact of data analytics on performance Improved response time for end-user reports through query tuning, indexing and end-user education in best practices.
• Performed capacity planning. 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. Ensured traceability of requirements to test cases and design artifacts RUP .
• Created functional and non-functional specifications from systems design to development of the modules.
• Created, documented and executed test plans manual/automated for QA of business rules and deliverables.
• Provided training and created technical documentation for staff members. Handled projects with 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.
• Implemented User Interface during Legacy re-write of IMS/CICS and DB2 to J2EE/.Net framework utilizing Oracle and SQL Server databases Web Service and DB2 batch interfaces to legacy system
• Coordinated database updates/release management. Management decision support included the creation of white papers on emerging technology. Pivot tables, cubes, dimensional data models and forecasting predictive analytics and performance metrics Hyperion/Cognos/Excel Development DBA conceptual/ logical/ physical
• Wrote PL/SQL triggers and procedures. Web Project Management utilizing modified SCRUM, Performed a heavy amount of QA with 98-99 accuracy.
• Utilized IBM Rational toolset RSA, Requisite Pro, Clear Case, Clear Quest, Web Sphere, Business Objects, Financial Reporting, J2EE, Oracle 10G, DB2 UDB9, SQL/Server 2005/8/10, MQ, SOA , TOAD, Crystal Reports Training. Microstrategy
• 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 and evaluated data models normalization, primary key and foreign keys Utilized ERWIN, EXCEL and VB Scripting.
• Responsible for Data Dictionary creation and maintenance. Utilized 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

ECMS

• Managed migration of all database changes, stored procedures, and batch programs from development to system test and production. Maintained IS Training Database.
• Performed conceptual, logical and physical database modeling and generated the DDL using 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 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, Lotus Notes, application security, Power Designer, PL/SQL and Sybase Info-Maker, Info Sphere, IBM Crystal Reports and Business Objects . Created and documented database administration procedures for In-House us e of Power Designer for routine data base administration tasks including DB2 mainframe requirements. SAP Interface.

Confidential

.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. Developed software and hardware solution s GSA comparison, ROI, justification for 5 Year Plan/budget.
• Completed Microsoft NET course track and SQL/Server Database Administration coursework. 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
• Oracle Financials SAP support

Confidential

Systems Analyst

Developed an online programming package for the cigarette program in Developer 2000, Designer 11i, Crystal Reports, VB, Oracle Forms/Reports.

Confidential

• Reducing redundancy, error and operating cost by API development and PL/SQL.
• Converted existing database to Oracle database structure ERWIN
• Utilized SQL/Loader, performance tuning and APS. Legacy re-engineering. IMS to Oracle. Performed online/batch conversion and SIT/SAT. Team Lead project coordinator for SIT/SAT problem resolution for application/database issues 18 months .
• SAP: Logistics Financials Materials Management.

Confidential

Database Consultant

• Analyzed and converted the AllFirst statement system for Dauphin Deposit merger.
• Managed: Unit Testing, QA, UAT, SIT/SAT, Mock1 2, and conversion turnover

Confidential

Database Consultant

Responsible for Oracle PL/SQL development for Cornell Forecasting System. Initial data warehousing efforts.

Confidential

Database Integration Team Lead

• Performed as team lead/QA analyst for IMS to DB2 Conversion for STARS at NAVICP.
• Automated data collection from the data warehousing environment. Developed system performance measurement indicators for NAVICP STARS MIS for the monitoring of critical decision support elements for the Defense Finance Accounting System HQ and its user community. Data warehousing/BI Reporting. Cognos.
• Performed systems analysis, design and development of a GUI Client Server interface