Sr. Data Architect/data Modeler Resume
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.
