SUMMARY:

• Overall 9+ years of experience as Data Architect/Data Modeler and Data Analyst including designing, developing and implementation of data models for enterprise - level applications and systems.
• Proven experience in Oracle, PL/SQL, as well as extensive background in data modeling and data warehousing.
• Experience in Agile/Scrum, iterative and waterfall SDLC methodologies.
• Experience with distributed data warehousing and/or data mining systems, using one or more Big Data/NoSQL technologies (Hadoop, Hive, HBase, Pig, Cassandra, MongoDB etc.)
• Strong experience with architecting highly performs databases using PostgreSQL, PostGIS, MYSQL and Cassandra.
• Proven experience completing deliverable such as data models, data flow diagrams, and data value maps with minimal supervision
• Experienced in JIRA software for Plan, Track, and Report and Release management.
• Hands on experience in Logical and physical database design like Tables, Constraints, Index, etc. using Erwin, ER Studio, TOAD Modeler and SQL Modeler.
• Experience in working with Business Intelligence and Enterprise Data Warehouse(EDW) including SSAS, Pentaho, Cognos, OBIEE, QlikView, Greenplum, Amazon Redshift and Azure Data Warehouse 
• Responsible for detail architectural design and data wrangling, data profiling to ensure data quality of vendor data, Source to target mapping
• Experience in designing Enterprise Data Warehouses, Data Marts, Reporting data stores (RDS) and Operational data stores (ODS).
• 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
• Experience in Dimensional Data Modeling, Star/Snowflake schema, FACT & Dimension tables.
• Experience in conducting Joint Application Development (JAD) sessions with SMEs, Stakeholders and other project team members for requirements gathering and analysis.
• Experience as a Architect UML models and leverage the advanced executable code generators to target different domains.
• Experience in integration of various relational and non-relational sources such as DB2, Teradata, Oracle, Netezza, SQL Server, NoSQL database.
• Hands on experience in Normalization & De-normalization techniques design considerations upto 3NF Form for OLTP Databases and Models.
• Extensive experience on usage of ETL & Reporting tools like SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) 
• 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.

TECHNICAL SKILLS:

Data Modeling Tools: Erwin 9.6/9.5, Sybase Power Designer, Rational System Architect, IBM Infosphere Data Architect, ER Studio 9.7,

Testing and defect tracking Tools: HP/Mercury, MS Visio & Visual Source Safe

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, Flume. 

Version Tool: VSS, SVN, CVS. 

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

Quality Assurance Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, Quality Center, Rational Functional Tester. 

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

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

Packages: Microsoft Office 2010, Microsoft Project 2010, SAP and Microsoft Visio, Share point Portal Server 

Operating Systems: Linux, UNIX, Windows 8/7

Other tools: OBIEE 10g/11g, SAP ECC6 EHP5, Share point, MATLAB. 

PROFESSIONAL EXPERIENCE:

Confidential, Wallingford, CT

Sr. Data Architect

Responsibilities:

• Developed a high performance, scalable data architecture solution that incorporates a matrix of technology to relate architectural decision to business needs.
• 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.
• Implemented logical and physical relational database and maintained Database Objects in the data model using Erwin 9.6
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models using Star and Snow Flake Schemas
• Loaded data into Hive Tables from Hadoop Distributed File System (HDFS) to provide SQL access on Hadoop data
• Provide code fix for existing issues of Enterprise Data Warehousing by developing Teradata BTEQ scripts and modifying the mapping using Informatica PowerCenter 9.6. 
• Worked on TERADATA15 and utility domains. Optimization of Queries in a Teradata database environment
• Worked in using Teradata tools like Fast Load, Multi Load, Tpump, FastExport, Teradata Parallel Transporter (TPT) and BTEQ.
• Used ETL methodology for supporting data extraction, transformations and loading processing, in a complex MDM using Informatica.
• Produced and enforced data standards and maintain a repository of data architecture artifacts and procedures.
• Provides architectures, patterns, tooling choices and standards for master data and hierarchy life cycle management
• Developed long term data warehouse roadmap and architectures, designs and builds the data warehouse framework per the roadmap.
• Worked on Tableau for insight reporting and data visualization
• Designed and developed architecture for data services ecosystem spanning Relational, NoSQL, and Big Data technologies.
• Specifies overall Data Architecture for all areas and domains of the enterprise, including Data Acquisition, ODS, MDM, Data Warehouse, Data Provisioning, ETL, and BI.
• Developed Data Mapping, Data Governance, and Transformation and cleansing rules for the Master Data Management Architecture involving OLTP, ODS.
• Refresh hardware sizing and design the infrastructure landscape for MDM and BODS
• Worked with Netezza and Oracle databases and implemented various logical and physical data models for them.
• Proficiency in SQL across a number of dialects (we commonly write MySQL, PostgreSQL, Redshift, SQL Server and Oracle).
• Developed and implemented data cleansing, data security, data profiling and data monitoring processes.
• Cleaned and maintained the database by removing and deleting old data.
• Worked with reverse engineering Data Model from Database instance and Scripts.
• Connected to Amazon Redshift through Tableau to extract live data for real time analysis.
• Evaluate multiple source systems and analyze to generate a unified data flow model for ETL architecture.
• Developed and delivered efficient and cost-effective technical solutions to meet customer business requirements by developing ETL automation process.

Environment: Erwin9.6, Teradata 15, Tableau, Amazon Redshift, Hive, ODS, OLAP, OLTP, Hadoop, MapReduce, HDFS, MDM, NoSQL, Agile, Unix, Spark, Cassandra

Confidential, Princeton, NJ

Sr. Data Architect/Data Modeler

Responsibilities

• Responsible for the data architecture design delivery, data model development, review, approval and Data warehouse implementation.
• Used Agile Methodology of Data Warehouse development using Kanbanize.
• Involved in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.
• Installation and Configuration of other Open Source Software like Pig, Hive, HBase, Flume and Sqoop.
• Developed Data Mapping, Data Governance, and Transformation and cleansing rules for the Master Data Management Architecture involving OLTP, ODS.
• Develop prototype solutions to verify capabilities for new systems development, enhancement, and maintenance of MDM
• Completed enhancement for MDM (Master data management) and suggested the implementation for hybrid MDM (Master Data Management)
• Provided suggestion to implement multitasking for existing Hive Architecture in Hadoop. Also suggested UI customization in Hadoop
• Performing 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 for map reduce and query optimization for Hadoop hive and HBase architecture
• 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 Physical Data Model (PDM) using Erwin and Oracle PL/SQL.
• Designed and documented Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object Oriented Design) using UML and Visio.
• Involved in Teradata utilities (BTEQ, Fast Load, Fast Export, Multiload, and Tpump) in both Windows and Mainframe platforms.
• Responsible for Metadata Management, keeping up to date centralized metadata repositories using Erwin modeling tools.
• 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.
• Worked very close with Data Architectures and DBA team to implement data model changes in database in all environments.
• 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 involved in developing the data warehouse for the database.
• Primarily responsible for Tableau customization for statistical dashboard to monitor sales effectiveness and also used Tableau for customer marketing data visualization.
• Designed integration solution from legacy source system to operational data store with the help of ETL

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, MS SQL server 2005, LINUX, DBA.

Confidential, Boston, MA

Sr. Data Analyst

Responsibilities:

• Designed Physical & Logical Data Model using ERWIN with the entities and attributes for each subject areas.
• Worked in enhancement of the existing Teradata processes running on the Enterprise Data Warehouse
• Interacted with DBA to discuss database design and modeling, index creations and SQL tuning issues.
• Developed test scripts for testing sourced data and their validation and transformation when persisting in data stores that are physical representations of the data models.
• Designed normalized and star schema data architectures using ER Studio and forward engineering these structures into Teradata
• Designed and developed SAS macros, applications and other utilities to expedite SAS Programming activities.
• Used normalization and de-normalization techniques to achieve optimum performance of the database.
• Created tables, views, sequences, indexes, constraints and generated SQL scripts for implementing physical data model.
• Designed the data marts using the Ralph Kimball's Dimensional Data Mart modeling methodology using ER Studio.
• Designed and implemented relational data model (OLTP) to support OAC database in Oracle.
• Conducted JAD sessions during the various stages of upgrading the matching system and discuss the current system preference.
• Created DDL scripts using Erwin and source to target mappings to bring the data from source to the warehouse.
• Prepared data dictionary/business glossaries and also integrated Data dictionary into data models
• Created mapping documents to aid with the development of more complex PL/SQL reports.
• Generate DDL and DML and execute them on the database
• Assist with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Developed the batch program in PL/SQL for the OLTP processing and used Unix Shell scripts to run in corn tab.
• Performed extensive data profiling and data analysis for detecting and correcting inaccurate data from the databases and track the data quality.
• Designed mappings using Informatica coming from different sources like databases, flat files into Oracle staging area.
• Parsed high-levels design spec to simple ETL coding and mapping standards
• Provided guidance and solution concepts for multiple projects focused on data governance and master data management.
• Performed performance improvement of the existing Data warehouse applications to increase efficiency of the existing system.

Environment: Erwin 9.0, Teradata 14, SSIS, Flat Files, ETL, PL/SQL, MDM, OLTP, Oracle 10g, BTEQ.

Confidential, Birmingham, AL

Sr. Data Analyst

Responsibilities

• Extensively used Erwin as the main tool for modeling along with Visio
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
• Involved with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using Erwin tool.
• Produced PL/SQL statement and stored procedures in DB2 for extracting as well as writing data.
• Used SQL*Loader to load the database from flat files and Converted Data stored in flat files into Oracle tables.
• Worked on Conceptual, Logical Modeling and Physical Database design for OLTP and OLAP systems.
• Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories.
• Conducted and participated in JAD sessions with the users, modelers, and developers for resolving issues.
• Created 3NF business area data modeling with de-normalized physical implementation data
• Documented and published the data models and their associated metadata.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Developed entity and attribute descriptions and definitions for the models and ensure that conflicts in descriptions and definitions are resolved.
• Performed data cleaning and data manipulation activities using NZSQL utility.
• Setup table level, column level and index level properties using Erwin tool.
• Developed Star and Snowflake schemas based dimensional model to develop the data warehouse.
• Used Reverse Engineering to connect to existing database and developed process methodology for the Reverse Engineering phase of the project.
• Maintain and enhance data model with changes and furnish with definitions, notes, and reference values and check lists.
• Participated in Performance Tuning using Explain Plan and TKPROF. 
• Performed Data Analysis and Data Profiling using complex SQL queries on various sources systems including Oracle, Teradata. 
• Used SQL for Querying the database in UNIX environment
• Created documentation and test cases, worked with users for new module enhancements and testing.

Environment: Erwin r8.2,Teradata 12, OLAP, OLTP, Oracle SQL Developer, Oracle Data Modeler, SSIS, Business Objects, Flat Files, PL/SQL, Metadata, MS Excel.

Confidential, Richmond, CA

Data Analyst/Data Modeler

Responsibilities:

• Created Physical Data Model from the Logical Data Model in Erwin and worked with the naming standards utility.
• Performed Data Analysis and Data Profiling and worked on data transformations and data quality rules.
• Wrote ad-hoc SQL queries and worked with SQL and Netezza databases
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning and to ensure testing issues are resolved on the basis of using defect reports.
• Created a Data Mapping document after each assignment and wrote the transformation rules for each field as applicable
• Well-versed in writing SQL queries to perform end-to-end ETL validations and support Ad-hoc business requests.
• Worked on the reporting requirements and involved in generating the reports for the Data Model using crystal reports.
• Involved in writing T-SQL, working on SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.
• Worked extensively on Data Quality (running Data Profiling, Examine Profile outcome) Metadata management
• Applied data naming standards, created the data dictionary and documented data model translation decisions and also maintained DW metadata.
• Extensively used SQL for performance tuning.
• Developed and executed queries in SQL for reporting using SQL Manager
• Created data masking mappings to mask the sensitive data between production and test environment.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Involved in deploying in the production environment along with developers and providing production support for data when issues arise.

Environment: Erwin7.0, Oracle 9i, ODS, OLAP, OLTP, SSIS, SSRS, SSAS, Business Objects, Crystal Reports