We provide IT Staff Augmentation Services!

Edw Architecture And Development Manager Resume

Seattle, WA

SUMMARY:

  • Confidential is a practiced and certified BI/EDW ETL consultant with over 10 years of IT experience .
  • Led cross functionality & integration architecture for mid - size and Fortune 500 organizations .
  • Thrived in a fast-paced, bottoms-up environment, delivered innovations to the business evolution.
  • Laid out plans and strategies using business intelligence to drive business transformation and the interactions among people, process and technology to achieve overall strategies/objectives.
  • Designed 100’sTB Enterprise DW on Massively Parallel Processing (MPP) environment.
  • Dived into SQL Internals, designed Physical/Logical Data Model and written 1000+ db objects.

SUMMARY:

PM/SDLC Phases: Plan, Design, Implement, Test, and Maintain (SCRUM, Agile Development)

Diagram: Erwin E-R, Data Flow, Work Flow, Network Architecture, Swan, Fishbone

Data Source: SQL Server 2008/2005/2000/7/6.5 , Oracle 11i/10g/9/8/7i, DB2, XML

Servers & Tools: PDW, SSAS/SSIS/SSRS/Visual Studio 2008/2005, DTS 2000/7, Erwin 7/4/3

Data Analytics ( SPSS ): Correlation, Decision Tree, Profiling, Association, Regression, Clustering

EXPERIENCE:

Confidential, Seattle, WA

EDW Architecture and Development Manager

Responsibilities:

  • Provide directions e.g. Data Governance/MDM/Metadata ETL to team. Design performance metrics/KPIs to align with business strategic/goal, business transformation, & cross functionality.
  • Plan & manage features, resources, infrastructure on MPP Parallel Data Warehouse (PDW).

Environment: Erwin 7.3, PDW, SQL/SSAS/SSIS, Windows 2008 R2, WCF, Omniture

Confidential, Seattle, WA

EDW- Sr Database Architect

Responsibilities:

  • Designed data model. Streamlined ETL Process. Improved ETL Performance by 300%.
  • Worked with The Kimball Group on BI, MDM Hub, ETL Assessment. Coached developers.

Environment: MDM, SQL Server/SSAS/SSIS, Windows 2008, MOSS 2007 Team: 20

Confidential, Redmond, WA

DW Architect/Dev Lead

Responsibilities:

  • Architected Marketing Intelligence Consolidated Dimensional Model, Data Warehouse & ETL.
  • Created SSAS data marts that lin k among marketing organizations, licensing programs (LPO).
  • Integrated MS Sales, MMBC, WWAD, Siebel etc VLDBs using SSIS. Remodeled metrics, KPI.
  • Managed onsite and off-shore BI resources. Led a development team of BA and 5 Developers.

Environment: Erwin 7.2, SSAS/SSIS/SSRS 2008, Windows 64bit Server 2008 Team: 6-20

Confidential, Redmond , WA

Architect/Senior Consultant

Responsibilities:

  • Architect ed automated ETL for GPF users worldwide to consolidate files with only SQL/SSIS.
  • Built PerformancePoint/MOSS 2007 BI prototype applications.

Confidential, Mahwah, NJ

Database Developer

Responsibilities:

  • Led as Data Architect/Project Lead to interface for requirements, timelines and deliverables.
  • Performed SDLC functions and prepare docs for: project plan, use requirements, system design, functional specifications, GUI prototype, test scripts, database architecture and data modeling.
  • Performed Cost/GAP Analysis. Led contract negotiation that leads to 25% saving in vendor costs.

Environment: Window 2000/2003, IIS 5/6, .NET 1.1/2.0, SQL Server/SSAS 2000/2005 VLDB, DTS/SSIS, Sagent 4.5, Erwin 3.5/4, MSMQ & ChasePaymentTech, ARTS Model Team: 14

Confidential, NJ

DBA/Architect Administrator/Architect

Responsibilities:

  • Laid-out midterm strategic plan to Executive VP that enhance innovation-, product-, & service-oriented turnkey solutions. Led Change Management as part of Agile Development of SDLC.
  • Led SQLXML Integrations. Migrated 600+ tables. Evaluated EAI tools: Informatica, Tibco.

Environment: MS Project, Window 2003, NET 1.1/2.0, SQL Server 2000/2005 CTP, Oracle 9i/10g, Analysis Services, DTS/SSIS, XMLSpy, VISIO, Hyperion, Embarcadero Team: 40

Confidential, Stamford, CT

DBA/Analyst

Responsibilities:

  • Designed ETL Architecture. Integrated divisions' systems into a centralized repository.
  • Integrated GreatPlains, SalesLogix and GlobalWare. Improved flight projections by 28%.

Confidential, New York, NY

Integration Developer

Responsibilities:

  • Developed subject data models.
  • Wrote stored procedures to get feeds from content aggregators .
  • Transformed data to XML format, and feed to SQL Server using DTS, Cambio & DataJunction.

Hire Now