Data Modeler/analyst Resume
Aurora, IL
SUMMARY
- 7 yearsof professional IT experience in Data Analysis/Modelingfor Online Transactional processing (OLTP)and Online Analytical Processing (OLAP)systems in Insurance, banking, Retail Domains.
- Extensive experience inRelationalData Modeling, Dimensional Data Modeling, Logical/Physical Design, ER Diagrams,Forward and Reverse Engineering ERWIN diagrams, analyzing data sources and creating interface documents.
- Proficient in System Analysis, ER/DimensionalDataModeling, Database design and implementing RDBMS specific features.
- Experience in understanding the business needsandgathering user requirements by conducting and participating in JAD sessions, interacting with end - users and training them on the applications developed for the organization.
- Experience in data analysis and responsible for collecting, preparing and cleaning data before or after it is collected in a database.
- Experience in Dimensional Modeling using Star and Snowflake schema methodologies of Data Warehouse and Integration projects.
- Extensively worked on ERWIN tool with all features like REVERSE Engineering, FORWARD Engineering, SUBJECT AREA, DOMAIN, Naming Standards Document etc.
- Experience withBusiness Process Modeling, Process Flow Modeling, Data flow modeling.
- Worked with ETL processes to transfer/migrate data from relational database and flat files common staging tables in various formats to meaningful data in Oracle and MS-SQL.
- Performed extensive data cleansing, data manipulations and date transforms and data auditing.
- Experience in usingOracle, SQL*PLUS,SQL*Loader,TOAD,Win NT/2003.
- Developed database objects like PL/SQL packages, Oracle tables, TSQL stored procedures, triggers that are used for meeting the business objectives.
- Developed Data dictionary and maintained Metadata for each model.
- Good knowledge in developing and designing reports throughSSRSandExcel
- Coordinated with other developers in tuning long running SQL queries to enhance system performance.
- Involved in debugging and developing exception-handling procedures whenever required.
- Strong in conceptualizing and communicating enterprise data architecture frameworks for global enterprises for inter operation of data warehouses, middleware, and web applications.
- Good documentation skills and was involved in making functional and technical documentation.
- A strong team member with good Communication and Analytical skills.
TECHNICAL SKILLS
Data Modeling Tools: Erwin, Power designer, ER Studio
Reporting Tools: Tableau, SQL Server Reporting Services (SSRS), Business Objects, Qlikview
Programming Languages: SQL, TSQL, PL/SQL, UNIX shell Scripting, PERL
Databases: Oracle, SQL Server, MS-SQL, MS-Access
PROFESSIONAL EXPERIENCE
Confidential, Aurora, IL
Data Modeler/Analyst
Responsibilities:
- Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
- Involved in the redesign of the existing OLTP system.
- Worked with ACORD XSD schema to generate WSDL’s for services to avoid point to point integration.
- Worked with a design team to map data model to an xml file format used by Acord framework.
- Created canonical consenting XSD schemas for operations using ICS.
- Acted as a Strong Data Analyst analyzing the data from low level.
- Worked with DBAs to recreate a best-fit physical data model from the logical data model. Performed logical and physical data modeling with Erwin and Model Manager.
- Performed Data modeling using Erwin. Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using the forward engineering Erwin tool.
- Created databases, tables, views & schemas. Performed users access authorization, defined locations, populated tables with data and performed unload/copy/replicate data from one database into another after detail analysis and design.
- Involved in the Database design and application development to support the creation and management of online business units for business users and customers usage.
- Used Erwin to transform data requirements into data models.
- Reverse Engineer the existing Stored Procedures and write Mapping Documents for them.
- Worked on defining deadlines and helped team to meet the deadlines.
- Extensively worked on documentation of Data Model, Mapping documents and Scheduling jobs.
- Deployed naming standard to the Data Model and followed company standard for Project Documentation.
- Involved in extensive Analysis on the Teradata Systems.
- Helped in migration and conversion of data from legacy system to oracle database.
- Widely used Normalization methods and have done different normalizations (3NF).
- Worked widely on data analysis querying and writing in SQL and TOAD.
- Analyzed the performance of the jobs during the project. Utilized standard techniques for enhancing the performance.
- Performed tuning of SQL Queries to improve the response time.
Environment: Erwin, oracle 11g,IgniteXML Organizer, Ignite XML Consumer Service(ICS), Teradata SQL Assistant, SQL, TSQL, PL/SQL, TOAD, SQL * LOADER, UNIX, MS OFFICE.
Confidential, Columbus, OH
Data Modeler/Analyst
Responsibilities:
- Gathered and translated business requirements into detailed,production-leveltechnical 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.
- Involved in the redesign of the existing OLTP system.
- Acted as a strong Data Analyst analyzing the data from low level.
- Performed Data modeling using TOAD Data Modeler. Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using forward engineering TOAD Data Modeler tool.
- Responsible for creating the staging tables and source to target mapping documents for the ETL process.
- Created Indexes and capacity planning and worked closely with DBAs.
- Created data models for OLTP systems.
- Widely used Normalization methods and have done different normalizations (3NF).
- Ensured production data being replicated into the ODS and the Data Warehouse without any data anomalies from the processing databases.
- Extensively used SharePoint for version controlling.
- Developed test plans and test cases for QA Unit Testing, System Testing and Enterprise testing.
- Prepared documentation for the analysis done and extensively used MS Office to prepare presentations.
- Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/ columns as part of Data Analysis responsibilities.
Environment: Oracle 11g, TOAD Data Modeler, Informatica 9.1, Cognos 8.3 and Linux Server
Confidential, Dayton, OH
Data modeler
Responsibilities:
- Participated in all phases of project including Requirement gathering, Analysis, Design, Coding, Testing, Documentation and warranty period.
- Extensively used SQL for Data Analysis and to understand the data behavior.
- Done Reverse engineering on existing data model to understand the data flow and business flows of existing systems and to integrate the new requirements to current system.
- Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and convert them to physical data model including capacity planning, object creation and aggregation strategies, partition strategies, Purging strategies as per business requirements.
- Conducted team meetings and proposed ETL strategy.
- Worked on Gap Analysis.
- Data analysis of existing data base to understand the data flow and business rule applied to different data bases by SQL
- Conducted meetings with the business and technical team to gather necessary analytical data requirements in JAD sessions.
- Partitioned tables based on the requirement and developed purging and archival rules.
- Designed and Developed strategies for Data Conversions and Data Cleansing
- Creating Mappings, Tech Design, loading strategies for ETL to load newly created or existing tables.
- UsedSSISto createETLpackages to validate, extract, transform and load data to data warehouse and data marts
- Created Schema objects like Indexes, Views, and Sequences, triggers, grants, roles, Snapshots.
- Pre populate the static tables in the Data warehouse.
- Developed strategies and loading techniques for better loading and faster query performance.
- Designed the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
- Extensively used ETL to load data from flat files (excel/access) to Oracle database from different Vendors and external source systems.
- Worked on defining deadlines and helped team to meet the deadlines.
- Extensively worked on documentation of Data Model, Mapping, Transformations and Scheduling jobs.
- Worked extensively with Micro strategy Report developers in creating data marts and develop reports
- Designed Mapping Documents and Mapping Templates for Data Stage ETL developer.
- Deployed naming standard to the Data Models at enterprise level and followed company standard for Project Documentation.
Environment: Erwin 7.2 (Data Modeling, ER Diagrams), Data stage 8.1/6.0, Micro Strategy, SAS, Oracle 11i/10G, Microsoft Outlook, AIX, SSIS
Confidential
Data Analyst
Responsibilities:
- Analyzed Data sources and requirements and business rules to perform logical and physical Data Modeling
- Played an active role as a member of Project team to provide business data requirements analysis services, producing conceptual and logical data models
- Designed the DataMarts using RalpfKimball's dimensional datamart modelling methodologies using ERWIN
- Worked with the DBA to convert logical Data models to physical Data models for implementation
- Created database objects like Tables, Stored Procedures, Indexes, Sequences, Views, Rules etc.
- Developed SQL Queries to fetch complexdatafrom different tables in remote databases using joins, database links and Bulk collects.
- Participated in JAD sessions to resolve critical issues
- Created aDataMapping document after each assignment and wrote the transformation rules for each field as applicable
Environment: Erwin 7.2, PL/SQL, MS Visio, MS Excel, Oracle 9i
Confidential
Data Analyst
Responsibilities:
- Analyzed the business requirements of the project by studying the Business Requirement Specification document.
- Created a logical design and physical design in Erwin.
- Created ftp connections, database connections for the sources and targets.
- Maintained security and data integrity of the database.
- Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
- Involved in database development by creating Oracle PL/SQL Functions, Procedures and Collections.
- Worked extensively with XML schema generation.
- Extensively used Erwin for developing data model using star schema methodologies.
- Created Unix Shell Scripts for automating the execution process.
- Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for the new programs.
Environment: Erwin, MS Excel, Oracle 10g, SQL, PL/SQL, MS VISIO, SQL*Loader and UNIX.
