SQL/SSIS/SSRS Support/Developer Resume

SUMMARY

Over 15 years of experience in the IT industry, focusing the last 10+ years on Crystal Reports,Foxpro,VB6,VB.NET, C#, SSIS, SSRS, SQL Server 2000/2008/2012.
Excellent interpersonal and communication skills and would be an asset to any development team.
Self - starter and a team player. Able to handle entire software development life cycle: specifications, design, coding, testing, debugging, development of diagrams and software documents.
Strong organizational and multi-tasking skills
Bilingual (English/Spanish)

PROFESSIONAL EXPERIENCE

Confidential

SQL/SSIS/SSRS Support/Developer

Responsibilities:

Manage SSRS Subscriptions and User Access Security.
Create custom reports for different departments within the Hospital (Radiology, Accounting, Oncology, Admissions).
Create SQL Triggers that update various database tables used across departments and sends notification emails.
Write complex SQL queries for validating the data against different kinds of data sources.
Create ETL Processes to move data from EPIC into SQL.
Perform data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Excel and SQL.
Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
Develop Stored Procedures, Functions, Views, Triggers, Indexes, constraints etc.
Create SSRS Reports.
Re-write SAP BOE Crystal Reports to SSRS.
Created console apps for nightly process using SSIS and C#.
Design and developed processes to import data from different sources, Oracle, Excel and ASCII files.

Confidential

.NET/SQL/SSRS Developer

Responsibilities:

Created SQL Triggers that update various database tables used across departments and sends notification emails.
Implemented Data quality Strategy in creating SSIS Packages that perform Data Profiling, Cleansing & Auditing based upon the business rules.
Created database schema, T-SQL Stored Procedures, User defined functions in SQL Server 2012 to Implement migration of FOXPRO Scrap application.
Created ETL Mapping document that illustrates the source-to-target mapping and data conversion rules.
Created T-SQL scripts for legacy data cleansing and scrubbing legacy data imported from FOXPRO.
Rewrote Crystal Reports 11 to SSRS.
Closely worked with the users of the various application to review the business requirements and translated them into database objects.
Eliminated manual intervention in the order entry system and automated the process of data exchange between various plant departments.
Wrote EDMS Windows App from VB6 to VB.NET (WinApp).
Rewrote ERP legacy system from VB6 to VB.NET.
Developed and implemented solutions using VB.NET 4.0/ASP/SQL SERVER 2008 to integrate and automate the process of Order Entry System across Marketing, Engineering and Manufacturing departments.
Developed Purchase Order System (WebApp) using VB.NET 4.0/ASP/SQL Server.
Created program to display different Financial Reports in one screen using WPF 3.0. (Windows Form VB.NET). Created 4 different containers in the main form, each one displaying and having their own events. Allow user interaction on each container. Create Animation. showing daily production goals.

Confidential

HRIS SQL Developer (Remote)

Responsibilities:

Provided programming support to their Global Time and Attendance and Payroll System using VB.NET/SQL Server 2005 and JavaScript Web App.
Developed SSIS packages to batch process data at night and load it into SQL Server.
Provided Production Support 24/7.
Developed SSIS Packages to process HR Files at night. These files were created by Workday HR System in XML. Use XSLT transformation programs, inside a SSIS package to convert the original XML schema and save results in a SSIS Variable, the import the data using a Data Task into SQL Tables.
Create Time & Attendance Reports using SSRS.
Setup SQL Server jobs to call SSIS Packages.
Call SSIS Packages from VB.NET WebApp to import Excel Files.
Develop JavaScript to handle client side events.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship