Data Analyst - ETL Developer Resume - Hire IT People

TECHNICAL SKILLS:

Strengths: Technical/Business knowledge, Business Analysis, SQL Server database development, Report writing, ETL, Data Base Design, Data Warehouse, Business Intelligence

Business Knowledge: Healthcare administration, higher education, software development

Programming Languages: SQL (T - SQL), Crystal Reports, SSRS, ETL(SSIS), Excel, PL/SQL

Database Management Systems: SQL Server 2000-2016, MS Access. Oracle

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst - ETL Developer

Responsibilities:

Responsible for automating client transaction feeds. Developed and implemented
SSIS packages, SQL queries/stored procedures to accomplish this.
Worked with 3rd party vendor of SSIS addins to enhance the functionality of native SSISespecially in the area of secure FTP
Put in place processes to change corporate culture from one embracing manual manipulation of client data to secure, automated processing with appropriate controls and

Confidential

SQL Developer/ Report Writer

Responsibilities:

Responsible for Data Analysis and Report Writing for the data bases that support the manufacturing, quality control and document management systems used to support the company’s manufacturing processes
Responsible for the CATSWEB system. CATSWeb is an industry standard software product which is used to track change controls, SOPs, policies and procedures, regulatory or compliance requirements and all relevant standards for support and maintenance of quality information systems.
Wrote ETL(SSIS packages) and SSRS Reports to provide business metrics that the CATSWeb system did not provide.

Confidential

Database/Data Warehouse Developer-Report Developer-System Analyst

Responsibilities:

Gather and document user specifications
Analyze SQL Server Data Warehouse to match reporting requirements with data
Develop and Implement new database objects (tables, views) for reporting purposes using T-SQL
Create sophisticated queries/stored procedures to meet reporting needs using T-SQL
Develop and implement reports using Crystal Reports

Confidential - Cambridge, MA

Data Analyst

Responsibilities:

Developed automated processes for insuring the integrity of the College’s Admissions, Registration and Faculty data. This was accomplished using SQL Server stored procedures.
Developed and deployed reports to provide operational and analytical information to the college administration.
Wrote stored procedures, functions and SSIS packages to implement these processes. The most notable was an SSIS package that analyzed the database for courses ending within a specified time, extracted the student information from these courses, transforming it into the format required mandated by the vendor of an Online Course Evaluation service, FTPed it to the Vendor’s FTP site and archived the results into a date stamped file for user access.

Confidential - Needham, MA

Database Developer/ Administrator

Responsibilities:

Wrote and modified queries and stored procedures to meet business needs
Created new database tables to enable new business requirements
Represented the interests of the database in staff meetings

Confidential - Newton, MA

Database Developer/Analyst

Responsibilities:

Managed campus wide administrative system from third party vendor. Determined user department’s business needs and determined the optimal manner to utilize the system to meet those needs.
Wrote subsystems to provide added functionality not in vendor product
Primary Report Creator for the College. Wrote and modified reports using Crystal Reports.
Especially skilled in eliciting requirements from end users when they are not necessarily certain of their requirements or what data is available to them.
Developed data stores (data models) to present data to end users in a manner enabling them to do their own reporting
Served as Database Administrator (DBA) for Microsoft SQL Server 2000/2005 servers
Wrote DTS scripts for data import
Worked very closely with end users gathering requirements for enhancements, troubleshooting, etc.

We provide IT Staff Augmentation Services!

Data Analyst - Etl Developer Resume

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship