SUMMARY

• 13+ years’ in Enterprise Data Modeling/Architecture, Data Warehousing, ETL solution design and development, Solution Architecture and Pre - Sales support, working with global teams.
• Wide industry domain experience: Telecommunications, Banking/Finance, Securities, Insurance, Manufacturing, Retail, Consumer Goods, Technology.
• Experience in Data Modeling - Logical and Physical Database Design, with tools such as Erwin and ER-Studio.
• Experience in Architecting ETL solutions and developing Load Strategies.
• Experience in creating data mapping documents for ETL, with various databases as source (Oracle, SQL Server etc.)
• Worked extensively on Performance tuning/Optimization of Confidential scripts/databases.
• Held primary responsibility in resolving production issues at Intel, Vodafone, GE, and Confidential .
• Expert with SQL and well versed with Macros, Stored Procedures.
• Well versed with Confidential models for finance (FSLDM) and communications (CLDM).
• Confidential Certified Master (V2R5).
• Guided and mentored junior technical resources in projects.
• Trained on Big Data Technologies.
• Mortgage experience at major banks and Confidential .
• Worked on Model Mart administration activities.
• Worked on creation of modeling standards and procedures.
• Worked on reviews of the data models created by other modelers.

TECHNICAL SKILLS

Data Warehousing Tools: Confidential 15 (Fastload, Multiload, BTEQ, Fastexport, TPump), Confidential SQL Assistant, Viewpoint, Confidential Administrator (WinDDI), Confidential Manager, Performance Monitor; Microstrategy, Informatica PowerCenter 7.1.3., Autosys, Control-M, Business Objects

Databases: Confidential 15, Oracle, SQL Server, Informix, Netezza

Modeling: Erwin 9.5.1.1, ER-Studio

Prog. Languages: C, MF-Cobol, C++, Visual FoxPro

Operating Systems: Linux, Windows, Unix

PROFESSIONAL EXPERIENCE

Confidential, Lake Forest, IL

Sr. Data Architect

Responsibilities:

• Worked on data architecture for Oracle to Confidential migration project.
• Worked on converting the existing Oracle models into Confidential models.
• Worked on new model designs for the enhancements.
• Conduct discussions with business, BAs, SMEs to understand requirements.
• Review the data models and DDLs created by other modelers.
• Work with SSAs to get the data requirements documented.
• Building Conceptual, Logical and /Physical data models using ERWin.
• Assignment of data types, domains, keys, indexes.
• Generation of Confidential DDLs using ERWin.
• Creation of mapping (STM) documents,
• Hand over the modeling deliverables to ETL and DBA teams.
• Worked on semantic modeling for Canada go live.
• Requirement discussions with business to develop semantic layer.
• Data profiling and data analysis.
• Performance tuning and optimization of the databases.
• Worked on Model Mart administration activities.
• Worked on creation of modeling standards and procedures.
• Worked on reviews of the data models created by other modelers for Canada go live.
• Design, develop and improve data warehouse architecture.

Environment: ERWIN 9.5.1.1, Confidential 15, Confidential SQL Assistant (Queryman), Confidential SQL Administrator (WinDDI), Windows 2000, Unix-MP-RAS, Business Objects, Informatica, Informatica Analyst.

Confidential, Mountain View, CA

Sr. Data Architect

Responsibilities:

• Design of logical/physical data models using ERWin for Responsys Campaign Activity.
• Requirement discussions with business, BAs, SMEs to understand requirements.
• Worked with Source System experts to understand sources.
• Assignment of data types, domains, keys, indexes.
• Generation of Confidential DDLs using ERWin.
• Creation of mapping (STM) documents,
• Hand over meetings with ETL and BI teams.
• Analysis and design of ETL Architecture and strategies.
• Requirement discussions with business to develop semantic layer.
• Worked on Perforce (Version Control) to manage DDL scripts through different environments.
• Data profiling and data analysis.
• Performance tuning and optimization of the databases.

Environment: ERWIN 9.5.1.1, Confidential 14.10, Confidential SQL Assistant (Queryman), Confidential SQL Administrator (WinDDI), Windows 2000, Unix-MP-RAS, Business Objects, Informatica, Informatica Analyst.

Confidential, Dover, NH

Sr. Data Architect

Responsibilities:

