We provide IT Staff Augmentation Services!

Sr.data Modeler/ Data Analyst Resume

Houston, TX

SUMMARY

  • Over 7 years of professional experience in Data analysis and Data modeling in Online Transitional Processing (OLTP) and Online Analytical Processing (OLAP). Strong Knowledge in database management, strategic analysis, requirements gathering, application and decision support, which plays a key role in software development life cycle (SDLC).
  • Strong Knowledge of SDLC methodology including analysis, design, development, testing and maintenance.
  • Proficient in Normalizing (using 3NF) and De normalizing techniques for optimum performance in relational and dimensional database environments.
  • Experienced in generating and documenting Metadata, while designing OLTP, ODS and OLAP systems environment.
  • Exposure and knowledge of Data Mart design, creation of Cubes, identifying facts and dimension.
  • Experience in modeling Star schema and Snow flask schema for data warehouse.
  • Involved in Extracting, Transforming and Loading (ETL) data using Informatica along with ETL team.
  • Extensively worked on Inmon and Kimball approach.
  • Experienced in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using various data modeling tools like ERWIN, Embarcadero ER Studio
  • Data Modeler with strong Conceptual and Logical Data Modeling skills has involved in JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications and queries
  • Strong experience in Logical/Physical, Relational and Multi - dimensional modeling, Data analysis for Decision Support Systems (DSS), Online transactional processing (OLTP) and Data warehouse/Business Intelligence (BI) applications, Data Transformation (ETL) and Reporting.
  • Strong Data analysis skills including Data Mapping from source to target database schemas, Data Cleansing and processing.
  • Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes.
  • Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
  • Experience documenting business cases and managed report development from design to release.
  • Excellent experience with writing complex SQL queries to perform End-to-End ETL validations and support Ad-hoc business requests
  • Strong Database experience using Oracle 10g/9i/8i, Teradata, PL/SQL, Stored Procedures, triggers and cursors
  • Expertise in UML (class diagrams, object diagrams, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using MS-Visio.
  • Excellent analytical, inter-personal and communication skills with clear understanding of business process flow
  • Self-starter, Multi-Tasking, Attention to detail, ability to work with minimal supervision and manage time and task efficiently.
  • Effective team worker and can carry out individual tasks to meet the deadlines effectively.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, SQL, C, Java.

Databases: Oracle10g/9i/8i, Teradata2.x, Microsoft SQL Server 2000/2005, MS Access 2007/2003/2000 , My SQL.

Data Modeling Tools: Erwin 4/5/6/7/r8, ER Studio, Sybase Designer, Rational Rose.

ETL Tool: Informatica Power Center 7.1.1, 8.1.1.

Reporting Tool: Cognos 8, Crystal Reports XI, Business Objects XI, Oracle Reports, XML Publisher.

Operating System: Microsoft Windows Vista/XP/2000/NT, Sun Solaris, Unix, Mac OS, MSDOS.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr.Data Modeler/ Data Analyst

Responsibilities:

  • Consulted with client management and staff to identify and document business needs and objectives, current operational procedures for creating the logical data model.
  • Created a high level ACORD standard, generalized data model to convert it into logical and physical model at later stages of the project using ERWIN.
  • Designed the Conceptual Data Model, Logical Data model, Physical Data model and transformed them to creating schema using ERWIN.
  • Designed XML layouts and data movement strategies in compliant to ACORD standards.
  • Created Database Tables, Views, Indexes, Triggers and Sequences and Developing the Database Structure.
  • Extensively used Star Schema methodology in building and designing the logical data model.
  • Utilized organizational standards for data naming, structuring and documentation.
  • Worked with DBA group to create Tables from the Physical Data Model using Forward engineering in Erwin.
  • Created PL/SQL, Stored Procedures to load the data into Oracle tables.
  • Worked with Oracle SQL Developer to develop the SQL scripts.
  • Utilized SharePoint to track changes requests throughout the process.
  • Used MS Visio for Creating Process flow diagrams and E/R Diagrams.
  • Involved in the Integration of data coming from different sources.
  • Created ETL mapping specification spreadsheets to document the transformation logic.
  • Conducted peer reviews of completed data models and plans to ensure quality and integrity from data capture through usage and archiving.
  • Created Materialized Views, Views and Synonyms to support Business Objects Interactive Reporting.

Environment: ERWIN 9.x, Oracle 11g, SQL Server 2012, PL/SQL, Oracle SQL Developer, ACORD, MS Visio, Informatica Power Centre 9.x, Business Objects .

Confidential, Hartford, CT

Sr.Data Modeler/Data Analyst

Responsibilities:

  • Interacted with users and business analysts to gather requirements.
  • Engaged in business process modeling using UML through Rational Rose.
  • Produced Logical Data Models/Physical Data Models.
  • Created the calculations based on the reporting needs and the source data available
  • Recognized source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
  • Involved with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using Erwin tool.
  • Created Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
  • Formed data mapping documents between Legacy and User Interface Systems.
  • Produced PL/SQL statement and stored procedures in DB2 for extracting as well as writing data.
  • Formed mappings in Informatica to load the data from various sources includes SQL server, DB2, Oracle, Flat files into the Data Warehouse, using different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator.
  • Used SSRS for database reporting in Microsoft SQL server 2005.
  • Performed User Acceptance Testing on the application - resolved issues from the participants, prepared and submitted Test Analysis Reports and participated in Product Readiness Review.
  • Produced the documentation of Data Acquisition and Interface System Design.

Environment: Rational Requisite Pro, Erwin, Data Stage, DB2 UDB, SQL Server, Sybase, Windows NT, Linux, Sun Solaris, T-SQL.

Confidential, Wilmington, DE

Data Modeler/ Data Analyst

Responsibilities:

  • Involved in requirement gathering along with the business analysts group.
  • Gathered all the Sales Analysis report prototypes from the business analysts belonging to different Business units
  • Gathered various requirement matrices from the business analysts.
  • Participated in Joint Application Development(JAD) sessions
  • Conducted Design discussions and meetings to come out with the appropriate Data Model
  • Designed for the various reporting requirements
  • Designed a logical data model using database tool Erwin r7.0
  • Used ER Studio to create logical and physical data models for enterprise wide OLAP system.
  • Developed monthly summary and downstream data marts from enterprise wide databases in accordance with reporting requirements with dimensions like time, customers, services and accounts.
  • Developed Star and Snowflake schemas based dimensional model to develop the data warehouse
  • Modeled the dimensions and facts using Erwin for centralized data warehouse
  • Identified and tracked slowly changing dimensions and determined the hierarchies in dimensions
  • Actively participated in data mapping activities for the data warehouse.
  • Created summary tables using de-normalization technique to improve complex Join operations
  • Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis pertaining to Loan products
  • Participated in the tasks of data migration from legacy to new database system
  • Worked on Metadata exchange among various proprietary systems using XML.
  • Conducted Design reviews with the business analysts, content developers and DBAs
  • Designed and implemented a physical data model to handle marketing strategies and to satisfy reporting needs dynamically.
  • Organized User Acceptance Testing (UAT), conducted presentations and provided support for Business users to get familiarized with Loan products application.
  • Handled performance requirements for databases in OLTP and OLAP models.
  • Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase
  • Perform Data Loading and Transformation using Data Junction 6.0

Environment: ERWin r7.0, ER Studio, SQL Server 2000/2005, Windows XP/NT/2000, Oracle 8i, MS-DTS, UML, SQL Loader, Data Junction, Rational Rose 2000

Confidential, Wilmington, DE

Data Modeler/ Data Analyst

Responsibilities:

  • Revisited the business rules and redefined many attributes and relationships in the model and cleansed unwanted tables and columns as part of Data Analysis tasks.
  • Responsible for data mapping, metadata maintenance and enhancing existing Conceptual and Physical data models.
  • Conducted sessions with architects, business and development teams to understand the Change Requests (CR’s), and effects caused on the system by the change requests.
  • Maintained and updated Metadata repository based on the change requests
  • Analyzed existing Conceptual and Physical data models and altered them using Erwin to support enhancements.
  • Conducted walkthroughs with the DBA to convey the changes made to the data models.
  • Utilized Rational Clear Quest to track change requests throughout the process.
  • Implemented SQL Scripts to modify the data to resolve assigned defects.
  • Involved in conducting walkthroughs with business and development teams to validate end-to-end data mapping across various systems.
  • Analyzed and synthesized the requirements gathered from multiple sources and documented the business process flow for the system.
  • Designed the conceptual data model and worked with the Business analysts and technical teams to design and update the logical data model in various iterations. Involved in the entire System study, AnalysisandDesign.
  • CreatedEntity relationships diagrams, data flowdiagrams and enforced allreferential integrity constraints using Oracle Designer.
  • Developed the data warehouse model (star schema) for the proposed central model. Also worked on normalizing star-schema to snow flake schema to fulfill requirement.
  • Worked with the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes.
  • Developed source to target mapping documents to support ETL design.
  • Created tables, views, sequences, indexes, triggers, table spaces, constraints and generated sql scripts for physical implementation.
  • Determined data rules and conducted Logical and Physical design reviews with business analysts, developers and DBAs.
  • 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.
  • Developed data mapping documents between Legacy, Production, and User Interface Systems.
  • Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents.
  • Designed the data sourcing, data staging and ETL process. Mapped the data between the source and targets.

Environment: Erwin, DB2, Teradata, Informatica, Power Designer, Clear Quest, Cognos, Crystal reports, TOAD, PL/SQL, ER Studio, Lotus Notes Windows 2003, MS Excel, Word and Access

Confidential, Warrens, NJ

Data Modeler /Data Analyst

Responsibilities:

  • Interacted with users and business analysts to gather requirements.
  • Understood existing data model and documented suspected design affecting performance of the system
  • Initiated and conducted JAD sessions inviting various teams to finalize the required data fields and their formats.
  • Developed Logical and Physical Data models by using Erwin.
  • Created logical data model from the conceptual model and its conversion into the physical database design.
  • Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models
  • Applied second and third NFR to normalize existing ER data model of OLTP system.
  • Used Denormalization technique in DSS to create summary tables and improved complex Join operation.
  • Gathered statistics on large tables and redesigned Indexes.
  • Installed and configured SQL Server.
  • Designed and developed the databases
  • Written Stored Procedures and Triggers extensively and working very closely with developers, business analyst and end users to generate various audit reports and troubleshoot their query problems and connectivity problems.
  • Created integrity rules and defaults.
  • Done analysis of resource intensive query and applied changes in existing back-end code (stored procedures, triggers) to speed up report execution
  • Created ftp connections, database connections for the sources and targets.
  • Maintained security and data integrity of the database.
  • Developed several forms & reports using Crystal Reports.
  • Provided maintenance support to customized reports developed in Crystal Reports/ASP.
  • Done analysis of live site issues related to database and resolved the same.

Environment: Erwin, Oracle 8i, SQL Navigator, PLSQL, Pro DB2, SQL server 7.0,MS SQL server Analysis Manager, Sybase, Rational Requisite, Windows NT, Crystal Reports.

Hire Now