Data Architect Resume Profile
Experience Summary
- Overall 14 years of IT experience in various phases and various roles of IT projects such as System Analyst, Data warehouse Architect, ETL Architect, Dimensional Data Modeler, ETL Technical lead, , ETL Designer, management activities like estimations, Project planning, Customer interactions, Requirements meetings with Business team, Onsite Coordinator for on-site/offshore model, Design, Development, coding, Testing and Implementation of business applications for Telecom, Manufacturing and Insurance.
- 8 years of experience working on Data warehouse projects primarily as a Data warehouse Architect, Dimensional Data Modeler, ETL Architect and Technical lead.
| |
| |
| |
| |
| |
| |
| |
|
PROJECT EXPERIENCE
Confidential
Data Architect
Technical Environment: IBM DB2, IBM DataStage 8.7, Data Studio 3.1, Java JDK/JRE 6, JaxWS-Spring, ASM,BEANS 6.1.1
Responsibilites/Contribution
- Requirement Analysis and System Study
- ODS data integration framework study
- Source-Target data element mappings
- ETL Architecture and ETL High level design
- ETL Framework components design
Confidential
Data Architect
Technical Environment: Oracle 11g, Power Designer
Responsibilites/Contribution
- Technical landscape review meetings
- Marketing applications review meetings
- Central Data hub architecture
- Conceptual data modeling, Physical data modeling
- Physical design recommendations
- Data migration strategy and Proof Of Concept support
Confidential
Dimensional Data Modeler, ETL Architect
Technical Environment: IBM DB2 UDB, IBM DataStage 8.7. SQL, IBM Cognos v10
Responsibilites/Contribution
- Requirements Analysis by working with the Business Analysts
- Dimensional Data Modeling
- ETL Architecture and ETL High level design
- ETL Framework components design
- Historical data migration strategy and design
Confidential
ETL Architect, ETL Lead
Technical Environment: Oracle 11g, PL/SQL, Oracle Data Integrator ODI 11g , OBIEE 11g, Business Objects, Autosys
Responsibilites/Contribution
- Conduct technical review meetings
- Requirements Prioritization
- Enterprise Data warehouse Architecture and High level Technical solution
- Study Oracle retail data model
- Phase wise implementation plan and strategies
- Road map for the enterprise warehouse implementation and strategic directions
- ETL architecture and ETL design for Merchandise data mart
- Creating ODI interfaces for extract and integrate data from sales, supplies systems
- Creating ODI packages
- Creating ODI Load plans for controlled and parallel execution of End-to-End data integration flows.
Confidential
Technical lead and Onsite Coordinator
Technical Environment: Oracle 10g, DataStage 7.5, DataStage 8.1, DataStage 8.5. SQL, PL/SQL, Control M
Responsibilites/Contribution
- Prepare Migration strategy and guidelines for migration of DataStage jobs on 7.5 and 8.1 to DataStage 8.5 version.
- Estimation and planning for the migration program
- Environment setup and configuration
- Control M scripts modifications
- Monitoring and heading the execution team
Confidential
ETL Technical lead and Onsite Coordinator
Technical Environment: Oracle 10g, Oracle Data Integrator ODI , SQL, PL/SQL, Cognos
Responsibilites/Contribution
- Requirement Analysis
- Prepared Solution Architecture Package HLD
- Prepared ETL architecture document and ETL specification documents.
- Coordination of ETL development activities
- Building ETL jobs using ODI 10g.
- Writing ODI Knowledge modules for Integration, Loading.
- Creating ODI packages for End-to-End data integration flows
- Technical consultation on ETL track.
- Production support
Confidential
Dimensional Data Modeler, ETL Architect, Technical Lead and Onsite Coordinator
Technical Environment: Oracle10g, SQL, PL/SQL, Oracle Warehouse Builder OWB 10.2.0.5 , Toad, Attunity Stream flow, ERWIN 6.0, Unix Shell Scripting, Crontab, SQL Developer, SQL Loader, WebFocus
Responsibilites/Contribution
- Requirement Analysis
- Data warehouse and Data mart architecture
- Dimensional data modeling
- ETL Architecture and High/Low level Designs
- Source to target mapping specification document
- Oracle Change Data Capture CDC to capture the incremental load from the sources
- Building ETL Mappings Process Flows using OWB, PL/SQL and Unix shell scripting.
- OWB Process Flows for controlling the sequence of data load
- Performance tuning of ETL scripts using TKPROP, EXPLAIN PLAN utilities
- Wrapper Unix scripts for Scheduling ETL jobs through Crontab
- System Test Cases for Data Validation, Data Transformation, Data Quality, Regression Testing
Privacy Policy
Resume Categories
- .NET Developers/Architects Resumes
- Java Developers/Architects Resumes
- Informatica Developers/Architects Resumes
- Business Analyst (BA) Resumes
- Quality Assurance (QA) Resumes
- Network and Systems Administrators Resumes
- Help Desk and Support specialists Resumes
- Oracle Developers Resumes
- SAP Resumes
- Web Developer Resumes
- Datawarehousing, ETL, Informatica Resumes
- Business Intelligence, Business Object Resumes
- MainFrame Resumes
- Network Admin Resumes
- Oracle Resumes
- ORACLE DBA Resumes
- Other Resumes
- Peoplesoft Resumes
- Project Manager Resumes
- Quality Assurance Resumes
- Recruiter Resumes
- SAS Resumes
- Sharepoint Resumes
- SQL Developers Resumes
- Technical Writers Resumes
- WebSphere Resumes
- Hot Resumes
