Data Architect Resume
Seattle, WA
SUMMARY:
- Over 7+ years of experience which includes working with databases, data science, data analysis, data modeler architecture and development.
- Responsible for all data related aspects of a project. At a macro level this comprises working with Data Architects in understanding the architectural roadmaps that support and fulfill business strategy
- Worked with individual projects as a contributing member , designing Logical Data Models and steward the data design of the project and ensuring alignment with the larger roadmap goals.
- Strong background in various Data Modeling tools using ERWIN, ER/Studio and Power Designer.
- Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering, Publishing Erwin diagrams, analyzing data sources and creating interface documents.
- Conducted JAD sessions, created Use Cases, work flows and Power Point presentations.
- Solid hands on experience with administration of data model repository, documentation in metadata portals in such as Erwin, ER Studio and Power Designer tools.
- Capture, validate and publish metadata in accordance with enterprise data governance policies and MDM taxonomies.
- Responsible for data governance rules and standards to maintain the consistency of the business element names in the different data layers.
- Extensive experience in development of T - SQL, Oracle PL/SQL Scripts, Stored Procedures and Triggers for business logic implementation.
- Proficient in Normalization/De-normalization techniques in relational/dimensional database environments and have done normalizations up to 3NF.
- Expertise in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) tools.
- Experience in modeling with both OLTP/OLAP systems and Kimball and Inmon Data warehousing environments.
- Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
- Experience in backend programming including schema and table design, stored procedures, Triggers, Views, and Indexes.
- Conduct data analysis, mapping transformation, data modeling and data-warehouse concepts.
- Experience in designing Logical, Physical & Conceptual data models for to build the Data Warehouse.
- Experience in conducting Joint Application Development (JAD) sessions with SMEs, Stakeholders and other project team members for requirements gathering and analysis.
- Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle.
- Solid Excellent experience in creating cloud based solutions and architecture using Amazon Web services (Amazon EC2, Amazon S3, Amazon RDS) and Microsoft Azure.
- Experienced in working on agile methodology . Assisted quality assurance team in preparing test scripts and test cases. Worked on Documenting Data Models, logic, coding, testing, changes and corrections.
- Well experienced in writing Complex queries, stored procedures, functions, cursors and packages using PL/SQL Programming.
- Energetic and self-motivated team player with excellent communication, interpersonal, and leadership skills, thrives in both independent and collaborative work environments.
TECHNICAL SKILLS:
Cloud Management: Azure, Azure Data Lake, Azure Data Factory, Amazon Web Services (AWS), Amazon Redshift
Data Modeling Tools: ER/Studio V17, Erwin 9.7, Power Sybase Designer 16.6.
OLAP Tools: Tableau, SAP BO, SSAS, Business Objects, and Crystal Reports 9
Programming Languages: SQL, PL/SQL, UNIX shell Scripting, PERL, AWK, SED
Databases: Oracle 12c, Teradata R15, MS SQL Server 2017, DB2.
Testing and defect tracking Tools: HP/Mercury, Quality Center, Win Runner, MS Visio 2016 & Visual Source Safe
Operating System: Windows 10/8, Unix, Sun Solaris
ETL/Data warehouse Tools: Informatica 9.6/9.1, SAP Business Objects XIR3.1/XIR2, Talend, Tableau
Methodologies: RAD, JAD, RUP, UML, System Development Life Cycle (SDLC), Agile, Waterfall Model.
PROFESSIONAL EXPERIENCE:
Data Architect
Confidential - Seattle, WA
Roles & Responsibilities
- As an Architect, implemented MDM hub to provide clean, consistent data for a SOA implementation.
- Interacted with Business Analyst, SMEs and other Data Architects to understanding Business needs and functionality for various project solutions.
- Used Agile Method for daily scrum to discuss the project related information.
- Designed and Developed data models for multiple different subject areas such as Membership, Claims, etc.
- Involved in solution and architecture meetings, to plan out the design for data model.
- Created mapping docs which included mapping source to target and adding logic.
- Data Governance of RAW, Staging, Curated and Presentation Layers in Azure Data Lake Store.
- Migration of on premise data to Azure Data Lake Store (ADLS) using Azure Data Factory (ADF V1/V2).
- Profiled data and worked with SMEs to resolve issues on data mapping.
- Involved in peer review sessions and helped other team members with design and data model issues.
- Created several Master Data Models (MDM) that unify data for critical concepts across applications.
- Provided suggestion to implement multitasking for existing Hive Architecture in Hadoop also suggested UI customization in Hadoop.
- Loaded data into Hive Tables from Hadoop Distributed File System (HDFS) to provide SQL access on Hadoop data.
- Worked on NoSQL database Cassandra . Implemented multi-data center and multi-rack Cassandra cluster.
- Worked on multiple different application within the enterprise data warehouse .
- Used Attunity Data Replication Tool Migrated on premise RDBMS's to Azure Data Warehouse.
- Written the PIG scripts /Hive queries to process/filter/transform the HDFS/ADL/WASB data.
- Collected large amounts of log data using Apache Flume and aggregating using PIG/HIVE in HDFS for further analysis.
- Responsible for metadata creation and reference architect documents which includes all the reference codes, and description.
- Involved in developing standards for data model creation and implementation which included classwords, abbreviations, data type standards.
- Provided suggestion on project issues which affected timelines to make sure the deliverables are completed and meet the deadlines.
- Trained and mentored offshore resources and held meetings with them to ensure data modeling guidelines have been followed and standards are met for the delivery of the projects.
Environment: Azure, MDM, Hive 2.3, Hadoop 3.0, HDFS, SQL, NoSQL, Cassandra 3.11, Apache, Flume, PIG 0.17
Sr. Data Modeler
Confidential - Minnetonka, MN
Roles & Responsibilities
- As a Data Modeler responsible for data warehousing, data modeling, data governance, data architecture standards, methodologies, guidelines and techniques.
- Partner with various business stakeholders and technology leaders, gather requirements , converted them into scalable technical and system requirement documents.
- Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
- Involved in Data mapping specifications to create and execute detailed system test plans.
- The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
- Designed and developed data structures that support high performing and scalable analytic applications on Teradata platforms.
- Responsible for all metadata relating to the EDW’s overall data architecture, descriptions of data objects, access methods and security requirements.
- Worked closely with Data Analysts and Senior ETL staff on the design of database load strategies and Data Profiling.
- Designed the logical data model from the technical design documents and translating to a physical data model using ERWIN.
- Worked on Data load using Azure Data factory using external table approach.
- Involved in creating Pipelines and Datasets to load the data onto data warehouse .
- Mentored more junior Data Modelers on best practices and standards for both operational and dimensional data modeling.
- Ensured data access and data load performance meets business partner’s requirements.
- Utilized Guide wire Policy Center.
- Worked on building MDM using Data coming from many different transactional systems
- Set up of environments to be used for testing and the range of functionalities to be tested as per technical specifications.
- Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
- Created ETL Jobs and Custom Transfer Components to move data from Transaction systems to centralized area (Azure Sql data Warehouse) to meet deadlines.
- Wrote and executed SQL queries to verify that data has been moved from transactional system to DSS, Data warehouse, data mart reporting system in accordance with requirements.
- Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
- Performed ad hoc analyses, as needed, with the ability to comprehend analysis as needed
- Involved in Teradata SQL Development, Unit Testing and Performance Tuning and to ensure testing issues are resolved on the basis of using defect reports.
- Tested the ETL process for both before data validation and after data validation process.
Environment: ETL, ERWIN 9.7, Azure, MDM, Sql, OLTP, Azure Sql, MDM, Sql Queries, Azure Data Factory, Sql, AgileData Modeler
Confidential - Bellevue, WA
Roles & Responsibilities
- Designed an Industry standard data Model specific to the company with group telecom offerings, Translated the business requirements into detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling
- Created a high-level industry standard, generalized data model to convert it into logical and physical model at later stages of the project using Power Designer.
- Created a high-level industry standard, generalized data model to convert it into logical and physical model at later stages of the project using Visio
- Designed and developed data structures that support high performing and scalable analytic applications on Teradata platforms.
- Conducted design walk through sessions with Business team to ensure that requirements and standards are met for the business.
- Facilitated project kickoff session with Business and SMEs to understand the requirements which also involved Project Manager , Development Lead , Data Modeler , Data Mapper , Data Architect etc.
- Involved in Teradata SQL Development and Created action plans to track identified open issues and action items related to the project.
- Worked with SME's and other stakeholders to determine the requirements to identify Entities and Attributes to build Conceptual, Logical and Physical data Models.
- Generated Data Definition Language files for Teradata and HIVE, for development of tables.
- Worked with Normalization/Denormalization techniques in relational/dimensional environments and have performed normalizations up to 3NF ( Third Normal Form).
- Performed Data Validation by comparing the data in the sources against the data in the Hive Data lake. Used Oracle SQL developer, Teradata, HUE, and putty to validate the data.
- Mentored Data Analysts on best practices and standards for both operational and dimensional data modeling.
Environment: Power Designer, MS Visio 2016, Teradata r12, SQL, HIVE 1.1, Oracle12c
Web and Database Developer
Confidential
Roles & Responsibilities
- Built dynamic website using HTML, CSS, JavaScript, and SQL from scratch.
- Developed project concepts and maintained optimal workflow
- Developed a database and migrated all the existing data into the new database.
- Help biweekly meetings with the radio station team to deliver the best product and meet the expectations of the team.
- Participated in brainstorming sessions to come up with innovative ideas.
- Created a Graphical User Interface to reduce the complexity of making changes to the website.
- Integrated website with social media including Facebook and Twitter.
- Creating a blogging section where people can ask questions, reply and comments on the posts.
- Structured all the data of the Radio Station so that it is safe and secure in future.
- Documented web application and technical specifications.
- Created logos, banners, and buttons on the website which can be used to broadcast the radio station.
- Provided guidance and trained the radio station team members to update the links, videos to the website.
- Used JavaScript to write functions to take user input.
- Worked with SQL to store data into the Database.
- Performed browser compatibility for various browsers including IE, Chrome and Mozilla Firefox.
Environment: HTML 5, CSS 2, JavaScript, and SQL
Artificial Intelligence Researcher
Confidential
Roles & Responsibilities
- Worked with big data of social media websites including facebook and twitter.
- Analyzed the requirements of the research.
- Debug, record and execute programs.
- Create and modify block diagrams and logic flowcharts.
- Prepared documentation for the research.
- Create d a parse r t o rea d the data of Faceboo k an d Twitte r publi c feed s usin g J AV A programmin g fo r marketin g purpose s
- Assisted with detailed technical design process that included data architecture, development, implementation and maintenance.
- Used Object Oriented Programming to call methods in the main class for parsing.
- Loade d al l th e dat a int o th e K-m e an s t o grou p th e simila r word s
- Use d Eclips e ID E fo r writin g program s an d script s t o rea d th e dat a fro m th e socia l medi a
- Ensured that all completed programs were tested to identify and correct any defects prior to deployment of the research model
- Presented the research into the SACNAS annual convention held in San Antonio TX.
Database Developer
Confidential
Roles & Responsibilities
- Worked on the overall Data Architecture, established and calculated values for database parameters
- Specified access for the users in different levels of each segment of database. Developed data model describing data elements and how they are used.
- Reviewed procedures in database management system manuals for making changes to database
- Worked as part of a team to coordinate development and determine the risks.
- Select and enter codes to monitor database performance to create production database
- Identify and evaluate industry trends in database systems to serve as a source of information advice for upper management.
- Write and code logical and physical database descriptions specify identifiers of database to management system or direct others in coding description
- Performed Data analysis and Data validation to make sure the data is loaded correctly into the database.