We provide IT Staff Augmentation Services!

Data Warehouse Information Resume Profile

2.00/5 (Submit Your Rating)

Ny, GA

Technology Leadership Summary:

  • A distinguished Applications Developer, Enterprise Architect andTechnology Executivewith many years ofITleadership experience improving IT processes, standards and governance to better delivercost effective, fit for purpose,technology solutions.
  • I provide tactical and strategic IT leadership for businesses that are looking to significantly increase efficiency, productivity, revenue, and are ready to execute on a focused commitment to improve IT and business processes to achieve these goals.
  • Methodical practitioner of CMMI, TOGAF, COBIT, ITIL, Lean Six Sigma and ISOas needed, to facilitate the implementation of a scalable, business-alignedEnterprise Architecture with an emphasis on waste reduction.
  • Over 20 years experience as a data architect, designing, developing enterprise transactional databases,data warehouses and BI initiatives. Develop Master Data Managementinitiatives and implementation of governance that supports the business data lifecycle.
  • A talent for developing and sustaining strong relationships between business lines and IT that enables transparent, honest assessmentsof existing systems and processes forstrategic improvementand partnerships.
  • Very experienced in developing and managinghigh-performing technology teams,for projects, operations and maintenance that deliver predictable solutionsand operational outcomes with an emphasis on quality and meeting the SLA.
  • Manyyears of windows and web applications development utilizing Microsoft, Oracle and IBM technologies, including systems and data integration, mergers and acquisition integration, service-monitoring frameworks, implementation of SOA and SOA orchestration tools Tibco Active Matrix, BizTalk etc. .
  • Compelled to develop IT services and solutionsthat scale efficiently with businessgrowth, and can be shared by multiple business entities, in an effort todramatically reduce the total cost of ownership to lines of business.
  • Committed to consolidating and standardizing platformsacross the enterprise, as well as reduce costly change management complexity.Ability to establish a change management framework, that ensures transparent accountability by all IT domains, as well as an approval process that ensures developed and tested services are truly ready to transition to production and meet the agreed SLA.
  • Savvy Technologist who will perform regular detailed assessments of IT and business requirementsto ensure IT strategies are in alignment with, and supportive ofbusiness goals and objectives.
  • Support transparent governance and oversight that ensures senior business leadership is aware of all service delivery dates and have signed off on related impact analysis, risk assessment and service transition plans.

Core Competencies:

  • Application Development / Systems Integration Big Data Distributed Architectures, Design, Configuration
  • Cloud Solutions Strategy / Needs Analysis Offshore Resource Staffing and Management
  • Change Management / ITIL Governance Business Process Automation / BP Offshore
  • Corporate Shared Services Operations Cost Benefit Analysis / Cost Reduction
  • Enterprise Content Management / Knowledge Management Change Management / Quality Assurance
  • Business Intelligence and Data Warehousing SDLC Standardization / Audit Performance Monitoring
  • Data Integration / Master Data Management Server / Database / Network / Storage Optimization Planning
  • Client Needs Assessment / Customer Care Managed Services Assessment

Technology Experience, Hands-on:

  • Hadoop, MapReduce, HBase, ZooKeeper, Hive, Flume, Sqoop, Cloudera
  • ASP.Net, VB.Net, WCF, IIS Server, VB/Java Script, VBA, XML, XSLT, CSS, HTML, UML, ER Studio, Erwin,
  • SQL Server, Transact SQL, SSIS, SSRS, SSAS, Oracle DB, PLSQL, Win Server 2008/12, Share Point 2010/13,
  • Citrix, Exchange, AD, Team Foundation Server, TIBCO Active Matrix/EMS/ESB/Data Exchange, SpringCM, Service Now ITIL MS CRM/ERP, SAP Business Solutions, Cisco Networks Switches Routers, VMwareArchitecture

A few recent facts:

  • Quality my teams executed over 120 successful software releases across projects, maintenance, and operations portfolios with less than 2 production defect rate.
  • Increased Market Share A projected 150M gross written premium increase scaled Corporate wide Policy Administration System to handle new underwriting business designed, purchased and implemented infrastructure and systems integration end to end through corporate technology stack Provided technical project management, development through user transition.
  • Savings - 2M cost savings over first year of operations - Implemented SharePoint 2013 as the enterprise document management and storage platform. Led the vendor selection, global topology and compute specifications and design hardware/software purchase and installation user adoption and migration strategy legacy systems de-commissioning strategy and execution.
  • Savings - 1M cost savings between 2012 and 2013- Implementedfirst 4 SAAS platforms, delivering a 50 increase in user efficiency and service availability across 2,500 employees located across 20 countries. Underwriting, ITIL, Content Management, and Human Resource Platforms .
  • Global Solutions efficiency 50 bandwidth and network capacity increase for Australia and Singapore business users.
  • System Life Extension - 30 system life extension Provided strategy and implemented tactical solution that extended by an additional 5 years the organizations primary revenue generating system.
  • GRC - Secured 100 of company software assets implemented standardized SDLC guidance framework and platform across enterprise for utilization by all IT divisions developed user training program to facilitate adoption and onboarding of all IT personnel migrated all source code to secure central software repository.
  • Corporate Image Managed corporate wide re-branding initiative in support of company CEO vision delivered externally facing corporate web site presence coordinated vendor resources in conjunction with internal developers and IT teams through deployment architected global knowledge management foundation.
  • Business Continuation - Ensured 100 availability of business continuation and disaster recovery communication web sites globally moved sites from onsite location to more secure and geographically isolated location for high availability.
  • Quality Assurance Savings - Reduced A H BU quality assurance testing costs by 350k in the first yearof solution implementation.
  • Process Improvement - 1M cost reduction of federal mandatory compliance process replaced quarter-end and year-end manual consolidation of data providing fully automated integration, metrics and reports.
  • Service Level Trust - Implemented Incident Management tracking framework brokered relationships and integrated IT systems and processes that previously operated in silos provided a transparent and accurate view of incidents and efficient problem management published automated metrics and reports to help track and facilitate targeted improvement.
  • Reduced cost of ownership - Consolidated disparate CRM platforms around the globe unified teams and initiatives to save on hardware, licensing, software and staff costs. Resulted in a 200k savings in 2012.
  • Champion For Customer Care Developed team of business savvy technologists who engage business leaders to identify, document business processes that have the potential to be automated or simplified. We develop simple re-useable solutions, package and publish these tools to users to perform jobs efficiently and accurately. Projected underwriter productivity increase of 20 .

Confidential

VP Corporate Applications Shared Services Division

  • Directive from COO to provide enterprise architecture strategy and leadership to a struggling Corporate IT Division, which consisted of more than 10 distinct technology platforms, operations, maintenance and projectteams.
  • Standardized operations support protocols and maintenance procedures across all applications. Implemented business continuation and back-up and recovery procedures to ensure SLA's were more than satisfied. Facilitated the development of incident management measurements and performance metrics. Implemented consistent SDLC processeswith full accountability.
  • Managed the purchase, implementation and configuration of Tibco Enterprise products to support the infrastructure message bus and service bus architecture. Asynchronous and synchronous service orchestration designs and solutions architecture. Includes the staffing and management of project and operations support teams. In all SOA and Data warehouse initiatives using Tibco suite products Active Matrix, Data Exchange etc.
  • SharePoint Team Designed global topology and architecture to implement SharePoint 2013 as the enterprise document and content management repository. Developed user training and adoption strategy. Positioned SP2013 platform to support many enterprise wide initiatives ie. BYOD, Corp Shares Restructuring, Data Leakage Protection, Content Storage Cost Reduction etc.
  • Lead the re-branding initiative for the externally facing company website.
  • ProcedeSystem - Ceded Re-Insurance Platform Calculations, Reports, Financials . Automated many manual data entry processes and activities that provided a tremendous cost efficiency in terms of resource reduction and increased data quality, and de-creased data correction activities.
  • IRIS Policy Administration IRIS is the company's primary policy creation platform. Implemented real time data replication of policy data to downstream systems. Avoided potential business catastrophe and long-term business outage by identifying and executing the isolation of production hardware from non-prod hardware. Managed the purchase of software, hardware and the configuration and coordination of hardware dedication, OS and Version upgrade.
  • Source Code Repository Secured enterprise source code library through implementation of Team Foundation Server Platform and code migration coordination. Introduced ALM framework and templates to support Agile, CMMI and other custom SDLC Implementation options.
  • Customer Relationship Platform - Implemented MS Dynamics infrastructure and platform. Utilized by many lines of business. Supports central repository of Broker customer relationships.
  • Enterprise Integration Team - Developedthe Axis Web Services Library AWS . Support service oriented architecture SOA . Managed the procurement and implementation ofTibco ActiveX platform,developers and support staff.

Data Warehouse Information Engineering

Establish and lead the development of theEnterprise Data Hub, consolidation and standardization of business operating data. I implemented the IEM Information Engineering Management group. Staffed Data Architects, Business Systems Analysts and ETL developers. Performed vendor and software product selection activities. Provided hands-on data and technology architecture conceptualization, ETL design patterns, project management and team leadership. Managed initiation and executive presentation of program, cost benefit, risk assessment, budget, approvals and overall strategic direction through implementation.

  • Coordinated the execution of non-disruptive business data profiling, data lineage discovery and data cleansing activities.
  • Architect and documented all Data Models data landing topology, Data HUB, Operational Data Store, Warehouse and Divisional data marts, dimensions and fact tables.Documented and delivered Corporate Data Dictionary, and established the data governance committee IGO to centrally manage business data life cycle.
  • Managed the development of near real-time data integration of all Insurance business legacy systems across Party, Submission, Agreement, Policy, Claim, Endorsement and Cash business domains including, Reinsurance and A H business divisions and products. Developed data quality rules engine and automated notification system to trap potentially bad data for manual analysis prior to being released to downstream financial and GL systems.
  • Just as importantly, this initiative provided the flexible and scalable infrastructure to support several major acquisitions and mergers over the last 6 years.
  • Developed automated Data cross-referencing of all enterprise front-end applications data codes, types, lists and feeds etc. . This provides a single-source of reference datafor all lines of business that need it. Data is also published for other data consumption initiatives by Service Oriented Architecture SOA orchestration platform.Managed the development, documentation, and source code library storage of all ETL code, physical database DDL and established baseline SDLC procedures to manage the data structure lifecycle and change management of all data related systems and components.
  • Implemented enterprise service bus. Purchased hardware, software, implemented topology and capacity planning. Developed infrastructure that supported loosely coupled architecture, which enabled ease of scale for acquisition initiatives as business tripled in size.

