Dw Data Architect Resume
DetroiT
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.
TECHNICAL SKILLS:
Operating Systems: IBM 3090 and MQ Series, 4341, z/OS, OS/390, 370, 360; MVS/XA or ESA
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, Detroit
DW Data Architect
Responsibilities:
- 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, Columbia
Enterprise Data Architect/Data Modeler
Responsibilities:
- 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
Responsibilities:
- 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, Columbia, SC
Conversion Data/Business Analyst
Responsibilities:
- 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, Harrisburg, PA
Data Architect/Analyst/Modeler
Responsibilities:
- 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 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 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 . Microstrategy)
- Managed migration of all database changes, stored procedures, and batch programs from development to system test and production. Maintained IS 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 use of Power Designer for routine data base administration tasks; including DB2 mainframe requirements. SAP Interface.
Confidential, Marietta, PA
Sr. Engineer/Database Administrator
Responsibilities:
- 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 of site-wide IS courses. Researched and selected vendors adhering to budget requirements. Scheduled Project Management 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, York, PA
Systems Analyst
Responsibilities:
- Developed an online programming package for the cigarette program in Developer 2000, Designer 11i, Crystal Reports, VB, Oracle Forms/Reports.
- 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.
- Analyzed and converted the AllFirst statement system for Dauphin Deposit merger.
- Managed: Unit Testing, QA, UAT, SIT/SAT, Mock1&2, and conversion turnover