SUMMARY

• Senior Data Architect with over 18 Years of experience. Able to deliver data management vision, goals, priorities and design principles to meet the business goals of the organization.
• Management and implementation of database models, data flow diagrams, database schemas, DB scripts and data standards to support robust data management infrastructure.
• Solid experience translating business requirements into logical and physical data models.
• Implement best practices and methodologies in data analysis, design and modeling.
• Lead with ability to design efficient database ETL application solutions to meet strategic goals and objectives of data warehousing environment.
• Prolific in data warehousing architecture, data warehouse design methodologies, data integration, data migration, data modeling of analytical databases consisting of data warehouses data marts and operational data stores.
• Led key initiatives to identify data/process anomalies and designed cost effective solutions that improved performance of decision support systems.
• Strong in relational and dimensional data modeling including star schema.
• Expert in analytical reporting, root cause analysis of data/processing problems and pattern detection.

Technical Skills:

TERADATA 13, DB2, UDB, IMS DB, MS ACCESS, SQL SERVER, ORACLE, ERWIN 7.3, ROCHADE, MS EXCEL, MS VISIO, MS POWERPOINT, MS PROJECT, SQL ASSISTANT, MS WORD, UNIX AIX, AUTOSYS, DATASTAGE, WINDOWS XP, KORN SHELL, SED AWK, SQL, CRYSTAL REPORTS, IBM-MF, IBM AS/400, COBOL, CICS, IMS DC, REXX, TSO-ISPF, SPUFI, QMF, CA7, C, VISUAL BASIC, HTML, JAVA, PERL, CGI, APACHE WEBSERVER, DREAMWEAVER.

EXPERIENCE

Confidential

Data Modeler/Architect

• Reverse Engineered the staging data model for the mortgage banking data warehouse.
• Analyzed ETL processing to identify risk factors and made necessary recommendations to ensure data integrity in the data warehouse.
• Analyzed metadata repository options and made key recommendations towards the selection of MDR tool to be used by the data warehouse.
• Analyzed Ab-initio code and developed source to target mapping SQL scripts in the process of reverse engineering a legacy data mart to source data from new integrated consumer data warehouse.
• Involved in validation of the source to target mappings and ensuring quality of the data in the data mart.

Environment: Erwin 7.3, Teradata 13, MS Excel, SQL Assistant

Confidential

Data Architect

• Led the analysis and design effort in defining, sourcing and integrating billing and usage data from a legacy billing system into enterprise consolidated data warehouse.
• Interviewed SMEs of the billing system and performed functional system analysis and guided the project team in the creation of BRD and SRD.
• Analyzed sample billing data from billing system and helped stakeholders understand true business value of the resulting analytical data enabling them make informed decisions.
• Analyzed multiple record layout EBCDIC files from the legacy billing system and created logical data model to host the billing and usage data in the Data Warehouse.
• Traced and analyzed billing data flow across various billing systems into the data warehouse and prevented duplication of billing data.

Environment: Teradata 13, MS Excel, SQL Assistant, Erwin 7.3, MS-Office Word, Unix AIX, Korn Shell.

Confidential

Data Consultant

• Responsible for thorough assessment of information quality of key business reports.
• Made significant contributions in formulating reporting standards, good practices, control processes and methods to be incorporated into the business report development process.
• Validated several key business reports and identified several data quality issues and important risk factors. Reviewed the data quality assessment results with the report owners and made necessary recommendations to ensure data quality.

Environment: SQL Server, Teradata 13, MS Access, MS Excel, SQL Assistant, MS-Office Word.

Confidential

Sr. Data Architect/Analyst

• Architected several logical and physical data model components/subject areas of enterprise data warehouse.
• Made significant contributions in defining the strategy and architecture to utilize ODS data for master data management in the enterprise data warehouse.
• Created process models, design specifications, table column transformation rules, source to target mappings, flow charts in the process building enterprise data warehouse and data marts for several data warehouse customers.
• Experienced in defining and managing data domains, data dictionary and enterprise metadata.
• Led the analysis team in migration of a multi-terabyte integrated enterprise data warehouse from a DB2 database to TERADATA and conversion of the corresponding ETL processing.
• Performed root cause analysis of several complex data and ETL process defects to identify the fundamental causes and designed efficient solutions.
• Managed decommissioning of inbound and outbound processing of several systems of record in the enterprise data warehouse and data marts.
• Translated business requirements to BRDs, SRDs and drafted service level agreements between Enterprise Data Warehouse and data mart extract customers.
• Supervised and led the ETL design effort for the AML Hub conversion project which included creation of design specifications document, DFDs, table column transformation rules, source to target mappings.
• Created relational logical physical models and ETL design to host hierarchical data, received through MQ Messaging, from an IMS database in enterprise data warehouse.
• Mentored and trained onshore and offshore design teams in providing efficient database, ETL Design and in using ROCHADE which is an enterprise metadata repository tool for publishing metadata.
• Designed efficient database and ETL solution for building the BASEL dimensional data mart used for measuring credit and operational risk for bank loan portfolios.

Environment: Teradata 13, DB2/UDB, IMS DB, MS Access, MS Excel, MS Power Point, SQL Assistant, BTEQ, DataStage, Erwin 7.3, Rochade, MS-Office Visio/Word/Project/, Unix AIX, Korn Shell, Autosys.

Confidential

QA/Data Analyst

• Designed an efficient ETL design for loading the integrated applicant history and account history into the CCG data mart.
• Designed an efficient archiving strategy for archiving and deleting data from the data warehouse.
• Led the customer support team and demonstrated outstanding problem research and resolution skills with respect to several complex data issues reported by the business users.
• Designed and developed a utility/tool to automate the data inspection process which enhanced the efficiency and productivity of data analysis effort.
• Performed data inspection and data analysis of raw data from various source systems to ensure data quality in data warehouse.
• Developed and executed SQL scripts for testing the table load rules and transformation rules and provided assistance to the users in user acceptance testing.

Environment: Unix AIX, Korn Shell, SED AWK, DB2/UDB, Teradata, SQL, Erwin Data Modeler v 4.1.4, Rochade v 6, DB2, Visio, MS-Office, Microsoft Project

Confidential

Programmer/Analyst

• Designed, developed tested migration of an Oracle database to SQL Server database for Tech-Pro Inc.
• Designed developed analytical reports for Tech-Pro Inc using Crystal Reports and SQL Server stored procedures.
• Developed a CICS/DB2 online application to replace an existing CICS/IMS DB online application for asset protection group of Target Corporation.
• Designed, developed, programmed and implemented Mervyn's legacy fix using COBOL, IMS and CICS.
• Analyzed, designed, developed and implemented Network Card conversion of Target Corporation.
• Designed, programmed, tested and implemented migration of ROLS Returns Online System for Random house publishing.
• Programmed and maintained UI, TAXES, ICON and FUTA applications of Department Of Labor.

Environment: Windows NT/2000, MS ACCESS, ORACLE, SQL Server, Crystal Reports, ODBC, IBM AS / 400, COBOL / 400, CL, DFU, QUERY, SDA , IBM-MF, IBM-PC, MVS, JCL, COBOL, VS COBOL II, REXX, IMS, CICS, VSAM, DB2, EXPEDITOR, CA7.