Bi Analyst / Developer Supervisor Resume
Seattle, WA
SUMMARY:
- Excellent team player and enthusiastic team member
- Excellent communication and interpersonal skills
- Highly organised and able to work well under pressure
TECHNICAL SKILLS:
Technical: Highly proficient (9 years of experience) at developing software using C# Winforms, VB.NET, ASP.NET Web forms, ASP Classic, XML, Multi - threading. Extensive 8 year experience using, designing, and implementing:1. MS SQL Server 2000/05/08R2/14/16 (DTS / SSIS Packages, T-SQL)2. Oracle 9i/10g (Database Design, PL/SQL, Implementation) Excellent appreciation of object oriented design principles and patterns. Comfortable also using IIS Windows Server, Tortoise, SourceSafe, Team Foundation Functional / Technical Designs Microsoft SSIS, SSRS, SSAS, Powerpivot, PowerBI
PROFESSIONAL EXPERIENCE:
Confidential, Seattle, WA
BI Analyst / Developer Supervisor
Responsibilities:
- Work closely with project managers to obtain and interpret customer demands to a functional and technical document.
- Work remotely with team members including developers, managers, project managers and leads
- Develop Integration Packages using Microsoft Azure VM with SQL Server 2014
- Develop on Azure Database (DML & DDL) Loading data through Integration Services
- Develop reports based on requirements and demands including SSRS, Powerpivot, PowerBI Desktop using cloud and on-premise data
- Attend SCRUM meetings on a daily basis
- Develop on SQL Server
- C# Development as needed
- Create demos for unreleased and new products; showcase supply the appropriate setup and laboratory documentation.
Confidential
Microsoft Business Intelligence Analyst / Developer
Responsibilities:
- Main functions include developing and maintaining the data warehouse environment based on the Ralph Kimball´s architecture.
- SSIS Developer - Develop ETL packages from the import process to the load process updating the different dimensions and fact tables.
- SSAS Create data models, new measures and sets
- SSAS Create Dimensions with relative hierarchies if needed
- SSAS MDX Scripting based on KPI´s
- SSRS reports connect through our Web Services developed C#.NET
- SSRS Reports are masked through our ASP.NET Web Pages to ensure the proper use and control of information on user/group hierarchy based access.
- Adhoc / Powerpivot reporting based on business demands
- Create Technical and Functional Designs used for Government Audits
- Provide Handover Documentation to our support team.
- C#.NET Developer Framework 3.0/3.5/4.0
Confidential
C# / ASP.NET Developer
Responsibilities:
- ETL Developer using Microsoft BIDS (Business Intelligence Development Studio) SSIS
- Software developer role specializing in Web development of Confidential ’s Secure Data Room
- Role included Web designing in .NET and implementing C# scripts and processes assigned by Co-Founder (Joni Stolt) in Visual Studios C#.
- Manage all source code and changes with Microsoft Team Foundation
- Developed Unit Testing Modules to simulate new processes to be implemented.
- Assist in weekly brainstorm meetings to share different ideas for new and existing challenges.
Confidential
Business Decision Solutions Analyst / Developer (CRM)
Responsibilities:
- (SSAS 2000 / SSAS 2008) Develop Data warehouse projects including (data models, dims, facts, sets, measures, hierarchies, MDX scripting, cubes, and partitions).
- (SSIS) Developing complex ETL´s with various tools including Business Objects Data Integrator, DTS, and DTSX packages.
- Software development role with main focus being the Group Report lead developer of the reporting department. Working directly with the business providing statistics reports on company performance, operations, forecasts, pricing, p&l, and kpi’s following the company’s development methodology.
- Technical Analyst providing impact analysis for sub-systems and databases that directly and indirectly interact with changes. The technical design is presented with complete UML guidelines based on the final functional design presented.
- C# Web form developer role known as the Group Report Web Master, includes development of new solutions, updates to the current infrastructure, and fixes to issues that may arise. This Web tool plays a key role in the Transcom’s day to day operations. Group Report Web is used by approximately 20,000 users, originally designed in ASP Classic and approximately 75% has been migrated to C# ASP.NET. This web application makes extensive use of AJAX, Web services, VB6 dll’s, external dll’s, and JavaScript technology to provide the business managers and operation team leaders with a standard administration interface of daily tasks and agent performance.
- C# Winform Developer is a broad role which deals with two main activities:
- C# Multi-Threaded Winform enhancements to already existing applications focusing on new specification enhancements, updates and fixes. This application allows users to administrate centralized data, generate real-time statistics, and acts as a service for data management taking into account many complex procedures to maintain a uniform international standard for the company’s data outcomes.
- Handover documentation is provided to support centre to deal with any maintenance, standard requests, and tasks.
Confidential
VB.NET Developer
Responsibilities:
- Software development role with main focus being the lead developer on a Customer Service Platform for the Supreme Court of Santa Cruz which. As a small consultant company, my role included the pre-requisites, functional, and technical design seeing the project through the entire development lifecycle. This in real time application was broken up into three parts:
- VB.NET Winforms application called PAUE solely used in reception of the courthouse focused on providing a framework for other courthouse applications to consolidate and provide quick customer service. Each courthouse application was re-coded to communicate with each other. PAUE is a multi-threaded application in which communicates to the SQL Server Platform infrastructure
- Each department of the courthouse accesses a VB.NET Web access point to scan in each task and log any associated activities, pending user information, and projected outcome date of task. This Web form application was developed with the use of internal developed Web Services.
- MS SQL-Server 2005 data source was used to access shared tables of other court house distributed applications along with the new base for PAUE.