Mdm Architect/data Modeler Resume
PROFESSIONAL PROFILE:
- I have twelve years of experience in Business Intelligence (BI), Data Quality/Governance, and Master Data Management (MDM).
- I have worked as a BI solution architect ETL data modeler/architect, and MDM data modeler/architect.
- I am proficient in IBM DataStage, Microsoft SSIS, Business Objects, Cognos, SAS Dataflux/MDM, and SQL.
- I’ve done solution architecture, data architecture/modeling, and data quality management.
- MDM architect/data modeler - As MDM architect I design 3NF MDM data model using CA Erwin; this involves source data analysis, data profiling and logical and physical data model validation. I define and implement data quality & governance initiatives including best practices for MDM/ETL processes, data remediation and mismatch reports, and ETL/quality process flow for data intakes.
- ETL architect - As ETL architect I’ve designed logical and physical star and snowflake data models, ETL processes, and implemented ETL standards and best practices.
- DataStage design, best practices, and administration - I’ve designed ETL applications using IBM DataStage performed DataStage migration, version 7.5 to 8.1; designed web services using DataStage; developed standardization and CASS validation using IBM Quality Stage, performed DataStage 8.7 install, user role creation and maintenance, code migration, freeing up DataStage job locks, and server maintenance.
- Report design/development - I’ve designed universes and reports using SAP Business Objects (BO) 6.5 and XI R3; I’ve used desktop intelligence (DESKI) and web intelligence (WEBI) tools for report design, performed migration of BO reports and universes from version 6.5 to XI R3. I’ve experience in doing report design using Cognos 10 (query studio, framework manager).
AREAS OF EXPERTISE:
- ETL architecture/data model
- MDM architecture/data model
- Best practices - ETL, Data Quality
- DataStage design/development
- DataStage administration
- Logical and physical data models
- Report design and development
- Application and data migration
- Technical leadership
SKILL MATRIX:
IBM DataStage, Quality Stage
SQL server 2000, 2005, 2008
UNIX shell scripting
CA Erwin
SAP/SAS MDM/Dataflux
Microsoft SSIS, DTS, and SSAS
SAP Business Objects
Oracle/DB2
Windows/VB Scripting
Autosys/control M/Tidal
Soap UI
MDX
Cognos - Query Studio and Framework manager
Teradata
JCL
C, COBOL
Tactician One
MS office suite
CHRONOLOGY OF EXPERIENCE:
Confidential
Tools: /Databases: SAS MDM, SAS Dataflux, IBM DataStage 8.7; SQL server 2008; Oracle 11i; Tidal, Visual Basic
MDM Architect/Data Modeler
Responsibilities:
- I design 3NF MDM data model using CA Erwin; this involves source data analysis, data profiling and logical and physical data model validation.
- I’ve implemented data profiling best practices in SAS Dataflux and driven the team towards using standards and developing re-useable objects;
- I’ve designed the cleansing, standardization, match rules, trust rules, survivorship rules, entity relationship mapping for health care providers’ MDM;
- I’ve designed web services for online provider directory from MDM hub.
Confidential
Tools: IBM DataStage 7.5, 8.7; Cognos 10; SQL server 2000, 2005, 2008; Oracle 11i/R12; Tidal
ETL Architect
Responsibilities:
- I did solution design for ETL applications.
- I developed standards and best practices for ETL processes;
- In my role as an ETL architect I did the “AS IS” ETL landscape analysis; based on this analysis
- I developed the road map for ETL landscape with tangible deliverables at end of six months, one year, and two years; In this small BI team
- I also performed DataStage 8.7 administration including installation of the server and the client, setup of database connections, DataStage users, and roles.
Confidential
Tools: DataStage 7.5, 8.1, 8.5; SAP Business Objects 6.5, XI R3; Microsoft SSIS, SSAS SQL server 2000, 2005, 2008; IBM DB2; Oracle 11i; Control M
ETL/Reporting Lead
Responsibilities:
- I designed data feed from SAP MDM to IBM WebSphere Commerce using DataStage 8.1; the challenging design involved web service calls from DataStage to web services hosted on MDM; the design also involved creation of custom logic for pivoting row to columns;
- I designed logical and physical data model the reporting data mart (star snowflake);
- I also designed SAP Business Objects universes and reports.
- I designed and developed ETL applications in DataStage 8.1 parallel environment;
- I designed SAP Business Objects universes;
- I managed work distribution to ETL developers, assisted project manager in building the project plan and determined timelines by providing development estimates.
- Designed/developed DataStage/Quality Stage application code; designed/developed web services on DataStage 8.1; performed performance tuning on web services for real time loads using soap UI; I deployed web services in different environments, migrated DataStage and quality stage code from version 7.5 to 8.1, and developed and implemented master data survivorship rules.
- As ETL lead for DataStage migration project, version 7.5 to 8.1 I setup DataStage environments; performed regression testing on DataStage application code to ensure data integrity.
- As Business Objects developer for migration project, version 6.5 to XI R3 I validated report data between 6.5 and XI reports to ensure the data integrity; performed troubleshooting for reports that generated different results between the environments; ensured that the metrics delivered by the reports in new environment met the business requirements; implemented design changes for database changes for performance optimization; created functional and technical specifications; created data flow diagrams for applications using Visio.
- As DataStage production support specialist I performed in-depth analysis of production issues; fixed existing and developed new DataStage code as a part of solution; developed one time DataStage application code or SQL queries to fix historical data; ensured that DataStage application code met the required Service Level Agreement (SLA) by doing performance tuning; validated business requirements and ensured that the application code met them.
Confidential
Tools: DataStage 7.5; Oracle 10g; SQL Server 2000; Autosys
ETL and Production Support Specialist
Responsibilities:
- I designed/developed DataStage application code for new database tables; performed unit testing, application support during system and integration testing; ensured data quality and integrity; implemented database design changes working closely with the DBA team to ensure performance optimization; identified and promptly fixed DataStage application code issues working closely with the testing team; wrote Oracle SQL scripts for data validation.