We provide IT Staff Augmentation Services!

Data Modeler Resume

St Louis, MO

Professional Summary

Dynamic IT consultant having around 10+ years experience with advanced Analysis, Design and technical knowledge, in the field of Data Warehousing, ETL, Data Analysis and modeling, along with quick adaptability to new technologies seeking challenging position where I can be productive right away

  • Expertise in Analysis, Design, Development, Implementation, Modeling, Testing, and support for Data warehousing & OLAP applications.
  • Expert in Business Intelligence solutions in Data warehousing / Decision Support Systems using ETL tools Informatica, OLAP, OLTP and Data Warehouse Reports using Business Objects, Crystal Reports.
  • Collaborated Cross work stream sessions to give idea on conversion changes from ODS and Data warehouse side.
  • Actively involved in the General Ledger conversion from Wachovia set of Books to Wells Fargo Consolidated GL.
  • Expertise in E-R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling.
  • Expertise in Data Profiling, Data Quality, and Data Governance.
  • Experienced in Data Warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources into data warehouse using Informatica.
  • Expertise in designing Normalized Data Warehouse.
  • Experience in coding using SQL, procedures/functions, triggers and exceptions.
  • Expertise in RALPH KIMBALL star schema methodology.
  • Expertise in conceptual modeling, logical modeling and physical modeling
  • Expertise in deploying OLAP tools, Materialized Views, and partitioning techniques for highly responsive Decision Support Systems
  • Expert in Designing Dimensional Modeling (Star Schemas, Snow flake schema) and Operational Data store (OLTP) Data Warehouse design.
  • Designed Mapping documents ETL architecture documents and specifications.
  • Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment.
  • Involved in system analysis & design of EDW and source system analysis.
  • Designed logical & physical data models with Erwin Tool ,Telelogic tool and Visio
  • Migrated data from different financial modules like AR, AP, GL, CA, FA, BUDGET, PURCHASING AND INVENTORY and HR to Oracle Database.
  • Involved in weekly Bug tracking meetings, Status meetings with the Business analysts to resolve the bugs in the application.
  • Good expertise in gathering requirements, business definition requirements and functional requirements gathering.
  • Expertise in processes research, analysis and documentation.
  • Executed Autosys, UNIX commands and created scripts.
  • Familiarity with Enterprise Architecture Structures Zachman.
  • Having excellent problem solving skills and critical thinking skills.
  • Efficient in all phases of the software development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning, Unit Testing, System Testing, User Acceptance Testing
  • A dedicated team player with excellent communication, organizational and interpersonal skills.




Technical Experience

Languages:

C, C++, JDK1.2, Java Script, TSL, Perl, PL/SQL, COBOL, HTML, and XML

ETL:

Informatica Power Center 8.6.1/8.1/7.1.4/7.1.1/6.0, PowerMart6.2/5.1, MS SQL Server, and SSIS/DTS

DSS:

MS SQL Server Reporting Services, Business Objects XIR2/6.5.1/5.1.8/4.1, SSAS, Web Intelligence, and Crystal Reports

Operating Systems:

MS Windows 2003/2000/NT, Sun Solaris, and Unix

Databases:

MS SQL Server 2008/2005/2000/7.0, Oracle 10g/9i/8i/7.x, DB2, and Teradata

Data Warehousing Methodologies:

Star Schema Design, Snowflake Schema Design, Data Modeling, and Best Practices in Data Warehousing Design and Implementation

Design Tools:

Rational Rose, Erwin7.2/4.0/3.0, IBM Telelogic 11, MS Visio, RUP, and RAD

Testing Tools:

Win Runner 7.5/7.0/6.0/5.0, Load Runner 7.6/7.5/7.0/6.0, Quick Test Professional, and Ardent Data Stage Director

Bug Tracking:

Quality Center 9.2/8.2/8.0//7.8/7.6/6.0, IBM Rational ClearQuest, PVCS Tracker, and Clarify

Professional Experience

Confidential,St. Louis, MO Jul’11-Till date Database Analyst/Data Modeler

Responsibilities:

  • Gathered Business requirements from Application teamsand Involved in JAD sessions with different application teams.
  • Performed Impact Analysis on existing database in order to create Functional System Design documents.
  • Created VISIO diagrams in order to give idea for Business Users and for IT team about existing flow. Also created future state data flow diagrams.
  • Performed Data Profiling by using Informatica Data Explorer.
  • Created Conceptual design as per requirements before designing logical and physical models.
  • Designed logical & physical data models with Erwin Tool.
  • Created Source System Analysis documents, and provided those documents to development team.
  • Worked extensively with the Dev and QA teams to plan and execute the releases.
  • Extensively worked with QA team to resolve the issues.
  • Designed and Implemented Dimensional Data Model to satisfy end users reporting needs.
  • Created Entities, attributes from requirements and established relationships between entities.
  • Worked with different types of Sources like XML files, DB Tables, Flat Files, and Destinations like DB Tables.

Environment: Erwin 7.2,Informatica Power Center 8.6.0, Informatica Data Explorer 8.6, Oracle 10g, DB2, MS Access, Toad for Oracle 9.7.2, Toad for DB2 4.0, Sun OS 5.9, IBM Unix, HP Quality Center 9.2, SecureCRT6.1, SecureFX6.1, XML, MS Office 2007, Windows 2003.

Confidential,Richmond, VA Jan’11- Apr’11 Data Analyst

Responsibilities:

  • Gathered Business requirements from Application teamsand Interviewed Users to understand requirements.
  • Designed an approach to separate intercompany transactions and external transactions for all GL entries in the source system as per requirement.
  • Performed Data Profiling on General Ledger Source system.
  • Created Entities and established relationships between entities.
  • Created Technical Design documents to load both Transactional GL data and Master data in BW Staging model.

Environment: PowerDesigner 15.1, Informatica Power Center 8.1, SAP BW, PECAS, JD Edwards, Oracle 10g, MS Office 2007, Windows XP.

Confidential,St. Louis, MO Jul’09-Jan’11 Database Analyst/Data Modeler

Responsibilities:

  • Gathered Business requirements from Application teamsand Involved in JAD sessions with different application teams.
  • Collaborated Cross work stream sessions to give idea on conversion changes from ODS and Data warehouse side.
  • Designed and implemented a project for General Ledger conversion from Wachovia set of Books to Wells Fargo Consolidated GL.
  • Actively participated in converting Brokerage Data and Bank Data from one system to another system.
  • Designed and implemented a project for assigning Enterprise Customer Number for all Wachovia existing Customers and Wells Fargo Customers.
  • Designed and implemented ECN assignment for all WFI Customers by converting from WFI to WFA.
  • Designed and implemented State By State Conversion for all Wachovia Customers in order to assign ECN.
  • Involved in status meetings with project manager, technical manager and program manager to update the status and understand the future project deadlines and updated that with team members.
  • Interacted with Business Analysts to get the functional requirements.
  • Interacted with end users to finalize reporting needs.
  • Designed and implemented star schema for account balances in order to generate reports for the same.
  • Designed a project to get more interest rates for private bank members based on House hold balance.
  • Identified and designed ODS and BDW changes w.r.t GL conversion project to deliver new data to downstream applications.
  • Gathered accurate data by performing data analysis and functional analysis.
  • Performed Impact Analysis on existing database in order to create Functional Data Requirements and Design documents.
  • Created VISIO diagrams in order to give idea for Business Users and for IT team about existing flow. Also created future state data flow diagrams.
  • Worked extensively with the Dev and QA teams to plan and execute the releases.
  • Extensively worked with QA team to resolve the issues.
  • Validation and loading of the Flat Files received from business users.
  • Performed Data Profiling by using Informatica Data Explorer.
  • Created Conceptual design as per requirements before designing logical and physical models.
  • Designed database with 1NF, 2NF and 3NF.
  • Designed logical & physical data models with Erwin Tool.
  • Designed and Implemented Dimensional Data Model to satisfy end users reporting needs.
  • Created Entities, attributes from requirements and established relationships between entities.
  • Identified business processes and created Fact tables for respective business processes.
  • Created Aggregate Fact tables, history fact tables and type II dimensions.
  • Created end of month fact tables and maintained history for these EOM fact tables.
  • Created views on top of fact tables and dimension tables.
  • Created source to target mappings, transformation logic and data dictionary.
  • Written data model definitions and metadata.
  • Reviewed Data Model with functional team and technical team for accuracy.
  • Created DDL scripts from Data Model and co-ordinate with DBA to execute in the data base.
  • Created Technical Documents to tweak ETL mappings for respective Data Marts.
  • Interacted with data transformation teams to ensure design is properly communicated.
  • Implemented Ralph Kimball star schema approach with OLAP multi dimensional model.
  • Defined Enterprise data warehouse (EDW) best practices for ETL methodologies and BI practices.
  • Actively participated in converting Brokerage data and bank data from one system to another system.
  • Identified hierarchies in source database to build Dimensions in the Presentation Layer
  • Consolidated data from different sources like Oracle, Flat Files to Oracle data warehouse.
  • Involved in Developing complex Informatica mappings to facilitate daily, weekly, monthly and One time loading of data into data warehouse.
  • Worked with different types of Sources like DB Tables source, Flat File Source, Excel Source and Destinations like DB Tables.
  • Involved in Creating mappings using Expression, Joiner, Aggregate, Lookup, Sequence Generator, Source Qualifier, Update Strategy and Router Transformations.
  • Involved in Developing Informatica mappings and also tuned mappings for improving performance
  • Involved in Creating reusable Transformations and mapplets to use in mappings.
  • Used Work flow Manager to create database connections.
  • Conducted UAT training sessions for end users & mentoring other peers

