- Featured in:
-
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 Developer Resume Samples
Filter:
No results found
Candidate Info
9
years in workforce
2
years at this job
BS
Information Systems
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
2
years in workforce
1
year at this job
BS
Electronic Information Engineering
MS
Computer Engineering
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
9
years in workforce
3
years at this job
BS
Management Information Systems
MA
Master of Arts
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
26
years in workforce
10
months at this job
MA
Computer Science
Computer Science Professor
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
19
years in workforce
10
years at this job
BA
Anthropology
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.
More Sql Server Bi Developer
Resumes
Sql Server Bi Developer Resume Success Stories
