SUMMARY

• Result - oriented IT professional experience with a strong background in Database development and designing data models for online transactional processing (OLTP) and online Analytical Processing (OLAP) systems for Health Care, Financial, Insurance & Telecom domains.
• Extensive experience in leveraging AWS cloud architecture to establish a cloud enterprise data warehouse using Redshift/Snowflake.
• Hands on experience in using Informatica Cloud services like data synchronization, data replication, mapping configuration and object migration from Dev. to SIT, UAT and Prod Env9
• Strong background in various Data Modeling tools using ERWIN, IBM Data Architect, Power Designer, MS Visio.
• Expert knowledge in SDLC (Software Development Life Cycle) and good experience in the field of business analysis, reviewing, analyzing, and evaluating business systems and user needs, business modeling, document processing.
• Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Logical data model/Physical data models Designs, ER Diagrams, Forward and Reverse Engineering, Publishing ERWIN diagrams, analyzing data sources and creating interface documents.
• Designed and developed Data Marts by following Star Schema and Snowflake Schema Methodology, using industry-leading Data Modeling tools like Erwin.
• Participated in JAD sessions, created Use Cases, workflows, and PowerPoint presentations.
• Gathering and translating business requirements into technical designs and development of the physical aspects of the specified design.
• Gathered and documented Functional and Technical Design documents.
• I have experience in extensive data profiling & Analysis.
• Worked extensively on Data Governance. Implemented metadata management to achieve regulatory compliance and quality in business intelligence.
• I have worked with ETL tools to extract, transform, and load data from relational databases and various file formats and loaded them to the target database.
• Excellent knowledge in SQL and coding PL/SQL Packages, Procedures.
• Experience in SQL Performance Tuning and Optimization (Design, Memory, Application, IO) and using Explain plan, Tracing, and TKPROF.
• Experience in creating Materialized views, Views, Lookups for the Oracle warehouse.
• Experience with Erwin model manager.
• Experience working with Master Data Management
• A dedicated team player with excellent communication, organizational and interpersonal skills.
• 7+ strong experience with data profiling tools such as Informatica Data Quality (IDQ)

TECHNICAL SKILLS

DBMS: Oracle 11/12, Hadoop Big Data, Hive, MS SQL SERVER 2016/2017, Sybase, Teradata, Netezza, Python

Database Specialties: Database Architecture, Data Analysis, Enterprise Data Warehouse, Database Design and Modeling, Data extraction, Integration, transformation, and Migration, ETL Architecture and Design Data Warehouse, OLTP, OLAP, Report Design and Development.

Data Analysis: User Requirement Gathering, JAD Sessions, Gap Analysis, Data Cleansing, Data Transformations, Data Profiling, Source Systems Analysis, Data Relationships

Data Modeling: Erwin, Infosphere Data Architect (IDA), MS Visio, Toad, Power Designer, ER Studio

ETL Tools: BODS 3.X, BO DI XI R2/6.5, Informatica, Data Stage, Glue, AWS Batch, EMR, Pyspark

Reporting Tools: Tableau, PowerBI, Quicksight

Programming: Python3, PL/SQL, T-SQL, JAVA, C/C++, VB 6.0

Scripting languages: JavaScript, PHP, Unix Shell, bash

Other technologies: Docker, Apache Airflow, Spark, Kafka, AWS Kinesis

Microsoft Office: Word, MS Excel, Access

PROFESSIONAL EXPERIENCE

Confidential, Englewood, Colorado

Data Architect

Responsibilities:

• Supported the enterprise architecture and performed Proof of Concept for several new technologies to find innovative ways to enhance the enterprise data warehouse.
• Orchestrated the migration plan for several business processes to establish a hybrid cloud architecture that leveraged Teradata and AWS Redshift
• Reviewed functional requirements and use cases to determine the necessary data requirements.
• Participated in creating realistic project plans with detailed tasks and ensuring their timely execution.
• Reversed engineered current system data model and subdivided it into workstreams for analysis and generated data source to target mapping documents.
• Created process flows and data flow diagrams of the current and future systems.
• Performed dependency and gap analysis for data structure changes on other downstream applications and the impact of new data elements on existing downstream processes.
• Designed and produced logical and physical data models for the financial platform and other in-house applications running on Oracle databases.
• Developed ETL procedures for moving data from source to target systems.
• Worked closely with both functional and technical team on the creation of data models which can seamlessly integrate with existing data structures on multiple Oracle databases integrated by database links.

Environment: ERWIN r9, Teradata, AWS Redshift, SQL Server 2017, 7, MS Visio, Docker, Airflow, AWS S3, Oracle 10g, PL/SQL

Confidential, Columbus, Ohio

Data Modeler/Analyst

Responsibilities:

• Responsible for delivering and coordinating data-profiling, data-analysis, data-governance, data-models (conceptual, logical, physical), data-mapping, data-lineage, and reference data management.
• Participated in meetings & JAD sessions to gather and collect requirements from the business end-users as well as reporting requirements. Worked with Business Analysts, SQL Developers, end-users, and stakeholders to understand the requirements and sign off on the various deliverables
• Create team strategies and establish project scopes of work; communicate project deliverable time frames and benchmarks to project sponsors.
• Created process flows and data flow diagrams of the current and future systems.
• Suggest architectural improvements, design, and integration solutions, and formulate methodologies to optimize database development.
• Performed Data profiling and exploration using Informatica IDQ
• Performed gap analysis for different data sources
• Created Source to Target mapping to include transformations and data quality rules needed for EDW Integration
• Created Data Marts to support enterprise reporting.
• Maintained metadata, version controlling of the data model.
• Utilized hybrid data model architecture to deliver project goals with a limited budget.
• Developed Data Exploration zone stores to manage raw data for exploratory analytics
• Created Materialized views & Summary tables for Reporting
• Integrated physical data model with a business glossary.
• Implemented data lineage of Metadata workbench tool

Environment: IBM Infosphere Data Architect (IDA), Hive, HDFS, Netezza, Teradata, Oracle 11g, Big Integrate, Toad, SQL Server

Confidential, Columbus, OH

Data Architect/Data Modeler

Responsibilities:

• Attended and participated in information and requirements gathering sessions.
• Translated business requirements into working logical and physical data models for Staging, Operational Data Store, and Data marts applications.
• Performed gap analysis and dependency analysis for current & future systems.
• Designed Star Schema Data Models for Enterprise Data Warehouse using Infosphere IDA.
• Created Mapping documents for ETL using Infosphere Fast Track tool
• Created and maintained Logical & Physical Data Models for the project. Included documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Implemented metadata management as one part of data governance. Worked with the business users to populate business glossary.
• Imported model to the business glossary and performed integration of the technical and business terms.
• Implemented data lineage of Metadata workbench tool
• Worked with Cognos reporting team to export XML framework manager model from IDA
• Validated and updated the appropriate Models to process mappings, screen designs, use cases, business object model, and system object model as they evolved and changed.
• Regular work reviews & supporting test units
• Created Model reports including Data Dictionary, Business reports.
• Generated SQL scripts and implemented the relevant databases with related properties from keys, constraints, indexes & sequences.
• Netezza Performance tuning: grooming, distribution keys, etc.

Environment: IBM Infosphere Data Architect, DB2, Teradata, Oracle 11g, IBM Data Stage, Toad, SQL Server

Confidential

Sr. Data Analyst

Responsibilities:

• Conducted JAD sessions, gathered information from Business Analysts, SQL Developers, end-users, and stakeholders to determine the requirements or various systems.
• Created and documented the models, data Workflow Diagrams, Sequence Diagrams, Activity Diagrams, and field mappings of all existing systems.
• Proficient in using ERwin Reverse engineering, Forward Engineering, and Complete Compare functions to create, updated, and resolve issues with existing data models.
• Created and implemented ERwin Naming Standards and Domain in the design of the creation of logical and physical data models following the company’s standards.
• Worked with other Data Modeler, DBAs, and Developers in my projects using Microsoft Team Foundation Server to ensure that every accept of the project is effectively considered and completed and on time.
• Prepared and presented graphical representation forms of Entity-Relationship Diagrams with eliciting more information.
• Created and maintained, conceptual, logical, and physical data models that define the information required for management and business intelligence purposes using Erwin Data Modeler.
• Worked with the DBAs and SQL Developers to deploy and maintain the developed physical data models.
• Used Erwin data modeler to design and implement the company’s health care domains
• Generated ad-hoc SQL queries using joins, database connections, and transformation rules to fetch data from the source and SQL Server database systems.

Environment: ER Studio Data Architect, MS SQL Server 2012, 2014, ServiceNow, Salesforce, MS Visio, Microsoft Visual Studio 2012, 2013, Microsoft Team Foundation Server