SUMMARY:

• Requirements gathering
• Database design and development
• T - SQL Stored Procedure development
• SSIS ETL design and development
• Report design and development
• MS Access data migration to MS SQL Server
• DB2 AS400 data migration to MS SQL Server
• Application design/development utilizing COBOL, VB.NET
• Basic knowledge of C#
• Fundamental knowledge of Tableau data visualization concepts and data connections
• Experienced developing reports utilizing T-SQL and DB2 SQL Stored Procedures, Crystal Reports, SSRS, MS Access

PROFESSIONAL EXPERIENCE:

Confidential

Data Programmer Analyst

Responsibilities:

• Designed methods to extract patient financial data from care provider s databases
• Designed and implemented ETL SSIS packages to extract data to facilitate collection efforts
• Package design included variables, parameters, expressions, script tasks
• Collaborated with business partners during efforts to design databases for imported data
• Designed and managed databases
• Setup of SQL Server Agent Jobs to control SSIS extracts, automate SQL scripts and other processes
• Designed/developed advanced SQL stored procedures to query databases on multiple servers
• Developed ad - hoc and scheduled SSRS reports
• Developed basic Tableau data visualization reports
• Maintained all data warehouse SSIS ETL code
• ETL code under source control utilizing Team Foundation Server
• Developed SQL Stored procedures to query dimension and fact tables in data warehouse
• Developed SQL Stored procedures to query Allscripts/PFM database
• Performed troubleshooting of PFM CACHE database
• Performed data analysis to ensure the availability of accurate data
• Setup and maintained MoveIt application SFTP tasks enabling scheduled file transfers
• Created scripts to automate database restores, SQL Server login/user creation
• Negotiated purchase of software and performed installation of software

Confidential

Reports Analyst

Responsibilities:

• Performed analysis of business requirements and data, in support of mortgage default services
• Designed and developed database to house aggregated data as a data source for client facing reports
• Designed and developed T - SQL stored procedures to extract, aggregate, transform, and insert data
• Developed client facing reports utilizing Crystal Reports 2008
• Performed data analysis and database research to identify location of data columns
• Automated ad-hoc reports for anytime availability utilizing t-SQL stored procedures
• Support/troubleshoot and maintain MS Access SQL and VBA scripts
• Support/troubleshooting and maintenance of T-SQL stored procedures and Crystal reports

Confidential

Database Analyst

Responsibilities:

• ISeries DB2 SQL, T - SQL Procs, SSRS, MS Access 97 & 2000,ASP.NET,VB.NET
• Application development utilizing VB.NET/ASP.NET with AJAX controls.
• Evaluated existing MS Access database applications and re-engineered using T-SQL and VB.NET
• Performed analysis of raw data for the purpose of resolving discrepancies anddiscovering anomalies
• Performed analysis of existing reporting system in an effort to develop a morerobust and dynamic BI environment
• Created DB2 SQL statements and T-SQL procedures to extract data from AS400 into
• SQL Server 2005 to build SQL Server report data sources
• Created and maintained SQL Server scheduled jobs, executing stored procedures for the purpose of extracting data from DB2 into SQL Server 2005
• Created and maintained database backups of Report Server and reports related databases
• Automated manual MS Access report processes
• Converted redundant MS Access reports to SSRS reports by utilizing parametersallowing the use of one report to deliver required data based on diverse criteria
• Migrated complex MS Access reports, queries, tables, and VBA modules to SQLServer/SSRS 2005
• Gathered requirements and developed new reports used in late payment and default tracking, inventory control, warranty service claim discrepancies, etc
• Installed/configured SQL Server 2005 Reporting Services (production system in native mode and test system in Sharepoint integration mode)
• Installed/configured SQL Server 2005 (including host OS Win 2003)
• Setup and maintained SQL Server logins and users
• Setup and maintained SSRS security roles

Confidential

Report Developer

Responsibilities:

• Modified existing XGEN COBOL applications and reports
• Designed, developed, and implemented batch/online Xgen COBOL applications.
• Liaison to manufacturing facility.
• Coordinated IT efforts between manufacturing facility and parent company and assisted/fulfilled Information Systems requests.
• Gathered business and manufacturing requirements
• Designed and analyzed Reports using Crystal Report reporting tool.
• Set priorities for migration of manufacturing ERP to SYSPRO ERP system
• Researched, Installed and configured Virtual PC for the purpose of creating a test environment.
• Installed and evaluated SYSPRO ERP modules
• Hardware and software troubleshooting - resolved technical issues associated with install of SYSPRO ERP system
• Researched and resolved connectivity and speed issues associated with ERP client software
• Communicated project status to supervisors and project sponsors at key milestones and maintained lines of communication between vendor and business units.
• Developed PO front end using VB.Net and Visual Studio 2005, for the purpose of interfacing with ERP PO module. The interface was accomplished through the use of XML strings.
• Reengineered COBOL reports and developed new reports utilizing Crystal Reports 10 and T-SQL 2000 stored procedures
• Created Stored Procedures on SQL Server 2000