Lead Data Architect Resume Samples

Description :

1. Implemented the enterprise shared services which is the most prestigious implementation for Time Warner enterprise and divisions of Time Warner includes (Warner Bros, HBO, Time, Corporate, TBS etc).
2. Developed the Enterprise Data warehouse (EDW) and Shared Services strategy and conceptual design.
3. Partnered with Business users in defining reporting needs, key performance indicators (KPIs), conducted end user interviews for various functional areas like HR, Transportation, IT Metrics, Real Estate, and Tax.
4. Designed EDW architecture, data acquisition methodology and shared services solution to TW management.
5. Established the enterprise data standards blueprint, physical and logical standards, physical database design, architecture guiding principles and design Informatica ETL and Business Objects (BO) Reporting architecture.
6. Designed the enterprise data warehouse and shared components for Human Resources, Financial, Transportation and Logistics, Real Estate, Tax, Business Continuity Planning, IT Metrics using Ralph Kimball Dimensional Methodology including Conceptual, Logical and Physical Data Model.
7. Designed and Identified the Master Data Management (MDM) strategy and components for HR, Vendor etc.

Experience

7-10 Years

Level

Management

Education

MS In Computer Science

Description :

1. Responsible and accountable for the enterprise data management team.
2. Managed the data management team of Data architects by providing architectural solutions for databases.
3. Architected framework for data warehouse solutions to Loan Management System, wealth management Architected and maintained Erwin logical and physical data models for Loan Mis, load Vantage, Loan Quest, and Financial Call reporting Data warehouse projects.
4. Architected framework for data warehouse solutions to Process wealth management information for OCC regulation.
5. Eliminated manual effort that had been in place on a monthly basis.
6. Lead Architect in Designing Comprehensive Data warehouse Solution, from data to the presentation layer, to build and expose Activity/Productivity of Customer risk rating, Wire Processing data.
7. Managed team of 3 data architects Designed and implemented multiple phases of Data warehouse with data extracted from various OLTP systems like mortgage application on a C_tree structures, loan servicing data on Oracle and consumer loans from SQLserver, for a centralized pool of data to report from.

Experience

2-5 Years

Level

Junior

Education

MS

Description :

1. Managed design and development of new Enterprise Data Warehouse sourced from new core accounting and origination systems for all of Pacific Capital Bancorp's subsidiaries, including transitioning to a new business intelligence model using both internal and vendor resources.
2. Redesigned Enterprise Data Warehouse to enable organization's new customer focus.
3. Engineered the transition from legacy source core accounting system to new accounting and GL systems.
4. Transformed the separate Data Warehouse and Operational data Store into an integrated Corporate Information Factory.
5. Designed all ETL for new source data and designed and inaugurated customer data integration (CDI) efforts, reconciling disparate customer data across newly integrated source systems.
6. Improved overall data quality through Master Data Management (MDM) initiative, satisfying OCC and Sarbanes-Oxley.
7. Designed and managed the metadata strategy using the Informatica repository and Business Objects.

Experience

5-7 Years

Level

Executive

Education

B.A In Political Science

Description :

1. Currently worked as a Lead Data Architect at AT&T playing a highly instrumental role providing data and solutions architecture for multiple enterprise-wide initiatives.
2. Worked on several projects architecting solutions required out of acquisitions, mergers, launching of various products & subsidiaries, and other major enterprise-wide initiatives.
3. Worked closely with the Stakeholders, Vendors, Analysts, and various application teams developing and delivering architecture that would align with the business initiative.
4. Generated architectural and design documents and make presentations to the governance boards.
5. Provided architectural recommendations and estimates on the initiatives.
6. Designed and oversaw the modeling of the required data structures, processes and guide their implementation.
7. Assigned, managed, and tracked the development of the solutions.

Experience

7-10 Years

Level

Management

Education

MS In Computer Sciences

Description :

1. Designed and developed analytic software for data collection, playback, and analysis of the Radio Frequency (RF) scanner products on the Amazon Web Services (AWS) platform.
2. Led design and development of the company's enterprise analytical platform.
3. Defined coding standard and enterprise data model standard.
4. Designed and developed an indoor walk test analytical application that is critical to the company's revenue with PostgreSQL, PostGIS, shell, and PHP.
5. Improved the performance of a legacy wireless network analytic data database by 200% with SQL tuning skill.
6. Led and mentored other data architects, data modelers, and developers on the team.
7. Designed the end-user layer for the EDW using Business Objects Universes.

