Sql Server Bi Developer Resume Samples

HIGH QUALITY

The best examples from thousands of real-world resumes

EXPERT APPROVED

Handpicked by resume experts based on rigorous standards

DIVERSE EXAMPLES

Tailored for various backgrounds and experience levels

Sql Server Bi Developers take part in the development of network architecture aimed at improving business performance. Common job duties highlighted on a Sql Server Bi Developer resume example are understanding business requirements, building analytics environments, implementing information solutions, proposing new data models, completing business intelligence projects, and improving process flow in the organization by proposing IT solutions. Successful resumes make display of the following assets: written and verbal communication, listening skills, creativity, problem solving, business acumen, the ability to deal with ambiguity, and computer proficiency. A degree in computer science or information technology is required for this position.

1

SQL Server BI Developer

Developed dashboards and scorecards for senior management and company-wide consumption.

  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005/2008 R2
  • Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
  • Implemented automated solutions to provide data to third party vendors utilizing SSIS 2005/2008 R2
  • Maintained, monitored, and developed production and development data warehouse and SSAS 2008 R2 Cube
  • Installed, upgraded, and configured SQL Servers from SQL Server 2005 to SQL Server 2008 R2
  • Captured business information needs from stake holders and translated into requirements and functional specifications. Evaluated and recommended best form of delivery - report manager report, refreshable Excel spreadsheets, or SSAS Cube.
  • Performed database administrator duties such as server security, query optimization, storage management, indexing, replication, backups, restores, monitoring production jobs, and being on on-call rotation
Candidate Info
9
years in
workforce
2
years
at this job
BS
Information Systems
2

SQL Server BI Developer

Designed and developed ER diagrams (Physical and Logical using ERwin data modeler) and mapping the data into database objects.

  • Created stored procedures, views, triggers and constrains to implement the database consistency and integrity.
  • Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.
  • Created SSIS package to extract, transform and load (ETL) data from different sources into destination target, like data warehouse, Flat file, Excel, OLE DB, using SQL Server Integration Services.
  • Designed and developed different type of reports including: Drill through reports, Sub reports, Drill down reports based on business requirement using SSRS.
  • Defined measure groups and further tuned dimensions attributes for a cube, created and deployed cubes to an instance of analysis services on the development server.
Candidate Info
2
years in
workforce
1
year
at this job
BS
Electronic Information Engineering
MS
Computer Engineering
3

SQL Server BI Developer

Worked as part of the Investment Management application development project throughout the entire software development lifecycle.

  • Performed all development activities required for delivery of BI solutions including ETL, data modeling, cube development, solution deployment and maintenance.
  • Responsible for data extraction, transformation and load for Trade Order Management Systems and Investment Analytic tools.
  • Deployed inbound and outbound trade files.
  • Responsible for the implementation, client support, upgrade management strategy of Trade order Management system for both alternative and traditional investment managers.
  • Created SSAS solutions and other solutions with Excel, ad hoc studies and analysis.
  • Collaborated with Technology Services Unit to help design, QA test and implement various bug fixes, patches and upgrades.
  • Developed new and supported existing SSRS reports of quantitative and qualitative data produced both internally and externally.
  • Tracked and reported key metrics.
  • Scheduled and monitored night work processes.
Candidate Info
9
years in
workforce
3
years
at this job
BS
Management Information Systems
MA
Master of Arts
4

SQL Server BI Developer

Design and implementation of a DataMart solution, including business analyst, data mart design, and Data integration using Management Studio and SSIS

  • Build SQL queries, stored procedures, views and functions as needed
  • Analyze procedures to identify processes to automate
  • Worked with datasets with over millions records
  • Developing customized reports using SSRS
  • Create spreadsheet reports using Excel (Pivot Tables, vlookups)
Candidate Info
26
years in
workforce
10
months
at this job
MA
Computer Science
Computer Science Professor
5

SQL Server BI Developer

  • Responsible for maintenance of daily server processes, development of in/outbound data feeds, and providing support to clients and internal staff through a ticket system.
  • Created web-based mockup of the file cleanup/reformatting windows application in Visual Studio 2008 utilizing HTML5, CSS, Bootstrap, and ASP.Net.
  • Created and maintained dashboards in SSRS for Support Team to view at a glance critical systems status using process monitoring system.
  • Utilizing SQL and SSRS, created process monitoring system providing alerts and charts to track, analyze and optimize critical SQL Server job agents across multiple production servers.
  • Created command-line Windows application in VB.Net to upgrade pre-97 Excel formatted files within our automated systems without requiring human intervention.
  • Created Windows desktop application combining VB.Net, DTS, Automate, and SQL Server to clean and reformat submitted client files in multiple formats and standardize the output. This allowed the use of a single SSIS package to load data from multiple clients, a single UI which non-IT personnel could use to clean files, and increased claim processing by 50%. This was converted to C# in a subsequent version which I update and maintain.
  • Automated the loading of claim files submitted electronically, increasing claim loading from 10 files per day to 100 files per day.
Candidate Info
19
years in
workforce
10
years
at this job
BA
Anthropology

Your Resume, Made Easy.

You are looking for your dream job and need a resume? My Perfect Resume is your solution and takes the hassle out of resume writing. Create the perfect job-worthy resume effortlessly in just a few clicks!