OBJECTIVE:

Looking for a technical Project Manager, Data and Reporting Integration position where I can share my skills and experience in software development lifecycle, data management and reporting. Interested in working in an Agile software development environment and leading systems development projects.

SUMMARY:

Over 20 years of experience in systems development. Positions ranging from Developer, Systems Administrator, DBA administrator, Systems Analyst, Report Developer and QA Tester. Currently using MS SQL Server with Data tools SSRS and SSIS, Tableau and TFS for source control. Experience with establishing change management procedures. Perform SCRUM Masters duties in an Agile development environment using JIRA and Confluence tools.

EXPERIENCE:

Confidential

Report Developer

Responsibilities:

• Developed a key reporting process using SSRS and SSIS to automate the generation of reports currently in a complex excel spreadsheet as PDF documents on a shared drive.
• This involved designing the database tables, ETL import/export processes, views, stored procedures, functions and a SQL job.
• Created numerous reports for Executives to support critical decision - making strategies for the fundraising campaign effort. Some of the technical implementation features with SSRS include: grouping, subgroups, cascading parameters, user selection of different sections to be displayed on the report, color shading of rows, SQL hierarchy table to roll up campaign data, drill down reports, freezing report rows and columns in the SharePoint environment, dynamic data in report headers, customized formatting and customized total lines.
• Developed extensive data queries along with scripts to generate the data dump to excel spreadsheet in support of a data modeling effort.
• Currently working on the migration of reports built in SSRS to Tableau.
• Assisted with the ETL SSIS build to extract data from the data warehouse to build TDEs on the Tableau server.
• Created dashboards to replicate the SSRS reports using crosstabs as well as various data visualizations to summarize data for users.

Confidential

Applications Analyst, Applications Support Engineer and DBA

Responsibilities:

• Acted as liaison between users and developers in defining functional and data requirements for SharePoint Forms, Work Flows, SSRS /Crystal Reports and applications. Developed Business Requirements Design (BRDs) documents to assist developers.
• BRDs consist of defining the functional process flow, the look and feel of the forms/reports (mock ups), database tables/fields/views, and all unique processing requirements.
• Provided technical and system administration customer support to ERP systems in the areas of manufacturing, shipping, labor-track, document management and document transfer.
• Performed version upgrade for application/SQL Server instance for OnBase, the document management system.
• Configured the scanning module for OnBase for documents to be swept into the import process for Document Control Center and automate the population of keywords from a custom query.
• Developed maintenance plans for production, development and testing of SQL Server databases.
• Team leader for the upgrade and migration of a Data Warehouse from SQL Server 2008 to SQL Server 2012.
• As part of the migration, I was responsible for moving stored procedures to a Data Store environment, the entities and enterprise data to a separate Data Warehouse.
• I developed reports in SQL Server Reporting Services (SSRS) and Crystal Reports in support of maintenance and user enhancement requests.
• Responsible for the system administration of SSRS on a SharePoint server providing user access as well as setting up the report subscriptions.
• Deployed reports, SQL Server jobs, and functional enhancements to the production environment.
• Installed SQL Server 2012 with data tools on several MS 2012 servers. Upgraded a case management database from SQL Server 2005 to SQL Server 2012.
• Provided support for applications and databases as required for Sarbanes-Oxley compliance.

Confidential

Data Analyst

Responsibilities:

• Responsible for populating voter registration data into a CRM solution to manage a campaign effort for a local candidate for Confidential .
• Transferring data from a MS Access database to MS SQL server 2012 using SSIS.

Confidential

Owner and instructor

Responsibilities:

• Kumon provides children the opportunity to master the foundation skills in math and reading through repetition and daily practice.
• Responsible for getting families interested in enrolling their children in the math/reading program by giving orientations to parents; hired, trained and managed up to 6 employees to help work with the children at the center; communicated with children and parents to give them up-to-date status on progress; prepared payroll, quarterly and annual taxes using Confidential ; ordered all inventory needed to run the center.

Confidential

Database Administrator

Responsibilities:

• Installed and upgraded versions of the Oracle RDBMS, developed PL/SQL scripts to replicate and synchronized databases on different servers, wrote PL/SQL scripts and stored procedures to migrate data from other sources to an Oracle database for a call center, performed analysis of database design to optimize and fine-tune processing speed and efficiency, developed PL/SQL scripts for backup/recovery procedures.
• Ensured database security and integrity of data via authentication and attribute constraints.
• Developed a customized system for a trucking company to manage the drivers and their loads using MS Access RDBMS and Crystal Reports.