Data Architect Resume
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