Environment: Erwin 7.2, Informatica Power Center 8.6.0, Informatica Data Explorer 8.6, Oracle 10g, DB2, MS Access, Toad for Oracle 9.7.2, Toad for DB2 4.0, Sun OS 5.9, IBM Unix, HP Quality Center 9.2, SecureCRT6.1, SecureFX6.1, XML, MS Office 2007, Windows 2003.

Confidential,Boise, ID Apr’08-Jun’09
Data Analyst/ Data Modeler

Responsibilities:

  • Gathered and analyzed requirements from end users and identified various data sources and created technical specification documents.
  • Conducted sessions with business user to understand business rules and data structures.
  • Prepared Functional Data requirements and Design documents as per the business requirements.
  • Interacted with end users to finalize reporting needs.
  • Implemented Ralph Kimball star schema approach with OLAP multi dimensional model.
  • Defined Enterprise data warehouse (EDW) best practices for ETL methodologies and BI practices.
  • Designed normalized database.
  • Designed data marts for different financial modules like AR, AP, GL, CA, FA, BUDGET, PURCHASING AND INVENTORY for reporting purposes.
  • Created Fact Qualifier Matrix as per the business requirements to support Logical Model.
  • Performed Impact Analysis on existing database in order to create Functional Data Requirements and Design documents.
  • Designed Data Marts from OLTP system in order to give different financial reports for GL, AP, AR, CA and FA as per requirements.
  • Created VISIO diagrams in order to give idea for Business Users and for IT team about existing flow . Also created future state data flow diagrams.
  • Created Conceptual design as per requirements before designing logical and physical models.
  • Designed logical & physical data models with Erwin Tool.
  • Designed and Implemented Dimensional Data Model to satisfy end users reporting needs.
  • Created Entities, attributes from requirements and established relationships between entities.
  • Identified business processes and created Fact tables for respective business processes.
  • Created Aggregate Fact tables, history fact tables and type II dimensions.
  • Created source to target mappings, transformation logic and data dictionary.
  • Written data model definitions and metadata.
  • Reviewed Data Model with functional team and technical team for accuracy.
  • Created DDL scripts from Data Model and co-ordinate with DBA to execute in the data base.
  • Created Technical Documents to tweak ETL mappings for respective Data Marts.
  • Interacted with data transformation teams to ensure design is properly communicated.
  • Implemented Ralph Kimball star schema approach with OLAP multi dimensional model.
  • Created Source System Analysis documents for ETL developers to create mappings.
  • Identified hierarchies in source database to build Dimensions in the Presentation Layer
  • Consolidated data from different sources like Oracle, Flat Files to Oracle data warehouse.
  • Validation and loading of the Flat Files received from business users.
  • Validated data in Integration testing and helped to users in user acceptance testing.
  • Actively participated in resolving issues for Integration testing
  • Implemented Data Security in Business Objects.
  • Involved in Developing complex Informatica mappings to facilitate daily, monthly and yearly loading of data into data warehouse.
  • Worked with different types of Sources like DB Tables source, Flat File Source, Excel Source and Destinations like DB Tables.
  • Involved in writing Master Test Plan as per Functional Data Requirements and also involved in writing Test Plan and individual Test Cases for each detailed requirement.
  • Involved in Creating reusable Transformations and mapplets to use in mappings.
  • Created a new universe based on the new reporting requirements
  • Created Hierarchies to facilitate drill-down in the Desktop Intelligence reports
  • Created and maintained Business Objects Web Intelligence reports.
  • Built Cross Tab reports
  • Concierge Project involved the study and analysis of the required data and pooling up different data from three different data warehouses for the sake of building up a common universe
  • Created pre-defined conditions and universe level prompts making it easy for business users to utilize these objects
  • Utilized different features in the reports like report level filters, conditions, alerters, rank, sorts, slice & dice, drill down, formulae & variables etc.
  • Resolved performance issues in reports by recommending alternatives
  • Created complex objects in the universe to capture the business logic
  • Created reports using different data providers like universe, free hand SQL, stored procedures and personal data files
  • Optimized the usage of user objects, conditions and universe level filters
  • Followed the Business Objects Best practices in creating reports & universe.
  • Unit Testing is done for the developed reports.
  • Conducted UAT training sessions for end users & mentoring other peers

