We provide IT Staff Augmentation Services!

Sr. Data Architect/data Modeler Resume

3.00/5 (Submit Your Rating)

Washington, DC

SUMMARY

  • Above 9+ years of experience as Data Architect/DataModeler and Data Analyst in Data Analysis, Data Modeling, Data Architecture, designing, developing, and implementing data models for enterprise - level applications and systems.
  • Experience in BigDataHadoop Ecosystem in ingestion, storage, querying, processing and analysis of big data.
  • Experience in BI/DWsolution (ETL,OLAP, Data mart), Informatica, BIReporting tool like Tableau and QlikView and also experienced leading the team of application, ETL, BI developers, Testing team
  • Expertise in Data Governance, Data Integration, Metadata, Reference Data and MDM
  • Experience in Hadoopecosystem components like HadoopMapReduce, HDFS, HBase, Oozie, Hive, Sqoop, Pig, Flume including their installation and configuration.
  • Strong experience with different project methodologies including Agile Scrum Methodology and Waterfall methodology.
  • Strong experience in Normalization (1NF, 2NF, 3NF and BCNF) and Denormalization techniques for effective and optimum performance
  • Experience in developing Map Reduce Programs using ApacheHadoop for analyzing the bigdata as per the requirement.
  • Experienced in SAS interacts with third party software such as databases (DB2, SQLSERVER, ORACLE), web Application Servers and SASHPA architecture etc.
  • Experience in working with Business Intelligence and Enterprise Data Warehouse(EDW) including SSAS, Pentaho, Cognos, OBIEE, QlikView, Green plum, AmazonRedshift and Azure Data Warehouse
  • Strong experience with architecting highly performance databases using PostgreSQL, PostGIS, MYSQL and Cassandra
  • Experienced in setting up connections to different Databases like Oracle, SQL, DB2, HADOOP, Teradata and NETEZZA according to users requirement
  • Experienced in SQL, PL/SQL package, function, storedprocedure, triggers, and materialized view, to implement business logics of oracle database.
  • Experienced in Teradata RDBMS using Fastload, FastExport, Multiload, Tpump, and TeradataSQLAssistance and BTEQTeradata utilities.
  • Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment
  • Good understanding and hands on experience in setting up and maintaining NoSQL Databases like Cassandra, MongoDB, and HBase
  • Expertise in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes
  • Extensive experience on usage of ETL &Reporting tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)
  • Solid understanding Unified Modeling Language (UML), Object Modelling Technique (OMT), Extreme Programming (XP), and Object Oriented Analysis (OOA).
  • Excellent knowledge in preparing required project documentation and tracking and reporting regularly on the status of projects to all project stakeholders
  • Expert in BI reporting and Data Reporting tools like Pentaho and SAPBI.
  • Experience in Dimensional Data Modeling, Star/Snowflakeschema, FACT & Dimensionables.

TECHNICAL SKILLS

Analysis and Modeling Tools: Erwin9.6/9.5, ER/Studio 9.7/9.0, Sybase Power Designer

ETL Tools: Informatica Power Centre 10.0/9.6.1/9.5 , Ab Initio, Talent, Pentaho

OLAP Tools: MS SQL Analysis Manager, DB2 OLAP, CognosPowerplay, Tableau, TibcoSpotfire

Big Data: Hadoop, HDFS 2, Hive, Pig, HBase, Sqoop, Flume, Spark.

Programming Languages: SQL, PL/SQL, UNIX shell Scripting, PERL, AWK, SED

Databases: MS SQL Server 2016/2015, Oracle12c/11g, DB2 V9.5, Teradata R15/R14, MS Access 2007

Operating Systems: Windows 8/7/XP, UNIX (Sun Solaris 10)

Project Execution Methodologies: Ralph Kimball and Bill Inmon data warehousing methodology, Rational Unified Process (RUP), Rapid Application Development (RAD), Joint Application Development (JAD)

Tools: & Software: TOAD, MS Office, BTEQ, Teradata SQL Assistant, MS-Office suite (Word, Excel, MS Project and Outlook), VSS

