We provide IT Staff Augmentation Services!

Sr. Data Modeler/ Analyst Resume

Rahway New, JerseY


  • Over 6+ years of extensive experience in Software Development including Data Analysis and Data Modeling for Online Transaction Processing (OLTP) and Online Analysis Processing(OLAP) systems.
  • Experienced in Design, Development, Testing and Maintenance of various Data Warehousing and Business Intelligence (BI) applications in complex business environments.
  • Well versed in Conceptual, Logical/Physical, Relational and Multi - dimensional modeling, Data analysis for Decision Support Systems (DSS), Data Transformation (ETL) and Reporting.
  • Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and expert in modeling Transactional Databases and Data Warehouse.
  • Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Data Profiling, Data Mapping, Performance Tuning and System Testing.
  • Proficient in Normalization/De-normalization techniques in relational/dimensional database environments and have done normalizations up to 3NF.
  • Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions, creation of cubes.
  • Extensive experience in High/ Low level ETL design, development and testing of DataStage ETL jobs using Data stage 8.1.
  • Worked on scheduling tool Control - M, various issue tracking tools and have effective knowledge on CASE tools like ERWIN and Embarcadero ER/Studio.
  • Sound Knowledge on UNIX Shell scripting (Bourne Shell, CSH, KSH and Bash).
  • Hands on experience in SQL, PLSQL programming, performed End-to-End ETL validations and supported Ad-hoc business requests. Developed Stored Procedures and Triggers and extensively used Quest tools like TOAD.
  • Experience on Performance Tuning for Oracle RDBMS using Explain Plan and TKprofutility and well versed with query optimization techniques in transactional and data warehouse environments.
  • Worked on Autosys Job Scheduler to automate/schedule ETL jobs, testing methodology, build and deployment.
  • Proficient in building Reports using standard industry Reporting tools, and Business Objects.
  • Strong Database experience using Oracle 10g/9i, DB2, Sybase, Teradata, PL/SQL, Stored Procedures, triggers and cursors.
  • Experience with Teradata utilities such as Fast Export, MLOAD for handling various tasks.
  • Good understanding of Ralph Kimball (Dimensional) & Bill Inmon (Relational) model Methodologies.
  • Possess excellent analytical, communication skills with clear understanding of business process flow and SDLC. Quick starter with ability to master and apply new concepts. Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.


Programming Languages: : SQL, PL\SQL (Triggers, Stored Procedures and Functions, Packages), C, C++, .NET, MATLAB.

ETL Tools: Ab Initio & SSIS, Data Profiler, EME, Data Stage SQL Server, DTS/Integration Services, SQL*Loader, Informatica Power Center /Power Mart, Power designer

Analysis/ Modeling Tools: Erwin, MS Visio, Sybase Designer, ER Studio Software Architect, Embarcadero DT/Studio, Power Designer

Utilities: SQL*Plus, SQL*Loader, Import/Export, Performance Tuning

Scripting: UNIX Scripting (SH, CSH, KSH, BASH)

Operating System: Mainframes, Windows Vista, UNIX, Sun Solaris, AIX

Web Development Tools: HTML, DHTML, XML, PHP, Java Script, Dreamweaver.

Tools: XML, TOAD, MS Office Tools.


Confidential, Rahway,New jersey

Sr. Data Modeler/ Analyst


  • Interacted with the end users to understand the business requirement and identified data sources. Involved in regular interactions with Business Analysts and participated in data modeling JAD sessions.
  • Worked on the Business requirement documents, involved in the development of Logical data model from the business requirement using the power designer. Also, worked with the team in the generation of Physical data model.
  • Performed data analysis and profiling of source data to better understand the data sources.
  • Designing and implementing data warehouses and data marts using components of Kimball Methodology, like Data Warehouse Bus, Conformed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema, etc.
  • Created 3 NF business area data modeling with de-normalized physical implementation.
  • Actively participated in creation of E/R Diagrams, Data Flow Diagrams. Worked on Grouping and creation of tables, validating data and identification of PK/ FK for lookup tables.
  • Implemented Star Schema methodologies in modeling and designing the logical data model into Dimensional Models.
  • Worked on creation of metadata collection and validation using 3NF; ODS schema maintenance; database-to-database data type.
  • Reverse Engineered DB2 databases and then forward engineered them to Teradata using Erwin.
  • Designed Informatica mappings, enabling the extract, transform and loading of the data into target tables.
  • Involved in non-transactional data entities of Master Data Management of the organization to provide processes for collecting, aggregating, matching, consolidating, quality-assurance, persistence and distribution.
  • Worked on attributes and relationships in the reverse engineered model to remove unwanted tables and columns.
  • Developed rule sets for data cleansing and actively participated in data cleansing and anomaly resolution of the legacy application.
  • Developed the Data warehouse model (Kimball’s) with several data marts and conformed dimensions for the proposed model in the Project.
  • Worked in conjunction with Database Administrators (DBAs) to finalize the physical properties of the tables including Partition key.
  • Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories.
  • Worked on generating the scripts by analyzing the data from different sources and created corresponding records for DBAs using Informatica.
  • Exposure to implementing Extraction mapping in Informatica (Mapping Designer).
  • Developed a number of Data correction scripts using PL/SQL to handle any manual adjustments/corrections in System.
  • Created DDL scripts for static dimensions and data model for the star schema using Erwin.
  • Involved in review of data model and design to monitor the data model changes and system design across Enterprise Data Warehouse.
  • Facilitated several UAT sessions to ensure the functionality.

Environment: Erwin r9.6, Teradata 12.0, Teradata SQL Assistant 6.1, Oracle 10G/ 9I, DB2 7.1, Business Objects, Crystal Reports /11, MS Visual Studio 2008, XML, HTML.

Confidential, Newark, NJ

Data Modeler/ Data Analyst


  • Involved in gathering business requirements by conducting a series of meetings with the business users
  • Worked on translating the business requirements into detailed, production-level technical specifications.
  • Worked on Conceptual, Logical Modeling and Physical Database design for OLTP and OLAP systems.
  • Worked closely with stakeholders in the project to create the best fit data model.
  • Used Erwin and Model Manager to perform logical and physical data modeling.
  • Involved in the review of the conceptual model for the EDW (Enterprise Data Warehouse).
  • Worked on identifying the objects and relationships and ensured that all fit together as logical entities. Used forward engineering in ERWIN tool to create physical design.
  • Worked on developing Database; Created tables, views & schemas, user’s access authorization and defined locations.
  • Performed unload/copy/replicate data between databases after the detail analysis and design.
  • Oversaw implementation of Business Intelligence environment including Data Marts following the Kimball methodology (multi-dimensional, star schema), and analytical reports .
  • Involved in extensive analysis on the Teradata and Oracle Systems.
  • Participated in migration and conversion of data from legacy system to oracle database.
  • Normalized the database based on the new model developed to put them into the 3NF of the data warehouse.
  • Created DDL scripts for static dimensions and data model for the star schema using Erwin.
  • Used SQL tools like Teradata SQL Assistant and TOAD to run SQL queries and validate the data in warehouse.
  • Performed tuning of SQL Queries to improve the response time.
  • Played an active role in creating the User reference documents on all the deliverables and conducted training sessions.

Environment: Oracle 10g, DB2, Erwin 7.x, Teradata SQL Assistant, SQL, PL/SQL, ODBC, HTML, TOAD, SQL * Loader, UNIX, MS Office.

Confidential, NYC

Data Analyst/Data Modeler


  • Prepared High Level Logical Data Models and BRDs (Business Requirement Documents), supporting documents.
  • Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards. Conducted Design discussions to come out with the appropriate Data Mart.
  • Defined facts, dimensions and designed the data marts using the Ralph Kimball’s Dimensional Data Mart modeling methodology using ERWIN.
  • Designed different type of STAR schemas like detailed data marts and Plan data marts, Monthly Summary data marts using Erwin with various Dimensions Like Time, Services, Customers and various FACT Tables.
  • Worked on integrating the data between different sources.
  • Provided architecture/development for initial load programs to migrate production databases from Oracle data marts to Teradata data warehouse.
  • Worked on mapping the data between Source and Targets.
  • Created DDL scripts for static dimensions and data model for the star schema using Erwin.
  • Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
  • Developed data mapping documents between Legacy, Production, and User Interface Systems.
  • Designed and Developed Oracle database Tables, Views, Indexes with proper privileges and Maintained and updated the database by deleting and removing old data.
  • Imported millions of records from .CSV files .TXT files using SQL * LOADER and Test Importer.

Environment: Oracle 10g, SQL, Erwin 4.x/7.x, Teradata, HTML, TOAD, SQL * Loader, MS office.


Data Analyst


  • Involved in the design of the overall database using Entity Relationship diagrams.
  • Wrote triggers, menus and stored procedures in PL/SQL.
  • Involved in developing interactive forms and customization of screens using Forms 4.5.
  • Involved in building, debugging and running forms.
  • Involved in Data loading and Extracting functions using SQL*Loader.
  • Designed and developed all the tables, views for the system in Oracle.
  • Designing and developing forms validation procedures for query and update of data .
  • Extensive learning and development activities.
  • Performed back - end testing for the Application.
  • Performed manual testing for integration and acceptance.
  • Performed negative and positive testing for the application.
  • Modified existing Test Plans and Test Scripts for regression testing.
  • Conducted data integrity testing by extensive use of SQL.

Environment: Oracle 8.0, SQL*plus, SQL*Loader, T-SQL, PL/SQL, Forms 4.5, Reports 2.5, Business Objects, WinRunner


Data Analyst/Business Analyst


  • Gathered business requirements through interviews, surveys and observing from account managers and conducted controlled brain-storming sessions with project focus groups and documented them in the Business requirement Document.
  • Analyzed Requirements and created Use Cases, Use Case Diagrams, Sequence Diagrams using Rose.
  • Extensively used SQL for accessing and manipulating database systems
  • Create various Data Mapping Repository documents as part of Metadata services (EMR).
  • Involved in the Data Movement between Systems and validated the Business Requirements.
  • Involved in business process modeling using UML
  • Verified the correlation between the UML diagrams and developed detailed diagrams
  • Developed and maintained data dictionary to create metadata reports for technical and business purpose.
  • Done SQL Server configuration database size estimation, database creation logins & user’s creation, granting object level permission, estimation of indexes on tables.
  • Created a logical design of the central relational database using Erwin4.x data transformations in both normalized and de-normalized data environments
  • Involved in data manipulation using stored procedures and Integration Services.
  • Worked on query optimization, stored procedures, views, and triggers.
  • Assisted in OLAP and Data Warehouse environment when assigned.
  • Maintained security and data integrity of the database.
  • Helped to develop test strategies, test cases, test plans, defect reports, Traceability Matrices and test environments and managed the testing process, bug reporting and analysis of test results.
  • Developed several forms & reports using Crystal Reports.

Environment: Windows Server 2003, MS SQL 2005/08, UNIX, Erwin4.x, Crystal Reports8

Hire Now