Environment: Informatica Power Center 8.1, T-SQL, OLAP Services, Business Objects XIR2, Oracle 10g, Toad, ActiveX, ADO.NET, XML, VB.Net, VB script, Windows 2003,IBM Telelogic 11,Unix.

Confidential,Charlotte Jul’07 – Feb’08 Sr. Data Analyst/ Data Modeler

Responsibilities:

  • Performed analysis / reverse engineering of the current application and preparation of mapping documents.
  • Analyzed requirements from end users and identified various data sources and created technical specification documents.
  • Conducted sessions with business user to understand business rules and data structures.
  • Involved in analyzing the current code, extract the business rules and implement them in the ETL model.
  • Performed analyzing of Business and System requirements.
  • Designed Normalized database.
  • Implemented INMON’S approach for DWH.
  • Designed logical & physical data models with Erwin Tool.
  • Designed staging area and populated from different sources after data cleansing.
  • Designed slowly Changing dimensions as per business needs.
  • Created DDL and SQL scripts and interacted with DBA to execute DDL scripts in the database.
  • Designed and Implemented Dimensional Data Model to satisfy end users reporting needs.
  • Created Entities, attributes from requirements and established relationships between entities.
  • Identified business processes and created Fact tables for respective business processes.
  • Created Aggregate Fact tables, history fact tables and type II dimensions.
  • Created end of month fact tables and maintained history for these EOM fact tables.
  • Created views on top of fact tables and dimension tables.
  • Created source to target mappings, transformation logic and data dictionary.
  • Written data model definitions and metadata..
  • Designed ETL technical specifications Document based on the BRD provided by Sr. Analysts.
  • Performed validation and loading of the Flat Files received from business users
  • Migrated data from Mainframe Flat files to Oracle Data Warehouse
  • Worked with different types of Sources like DB Tables source, Flat File Source, Excel Source and Destinations like DB Tables.
  • Identified hierarchies in source database to build Dimensions in the Presentation Layer
  • Consolidated data from different sources like Oracle, Flat Files to Oracle data warehouse.
  • Validation and loading of the Flat Files received from business users
  • Involved in creating Test Plan and Test cases for integration testing
  • Validated data in Integration testing and helped to users in user acceptance testing.
  • Actively participated in resolving issues for Integration testing
Created Stored Procedures, SQL scripts and calling them at pre and post session. Implemented various performance tuning techniques for improving the performance of the application Involved in writing UNIX scripts Involved in writing sql queries to validate the data between source and target systems
  • Used Informatica Debugger to validate maps and to gain trouble shooting information about data and error conditions.
Involved in mapping migration, metadata management and Security using repository manager Responsible as a team member for deploying the ETL governance and best practices Worked extensively with the release team to plan and execute the releases. Setup folders, groups, users, permissions and performed Repository administration using Repository Manager
  • Used multiple data bases to create reports.
  • Mentored other developers & peers for technical & application specifications.
  • Created reports using store procedures and data base triggers as data sources.
  • Provide 24 X 7 supports to all production, development Test Environments.

Environment: Informatica 7.1.4, Cognos, Erwin 3.5.2, Oracle 10g, Toad, DB2, Active X, VB script, ASP.NET, MS Access, Microsoft Source safe, Windows 2003,Unix

Confidential,CA Apr’04- May‘07
Data Analyst/ Data Modeler

Responsibilities:

  • Conducted sessions with business user to understand business rules and data structure
  • Designed conceptual model, logical model and physical model to satisfy business needs.
  • Designed OLAP data models with star schema Ralph Kimball approach
  • Creating tables, relationships, triggers and indexes for enforcing business rules.
  • Designed and Implemented Dimensional Data Model to satisfy end users reporting needs.
  • Created Bus Matrix to develop a logical model.
  • Created Entities, attributes from requirements and established relationships between entities.
  • Identified business processes and created Fact tables for respective business processes.
  • Created Aggregate Fact tables, history fact tables and type II dimensions.
  • Designed and created end of month fact tables and maintained history for these EOM fact tables.
  • Created views for application teams.
  • Created indexes for respective columns in both dimensions and fact tables.
  • Created source to target mappings, transformation logic and data dictionary.
  • Written data model definitions and metadata.
  • Using SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
  • Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment.
  • Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Expression, Filter, Lookup, Source Qualifier and Aggregator transformations Developed process workflow to maintain the dependency between the jobs
  • Configured product meta-data tables to support client data reporting needs.
  • Defined visual basic interface for automation of loading data from XML files
  • Created SQL reports, data extraction and data loading scripts for different databases and schemas.
  • Architected approaches for Speed Loads and Incremental load
  • Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.
  • Daily support, troubleshooting, monitoring, optimization and tuning of server environments across entire system.
  • Extracted source definitions from the database into the Informatica Power Center repository.
  • Created mappings using Filter, Aggregator, Expression, Join, Union, lookup, Update Strategy, Stored procedure, Sorter transformations.
  • Used Informatica Debugger to validate maps and to gain trouble shooting information about data and error conditions.
  • Used Work flow Manager to create database connections.
  • Used Work flow Manager to create, execute and monitor sessions.
  • Created Workflows and run Workflows using Workflow Manager.
  • Monitored the data loads using Workflow monitor.
  • Involved in the installation, configuration of Informatica.
  • Unit Testing is done for the mappings in the project.

Environment: Informatica 7.1.1, Business Objects 6.5.1, Oracle9i, Toad, SQL Server 2000, T-SQL, Teradata, Java, J2EE, Active X, VB.Net, ASP, visual basic, Windows 2003, Unix, Erwin 3.0

Confidential,NJ Jan’02-Mar’04
DW/BI Consultant

Responsibilities:

  • Involved in designing of Conceptual Logical Model and Physical Model.
  • Involved in OLAP Data modeling to develop the database design using Erwin
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Created SQL reports, data extraction and data loading scripts for different databases and schemas.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
Created Informatica mappings with various transformations to build business rules to load the data Various transformations such as expression, filter, aggregator, lookup and sequence generator transformations were used to handle situations depending on the requirement. Worked on various files such as Excel files and Flat files at source Responsible for loading type1 and type2 dimensions Created Mapplets and reusable transformations to be re-used in the Informatica mappings Responsible to tune ETL procedures and STAR schema to optimize load and query Performance
  • Performed all aspects of database administration, including data modeling, backups andrecovery.
  • Used Informatica Debugger to validate maps and to gain trouble shooting information about data and error conditions.
  • Involved in mapping migration, metadata management and Security using repository manager
  • Responsible as a team member for deploying the ETL governance and best practices
  • Worked extensively with the release team to plan and execute the releases.
  • Setup folders, groups, users, permissions and performed Repository administration using Repository Manager
  • Performed Unit Testing and System testing.
  • Created and Modified Reports using Business Objects.
  • Created complex reports using Business Objects functionality like Table, Cross Tab and Ranking were used in reports.

Environment: Informatica 6.0, Business Objects 5.1.8, Oracle 8i, T-SQL, OLAP, SQL Server, Erwin 3.0, CVS, Windows NT/2000/XP, UNIX.

Education

Masters in Science
Post Graduation Diploma in Software Engineering

Hire Now