We provide IT Staff Augmentation Services!

Consultant Resume

SUMMARY:

  • Twenty years experience Database and Application Development with diverse industry experience in banking, health care, manufacturing, and government. Professional expertise includes business intelligence, database design, legacy data conversion, systems migration - integration, and reporting systems.
  • Expert SQL programmer C # Developer
  • SQL Server Integration Services (SSIS) Reporting Services (SSRS)
  • Analysis Services Development (SSAS) DBA experience
  • Requirements analysis and design Access/Excel VBA developer

TECHNICAL SKILLS:

  • SQL programming / Stored procedures Expert 20 12/20/2014
  • SSIS and Confidential development Very Strong 9 12/26/2014
  • SQL Server Analysis Services SSAS Strong 3 4/20/2014
  • SQL Server Reporting Services SSRS Very Strong 4 7/20/2014
  • Visual Basic Expert 19 9/12/2013
  • C # programming/scripting strong 3 12/20/2014

PROFESSIONAL EXPERIENCE:

Consultant

Confidential

Responsibilities:

  • Developed processes to support the ERP system with SSIS, SQL Stored procedures.
  • The SSIS packages are parameter driven and invoke stored procedures to move data from the ERP system to a data warehouse.

Consultant

Confidential

Responsibilities:

  • Developed ETL Processes for support of the 340B Pharmaceutical managmenent product with SSIS, SQL Stored procedures, and C # scripting.
  • The SSIS packages where parameter driven and invoked stored procedures to create file output for customer consumption.
  • In addition developed stored procedures that would consume customer files and process them into various database tables.

Consultant

Confidential

Responsibilities:

  • Developed ETL solution for migration of Zuora Financial cloud data into Staging Database using C Sharp and the Zuora API Web Service.
  • Migrated SQL Server 2008 R2 SSIS ETL system to SQL Server 2012.
  • Developed ETL System using SSIS and Stored Procedures.to migrate Staging data to an Operational Data Store and finally to a Data Warehouse.

ETL Developer

Confidential

Responsibilities:

  • Developed and enhanced SSIS packages and SSRS reports for the sales support team.
  • Developed ad hoc report solutions in SSRS.
  • Help troubleshoot issues in existing ETL systems to improve efficiencies and functionality.

Consultant

Confidential, Minneapolis, MN

Responsibilities:

  • Created a SQL Server Integration Services (SSIS) application for client startup company ( Confidential ) to transfer files via SFTP and into a SQL sever data warehouse staging environment. Upon landing files and migrating into staging area, did data quality analysis and reporting of anomalies to assure data ready for move into operational data store (ODS).
  • Developed SQL Server Analysis Services cubes for the Fairview Pharmacy Services client. Gathered the requirements, designed dimensional including the hierarchies for the models, developed and tested and deployed the cubes for the client. Business stakeholders included Supply Chain, Financial Services, and the 340 B Program Management groups.
  • Designed, developed and implemented Reporting Services reports for two clients - Fairview Pharmacy Services and the Clearscript Pharmacy Benefit Manager (PBM).
  • Migrated legacy Confidential system to new SSIS Processes for updated Confidential conversions. This was for he CHS client

Software Test Engineer

Confidential, Minneapolis , MN

Responsibilities:

  • Developed test system for Intersystem Ensemble interop application.

ETL Developer

Confidential, Minneapolis, MN

Responsibilities:

  • Developed ETL processes for Confidential Inc.
  • Using Betrieve ETL tools including Schema Designer, Process
  • Designer, and Map Designer, converted client files into the Confidential 's proprietary collection system.

Consultant SQL Server/Excel

Confidential, Minneapolis, MN

Responsibilities:

  • Created a reporting system through Excel to retrieve data residing in SQL Server.
  • Short term engagement that involved development implementation and client teaching of the reporting application.
  • Implemented stored procedures for report table population.
  • Coded the Excel VBA application that would retrieve data and populate Excel output using Excel Objects and SQL OLE DB within VBA.
  • Mentored and trained client on the application and tools to maintain and enhance the application.

ETL Developer

Confidential, Minneapolis, MN

Responsibilities:

  • Developed Confidential and SSIS packages for medical device manufacturing system conversion.
  • Extensive use of Confidential and
  • SSIS technologies for ETL processing including complex stored procedures and scripting tasks in VB.net. Schedule jobs for ongoing data processing in SQL Server and a Fourth Shift manufacturing database and Matrix application to the reporting database.
  • Helped produce data tables and queries for a Crystal Reports Business Objects reporting environment.

ETL Developer

Confidential, Minneapolis, MN

Responsibilities:

  • Developed stored procedures Confidential and SSIS packages for database marketing systems.
  • Extensive use of SSIS technologies for ETL processing including stored procedure and scripting tasks in VB.net.
  • Ongoing importing from client systems into company database using SSIS FTP tasks and data transfer from flat files into company's database.
  • Ongoing support of database system backup and monitoring of imported data including data validation and issue resolution of client data.

ETL Developer

Confidential, Mendota Heights, MN

Responsibilities:

  • Developed stored procedures for company's actuarial systems in SQL Server 2005.
  • Wrote integration packages in Confidential and SSIS for creating and moving data to various repositories.
  • Conversion of Confidential packages into SSIS packages.

Data Analyst

Confidential, Minneapolis, MA

Responsibilities:

  • Worked with auditors to generate data for recovery auditing purposes.
  • Work with very large client datasets to help auditors document claims submitted to vendors.
  • Wrote SQL code to improve business auditing practices and decision support capabilities and billing.
  • Query analysis and optimization to handle large datasets.
  • Data analysis of client datasets to fine new audit opportunities.

Report Developer

Confidential, Minneapolis, MA

Responsibilities:

  • Developed reports for the project planning and finance area with a Lawson Software application using Crystal Reports and queries from Oracle.
  • Also developed a SQL Server resource planning application that would export financial data to Excel.

Developer

Confidential, Minneapolis, MA

Responsibilities:

  • Developed database application to track revenue sources from administration fees and rebate programs from pharmaceutical manufacturers.
  • The application predicts accruals and variance from actual for the finance system using
  • SQL Server Transact SQL and Visual Basic.
  • Created Excel output from the database records and synchronized the changes to the Excel file within the SQL Server tables.

Confidential, Minneapolis, MN

Developer

Responsibilities:

  • Developed conversion application for the finance area for the MINCIS conversion.
  • Extensive programming with Transact-SQL to convert legacy mainframe systems to SQL SERVER 2000.
  • Developed error/exception handling routines to move data to tables for analysis and data cleanup.
  • Perform data gap analysis to determine missing or incomplete data.
  • Worked with Systems Analysis to fulfill specifications for target system.

Database Developer/Report Developer

Confidential, Minneapolis

Responsibilities:

  • Developed a Billing Management System using Visual Basic, SQL Server and Crystal Reports.
  • Implemented triggers, stored procedures and views to maintain business rules integrity.
  • Extensive use of views to produce reports with Crystal Reports.
  • Mentored one junior developer in areas of application development, database development techniques and Crystal Reports development, Transact SQL and SQL Query Analyzer.
  • Database maintenance, backup, nightly job scheduling.

Developer

Confidential, Vadnais Heights, MN

Responsibilities:

  • Database application development for Industrial SQL Server (ISQL) and MS SQL Server and Access.
  • Created stored procedures, views, and triggers. Database installation, tuning, backup, maintenance, and job scheduling for Confidential packages or stored procedures.
  • Created a report ActiveX with Visual Basic for deployment in an HMI interface.
  • Developed reports with Crystal Reports for all projects. mentored HMI developers in the use of Access, SQL Server in their projects.

Developer

Confidential, Vadnais Heights, MN

Responsibilities:

  • Mentoring a project team of five developers with implementing SQL Server development and reporting applications using
  • Crystal Reports for the Mortgage Document Center. Trained developers to implement SQL Server and database transformation queries for various output specifications.
  • Managed the transformation of legacy SQL code to stored procedures to improve performance and maintenance of the reporting application.

Consultant

Confidential, Hopkins, MN

Responsibilities:

  • Developed a decision support application to process loans for the Business Banking Credit Center.
  • Developed the major portion of the database schema and interface. Including SQL Server Installation and setup.
  • Lead the evolution through major version changes including the migration to a 32-bit VB6 application.
  • Mentored two full time employees of US Bank during this process.
  • The application evolved from an MS Access file system running in 16 bit mode to a fully functional client server system running on SQL Server.
  • Created the major modules including a database connection COM object to handle library changes upon platform changes.
  • Wrote the interface code to handle Btrieve database queries for a third party COM object.
  • Loan underwriters would use this application to capture client data, determine credit scores determine collateral requirements, loan risk and loan commitments (or denials).

Hire Now