Resume

Sign in

Data Project Management

Location:
Nyack, New York, 10960, United States
Posted:
October 06, 2016

Contact this candidate

EDUCATION

University at Albany, State University of New York, Albany, NY

Bachelors Degree – Information Science; Minor: Business May 2012

Information Science GPA: 3.5 Commutative GPA: 3.07

Academic Honors: Dean's List

Study Abroad: Chengdu University, China May 2011 - July 2011

oStudied Chinese language and culture.

oTaught English class to children, and adults.

TECHNICAL SKILLS

MySQL programming

Experience using SSIS

Knowledge of SQL & relational databases

Project management

HTML/ CSS

Linux shell scripting

Lean Six Sigma Green Belt Certification

Strong SQL and Database Administrator experience

Data Modeling / Database Design

Basic java programming knowledge for web applications

Communicate technical concepts clearly and effectively

SQL Server 2008/2012/2014

Experience using SSIS for data integration

Experience creating SSRS reports for big data initiatives

Informatica

Microsoft office suite

Financial and municipal data knowledge

Experience using Talend

Experience using Jenkins

Experience using JIRA

Experience using SVN

Strong problem solving skills

Healthcare data knowledge

Passion for learning and teaching colleagues

Self-starting and quick learner

Strong documentation skills

Strong performance tuning skills

Strong interpersonal skills and willing to be a team player

Able to juggle several projects in a high intensity environment.

I.T EXPERIENCE

Lumesis inc, Stamford, Connecticut, ETL Administrator Mar. 2015 – Nov.2015

Maintain day to day data operations while constantly researching and implementing new ways to automate ETL data process.

Used MySQL for database manipulation and integration for data warehouse initiatives

Used Jenkins for automated intergration for java based programs as well as linux/batch scripting process.

Use Talend and some java programming to create automatized process to import and export data

Write Linux scripts along with T-SQL to automatically import, export data and send email alerts to various teams and clients

work with project management team to meet business rule expectations for automated process

3M Health Information Systems, Troy, New York, Associate Data Developer Sept. 2012 – Mar. 2015

Technical lead for New York state and Pennsylvania statistical hospital data.

Use Informatica and SSIS to perform ETL services.

Use SQL server 2008 and 2012

SharePoint development for internal management use and for internal data publishing.

Use a combination of XMl format files and SQL programing for data integration.

Write stored procedures,T-SQL, Dynamic SQL, functions, views, triggers and other queries to process medical data and to support data warehousing initiatives for over 200 terabytes(200TB) of data.

Write T-SQL scripts for processing medical data for production dashboard.

Create automated process to validate information and translate data into our in-house data warehouse.

Perform peer code reviews, debugging, and troubleshooting SQL scripts.

Manage and kept track of the roles and task of several developers to ensure product validation.

Recognize processing issues, create appropriate solutions in a timely fashion and assign task to solve the problem.

Host monthly meeting's that included DBA's, Management and other developers to plan and implement product life cycle from integration to production.

Work with client services to create business rules and meet the clients data needs

Maintain CMS and 3M standards for tables across various servers.

Manage all backup files being made in the data services department.

Create and update documents that describe complex procedures.

Work successfully with Developers and Data Implementation team to transition development changes into production.

Use project management tool (JIRA) to track and document all production changes.

Use JIRA to assign projects, and bug fixes and see them through to their conclusion.

Worked with clients to create data formatting standards for FTP data integration.

Managed and organized all FTP clients as well as created s

Participate in data modeling / database design and implementing Big Data solutions

Conduct code testing and used Visual source safe (VSS) and SVN to maintain sql script versions

Assist in training new data operators.

Empire State Development, Manhattan, NY, Summer Intern Summer 2011

Assisted with management and maintenance of computer software and hardware.

Trained users on computer software while solving computer related issues.

Repaired computers using harvested parts.

Prepared video conferencing system.

Teaching Assistant, Internet and Information Access, College of Computing & Information Fall 2011

Assisted course instructor with grading and class lecture for class of 350 students

Provided tutoring assistance during regular office hours.

New York State Assembly Office, Albany, NY, Legislative Intern Jan 2012 – June 2012

Managed and responded to constituent letters.

Conducted meetings with lobbyist.

Aided in legislative affairs.

Educated on the legislative process.



Contact this candidate