SUMMARY:

• Above 10+ years of experience as Data Architect/Modeler and Data Analyst with high proficiency in requirement gathering and data modeling including design and support of various applications in OLTP, Data Warehousing, OLAP and ETL Environment. 
• Extensive experience with Service Oriented Architecture SOA, UML and creation of XML Schema.
• Experienced in developing Conceptual, Logical and Physical Data Models for enterprise OLTP applications, Operational Data Store (ODS), Data Hub and Master Data Management (MDM) solutions.
• Strong experience with different project methodologies including Agile Scrum Methodology and Waterfall methodology.
• Experience in developing Data Mapping, Data Governance, and Transformation and cleansing rules for the Master Data Management Architecture.
• Strong experience with architecting highly performance databases using PostgreSQL, PostGIS, MYSQL and Cassandra.
• Experienced in designing Architecture for Modeling a Data Warehouse by using tools like Erwin r9.6/r9.5, Sybase Power Designer and E - R Studio.
• Experienced on data architecture including data ingestion pipeline design, Hadoop information architecture, data modeling and data mining, machine learning and advanced data processing.
• Extensive knowledge of big data, Hadoop, Map-Reduce, Hive, NoSQL Databases and other emerging technologies.
• Experience in importing and exporting data from different relational databases like MySQL6.x, Netezza, Oracle into HDFS and Hive using Sqoop.
• Experience in conducting Joint Application Development (JAD) sessions with SMEs, Stakeholders and other project team members for requirements gathering and analysis.
• Experience in integration of various relational and non-relational sources such as DB2, Teradata, Oracle, Netezza, SQL Server, NoSQL database.
• Experience in developing normalized data models into physical RDBMS design via forward engineering as well as reverse engineering existing physical structures for analysis and refinement.
• Extensive experience in Data analysis and Data Profiling of source systems using ANSI SQL for designing accurate and optimal Integration and Conversion solutions.
• Experience in working with Business Intelligence and Enterprise Data Warehouse(EDW) including SSAS, Pentaho, Cognos, OBIEE, QlikView, Greenplum, Amazon Redshift and Azure Data Warehouse
• Extensive experience with various data processing platforms and languages including Apache Spark(Scala), Apache Drill, Python, and PostgreSQL PL/pgSQL.
• Experienced in various Teradata utilities like Fastload, Multiload, BTEQ and Teradata SQL Assistant
• Extensive experience on usage of ETL & Reporting tools like SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
• Good knowledge of Data warehouse concepts and principles like Kimball/Inman, Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De-Normalization for relational and dimensional database environments.
• Worked with XML and Flat file sources coming from various legacy source systems and residing on Mainframe and UNIX.
• Strong experience in writing SQL and PL/SQL, Transact SQL programs for Stored Procedures, Triggers and Functions.
• Created ETL mapping documents establishing source-target data mapping and ETL strategies by working closely with ETL development team.
• Ability to architect data management enterprise solutions that are in alignment with strategic technology road map and emerging industry trends.
• Proven experience in delivering projects successfully through effective planning, prioritizing, team building, motivating, goal setting, task scheduling and tracking of scheduled tasks to completion.

TECHNICAL SKILLS:

Data Modeling Tools: Erwin 9.6/9.5, Sybase Power Designer, ER Studio 9.7/9.6

Database Tools: Microsoft SQL Server 2016/14, Teradata 15.0, DB2, Oracle 12c/11g and MS Access 

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

ETL/Data warehouse Tools: Informatica 9.6, Web Intelligence, Talend, Pentaho

BI Tools: Tableau 7.0/8.2, Tableau server 8.2, Tableau Reader 8.1,Pentaho 6, SAP Business Objects, Crystal Reports

Packages: Microsoft Office 2010, Microsoft Project 2010, SAP and Microsoft Visio, Share point Portal Server, OBIEE 10g/11g, SAP ECC6 EHP5, Go to meeting, MATLAB

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

Version Tool: VSS, SVN, CVS. 

Operating Systems: Linux, UNIX, Windows 8/7, Sun Solaris 

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

Sr. Data Architect/Data Modeler

Responsibilities:

• Responsible for the data architecture design delivery, data model development, review, approval and used Agile Methodology for Data Warehouse development
• Developing and automating multiple departmental Reports using Tableau and MS Excel.
• Responsible for all metadata relating to the EDW's overall data architecture, descriptions of data objects, access methods and security requirements.
• Designed both OLTP and ODS databases for high performance using ERWIN modeling tool.
• Extracted ETL code from mainframe and Datastage jobs via Bluezone FTP Client.
• Established uniform Master Data Dictionary and Mapping rules for metadata, data mapping and lineage.
• Connected to Amazon Redshift through Tableau to extract live data for real time analysis.
• 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.
• Involved in Teradata utilities (BTEQ, Fast Load, Fast Export, Multiload, and Tpump) in both Windows and Mainframe platforms.
• Designed the logical data model from the technical design documents and translating to a physical data model using Erwin 9.6.
• Worked with delivery of Data & Analytics applications involving structured and un-structured data on Hadoop based platforms on AWS EMR
• Designed and implemented Oracle PL/SQL store procedures, functions and packages for data manipulation and validation.
• Involved in all the steps and scope of the project reference data approach to MDM and Created Data Dictionary and Data Mapping from Sources to the Target in MDM Data Model. 
• Participated in the creation of Business Objects Universes using complex and advanced database features.
• Designed and implemented Control-M jobs to automate data marts loading processes.
• Developed Data Mapping, Data Governance, and Transformation and cleansing rules for the Master Data Management Architecture involving OLTP, ODS.
• Worked on building Aptitude Operational Data Store(ODS) model in an Oracle Ex-data database.
• Set up of environments to be used for testing and the range of functionalities to be tested as per technical specifications.
• Reviewed 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 Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions worked with different methods of logging in SSIS.
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.

Environment: Erwin 9.6, Agile, SQL, PL/SQL, XML, Hadoop, Teradata 15, ODS, SSIS, Flat files, MDM, Hadoop, Redshift, HBase, HDFS, Sqoop, SQL Assistance, OLAP, OLTP, Oracle12c and Teradata15.

Confidential, Wilmington, DE

Sr. Data Architect/Data Modeler

Responsibilities:

• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Worked for map reduce and query optimization for Hadoop hive and HBase architecture
• Independently coded new programs and design Tables to load and test the program effectively for the given POC's using Big Data/Hadoop.
• Developed various QlikView Data Models by extracting and using the data from various sources files Excel, Flat Files and Big data.
• Installation and Configuration of other Open Source Software like Pig, Hive, HBase, Flume and Sqoop.
• Actively participated in JAD sessions with Java Architects, ETL Leads, and Technical Leads
• Massively involved in Data Architect role to review business requirement and compose source to target data mapping documents.
• Mapped the data elements from the new system to the downstream BIW (Business Intelligence Warehouse) and produced source to target mapping document.
• Involved in Migrating the data model from one database to Teradata database and prepared a Teradata staging model.
• Participated in JAD sessions for design optimizations related to data structures as well as ETL processes
• Created 3NF business area data modeling with de-normalized physical implementation of data.
• Designed and changed existing data model as per business requirements using Erwin 9.5.
• Responsible for Metadata Management, keeping up to date centralized metadata repositories using Erwin 9.5 modeling tools.
• Involved in requirement analysis, ETL design and development for extracting data from the heterogeneous source systems like Oracle, flat files, XML files and loading into Staging and Data Warehouse Star Schema.
• Involved in Netezza Administration Activities like backup/restore, performance tuning, and Security configuration
• Developed data Mart for the base data in Star Schema, Snow-Flake Schema
• Designed and maintained Metadata documents on team site for unison in design and implementation of Data Model.
• Developed prototype solutions to verify capabilities for new systems development, enhancement, and maintenance of MDM
• Provided suggestion to implement multitasking for existing Hive Architecture in Hadoop. Also suggested UI customization in Hadoop

Environment: Erwin 9.5, Oracle 11g, Teradata 14, PL/SQL, Informatica 8.x, Netezza, UNIX, Tableau, T-SQL, Hadoop, HBase, HDFS, ODS, OLAP, OLTP, Flat Files, MDM, LINUX.

Confidential, Philadelphia, PA

Sr. Data Architect/Data Modeler

Responsibilities:

• Performed Source System Analysis, database design, data modeling for the warehouse layer using MLDM concepts and package layer using Dimensional modeling
• Created HBase tables to load large sets of structured, semi-structured and unstructured data coming from UNIX, NoSQL and a variety of portfolios.
• Created Hive architecture used for real time monitoring and HBase used for reporting
• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using Erwin.
• Generate DDL scripts for database modification, Teradata, Macros, Views and set tables.
• Designed and documented Use Cases, Activity Diagrams, OOD (Object Oriented Design) using UML and Visio.
• Developed data Mart for the base data in Star Schema, Snow-Flake Schema involved in developing the data warehouse for the database.
• Developed MapReduce programs to parse the raw data, populate staging tables and store the refined data in partitioned tables in the EDW.
• Involved in capturing data lineage, table and column data definitions, valid values and others necessary information in the data models
• Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Designed and developed the data dictionary and Meta data of the models and maintain them.
• Performed Data Analysis tasks on warehouses from several sources like Oracle11g, Teradata, and XML and generated various reports and documents
• Processed the data using HQL (like SQL) on top of Map-reduce.
• Interaction with Business Analyst, SMEs and other Data Architects to understanding Business needs and functionality for various project solutions
• Managed, designed, and created the Star Schema and Snowflake Schema for a financial data mart using Erwin.
• Created data masking mappings to mask the sensitive data between production and test environment.
• Developed Star and Snowflake schemas based dimensional model to develop the data warehouse.
• Analyzed the web log data using the HiveQL to extract number of unique visitors per day, page views, visit duration, most purchased product on website.
• Used Normalization (1NF,2NF&3NF) and De-normalization techniques for effective performance in OLTP and OLAP systems.

Environment: Erwin 9.0, Teradata V14, Teradata SQL Assistant, Informatica, Oracle 11g, OLAP, OLTP, ODS, MapReduce, Netezza, Mainframes, SQL, PL/SQL, XML, Hive, Hadoop, PIG.

Confidential, Wallingford, CT

Sr. Data modeler/ Data Analyst

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Performed Reverse Engineering of the current application using Erwin, and developed Logical and Physical data models for Central Model consolidation.
• Translated logical data models into physical database models, generated DDLs for DBAs 
• Performed Data Analysis and Data Profiling and worked on data transformations and data quality rules. 
• Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues. 
• Collected, analyze and interpret complex data for reporting and/or performance trend analysis 
• Wrote and executed unit, system, integration and UAT scripts in a data warehouse projects. 
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica. 
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of Data Analysis responsibilities.
• Designed the data marts using the Ralph Kimball's Dimensional Data Mart modeling methodology using Erwin.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2 
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, with high volume data 
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business 
• Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues. 
• Created SQL tables with referential integrity, constraints and developed queries using SQL, SQL*PLUS and PL/SQL.
• Perform GAP analysis of current state to desired state and document requirements to control the gaps identified.
• Developed the batch program in PL/SQL for the OLTP processing and used Unix Shell scripts to run in corn tab.
• Identify & record defects with required information for issue to be reproduced by development team. 
• Worked on the reporting requirements and involved in generating the reports for the Data Model using crystal reports

Environment: Erwin 8.5, PL/SQL, Business Objects XIR2, Informatica 8.6, Oracle 9i, Teradata R13, Teradata SQL Assistant 12.0, PL/SQL, Flat Files, Teradata

Confidential,jacksonville, FL

Data modeler/ Data Analyst

Responsibilities:

• Involved in understanding Logical and Physical Data model using Erwin Tool.
• Involved in OLTP, OLAP, GUI, Relational Database Management Systems (RDBMS) and Report Development.
• Collaborated with ETL, BI and DBA teams to analyze and provide solutions to data issues and other challenges while implementing the OLAP model. 
• Worked on claims data and extracted data from various sources such as flat files, Oracle and Mainframes.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Analyzed business requirements, system requirements, data mapping requirement specifications interacting with client, developers and QA team.
• Tested several dashboards and deployed them across the organization to monitor the performance.
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• developed advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Excellent experience on Teradata Appliance Backup Utility (ABU) and ARC to backup data to and from Teradata nodes.
• Created customized report using OLAP Tools such as Crystal Report for business use.
• Reviewed the Joint Requirement Documents (JRD) with the cross functional team to analyze the High Level Requirements.
• Creation of UML Diagrams including Context, Business Rules Flow, and Class Diagrams.
• Create and Monitor workflows using workflow designer and workflow monitor.
• Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, MS Access, Excel and SQL
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Analyze technologies, technical processes and/or functions, and document findings, identify areas for improvement and create specifications for implementation
• Developed regression test scripts for the application and Involved in metrics gathering, analysis and reporting to concerned team and Tested the testing programs

Environment: Erwin 7.3, MS Excel, PL/SQL, Informatica 7.x, Oracle 9i/8i, Teradata V2R12, Teradata SQL Assistant, ETL Tools Perl, OLAP, OLTP, PL/SQL, MS Access.