Data Architect Resume
Austin, TX
SUMMARY:
- A data management professional with 9 years of experience as Data Architect/Data Analyst creating and managing data requirements, designs, and standards for a wide variety of industries and types of projects.
- Demonstrated ability to synthesize and translate complex business requirements into accurate, flexible, and useful data insights, with the ability to communicate these results effectively to a diverse audience.
- Formulation of Enterprise - wide data architecture and framework, the specification of tactical and strategic IT solutions, architectural guidelines, corporate standards and methodologiesBig Data
- Extensive knowledge on Data lake implementation
- Data migration from existing system to big data flat form
- Data Engineering, Hadoop, HDFS, HIVEData Analytics
- Good knowledge on statistical analysis and Modeling
- Business and data insights for Analytics and reporting
- Data Visualization and DashboardsData Modeling
- Enterprise and project-level data modeling (conceptual, logical, and physical) for Enterprise data architectures.
- OLTP (online transaction processing) data stores
- Data Warehouses (dimensional and relational) and Operational Data Stores
- Communicating data requirements and models to a wide variety of stakeholders (business representatives, project management).Data Administration
- Current Systems Analysis and reverse engineering of legacy environments
- Data Management standards development
- Model management
- Metadata management
- Data element mappings
- Master data ManagementData base Administration
- Physical database design, including design of tables, indexes, referential integrity constraints, views, materialized views, partitions, etc.
- Development and management of database creation and modification scripts
- SQL Tuning & Database performance optimization
- Database sizing, Data profiling
- ETL development and reporting processes
PROFESSIONAL EXPERIENCE:
Confidential, Austin TX
Data Architect
Responsibilities:
- Involved in the designing of Enterprise data management system.
- Conducted various meeting with business users and stake holders for requirement’s gathering.
- Extensively involved in analyzing various data formats using industry standard tools and effectively communicate them with business users and SME’s.
- Implemented data visualization techniques using tools and forecasting the results with business to help them for better decisions.
- Identified the Meta data properties and mapping them back by identifying the true source.
- Designed conceptual, logical, physical data models and proof of design for enterprise data management.
- Conduct data model reviews with project team members.
- Capture technical metadata through data modeling tools.
- Ensure data warehouse and data mart designs efficiently support BI and end user.
- Collaborate with BI teams to create reporting structure.
- Extensively involved in the data migration and Data Lake implementation project discussions.
- Worked closely with business intelligence and analytics teams to design and get data insights
- Developed many process diagrams, data diagrams, roles and accountability diagrams to provide recommendations on future enhancements for ROW projects under way
Environment: Erwin, oracle, Python, SAS, Tableau, Visio, Microsoft SQL server management studio, project and Visio, UNIX.
Confidential, Atlanta GA
Data Architect/Analyst
Responsibilities:
- Identified all sources required for phase releases and involved in analyzing data discovery as part of source deploy to raw zone.
- Extensively involved in profiling and analyzing source data using various techniques and translate that into information.
- Worked closely with analytical team for analyzing structured, semi structured and unstructured data requirements.
- Developed Conceptual, Normalized Logical and Physical database models to design OLTP system.
- Involved in data linage and data reconciliation implementation for all sources end to end.
- Analyzed data of existing applications for lifting and shifting to data lake environment from existing systems as part of data migration. extensively involved in analyzing source moving target layout changes for existing systems from source
- Worked with data visualization (Tableau) to visualizing, analyzing and monitoring dashboards.
- Involved in Change data capture (CDC) and technical data quality (TDQ) discussion of project implementation.
- Involved in Developing ETL XFR data transformations for distribution data mappings and created HADOOP HDFS files as output.
- Analyzed migration applications from existing system to data lake environment
- Worked on Micro/ Macro and other existing design documentation and transferred that to team’s project requirements.
- Documentation of HLD, DLD by understanding the requirements and providing mappings and sessions involved in the ETL process
- Identified and understood the business function activities, entities, data attributes, table’s metadata and documented detailed design specifications for new system.
- Contributed to design, development and deployment activities as needed in support of the corporate SDLC.
- Attained good knowledge in Hadoop Data lake Implementation and HADOOP Architecture for client business data management.
- Worked on Creating Hadoop HDFS files and populate that from Data Cluster to Analytical Cluster.
- Identified and understood the business function activities, entities, data attributes, table’s metadata and documented detailed design specifications for new system.
- Contributed to design, development and deployment activities as needed in support of the corporate SDLC
Environment: Erwin, Ab Initio GDE 3.2.5, Ab Initio Co-op 3.2.4, UNIX, UNIX Shell, Windows XP, Microsoft office suit, Visio
Confidential, Franklin Lakhs NJ
Data Architect
Responsibilities:
- Involved in the Architectural role to design and develop EDW program initiative. Designed the IDD document by analyzing the SRS and Mapping documents.
- Involved in design and conversion of business requirements to Conceptual Data Model, logical Data Model and Physical Data Model for Provider/Member/Benefits/Product/Disease Registry subject areas
- Documenting high level architecture/framework through Systems Architecture Vision (SAV) andSystems Architecture Specification (SAS) document.
- Expertise in working on Enterprise Architecture standards to identify System Security Specifications, Information Security Specifications, Enterprise Business Continuity Specifications.
- Involved in designing companies production Delta load (loading anchor data into production) steam line process.
- Participated in integration of MDM (Master Data Management) Hub and Data warehouse.
- Reverse Engineered all the source Database’s using Erwin for data migration from Confidential to Medco data standards.
- Developed Process Methodology for the reverse Engineering Phase of the project.
- Developed Project plan with project Manager Assistance for the first two phases of the project.
- Sound knowledge of Enterprise Information Model(EIM) which consists of 15 subjectareas (Provider, Member, Product, Member/Group Contracts, Provider contracts, ProspectProducer, Sales & marketing, Claims & Encounters, Financial, Asset, Premium & Fees, Member
- Health, Business Administration and Planning, Communication event)
- Applied SQL tuning/Database performance optimization techniques for improved query performance
Environment: CA All Fusion Model Manager, Erwin, Ab Initio GDE, IBM DB2, Business Objects, DB2 Oracle, Teradata, XML,UNIX, UNIX Korn Shell, Windows XP
Confidential, Irving, TX
Data /System Analyst
Responsibilities:
- Worked on CMR (Customer Management Repository), 360 degree view of Citi customer demographic master data across different line of business.
- Extensively worked and involved in analyzing the data for different LOBS to fit in to master data repository.
- Involved in data profiling and analyzing activities for various third party data sourcing to master repository. Documenting high level architecture/framework through Systems Architecture Vision (SAV) and Systems Architecture Specification (SAS) document.
- Mapped data items from mainframe source to multiple targets. This included reading COBOL code, Teradata BTEQ scripts and ABINITIO jobs.
- Worked on Enterprise Architecture standards to identify System Security Specifications, Information Security Specifications and Enterprise Business Continuity Specifications.
- Designed Enterprise Data Warehouse consolidation roadmap for Decision Support Systems including use of Taxonomy from Industry Standard Models to standardize terminology and mapping them to CITI data elements to identify gaps.
- Helped in collecting, documenting and analyzing requirements to recommend tools for Metadata Management, Master data Management Data Quality and Data Governance and Data profiling.
- Helped define Enterprise framework for Data Governance and Stewardship.
- Designed conceptual, logical and physical data models in both data warehouse and operational environments from business requirements.
- Created documents for mapping data elements from database to other databases and/or web services.
- Performed Data discovery using SQL for checking Data Quality issues and report them to
- Business and developed a long term strategy to fix recurring issues.
- Designed and maintained Conceptual, Logical and Physical models in OLTP (operational) using Relational (3NF) and OLAP (data warehouse) using Dimensional (Star Schema) models.
Environment: Erwin, Ab Initio Metadata Hub and GDE,Profiler, Oracle,Tera data, HP quality center, IBM Info sphere Metadata Workbench and Business Glossary.
Confidential, Northbrook IL
Data Modeler /Analyst
Responsibilities:
- Worked on Design and Development of Auto Data Mart (IRM), Gathered and translated business requirements into detailed Data Models.
- Actively Involved in Design and Development of Agent Gateway Marketing Model. AGM is a dimensional model (Star Schema), which provides data to Sales and Marketing Reports.
- Worked on Analysis, Design and Development of Claims Data Model.
- Actively involved in Integration Analysis of Enterprise Data Warehouse GSRM project to integrate over 850 data elements and measurements from 2 different sources into a common set of data tables
- Involved in the Activities of Data Profiling, Data Integration and Data Quality
- Actively involved in the process of developing and maintaining Meta Data management and Data Governance standards.
- Provided performance tuning and capacity planning on Teradata in order to help scale the system and optimize performance
- Done Physical database performance optimization using partition primary, aggregate join indexes
- Conducted Design walkthroughs which better helped the ETL and MSI developers to understand the design.
- Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects.
- Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
- Built Conceptual, Logical and Physical Dimensional Data Models.
- Gathered Business Requirements and Conducted Data Audits.
- Strong skills in gathering information requirements needed to build dimension to fact matrix.
- Drafted Enterprise Data Warehouse Bus Architecture.
- Involved in data explorations and Profiling.
- Worked with reporting team to develop Mockup Reports and presented them to business for approval.
- Designed Transaction grain, Periodic & Accumulating Snapshot Fact tables.
Environment: CA All Fusion Model Manager, Erwin, SQL Server 2005, Teradata, Informatica, Business Objects, Microsoft Analysis Services 2005 Business Intelligence Studio.
