We provide IT Staff Augmentation Services!

Sr. Data Modeler/data Analyst Resume

Park Ridge, NJ

SUMMARY:

  • 6 plus years of IT Experience as a Data Analyst, Business Analyst, and Data Modeler especially in Data Warehousing and Business Intelligence applications.
  • Experience as a Business Analyst for data warehousing with a good knowledge and expertise in all phases of SDLC methodology including analysis, design, development, testing and maintenance.
  • Extensive experience working with SQL & PL/SQL in creating stored procedures, views, triggers and database schemas.
  • Proficient in Data Analysis on Oracle, MS SQL Server & MS Access with sound knowledge in extraction of data from various database sources like Oracle, MS SQL Server, DB2 and Flat files into the Data Stage.
  • Experience in working with Sybase Power Designer for creating conceptual data model with entities, attributes, and relationships.
  • Explored the reverse engineering features of PowerDesigner to create physical, conceptual and object - oriented models from an existing database.
  • Extensively worked on Teradata data modeling projects.
  • Experience with Teradata SQL and TeradataUtilities (ETL Data Migration Tools).
  • Designed the data marts using the Ralph Kimball’s and Inmon dimensional data mart modeling techniques.
  • Experience in working with Master Data Management (MDM).
  • Well versed in system analysis, ER/Dimensional Modeling, Database design and implementing RDBMS specific features.
  • Good in Normalization (1NF, 2NF, 3NF and BCNF)/Denormalization techniques for effective and optimum performance in OLTP and OLAP environments.
  • Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
  • Efficient in process modeling using Erwin in both forward and reverse engineering cases.
  • Well versed with Data Migration and Data Conversions using DTS, PL\ SQL Scripts.
  • Experience in writing DDL,DMLcommands.
  • Used TOAD for SQL developing.
  • Experienced in conducting JAD Sessions.
  • Experience in documenting InterfaceAgreement.
  • Experience in using Visual Studio for GUI applications and Windows Forms applications.
  • Experience in defining events within Business Process using Workflows.
  • Extensive experience in the development, implementation and integration of strategies within a team oriented environment, utilizing quantitative and qualitative analytical skills.
  • Excellent analytical, inter-personal and communication skills with clear understanding of business process flows.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, T SQL, Visual Basic 6.0, XML, HTML, Java.

Operating Systems: Windows (NT/XP/95/98/2000), UNIX, Sun Solaris, Mac OS.

Databases: Oracle 10g/9i/8i, SQL Server 2000/2005/2008 , PL/SQL, SQL*Plus, SQL*Loader, IBM DB2, MS SQL Server 2000/7.0/6.5 , MS Access 2000, Teradata V2R5.0.

Microsoft office: Word, Excel, Access, Visio, Outlook, PowerPoint

Project Management Tools: Microsoft Project and other tools.

Data Modeling Tools: Erwin, Sybase Power Designer, Clear quest, Rational Rose, MS Visio, ER Studio, Oracle BPA, SA - System Architect.

Reporting Tools: Business Objects 5.x/6.5, Cognos 7.0/6.0, Crystal (6, 8, and 11), OBIEE Business Intelligence Enterprise edition 10.3.4.1.

Web Development Tools: Macromedia Dream Weaver4.0, Flash 5.0, Adobe Photoshop

ETL Tools: Informatica Power Center 8.6/7.1/6.2

PROFESSIONAL EXPERIENCE:

Confidential, Park Ridge, NJ

Sr. Data Modeler/Data Analyst

