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