We provide IT Staff Augmentation Services!

Ibm Sql Server And Business Intelligence Developer Consultant Resume

2.00/5 (Submit Your Rating)

Richfield, MN

Hire Now

SUMMARY:

  • To find a job in technology designing computer information systems, modifying systems to improve production and work flow, and expanding systems to serve new purposes.

TECHNICAL SKILLS:

Languages and Skills: VB6, VB.NET, ASP, ASP.NET, SQL, T - SQL, VBA, C#, SSIS, SSRS, VBScript, Perl, PL/SQL

Tools: Visual Studios 2003/2005/2008/2010/2012, Microsoft Office 2000/2003/2007/2010, SQL Server 2005/2008/2012, Siebel, Oracle, Windows Server 2008/2012, TOAD

PROFESSIONAL EXPERIENCE:

Confidential, Richfield, MN

IBM SQL Server and Business Intelligence Developer Consultant

Responsibilities:

  • Database Administrator for IBM databases which hold Best Buy store device and server data.
  • Replicated databases for different environments such as development, QA, and Production.
  • Wrote hundreds of scalable stored procedures and functions for various applications.
  • Created SSRS reporting website with Windows Server 2012 and SQL Server 2012.
  • Created SSRS reports and stored procedures based on project manager requirements that were used thousands of times a year.
  • Created SSIS packages to import Best Buy data into IBM databases to do differential comparisons.
  • Maintained, fixed, performance tuned, and hyper threaded slow SSIS packages already installed on the servers.
  • Created the database, scripts, stored procedures and functions for an ASP.net web portal that checked the health status of all networked devices like registers and scanners in every Best Buy store.
  • Security administrator for all IBM databases and some Best Buy databases.
  • Used PL/SQL to access data from other Best Buy consulting databases to create Oracle packages and write PL/SQL procedures to import their data into IBM databases.
Confidential, Bloomington, MN

VB.NET Developer Consultant

Responsibilities:

  • Created Excel reports for the Global Reporting application using VB.NET and SQL Server.
  • Added functionality and maintained Global Reporting application using C#.NET.
  • Worked with business analysts to gather reporting requirements.
  • Maintained and debugged existing Excel reports with VBA which were used by thousands of users.
  • Created and maintained scalable SQL stored procedures that were up to and exceeding thousands of lines.
Confidential, Bloomington, MN

VB.NET Developer Consultant

Responsibilities:

  • Converted Wachovia VB6 finance applications to integrate with VB.NET Confidential applications.
  • Created SSIS packages to clean Wachovia data and import into Confidential databases.
  • Created SSRS reports for QA to check for differences in Wachovia data being imported into Confidential databases.
  • Maintained C# Confidential accounting and finance applications.
Confidential, Minneapolis, MN

Marketing Data Specialist

Responsibilities:

  • Created Oracle queries that were scheduled daily to pull data for various coworkers needs.
  • Created automated marketing reports and dashboards with SSRS of markets and customers to identify industry patterns and trends.
  • Worked with outside clients and vendors to make ad-hoc reports based on data from CRM software Siebel.
  • Created SQL Server SSIS packages to transfer data into marketing databases from external and internal sources.
  • Converted VB6 legacy marketing applications into VB.NET applications.
Confidential, Fort Lauderdale, FL

Fixed Income Risk Analyst

Responsibilities:

  • Managed scripts and nightly batch jobs to create risk reports for portfolio managers daily.
  • Modeled fixed income securities for risk management software.
  • Automated the transfer of bond, equity, and derivative pricing and positions from internal accounting system to external vendor software using SQL Server DTS packages.
  • Traveled to Bombay, India for a month to teach new employees on how to use risk software and monitor nightly system jobs for risk reporting process.
  • Filled reporting requests and answered risk questions from global portfolio managers.
Confidential, Fort Lauderdale, FL

Business Systems Analyst

Responsibilities:

  • Fixed and improved existing MS Access databases and reporting tools using SQL and VBA.
  • Designed and created new Excel VBA macros to automate accounting functions.
  • Used ODBC connections to the AS400 mainframe to pull accounting data directly into MS Access and Excel.
  • Worked with supervisors and managers to gather, analyze and prioritize business and functional requirements for projects.
  • Trained and worked with accounting analysts on new macros, system features.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship