We provide IT Staff Augmentation Services!

Data Modeler And Bi Developer Resume

4.00/5 (Submit Your Rating)

Dayton, OH

SUMMARY

­­­­­­­­

  • Over 9+ years of IT experience in information management and six years of Data Modeler with over: data modeling, database design, solution design, SQL query development, and business intelligence (BI) development and architecture.

TECHNICAL SKILLS

Data Modeling Tool: Erwin Data Modeler 8.2.08.3637

Data Management: Microsoft SSIS, T - SQL

Databases: SQL Server, Teradata, Access

Business Intelligence: Microsoft SSRS, Visual Studio, MicroStrategy

Operating Systems: Windows

Other: SQL, HTML, Team Foundation Server, Visio, MS Office, WebEx, Hadoop

PROFESSIONAL EXPERIENCE

Confidential - Dayton, OH

Data Modeler and BI Developer

Responsibilities:

  • Hands-on experience in all stages of system development efforts, including requirement analysis, design, development, and testing and implementation of data warehouse processes
  • Used forward engineering to create a physical data model with DDL that best suits the requirements from the logical data model
  • Used Erwin for reverse engineering to connect to existing databases and create data models
  • Built conceptual, logical, and physical data models in third normal form using Erwin and Microsoft Visio
  • Applied data warehousing principles while building fact tables, dimension tables, star schema models, and snowflake schema models, slowly changing dimensions, foreign key concepts, and referential integrity
  • Built repositories and created source & target mapping for database tables for data extraction, data transformation, and loading (ETL) programs using Microsoft SSIS
  • Developed business intelligence (BI) reports with Microsoft Reporting Tools (SSRS) and MicroStrategy Reporting Tools
  • Worked under Scrum methodology for SDLC, using Team Foundation Server
  • Improved data integrity by adding foreign keys and normalizing the underlying data structure
  • Provided data quality analysis to business owners and users for their custom created reports
  • Gained understanding of data about care management, behavioral health, state health plans, case management, grievances & appeals, claims, finance, provider data, utilization management, and enrollment through projects

Confidential - Dayton, OH

Business System Analyst

Responsibilities:

  • Worked on robust EDW (Enterprise Data Warehouse) ETL team, doing the Intake process of new requests, triaging, rank priority, and gathered technical requirements.
  • Led meetings with BA and ETL development teams to prioritize work, design solutions. Used JIRA to document requests, define sprints, and create Dashboards. Re-did process in ServNow.
  • Defined requirements and created data flows to document business processes. Createdmapping documents of incoming source and target files in Stage layer and Informatica maps.
  • Data analysis, used SQL Server to validate data between four different source systems to create a master record for new MDM system. Wrote business rules in Markit securities tool.
  • Supported an ETL process for processing XML trade files and creating test data.

Confidential - Westborough, MA

BI Developer

Responsibilities:

  • Created intelligent cubes to reduce the database load and decrease the report execution time by using the cube services
  • Developed metrics and filters for reporting
  • Created attributes, facts and relationships between attributes using MicroStrategy Architect; imported tables using warehouse catalog and created logical tables
  • Modified VLDB properties to optimize the performance of reports; created transformations (formula based; table based) to use in comparative reports, like for sales analysis (yearly/monthly)
  • Created Gauge Widgets, Time Series Sliders, Interactive Stacked Graphs; created visualizations like, Heat Map and Graph Matrix Visualization
  • Successfully completed various dashboard projects, such as for web, mobile, and iPads
  • Engaged in deployment/migration activities between different MicroStrategy environments
  • Involved in supporting production, implementation and post-production activities
  • Worked with the project manager, technical leads, and end users
  • Resolved critical defects identified during production testing
  • Analyzed all the intelligent cubes, tested the data, and supported the production environment

Confidential, Atlanta, GA

Data Modeler

Responsibilities:

  • Involved in the complete life cycle of different projects
  • Gathered business requirements in end-user meetings to create reports; established and maintained relationships with end-users
  • Conducted data-modeling analyses
  • Created facts and dimension tables for the data warehouse
  • Created the requirements documentation for Erwin projects and documented the user-defined properties (UDP) in Erwin Mart
  • Generated reports with Erwin Mart
  • Created source-to-target mappings for ETL processes
  • Used reverse and forward engineering tools to create physical data models

We'd love your feedback!