Experience

2-5 Years

Level

Junior

Education

M.S. In Computer

Description :

1. Worked with Principle Architects, System Analysts, and internal business customers to discover the data requirements and create the data model as well as data mappings to exchange data with other systems.
2. Worked with Software Architects and Engineers to help them find the data they need from other systems within the company and to efficiently store their own data in a logical manner and ensure data integrity.
3. Ensured that the corporate standards are being enforced in order to make it easier for users to understand the data from one database to another.
4. Designed the overall data architecture for Service Planner, a new web-based application within CenturyLink that uses real-time data streaming from Ventyx's Service Suite application.
5. Helped management more accurately plan technician scheduling to meet their ever-changing demand.
6. Designed and developed custom ETL packages in PL/SQL to extract Service Suite data for Service Planner.
7. Integrated third-party data from Experian using Sonic MQ and XML messages.

Experience

7-10 Years

Level

Management

Education

BS

Description :

1. Managed the workload of the junior data architects and made logical data modeling assignments.
2. Analyzed business requirements, define the scope, and manage project work schedule, resources, and cost estimates.
3. Managed the enterprise application inventory through processes that eliminated duplications through documented and monitored business processes.
4. Implemented the Corporate Data Dictionary (Meta-Data Repository) to house all the logical entities and attributes with business definitions, validation rules, and version control using Power Designer's Repository.
5. Provided logical and physical relational data modeling services for application development teams supporting financial, human resource, customer service, and operation systems.
6. Facilitated design sessions with the application analyst and end-users, to gather business requirements Led the design, code, test, and implementation of legacy application (mainframe and client/server) messaging interfaces for Oracle iProcurement Application via MQSeries Integrator.
7. Provided technical guidance to the team in defining the data transformation rules and data conversion routines for the integration of data on multiple platforms.

Experience

2-5 Years

Level

Junior

Education

MS

Description :

1. Participated in design, development and implementation of architectural deliverables, to include components of the assessment and optimization of system design and review of user requirements.
2. Contributed to the determination of technical and operational feasibility of solutions.
3. Developed prototypes of the system design and works with database, operations, technical support and other IT areas as appropriate throughout development and implementation processes.
4. Assured that the data application architecture is consistent with enterprise application standards and disaster recovery plan requirements.
5. Provided technical knowledge and capabilities as a team member and individual contributor.
6. Provided strategic thinking, solutions, and roadmaps while driving architectural recommendations.
7. Maintained current and future state architecture.

Experience

2-5 Years

Level

Junior

Education

MS

Description :

1. Developed strategic vision for the department's future, bringing in new professional culture.
2. Lead and managed a team of four developers in ground-up end-to-end design and implementation of the enterprise data warehouse along with a unified reporting system and standard presentation layer.
3. Managed and participating hands-on in several migration projects getting away from legacy mainframe DB2 systems to the Oracle-based platform.
4. Automated the migration of the old reports and processes to Oracle 10g Discoverer and third-party reporting tools.
5. Designed and implement the processes that integrate the disjointed multi-platform data into one unified Oracle-centric platform.
6. Migrated to Oracle Warehouse Builder ETL.
7. Contributed to the recruiting, mentoring, and growth of team members.

Experience

5-7 Years

Level

Executive

Education

MS

Description :

1. Participated in implementing and adopting industry best practices on data management like defining data policies, standards, guidelines, architecture and coached team members to follow the defined standards.
2. Ensured the data models were reviewed and updated consistently to ensure compliance with standards and to aid system integration efforts.
3. Led and delivered successfully Campaign Performance Analytics Dashboard saving 1.2 million annually for HP Americas Marketing Analytics Business Groups.
4. Responsible for logical and physical designs of both the ODS(relational) and EDW(dimensional models).
5. Led change control meetings with business primes and developers to discuss proposed changes and understand at what level they applied.
6. Reconciled discrepancies in current state logical and physical data models, and collaborated with other team members to model additional entities and relationships.
7. Designed and implemented extensive user segmentation and tagging system for dashboarding all core KPIs and game balance metrics by user acquisition source, geolocation, device, platform, AB test group, game progress, etc.

Experience

5-7 Years

Level

Executive

Education

MS