SUMMARY

• More than 20 years of experience in database and application design, and development. Seasoned architect, analyst, integrator, developer, and modeler with significant expertise in business intelligence, data warehousing, business process management (BPM), organizational change management (OCM), data governance, and service - oriented architecture (SOA).
• More than 20 years of business analysis, data analysis, systems architecture, modeling, data warehousing, and business intelligence experience.
• More than 15 years of SQL experience, including the development of procedures, triggers, packages, and views.
• Ability to turn around high quality architectural, functional, and technical documentation rapidly.
• Seasoned analyst with expertise in enterprise application process and data modeling, cross-platform migrations and conversions, relational database design and normalization, and software reengineering.
• Excellent relationship building skills across the enterprise and with vendors and customers.
• Strong meta data management governance and data lineage and profiling skills in the development of KPIs, data marts, and dashboards.
• Strong troubleshooting skills relating to data quality or software defects.
• Proven ability to oversee or execute all software life-cycle activities from requirements analysis to software implementation and support within a distributed organization.
• Agile/Scrum experience including sprint planning, user stories development, backlog grooming, fostering client partnership, and cost/revenue forecasting.

TECHNICAL SKILLS

Data Modeling: Erwin, Embarcadero/ER Studio, Mega, InfoSphere Data

Languages: SQL, Java, J2EE, .Net, C, C##, Power BI, MySQL, XML, PL/SQL

Operating Systems: Mainframe, Unix, Linux, Windows, IBM

Paas: MS Azure, MS AX 2009, MS AX D365, MS CRM, MS MDM

Saas: Salesforce.com

Integration Services: Informatica Powercenter, SSIS, SAP BODI and Cloud Integration

Methodologies: Waterfall, Agile, Hybrid

PROFESSIONAL EXPERIENCE

Confidential

Senior Business Analyst

Responsibilities:

• Built strong working relationships with business users across and outside of the enterprise.
• Developed use cases, requirements, and process flows.
• Created functional and technical designs and worked with developers on product builds.
• Created, executed and facilitated test strategies, plans, and scripts.

Environment: Microsoft AX 2009, AX D365, MicroStrategy, Adaptive, SSIS, SSRS, Clarity, VSTS, Atlas, Tango, CRM, MDM, Informatica, Azure.

Confidential, Tempe, AZ

Test Data Engineer

Responsibilities:

• Day-to-day operational support of data obfuscation and provisioning in non-production environments.
• Development, maintenance, and enhancement of TDM capabilities, repeatable processes, governance framework, and testing tools.
• Interacted with business analysts and end users, maintained inventory and documentation, provided subject matter expertise.
• Provided project estimating, developed test cases and plans, identified risks and issues and developed mitigation and resolution strategies, built SQL queries to verify obfuscation results.
• Wrote extensive documentation to facilitate knowledge transfer to new team members.

Environment: Windows, DB2, Linux, CA Datafinder, Optim, Oracle 12c, SQL Server 2008/2012, Postgres/Greenplum, TOAD, Visual Basic, Clarity.

Confidential, Phoenix, AZ

Senior Programmer/Analyst

Responsibilities:

• Wrote requirements and developed and supported bill of materials and back orders supply chain systems using Rapid Response workbooks and configuration and Oracle packages.
• Integrated the Rapid Response 1A system with workbooks, packages, SQL Loader, and AutoSys job chain scheduling.

Environment: Kinaxis Rapid Response, PL/SQL, SQL Loader, JDA, SAP, Unix, AutoSys, SQL Developer, Harvest

Confidential, Phoenix, AZ

Senior Data Architect

Responsibilities:

• Performs structured data requirements analysis and data modeling in support of application development for relational and reporting databases.
• Supports the development of enterprise data architectures.
• Uses proven methodologies for analyzing and presenting data.
• 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

Development and Production Oracle and SQL Server DBA

Responsibilities:

• Lead on development change management requests ensuring that they flowed smoothly through the weekly deployment process.
• Each week, there were about 30 deployments in progress and ten deployments planned for that week.
• Lead for business intelligence using SSIS ETL and a front-end of Crystal Reports Server, Excel Analytics Cube, and Strategic Analyzer.
• DBA tasks included server upgrades, patching, scrubbing, permissions, optimization, imports, exports, migrations, and architecture.
• Established Confidential University, a weekly forum for information sharing across the entire IT department.

Environment: Oracle 11gR2, Microsoft SQL Server 2008 and 2012, SSIS, SSAS, SSRS, Strategic Analyzer, Excel cube, Crystal Reports, TFS, Linux, PowerShell Windows scripting, Microsoft Dynamics AX.

Confidential, Phoenix, AZ

Senior Consultant

Responsibilities:

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

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

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.
• This project is estimated to save 12,000 hours per year on 54 complex air emissions and chemical inventory, hazardous waste, Tier II, waste water, and toxic release inventory reports.

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

Confidential, Phoenix, AZ

Lead Information Architect

Responsibilities:

• Lead Information Architect for the Choice enterprise.
• Coordinated the work of technical, data, ETL, and BI analysts, developers, and testers.
• Oversaw the design of the data and technical architecture of the data warehouse.
• Integrated CA Wily monitoring tool to data warehouse repository.
• Major projects included click thru campaigns and guest insight survey data.

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

Confidential, Mesa, AZ

Senior Consultant

Responsibilities:

• On the Enterprise Supply Chain Management Systems (ESCM) team that supports an established Oracle system that runs processes controlled by UNIX scripts.
• Participated in the Capability Model Maturity Integration (CMMI) system development level three life-cycle and Lean+ initiatives.

Environment: Oracle 9i/10G, Oracle Developer/Administrator, XML, UNIX, SPO, SLIC, GOLD, TAV, APIs, Java, ClearCase, ClearQuest, Business Objects, ColdFusion, MECA, PVCS, A2A Application Integration Brokers.