Microsoft Bi Architect Resume
2.00/5 (Submit Your Rating)
Greendale, WI
SUMMARY
- A seasoned and well - rounded Information Technology professional with over 24 years of experience in developing innovative solutions using Microsoft technologies with main focus on Data Warehousing solutions using Microsoft’s Business Intelligence (BI) stack including Power BI, DAX, SSAS\Tabular, Azure, SSAS, SSIS, SSRS, MDX, PowerPivot, Netezza, and Teradata.
- I also have in-depth hands-on experience in a wide range of other Microsoft technologies like Visual Studio, .Net framework, C#, and VB.Net.
- Working as an architect, a data modeler or as a lead developer, I am familiar with all phases of the software development life-cycle and have contributed project management, system design, business process data modeling, and documentation skills. I possess strong leadership qualities and is able to mentor and train junior developers.
- I also possess outstanding communication and presentation skills, as shown through my certification as a Microsoft certified trainer (MCT) in Business Intelligence and Performance Point.
TECHNICAL SKILLS
- Microsoft Business Intelligence Architect
- Tableau software
- Kimball Methodology
- SharePoint Business Intelligence
- Excel Services
- MS-SQL Server BI - SSIS/SSAS/SSRS
- Microsoft .Net, C#.Net, VB.Net
- PowerPivot, PowerView, and SSAS\Tabular
- MDX, DAX
PROFESSIONAL EXPERIENCE
Microsoft BI Architect
Confidential, Greendale, WI
Responsibilities:
- During my work at Confidential, I worked with my clients as a Data Warehousing/BI Architect and lead Business Intelligence (BI) Developer, I collected requirements, I performed data profiling and data modeling, designed, built Business Intelligence solutions, and provided mentoring and training for my client’s IT professionals, BI developers and business users. I used data modeling tools like Toad and ERWin, and used the Microsoft BI stack including SQL Server, SSIS, SSAS, SSRS, PerformancePoint 2010, Excel Services, PowerPivot, PowerView, Power BI, SharePoint 2010/2013 Tableau, Azure APS, Dynamics CRM, Netezza and Teradata .
- My tasks included defining the business requirements, architecting the BI solutions, designing and building SSIS packages, SSAS database, writing MDX and DAX scripts, SSRS reports, PowerPivot and SSAS Tabular models, PowerView dashboards, PerformancePoint dashboards, Tableau dashboards, configured Kerberos authentication for SharePoint and SQL Server and created SharePoint 2010/2013 Business Intelligence Center sites.
- Below is a listing of some of the clients I worked for:
Confidential - Milwaukee, WI
Senior Consultant
Responsibilities:
- Web Portal Application Development-Zywave, Milwaukee, WI; working as a senior developer with a team of over 20 developers, testers, architects, and graphic designers carrying out web portal application development using ASP.Net and Dot Net Nuke using a wide range of technologies that included ASP.NET 3.0, C#, ADO.NET, WCF, Visual Studio.NET 2005, Visual Studio team system (VSTS), MS SQL Server 2005, Dot Net Nuke (DNN), telerik web controls, and AJAX web extensions
- Microsoft Business Intelligence Architect and senior technologist-DCI Marketing, Milwaukee, WI ; worked as an architect and senior technologist where I played a critical role in designing, developing and delivering a dashboard solution that focused on information delivery using Microsoft technologies. My responsibilities on this project included collecting business requirements, system architecture, dimensional modeling, design and implementation of star-schema based relational database, implementation of the ETL packages based on SSIS, design and implementation of SQL server 2005 Analysis Services database cubes using BIDS, designing and implementing a web based presentation layer using Dundas OLAP controls, and development of reports using SQL Server 2005 Reporting Services. Also, my duties included hands-on installation and configuration of all solution components.
- Architect and lead developer; I worked as the architect, lead developer, and mentor on many multi-tiered applications, including web applications, web services applications, and windows forms applications. I collected and documented the application requirements, designed the solution, and lead the programming effort. A wide range of technologies were involved including Microsoft .Net, ASP.Net, ADO.Net, SQL server 2005. The programming language used on these projects was VB.Net and C#.
Senior Consultant
Confidential, Milwaukee, WI
Responsibilities:
- Microsoft BI developer; worked on all phases of a multi-tiered ASP.Net Web application which was designed to be used by the managerial staff of a large Milwaukee are bank. This application used a multidimensional data cube stored in Microsoft Analysis Services server to deliver secure and fast scorecard reports over the web. My role on this project was to architect the web solution, including the user-friendly graphical user interface design, lead the development effort, oversee and coordinate testing, and lead the deployment and configuration effort all the way to the user approval testing and release. Other technologies I used on this project were Multidimensional Query language (MDX), ADO.Net, C#, Microsoft OLAP Services, and Database programming Microsoft SQL Server 2000.
- Lead ASP.Net developer; worked on all phases of many three-tiered ASP.Net Web applications; my role on these projects was to architect the system and lead development effort. My works involved collecting and documenting requirements, system design and architecture, mentoring and leading the development effort, coordinating the Quality Assurance effort, and take the project all the way to user approval and deployment. The work on this project involved extensive use of UML diagrams, ADO.Net, C# and Database programming.
- C++ developer; worked as a C++ developer on a variety of client-server applications. My responsibilities included collected requirements, designing solutions, developing and testing applications. Technologies used were MS-SQL 6.5, InstallShield Profession 6.1, and MS-Developer studio 5.0, MS Visual C++, MFC, C-Cover, and Test Director for bug tracking, Microsoft Visual Source Safe, and RequisitePro to track application requirements.