• Requirement gathering from the lead data modeler for CLF-WC project.
• Requirement and Data Analysis for CLF-WC project.
• Design of logical/physical data models using ERWin.
• Assignment of data types, domains, keys, indexes.
• Generation of Confidential DDLs using ERWin.
• Design and development of semantic views,
• Work on mapping document with System Analyst.
• Worked on semantic modeling for CLF-WC project.
• Performance tuning and optimization of the views.

Environment: ERWIN 9.5.1.1, Confidential 14.10, Confidential SQL Assistant (Queryman), Confidential SQL Administrator (WinDDI), Windows 2000, Unix-MP-RAS, Microstrategy, Informatica

Confidential, Dublin, OH

Sr. Data Architect

Responsibilities:

• Design of logical/physical data models using ERWin for Mortgage Banking Division.
• Data profiling and data analysis.
• Requirement discussions with business, BAs, SMEs to understand requirements.
• Worked with Source System experts to understand sources.
• Assignment of data types, domains, keys, indexes.
• Generation of Confidential DDLs using ERWin.
• Creation of mapping (S2TM) documents,
• Hand over meetings with ETL and BI teams.
• Worked on semantic modeling for Peregrine project.
• Requirement discussions with business to develop business views.
• Developing and implementing access layer views and macros to be used by BO-Universe.

Environment: ERWIN 7.3, Confidential 14.10, Confidential SQL Assistant (Queryman), Confidential SQL Administrator (WinDDI), Windows 2000, Unix-MP-RAS, Microstrategy, Informatica

Confidential, Seattle, WA

Sr. Data Architect

Responsibilities:

• Design of physical data models using ER-Studio.
• Data profiling and data analysis.
• Assignment of data types, domains, keys, indexes.
• Generation of Confidential DDLs using ER-Studio.
• Creation of mapping (S2TM) documents,
• Hand over meetings with ETL and BI teams.
• Worked on semantic modeling for SCM-APO project.
• Analysis and design of ETL Architecture and strategies.
• Worked on Accurev (Version Control) to manage DDL scripts through different environments.
• Worked on fixing the skew on Confidential tables.
• Worked on determining good primary indexes and performance optimization of Confidential databases.
• Requirement discussions with business to develop business views.
• Developing and implementing access layer views and macros to be used by BO-Universe.

Environment: ER-Studio 9.5, Confidential 14, Confidential SQL Assistant (Queryman), Confidential SQL Administrator (WinDDI), Windows 2000, Unix-MP-RAS, Microstrategy, Informatica

Confidential - Englewood Cliffs, NJ

Data Architect

Responsibilities:

• Study, analysis and design of logical models, conversion of logical into physical models.
• Data profiling and data analysis.
• Analysis and design of ETL architecture and strategies.
• Requirement discussions with business and other stakeholders
• Confidential database design for Cordillera project.
• Assignment of data types, domains, keys, indexes.
• Generation of Confidential DDLs.
• Physical Modeling for database.
• Creation of mapping documents
• Hand over meetings with ETL and BI teams.
• Database performance tuning and optimization.
• Semantic layer design and development.
• Reverse Engineering, Forward Engineering, Complete Compare, DDL generation.
• Work with DBAs to get DDLs implemented.

Environment: Erwin 7.3, Confidential 14.0, Viewpoint, Confidential Manager, PMon, Confidential Parallel Transporter, Confidential SQL Assistant (Queryman), Confidential Administrator (WinDDI), Windows 2000, Unix-MP-RAS, Microstrategy, Informatica

Confidential - Wilmington, DE

Distribution Data Warehouse

Responsibilities:

• Study, analysis and design of logical models, conversion of logical into physical models.
• Data profiling and data analysis.
• Analysis and design of ETL architecture and strategies.
• Requirement discussions with business and other stakeholders
• Confidential database design and administration for database migration project.
• Assignment of data types, domains, keys, indexes.
• Generation of Confidential DDLs.
• Physical Modeling for database.
• Creation of mapping documents
• Hand over meetings with ETL and BI teams.
• Database performance tuning and optimization.
• Semantic layer design and development.
• Reverse Engineering, Forward Engineering, Complete Compare, DDL generation.
• Work with DBAs to get DDLs implemented.