Confidential

  • As Director of IT, I designed, developed, and deployed,Financial solutions for Prudential's Treasury Division Corporate Banking, Cash Mgmt, Funds Transfer, Money Market Investment, Finance etc. . Managedall operations, maintenance and project teams through transition to production usage.
  • Corporate Cash Flow Forecasting Systems - Developed Conceptual, Logical and Physical database models that provide a real-time data repository for Enterprise CashFlow Forecasting, MMIP, Funds Transfer, Bank Account Administration and Analysis functions, all accessible via Corporate Web Interfaces.
  • Financial Reporting - Provided full suite of financial reporting and business intelligence services to Corporate Cash Management Division, including adhocCash reports, Metrics, Forecasting data.
  • B2B Developed many on demand cash movement processing services, including tri-daily bank account cash position and balance information that are critical to Corporate Treasuries financial decision manking.
  • Prudential Secure Bank File Transfer - Designed and developed secure, encrypted data transfer services and protocols to manage the daily file transfer of hundreds of bank files BAI from Prudential's external banking partners. Staged the files, extracted and loaded the transactional data into target databases Gateway Treasury Workstation, Cashflow, MMIP etc. . This allowed Prudential to understand the cash position of all of its bank accounts, throughout the day, every day. Thus allowedthe Corporate Treasurer to make accurate and timely investments, lending and borrowing decisions both internal business units and external. Final end of day cash results were automatically fed to Oracle Financial System.
  • Business Intelligence Automated Dashboards and Excel Cash Reports QtrBusBorrowing, MMIP reporting, Cashflow Reports, Cash Variance,Enterprise Scorecard. These services our critical to Treasury executives decision making pertaining to cash rich , or cash poor lines of business and their lending and borrowing positions and cash efficiency rankings.
  • Internal Data Feeds Developed extensible services that provided data to many different systems General Ledger, SMART Wire, BankFees Sys Admin, Charms System, etc
  • Corporate Banking On-Line Account opening and approval system Gathered business requirements, provided specifications for approval developed web based bank account management system with full integration with Prudential bank partners.
  • Money Market Investment Plan Internal cash investment system Developed application that allowed internal lines of business to manage investments.FundsTransfer and Approval SystemImplementation wire transfer and approval system developed B2B funds transfer application that provided business real time management of cash transfer functions
  • Corporate Scorecard System Implementation senior management reporting system
  • Corp Treasury Workstation Implementation cash position management system Baseline implementation of corporate systems. Also, upgraded this system to web based version.Custom Bank Fees Payment System Developed in-house bank servicespayment management system
  • Regulatory and Compliance - Managed mandatory system documentation update of all applications to ensure all systems meet company standards as well as annual SOX Roll forward testing of all external and internal data feeds.
  • DR/BCP - Defined and documented all Disaster Recovery, Business Continuation plans for all Corporate Treasury businesses and systems. Conducted quarterly live DR/BCP failover for duration of 1 week each quarter to ensure process is smooth and transparent to end users, and seamless systems recovery.
  • IIS/Web Services - Implemented the topology and Initial setup and configuration of Prudential's web server hardware and managed routine maintenance on all SDLC environments. Install and configure IIS Web services, Cyberfusion, Connect-Direct, FTP services, vendor and in-house software installations.
  • Change Management - Manage the change control process and ensure signoffs and approvals for each phase of the software development cycle. Properly store and promote database objects using Serena VM Web Client and PVCS library management. Utilize enterprise Change Request Database to document and track business requirements, systems specifications. Approve, unit testing, QA and UAT results. Manage software implementation staging and provide detailed database and application install instructions for all new development and routine application maintenance changes.
  • Operations Team - Managedand lead team providingsystems operational support to business, including monitoring and execution of batch procedures which ftp incoming bank files to staging areas, clean and load financials into Treasury Workstation Systems that provide daily and intra-day enterprise account cash positions to allow business units, desk managers, corporate traders, and corporate account managers to make the best decisions on cash disbursements and concentrate funds on behalf of the Prudential General and Subsidiary Accounts.
  • Manage and lead team of Sr. Systems Analysts and Senior Developers providing daily production support priorities. Introduce new project development, review bus requirements and systems specs, and provide project scope. Develop and implement detailed project plan conduct weekly meetings with team to ensure deliverables are on scheduled.
  • Manage team of SQL Server DBA's providing daily priorities including dump and loads code staging database security management business continuation guidelines enterprise patch installs research, analysis and purchase of 3rd party software, production issues analysis and resolution.

We'd love your feedback!