SUMMARY:

• Data warehouse design, modeling, architecture and development
• ETL design, implementation and production support and maintenance
• TSQL stored procedures, functions, views, indexes, optimizations and other database objects.
• Error handling, auditing, notification and monitoring design pattern implementation for ETL
• Unit testing and quality control including test design and acceptance criteria definitions
• Team foundation server source control with small to large size teams
• GIT source control setup and implementation
• Agile / SCRUM project management (Epics, features, product backlogs, tasks, bugs etc.)
• Strong understanding and experience with software development lifecycle, best practices and design patterns.
• SharePoint development including SP apps, information management design using lists, libraries and workflows.
• Dynamics CRM development using solutions, custom entities, workflows, plugins along with production support and maintenance
• Strong technical documentation with programing guidelines and references, system requirements and system design
• Advanced troubleshooting, performance enhancement and discovery of system functionality and programing of legacy systems with or without documentation
• Excellent team leadership abilities with effective communication while encouraging positive elements of the team and projects
• Skilled in defining and achieving goals with a results based expectation of success
• Strong coordination, interpersonal and effective communication skill across many areas of IT and business roles
• After years of experience in multiple areas of IT, development or business as a whole, I’d be happy to discuss the many other skills and abilities in my background

TECHNICAL SKILLS:

SQL Server versions 2005: 2014 (MCITP) SQL Server Integration Services

SQL Server Analysis Services 2008: 2014 Business Intelligence Development Studio / Data Tools

Visual Studio 2008: 2015 Multidimensional Data Warehouse Design (Kendal, Data Vault)

SSAS: Cubes, dimensions, calculations and kpi development MDX / DAX Qlikview Analytics Platform QVD, scripting, dashboard and reporting design Enterprise metrics development Power BI, Power Query, Power Pivot C# .net 2.0 - 5.0 Asp.net MVC Asp.net Web Forms

Entity Framework 5: 6 Azure Web App Service SharePoint Apps 2013 & SP Online Dynamics CRM Online Solutions, Web Resources & Plugins JavaScript Cascading Style Sheets (CSS)

PROFESSIONAL EXPERIENCE:

Confidential

Business Intelligence Developer

Responsibilities:

• Developed SSAS dimensions, cubes, calculations for loan and loan applications data marts
• Used MDX to develop calculations in cubes and for data sets in SSRS, PowerPivot and Power View
• Data modeling and schema design using the Kimball methodologies.
• Implemented Master Data Services to define conformed dimensions, ETL lookup mapping and other core system data.
• Managed and trained team on maintaining Master Data with Excel 2013/2016 MDS add in
• Developed SSIS projects for MDS entity staging.
• Exposed MDS data using subscription views
• Implemented derived hierarchies, explicit hierarchies and business rules.
• Implemented Data Quality Services to ensure dimension data is accurate and uniform.
• Designed error handling, package auditing and notification framework for SSIS ETL systems.
• Created Key Performance Measures and Indicators that drive company measurement, reporting and analytics across key data sources and functions such as Member data, Operations/Logistics, HR, IT/Systems, Compliance and Risk Management
• Performed data modeling and system architecture for data warehouse to support business intelligence initiatives.
• Planned development, implementation, testing, release and maintenance projects for enterprise data warehouse initiatives
• Data mining, model building, and other analytical techniques to develop and maintain predictive models to drive or inform the business
• Performed statistical analysis against member data to develop models and identify trends in support of the business
• Collaborated with business liaison to understand and develop business and functional requirements
• Developed and maintained new and existing web-based and client/server applications
• Developed ETL systems to acquire and load data from internal and external sources.
• Team leadership and collaboration with developers, stakeholders and subject-matter experts to establish technical vision and analyze trade-offs development initiatives
• Provided technical support to analyze business requirements and translate into useful applications and solutions
• Gauged the effectiveness and efficiency of existing programs; develop and implement strategies for improving or further leveraging these programs
• Gathered information through research, organize data, design workflow, test, validate and complete project
• Evaluated and tested vendor-supplied software packages for compatibility with existing systems, ease of use, and determine if software meets business needs and supports organizational priorities
• Additional database architectures, system design and development
• Other job related duties as assigned.
• SharePoint installation, configuration, lists, libraries and app development
• Dynamics CRM managed and unmanaged solution development with custom entities, plug ins and web resources.

Confidential

Data Warehouse and Business Intelligence Developer

Responsibilities:

• Responsible for developing software systems using Microsoft SQL Server, SSAS, SSIS and SSRS.
• Responsible for architecture, designing and building SSIS ETL packages and SSRS reporting solutions.
• Created collections and sites on Microsoft SharePoint 2010/2013 server.
• Responsible for developing and maintaining detailed software requirements and documentation.
• Worked closely with other team members on design of software systems.
• Developed complex analytic queries on large data sets.
• Created stored procedures, triggers, and functions, views and tables.
• Assisted in analyzing trends in key metrics around key business processes.
• Generated code to extract, transform and load data from production data sources to the data warehouse.
• Executed performance tuning of key queries as required.
• Maintained uptime demands on the system.
• Provided end-user support.
• Participated and lead special projects and assignments as required.
• Participated in all other miscellaneous ANI and departmental tasks as required.

Confidential

Asset Management System Administrator

Responsibilities:

• Developed, implemented and maintained SQL Server and Oracle database environments to meet software requirements.
• Delivered timely and accurate reports and updates to management regarding system maintenance, project and development status.
• Designed reports using SSRS, Crystal Reports and Eclipse for BIRT.
• Developed T-SQL, Triggers, Functions, Tables and Views.
• Administered IIS in development and production environments.
• Delivered technical presentations and project updates for management and non-technical staff members.
• Hands on experience with MS Team Foundation Server, MKS Integrity source control management and Remedy Change control software.
• Administered J2EE web applications using WebLogic and WebSphere application servers.
• Responsible for maintaining problem management request status for all issues submitted to IBM support under contract.
• Developed QA unit test scripts verifying software development release stability.
• Developed project management database and custom user interface using SQL Server, Asp.net and Entity Framework.
• Developed custom reports and enhancements to HP Quality Center using MS Office automation, VB.net & JavaScript.
• Provided technical database and application support and guidance to development staff and user community.
• Active hands-on member of development, support and maintenance teams.
• Resource and performance analysis and planning.
• Developed PL/SQL procedures and queries to load data from Maximo ver. 4 & 5 instances into version 7.
• Developed and configured custom web application enhancement pages using XML, JavaScript, J2EE and Eclipse.

Confidential

ETL Database Developer / DBA

Responsibilities:

• Designed and developed ETL and Data Integration solutions for complex functional and technical requirements using SSIS .
• Data model design and implementation.
• Data Profiling.
• Data Regression Testing.
• Develop SQL scripts and SSRS reports as needed.
• Developed custom data solutions as needed.
• Interacted with technical and business users.
• Documented data flows, and rationale for data loads.
• Ensured the completeness, timeliness and accuracy of the data loads using Red Gate SQL Toolkit and custom scripts.
• Performed system analysis and identified solutions to technical problems.
• Provided production support activities for assigned systems.
• Provided input to project estimates and work plans.

Confidential

Technical Specialist

Responsibilities:

• Designed Maximo test environments for custom development configurations.
• Developed TSQL and PL/SQL queries for Data Splice mobile Maximo software.
• Traveled to client’s site for Data Splice installation, implementation and training.
• Delivered technical presentations and demos for Maximo and Data Splice integrations.
• Gathered requirements for new client software development.
• Installed Maximo 6 & 7 as well as WebLogic and WebSphere.
• Led development team on 3rd party software integration using Maximo, VS Scheduler and Data Splice.
• Developed automated QA unit test scripts for verifying Data Splice release builds stability.