We provide IT Staff Augmentation Services!

Data-warehouse Architect Resume

4.00/5 (Submit Your Rating)

Boca Raton, FL

SUMMARY:

Respected senior data warehouse architect with almost two decades of multi - industry experience. Accomplished Data Warehouse architect and implementation specialist with a history of superior performance. Successful leader of full life cycle projects involving Enterprise Application Development through Business Intelligence. Skilled in Informatica, Trillium, Oracle, Embarcadero, Business Objects, OBIEE, Informatica cloud, Sales Force and Big Data. Certified Business Intelligence Professional (CBIP) from TDWI.

AREAS OF EXPERTISE:

  • Architect Design
  • Architect Development
  • BI/DW Solutions
  • Informatica Cloud & SalesForce
  • Customer Data Integration
  • Data Quality
  • Data Governance
  • Big Data
  • Metadata managment
  • Self-Service BI
  • Master Data Management
  • ETL

KEY SKILLS ASSESSMENT:

ETL & BI: Informatica, Syncsort DMExpress, Trillium Data Quality, Business Objects, Crystal reports, Oracle Reports, OBIEE, Big Data

Cloud Technologies: Informatica Cloud, Salesforce CRM

ERP: Oracle E-Business Suite

Databases: Oracle, SQLServer, Sybase and Informix

Scripting: Unix Shell Scripts, Windows Batch Scripts, PERL

Languages: Java, ASP, Oracle Webserver(PLSQL Cartridges), Oracle Forms, Visual Basic, C, Pro*C, PERL

Tools: Embarcadero, Erwin, Oracle Designer, JBuilder, JDeveloper, Visual Source Safe, Toad, SQL Navigator, Autosys, Control-M

PROFESSIONAL EXPERIENCE:

Confidential, Boca Raton, FL

Data-warehouse Architect

Technical Environment: Informatica, Trillium, Oracle, Unix Shell scripting, Business Objects, Embarcadero, Toad, OBIEE, Informatica Cloud, Sales Force, Big Data.

Responsibilities:

  • Project estimates, time line, resource and budget planning as well as vendor selection and vendor management.
  • Key contributor to solution architecture, architecture and design of future state applications and business transformation for order to cash program enterprise wide.
  • Key contributor to architecture, strategy, implementation and support of Data Integration, Business Intelligence, Master Data Management strategy and Performance Management Solutions to business users across North America.
  • Key role in development of BI strategy and roadmap, BIDW methodology, BI Artifacts, BI/DW architecture standards. Re-architecture of Datawarehouse platform using BI reference architecture as well as Kimball and Inmon methodologies.
  • ETL and DB environment architecture, design, development for implementation of BI solutions. Architected and executed the upgrade of BI/DW environment on time and very low budget. Administration of Informatica and Trillium environments.
  • ETL Code review for enforcement of ETL standards. Process optimization of BI/DW ETL processes.
  • Coordination with onsite and offshore teams for successful implementation.
  • Architecture, design and implementation of ETL and Data quality solution for customer data integration to identify and resolve exceptions between Billing and Service delivery applications.

Confidential, Boca Raton, FL

ETL Lead

Technical Environment: Informatica, Oracle, Unix Shell scripting, PERL, Informix, C, Bugzilla, Control-M, DMExpress, Syncsort

Responsibilities:

  • Steered and facilitated Requirements Analysis sessions with business groups. Project proposals, estimates and resource planning.
  • Developed Technical requirements document. Data modeling, system data analysis, design and database creation.
  • Lead Technical design and development for ETL for large data warehouse.
  • Review Technical Design Document and Test Plans with the technical board.
  • Coordinate Onsite and Offsite development with development teams as well as coordinate system and integration testing with QA teams onsite and offsite.
  • Develop production run books and best practices. Production deployment and KT to Production Support team.

Confidential, Miami, FL

Technical Lead

Technical Environment: Informatica, Crystal reports, Oracle, Unix Shell scripts, Windows batch scripts, PERL, SQLServer, Autosys, Java, C, Pro*C, ASP, Visual Source Safe

Responsibilities:

  • Participate in JAD sessions with business analysts, clients.
  • Coordinate and participate in Technical architecture sessions for ETL and CRM products.
  • Develop and review Technical Design documents.
  • Lead technical teams onsite and offsite.
  • Client interaction and user interaction for requirements, demos and training.
  • Project proposals, estimates and resource planning/
  • Lead ETL projects for dataloads and feeds.
  • Lead Web projects as well as client server projects.

Confidential, Miami

Senior programmer Analyst

Technical Environment: C, Pro*C, Oracle, Unix Shell Scripts, Windows Batch files

Responsibilities:

  • Design and development of interfaces product to interface time management and workforce CRM solutions with different ERP products.
  • Successfully implemented for leading aerospace and defense clients such as Boeing, Lockheed Martin, Raytheon.

Confidential

Senior Programmer Analyst

Responsibilities:

  • Development of automation software for manufacturing processes such as work order creation, purchase orders, invoices etc., for clients such as Allied Signals and Confidential .

Technical Environment: Java, Net Dynamics, HTML, Java Script and Oracle Database, PL/SQL

Confidential

Software Engineer

Technical Environment: C, Pro*C, Oracle, Forms, Unix Shell scripts, Oracle Reports, Visual Basic

Responsibilities:

  • Development and testing of modules such as ATM banking, anywhere banking, Trade Finance, CORBA etc., for Finnacle, banking automation product of Infosys.
  • Production Planning and Control department functions that include data analysis and generation of production, sales and inventory reports.

We'd love your feedback!