Data Management Analyst Resume San Antonio, TX - Hire IT People

SUMMARY

Proficient in SQL Server Database/Data Warehouse project and currently looking for a SQL Server DB/DWH Developer, Data Analytics, machine learning job opportunity.
6 years of data field work experience cross through SQL/Oracle RDBMS, testing, and programming.
Analyzing, designing, tuning and developing client/server, Business Intelligence (BI) database application, using (SSIS, SSRS, and SSAS) in MS SQL Server 2008 R2/2014.
Excellent team member with good interpersonal relations, strong communication skills, hardworking, high level of motivation, ability to perform well in a group and independently.

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

Data Management Analyst

Responsibilities:

A Key - person of contact of month-end processing to make the data deliver with accuracy in time each month.
Developing procedures, SSIS packages, Quantemplate pipeline to enhance and cleansing transactions data to data warehouse during the month-end processing.
Successfully reduced one part of the periodic month-end process from hours to seconds.
ETL mapping from transaction database to data warehouse.
Analyzed the root cause of data warehouse support incidents caused by, out of balance issue, data inconsistency.
Initiated, developed, and tested table partition auto management for faster data query,
Completed various development and testing cycle with minimum instructions.

Confidential, Oak Brook, IL

MDM Project Developer

Responsibilities:

Worked in Agile Scrum environment for Master Data Management Projects.
Incident Management and Production Support via Service Center and HPQC. Composed and implemented test cases and unit tests.
Created stored procedures, views, tables in SQL Server 2014 Management Studio. Developed SSIS packages using Visual Studio 2013 Data Tools.
Maintained master data elements: People, Location, and Contact information.
Implemented source control in TFS and deployed to server. Familiar with software development lifecycle in development, quality assurance, and production environment.
Collaborated with UI team in Meta Master Data Catalog Project. Backup, restore, and refresh databases objects. Developed Data modeling, Schemas and tables.

Confidential, Algonquin, IL

SQL Server BI Developer

Responsibilities:

Exposure to database operation in Development, Test, and Production environments.
Built the disaster recovery plan including inventory core business functions, processes, and identify data priorities. Tuning queries through execution plan.
Designed Key Performance Indicator and calculated field in Dashboard, PowerPivot and Database Programming in SQL, PL/SQL and T-SQL.
Developed reports with SSRS 2008 R2, Report builder 3.0. Managed, secured and subscripted reports and deployed reports through SSRS Server and IFS Quick Report catalog to clients.

Confidential, Rolling Meadows, IL

SQL Server DB Developer

Responsibilities:

Developed data modeling for database and data warehouse in SQL Server Management Studio. Utilized normalization and denormalization to minimize redundancy and to optimize the read performance of database.
Utilized Execution Plan, Data Profiler, and Database Engine Tuning Advisor with ETL processes to ensure the quality of data and to improve queries and database objects (Tables, Indexes, and Store Procedures).
Maintained the database statistics to enhance database performance.
Developed reports like drill down, linked reports, dashboard with SharePoint 2010 PerformancePoint service and interactive reports for client demands. Worked with business analyst, IT manager to develop report solution.

Confidential, Dallas, TX

Computer Lab Assistant

Responsibilities:

Confidential

Database Administrator Assistant

Responsibilities:

Performed database setup, upgrades, and recovery. Maintained, validated backup plan, and performed backup the database to ensure its accessibility.
Performed stress testing for 24 regional school’s database which ensure stability of systems. Routine inspected and evaluated school’s database performance and robustness.
Implemented database security, created SQL Server logins, database user Ids, and roles. Provided 24x7 on call support in a rotation. Implemented High Availability solutions including Database Mirroring and Always On Availability Group.
Daily checked server disk space, job failures, system check, application connectivity, replication health status to reduce server downtime for saving company profit.
Identified, analyzed, and documented software defects in program functions, outputs, online screens and content. Identified program variance from functional requirements, and recommended modifications for standardization and increased usability.