Data warehouse Tools: SAP Business Objects XIR3.1/XIR2, Web Intelligence, Talend, Tableau, Pentaho

Reporting Tools: Crystal reports XI, Business Intelligence and SSRS, Business Objects 5.x / 6.x,Cognos7.0/6.0

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Sr. Data Architect/Data Modeler

Responsibilities:

  • Responsible for the data architecture design delivery, data model development, review, approval and Data warehouse implementation.
  • Developed DataMapping, DataGovernance, and Transformation and cleansing rules for the MasterDataManagement Architecture involving OLTP, ODS.
  • Data modeling, Design, implement, and deploy high-performance, custom applications at scale on Hadoop/Spark.
  • Extensively used the Ab Initio tool's feature of Component, Data and Pipeline parallelism.
  • Worked with Python OO Design code for manufacturing quality, monitoring, logging, and debugging code.
  • Created MDMbaseobjects, Landing and Staging tables to follow the comprehensive data model in MDM.
  • Involved in designing Logical and Physicaldatamodels for different database applications using the Erwin 9.6.
  • Created Dispatch scripts to dispatch the data from HDFS to Teradata data.
  • Created the BTEQ and MLOAD scripts to load the data from Hadoop to Teradata Target system by making use of Sqooputility.
  • Imported required tables from RDBMS to HDFS using Sqoop.
  • Written DDL and DMLscripts to alter existing and to create new tables.
  • Extensively worked on creating the migration plan to Amazon web services (AWS).
  • Responsible for Bigdata initiatives and engagement including analysis, brainstorming, POC, and architecture.
  • Worked with Python OO Design code for manufacturing quality, monitoring, logging, and debugging code.
  • Enterprise Metadata support for Ab Initio batch conversions and Real time Abinitio interfaces.
  • Working on AmazonRedshift and AWS and architecting a solution to load data create data models and run BI on it.
  • Developed various QlikViewDataModels by extracting and using the data from various sources files Excel, FlatFiles and Bigdata.
  • Established data architecture strategy, best practices, standards, and roadmaps
  • Involved in resolving the dependencies that create problem while migrating to the cloud.
  • Worked very close with Data integration and DBA team to implement data model changes in database in all environments.
  • Worked with Hadoop eco system covering HDFS, HBase, YARN and Map Reduce.
  • Worked on TERADATA 15 and utility domains. Optimization of Queries in a Teradata database environment.
  • Designed both 3NF data models for ODS, OLTP systems and dimensional data models using star and snow flake Schemas.
  • Used BTEQ and SQLAssistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
  • Developed long term data warehouse roadmap and architectures, designs and builds the data warehouse framework per the roadmap.
  • Designed and developed architecture for data services, ecosystems, panning Relational, NoSQL, and Big Data technologies.
  • Worked with Netezza and Oracledatabases and implemented various logical and physical data models for them.
  • Worked with the ETLteam to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes.

Environment: Erwin 9.6, Teradata 15, Oracle 12c, Hadoop, Spark, Tableau, SQL Loader, PL/SQL, SharePoint,, Crystal Reports, Netezza, NoSQL, HDFS, HBase, Amazon Redshift, AWS, MDM.

Confidential, Chicago, IL

Sr. Data Architect/Data Modeler

Responsibilities:

  • Interact with BusinessAnalysts to get the functional reporting requirements and Interact with End users to find out the reporting needs.
  • Conducted one-to-one sessions with Source SME to gather Source Mapping for the reporting attributes.
  • Configure model design tool (PowerDesigner), metadata repository (Informatica Meta Manager), and analytical/reporting tool (Business Object) and set up Environment.
  • Used ETLmethodology for supporting data extraction, transformations and loading processing, in a complex MDM using Informatica.
  • Converted critical code from Teradata stored procedures to Ab Initio ETL jobs.
  • Experienced in developing Web Services with Python programming language.
  • Created HBase tables to load large sets of structured, semi-structured and unstructured data coming from UNIX, NoSQL and a variety of portfolios.
  • Connected to AmazonRedshift through Tableau to extract live data for real time analysis.
  • Responsible for Metadata Management, keeping up to date centralized metadata repositories using Erwin modeling tools.
  • Created Logical and Physical models using Erwin tool for oracle and Teradata database designs.
  • Worked closely with SolutionArchitects to find out the optimal solution for the Database design from and ETL and DataGovernance perspective.
  • Part of the IDWDesign Team to generate data model for a functional area and also generate the BIReportingMart for the same functional Area.
  • Maintained the Data Dictionary with ReportingAttributes, business description of the attribute, Source Mapping and Target Mapping.
  • Developing full life cycle software including definingrequirements, prototyping, designing, coding, testing and maintaining software
  • Researched, evaluated, architect, and deployed new tools, frameworks and patterns to build sustainable BigData platforms for the clients.
  • Created several Master Data Models (MDM) that unifies data for critical concepts across applications.
  • Involved in suggesting the changes required to the existing data architecture to perform well after moving it into AWS.
  • Collaboration with Architects and Managers for review of solutions and data strategy
  • Responsible for creating OLAPcubes for deep through analysis using SSAS.
  • Generated ad-hoc SQLqueries using joins, database connections and transformation rules to fetch data from Teradata database.
  • Worked with DBA to create Best-Fit Physical Data Model from the logical Data Model using Forward Engineering in Erwin.
  • Performed Hive programming for applications that were migrated to big data using Hadoop
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Involved in data from various sources like Oracle Database, XML, FlatFiles, and CSVfiles and loaded to target warehouse.

Environment: ERWIN 9.5, Teradata 14.1, Amazon Redshift, Tableau, NoSQL, OLAP, OLTP, ODS, MDM,, Hadoop, HDFS, HBase, Oracle 12c, AWS, Python, MDM, Unix, Informatica 9.6.

Confidential - Minneapolis, MN

Sr. Data Architect/Data Modeler

Responsibilities:

  • Developing strategies for data acquisitions, archive recovery, and implementation of databases and working in a data warehouse environment, which includes datadesign, database architecture, and Metadata and repository creation.
  • Designed the data martsusing the Ralph Kimball's Dimensional DataMart modeling methodology using ERStudio.
  • Developed various QlikView Data Models by extracting and using the data from various sources files Excel, FlatFiles and Bigdata.
  • Involved in AWSArchitecture design and modification, gapanalysis
  • Designed and Developed OraclePL/SQL and ShellScripts, Data Import/Export, Data Conversions and DataCleansing.
  • Created DDLscripts using ERStudio and source to target mappings to bring the data from source to the warehouse.
  • Proficiency in SQL across a number of dialects (we commonly write MYSQL, PostgreSQL, Redshift, SQLServer, and Oracle).
  • Responsible for reformat and migration of existing security and derivative database information into new SQLServer database.
  • Developed data extraction programs using Business Objects Data Services
  • Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle, database.
  • Worked in importing and cleansing of data from various sources like Oracle12c, flatfiles, SQLServer with high volume data.
  • Provided guidance and solution concepts for multiple projects focused on data governance and master data management.
  • Monitored and measured data architecture processes and standards to ensure value is being driven and delivered as expected.
  • Created dimensional model for the reporting system by identifying required dimensions and facts using ERStudio.
  • Generated data models to make extracts for SAS sourcing data from Enterprise Data Warehouse.
  • Performed GAP analysis assessed as-Is processes through user interviews, data collection and analysis, design and evaluation of To-Be process solutions.
  • Involved in writing T-SQL, working on SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.
  • Design and develop Business Intelligence architecture using Microsoft and Tableau products.
  • Dataprofiling usingIDQfor the source application OLTP tables to cleanse.
  • Generated DDL statements for the creation of new ER/studio objects like table, views, indexes, packages and stored procedures.

Environment: ER Studio 9.0, SQL Server 2012, QlikView, SSIS, Flat Files, Hadoop, Spark, ETL, PL/SQL, MDM, OLTP, Oracle 11g, BTEQ, SAS, MS Access,IDQ, Excel.

Confidential - Minneapolis, MN

Sr. Data Analyst/Data Modeler

Responsibilities:

  • Involved in data profiling and data cleansing to eliminate data redundancy and enhance performance of the database.
  • Initiated and conducted JAD sessions inviting various teams to finalize the required data fields and their formats.
  • Worked on Conceptual, Logical Modeling and Physical Database design for OLTP and OLAP systems.
  • Designed the data marts using the Ralph Kimball’s Dimensional DataMart modeling methodology using ERStudio.
  • Involved in writing T-SQL, working on SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.
  • Data analysis and reporting using MYSQL, MS PowerPoint, MS Access and SQL assistant.
  • Involved in writing scripts for loading data to target data Warehouse using BTEQ, Fast Load, Multiload
  • Worked on Data modeling using Dimensional Data Modeling, Star Schema/Snow Flake schema, and Fact& Dimensional, Physical & Logical data modeling.
  • Extensively involved in Recovery process for capturing the incremental changes in the source systems for updating in the staging area and datawarehouse respectively
  • Involved in creating dashboards and reports in Tableau and Maintained server activities, user activity, and customized views on Server Analysis.
  • Developed UNIX ShellScripts for database code change deployment to various environments and Job Scheduling.
  • Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
  • Developed multiple data flow tasks for different packages using MSSQLserver integration services.
  • Created tables and views using T-SQL to pull data for creating daily reports for interval level call data.
  • Worked in importing and cleansing of data from various sources like Oracle 10g, flat files, SQL Server 2008 with high volume data.
  • Involved in designing and implementing the data extraction (XMLDATA stream) procedures.
  • Involved in MY SQL, MSPowerPoint, MSAccess Database design and design new database on Netezza which will have optimized outcome.
  • Used SQL assistant tool extensively to profile data and check mapping accuracy.
  • Performed Data mapping between source systems to Target systems, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data

Environment: ER/Studio 8.0, PL/SQL, Informatica 8.x, Oracle 11g, Netezza, UNIX, TIBCO Spotfire, T-SQL, Tableau, MS SQL server 2008, LINUX, DBA

Confidential

Data Analyst/Data Modeler

Responsibilities:

  • Extensively worked with OLTP and Record creation/management systems in data extraction, manipulation and masking in/out of record management systems.
  • Loaded data into various star schema data warehouse dimension and fact tables.
  • Responsible for data conversion from SQLServer to Oracle10g.
  • Created SQLtables with referential integrity, constraints and developed queries using SQL, SQL*PLUS and PL/SQL.
  • Performed business requirements analysis, Data Dictionary mapping, extensive database modeling (Relational and Star schema) utilizing OracleDesigner and SybasePowerDesigner.
  • Performed Data Analysis using procedures and functions in PL/SQL.
  • Designed UML Models (Rational Rose, Visio) and Relational data Models for applications. Created DDLscripts for physical implementation of databases of the Physical Data Model.
  • Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in SybaseDatabaseServers.
  • Created business requirement documents and integrated the requirements and underlying platform functionality.
  • Excellent knowledge and experience in Technical Design and Documentation.
  • Involved in preparing the design flow for the Datastageobjects to pull the data from various upstream applications and do the required transformations and load the data into various downstream applications
  • Used SybasePowerDesigner tool for relational database and dimensional data warehouse designs.
  • Developing ETL in SAS, Teradata, and SQL to load the campaign management datamart from different business sources.
  • Provide production support to resolve user issues for applications using Excel VBA
  • Involved in construction of data flow diagrams and documentation of the processes.
  • Performed Conceptual, Logical and Physical modeling of OLTP, ODS&DW/BI data bases, using PowerDesigner, Visio and Pro Vision tools.
  • Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data

Environment: Sybase PowerDesigner, SQL Server 2005,Oracle 9i, OLAP, OLTP, XML, MS Visio, MS Excel, SQL*PLUS and PL/SQL, Rational Rose, SAS, Power Center 6.2, Business Objects 6.5.

We'd love your feedback!