We provide IT Staff Augmentation Services!

Data Architect Resume

4.00/5 (Submit Your Rating)

Mt Laurel, NJ

OBJECTIVE:

Senior Technology Lead/Data Architect Position

SUMMARY:

Solid experience in data warehouse design and development; Strong knowledge in ETL tool Informatica, SAP Data Services, IBM Data Stage and SAP Business Objects BI tools including Central Manager Server, WEB Intelligence and Explorer; highly skilled professional experience in SAP HANA, Oracle RDBMS design and development, data modeling, and PL/SQL; Strong background in multi - platform computer systems.

COMPUTER SKILLS:

  • SAP Data Services, SAP HANA, SAP Business Objects, Web Intelligence
  • Embarcadero ER/Studio 9.0, ERWIN Data Modeler 4.12
  • Informatica Power Center 8.5
  • IBM DataStage
  • Oracle SQL and PL/SQL, Java, Java Script
  • Visual Basic, C, C++, MS Visio
  • SAS BASE/MACRO, SAS/STAT, MS SQL Server

PROFESSIONAL EXPERIENCE:

Data Architect

Confidential, Mt. Laurel, NJ

Responsibilities:

  • Work as a Lead Data Warehouse Architect for Confidential using SAP Big Data Intelligence solutions with SAP HANA, SAP Data Services 4.2, and SAP BI Platform 4.1 to design and develop enterprise data marts for various business areas including Vehicle Fleet Management, Vehicle Inventory, Vehicle Expenses, Vehicle Fuel Analytics Info spaces.
  • Designed and developed Dimension Model for Telematics using Embarcadero ER/Studio 9.0
  • Design and develop multiple SAP Explorer Info spaces for Confidential major clients
  • Develop automation program using Business Objects Macros and Java for email distribution of hundreds of BO report results in excel or pdf format to corresponding users in timely manner.

Senior Technical Analyst

Confidential, Collegeville, PA

Responsibilities:

  • Worked on Wyeth IMPACT to Confidential RighTrack II Integration Project
  • Designed and developed Clinical Data Exchange (CDX) using Informatica Power Center and Oracle store procedures
  • Coordinated with BI team, successfully designed and implemented the Medical Enterprise Reporting & Logistical Intelligence Network (MERLIN)
  • Worked as lead developer successfully completed Clinical Business Continuity (CBC) project
  • Worked as lead developer successfully completed the project that allows system automatically load subject data from the ODS into International Management Package for the Administration of Clinical Trials (IMPACT) and eliminate the manual data entry currently performed by site monitors
  • Helped Contribute to completion and implementation of Decision View (DV) Project by creating important Oracle store procedures and updating MERLIN universe.
  • Successfully tuned the long running existing Business Intelligence Reports (BIR) to significantly cut down the scheduled report run time
  • Successfully interacted with diverse user/customer base and ensured delivery of top quality products to meet business needs.

Senior Application System Analyst

Confidential, Fort Washington, PA

Responsibilities:

  • Developed Data Stage Batch Run process using IBM DataStage for Confidential Reporting Confidential for Wholesale Lending Business and Retail Lending Business
  • Built BO repository with multiple universe/report domains for different business groups (Wholesale, Retail, Capital Markets etc.).
  • Developed Business Objects Universes for Proof of Concept, Whole Sale Rate and Price, Security and Administration for Mortgage sales department; Designed and implemented row-level security in the BO repository

Data Warehouse Specialist

Confidential, O’Fallon, MO

Responsibilities:

  • Worked as an independent contractor to help build a Confidential for Confidential Marketing Team, and build a Business Objects universe connecting to the Confidential .
  • Involved in building MarketScope Application using Confidential

BO Administrator and Support Specialist

Confidential, Montgomeryville, PA

Responsibilities:

  • Designed and developed BO universes and reports for management, Account Receivable, Account Payable, Sales, Purchasing and Manufacturing departments.
  • Worked in upgrading Business Objects, Web Intelligence and Broadcast Agent Server, training end-users, planning and distributing reports and decision support tools over the web/intranet
  • Administrated BO repository including user accounts, universes and documents

Consultant

Confidential, Blue Bell, PA

Responsibilities:

  • Worked at Confidential Group for Confidential Oracle database design and development under VAX and UNIX systems
  • Created queries, views, stored procedures, functions, and triggers using Oracle SQL and PL/SQL for Clinical Data Management group
  • Responsible for Y2K remediation of the Oracle database and Confidential

Programmer

Confidential, Philadelphia

Responsibilities:

  • Helped design and develop company Client/Server systems for sales, inventory, shipping and management using Visual Basic as front-end and Oracle as back-end

Database Developer

Confidential

Responsibilities:

  • Designed, developed and implemented Relational Database Management System using C and Oracle to enable customers timely retrievals of critical information used for business decisions

We'd love your feedback!