Environment: Erwin 7.3, Confidential 13.10, Viewpoint, Confidential Manager, PMon, Confidential Parallel Transporter, Confidential SQL Assistant (Queryman), Confidential Administrator (WinDDI), Windows 2000, Unix-MP-RAS, Microstrategy, Informatica

Confidential, Minneapolis

Data Architect

Responsibilities:

• Study, analysis and design of logical models, conversion of logical into physical models.
• Data profiling and data analysis.
• Analysis and design of ETL architecture and strategies.
• Requirement discussions with business and other stakeholders
• Confidential database design and administration for database migration project.
• Assignment of data types, domains, keys, indexes.
• Generation of Confidential DDLs.
• Physical Modeling for database.
• Creation of mapping documents
• Hand over meetings with ETL and BI teams.

Environment: Erwin 7.3, Confidential 14, Viewpoint, Confidential Manager, PMon, Confidential Parallel Transporter, Confidential SQL Assistant (Queryman), Confidential Administrator (WinDDI), Windows 2000, Unix-MP-RAS, Microstrategy, Informatica

Confidential, Westlake, TX

Data Architect

Responsibilities:

• Study, analysis and design of logical models, conversion of logical into physical models in an Agile environment.
• Data profiling and data analysis for compression etc.
• Analysis and design of ETL architecture and strategies.
• Confidential database and data warehouse design and administration for valuation services.
• ETL design and development for Valuations Services data warehouse.
• Design, development, testing, debugging, modifications of Fastload, Mload, BTEQ, Macro, Tpump and Stored Procedures.
• Monitoring the database using Viewpoint and Confidential Manager.
• Performance tuning and optimization by tuning the queries and design changes, compression, PPI, MLPPI etc.
• Development and maintenance of backup and recovery jobs using TARAGUI/Netbackup.
• Creation of databases, users with proper rights/permissions, roles and profiles.
• Space Management and database cleanup activities.
• Setting up detail and threshold DBQL logging, applying compression on tables.
• Setting up weekly statistics collection jobs.
• Migration of objects from one environment to other.
• Configuration changes, DBS Control settings, alerts using Confidential Manager, and Viewpoint.

Environment: Erwin 7.3, Confidential 12, Viewpoint, Confidential Manager, PMon, Confidential Parallel Transporter, Confidential SQL Assistant (Queryman), Confidential Administrator (WinDDI), Windows 2000, Unix-MP-RAS, Microstrategy, Informatica

Confidential, Jacksonville

Data Architect

Responsibilities:

• Confidential database design for new enhancements.
• Conversion of Logical model into physical model.
• Performance tuning and optimization by tuning the queries and by design changes, compression, PPI, MLPPI etc.
• Space management and database clean-up activities.
• Creation of databases, users with proper rights/permissions, roles and profiles.
• Setting up detail and threshold DBQL logging, applying compression on tables.
• Setting up weekly statistics collection jobs and backup and recovery jobs.
• Migration of objects from one environment to other.
• TASM/Workload management, configuration of DBS Control settings.
• Data profiling and data analysis for compression etc.

Environment: Erwin 7.3, Confidential 12, Confidential Manager, Pmon, Confidential Parallel Transporter, Confidential SQL Assistant (Queryman), Confidential Administrator (WinDDI), Windows 2000, Unix-MP-RAS

Confidential

Data Architect

Responsibilities:

• Oracle to Confidential database design for Research subject area.
• Logical to physical modeling of CRM and CI modules.
• Logical Database design: Creation of data model using Erwin, forwarding/backward engineering, html report generation.
• Performance tuning and optimization by tuning the queries and by design changes, compression, PPI, MLPPI etc.
• Space management and database clean-up activities.
• Creation of databases, users with proper rights/permissions, roles and profiles.
• Setting up detail and threshold DBQL logging, applying compression on tables.
• Setting up weekly statistics collection jobs and backup and recovery jobs.
• Confidential technical solutions design for migration from Oracle to Confidential .
• Migration of objects from one environment to other.
• Confidential ETL support of Oracle to Confidential ETL migration.
• TASM/Workload management using TDWM, DBSControl settings.
• Data profiling and data analysis for compression etc.

Environment: Erwin 7.3, Confidential 12, Confidential Manager, Pmon, Confidential Parallel Transporter, Confidential SQL Assistant (Queryman), Confidential Administrator (WinDDI), Windows 2000, Unix-MP-RAS