Remote data modeler Resume Alexandria, VA - Hire IT People

SUMMARY:

An IT professional with over seven years of experience in various fields such as Finance and Insurance. An eager individual with extensive experience in Data Analysis, Data Manipulation, Data Extraction, Research and Reporting in different formats and from multiple sources. Proven ability to learn, utilize in - house databases and systems to maintain strategic vision of the organization and link it with everyday tasks. Able to perform multiple duties in business analysis, project or program management and functional leadership.
Experience in Data Analysis and ETL techniques for loading large amounts of data.
Utilize business intelligence tools to include OLAP (Online Analytical processing), data warehousing, reporting, querying tools and excel.
Perform data modeling and data migration in efforts to consolidate and harmonize data.
Hands-on data modeling experience using Dimensional Data Modeling, Star Schema, Snowflake, Fact and Dimension Table, Physical and Logical Data Modeling using Erwin 3.x/4. x.
Possess strong computer and office administration skills with vast knowledge of Windows and Microsoft Office Suite (Word, Excel, PowerPoint, Access, and Visio).
Support in a detailed technical design, development, implementation, and support of Big Data applications using existing and emerging technology platforms.
Great understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM).
Possess a strong ability to acclimate and learn new technologies and new business lines swiftly.
Excellent team player with demonstrated experience of working diplomatically and collaboratively with all levels of staff to ensure successful implementation of assignments
Self-motivated individual with strong communication skills, great attention to details and the ability to work under pressure.
Exceptional organizational and time management skills and the ability to work independently.

TECHNICAL SKILLS:

Operating Systems: Windows, Unix, MacOS

Databases: MS SQL Server 2005/2008/2012, MySQL 5.2, 5.7, Oracle 9i, 10g, 11g, DB2

ETL/Other Tools: SSIS (Visual Studio), Erwin Data Modeler, MySQL Workbench

Querying Tools: SQL Management Studio 2008/2012, 2014, 2018, SQL Plus, SQL Developer, PL/SQL

Querying language: SQL, PL/SQL, TSQL

Business Intelligence Tools: Tableau 9.1, 9.2, 9.3, 10.4, PowerBI, Excel and PowerPivot, SSRS

EXPERIENCE:

Remote data modeler

Confidential | Alexandria, VA

Reverse engineer data models for existing databases and systems.
Perform data normalization and denormalization where needed.
Design data models for development of a data warehouse and data marts.
Develop SQL scripts, perform database support activities, and conduct performance tuning.
Design and analyze data models, data flows and integration patterns for structural deficiencies to build a robust and complete future state model.
Create and maintain management-level reports using SSRS.
Work closely with subject matter experts in order to understand system requirements.
Collaborate with customers and stakeholders to devise possible solutions for data sharing environments.

Data modeler

Confidential

Responsibilities:

Produce technical design documentation for all codes and data models.
Analyze duplicates or errors in data to provide appropriate inter-departmental communication and monthly reports.
Ensure the Data warehousing design is scalable and maintainable.
Forward engineer physical models to create DDL scripts to implement new databases and database changes. Reverse engineer database and synchronize data models with actual data implementations.
Create data dictionaries and business glossaries to document data lineages, data definitions and metadata for all business-critical domains.
Develop and maintain custom Jira workflows based upon business requirements.
Conduct/attend requirements definition meetings with end users and document system/business requirements.
Update and create the appropriate data types and sizes for the new fields added to the system data model.

Data analyst

Confidential

Responsibilities:

Partner with business owners to identify business needs to generate requirements and establish methodology needed for producing standard reports and ad hoc analyses.
Design, build, deploy and maintain analytics models.
Provide technical support for existing reports, dashboards, and tools.
Aggregate data, analyze for errors and inconsistencies to promote data integrity.
Gather, analyze, document business requirements and transfer knowledge to the product development team.
Write queries to retrieve data from different tables by using JOINs, Sub-queries and correlated sub-queries on SQL Server platform.
Write intermediate to advanced SQL for data wrangling and reporting efforts.
Write complex SQL queries using advanced SQL concepts like aggregate functions, Group by and OLAP (Online Analytical Functions).

We provide IT Staff Augmentation Services!

Remote Data Modeler Resume

Alexandria, VA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship