Data Architect Resume
New York, NY
PROFILE:
- Proven experience in Data Warehouse Architecture and Design in a Parallel Environment
- Excellent ability to develop modeling solutions collaboratively or from Use Case requirements
- Expertise in Financial Instruments and Front / Back Office Financial Processing
- Strong SQL skills with knowledge of Business Intelligence
- Significant experience in Data Migration, Data Mapping and Gap Analysis
- Demonstrated ability to liaison between Business and Technology and deliver mission critical business solutions
- Excellent project management, leadership, supervisory, interpersonal and communication skills
TECHNICAL SKILLS:
Languages: Teradata, Oracle, DB2, SQL, SQL*PLUS, PL/SQL, Sybase, Java, JSP, JDBC, HTML, XML, Spring
O/S/Software: Erwin Modeling Tool, Rational Rose Modeling tool, Teradata Admin, Oracle 10g, SQL*Navigator, Cognos Impromptu, Unix, LoadRunner, Eclipse, MS Project, Visio
PROFESSIONAL HISTORY:
Confidential, New York, NY
Data Architect
Responsibilities:
- Configuration Management Data Repository
- Analyzed, architected, modeled and implemented physical design of Configuration Management data repository for Confidential to quickly resolve IT Configuration outages, thereby saving patients’ lives and to achieve significant cost savings by optimal management of its IT Configuration assets.
- The data repository stores Confidential ’s inventory of more than 10,000 IT Configuration Assets such as Applications, Servers, Networks and Storage Arrays across more than 100 facilities and Data Centers. It defines their attributes, maps their interdependencies and identifies support contacts to quickly resolve outages and to optimize utilization of its assets and capacity management.
- Worked with Business Managers and stakeholders to define modeling and reporting requirements.
- Integrated Enterprise Data sources such as Sales and Support Vendors to provide quick support access and NYU Locations to identify the sites where Configuration assets are located.
- Created Naming and abbreviation standards and Data Dictionary templates for enhanced Data Management.
- Implemented reporting model and Data Dictionary for Operational, Leadership and Dashboard reports.
Confidential, New York, NY
Data Architect and Analyst
Responsibilities:
- Performed Data Architecture, Analysis, Modeling and Physical design for Confidential Private Banking mission critical projects.
- Architected, performed Analysis, Logical and Physical data model for a consolidated repository for storing transactions from a half dozen accounting source systems throughout Latin America, US and Europe.
- Rationalized different formats and protocols, consolidated hundreds of different fields from various source systems, and ensured that transactions displayed on the internal and external sites are as they appeared on client Statements.
- Utilized web services to synchronize the various displays with the client Statements and to limit the Transaction fields to a core set.
- A phased implementation approach incorporated the core architecture components up front, while deferring implementation of field specific details until the corresponding source system was added.
- Worked with Mphasis Object Role Modeling (ORM) team to create a Semantic model and participated in review sessions to ensure accurate reflection of the Business view and to verify the mapping of the data model to the Semantic model.
Confidential, New York, NY
Data Architect and Analyst
Responsibilities:
- Performed Data Architecture, Analysis, Modeling and Physical design and played an instrumental role in implementing a wide range of enterprise - wide data initiatives.
- Performed analysis and Logical and Physical data model for a significant portion of a Self-Serve Data Warehouse, enabling business users to autonomously query business data and perform deep-dive analysis of metrics critical to firm’s profitability.
- These metrics include business penetration, return on assets and asset flow trends.
- The Analytical Environment utilizes a Semantic Layer to access golden source data, consists of several hundred Entities and is deployed on a Teradata data warehouse platform.
- Architected, modeled and designed information structures for five related applications that collectively provided clients with recommendations to maximize return on their portfolios, while taking risk component into account. Implemented logical and physical data model, consisting of more than 140 entities, using Erwin modeling tool and deployed the schema on a Teradata data warehouse platform.
- Led initiative to create Enterprise Information Model to integrate Confidential ’s application specific data silos into a unified, reusable Enterprise Information Resource.
- Achieved capability for integration of the migrated Confidential components and intuitive access to the Metadata Repository and data models by business taxonomy.
- Utilized a three level layered architecture, based on the Zachman Framework.
- Fifteen key Business Areas have been implemented thus far at the top level and nine Concepts at the second level, including key areas such as Account, Products and Services, Entitlements, Financial Advisor, Party, Security and Trade.
Confidential, New York, NY
Data Modeler Analyst
Responsibilities:
- Performed analysis and data modeling of File Import application which loads feeds for a variety of financial products, interfaces and formats. Developed new generic data model supporting commercial off-the-shelf ETL tools such as Ab-initio.
- Developed Data Migration Process for converting and loading current Confidential DB to new re-engineered schema, resolving challenges presented by a large DB size of 8 terabytes, Global DB distribution, shared centralized reference data and high availability requirements.
Confidential, New York, NY
Data Modeler Analyst
Responsibilities:
- Developed Logical and Physical Data Model for Confidential ’s User entitlement redaction functionality for filtering reports and queries. Resolved all business rules determining user entitlements to data resources and stored them in User level tables, to be utilized in formulating an appended where-clause, to implement filtering at the DB level. Improved performance by filtering entirely within the RDMS prior to retrieving any data.
- Contributed to development of database model for new external Centralized Activation and Entitlements Service (CAS), which provides On-boarding and provisioning from a centralized point for the GTS downstream applications.
- Analyzed Confidential and CAS Entitlements, On-boarding and Provisioning and wrote mapping document to integrate the new Centralized Activation System (CAS) with Confidential . Facilitated on-time delivery of CAS, by utilizing existing Confidential Use Cases and DB schema to implement the CAS messages, thereby eliminating the need to redesign Confidential .
- Procured funding and developed Business Intelligence pilot leveraging existing loss and Key Risk Indicator data to manage Confidential ’s Operational Risk.
- Served as liaison between Business and Developers for global Entitlements Enhancement (3,000 users). Elicited Requirements and communicated to Developers. Worked with project lead to ensure on-time delivery and quality standards. Coordinated with Business to obtain commitment for UAT testing and signoff.
- Wrote Use Case Requirements for Risk Control and Self Assessment (RCSA) application and developed test strategy, standards and functional coverage for QA testing.
- Significantly improved sponsor satisfaction and relationship on multi-million $ Op Risk initiative, by revamping communication and format of bi-weekly Project Status meeting.
Confidential, New York, NY
Software Analyst Designer, Operational Risk
Responsibilities:
- Lead database designer for global Operational Risk application, utilized for managing risk of losses due to fraud, improper business/employment practices or catastrophic external events.
- Performed data modeling and database architecture design, utilizing role based privileges to grant selective access and segregated schemas to enable shutdown/recycle of one application while the other is live.
- Managed project team and developed migration strategy to convert Confidential ’s global Operational Risk from Sybase to Oracle. Cut project time 50% and saved $175,000 utilizing out-of-the-box Workbench solution to automatically convert stored procedures and tables.
- Set up and went live with mission critical Production support process for Op Risk to facilitate reliable and timely handling of production issues and escalation of problems.
- Designed and developed Java application to load daily FX rate feeds from the New York Rate Server to provide default rates for the Event Data Capture application.