We provide IT Staff Augmentation Services!

Senior Data Modeler/analyst Resume

Chandler, AZ

SUMMARY:

  • 8+ years of professional experience in data analysis, data modeling, design, development and implementation of OLTP, Data Warehouse & Business intelligence.
  • Hands on knowledge with complete Software Development Life Cycle (SDLC) for the projects using methodologies like Agile, RUP, Waterfall, and hybrid methods.
  • Expertise in interacting with stakeholders, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
  • Strong background in business intelligence, reporting systems, data quality (including ETL), and full life - cycle development.
  • Experience of working in the area of data management including data analysis, gap analysis and data mapping.
  • Extensive experience in reverse engineering databases, Complete compare using ERwin.
  • Designed and developed Data models for Database (OLTP), the operational data store (ODS), Data warehouse (OLAP), and federated databases to support client enterprise Information Management Strategy.
  • Experienced in identifying the Facts and Dimensions from the Enterprise Architecture for designing the Star and Snowflake Schema.
  • Experience in developing Entity-Relationship diagrams and modeling Transactional Databases in 3NF and using tools like Erwin, ER/Studio and Netezza Power Designer.
  • Excellent experience in Extract, Transfer and Load process using ETL tools like Data Stage, Informatica, Data Integrator and SQL Server Integration Services for Data migration and Data Warehousing projects.
  • Efficient in enterprise data warehouses using Kimball data warehouse and Inmon’s methodologies, good in building various logics to handle Slowly Changing Dimensions.
  • Experience on workflow Analysis, Functional decomposition Analysis, Object Modeling along with Activity Diagrams.
  • Worked extensively with ERwin, Visio and ER Studio, Dimensional Modeling and Data Migration projects.
  • Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary.
  • Extensive experience in Database Management in managing SQL Server Databases
  • Developing reports on SSAS & SSRS on SQL Server (2000/2005). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
  • Supported team in resolving SQL Reporting services and related issues.
  • Extensive experience in Performance tuning databases for optimum performance
  • Expert in Backup / restore of databases for maximum efficiency.
  • Interacted with all levels of the project development team, from end users to Software Architects, Technical Lead, Database Administrators, and System Administrators.
  • Excellent technical, time management, communication, interpersonal and presentation skills.

TECHNICAL SKILLS:

Data analysis: Requirements Gathering, JAD sessions, Process/Production Model analysis, Data Normalization, Cleansing, Profiling, System Design, Data architecture internal Standards development, Metadata, Bulk Editor and Reports, Source and Target system Analysis, Project Management.

Data modeling tools: CA Erwin, Netezza Power designer, Erwin, ER/Studio, Toad data modeler, Visio tool, IBM Data Architect, UML, MS Visio, Data Profiling, Data cleansing.

Database systems: Oracle, Teradata, SQL server, Sybase, MySQL, Microsoft Access, DB2.

ETL and Reporting Environment: Informatica, Microsoft SSIS, SSAS, SSRS, Data Stage and Crystal Reports.

Operating systems: Microsoft windows 2000/2003/NT/2007/2008.

Languages: T-SQL, PL/SQL, Basic C &Unix.

Additional QA Skills: Business and Software Process and Procedure Definition, Quality Models, data standards, Measures and Metrics, Project Reviews, Audits and Assessments. Provide Assistance to Production Issues

PROFESSIONAL EXPERIENCE:

Senior Data Modeler/Analyst

Confidential, Chandler, AZ

Responsibilities:

  • Helped conduct meetings with the end users and performed interviews to gather the requirements from them and to convert those requirements into Requirements document for the development and testing teams.
  • Analyzed the business requirements to get a thorough understanding of the testing requirements and developed test plans and created test cases in Rational Test Manager for extensive coverage of the requirements during testing.
  • Designed Logical/Physical and Conceptual models of database using ERwin and VISIO
  • Did extensive reverse engineering of databases using ERwin.
  • Worked with the developers to understand the ERD (Entity Relationship Diagram) and thus create comprehensive test plans, following the RUP model, for the applications and also gather test data for the data driven test cases.
  • Managed Traceability matrix to trace Business Requirements, Functional Requirements, and Use Cases.
  • Worked with business people, data stewards, SMEs as a part of data model designing and source to target mapping document creation.
  • Identified opportunities for business process improvement and initiated efforts to make improvements.
  • Worked extensively on BI (SSIS) Packages for extracting the data of the customers from OLTP, transform that data and load it into the OLAP.
  • Extensively involved in using BI tools like Import and Export Wizard for developing the packages.
  • Provided the sequence and flow diagrams for various modules in the project using Rational Rose.
  • Created solid DSS databases for Reporting.
  • Participated in weekly review meetings to report the documented test metrics and defects found in the System. Closed bug reports once they are resolved and verified.
  • Involved in Training and Documentation.
  • Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from sources.
  • Gather requirements and design of data warehouse and data mart entities.
  • Used SQL to perform data analysis, data profiling and generating reports.
  • Assisted in designing test plans, test scenarios and test cases for integration, regression and user acceptance testing.
  • Worked with Data Quality and ETL teams as part of my job responsibilities.

Environment: ERwin, VISIO, SQL Server 2008, Microsoft Word, Excel, PowerPoint, SSAS, SSRS, SSIS.

Data Modeler/Analyst

Confidential, NY

Responsibilities:

  • Designed the business requirement collection approach based on the project scope and SDLC methodology.
  • Conducted controlled brainstorming sessions with project focus groups.
  • Documented business requirements with wireframes and mockups to explain in detail the business implications and impacts.
  • Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Dataflow Diagrams and Conceptual Data Models in MS Visio.
  • Worked extensively with VISIO and Erwin to do reverse engineering of Database for reporting
  • Did extensive logical/physical modeling of database for ETL/Reporting
  • Prepared functional requirements to define the system rules by creating Use Cases, Interface design and data dictionaries.
  • Analyzed various resource files being used to generate the report and documented data mapping and data source interface documents to assist the development team.
  • Worked with the Business Objects developers to provide input for generating automated and adhoc Business reports.
  • Used SQL for querying and analysis purposes on various source tables and conditions applied and Wrote SQL joins, sub queries.
  • Used SQL Server Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
  • Built up and maintain a strong data warehousing system for the organization
  • Helped the testing team in creating the test plans and test scripts. Assisted the users in UAT testing by providing test scenarios and test data.
  • Assigned problems to appropriate software development team for fixes.
  • Authored progress and completion reports, which were then submitted to project management on a weekly basis.

Environment: MS SQL Server 2008/2005/2000 , ERwin, VISIO, Oracle 11g, Oracle SQL Developer, MS Word, MS Excel, MS PowerPoint, MS Access, MS Projects, MS Visio, Adobe Flash, MS SharePoint.

Data Modeler/Analyst

Confidential, Montvale, NJ

Responsibilities:

  • Participated in requirement gathering session with business users and sponsors to understand and document the business requirements as well as the goals of the project.
  • Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with business users.
  • Analyzed the source system (JD Edwards) to understand the source data and JDE table structure along with deeper understanding of business rules and data integration checks.
  • Identified various facts and dimensions from the source system and business requirements to be used for the data warehouse.
  • Created the dimensional logical model with approximately 10 facts, 30 dimensions with 500 attributes using ER Studio.
  • Implemented the Slowly changing dimension scheme (Type II) for most of the dimensions.
  • Reviewed the logical model with Business users, ETL Team, DBA's and testing team to provide information about the data model and business requirements.
  • Created the DDL scripts using ER Studio and source to target mappings (S2T- for ETL) to bring the data from JDE to the warehouse.
  • Worked with DBA to create the physical model and tables. Scheduled multiple brain storming sessions with DBAs and production support team to discuss about views, partitioning and indexing schemes, case by case for the facts and dimensions.
  • Worked on Trillium Data Quality tool for monitoring Production systems for Data Anomalies and resolve issues.
  • Worked on Mercury Quality Center to track the defect logged against the logical and physical model.
  • Worked as an onsite project coordinator once the design of the database was finalized in order to implement the data warehouse according to the implementation standards.
  • Worked with client and off shore team to make sure that the reports and dashboards are delivered on time.
  • Participated in UAT sessions to educate the business users about the reports, dashboards and the BI System.
  • Worked with the test team to provide insights into the data scenarios and test cases.
  • Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.

Environment: ER Studio, Microsoft SQL Server, Oracle, Teradata

Data Modeler/Analyst

Confidential, Broussard, LA

Responsibilities:

  • Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
  • Involved in gathering user requirements along with Business Analyst.
  • Extensively used Star Schema methodology in building and designing the logical data model.
  • Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
  • Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
  • Prepared business case for the data mart and then developed and deployed it.
  • Used ERwin to transform data requirements into data models.
  • Performed Reverse Engineering of the current application using ERwin, and developed Logical and Physical data models for Central Model consolidation.
  • Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of Data Analysis responsibilities.
  • Worked extensively in data analysis by querying in SQL and generating various PL/SQL objects.

Environment: SQL server 2008, Windows XP, Erwin, MS Visio, TOAD, Microsoft Office.

Data Modeler/Data Analyst

Confidential

Responsibilities:

  • Building Data Mart (Conceptual, Logical and Physical) for reporting environment
  • Creating Data Dictionary for user defined databases (Collateral, Securities and Reporting) in Oracle, SQL Server
  • In the role of Data Analyst performed analysis and design of extensions to an existing data warehouse/mart business intelligence platform
  • Segregated data and organized the data for common subjects using ODS
  • Generated operational reports from ODS as opposed to the transactional/ legacy system
  • Performed Data Architecture in Designing and implementing a Metadata Repository providing a centralized information source for the data models, data maps, processes, documents, contact lists, project calendars and issues affecting the merger with Wachovia
  • Implemented Agile Methodology for building an internal application
  • Worked on Data Aggregation
  • Generating Discrepancy reports using Ascential Data Stage
  • Preparing Functional Specifications Document for the project
  • Technical hands-on expertise using OLAP tool Business Objects 4/5.x/6.0 /XIR2(Reports, Designer, Web Intelligence, Info view and Supervisor)
  • Universe designing, developing and generating complex, Adhoc, dashboard Reports
  • Analyzing data in both application and reporting databases and solving the discrepancies
  • Tracking Data Model Change Requests to closure
  • Reverse engineering old database and creating subject areas for each schema
  • Preparing High Level Data Flow for all the major Applications
  • Well experienced in writing Complex queries, stored procedures, functions, cursors and packages using PL/SQL Programming
  • Developed robust and efficient oracle PL/SQL procedures, packages and functions that were useful for day to day data analysis
  • Fine-tuned existing PL/SQL code and worked on upgrade from 9i to 10g
  • Fine-tuned Oracle SQL to be more efficient

Environment: Oracle 9i/10g, SQL Server 2000/ 2005, Erwin 7.5.2, BO 6.5/ XIR2, Qlikview 8.5, Ascential Data Stage 7.5, Clear Quest, Windows XP, XML, Excel, Access.

Data Warehouse Analyst/Tester

Confidential

Responsibilities:

  • Designed & Created Test Scripts and Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document).
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Developed separate test cases for ETL process (Inbound & Outbound) and reporting
  • Involved with Design and Development team to implement the requirements.
  • Developed and Performed execution of Test Scripts manually to verify the expected results
  • Design and development of ETL processes using Erwin tool for dimension and fact file creation
  • Involved in Manual and Automated testing using QTP and Quality Center.
  • Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios).
  • Defects tracking, review, analyzes and compares results using Quality Center.
  • Participating in the MR/CR review meetings to resolve the issues.
  • Defined the Scope for System and Integration Testing
  • Prepares and submit the summarized audit reports and taking corrective actions
  • Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.
  • Document and publish test results, troubleshoot and escalate issues
  • Preparation of various test documents for ETL process in Quality Center.
  • Involved in Test Scheduling and milestones with the dependencies
  • Functionality testing of email notification in ETL job failures, abort or data issue problems.
  • Identify, assess and intimate potential risks associated to testing scope, quality of the product and schedule.
  • Created and executed test cases for ETL jobs to upload master data to repository.
  • Responsible to understand and train others on the enhancements or new features developed
  • Conduct load testing and provide input into capacity planning efforts.
  • Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.
  • Modified the automated scripts from time to time to accommodate the changes/upgrades in the application interface.
  • Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application.

Environment: Windows XP, Erwin, QTP and Quality Center