We provide IT Staff Augmentation Services!

Sr. Data Modeler/analyst Resume Profile

Buffalo Grove, IL

Summary:

  • 8 years of excellent experience as a Data Analyst and Data Modeler plus experienced in database management, strategic analysis, requirements gathering, application and decision support, which plays a key role in software development life cycle SDLC .
  • Excellent in system analysis, ER Dimensional Modeling, Database design and implementing RDBMS specific features.
  • Experience in modeling with both OLTP/OLAP systems and Kimball and Inmon Data Warehousing environments.
  • Experience in Dimensional Data Modeling experience using Data modeling, Relational Data modeling, ER/Studio, Erwin, and Sybase Power Designer, Star Join Schema/Snowflake modeling, FACT Dimensions tables, Conceptual, Physical logical data modeling.
  • Highly proficient in Data Modeling retaining concepts of RDBMS, Logical and Physical Data Modeling until 3NormalForm 3NF and Multidimensional Data Modeling Schema Star schema, Snow-Flake Modeling, Facts and dimensions . Complete knowledge of datawarehouse
  • Managed full SDLC processes involving requirements management, workflow analysis, source data analysis, data mapping, metadata management, data quality, testing strategy and maintenance of the model.
  • Proficient in Software Development Life Cycle SDLC , Project Management methodologies, and Microsoft SQL Server database management.
  • Experience in developing Entity-Relationship diagrams and modeling Transactional Databases and Data Warehouse using tools like Erwin, ER/Studio and Power Designer.
  • Expert in the Data Analysis, Design, Development, Implementation and Testing using Data Conversions, Extraction, Transformation and Loading ETL and SQL Server, ORACLE and other relational and non-relational databases.
  • Experience in logical/physical database design and review sessions to determine and describe data flow and data mapping from source to target databases coordinating with End Users, Business Analysts, DBAs and Application Architects.
  • Extensive experience with Normalization 1NF, 2NF, 3NF and BCNF and De-normalization techniques for improved database performance in OLTP and Data Warehouse/Data Mart environments.
  • Expert in developing transactional enterprise data models that strictly meet normalization rules, as well as Enterprise Data Warehouses using Kimball and Inmon Data Warehouse methodologies.
  • Extensive experience in using ER modeling tools such as Erwin and ER/Studio.
  • Excellent experience in troubleshooting test scripts, SQL queries, ETL jobs, data warehouse/data mart/data store models.
  • Excellent experience in writing SQL queries to validate data movement between different layers in data warehouse environment.
  • Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.
  • An excellent team player technically strong person who has capability to work with business users, project managers, team leads, architects and peers, thus maintaining healthy environment in the project.

Technical Skills:

  • Analysis and Modeling Tools: ERwin 7.2/7.0, 8.0, r9, Sybase Power Designer, Oracle Designer, BPwin, Rational Rose, ER/Studio, MS Visio
  • ETL Tools: Informatica Power Center 9.5/8.6.1/8.1/7.1, Data Stage 7.5, Ab Initio, Talend
  • OLAP Tools: MS SQL Analysis Manager, DB2 OLAP, CognosPowerplay
  • Languages: SQL, PL/SQL, T-SQL, XML, HTML, UNIX Shell Scripting, C, C , AWK
  • Databases: MS SQL Server 2008/2005/2000, Oracle11g/10g/9i/8i, DB2 V9.5, Teradata V2R6.1, MS Access 2000
  • Operating Systems: Windows XP/2000/98, UNIX Sun Solaris 10
  • Project Execution Methodologies: Ralph Kimball and Bill Inmon data warehousing methodology, Rational Unified Process RUP , Rapid Application Development RAD , Joint Application Development JAD
  • Tools Software: TOAD, MS Office, BTEQ, Teradata SQL Assistant
  • Tools: MS-Office suite Word, Excel, MS Project and Outlook , VSS

Work Summary

Confidential

Sr. Data Modeler/Analyst

Responsibilities

  • Worked on discovering entities, attributes, relationships and business rules from functional requirements
  • Used Erwin R9.0, created Conceptual, Logical and Physical data models.
  • 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
  • Designed both 3NF data models for ODS, OLTP systems and dimensional data models using star and snow flake Schemas
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
  • Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects
  • Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, SQL Server 2005 with high volume data
  • Responsible for analyzing various data sources such as flat files, ASCIIData, EBCDIC Data, Relational Data Oracle, DB2 UDB, MS SQL Server from various heterogeneous data sources.
  • Involved in Teradata SQL Development, Unit Testing and Performance Tuning and to ensure testing issues are resolved on the basis of using defect reports.
  • Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
  • Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Data Oracle, DB2 UDB, MS SQL Server from various heterogeneous data sources.
  • Preparation of various test documents for ETL process in Quality Center.
  • Created and executed test cases for ETL jobs to upload master data to repository.
  • Modified the automated scripts from time to time to accommodate the changes/upgrades in the application interface.
  • Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.

Environment: Informatica9.5, Business Objects, SQL, Teradata R14.10 MLOAD, FLOAD, FAST EXPORT, BTEQ , TeradataSQL Assistant 14, Toad, UNIX, Shell Scripting, TP 9.2, Test Director 7.x, Load Runner 7.0, Oracle 10g, UNIX AIX 5.2, PERL, Shell Scripting

Confidential

Sr. Data Modeler

Responsibilities:

  • Analyzed the business requirements by dividing them into subject areas and understood the data flow within the organization
  • Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports inHTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, co-coordinated with DBAs' to apply the data model changes.
  • Generated a separate MRM document with each assignment and shared it on SharePoint along with the PDF of updated data models
  • Created a list of domains in Erwin and worked on building up the data dictionary for the company
  • Created a Data Mapping document after each assignment and wrote the transformation rules for each field as applicable
  • Worked on Unit Testing for three reports and created SQL Test Scripts for each report as required
  • 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.
  • Worked on Metadata Repository MRM for maintaining the definitions and mapping rules up to mark
  • Used Graphical Entity-Relationship Diagramming to create new database design via easy to use, graphical interface.
  • 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

Environment: ER Studio 9.1.0, Teradata, Netezza, EMC Greenplum, Oracle RAC 11g, IBM DB2, Business Objects XI 3.1,DbVisualizer 8.0.10, PDM, SAP, JD Edwards, Teradata 13.10

Confidential

Data Analyst / Data Modeler

Responsibilities

  • Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
  • Used Erwin r7.3 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
  • Involved in the creation, maintenance of Data Warehouse and repositories containing Metadata.
  • Involved in the study of the business logic and understanding the physical system and the terms and condition for database.
  • Responsible as a member of development team to provide business data requirements analysis services, producing Logical and Physical data models using Power Designer 12.0.
  • Worked with DBAgroup to create Best-Fit Physical Data Model from the Logical Data Model using Forward Engineering.
  • Developed Data Migration and Cleansing rules for the Integration Architecture OLTP, ODS, DW
  • Created documentation and test cases, worked with users for new module enhancements and testing.
  • Analyzed the Business information requirements and examined the OLAP source systems to identify the measures, dimensions and facts required for the reports.
  • Utilized Power Designer's forward/reverse engineering tools and target database schema conversion process.
  • Documented logical, physical, relational and dimensional data models. Designed the data marts in dimensional data modeling using star and snowflake schemas.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects.
  • Used Data Stage Manager for importing metadata from repository, new job categories and creating new data elements.
  • Developing reusable objects like PL/SQL program units and libraries, database procedures and functions, database triggers to be used by the team and satisfying the business rules
  • Written Procedures and Functions using Dynamic SQL and written complex SQL queries using joins, sub queries and correlated sub queries.
  • Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD Object oriented Design using UML and Visio.

Environment:PowerDesigner, Oracle10g, SQL server, MS Excel, MS Visio, Rational Rose, Requisite Pro, Rational, Oracle 8i, Windows XP, PL/SQL, , Sql Server, MS Office, MS Access, MS Visio.

Confidential

Data Analyst / Data Modeler

Responsibilities

  • Part of the team responsible for the analysis, design and implementation of the business solution.
  • Developed the logical data models and physical data models that capture current state/future state data elements and data flows using ER Studio.
  • Translate business requirements into conceptual, logical data models and integration data models, model databases for integration applications in a highly available and performance configuration using ER/Studio.
  • Reverse Engineered DB2 databases and then forward engineered them to Teradata using ER Studio.
  • Extensively used Normalization techniques up to 3NF .
  • Responsible for data modeling and building a star schema model in ER Studio.
  • Responsible for physical modeling per database and performance requirements.
  • Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic.
  • Create and deploy reports using SSRS.
  • Designed the physical model for implementing the model into oracle 10g physical data base.
  • Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
  • Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges.
  • Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis.
  • Handled performance requirements for databases in OLTP and OLAP models.
  • Worked with ad-hoc reporting using Crystal Reports 9 and T-SQL.

Environment: Erwin r9, SQL Server 2008, SQL Server Analysis Services 2008, SSIS 2008, SSRS 2008, Oracle 10g, Business Objects XI, Rational Rose, Data stage, MS Office, MS Visio

Confidential

Data Analyst / Data Modeler

Responsibilities

  • Involved in creating Physical and Logical models using Erwin.
  • Created and maintained Database Objects Tables, Views, Indexes, Partitions, Synonyms, Databasetriggers, StoredProcedures in the data model.
  • Worked on building the data model using ER Studio as per the requirements, discussion and approval of the model from the BA.
  • Provided subject matter expertise as appropriate to ETL requirements, information analytics, modeling design, development, and support activities.
  • Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
  • Worked on Data Quality Framework design, logical physical model and architecture.
  • Worked with Data Warehouse Extract and load developers to design mappings for Data Capture, Staging, Cleansing, Loading, and Auditing.
  • Developed, enhanced and maintained Snow Flakes and Star Schemas within data warehouse and data mart conceptual logical data models.
  • Communicated data needs internally and externally to 3rd parties. Analyzed and understood the data options and documented data dictionary.
  • Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
  • Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
  • Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
  • In depth analyses of data report was prepared weekly, biweekly, monthly using MS Excel, SQL UNIX.
  • Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
  • Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.

Environment: Oracle, Erwin 9x, DB2, Information Analyzer, Informatica, MDM, Quality centre, Excel, MS-Word, ETL Tools Informatica

Hire Now