SUMMARY

I am seeking a challenging career in software development where my programming skills in SQL Server, SQL Reporting Services (SSRS), SSIS, SSDT, BIDS, Crystal Reports, SAP Business Intelligence/Business Objects (Designer; Query as a Web Services; Web Intelligence; CMC) and VB Script can be utilized.

TECHNICAL SKILLS

• SQL Server
• SSRS
• SSIS
• SSDT
• DTS
• ETL
• LINQ Data Access
• Visual Studio (2013
• 2012
• 10
• 9)
• Crystal Reports
• Business Intelligence/Business Objects
• Rapid SQL
• Access
• My SQL
• Oracle 7 & 8
• Erwin
• MS Office 2000
• MS Office 2016
• Windows 2007
• Windows 2000
• Windows 2010
• Windows NT
• MS Project
• TFS
• Visual Source Safe
• PVCS Version Mgr.
• Visual Basic (5,6)

PROFESSIONAL EXPERIENCE

Sr. SQL

Confidential, Boston, MA

Responsibilities:

Design, architect and implement successful WEBI Reports and Business Intelligence solutions related to Retail and Digital data for clients. I have created and updated the Universe by gathering requirements from business users and upper management to create WEBI. I have scheduled and published WEBI Reports through CMC.

Created tables, CTE, views, functions, triggers and stored procedures for reporting databases.

I have built T - SQL scripts, stored procedures, functions and complex queries in SQL Server to meet client needs and for data analysis and extraction. I have enhanced existing stored procedures to run faster.

I have designed and created SSIS packages using SSDT and maintained existing ones, which involved converting and transforming data (using different transformations) received through flat files from different sources and enterprise level data into a single repository for reporting purposes. I have created stored procedures to do some of the transformations and loading of the data into target tables in SSIS packages and created scheduling and monitoring of those jobs.

I have created SSRS reports for Europe since their data is in SQL Server 2014. Have created reports using, sub-reports and drill-through and drill-down reports and parameterized reports and for some users I have created linked reports where the user got to see data for a region and just gave them the link to it. And also scheduled and published some of the reports.

Environment: Windows 7, Windows 2000, Windows 2010

Tools: Confidential, Microsoft Visual Studio (2008, 2012, 2013)

Platforms: SQL Server (2008, 2012, 2014), SSRS, SSIS, SSDT, Webi Reports-SAP Business Objects v3.1 /v4

Sr. SQL / Confidential Developer

Confidential, Buffalo, NY

Responsibilities:

Designed and created SQL stored procedures and SAP Crystal Reports and created sub-reports and LOV’s for the Internal Audit Project. Altered and successfully implemented existing SAP Crystal Reports and also implemented changes on complex stored procedures for the reports. Wrote SQL scripts and stored procedures to load tables for Data Warehouse and performance tuning old stored procedures (using execution plan since we did not have access to others). Created and updated the Universe by gathering requirements from business users and upper management to create WEBI, Crystal Reports and SSRS. Built T-SQL scripts, stored procedures, functions, and complex queries in SQL Server to meet client needs and for data analysis and extraction. I have enhanced existing stored procedures to run faster. Created tables, views, functions, triggers and stored procedures for our Reporting Database.

Environment: Windows 7, Windows 2000

Tools: Confidential, Microsoft Visual Studio (2008, 2012)

Platforms: SQL Server (2008, 2012), SSRS, SSDT, BIDS, Webi Reports - SAP Business Objects v4, Crystal Reports v11, QlikView

Sr. IT Software Engineer

Confidential, Highlands Ranch, CO

Responsibilities:

Designed, architect and implemented successful SSRS Reports and Business Intelligence solutions related to Borrower and Loan data for clients. Worked closely with Solution Architects, Developers and Data Analysts to develop business intelligence solutions that promote reusability and standardization. Have extensive knowledge in SAP BusinessObjects including Universe design and reporting. Built T-SQL scripts, stored procedures, functions and complex queries on SQL Server 2008 to meet customer needs and for data analysis and extraction.

Nsight Production Support/Projects - Worked with Business Users to understand the requirements and implement solutions by creating or modifying complex SQL stored procedures, universes, Webi Reports and SSRS.

School Portfolio Project - Worked with National Manager to understand the requirements and designed and implemented an Enterprise solution to meet their needs. This project included multiple complex stored procedures, new database tables, Universe and Webi report. The report contained 4 sections: Graph, overall Nelnet Portfolio, school owned loans and dashboard for Nelnet owned loans. It was a bursted report that pushed customized data in the report to over 10,000 school associates via email.

Environment: Windows 7, Windows 2000

Tools: Microsoft Visual Studio, TFS

Platforms: SQL Server (2008, 2012), Webi Reports - SAP Business Objects, SSRS, SSIS, SSDT, BIDS

Sr. Information Technology Database Analyst

Confidential

Responsibilities:

Project 4Sight - Master Data Module: Worked with Business Users to understand the requirements and implement the consolidation of All 4 Legacy System. Created and maintained DB for 4Sight Staging Master Data/Organization for the implementation for Credit/Vanguard R1. Wrote SQL scripts for each of the 4 Legacy Systems (Passport, Passkey, Premier and Xpress) for loading Staging Master Data/Organization Tables for R1 Credit/Vanguard. Designed and created Cross System Reports (across All 4 Legacy System) in SSRS. Created and maintained stored procedures for these reports.

Designed and created Reconciliation Reports in SAP Business Objects. Designed and implemented Confidential solutions related to Organization, Location and Contacts Data. Responsibilities included creating and designing Data Warehouse, ETL (Data Services/SSIS), BO Universe. Worked on R2-Data load for Location and Contacts (All 4 legacy System) using SSIS packages. Researched and implemented the data conversion and combination of organization info, Location and Contacts info from All 4 Systems. Ensured SOX compliance of Change management, Security, Batch Scheduling and SDLC procedures.

Project Management Office: Worked on different projects for the enhancement for Passport App, Visa and West Pipe Connect projects. Worked with the Business Users to understand the requirements and implement the changes by creating or modifying SQL stored procedures, triggers, cursors and wrote SQL scripts for Data Fix. Created and modified reports in using Crystal Reports and SSRS. Ensured SOX compliance of Change management, Security, Batch Scheduling and SDLC procedures.

Passport/Visa Production Support (Nominations and Scheduling): Worked with the Business Users to understand the requirements and implement the changes by creating or modifying SQL stored procedures, triggers, cursors and wrote SQL scripts for Data Fix. Created and modified reports in using Crystal Reports and SSRS. Ensured SOX compliance of Change management, Security, Batch Scheduling and SDLC procedures.

Environment: Windows 7, Windows 2000

Tools: Rapid SQL, Confidential, Microsoft Visual Studio, TFS, Serena Team Track, PVCS Version Mgr.

Platforms: SQL Server (2008, 2005, 2000), Oracle, SQL Server Reporting ServicesWebi Reports: SAP Business Objects, SSRS, Crystal Reports