Data Modeler/Analyst Resume

SUMMARY

4 years of IT experience in design, architecture, development, implementation and maintenance to support standard databases and data warehousing environments.
Working experience as a DataModeler and Data Analyst with high proficiency in requirement gathering and data modeling including design and support of various applications in OLTP, Data Warehousing, OLAP.
Excellent experience in delivering Quality Conceptual, Logical and Physical Data Models for Multiple projects involving various Enterprise New and Existing Applications and Data Warehouse.
Proficient in data mart design, creation of cubes, identifying facts& dimensions, star & snowflake schemes.
Efficient in developing Logical and Physical Data model and organizing data as per the business requirements using Sybase Power Designer, Erwin, ER Studio in both OLTP and OLAP applications
Comprehensive knowledge and experience in process improvement, normalization/de - normalization.
Expertise on Relational Data modeling (3NF) and Dimensional data modeling.
Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
Expertise in documenting the Business Requirements Document (BRD), generating the UAT Test Plans, maintaining the Traceability Matrix and assisting in Post Implementation activities.
Experience on Data Analysis and Data Mapping.
Experienced in theDataAnalysis, Design, Development, Implementation and Testing usingData Conversions, Extraction, Transformation SQL Server and ORACLE.
Experience in RDBMS (Oracle) PL/SQL, SQL, Stored Procedures, Functions, Packages, Triggers
Experience in Dimensional Modeling and Data Warehouse. ETL tools Informatica /Data Stage/BI tools such as Business Objects. Star& Snow Flake Schemas.
Extensive experience in using ER modeling tools such as ERwin and ER/Studio.
Excellent problem solving and analytical skills with a proven ability to learn and understand new technologies efficiently.
Effective team worker and can carry out individual tasks to meet the deadlines effectively.
Excellent understanding and working experience of industry standard methodologies like System Development Life Cycle (SDLC), as per Rational Unified Process (RUP), AGILE Methodologies.
Extensive experience with OLTP/OLAP System and E-R modeling, developing Database Schemas like STAR schema and Snowflake schema used in relational, dimensional and multidimensional modeling.

TECHNICAL SKILLS

RDBMS: Microsoft SQL Server14.0, Oracle 12c/11g/9i, and MS Access

SQL Interpreters: Erwin 9.x/7.x/4.x, Toad 9.6

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

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

MS Office Tools: Excel, Access, Word, PowerPoint, Project, Visio

Languages: PL/SQL.

Operating Systems: Windows 10/7/ XP/00.

PROFESSIONAL EXPERIENCE

Confidential

Data Modeler/Analyst

Responsibilities:

Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Synonyms, Database triggers, Stored Procedures) in the data model.
Developing the Conceptual Data Models, Logical Data models and transformed them to creating schema using ERWIN.
Translated business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications.
Participate in weekly data analyst meting and submit weekly data governance status.
Defined and processed the facts, dimensions. Designed Data Mart modeling methodology using Erwin.
Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and bulk collects.
As part of Data Masking / Data Privacy performing the Reverse engineering on the Data Model to identifying the Schemas based on requirements.
Gathering the business requirements from the respective application team (Data Architect's / Application Owner's).
Prepared High Level Logical Data Models using Erwin, and later translated the model into physical model using the Forward Engineering technique.
Responsible for defining the key identifiers for each mapping/interface.
Reverse engineered all the Source Database's using Erwin.
Used data analysis techniques to validate business rules and identify low quality missing data in the existing data.
Analyzing the requirement from application team i.e. Sensitive & Personal Information.
Updating the existing data models in all environments.
Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.

Environment: Oracle 11g, SQL Server 2005/2014, DB2, Microsoft Transaction Server, Erwin r9.6.1, MS-SQL server manager, Microsoft Access, SAP BW.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship