LiveCareer-Resume

senior business intelligence developer resume example with 13+ years of experience

JC
Jessica Claire
Montgomery Street, San Francisco, CA 94105 (555) 432-1000, resumesample@example.com
Career Overview
Highly motivated Sales Associate with extensive customer service and sales experience. Outgoing sales professional with track record of driving increased sales, improving buying experience and elevating company profile with target market.
Qualifications
SQL Server 2000-2012; Oracle 10g-11g; SQL Server Integration Services and Data Transformation Services; SQL Server Reporting Services; Visual Studio 2005-2010; Microsoft Access 2003-2013; Crystal Reports 8.5-12; Microsoft Excel 2003-2013; creation of SQL queries, views, functions, and stored procedures. Proficient in T-SQL, PL/SQL, Jet SQL, VB.NET, and VBA; some experience with Linux shell scripting, Python, R, VBScript, ASP.NET, HTML, and XML.
Accomplishments
Work Experience
09/2013 to Current Senior Business Intelligence Developer Northwest Bancorp, Inc. | , ,
  • Develop, deploy, and maintain complex financial reports using SSRS and Excel.
  • Work closely with business analysts to gather report specifications and build queries, functions, and packages in Oracle SQL Developer to provide decision-guiding business intelligence to investment managers.
  • Support investment management data warehouse and analysis cube and improve existing ETL processes for warehouse and mart population using SSIS and Linux shell scripts.
08/2011 to 09/2013 Intermediate ETL Developer Frontier Technology Inc | , ,
  • Develop and automate interfaces between clients and their insurance carriers using primarily SSMS and SSIS.
  • Write complex T-SQL code to transform EBenefits data to conform to carriers' specifications (using both proprietary and HIPAA EDI 834 layouts).
  • Globalize processes and create efficiencies wherever possible to streamline development of future file feeds.
  • Accomplishments: Created over sixty-five new file feeds and inherited responsibility for over fifty existing feeds.
  • Globalized processes for use among multiple feeds and conducted ongoing performance tuning to maximize efficiency.
  • Assigned as primary developer of inbound census and outbound payroll files.
  • Designed interface tracking database to replace existing spreadsheets; created corresponding user interface and reporting tool.
  • Spearheaded initiative and led task force to evaluate and select project management software; created company-wide project management and documentation standards and trained staff in compliance.
  • Acted as mentor to summer intern and trained intern in database design and querying.
10/2010 to 08/2011 Intermediate Database Administrator Carnegie Museums Of Pittsburgh | , ,
  • Supervision of two employees (Database Analyst and Software Support Specialist); coordination of organization-wide collections management systems migration; data warehousing; business intelligence analysis, including corporate dashboard creation and maintenance.
  • Primary database point person for Carnegie Museum of Art, Carnegie Museum of Natural History, Andy Warhol Museum, Carnegie Science Center, and Powdermill Nature Reserve.
  • Accomplishments: Created corporate data warehouse incorporating data from numerous disparate systems and platforms; created corporate dashboard using SSRS to provide high-level business intelligence to executives and trustees; coordinated initiative to migrate all museum collections data and digital asset management systems to a single, centralized platform.
01/2008 to 10/2010 Associate Data Architecture Analyst Carnegie Museums Of Pittsburgh | , ,
  • Database administration; report design and implementation; database design; user interface design; evaluation, updates, and integration of existing data management systems.
  • Primary database point person for Carnegie Museum of Art, Carnegie Museum of Natural History, Andy Warhol Museum, Carnegie Science Center, and Powdermill Nature Reserve.
  • Accomplishments: Designed and implemented several databases and corresponding user interfaces for purposes including contact management, advertisement budgeting and tracking, and institution-wide volunteer assignment and management; wrote extensive documentation on newly created databases and provided end-user training; using SSIS, automated previously manual processes such as visitor ZIP code tracking, mailing list generation and formatting, and synchronization between disparate database platforms; migrated existing Crystal reports to SQL Server Reporting Services and created numerous new business intelligence reports, receipts, and confirmation letters on request; researched and wrote Carnegie Museums of Pittsburgh Information Technology policy manual.
Education and Training
Expected in June 2007 Master of Library | Information Science University of Pittsburgh, Pittsburgh, Pennsylvania. GPA: GPA: 3.8
Information Science GPA: 3.8
Expected in July 2004 Bachelor of Arts | History Rutgers University, Douglass College, New Brunswick, New Jersey GPA: GPA: 3.6
History GPA: 3.6
Skills
VB.NET, ASP.NET, streamline, Analyst, Art, asset management, automate, budgeting, business intelligence, contact management, Crystal Reports 8.5, Crystal reports, clients, customer service skills, data management, data warehouse, Database administration, databases, Database, database design, data warehousing, Detail-oriented, documentation, EDI, ETL, financial, HTML, Information Technology, insurance, investment management, letters, Linux, mentor, Microsoft Access, Microsoft Excel, Excel, migration, Natural, Oracle, developer, PL/SQL, Oracle SQL, payroll, problem-solver, processes, project management, proofreading, Python, Quick, reporting, shell scripts, shell scripting, spreadsheets, SQL Server, SQL, SQL Server 2000, Supervision, Software Support, user training, T-SQL, user interface design, user interface, VBA, VBScript, Visual Studio, well-organized, XML, ZIP

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • University of Pittsburgh
  • Rutgers University, Douglass College

Job Titles Held:

  • Senior Business Intelligence Developer
  • Intermediate ETL Developer
  • Intermediate Database Administrator
  • Associate Data Architecture Analyst

Degrees

  • Master of Library
  • Bachelor of Arts

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: