SUMMARY

• Windows Azure
• .NET 2003,2005,2008,2010,2012,2013,2015,2017 C#/VB.NET
• SOA
• 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

Languages (current): T-SQL, PL-SQL, MDX, VB.NET, C#, C++

Databases (current): SQL SERVER, ORACLE, DB2, SYBASE, ACCESS

Tools (current): SSAS, SSIS, SSRS, SHAREPOINT, PERFORMANCE POINT, INFORMATICA, EXCEL SERVICES, ERWIN, EMBARCADERO, TOAD, SPOTLIGHT, ORACLE DEVELOPER SUITE, SQL SERVER DEVELOPER SUITE, VISIO

Methodologies (current): Kimball, Inman, TOGAF, SOA

Industries: Financial, Manufacturing, Retail, Confidential, Health

PROFESSIONAL EXPERIENCE

Confidential, FL

Technical Solutions /Big Data /Enterprise Data Warehouse

Responsibilities:

• Lead technical sessions, perform technical analysis and produce technical documentation relating to the overall architecture of each integration project.
• Provide expert level assistance and guidance to TBC’s development teams regarding design best practices and technical issues.
• Work directly wif project stakeholders to define and document the use cases, functional / non-functional requirements, and gaps, for each integration project.
• Maintained a high degree of business functional noledge
• Designed developed backend, middleware and front end processes Angular 4,Vb.net/C#, SQL,JASON and WEB API
• Developed processes in SSIS/PowerShell to support “continuous” integration on Windows Application Servers
• Extensive SSAS Development (MDX Scripting)/ Auto Partition Strategies. SSAS .Net Assembly development. Dimension development and design. Auto Security Administration.
• Development of operations reports and dashboards using metrics that measure high availability and throughput .
• Developed azure based monitoring, alerting and active monitoring of risks to site SLA’s
• Developed and deployed Integration Azure solutions for high availability, elastic load distribution and high throughput for SAP, Teradata, Oracle and SQL Server transactional sources in Data Streaming and batch modes.
• Participate in troubleshooting, capacity planning and analysis, performance analysis activities.
• Designed and deployed Azure Service Bus to connect ON Premise services wif public cloud services utilizing custom API’s
• Design and develop robust programs leveraging existing libraries written .NET and R.
• Deployed and supported Azure Data Lake Storage GEN2 data lake solution.

Confidential, Miami, FL

.NET SOA /Big Data /Azure /Enterprise Data Warehouse

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 wif SSIS 2016 and BizTalk 2016 to integrate wif 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 .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 wif SSAS assembly components written In C#.
• Designed and developed SSIS wif BT Scripts for Teradata import and extraction in Teradata STAGING / EDW data repositories
• Integrate Notification Services wif 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

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 wif 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 noledge 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

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 wif 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 noledge 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

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 wif Data Center personnel and purchasing for vendor cost evaluation for Microsoft Appliances for the PDW
• Worked wif 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 wif Business Analyst implementing the rules for the Data Quality Service
• Implementing Xvelocity index strategies.

Confidential, Atlanta, GA

Data Architect Architect SSAS,SSIS

Responsibilities:

• Designed and implemented data warehouse ETL using SSIS and building SSAS cubes wif 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 wif SharePoint Business Connectivity Services that takes advantage of SharePoint 2010 Workspace linking external content types wif SQL 2008 R2 databases

Confidential, Huntsville, AL

Data Architect (SSAS,SSIS) & Developer

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 wifin 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

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

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

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 has 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 wif 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 wif 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 wif the halp of VS 2010 and SharePoint Designer 2010.
• Creation of WCM - Web Content Management Application for SharePoint 2010.
• Integration of Ping Identity wif 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

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 wif 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

Responsibilities:

• Organized meetings wif 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 wif Java /.net Developers to design Web Services Gateways to Operational Data Stores
• Performed Data modeling and Data Transformation and Loading (DTL) wif 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 wif 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

Responsibilities:

• Worked wif 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 noledge 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 wif 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 wif 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

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 wif 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 wif 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 wif complex transforms and type 1 and type 2 changes.
• SSIS Script components written in C# .NET
• Demonstrated strong leadership wif experience training developers and advising technical groups on ETL best practices.
• Web Services Gateway Architecture and development (working wif .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 wif 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

Responsibilities:

• Worked in a collaborative environment that provided, interfaced wif 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

DATA Architect - SSAS/ SSIS / SSRS / SharePoint Developer

Responsibilities:

• Managed BI and Data Warehouse (DW) requirements, conducted source system analysis and creating high-level solution architectures to meet the requirements. Worked wif 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 wif 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 noledge 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 wif 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 wif 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

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 noledge 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

Consultant - Data Architect, SAP BW Architect

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 solutions, partnering wif 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 (wif SAP Central Instance on second node) connected to a SAN.
• Integrated Office Performance Server (score carding, analysis and planning) wif 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 wif 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, MA and Detroit, MI

Consultant - Project Manager/Data Architect

Responsibilities:

• Worked wif both business and internal IT customers to complete an incomplete project plan for release 2 version of an Enterprise Application/Data Warehouse.
• Worked wif a team of business analysts, data architects, application developers, ETL developers and testers, My objective was to deliver projects wifin 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.
• 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.
• 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.

Confidential,

Consultant - OLAP Data Warehouse Developer/Data Architect

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 wif 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

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

Responsibilities:

• Designed and implemented ETL processes to make data available for reporting purpose wifin 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 wif 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.
• Technologies Utilized - 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

Confidential, COLUMBUS,GA

Consultant - SQL Server Developer, Data Migration Architect

Responsibilities:

• Optimized all web site databases, which resulted in substantial performance gains.
• Optimizations included table redesign, indexing, query rewrites, and stored procedure rewrites. Used QUEST - SPOTLIGHT, SQL PROFILER to identify bottlenecks. Review existing stored procedures and optimize code. Technologies Utilized SQL Server 2000

Confidential, PENSACOLA, FL

Consultant - OLAP SQL Server Developer/SQL Server DBA/ Data Warehouse Architect

Responsibilities:

• Lead project including creation of project plan using Microsoft Project, assigning tasks to programmers, analysts, running project meetings including attending meetings wif hospital departments to stay abreast of the latest user requirements and changes to any existing data warehouse requirements. Involved in organizing and assisting in testing, certification, and post “go-live” tasks. Used many Microsoft Office tools such as Excel spreadsheets, Microsoft PowerPoint presentations, Word, etc. to get the project completed wifin time frame.
• Project: Build core infrastructure of Data Warehouse - Defined technology planning requirements, objectives, architectural principles, goals and standards for enterprise data warehousing. Ensured management development approach were aligned wif the architecture strategy, standard technologies and design principles by delivering weekly updates. Coached partners and direct managers and staff at all levels. Technologies involved Windows Sever 2003, Microsoft SharePoint, .NET 2003 Visual Studio, SQL Server 2000, Reporting Services(MSRS) 2000,Microsoft Analysis Services(MSAS) MDX developing, Web Services, Microsoft Project, Microsoft Vision and DTS. Build and administrate a 2 node cluster on a Windows 2003 Server. BI (Business Intelligence) Tools: Crystal Reports /Report Services / Microsoft Office Pivot Tables

Confidential

Consultant - DATA ARCHITECT

Responsibilities:

• Worked on large transactional processing application. Primary role assess current application database designs and make recommendations to design, build and tune large transactional databases for core business applications and development “SQL SERVER BEST PRACTICES”.
• GENERAL ELECTRIC (MEDICAL DIVISION) (3 month contract) (CHICAGO, ILLINOIS)
• Consultant - SQL Server Developer/SQL Server DBA/Architect
• Project 10
• Write procedures to prepare databases for replication. Design transactional replication for 16 databases. Provided technical support in implementing transfer noledge base to IT staff-All work was done remotely.

Confidential, ST LOUIS, MISSOURI

Consultant - OLAP SQL Server Developer/SQL Server DBA/DATA Warehouse Architect

Responsibilities:

• Managed a team of SQL developers and database designers in the design and implementation of a OLAP Reporting environment which would service 600 users in 18 different office locations (national/international) . -Provided guidance and technical assistance to team members on an on-going basis throughout the duration of the project(s). dis included training less experienced analysts/programmers, directly monitoring work activities, and providing performance feedback for quality review purposes.
• Provide database management support to include implementation and administration of 30 SQL Server's across the enterprise.
• Responsibilities also include using Quest Software for monitoring and administering the system. Conducted performance monitoring and measurement including: Tuning & Performance Monitoring: executing DBCC Commands, Sizing Procedure cache, Sizing Data cache, configuring locks and Transaction Isolation levels and Index Management. Monitor volume (hard drive) space. Wrote (T- SQL) and fine-tuned complex stored procedures. Strategically designed and implemented data warehouses, data marts, and data stores, while ensuring high levels of data availability.
• Designed and developed data warehouse data stores, and analyzed business requirements, developed target-source data mappings and delivering ETL processes for end-user OLAP and reporting initiatives (Used report services as an OLAP client schedule reporting tool ). Installed/administrated SQL SERVER REPORTING SERVICES, created schedule reports and delivered via email.
• BI (Business Intelligence) Tools: Crystal Report /Report Services / Microsoft Office Pivot Tables

Confidential

Consultant - OLAP SQL Server Developer/SQL Server DBA

Responsibilities:

• Responsible for developing / maintaining metrics and reporting for financial automation systems locally and over the web using Cognos REPORT.NET. OLAP cubes were created and administrated (33+ cubes spanning various subjects) on the SQL Server 2000 Analysis Services platform designed using the star schema Method.
• Developed OLAP queries using MDX. Please Note: Cubes supported about 40 users, wif 40% of the cube set for near real time data delivery. Data marts (10 + averaging 1 gigabyte in size) were residing on SQL Server which were populated by ETL processes, written in T-SQL, Visual Basic scripts and .net- extracting from DB2 and Oracle OLTP systems). Static reports were created an converted to Report Services from Access and, Crystal reports (before version 8.0).
• BI (Business Intelligence)

