SUMMARY:

• Entrepreneurial, innovative Information Technology professional with broad - based management, leadership, technical and communication skills, paired with a broad understanding of the critical technologies, persistence on aligning IT strategies to corporate goals and objectives with the belief that the most important thing is the delivery of business value.
• Architecting Master Data Management Marketing Customer MDM solution Roadmap, Enterprise Data Management functions, Infrastructure strategy, Reporting and Analytics.
• Architecting and designing MDM solution using Microsoft Master Data Services.
• Reduced costs for compliance data feeds and other business units centralizing data movement using Data integration strategy.
• Transitioned firm to employ Data Management Services change management system for applications development slashing time-to-deliver by 50%.
• Implemented rigorous development and testing processes decreasing software defects by 60%.
• Slashed production support processes by 50% along with reducing production support overhead costs with implementation of methodology processes and change/release management system.
• Facilitated and maintained enterprise information architecture for unified access to structured and unstructured data across multiple data sources, including data warehouse and machine data.
• Designing ODS/Data Lake with Hadoop HDFS files system building Data COE for business.
• Spearheading of flagship product from Oracle to Mongodb within Azure IAAS building out replica sets within 3 global and regional data centers.
• Designed and implemented data solutions using Master Data Management principles and tools.
• Designed and implemented data governance and quality initiatives ensuring consistent translation and usage of data.
• Partnered with leaders and team members across the business to design and institute practices that will drive the appropriate levels of rigor and quality in enterprise information architecture.
• Analytical professional skilled in successfully building relationships and promoting synergy across business lines to drive comprehensive business approaches that enhanced profitability.

TECHNICAL SKILLS:

• Mongodb
• MySQL
• Oracle
• Oracle eBS
• Lawson
• SQL Server
• SQL
• SSIS
• SSAS
• SSRS
• DWS
• MDSE
• ProClarity
• MOSS 2007
• SharePoint
• TOAD; Informatica
• Erwin
• Cognos Reporting Suite
• Oracle Business Intelligence Enterprise Edition
• Agile
• SDLC
• Sybase
• MySQL
• TIBCO
• SAS
• JAVA
• HTML
• XML
• E-Commerce
• B2B
• B2C
• Teradata
• Neteeza
• Lite speed
• Spotlight
• Power BI
• MDM
• ODS
• DW/BI

PROFESSIONAL EXPERIENCE:

Confidential

Database Manager/Architect

• Completed million dollar project migration and upgrade of Oracle eBS environment from 11i to R12 with complete data center uplift 3 tier eBS environment from DC to Fujitsu Cloud, currently managing six 3 tier environments.
• Managed team of DB Engineers (production and development DBAs) on site, off site, across the globe consisting of Administration, High Availability, DR, SDLC, DBLC, Change Management, On-call support and Performance optimization.
• Save Confidential thousands of dollars in licensing costs by consolidating business unit SQL Server environments, reducing footprint of SQL Server Standard and Enterprise Edition instances.
• Build business case on resource planning proving the need for more DB Engineers to support heterogeneous environment of Apps (eBS) DBAs, SQL Server, Oracle, MySQL, Mongodb, Lawson and Data Architect resources.
• Migrate Oracle VMware and Rac environments from Oracle 9.0 and 11g to 12c on new 4 Oracle Database Appliances (ODAs) to reduce million dollar-licensing fees; plan, architecture and design new Mongodb platform in Azure Cloud using IaaS for flagship products migrating from Oracle to Mongodb within multiple DCs and regions with multi-tenant and global and regional replica sets within Azure.
• Implement DevOps process working with product Senior Management team and DB Engineers to meet demand and accelerate sprint processing by working with, sitting with, and designing with developers to implement Agile sprints.
• Implemented SDLC process of gathering requirements and designing necessary documents around Mongodb required Config, MongoS, Mongodb DB nodes, OpsManager, Replica sets, backup servers, index documents, queries documents and collection documents within MS Azure Pivotal Cloud Foundry micro-services and API layer.
• Plan, Design and Mentor Data Sciences team on best practice of scale out model for SQL Server DW stack, MDM, Master Data Services, SSRS, SSIS, SSAS and OLTP/OLAP Reporting applications to create COE with centralized and consolidated footprint and cut costs.
• Work on (COE) center of excellence data management proof of technology project providing integration and management of data within a data lake and ODS new environment designing/building building necessary data stores for business units to complete further analytics of their data using Cloudera Hadoop HDFS.

Confidential

D atabase Manager/Architect

• Strategized processes to implement performance tuning and analyze best practices for business and application development teams, implementing new best practices, standards, policies and procedures within the SQL Server environment. Worked with DBAs on new daily, weekly and monthly DBA tasks assessed and developed long-term strategic goals for production databases in conjunction with data owners and department managers.
• Correlated with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures, designing and implementing short and long-term strategic plans to ensure that database capacity meets existing and future requirements.
• Developed, implemented, and maintained policies, procedures, and associated training plans for database resource administration and appropriate use, installed and configured relevant network components to ensure database access as well as database consistency and integrity.
• Responded to and resolved database access and performance issues, monitoring database system details within the database, including stored procedures and execution time; worked with DLP team to design and implement system, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
• Built MDM solution using MS DQS, SQL Server, SSIS, SSAS and Power Bi tools with DBA team and Data Sciences team working on designing and building up stream enterprise Data Sciences solution working with Marketing and Sales Force teams to provide necessary information to ask questions and to make better business decisions.

Confidential

Enterprise Data Warehouse Manager/Architect

• Spearheaded process to build new Data Warehouse team consisting of ETL Developers/Architects and Data Architects with business case for these resources to design new Data Warehouse and Data Marts for enterprise and business units.
• Spearheading Informatica MDM solution along with business case on Data Governance and Data Quality.

Confidential

Senior Manager Enterprise/Information Architecture/Architect

• Defined Enterprise Information Architecture vision, strategy, principles and standards, got buy-in from stakeholders, management, business partners, and propagated throughout the company.
• Provided framework, stewardship, governance and decision making for management of data for project development teams, business users and other stakeholders; balanced short-term versus long-term actions, strategic versus tactical requirements, while continuing to move forward towards the strategic vision.
• Delivered road map to achieve the vision, building an enterprise managed information environment for operational and transactional data and for transforming that data into information to support business analysis and reporting. At the enterprise level, the architect wants to provide a consistent view and usage of operational data across multiple applications and to rationalize data and information storage to minimize duplication and simplify access.
• Developed enterprise data management methodology and standards, and promoted to both technology and business throughout the company, working on and leading a team consisting of IT and Business users to implement new MDM strategies helping achieve consistency, accuracy, integrity and semantic consistency of master data assets in support of key business and IT initiatives towards successful migration of SOA environment.
• Architecting and helping design Data Governance solutions, committees, stewards, council and domains.
• Designing from Architecture team Marketing data mart solution to build customer data mart consisting of behavioral data generated from experiences. Selection and scoring of MDM solution vendors as well introduction of data management framework consisting of Data Governance, Information Architecture, DQ, MDM, DW, Metadata and Information security.

Confidential

Sr. Data Architect

• Served as Lead Architect working on data integration patterns, best practices, data governance and BI strategy, Lead Architect designing data store of UP data SOR of Customer, Policy, Member, Provider and Claims data based on daily files received from UHG, Lead Architect working on designing strategy of BUS Architecture for multiple Data Marts, Lead architect working with peers to help design Architecture principles along with people process and technology to gain that synergy with the business.
• Designed and maintained data marts and MDW ( Confidential Data Warehouse) environments, was Lead Architect with Cognizant (offshore and onshore) integrating and designing multi-million dollar project within Health Management directing, leading JAD sessions, strategizing and mentoring business and consultants; worked with IT peers and center of excellence solutions to realize the importance of information, which is an asset to the corporation and the realization that of need to start, manage data and integration patterns of data.
• Worked with business and portfolio managers to collaborate with, identify and define business subject areas and information needed based on operational or analytical; coordinated and implemented EDW BUS mart processes re-architecting existing data marts to start pulling data from subject area and source ODS environments.

Confidential

KForce Sr. Management Consultant/Architect

• Mentored Senior Management and staff regarding business value of what BI brings and provides to the business and IT.
• Managed and maintained business case, project, project plan, proof-of-concept, and proof-of-architecture strategy success, working on data consolidation strategy using SSIS to integrate data from legacy system, Oracle, and SQL Server to SQL Server 2005 master data management repository for Data Warehouse system of record.
• Performed hands-on developing all databases on SQL 2005, ETL using SSIS, Cubes using SSAS, Reports using SSRS, briefing books using ProClarity, SharePoint for management of documents, Dashboards, reports, and PPS 2007 monitoring for dashboards and scorecards integrating with ProClarity Analytic Server.

Confidential

Growe Technologies Sr. Management Consultant/Architect

• Created working document outlining an enterprise data management strategy that suggested strategies required to add value and how to be successful with these strategies; made sure working document outlined need for significant business sponsorship with clear business drivers, mandates, objectives and milestones.

Confidential

KForce Sr. Management Consultant/Architect

• Implemented data integration process using SQL Server replication to staging system then SSIS to load data of Viper system consisting of customer relationship management data and order management system data to enterprise data mart, mentoring staff and setting direction following Microsoft DW Toolkit with SQL Server 2005 as the enterprise database management system and ProClarity as presentation.
• Set up data governance, best practices, standards and procedures along with why this is important to IS and the business now and in the future; mentored IS resources on importance of data as asset to Confidential and how this data adds value to the business within the Data Warehouse environment.

Confidential

Consultant/Architect

• As Senior Consultant within Enterprise Data Management practice working on SQL Server migrations from SQL 2000 to SQL 2005 worked with and partnered with clients to help implement data management strategies; completed assessment for client requesting help identifying issues reducing costs with one of their mission critical applications with identification of space organization on SAN, SQL server configuration changes plus index processing and maintenance.

Confidential

Data Systems Manager/Sr. Management Consultant/Architect

• Established new department, Data Systems Management of data architects and database administrators mentoring what each role is, the value of each role, and responsibilities of each role; formed partnership with business clients and departmental peers on what services DSM was providing, what services clients would like DSM to provide, and what services DSM no longer needs to provide.
• Managed all aspects of the Cognos Finance data mart project including sourcing of data, ETL development, profiling of data, quality checking of data, design, and implementation; formulated plan to partner with business to pull all customer data from distributed environment to implement one version of the truth of customer data for new Salon spa application system.

Confidential

Head of US Brokerage Data Management Services/Architect

• Challenged to improve productivity and reduce costs through improved uses of technology, authored plans and strategies to centralize data movement and software development processes along with consolidate/upgrade servers and establish consistent standards to eliminate unstable, highly mixed operating environment; authored best practices, methodology for DW/BI/Application systems to increase productivity and availability of mission/business critical applications.
• Implemented change control and process documentation for all aspects of the business including new database development and database upgrades, deployed database, hardware monitoring system including multi-tier paging alerts for system issues and initiated metadata management strategy focusing in on business needs to store business data information in centralized location for all business units.
• Challenged to improve productivity and reduce costs through improved uses of technology. Authored plans and strategies to centralize data movement and software development processes along with consolidate/upgrade servers and establish consistent standards to eliminate unstable, highly mixed operating environment.
• Architected, designed and implemented Data Integration strategy using Ascential software Data Stage, Profile Stage, Quality Stage, Meta Stage and Audit Stage to centralize and manage data integration.