Business Intelligence Developer Resume
New, YorK
SOFTWARE SKILLS:
Linux, OS X, Windows, Azure, Active Directory, Group Policy, IIS, SQL Server, Oracle, MySQL, PowerShell, HTML, CSS, Bootstrap, JavaScript, TypeScript, jQuery, Python, R, RStudio, Java, JDBC, JSF, Eclipse, NetBeans, IntelliJ, PHP, Visual Studio, C#, VB, WPF, ASP.NET, LINQ, Entity Framework, SSMS, T - SQL, BIDS, SSDT, MDX, DAX, SSIS, SSAS, SSRS, Power BI, Power Query, Power Pivot, Tableau, Word, Excel, VBA, Access, PowerPoint, Outlook, Lotus Notes, Visio.
EXPERIENCE:
Business Intelligence Developer
Confidential, New York
Responsibilities:
- Used Power Query and Power Pivot in Excel and Power BI to build and analyze tabular data models using the M and DAX languages.
- Utilized Business Intelligence Development Studio and SQL Server Data Tools to design and develop Integration Services packages to extract, transform, and load data into a multidimensional data warehouse.
- Used Kimball methodology to design dimension and fact tables for star schemas and SQL Server Analysis Services to define attribute relationships and hierarchies, and to associate dimensions with measure groups.
- Used MDX to create key performance indicators and various regular, drillthrough, and reporting actions, and to define calculated members and named sets in the SSAS cube designer.
- Created SQL Server Reporting Services reports and subreports containing tablix (list, table, and matrix) data regions with appropriate row and column groups, charts, document maps, query and report parameters, interactive sorting, filters, drilldown and drillthrough features, to satisfy business requirements.
- Developed database-driven web applications using ASP.NET Web Forms and ASP.NET MVC.
- Participated in the development of SQL Server OLTP databases (tables, constraints, indexes, views, stored procedures, and user defined functions).
- Created and maintained Access databases (tables, queries, forms, reports) and Excel spreadsheets, including pivot tables and charts, to support departmental activities.
- Earned MCSA / MCITP Enterprise Administrator on Windows Server 2008 and MCTS SQL Server 2008, Business Intelligence Development and Maintenance certifications.
Computer Consultant
Confidential, New York
Responsibilities:
- Provided administrative support to Asset Management Services Technology Infrastructure department.
- Developed Excel models of the multi-year and one year plan processes, distributed plan and performance measurement templates electronically using Lotus Notes, and performed consolidations of data returned by business groups.
- Participated in the implementation and testing of an application inventory management system utilizing Confidential ’s intranet as the front end to a Sybase database.
Database Developer / Administrative Assistant
Confidential, New York
Responsibilities:
- Designed, implemented and maintained Microsoft Access databases to track client entertainment and customer calling activity of senior management.
- Provided word processing and spreadsheet support using Word and Excel.
Personal Computer Support Specialist
Confidential, New York
Responsibilities:
- Provided word processing, spreadsheet and database management support using a variety of software packages on the IBM PC and Apple Macintosh.