Data Architect / Developer Resume Tinton Falls, NJ - Hire IT People

SUMMARY:

IT professional with proven experience and skills in Data Architecture and Database design, Data modeling, DW/BI development
System and Databases administration, as well as Data Analytics and Data Visualization development and management.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE:

Data Architect / Developer

Confidential, Tinton Falls, NJ

Responsibilities:

Collect and analyze business requirements, establish and maintain policies and standards
Provide technical solutions including data models, data flows, data quality, mapping, integrity, security, scalability, reliability, performance, migration, operations, data discovery and data visualization.
Create and implement logical, physical, Relational, Dimensional data models
Create and maintain data dictionaries and system documents
Develop and implement SSIS Packages with fault-tolerance, error logging and auditing to validate business rules, create workflows, data mappings, transformation and cleansing, ensure data quality, integrity and security
Develop Stored Procedures, Functions, Triggers, OLAP Cube, MDX queries
Collect and analyze large datasets, implement predictive analytics models
Provide function design to developers, test, deploy application code, manage source code
Manage databases capacity, security, high availability. Manage and automate database jobs and maintenance plans, check Servers and Databases health
Troubleshoot and optimize system, application and query performance
Install and configure QlikSense BI Platform, manage QMC and backend PostgreSQL database. Create data models, QVD files and Dashboards
Use SCRUM methodology for development, testing and project management
Create Azure SQL Database, HDInsight cluster, HBase, and Hive tables on Azure POC platform

DBA / Developer

Confidential, Secaucus, NJ

Responsibilities:

Designed and documented database architecture, created logical and physical data models
Managed database security, data quality, integrity, and job automation
Monitored and tuned application performance, optimize queries. Managed Backup and Recovery
Developed and implemented SSIS packages to validate data, transform, map, load and refresh data into Database and data Warehouse from multiple sources
Wrote Stored Procedures/Functions/Triggers to implement pre-defined business rules and metrics
Designed and created OLAP Cubes and Analytics Reports using SSAS and SSRS
Provided function design and coding standards to developers, tested and deployed development code to production, managed source code

Data Warehouse Specialist

Confidential, Somerset, NJ

Responsibilities:

Developed and optimized ETL processes to support data loading from disparate systems into Data Warehouse. The processes utilizing SSIS Packages
T-SQL and Stored Procedures to load, transform, cleanse and merge data, map and load data into Data Warehouse Dimension and Fact tables. Tuned SSIS packages performance for high volume data loads
Data sources include Oracle, SQL Server databases, XML files, Excel, CSV and Text files
Designed, developed and implemented Dimensions, Hierarchies, OLAP Cubes using SQL Server Analysis Service, developed calculated measures. Helped business users connect OLAP Cubes via Excel
Worked with business users to collect requirements, developed ad-hoc and scheduled Reports using SSRS and Excel

Database Developer

Confidential, Warminster, PA

Responsibilities:

Created logical and physical data models, created and maintained database objects
Developed XML, T-SQL, Stored Procedures, Functions, Triggers and SSIS packages

Sr. DBA / Developer

Confidential, New York, NY

Responsibilities:

Created physical/logical data modeling, designed and implemented Normalized and Dimensional tables
Managed system capacity, data security, integrity, database upgrade/migration, performance, backup/recovery
Developed and maintained PL/SQL packages and procedures for database applications
Analyzed, validated and integrated disparate data sources, developed and implemented ETL processes using DTS/SSIS, Stored Procedures, mapped and loaded data into Data Warehouse
Created operation reports utilizing Cognos and MS Excel