We provide IT Staff Augmentation Services!

Senior Data Architect Resume

5.00/5 (Submit Your Rating)

Phoenix, AZ

PROFESSIONAL SUMMARY:

  • Agile/Scrum experience including sprint planning, user stories development, backlog grooming, fostering client partnership, and cost/revenue forecasting.
  • More than fifteen years of systems architecture, modeling, data warehousing, and business intelligence experience.
  • Seasoned architect, analyst, integrator, developer, administrator, and modeler with expert - level expertise in business intelligence, data warehousing, business process management (BPM), organizational change management (OCM), master data management (MDM), and service-oriented architecture (SOA).

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Senior Data Architect

Responsibilities:

  • Business and data requirements and impact analysis
  • Data architecture definition
  • Data modeling design and integration
  • Data governance and MDM

Environment: DB2 UDB LUW, DB2 zOS, IMS, SQL Server, Oracle, Mongo DB, Trident Graph, SOA, Agile, Embarcadero ER/Studio Data Architect.

Confidential, Phoenix, AZ

DBA

Responsibilities:

  • Production DBA tasks included server upgrades, patching, scrubbing, permissions, optimization, imports, exports, migrations, licensing, troubleshooting, and architecture.
  • Our Oracle DBA environment has Oracle Linux, RAC, ASM, Clusterware/grid, RMAN, and OEM Cloud Control 12c. Our SQL Server DBA environment has multiple SQL Server 2008 and 2012 databases, and T-SQL and DTS stored procedures, SQL Server job agents, and dimensional entities.
  • Development DBA tasks included ensuring that change management requests ensuring flowed smoothly through the SDLC process and that software and data DDL and DML changes are expedited. Each week, there were about 30 deployments in progress and ten deployments planned for that week.
  • Provided support for business intelligence using SSIS ETL and a front-end of Crystal Reports Server, SSAS, Excel Analytics Cube, SSRS, and Strategy Analyzer.

Environment: Oracle 11gR2, Microsoft SQL Server 2008 and 2012, SSIS, SSAS, SSRS, BIDS, Visual Studio, Report Builder, Strategy Analyzer, Excel cube, Crystal Reports, TFS, Linux, PowerShell Windows scripting, Microsoft Dynamics AX, .NET, Embarcadero ER/Studio Data Architect.

Confidential, Phoenix, AZ

Senior Consultant

Responsibilities:

  • Provided consulting services for clients using the Oracle Enterprise Business Suite 11 and 12 and OBIEE. Projects included an EBS 11 to 12 upgrade, Oracle reports development, UNIX scripting, Siebel CRM. and IBM business intelligence Cognos 8 to 10 migration.

Environment: Oracle Enterprise Business Suite 11/12, Oracle 10g/11g, OBIEE 11g, IBM Cognos 8/10, Siebel 8.x, SalesForce.com, Apex.

Confidential, Chandler, AZ

Database Architect

Responsibilities:

  • Architected a logical and physical data model and SSIS ETLs to create a data mart to accommodate environmental reports, permits, and certificates to be stored in a global repository, with reporting using SSRS. Agile SDLC.

Environment: Microsoft SQL Server 2008 R2, Microsoft Visual Studio 2008, SSIS, SSRS, SharePoint 2010, MicroStrategy 8, SAP, Comply Plus Web.

Confidential, Phoenix, AZ

Lead Information Architect

Responsibilities:

  • Lead Information Architect for the Choice enterprise.
  • Developed the data and technical architecture and data models of the enterprise data warehouse.
  • Agile SDLC.

Environment: Informix IDS (for the EDW), SQL Server 2008, Oracle 11G, PeopleSoft, SAP/Business Objects XI, Cognos, UNIX, Erwin, Embarcadero/ER Studio, Mega, IBM InfoSphere Data Architect, XML schema, Java, JSON, J2EE, .NET, RazorSQL, Subversion, ClearCase, ClearQuest, CA Wily Introscope 8, web services technologies.

Confidential, Mesa, AZ

Senior Consultant/Ciber

Responsibilities:

  • On the Enterprise Supply Chain Management Systems ( Confidential ) team that supports an established Oracle system that runs processes controlled by UNIX scripts.
  • Confidential 's Rotorcraft Apache Longbow Helicopter Division in Mesa has 4,900 employees, and its primary customer is the Confidential .
  • ColdFusion front-end. Object oriented design and development.

Environment: Oracle 10G, OBIEE, Oracle Developer/Administrator, XML, UNIX, SPO, SLIC, GOLD, TAV, APIs, Java, ClearCase, ClearQuest, Business Objects, ColdFusion, Siebel 7.x, MECA, PVCS, A2A Application Integration Broker, Oracle AQ/IBM MQ Data Transports.

Confidential, Phoenix, AZ

Senior Consultant

Responsibilities:

  • Systems administration support for Confidential, an asset performance management system, with reporting, work management, and auditing functionality for 200 users, consisting of J2EE, EJB, JSP, XML, Oracle Discoverer, Oracle 9iAS J2EE/Enterprise and Web Cache, and Tomcat/Apache (UNIX) web methods application server.

Environment: Oracle 8i, Oracle Web Server, Oracle forms and reports 6i, Quest/TOAD, UNIX/AIX, Korn Shell, Erwin, Cognos, Informatica, AWK/SED, HTML, DHTML, XML, TSO, JCL, WS-FTP, IMS DB, ERP/SAP, Crystal Reports, JavaScript, Java Server Pages, Servlets, multithreaded programming.

Confidential, Phoenix, AZ

Senior Systems Analyst

Responsibilities:

  • Developed, modified, and tuned Pro*C reports, Oracle forms, and PL/SQL stored procedures.

Environment: Oracle 8, Pro*C, UNIX/Solaris, Korn Shell, Quest/TOAD, Oracle Developer, Forms/Reports Builder 6i.

Confidential, Tempe, AZ

Systems Engineer

Responsibilities:

  • Coded, tested, documented, and installed PL/SQL packages and procedures on a UNIX/HP platform to accommodate 15 partition table split of the Automated Clearing House ( Confidential ) Reject Repair and History database.
  • End-user population consisted of 7,343 end-users across 74 cost centers.

Environment: Oracle 8, HP-UX 11 OS, JDBC, Portlets, PL/SQL, Korn Shell, JavaScript/SSJS, Java, EJB, JSP, MVS, Oracle Call Interface/Common Gateway Interface (OCI/CGI), COBOL, TSO, JCL, IBM DB2, Unified Modeling language (UML), Rational Rose, ClearCase, Visio.

We'd love your feedback!