SUMMARY:

• Windows Azure
• .NET 2003,2005,2008,2010,2012,2013,2015,2017 C#/VB.NET
• Microsoft SharePoint 2007,2010 and 2013 (Architecture/Development)
• Microsoft SQL Server 4.5,6.0,6.5,7,2000,2005,2008,2012 & 2014 Database Architecture/Development
• The Open Group Architecture Framework 9 Certification (2010)
• Microsoft Business Intelligence (ssis,ssas & ssrs) 2005,2008,2012 & 2014 and 2016
• Microsoft Certified Systems Engineer (MCSE 2005)
• Microsoft Certified Database Administration (MCDBA 2003)
• .Net Architecture/Development (VB.NET/C#) - 17 Years
• Microsoft CRM Development - 6 Years
• Business Intelligence Architecture /Development/ Analysis - 19Years
• Database Warehouse Architect OLAP Model Architecture /Administration /Development - 19 Years
• Database Architect OLTP Model Architecture /Administration / Development - 15 Years
• Azure Development - 6 Years
• SQL Server Enterprise Database Optimizing and Tuning - 16 Years
• SQL Server Availability (Clustering (including GEO-Clustering), Log Shipping, Replication (all modes),Data Mirroring).- 11 years collectively
• Cube Architecture Development - 14 years (SSAS, MSAS)
• Web Services Architecture and development (5 years)
• ETL -15 Years
• MSRS, SSRS - 6 Years
• MDX - 14 Years
• T-SQL - 19 Years
• Reporting - 15 years (Crystal Reports, ProClarity Performance Point Scoreboard/Dashboard and Analytics, Power BI, Excel Pivot and Power Pivot Services, SharePoint)
• Pre- Sales/SOW support - 6 years collectively
• Technical Documentation Development - 7 Years
• SharePoint 9 Years: Microsoft SharePoint Server 2013,Microsoft SharePoint Server 2010, Microsoft SharePoint Foundation 2010, FAST Search Server 2010 for SharePoint, Microsoft Office SharePoint Server 2007 (MOSS 2007), Windows SharePoint Services 3.0 (WSS 3.0), SharePoint Portal Server 2003, SharePoint Portal Server 2001, SharePoint Team Services

TECHNICAL SKILLS:

T-SQL

PL-SQL

MDX

VB.NET

C#

C++

SQL SERVER

ORACLE

DB2

SYBASE

ACCESS

SSAS

SSIS

SSRS

SHAREPOINT

PERFORMANCE POINT

INFORMATICA

EXCEL SERVICES

ERWIN

EMBARCADERO

TOAD

SPOTLIGHT

ORACLE DEVELOPER SUITE

SQL SERVER DEVELOPER SUITE

VISIO

Kimball

Inman

TOGAF

SOA

Financial

Manufacturing

Retail

Government

Health

PROJECT HISTORY:

Confidential, Miami, FL

.NET SOA /Big Data /Azure /Enterprise Data Warehouse/ Architect & Developer

Responsibilities:

• SQL Server MDM and Data Quality development
• Provide ETL SSIS design, development and unit testing estimations based on business
• Lead the architecture and design of the SOA data warehouse, data marts and BI dashboard reports which will support various data initiatives.
• Created a custom Integration infrastructure and Replication Service with SSIS 2016 and BizTalk 2016 to integrate with Microsoft CRM
• Developed Power BI and Tableau (SharePoint Web Part) In SharePoint 2013/2016
• Developed advance complexed scalable ETL SSIS solutions utilizing Microsoft Azure Service Bus, Web Services (Rest and Web API), and Microsoft Stream Insight Server Platform
• Developed Entity/API web services
• Developed and written back end processes using Google Geocoding API's for property identification (e.g. convert verified addressed longitude and latitude coordinates)
• Designed data streaming and repository encryption security framework
• Creating U-SQL projects in Visual Studio against Microsoft Azure Data Lake to populate data warehouse
• Developed Bi-directional (upload and download) services to Azure Blob Storages
• Built and design operational data stores sourced by Azure Data lakes, PostgreSQL,PeopleSoft, Sybase, Oracle, MYSQL, NOSQL, Azure SQL Server and SQL Server Via ETL and Custom CDC processes
• Built a customized notification platform in VB.NET for data warehouse utilizing SQL Server Broker Services and Azure Service Bus
• Design developed SSAS cube infrastructure (Tabular and Multidimensional), wrote complexed mdx scripts assisted with SSAS assembly components written In C#.
• Designed and developed SSIS with BT Scripts for Teradata import and extraction in Teradata STAGING / EDW data repositories
• Integrate Notification Services with Microsoft Dynamics CRM to broadcast status on Web and Mobile Applications (.net development CRM SDK)
• Created Custom SSRS Reporting for Microsoft Dynamics CRM
• Serve as the Project SharePoint Online/and on-premise Architect
• Create SharePoint flowcharts, wire diagrams, and slides to convey technical information to technical and non-technical audiences.
• Responsible for building VMWare/Hyper V Virtual Azure development environments

Confidential, West Palm Beach, FL

Data Architect and SQL/CRM developer / Azure Developer (Technical Project Developer Lead)

Responsibilities:

• Designed and developed Azure blob storage and Azure SQL
• Assessed/Design Proof of Concept SOA Enterprise Data Warehouse
• SQL Server MDM and Data Quality development
• Worked with System resources to implement server SQL Server 2012 Clusters in addition assisted in SQL Cluster administration.
• Design Proof of Concept Integration Bus for Offshore Web Analytical Systems.
• Developed C#/VB.net Middleware via active directory and WMI processes detecting users logging on to the network and accessing databases
• Extracting and Migrating data (SSIS and Web Services) into Microsoft Dynamics CRM 2013
• Created Custom SSRS Reporting for Microsoft Dynamics CRM
• Provide guidance in optimizing SQL SERVER 2012 OLTP External and Internal environments
• SSAS MDX\DAX development and optimization guidance.
• Provide guidance in optimizing SSIS/SSAS (tabular and multi dimension) /SSRS environments.
• Installed and configured SharePoint 2013 Farms for Business Intelligence Domain
• Conducted SharePoint performance and scalability testing, and capacity analysis/planning
• Developed and assist in designing complex page layouts for SharePoint 2013
• Developed custom reporting web parts for SharePoint 2013 in Visual Studio 2012
• Validate and prepare detailed specifications and documentation of SharePoint environments and provide knowledge transfer to other technical staff.
• Developed Power view, Excel Service and Performance point reports.
• Created BCS’s and external content lists and views using SharePoint Designer
• Created custom Workflows using SharePoint Designer and Visual Studio
• Designed a security paradigm involving Active Directory and SharePoint’s Secure Store Service

Confidential, Madison, WI

Data Architect/Microsft CRM Developer /SharePoint Architect/MSBI SSAS Developer

Responsibilities:

• Design Information Architecture, Governance plan, Workflow designs and Taxonomy, Design POC and proposed solutions.
• Prepared Architecture diagram from existing environment Manage offshore team of seven developers and four onsite SharePoint professionals
• Created custom Workflows using SharePoint Designer and Visual Studio
• Write and Implement Best Practices for performance optimization for various portals
• SharePoint Webpart modification and new development in Visual Studio C# .NET
• Assisted in the implementation Enterprise Search, Information Management Policies, Various permission levels, Content Types, Manage Implementation from classic ASP applications to SharePoint, SharePoint 2010 installation and configuration in development environment and extensively worked on Portal Performance optimization.
• SSAS Architecture and Developer including MDX
• Extracting and Migrating data (SSIS and Web Services) into Microsoft Dynamics CRM 2011
• Developing .Net Applications to interface with Microsoft Dynamics CRM
• Created Custom SSRS Reporting for Microsoft Dynamics CRM
• Design and implementation of SharePoint search and FAST search.
• Created BCS’s and external content lists and views using SharePoint Designer
• Created custom Workflows using SharePoint Designer and Visual Studio
• Administrate of SharePoint farms - backups/restore, load balancing, database maintenance, proactive system health monitoring, configuration.
• Validate and prepare detailed specifications and documentation of SharePoint environments and provide knowledge transfer to other technical staff
• Conducted SharePoint performance and scalability testing, and capacity analysis/planning

Confidential, Fort Lauderdale, FL

Data Architect /Microsoft CRM Developer /Technical Advisor for SQL SERVER 2012 Microsoft Parallel Data Warehouse (Technical Project Lead)

Responsibilities:

• Guide .Net/Java Developers in the standard and practices of building and communicating WCF Web Services/Microsoft Azure Service and Windows Service Bus for Windows Server
• Creating a technical design for a Service Based Data Warehouse.
• Creating a proof of concept Service Bus Platform.
• Worked with Data Center personnel and purchasing for vendor cost evaluation for Microsoft Appliances for the PDW
• Worked with Data Center personnel to implement the Storage, Computing, Management, Control, Landing and Backup Nodes for the PDW.
• Implemented “Big Data” Solution - HDInsight Server to manage relational and unstructured data at rest and in motion for PDW
• Extracting and Migrating data (SSIS and Web Services) into Microsoft Dynamics CRM 2011
• Designed and built Master Data Services for the PDW
• Worked with Business Analyst implementing the rules for the Data Quality Service
• Implementing Xvelocity index strategies.

Confidential, Atlanta, GA

Data Architect Architect (SSAS, SSIS) & Microsoft Dynamics CRM Developer/SharePoint Architect (Technical Project Developer Lead)

Responsibilities:

• Designed and implemented data warehouse ETL using SSIS and building SSAS cubes with complex data (dimensions, measures, data source views).
• Performance tuning deployed and processed SSAS Cubes.
• Performed troubleshooting/researched data issues that arise during cube development and validation.
• Supported SQL server table and SSAS cube partitioning.
• Creating SSAS Assemblies written in C#.NET and MDX Development
• Extracting and Migrating data (SSIS and Web Services) into Microsoft Dynamics CRM 2011
• Created SSRS reports using SSAS and SQL tables as data sources; passing parameters to drill-down reports.
• Create functional design documents for SharePoint and Data Warehouse, translate the business requirements into system requirements, create a prototype of recommended solutions, demo to the users, and implement the solution. Communicate conceptual and detail designs to business stakeholders and IT development teams.
• Planned, developed and installed a new office intranet based on SharePoint 2010. Tools used were ASP.NET 3.5, InfoPath 2010, Visual Studio 2010, SharePoint Designer 2010, Web Office 2010 and CS5 Adobe Creative Suite
• Administrate of SharePoint farms - backups/restore, load balancing, database maintenance, proactive system health monitoring, configuration.
• Conducted SharePoint performance and scalability testing, and capacity analysis/planning
• Planned, developed with SharePoint Business Connectivity Services that takes advantage of SharePoint 2010 Workspace linking external content types with SQL 2008 R2 databases

Confidential, Huntsville, AL

Data Architect (SSAS, SSIS) & Developer (Technical Project Lead)

Responsibilities:

• Designed / Developed Proof of Concept SOA Data Warehouse
• Designed /Developed (limited scope) SSIS ETL Framework
• Modified / Created SSIS script components created in VB .NET
• Designed Insight Stream Technologies Framework for all data points within the SOA Data Warehouse
• Designed / Developed (limited scope) SSAS OLAP Cube Farm including MDX Developer
• Designed Operational Data Store Farm
• Designed and Implement Transparent Encryption at the Database Level

Confidential, Chicago/Libertyville, IL

Data Architect & MSBI SSAS Developer (Technical Project Lead)

Responsibilities:

• Review SQL Server performance and train staff on areas for improvement in code, storage, indexes and configuration.
• Guidance on Data Vault concepts and assisting choosing a Data Vault Solution Vendor
• Design approach on consolidating databases onto less servers to cut software and infrastructure costs
• SSAS OLAP /MDX Developer
• Jump start failed SQL Server Blade deployment project, fix configuration, and perform load testing
• Wrote monitoring UTILITIES for OS/SQL Server platform in SSIS and VB.NET VC.NET.

Confidential, Miami, FL

Microsoft (MSAS, SSAS) Architect & Developer (Technical Project Lead)

Responsibilities:

• Designed Aggregations and pre-calculating in SSAS 2008.
• Integrate custom .Net assemblies into SSAS
• Wrote complex MDX queries
• Designed and processed partitions
• Created measures, KPI’s as well as defined Actions, translations and perspectives.

Confidential, Cleveland, OH

Data Architect /MSBI (MSAS, SSAS, SSIS) Architect & Developer/SharePoint Developer (Technical Project Lead)

Responsibilities:

• Analyzed technical requirements and design new data models or update existing data models using ER Studio and Visual Studio Database Edition.
• Analyzed technical requirements and recommend ETL strategies and provided visual representation of design using Visio
• Coded stored procedures of high complexity to meet product requirements
• Conducted Index and Performance Analysis to ensure products provide optimal performance
• Delivered work products that meets specifications, are free of defects, and have optimal performance
• Maintained star/snow flake Database Designs and Models
• Defined and kept up to date Database Architecture and Development best practices
• Built / designed consensus amongst different teams working on software development projects
• Facilitated discussions among database developers to exchange ideas and introduce new database technologies
• Assisted in development and enhancement of multi-dimensional cubes
• Developed complex MDX queries
• Design / develop dimensions, partitions and perspectives
• Designed / develop complex measure groups
• Interacted with non-technical Business users, understand and document requirements
• Develop, document, make recommendations, and communicate plans for investing in SharePoint and Enterprise Content Management Department.
• Administrate of SharePoint farms - backups/restore, load balancing, database maintenance, proactive system health monitoring, configuration.
• Creation of Custom Web Part Properties using VS 2010 with SharePoint 2010.
• Organizing user Roles for SharePoint 2010.
• Creation of Prospect Navigator Web Part in SharePoint 2010.
• Creating SSAS Assemblies written in VB.NET
• SSIS Script components written in VB..NET
• Designing the Master Template with the help of VS 2010 and SharePoint Designer 2010.
• Creation of WCM - Web Content Management Application for SharePoint 2010.
• Integration of Ping Identity with SharePoint 2010 for providing Single Sign on.
• Worked on Creating and Managing Service Applications in SharePoint 2010

Confidential, Providence, RI

Data Architect /MSBI (MSAS, SSAS, SSIS, SSRS) Architect & Developer/SharePoint Developer (Technical Project Lead)

Responsibilities:

• Assisted in the design of the corporate decision support infrastructure including the reporting presentation layer
• Analyzed user feedback and implemented application software enhancements
• Mapped business needs/requirements to subject area model and to logical enterprise mode
• Extracted, transform, and load corporate data to facilitate reporting
• Documented processes and transformations in an organized deliverable
• Assisted in the support of corporate financial reports and tools
• Collaborated with developers, programmers, and designers in conceptualizing and development of new software programs and applications.
• Web Services Architecture and development for Java Portals
• Assisted in defining software development project plans, including scoping, scheduling, and implementation.
• Design and Develop complex MDX Queries
• Researched, identify, analyze, and fulfilled requirements of all internal and external program users.
• Designed ETL architecture
• Defining /Creating SharePoint Excel Services and Scoreboard Analytics for SharePoint 2010
• SSIS Script components were written in C# .NET
• Defining /Creating Business Catalog Services Entities in SharePoint Server 2010
• Building custom Web Parts for SharePoint 2010 Solution SEO Search Engine Optimization friendly i.e. optimizing performance, the default page size, dynamic embedding of the Meta tags, and creation of custom Publishing Page library followed by URL rewriting and redirection.
• Defining and designing data models (in SSAS - Unified Dimensional modeling) for the SSRS platform

Confidential, Miami, FL

Data Architect /MSBI (MSAS, SSAS, SSIS, SSRS) Architect & Developer/SharePoint Administrator (Technical Project Lead)

Responsibilities:

• Organized meetings with Technical Professionals (full time employees) demonstrating the best practices for MSAS and SSAS.
• Provided Database architecture (UNIFIED DIMENSIONAL MODELING) design, implementation strategies for MSAS and SSAS OLAP platforms.
• Mentoring production team on how to build, maintain and secure (governed by Active Directory) CUBE clusters on MSAS and SSAS platforms.
• Developed MDX queries.
• Work with Java /.net Developers to design Web Services Gateways to Operational Data Stores
• Performed Data modeling and Data Transformation and Loading (DTL) with a focus on SQL SERVER
• ETL FRAMWORK (SSIS).
• Developed MDX queries
• Mentored IT internals on performance optimization for MSAS and SSAS. Wrote a MSAS/SSAS partitioning management tool in .NET C# (using Silverlight Components).
• Defining /Creating Excel Services and Scoreboard Analytics for SharePoint 2010
• Converting 45 Crystal reports to SSRS reports with a simplified data model
• Implementation of SharePoint 2010 server farm and FAST Search Server 2010 for SharePoint to provide enterprise wide federated search capabilities.

Confidential, Miami, FL

Consultant - Data Architect & MSBI (MSAS,SSAS,SSIS,SSRS) Technical Lead / SharePoint Developer

Responsibilities:

• Worked with both functional and technical personnel to gather, manage, model, and document the detailed data requirements for relational database systems, including the corporate data warehouse. Defined major data architecture related technology standards.
• Participated in development initiatives to develop logical and physical data models and to captured application specific metadata
• Document data content, relationships, structure, and flow, processes that manage, transform/touch data, business rules that govern data, and durations for which data is required
• Created and maintained an enterprise metadata repository
• Served as technical lead or consultant to development teams in efficient data access methods
• I was responsible for overall architecture design, which includes logical and physical design of data warehouse, data marts, staging areas, and operational data stores ensuring that the design will support data availability, SLA, and response time commitments
• Provided expert knowledge regarding data warehousing, OLAP technology, and data management including data extraction, transformation, and loading processes
• Prepared specifications for data warehousing projects, including data distribution and replication where appropriate
• Worked with various levels of management to plan, develop, and implement Data warehouse strategies to provide for the integration of data from many source systems
• Web Services Gateway Architecture and development (working with Java developers) in C# .NET
• Define and design data models for SSRS, developed over 60 + preports
• Established and enhance a data management framework
• Established, enhance and enforce data standards
• Developed MDX Queries
• Ensured appropriate data security, privacy and access considerations are addressed
• Review SQL code to ensure scalability and efficiency
• Developed SharePoint Application in MOSS 2007 in a medium server farm configuration, extensive use of personalization, branding, custom web parts, content types, InfoPath forms, and custom workflows using Windows Workflow Foundation.

Confidential, Miami, FL

MSBI SSIS/SSAS, SSRS Developer and DATA Architect (Technical Project Lead)/SharePoint Developer (Technical Project Lead)

Responsibilities:

• Build, Design and Development SSIS (Integrated Services) AND SSAS (Analysis Services)
• (SSAS) - 2005/2008 AND (MSAS) 2000 OLAP designed and deployed complex cubes, writing MDX queries.
• Worked on complex data flow and processing and with large transactional and reporting databases.
• Demonstrated complex Dimensional Modeling.
• Wrote and developed complex MDX queries
• Developed complex SQL queries and stored procedures.
• Extensive data analysis
• Designed and maintained star schema Data Warehouse structure with emphasis on performance and scalability.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS) - 2008, Data Transformation Services (DTS), and ETL package design, and RDBM systems like SQL Servers, Oracle, and DB2. Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• SSIS Script components written in C# .NET
• Demonstrated strong leadership with experience training developers and advising technical groups on ETL best practices.
• Web Services Gateway Architecture and development (working with .net developers)
• Deployed SharePoint Excel Services (SSAS as the source in MOSS 2007)
• Deployed SharePoint SSRS Services
• Creating Business Data Catalog Entities in SharePoint Server 2007.
• Demonstrated excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports

Confidential, Miami, FL

Consultant - SSRS/ Architect (Technical Project Lead) - Build and design Reporting Model Server / SharePoint Developer (Technical Project Lead)

Responsibilities:

• Worked in a collaborative environment that provided, interfaced with all levels of management in gathering requirements
• Translated business needs into technical requirements and ensure that requirements conform to overall objectives and specifications.
• Generated reports to support the general operations of the company and provide reporting solutions to diverse business teams.
• Developed reports in SSRS and SharePoint Excel pivot tables.
• Developed a standard set of queries against SQL Server databases.
• Converted Crystal Reports into SSRS reports.
• Performed data mining
• Web Services Gateway development in C# .NET
• Maintained current SSRS Report server or environment and expand the use of its features throughout the business.
• Migrated MSRS reports to SSRS.
• Integrated SSRS in SharePoint MOSS 2007.
• Creating Business Data Catalog Entities in SharePoint Server 2007.
• Creation of ad hoc and standards in SQL.

Confidential, Norwalk, CT

DATA Architect - SSAS/ SSIS / SSRS / SharePoint Developer (Technical Project Lead)

Responsibilities:

• Managed BI and Data Warehouse (DW) requirements, conducted source system analysis and creating high-level solution architectures to meet the requirements. Worked with Business Partners from across the company to understand specific reporting and analytic needs.
• Demonstrated approach / techniques of Systems Development Lifecycle methodology (preferably all levels of data warehouse design)
• Developed SharePoint Webparts in C#.NET
• Discussed and evaluated multiple ETL technologies such as Informatica 7 vs SSIS 2008
• Used data modeling tools ERWin
• Designed processes to integrate multiple database platforms Oracle, DB2 and SQL Server
• Presented business cases for implementation Microsoft BI Platform (SSAS 2008, SSRS 2008, Proclarity 6.3, Office Performance Point Server 2007)
• Developed MDX queries for SSAS platform
• Implemented SharePoint MOSS 2007 with FBA (Forms Based Authentication), InfoPath forms and Sharepoint custom workflows and web parts.
• Developed utility Web Parts and deployed SharePoint Excel Services (SSAS as the source) and SSRS in SharePoint MOSS 2007
• Used SharePoint BDC for importing user profiles from PeopleSoft. Set up content deployment architecture.
• Demonstrated in-depth ability to differentiate DW and BI concepts such as operational BI, ODS, dashboards, scorecards, CDC (Change Data Capture), Data Services using SOA.
• Demonstrated knowledge of modeling concepts such as normalization, dimensional modeling, snow-flaking and multi-dimensional modeling
• Formulated architecture strategies around Master Data Management (MDM), Meta Data, messaging / data services, data quality and profiling
• Demonstrated experience with complex analytical systems and reporting environments
• Developed and implemented BI strategies
• Demonstrated strong presentation, communication, and facilitation skills (oral and written)
• Influenced others, built trusting relationships with business partners and peers
• Integrated analysis of business models, logical specifications and user requirements to design and understand solutions.

Confidential, Miami, FL

Consultant - SQL Server SSIS developer/ Data Architect (Technical Project Lead)/SharePoint Administrator & Developer (Technical Project Lead)

Responsibilities:

• Designed strategies for ETL audit, load balance, exception handling and high data volumes.
• Provided expertise and guidance in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.
• Mentoring internals
• MDX development/conversions (Excel Business Functions)
• Developed SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005
• Created interface stored procedures used in SSIS to load/transform data to the database.
• SSIS script components written in VB.NET
• Reconciled data for transformation from SQL 2000 to SQL 2005 using SSIS.
• Assisted Implemented SharePoint MOSS 2007 for corporate intranet, document management and collaboration and project management. Developed application to consolidate sales rep reports.
• Creating Business Data Catalog Entities in SharePoint Server 2007.

Confidential, Birmingham, Alabama

Consultant - Data Architect, SAP BW Architect, BI Subject Matter Expert (Technical Project Lead)

Responsibilities:

• Design approach for End User access to the SAP BUSINESS INFORMATION WAREHOUSE.
• Scope and estimate requests.
• Developed naming and development standards across all artifacts.
• Forecast storage, workload and scheduling capacity.
• Provided standard documentation for all phases of report development.
• Provided a high-level solution, partnering with end-users in the resolution of reporting problems or in the deployment of new reports.
• Demonstrated 2 Node Failover Cluster (active to passive node) for SAP BW environment (with SAP Central Instance on second node) connected to a SAN.
• Integrated Office Performance Server (score carding, analysis and planning) with SAP BW.
• Use Reporting Services 2005 / Analysis Services 2005 (including MDX development) to reports directly access SAP BW environment.
• Designed and developed ETL processes extracting data from MYSAP environment to SAP BW environment.
• Working with SharePoint Admins on deployment strategies for Excel/Reporting Services across the enterprise
• Demonstrate initiative in resolving problems, balancing conflicting requirements and priorities
• Mentored business users and BI developers

Technologies: SAP R/3, SAP Net weaver Application, SAP Central Instance Server, BI Visual Studio 2008, ProClarity Suite 6.3, Office Performance Server, SharePoint 2007,Excel Services, SQL SERVER 2005 PLATFORM: Reporting Services (SSRS),Analysis Services (SSAS),Integrated Services (SSIS)

Confidential, Norwood, MA and Detroit, MI

Consultant - Project Manager/Data Architect

Responsibilities:

• Worked with both business and internal IT customers to complete an incomplete project plan for release 2 version of an Enterprise Application/Data Warehouse.
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers, My objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines.
• Develop and maintain detailed project plans and budgets using Microsoft Project.
• Mentor developers on standard and practices of Data Warehouse
• Manage and coordinate a team of various technical resources
• Design/ developing SSIS (ETL)/SSAS (OLAP) MDX developing components.
• Manage customer expectations by clearly documenting and maintaining project deliverables, plans, and status throughout life of the project.
• Frequently travel to customer sites to present project status and address customer concerns.
• Migrated SharePoint 2003 corporate intranet to MOSS 2007 medium server farm. Set up extranet for clients using forms-based authentication (FBA) and ADAM. Deployed SQL Server Reporting Services for generation of reports. Developed InfoPath forms, custom workflows, web parts and event handlers.

Technologies Utilized: SQL SERVER 2005, SQL SERVER 2000, ERWIN, MICROSOFT ANALYSIS SERVICES (SSIS), MICROSOFT ANALYSIS SERVICES (SSAS), REPORT SERVICES 2005..NET VISUAL STUDIO 2005(BI Visual Studio). BI (Business Intelligence) Tools: Business Scoreboard Manager / Cognos /Microsoft Office Pivot Tables.

Confidential, Nashville, TN

Consultant - OLAP Data Warehouse Developer/Data Architect (Technical Project Lead)

Responsibilities:

• The objective was to build a cube (business requirements including KPI’s were already declared before development) and mentor internals on procedures.
• Migrated data from SAS environment to SQL Server 2005 via SQL Server Integrated Services (SSIS) . Applied conversion and transformation procedures according to business requirements. Designed and built cube (SSAS) and MDX developing with 10 dimensions in addition built partitions spanning 8 years by month (wrote .net component utilizing the AMO layer specific to calendar/fiscal time slices generated partitions automatically) Added 3 perspective views and 3 drill through action objectives. . . BI (Business Intelligence) Tools: Business Scoreboard Manager, BI Visual Studio 2005, Reporting Services 2005 (SSRS) / ProClarity 6 /Microsoft Office Pivot Tables,

Confidential, Milwaukee, WI

Consultant - OLAP Data Warehouse Developer/ Data Architect (Technical Project Lead) - (DTS/MSAS/SSIS/SSAS Development) (Technical Project Lead)

Responsibilities:

• Migrated DTS objects to SQL Server Integrated Services (SSIS) (BI Microsoft Visual Studio 2005) environment
• Migrated SQL SERVER 2000 DATABASES objects to SQL Server 2005
• Migrated Microsoft Analysis Services to SQL Server Analysis Services (SSAS) (BI Microsoft Visual Studio 2005)
• Deploy/Design cubes in SSAS environment Snowflake/ and Star Schema Designs
• Redesign/ Deploy reports using Report Services 2005 (BI Microsoft Visual Studio 2005)
• Make modifications/and add new MDX queries to cubes
• Manage /Rebuild Partitions for cubes
• Microsoft SharePoint Server 2003 hosting for Reporting Services
• Wrote .Net application to process and rebuild multiple cube(s) partitions.
• BI (Business Intelligence) Tools: Business Scoreboard Manager, Microsoft Office Pivot Tables/Cognos

Confidential, Atlanta, GA

Consultant - Data Warehouse Developer/ Data Architect (Technical Project Lead)

Responsibilities:

• Designed and implemented ETL processes to make data available for reporting purpose within a data warehouse.
• Designed, administrated and developed Star Schema Data marts
• Responsible for identifying and translating business requirements for the Enterprise Data Warehouse into logical and physical data models.
• Designed, test, implemented and maintained the Data Warehouse across multiple platforms, technologies and computing environments. Performed daily database administration, which included table design and maintenance.
• Responsible for producing information models that represented the business problem to be solved with regard to: data content, data relationships and structure, processes that managed, transformed data, business rules that govern data, and durations for which data is utilized or required.
• Created objects, attributes, relationships and responsibilities that represented the core abstractions involved in business and technical services for the enterprise.
• Translated business rules and data processing activities into requirements and models suitable for system design and development.
• SQL SERVER 2005, SQL SERVER 2000, ORACLE 9I, ERWIN, MICROSOFT ANALYSIS SERVICES (SSIS), MICROSOFT ANALYSIS SERVICES (SSAS), REPORT SERVICES 2005..NET VISUAL STUDIO 2005.
• . BI (Business Intelligence) Tools: Business Scoreboard Manager, Crystal Report /Report Services / Microsoft Office Pivot Tables