Tools: Crystal Report /Cognos/ Microsoft Office Pivot Tables

Confidential: (HUNTSVILLE, ALABAMA)

Consultant - OLAP SQL Server Developer/SQL Server

Responsibilities:

• Planned, directed, and managed designated projects.
• Ensured that objectives were accomplished in accordance wif outlined priorities.
• Analyzed results of operations to discover more efficient ways to utilize resources.
• Coordinated the successful simultaneous development of several projects.
• Delegated responsibilities and designed time schedules.
• Reviewed project status reports during each operational phase.
• Prepared weekly project status reports for management.
• Designed and developed data structures to store enterprise data in a SQL SERVER 2000 ENTERPRISE environment.
• Migrated Access Databases/Queries to OLTP SQL SERVER systems, written interfaces in .NET VB to re-route data to new platforms.
• Created scheduled database processes supporting automated file transfers. Maintained databases, including updating statistics, indexing, structure modifications, capacity planning, and index analysis.
• Implemented database security, logins, users, roles, and object permissions.
• Implemented configuration management of database objects.
• Worked wif integrated project teams as project database administrator for large-scale modifications and new product releases.
• T-SQL development and writing T-SQL queries
• Administrative tasks including DBCC commands, I/O, memory/cache utilization
• Implemented logical model/physical design
• Planned and executed small-scale database modifications and SQL scripts for bug fixes, data repair, and functionality enhancements.
• Implemented database backup and recovery procedures, including disaster recovery procedures.
• Supported data replication to and from multiple web sites and maintains the underlying batch processes.
• Assisted software engineers and end users wif query writing, database access, and general information.
• Designed/Implemented/Maintained OLAP servers and processes to replicate production data to the server.
• Performed transaction analysis and performance tuning of database applications and batch processes.
• Conferred wif senior management and staff on policies and procedures, technical problems, and priorities that relate to database operations.
• Prepared project status/progress reports on assigned activities.
• Defined the overall data warehouse architecture. (e.g., ETL process, ODS(Operational Data Storage), Data Marts);
• Defined technical requirements, technical and data architectures for the data warehouse ; Recommend/select data warehouse technologies ;
• Designed the ETL process (data sources include ORACLE,DB2), including data quality and testing;
• Developed .net components using DSO /CDO components and wrote VB.NET components (for the ETL environment) to interpret and cleanse data entering the warehouse and alert administrators via email if certain conditions would arise.
• Designed/implemented the information access and delivery effort for the data warehouse;
• Defined meta data standards for the data warehouse; created the data warehouse meta data capture and access effort.
• Microsoft Analysis Services: Build and design Star, Snowflake Schemas, Dimensional Data Models. Improved and improve query responsiveness and processing performance. Optimized hardware resources, deployed and interpret monitor counters, manage the MSAS cache.
• Cognos Power Play: as a front end to report on OLAP cubes built wif Microsoft Analysis Services.
• BI (Business Intelligence) Tools: Crystal Report /Cognos / Microsoft Office Pivot Tables

Confidential

Data Architect/SQL Server Developer/Data Warehouse Architecture

Responsibilities:

• Diagnosed and analyzed the performance and availability of OLAP cubes on Microsoft Analysis Server
• Defined the overall data warehouse architecture. (e.g., ETL process, ODS(Operational Data Storage), Data Marts);
• Add and made modifications to dimensions /measures and calculated fields according to constant user requests.
• Created archive processes for OLAP databases.
• Designed and created replication objects for
• Deployment capacity planning, installation and operational maintenance of SQL Server based application environments.
• Recommended and Implemented SQL Server recoverability and high availability solutions.
• Development, tuning, testing, documenting SQL Server database upgrade and data migration scripts (Data sources include Oracle,DB2 and Sybase).
• Analyzing and troubleshooting SQL Server - based application performance.
• Recommended SQL Server related application coding methods and standards.
• Migrated Access Databases/Queries to SQL SERVER systems.
• Designed and implemented enterprise wide databases, manage SQL query libraries, provide user support, and set standards for application access to database.
• Designed and deployed a replication solution over LAN and WAN environments.
• Performed trigger verification, stored procedures, referential integrity, and involved wif hardware products / system specifications.
• Performed I/O, memory/cache, SPIDs, DBCC commands and performance tuning of both the physical objects and the stored procedures wif monitoring tools by using code efficiency, table indexing, log file and load-balancing techniques.
• Please note: Supported 18 servers wif a database size average of 1.5 to 2 terabytes. Develop Data Warehouse Technical Infrastructure Strategy and Capacity Planning. Design and implement Service Level Agreements and Key Performance Indicators. Design and Develop System Monitoring and Production Control Procedures. Develop and implement additional Security Strategies.
• Wrote VB.NET components (for the ETL environment) to interpret and cleanse data entering the warehouse and alert administrators via email if certain conditions would arise.
• BI (Business Intelligence) Tools: Crystal Report /Report Services / Microsoft Office Pivot Tables

Confidential, HUNTSVILLE, ALABAMA

Data Architect /SQL Server Developer/Data Warehouse Developer

Responsibilities:

• Responsible for the design, development, management, and maintenance of the SQL Server
• 2000/7 Databases.
• Troubleshoot the production, development and testing of databases and data models. Data warehousing, production, and replication.
• Deployed a CRM system wif a SQL server back-end (as of 11/2002 built/installed and administrated 14 SQL SERVER SYSTEMS on raid servers for the Confidential ), migrated data from 22 departments to a central database repository (dis involved creating DTS packages to query and convert heterogeneous data written in vbscripts /visual basic).
• Created replication system on a WAN and LAN (local and international sites).
• Created a process for customers to request information via fax and email which communicates to the CRM system.
• Deployed Microsoft Analysis Server using MOLAP/ROLAP OLAP storage modes. Created/designed OLAP cubes -involving defining measures and dimensions. Design, build, process and view cubes wif cube dimension editors. Developing mdx queries for adhoc reporting. Using reporting environments like Crystal reports, and Microsoft Excel PivotTable Reports . Optimized cube data retrieval .
• Reports were delivered via email or using .NET applications (developed by myself). Most reports were automated and were automatically emailed to the management group.
• Worked in a SQL SERVER CLUSTER ENVIRONMENT (2 active / 2 passive configuration - CRM PRODUCTION/ CRM WEB)/COMPAQ SAN ENVIRONMENT.
• Migrated Access\Queries Databases to SQL SERVER, replace access reports wif Crystal Web reports
• VB/.NET DEVELOPMENT: 1. Wrote a visual basic 6. /crystal report application including developed COM+ objects (which I originally created) to VB .NET application.2. Created an application (my idea) to assist the Help Desk department: Instead of customers calling the halp desk department and the transaction was entered manually into a CRM system, customers would now email the halpdesk department, my application will read and update the CRM system automatically, direct the emails to individuals in the halpdesk department and maintain a “load balance” between the halpdesk operators. The email server was MICROSOFT EXCHANGE and CDO objects were used to control the functionality of exchange and outlook in .NET application.
• Built and administrate a 2 node cluster on a Windows 2000 Server.
• BI (Business Intelligence) Tools: Crystal Report / Microsoft Office Pivot Tables

Confidential

SQL Database Administrator/SQL Server Developer

Responsibilities:

• Administrated the database and system departments.
• Wrote store procedures, triggers and created indexes.
• Designed and deployed a replication solution over LAN and WAN environments.
• Optimized SQL Servers and used various tools like Query Analyzer, SQL Server Profiler, SQL Performance Monitor, Data Transformation Services and DBCC on daily basis.
• Implemented SQL SERVER maintenance plans.
• Created/Designed a Automated Email Reporting System using Crystal Reports against a SQL RDMS.
• Oversaw network and database architecture, and software installation and customization. Provided infrastructure administration to ensure server configuration, operating systems, routers, switches and hubs are working properly wif redundancy. Ensure adequate development, testing, and production environments.
• The development hardware was composed of (4) raid level servers accompanied wif 3 standard servers (IDE). Operations was composed of (8) raid level servers which hosted 500 + users (including remote users). Operating system used were Windows 2000 and Windows NT4. The development platform was Visual Basic 6 (wif ADO, MTS, COM+) and SQL 7 and SQL 6.5 as the RDMS (s), EXCHANGE SERVER 5.5.

Confidential, New York

SQL Server Developer/ Administrator/Consulted for a Confidential

Responsibilities:

• Analyzed and modeled customer (our customers included THE NEW YORK HUMAN RESOURCE ADMINISTRATION, NEW YORK WORKMAN COMPENSATION BOARD, NEW YORK STATE TEACHERS RETIREMENT ADMINISTRATION) provided legacy datasets, developed new physical models, interpreted and designed business rules, defined rules for standardization and data integrity, designed and implemented data transformation processes, designed procedures for maintaining and refreshing data on an ongoing basis and maintain project metadata.
• Implemented, administrated (locally and remotely) and deployed SQL server databases.
• Worked in conjunction wif the development team, outlining the initial needs of the client(s).
• Worked wif the SYSTEMS ADMINISTRATORS on all projects relating to hardware, raid level and networking configuration for SQL SERVER.
• Responsible for the design and of security for SQL server(s) .
• Daily Primary Admin Tasks: Optimization, managing data repositories, backup processes and implementation of all levels combating data retrieval issues like (locking and bad calls (queries) in our databases ), and optimizing and creating stored procedures, triggers, views and indexes.
• Co-authored every disaster recovery plan on all projects.
• Migrated Access Queries \Databases to SQL SERVER.
• VB DEVELOPMENT DETAILS: Wrote multi-user data entry program wif KOFAX imaging controls- Program will retrieve images and operator will enter data to describe image, info saved to database. 50 + users

Confidential,Miami,FL

SQL Server Developer /SQL Database Administrator

Responsibilities:

• Assigned to design gigabyte databases for a prepaid cellular company which harbored an extensive and complex legacy information system.
• Co-developed and Co-designed a client server application (developed in Visual Basic 5.0) for a Call Center environment co-developed and designed database architecture, (SQL Server 6.5/6.0), setup Replication System and a Database and System Backup.
• Optimized SQL Servers which delivered sub-second response times using proprietary tools and database technology.
• Integrating large files and databases from disparate systems wifout the benefit of common identifiers; dealing wif unconventional data storage techniques and proprietary database systems.
• Created triggers, store procedures, views and Indexes.
• Responsible also included; SQL Software installation and upgrades.
• Performed application security configuration and administration. Performed logical database design and physical database implementation, SQL database creation, monitoring and performance tuning.
• Responsible for application/SQL troubleshooting and tuning.
• Developed and implemented Backup and Recovery Strategies.
• Reviews SQL code and database object designs against standards and best practices.
• Performs database administration from the command line
• Wrote and designed Reporting Software using Crystal Reports controls for Visual Basic

Architecture: The Test Environment was composed of 2 raid level .Operations was composed of (6) raid level servers which hosted 300 + users (including remote users). Operating system used were Windows NT4. Development platform was DELPHI 3, Visual Basic 5 (wif BETRIEVE, ODBC, RDO,ADO) and SQL 6.5 as the RDMS (s).

Confidential, Miami, FL

SQL Developer /Database Administrator

Responsibilities:

• Analyzed the company’s department(s) various data retrieval and storage modules, in addition to their manual and complex procedures.
• Delivered innovative new ways which consolidated and transformed data into valuable business intelligence.
• Data migration transformation, database development, optimization and design.
• Developed and designed business client server applications wif database platforms such as Access 95, 2.0, FOXPRO2.6,Crystal Reports 4 and SQL Server 4.5/6.0 for in-house and clients.
• Installed SQL server Databases for clients and trained technical personnel basic administration duties to administer those servers.