SUMMARY:

• Above 11+ years of Experience working as a Data Architect/Data Modeler and Data Analyst with emphasis on Data Mapping, Data Validation in Data Warehousing Environment.
• Extensive experience in RelationalDataModeling, DimensionalDataModeling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering.
• Experience in developing Map Reduce Programs using Apache Hadoop for analyzing the Big Data as per the requirement.
• Experience in working with business intelligence anddatawarehouse software, including SSAS, Pentaho, Cognos, OBIEE, QlikView, Greenplum, Amazon Redshift and AzureData Warehouse
• Excellent understanding and working experience of industry standard methodologies like System Development Life Cycle (SDLC), as per Rational Unified Process (RUP), AGILE and Waterfall Methodologies
• Solid Understanding of bigdatatechnologies like Hadoop, Spark, MapReduce, Pig and Hive.
• Extensive experience in sitting up Procedures to Extract, Transform & Load (ETL) data from Operational & Legacy Systems to the Data Warehouse by Using Informatica.
• Experienced in Strong in Source to Target data mapping, Standardization Document, Mapping Creation, Star/Snowflake Schema Mapping Creation, RDMS, Building Data Marts and Meta Data Management.
• Expertise in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes
• Experience in EnterpriseDataWarehousing design, Building conceptual Architect, Data Integration and Business Intelligence Solution.
• Experience leveraging architecture frameworks such TOGAF 9.0.
• Experience in importing and exportingdatausing Sqoop from HDFS to Relational Database Systems (RDBMS) and from RDBMS to HDFS.
• Enterprisein DataManagementDataGovernance,DataArchitecture,DataModeling, Warehousing,DataIntegration, Meta - data, ReferenceDataand MDM
• Data warehousing experience in designing and developing ETL mappings and scripts using Informatica PowerCenter 9.5/9.1/ 8.6 using Designer, repository Manager, Repository Server, Workflow Manager & Workflow Monitor, Data Profiling, Data Cleansing.
• Good understanding and hands on experience in setting up and maintaining NoSQL Databases like Cassandra, Mongo DB, and HBase.
• Expertise in Data Models, ER diagrams, Data Dictionaries, Data mapping and Data Lineage documents.
• Designing the architecture of thedatawarehouse after understanding and analyzing the legacy databases.
• Experience in designing star schema, Snowflake schema forDataWarehouse, ODS architecture by using tools like Erwindatamodeler, Power Designer, Embarcadero E-R Studio.
• Good knowledge of Data Marts, Operational Data Store (ODS), Dimensional Data Modeling with Ralph Kimball Methodology using Analysis Services
• Extensive experience in shell scripting Python, Perl, Ruby, or any other scripting language
• Experienced in SQL, PL/SQL package, function, stored procedure, triggers, and materialized view, to implement business logics of oracle database.
• Worked and extracteddatafrom various database sources like Oracle, SQL Server, DB2, and Teradata.
• Strong experience with architecting highly performance databases using PostgreSQL, PostGIS, MYSQL and Cassandra.
• Extensive experienced in Normalization and De-normalization techniques for improved database performanceDataWarehouse/DataMart environments.
• Experience in Teradata SQL queries, Teradata Indexes, Utilities such as Mload, Tpump, Fast load and Fast Export.

TECHNICAL SKILLS:

Analysis and Modeling Tools: Erwin 9.6/9.5, Sybase Power Designer, Oracle Designer, ER/Studio 9.7

Databases: Oracle 12c/11g, Teradata R15/R14, MS SQL 2014/2012, DB2, MS Access, Netezza

BigData: Hadoop, HDFS 2, Hive, Pig, HBase, Sqoop, Flume.

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

BI Tools: Tableau, Tableau server, Tableau Reader, SAP Business Objects

Operating System: Windows, Unix, Sun Solaris and Linux

ETL/Datawarehouse Tools: Informatica 9.6/9.1, SAP Business Objects XIR3.1/XIR2, Web Intelligence, Talend, Tableau, Pentaho

Tools & Software: MS Office, BTEQ, Teradata SQL Assistant

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

Testing and defect tracking Tools: HP/Mercury (Quality Center, Win Runner, Quick Test Professional, Performance Center, Requisite, MS Visio & Visual Source Safe

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Sr. Data Architect/Data Modeler

Responsibilities

• As an Architect responsible for the data Architecture and Data Model design, delivery, data model development, review, approval and Data warehouse implementation.
• Implement System Development Life Cycle (SDLC) using Agile as per requirement
• Worked as Architect to implement MDM hub to provide clean, consistent data for a SOA implementation.
• Worked in NoSQL database on simple queries and writing Stored Procedures for Normalization and De-normalization(3NF)
• Worked with delivery of Data & Analytics applications involving structured and un-structured data on Hadoop based platforms on AWS EMR
• Used extensively Base SAS, SAS/Macro, SAS/SQL, and Excel to develop codes and generated various analytical reports.
• Responsible for all metadata relating to the EDW's overall data architecture, descriptions of data objects, access methods and security requirements.
• Designed the logical data model from the technical design documents and translating to a physical data model using ER Studio.
• Analyzed defects that occurred in the process of ingestion and provision into HIVE, and loaded into Mark Logic from Talend.
• Handled performance requirements for databases in OLTP and OLAP models using using Star and Snowflake Schemas
• Involved in all the steps and scope of the project reference data approach to MDM, Creating a Data Dictionary and Mapping from Sources to the Target in MDM Data Model.
• Represented conceptual, logical and physical data models using Cassandra and NOSQL databases
• Working with various data processing platforms and languages including Apache Spark(Scala), Apache Drill, Python, Oracle PL/SQL, and PostgreSQL PL/pgSQL
• Worked on BI tools such as SSIS, SSRS, SSAS and tabular data modeling including MS solutions like MS EXCEL and MS Access Database.
• Researched, evaluated, architect, and deployed new tools, frameworks, and patterns to build sustainable Big Data platforms for our clients
• Handled importing of data from various data sources, performed transformations using Hive, MapReduce, loaded data into HDFS and Extracted the data from Oracle into HDFS using Sqoop.
• Developed Data Mapping, Data Governance, and Transformation and cleansing rules for the Master Data Management Architecture involving OLTP, ODS.
• Performed ad-hoc analysis, 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.

Environment: ER Studio 9.7, Agile, Mark Logic, SQL, PL/SQL, MDM, Hadoop, Redshift, HBase, HDFS, Sqoop, ODS, OLAP, OLTP, Oracle12c and Teradata15

Confidential, Gardner, KS

Sr. Data Architect/Data Modeler

Responsibilities

• Interaction with Business Analyst, SMEs and otherDataArchitectsto understanding Business needs and functionality for various project solutions
• Worked as Data Architect to implement it in the data model.
• Conducted Integrated Data Warehouse (IDW) project business requirement sessions with business users to understand the requirements.
• Establisheddataarchitecture strategy, best practices, standards, and roadmaps
• Independently coded new programs and design Tables to load and test the program effectively for the given POC's using BigData/Hadoop.
• Translate business and data requirements into Logical data models in support of Enterprise Communication Data Model, OLTP, OLAP, Operational Data Store(ODS) and Analytical systems.
• Extensive experience in PL/SQL programming - Stored Procedures, Functions, Packages and Triggers.
• Created reports from Greenplum (Pivotal) which references the positions/transactions for each customer's monthly invoice for all jurisdiction (CFTC, ESMA, CANADA, ASIC & MAS) and make it available on the Portal .
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Working on Amazon Redshift and AWS and architecting a solution to load data, create data models and run BI on it.
• Based on TRD Document Worked in Designed and implemented Informatica ETL solutions.
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, data types, domain definitions, and corporate meta-data definitions.
• Accountable and responsible for establishing a Data Governance initiative and framework within the program as well as contributing to and ensuring compliance to the overall Data Governance strategy.
• Performeddataanalysis and data profiling using complex SQL on various sources systems including Oracle and DB2.
• Used Erwin and Visio to create 3NF and dimensionaldatamodels and published to the business users andETL/ BI teams.
• Designed both 3NFdatamodels for ODS, OLTP systems and dimensionaldatamodels using Star and Snowflake Schemas.
• Involved in Extraction, Transformation and Loading (ETL) process and used Informatica power Center Components - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Worked with the Business and the ETL developers in the analysis and resolution of data related problem tickets and other defects.
• Used push down optimization in Informatica to call Greenplum GPLoad functions
• Involved in writing Shell Scripts to accumulate the MTD source file Collaboration with Architects and Managers for review of solutions and data strategy
• Generated data models to make extracts for SAS sourcing data from Enterprise Data Warehouse.
• Defined best practices fordatamodeling and extraction and ensure architectural alignment of the designs and development.

Environment: Erwin9.6.4, Oracle 12c, ODS, PL/SQL, OLAP, OLTP, Hadoop, MapReduce, HDFS, Star Schema, Snowflake Schema, MDM, DB2, Hadoop, Spark, Cassandra, SAP

Confidential - NYC, NY

Sr. Data Architect/Data Modeler

Responsibilities

• Develop and maintain data architecture, including master data and data quality, using Toad Data Modeler.
• Worked as Architect and designed conceptual, logical and physical models and build data marts using hybrid Inmon and Kimball DW methodologies
• Design and develop Business Intelligence architecture using Microsoft and Tableau products.
• Worked as Architect and designed conceptual, logical and physical models and build data marts using hybrid Inmon and Kimball DW methodologies
• Performed Hive programming for applications that were migrated to big data using Hadoop
• Created native Oracle functions to Greenplum DDLs for Business Objects to use
• Created a detailed plan to migrate the EDW from Oracle to Greenplum.
• Created Hive functions in python to be used with hive.
• Enhancement of conceptual, logical & physical models adopting techniques such 3NF and Data Vault to model different data domains
• Development and performance enhancements for Star Schemas, ODS, metadata management.
• Worked with the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes.
• Used PL/SQL programming - Stored Procedures, Functions, Packages and Triggers
• Involved in Teradata utilities (BTEQ, Fast Load, Fast Export, Multiload, and Tpump) in both Windows and Mainframe platforms.
• Created several Master Data Models (MDM) that unify data for critical concepts across applications.
• Created views on top of highly normalized data to make it easier for the developers to write the queries.
• Performing code reviews for ETL mappings from a performance & Error handling perspective.
• Designed Physical Data Model (PDM) using IBM Info sphere Data Architect data modeling tool and Oracle PL/SQL.
• Worked in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Designed components for overall data architecture - Metadata Management, Reference Data, Data Staging, Enterprise Data Warehouse, and Operational Data Store.
• Collaboration with Architects and Managers for review of solutions and data strategy
• Conducted performance tuning of the database that included creating indexes, optimizing SQL statements.

Environment:Toad, Agile, Teradata 14.1, PL/SQL, ODS, Hive, Hadoop, OLAP, OLTP, flat files, MDM, Hadoop, Python, Tableau.

Confidential - Tampa, FL

Sr. Data Architect/Data Modeler

Responsibilities

• Involved in Data Architecture, Data profiling, Data analysis, data mapping and Data architecture artifacts design.
• Developing full life cycle software including defining requirements, prototyping, designing, coding, testing and maintaining software.
• Responsible for the data architecture design delivery, data model development, review, approval and Data warehouse implementation.
• Performed extensive Data Analysis for few applications and suggested Design and Best Practices.
• Designed the data warehouse architecture for all the source systems using MS Visio
• Involved in the design and development of user interfaces and customization of Reports using Tableau and OBIEE.
• Designed of Big Data platform technology architecture Including data intake, data staging, data warehousing, and high performance analytics environment.
• Installation and Configuration of other Open Source Software like Pig, HBase, Flume and Sqoop.
• Involved in end to end implementation of Big data design.
• Design MOLAP/ROLAP cubes on Teradata Database using SSAS.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Designed ER diagrams, Conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Worked on designing a Star schema for the detailed data marts and plan data marts involving confirmed dimensions.
• Created, maintained, modified, and optimized Teradata databases, database security and auditing
• Generated and DDL (DataDefinition Language) scripts using ERWIN 9and assisted DBA in Physical Implementation ofdataModels.
• Worked with team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes.
• Worked in importing and cleansing of data from various sources like Teradata, flat files, SQL Server with high volume data.
• Create and communicate the strategy and use of Big Data.
• Involved in the daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.

Environment: Erwin 9.0, BTEQ, PL/SQL, OLAP, ODS, OLTP, SSAS, Pig, HBase, Flume, Sqoop, Tableau, SQL Server 2008, Teradata R13, Teradata SQL Assistant, Flat Files, SSAS, Pivot, OBIEE.

Confidential - Bellevue, WA

Sr. Data Analyst/Data Modeler

Responsibilities

• Working as aDataModeler/Analyst to generateDataModels using Erwin and developed relational database system.
• Used Erwindatamodeling tools to createdatamodels for databases and DDL scripts by using Forward and Reverse Engineering.
• Created data masking mappings to mask the sensitive data between production and test environment.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle.
• Worked on SQL queries in a dimensional data warehouse as well as a relational data warehouse.
• Developed dimensional model for Data Warehouse/OLAP applications by identifying required facts and dimensions.
• Designed STAR schema for the detailed data marts and plan data marts consisting of confirmed dimensions.
• PerformedDataAnalysis anddataprofiling using complex SQL on various sources systems including Oracle 10g and Teradata.
• Used Erwin model mart for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Created views and dashboards on end client's data. Produced powerful dashboards telling story behind the data in an easy to understand format such as pie, bar, geo, and line charts that are viewed daily by senior Management.
• Used Teradata for OLTP systems by generating models to support applications that connect to SAS.
• Performed logical data modeling, physical data modeling (including reverse engineering) using the Erwin Data Modeling tool.
• Performed logical data model design including normalization/de-normalization referential integrity, data domains.
• Involved inDataProfiling,DataCleansing and make sure thedatais accurate and analyzed when it is transferring from OLTP toDataMarts andDataWarehouse.
• Developed detailed ER diagram anddataflow diagram using modeling tools following the SDLC structure.
• Used M-LOAD, Fast-load and T-pump loading to migratedatafrom Oracle to Teradata.
• Involved in the creation, maintenance ofDataWarehouse and repositories containing Metadata

Environment: Erwin 8, Teradata 12, BTEQ, PL/SQL, OLAP, ODS, OLTP, Tableau, Oracle9i/10g, SAS

Confidential

Sr. Data Analyst/Data Modeler

Responsibilities

• Designeddatamodels anddataflow diagrams using Erwin and MS Visio.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Prepared scripts for model and data migration from DB2 to the new Appliance environments.
• Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve performance.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Modeled the dimensions and facts using Erwin for centralized Data warehouse.
• Worked extensively in data analysis by querying in SQL and generating various PL/SQL objects.
• Collaborated the data mapping document from source to target and the data quality assessments for the source data.
• Maintained the quality ofdataanalysis, researched output and reporting, and ensured that all deliverables met specified requirements.
• Extensively used ETL to load data from DB2, Oracle databases.
• Generated comprehensive analytical reports by running SQL queries against current databases to conductDataAnalysis.
• Extensively worked with SSIS packages forDataMigration from source systems.
• Implemented Data Archiving strategies to handle the problems with large volumes of data by moving inactive data to another storage location that can be accessed easily.

Environment: Erwin 7.0, Oracle 8i, DB2, Oracle SQL Developer, PL/SQL, Business Objects, MS Visio, OLAP, OLTP, SSIS