Responsibilities:

  • Worked with the Business analyst for gathering requirements.
  • Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
  • Used UML and Visio for creating Activity diagrams, Sequence Diagrams.
  • Developed entity and attribute descriptions and definitions for the models and ensure that conflicts in descriptions and definitions are resolved.
  • Conducted and participated in JAD sessions with the users, modelers, and developers for resolving issues.
  • Conducted design discussions and meetings to come out with the appropriate data martusing Inmon methodology.
  • Worked with Master Data Management architects to develop data models.
  • Performed source data quality assessments.
  • Experience in Data Transformation and data cleansing.
  • Identified the objects and relationships between the objects to develop a logical model in Erwin tool.
  • Translated the logical model into physical model using Forward Engineering technique in Erwin tool for both OLAP and OLTP systems.
  • Defined and processed the facts and dimensions.
  • Utilized Erwin for reverse engineering the database from DDL scripts.
  • Assisted the Data Acquisition Architect to ensure the Data Architecture is applied properly.
  • Involved in resolving the data type inconsistencies between the source systems and the target system using the Mapping Documents.
  • Developed PL/SQL programming that included writing Stored Procedures, Packages, Functions and Database Triggers.
  • Writing complex queries using Teradata SQL.
  • Experience in using SSIS in solving complex business problems.
  • Experience in using SSRS in creating and managing reports for an organization.
  • Created documentation, worked with users for new module enhancements and testing.

Environment: PL/SQL, SQL Server 2008, Oracle 10g, Teradata, Erwin r7.3, Windows XP, Excel.

Confidential, Portland, Oregon

Data Modeler/Data Analyst/Developer

Responsibilities:

  • Involved in gathering user requirements along with business analysts.
  • Involved in a team conducting data modeling JAD sessions and logical data analysis, communicated data-related standards.
  • Created documentation for Technical & Business User Requirements during requirements gathering sessions using Rational Requisite Pro.
  • Transformed project data requirements into project data models for OLAP and OLTP systems using Erwin.
  • Prepare prototype models to support the development efforts. Assist the business analyst in mapping the data from source to target.
  • Involved in modeling business processes through UML diagrams using Rational Rose.
  • Conducted logical data model walkthroughs and validation.
  • Facilitated transition of logical data models into the physical database design for data marts using Inmon methodology and recommended technical approaches for good data management practices.
  • Performed the activities necessary to support the standardization of facts and dimensions.
  • Worked with DBA group to create Physical Data Model from the Logical Data Model using Forward engineering in Erwin.
  • Reverse Engineered the database structure from the existing application using Sybase power designer.
  • Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
  • Developed data mapping documents between Legacy, Production, and User Interface Systems.
  • Wrote PL/SQLstatement and stored procedures in Oracle for extracting as well as writing data.
  • Wrote DDL and DML statements for creating, altering tables and converting characters into numeric values.
  • Turned SQL queries to make use of data base indexes, and analyzed the data base objects.
  • Used SSIS, SSRS for solving business problems and creating reports in organization.
  • Worked on modeling for Business Objects reporting in Teradata, and also OLTP style in Oracle environment that is a source for Teradata for maintenance of dimension attributes

Environment: Rational Requisite Pro, Informatica, Data Flux, PL/SQL, SQL Server 2008, Sybase 12, Business Objects, Windows NT, Linux, Sun Solaris, Sybase Power Designer, Teradata.

Confidential, Dallas,TX

Data Modeler

Responsibilities:

  • Consulted with business analyst for gathering the business requirements.
  • Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
  • Make use of data modeling techniques in designing the data marts project.
  • UsedRational Rose 2000 for Object Modeling in UML.
  • Gather all the Sales Analysis report prototypes from the business analysts belonging to different Business units.
  • Gather the various requirementmatrices from the business analysts.
  • Participated in JAD sessions.
  • Assisted the DBA in converting the logical models to physical.
  • Conduct Design discussions and meetings to come out with the appropriate Data Martusing Kimball Methodology.
  • Designs for the various reporting requirements.
  • Conduct Design reviews with thebusiness analysts, content developers and DBAs to ensure the feasibility of the designs.
  • Used Erwin for developing data model and forward engineer the data model.
  • Reverse engineer the data base in to physical data model by using Erwin.
  • Developed entities and relationships using SybasePowerDesigner.
  • Designed different type ofSTAR schemaslike detailed data marts, Plan data marts,
  • Used Erwin for monthly summary data marts and inventory data marts.
  • Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.

Environment: Oracle 8i, Windows NT, ER-Win 4.0, Sybase Power Designer, MS-DTS,SQL Loader, Data Junction, Rational Rose 2000, Oracle Express Server.

Confidential, Bridgewater, NJ

Data Modeler / Data Analyst

Responsibilities:

  • Gathered and translated business requirements, worked with the Business Analyst and DBA for requirements gathering, business analysis, and testing and project coordination.
  • Performed Reverse Engineering of the legacy application using DDL scripts in ERWin, and developed Logical and Physical data models for Central Model consolidation.
  • Worked with DBAs to create a best fit Physical Data Model from the Logical Data Modelusing ERWin.
  • Administered and maintained the model updates using ModelMartfor the entire project team.
  • Employed process and data analysis to model a Customer Information Business System.
  • Conducted logical data model walkthroughs and validation.
  • Conducted team meetings and JAD sessions.
  • Developed data mapping documents for integration into a central model and depicting data flow across systems.
  • Worked on Conceptual, Logical Modeling and Physical Database design for OLTP and OLAP systems.
  • Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models.
  • Used SybasePowerDesigner in designing the data model.
  • Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables and columns as part of Data Analysis responsibilities.
  • Performed legacy application data cleansing, data anomaly resolution and developed cleansing rule sets for ongoing cleansing and data synchronization.
  • Developed the Data warehouse model (star schema) for the proposed central model for the Project.
  • Developed Process Methodology for the Reverse Engineering phase of the project.
  • Developed Project plan with Project Manager’s assistance for the first two phases of the project.
  • Developed and maintained the central repository, populated it with the metadata.

Environment: Oracle 9i, ERWin 4.0, Sybase power designer,ModelMart, W2K/XP, Visio 2000, MS Office XP, PL/SQL, SQL.

Confidential

Oracle Developer/Data Modeler

Responsibilities:

  • Involved in the entire system study, analysis and design.
  • Creating procedure for updating the data from factory systems, through Oracle PL/SQL.
  • Used Stored Procedures, Packages and Database Triggers extensively.
  • PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.
  • Experience in SSIS, SSRS in solving business problems and managing reports in organization.
  • Provide ER diagrams via Erwin and Visio.
  • Involved in testing the database for queries that were generated and handled the performance issues efficiently.
  • Involved in documenting the entire technical process.
  • Supported technical teams involved with ORACLE issues and operations.
  • Involved in the maintenance of the database.
  • Requirement gathering from the users. A series of meetings were conducted with the business system users to gather the requirements for reporting.
  • Requirement analysis was done to determine how the proposed enhancements would affect the current system.
  • Design and developments of the changes and enhancements. The existing submission and refining programs were enhanced to in corporate the new calculations.
  • Designed XML schemas using Unified Modeling Language (UML) - translating business concepts into XML vocabularies
  • Interacted with end users to identify key dimensions and measures that were relevant quantitative.
  • Involved in logical and physical designs and transform logical models into physical implementations.

Environment: Oracle 8i, SQL, PL/SQL, XML, Erwin, Windows 2000/NT, UNIX.

Confidential

Data Modeler/Data Analyst

Responsibilities:

  • Gathered business requirements through interviews, surveys, prototyping and observing from account managers and UI (User Interface) of the existing Broker Portal system.
  • Wrote Requirement and Design document for Master Data Entities. Used Corporate Modeler to design the Process
  • Conducted controlled brain-storming sessions with project focus groups.
  • Prepared High Level Logical Data Models and BRDs (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
  • Analyzed different source systems in order to come up with Source system which was generating the data.
  • Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
  • Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams in Rational Rose.
  • Conducted JAD sessions with management, SME (Subject Matter Expertise), vendors, users and other stakeholders for open and pending issues to develop specifications.
  • Participated in the Data Modeling to generate target database layout use for the data marts.
  • Generated data mapping documents to define mapping from source to target.
  • Reviewed the business requirements or use cases, do the analysis, and convert them to logical data models.
  • Participated in high-level and low-leveldesign sessions including writing technical project documentation.
  • Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
  • Defined the data definitions, and create the target tables in the database.
  • Mapped the source and target databases by studying the specifications and analyzing the required transforms.
  • Provided data modeling support for numerous strategic application development projects.
  • Documented the Purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.

Environment: Oracle 8i, PL/SQL, Toad 8.1, Erwin 4.0, Informatica 7.1

Hire Now