rochester Minnesota, US
Phone: xxx-xxx-xxxx
Email: xxx@xxxx.xxx
Looking For: Project Analyst, Project Coordinator
Occupation: Business and Finance
Degree: Master's Degree
Career Level: Experienced
Languages: Vietnamese, English
Highlights:
Skills:Data Analyst, SSRS, SSIS, Microsoft Office Suites, Rapid SQL, IBM InfoSphere, Microsoft Project, PMP, Agile Methodology, Project Life Cycle, Data profiling, Project Planning, Negotiation, Decision Making
Membership:PMI, Phi Theta Kappa
Certification:Project Management Professionals
Data Analyst 03/2015 - current
Mayo Clinic, rochester, Minnesota United States
Industry: Healthcare
This project calls for the development of a comprehensive IT enabled solution to help support an Enterprise wide medication diversion surveillance program. A comprehensive and sustainable state of the art enterprise wide drug diversion program requires advanced technological and analytical support. Mayo has had significant diversion episodes that have received national attention and impacted both patients and Mayo Clinic’s reputation.
• Identified the changes and constraints in new schemas that includes new columns, tables, primary and foreign keys and used T-SQL to write scripts to apply changes, transform the data; and developed T-SQL procedures and triggers to modify the data and to truncate, create and import data.
• Developed T-SQL queries for table creation, created stored procedures, views, triggers, and tested tables by using input values in banks BI schema structure.
• Maintained the table performance by following the tuning tips like Normalization, Creating Indexes.
• Created test cases, data profile for source to target mapping ETL jobs.
• Practiced and implemented Agile methodology for Software developing cycle.--
SQL Developer 05/2014 - 12/2014
Hinduja Global Solutions, Peoria, Illinois United States
HGS is a world leader in customer relationship management and business process outsourcing. HGS provides contact center services, back office processing and IT solutions to a global clientele comprising several Fortune 500 Companies. This project engaged with analyzing and completing client data per requests. Completed cleaning, duplication, and migration of database for end client.
• Merged and converted historical data from multiple flat files, current database, and FoxPro database into a new master database.
• Identified the changes and constraints in new schemas that includes new columns, tables, primary and foreign keys and used T-SQL to write scripts to apply changes, transform the data; and developed T-SQL procedures and triggers to modify the data and to truncate, create and import data/
• Designed, developed, implemented Stored Procedures and Triggers for automating tasks, and debugged stored procedures in MS SQL Server 2012 to load the data into consolidated database.
• Developed T-SQL queries for table creation, created stored procedures, views, triggers, and tested tables by using input values in banks BI schema structure.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub. Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.
• Maintained the table performance by following the tuning tips like Normalization, Creating Indexes.
• Created highly complex SSIS packages with File Watcher Task and used various Data transformations like conditional splitting, For Each Loop, Multi Cast, Data conversion, error handing to import client data from multiple flat files and post into staging tables for processing.
Environment: MS SQL Server 2012/2008R2, SQL Integration Services 2012/2008R2 , SCRIPT, Windows 7, Visio, MS Excel, CSV--
University of Houston 08/2008 - 12/2010
Houston, TX, United States
Degree: Bachelor's Degree
Major:Management Information System
Bachelor in Administration degree with concentration on Management Information System