Solution / Data Architect (cft) Resume
NJ
SUMMARY:
- Very experienced and objective - oriented IT professional with successful track record of delivering cost-effective and quality IT solutions for global business requirements
- Experienced in IT functions - Data Architecture / Data Management, Data Analytics, Application Service Management (ASM) and Application Development Management (ADM), Change Management, Security Management, Compliance (ITIL, SOX), IT Operations, Help Desk, QA, Staff Development / Training, etc.
- Extensive technical and management experience in developing and implementing strategies & solutions for various functional and technical areas in IT, Data Management (Master / Reference Data Management, Database, Business Intelligence, and ETL), Infrastructure (Cloud, Servers, Storage), IT Managed Services
- Comprehensive experience in Program / Project Management including management of Risk, Quality, Budget & Time
- Excellent leadership, team-building, inter-personal, presentation, and communication skills (including C-Suite Level)
- Gained enriched experience in large number of industries, organizations, projects, technologies, etc. by providing IT Services.
TECHNICAL SKILLS:
Project Management Tools: MS Project Server, MS Project, MS Office Suite, Share Point, CA Clarity PPM, HP PPM, etc.
Operating System: HP-UX, Solaris, Windows, and AIX
Big Data: Hadoop, GemFire
Database Implementations: Replicated / Standalone Databases, Data Marts, Data Warehouse, ODS. MDM, RDM
Database Technologies: ORACLE (v5 to 10), Sybase 10/12.5, and MS SQL Server 2000, SQL 2005, SQL 2008, DB2
Data Modeling Tools: Visio, Erwin, ER Studio and Power Designer
Oracle Tools: Oracle Enterprise Manager, Performance and Diagnostic packOracle Client Tools (Forms, Reports), DB Artisan, SQL*Navigator
Oracle/Utilities: Oracle RDBMS versions 5 to 10g, SQL*Net, SQL*Plus, Export /Import, Loader, RMAN
Oracle/Adv. Technologies: Replication, Multi-Threaded Server (MTS), Query OptimizationDistributed Databases (SQL*Net), Data Warehouse, Familiar with RAC, Streams, ASM
Oracle Database Support: ERP Applications (Baan, People Soft, and J.D.Edwards’ One World)
Application Tools: Blue Martini, Cold FusionApplication Servers - IPLANET, Web Logic
EAI Tools: IBM/MQ, and TIBCO Messaging Services
Sybase Tools: SQL Advantage, Sybase Central, Power Designer
MS SQL Server Tools: Enterprise Manager, SQL Query Analyzer, DTS, SSIS, TSQL
Business Intelligence: ETL ToolsCOGNOS, Micro-Strategy, Business Objects, Informatica, Data Stage
UNIX Tools: Shell Scripting, SAR, VMSTAT, and PRSTAT
Programming Languages: UNIX Shell, AWK, PERL, ‘C’, BASIC, COBOL, SQL, PL/SQL
Requirements/Testing Tools: IBM Rational Suite, HP-Quality Center
High Availability Solutions: Veritas, NetApps, EMC/SAN Storage, Oracle Data Guard, Database Replication/Clustering
PROFESSIONAL EXPERIENCE:
Confidential, NJ
Solution / Data Architect (CFT)
Responsibilities:
- Responsible for creating Solution Architecture for multiple business requirements - Enterprise Learning & Development Tool (ELDT), Consumer Loans & Mortgage Loans for CRA Reporting
- Designing solutions using standards and policies for Data Management, Data Architecture, Data Analytics, Data Integration, Records Management, Data Governance and Data Quality
- Creating solution architecture with integration to enterprise systems like - IAM, ARM and Entitlements for small to large global solutions to meet business requirements
- Identifying opportunities for Master Data Management, Data Analytics, Data Warehouse / Lake, etc.
Confidential, NJ
Enterprise Data Architect
Responsibilities:
- Developed methodology and framework to defining Roadmap for Enterprise Data Management and Data Architecture
- Developed approach for enhancing Enterprise Data Maturity using CMMI’s Data Management Maturity Model
- Used CMMI’s Data Management Maturity Model to assess current Data Management Maturity, to identify barriers in enhancing maturity levels, using data processes dependency matrix to define roadmap to achieving higher levels of Enterprise Data Maturity
- Authoring a book on “Enhancing Enterprise Data Management Maturity”
- Developed Data Architecture solution for Financial Crime Detection, Alerting, Reporting & Mitigation by integrating AML, KYC, ABAC, & other compliance systems
Confidential, PA
Enterprise Data Architect & Information Program Manager
Responsibilities:
- Apply Enterprise Data Architecture principals and enhancements to optimize Data Management landscape Confidential Fortune 500 organizations
- Adopt CMMI’s Data Management Maturity Model to assess and enhance Enterprise Data Management Maturity
- Document Current State Architecture, identify Target State Architecture, and define Architecture Roadmap to Target State Architecture
- Develop Enterprise Data Strategy, Data Governance framework, Data Quality process and re-architected existing Data Solutions
- Architect business solutions using Data Analytics and Data Science to provide Financial Operations Management and SLA Reporting on millions of transactions leading to optimization of operations and financial savings
- Create architecture design for Risk Management framework using AML, KYC, and other compliance / regulatory systems
- Manage all aspects of Programs - Resource, Quality, Timeline, Budget ($.5-$5M), Risk and Communication using PMO guidelines
Confidential - PA
Director (Enterprise Data Architect) & EIM Program Manager
Responsibilities:
- Program Management & Data Architecture oversight of Enterprise Information Management Program (Budget: $1 to $5M) of PMO
- Instrumental in adopting CMMI’s Data Management Maturity (DMM) Model & conducting baseline assessment of Enterprise Data Maturity
- Developed Enterprise Data Strategy, Data Governance framework, Data Quality process, and enhanced Data Development processes
- Defined Current / Future State Data Architecture, along with data artifacts like Erwin Data Model, Data Dictionary, Business Glossary,
- Identified data related challenges and developed a strategy to mitigate the challenges by defining data roadmap and milestones
- Enhanced Information Management alignment to Business Strategies by developing solutions for Self-service Reporting, Data Monetization, Predictive Analytics by technology adoption (Netezza), identifying IT skills gaps
- Authored whitepapers on Data Management Maturity and enhanced CMMI’s DMM Framework with metrics and roadmap generation
- Provided Data Architecture oversight and expertise to Digital, Middle-ware, and Business Process Management (BPM) Programs of PMO
Confidential
Enterprise Data Architecture / Program Management
Responsibilities:
- Responsible for Solution / Data Architecture for managing Financial Crime & Intelligence & Financial Investigation for all Global business units of Confidential, drawing and data modeling of data from underlying compliance systems
- Empower Financial Crime Team with Financial Intelligence as follows:
- Provide a global dashboard view of integrated AML, KYC, ABC, and other compliance systems
- Management Reporting on Case Management Progress using Dashboards, {Predictive Analytics, Data Mining, etc.
- Managed all SDLC phases of four Work Streams - Data Acquisition, Data Analytics / Reporting, Financial Intelligence - Case Management & Issue Tracking, and Financial Crime Global Search
- Responsible for all phases of Architecture - Current to Target State, Solution Architecture and Roadmap compliant to TOGAF Framework
- Managed Project Plans, Dependencies, Communication, Risks, Issues, Resources, Quality, Timeline, Budget ($5M), etc. per PMO
- Solution Architecture consisted of systems for Anti-Money Laundering (AML), Know Your Customer (KYC), Anti Bribery & Corruption (ABC) using industry established software as Mantas, Actimize, Oracle OEDQ, Hadoop, Tera Data, Oracle, etc.
Big Data Architecture
Confidentiall, Raritan, NJ
Responsibilities:
- Manage development and implementation of Proof-of-Concept for creating a Data Lake using GemFire, Hadoop and SAP
- Create solution architecture for the Big Data POC to ensure business needs are met
Enterprise Data Architecture / Program Management
Confidential, White Plains, NY
Responsibilities:
- Provide Procurement Spending Analytics solution to client for strategic budgeting and planning to optimize Global Spending and Savings
- Perform Program Management - WBS, Budget ($3M), Plan for Resource/Risk/Issue/Communication per PMO guidelines & framework
- Create Solution Architecture and Data Models with SAP instances, Data Integration, Databases, ETL, BI & Analytics components
- Engage with five regions - Brazil, North America, EMEA, Asia and South America to elicit business requirements, source data and to develop Global Spending Operation Data Store along with Analytics and BI Reporting
- Manage off-shore teams and coordinate with onsite client groups for all phases of the project
Confidential
Program Manager - Master Data Management
Responsibilities:
- Manage Global Master Data Management Program for Customer and Product Data as part of PMO
- Manage external solution delivery vendor and oversee Project Scoping, Budgeting, Defining Work streams, Creating Project Plans, Teams, Communication Plan, Risk/Issue Management, Quality Management, Dependency Management, Management Reporting, etc.
- Manage Budget ($1M), Project-level Cost-Benefit Analysis, MDM Roadmap, etc.
- Oversee Data Governance and Data Quality Initiatives
- Develop Solution Architecture utilizing SAP & non-SAP source systems, Data Integration, Databases, ETL, BI and Analytics components
- Ensure timely delivery of projects that meet defined scope within budget and meeting quality criterion defined by business
Confidential
Program Manager - Master Data Managemen
Responsibilities:
- Responsible as part of Global PMO for Program Management of Foundational Systems - Master Data Management (Customer and Product Master Data), Reference Data Management, Domain Architecture (Integration Shared Services), Business Intelligence, Corporate Reporting and Financial Payment Systems
- Program Management responsibilities include Project Scoping, Budgeting ($100K-$1M), Defining Work streams, Creating Project Plans, Teams, Communication Plan, Risk/Issue Management, Quality Management, Dependency Management, Management Reporting, etc.
- Manage MDM Roadmap, Budget, Project-level Cost-Benefit Analysis, New Data Source On-boarding Process, etc.
- Oversee Data Governance and Data Quality Initiatives
- Provide Technical / Architecture leadership to technical team to architect an effective MDM solution
- Ensure timely delivery of projects that meet defined scope within budget and meeting quality criterion defined by business=
Program Manager / Information Management / Architecture
Confidential - NY
Responsibilities:
- Provide Program / Project Management leadership to manage scope, plan, schedule, architecture, approach, risk, quality, cost, etc. of multiple Information Management multi-year initiatives as part of compliance to ICD-10 Diagnosis and Procedure Codes
- Responsible for Delivery of ICD-10 Compliance solution and Architecture impacting Mainframe generated files, ETL Processes, Data Warehouse Design, Data Modeling (using Erwin), Data Integration and Business Intelligence Reporting capabilities to support Business Applications - Claims Processing, Memberships, Lab Data, Vendor Feeds, Reference Data, etc.
- Create an inventory of all objects across various technology areas within Information Management data flows and identifying all objects to be impacted by changes due to ICD-10 Compliance for Remediation, and providing the information in a Dashboard
- Document Project Charter, Scope, Business Requirements, Technical Requirements, Remediation Approach Remediation Effort Estimates, Resource Requirement and other artifacts required for successful delivery of ICD-10 Compliance solution
- Manage adherence to Confidential Health’s EPMO (Enterprise Program Management Office) guidelines for PPM (Project Portfolio Management), PMLC (Project Management Life Cycle), SDLC (System Development Life Cycle) covering project planning, monitoring, reporting, communications, budgeting ($4.5M), time lines and all other aspects of Project Management)
- Providing Information Architecture oversight / roadmap for developing MDM solution, applying CDM and LDM modeling techniques
Program Manager
Confidential, New York
Responsibilities:
- Lead projects to strategize, develop & enhance Pay Model for Digital Media Subscriptions, Analytics and Dashboard / ABC Reporting
- Responsible for Architecture (using TOGAF Framework), Data Modeling (using Erwin), Data Integration, Customer Relationship Management, Data Warehouse, Executive Dashboards, Data Marts, Reference Data, Siebel MDM solution and Business Intelligence Reporting capabilities to support NY Times Digital Subscriptions, Customers information, ABC Reporting, etc.
- Document current state and evolve future state architecture for Data Assets in supporting Business Requirements / Goals
- Manage data intensive projects using Predictive Analytics, Big Data, Data Mining, etc. to align marketing campaigns to data trends
- Provide direction to business/data analysts, DBAs, ETL/Business Intelligence professionals, QA in supporting existing environment and in successfully developing and implementing new solutions / enhancements
- Manage multiple projects end-to-end, including project schedule, milestone, budget, communication, risk and quality,
- Provide inputs to senior management for process improvement related to project delivery and management
- Improve IT processes related to Management of Change, Incident, Problem, Projects, Production Support, etc.
- Setup Data Governance and Data Quality processes to improve Data Quality and Accuracy
Sr. Program Manager / Enterprise Data Architect
Confidential
Responsibilities:
- Manage project to develop Data Warehouse and Business Intelligence Reporting capabilities for Wholesale Division
- Provide leadership to a team of business analysts, data analysts, data stewards through all phases of the project
- Manage all aspects of project from schedule, milestone, budget, communication, risk, quality, and integration to existing systems
- Define data integration and data quality requirements for ETL module, reporting requirements for Business Intelligence
- Ensure business requirements are fully met with supporting solutions in relation to data model, dimensions/measures, summarizations, star-schema, etc.
Confidential
Sr. Program Manager - Information Technology & Information Management
Responsibilities:
- Managed multi-million dollar Client Engagements, Projects and Programs related to business and technology transformation
- Managed Off/On Shore Delivery Model in diverse technology and business areas like Managed Services & Global Operations, Application Development, Information Management (Data Architecture/Data Governance), Enterprise Architecture, ecommerce, Infrastructure (Cloud Computing, Virtualization, Storage-NetApps/EMC, Servers-Solaris, AIX, HP, Data Center-Migration/Setup, DR/BCP), QA/Testing, Compliance/Risk, ERP (SAP ECC, SAP/BW, Oracle, PeopleSoft), Analytics / Business Intelligence, etc.
- Managed program / projects involving technology and data transformation from Oracle / PeopleSoft ERP to SAP ERP
- Managed all aspects of Client Engagement Programs including Charter/Vision, Scope/SOW, Objectives, Schedule/Plan, Risks, Resources, Budget ($1-40M, Client expectation, Communication, Business Development, RFI/RFP, Quality, SDLC Phases, Release / Change Management, Resource Supply Chain Management, Vendor Management, Contracts / Negotiations, etc.
- Managed Programs & Projects globally, involving diverse teams, cultures, time zones and technologies, using various PDLC methodologies (Agile, Waterfall) and providing metrics based progress reporting (Earned Value, etc.)
- Aligned business user requirements to IT Business Technology Services, monitoring / tracking organizational goals, SLA’s & KPI Metrics, and ensuring solution architecture/delivery of services within budget, within stipulated time-lines & aligned to TOGAF
- Demonstrated leadership & challenge project teams to adhere to standards / governance policies & to deliver best performance
- Provided guidance and set direction for various technical teams in adopting standards, in following governance policies, in developing Enterprise Architecture artifacts & road maps
- Responsible for exploring opportunities for providing new services to enhance revenue opportunities
Confidential
Sr. Program Manager - Global PMO / Information Management
Responsibilities:
- Managed PMO groups to ensure Confidential /Wyeth integration is on track to achieving synergy savings within budgeted cost
- Project Management of Data Architecture, development and implementation of a Data Management solution to build a PMO Dashboard, Data Warehouse and Business Intelligence capabilities for Global PMO managing a budget of $1Billion for Confidential -Wyeth integration to monitor and manage program-health related information for over 300 Programs across 12 LOB
- Program Management of multiple projects related to Data Center consolidation / sunset / setup, Infrastructure Upgrade (EMC/NetApps, Servers and CISCO), Application Portfolio Management, and Data Consolidation / Virtualization.
- Gathered business requirements for Trend / Predictive Analytics, look-ahead projections, drill-down capabilities, dash-board and program health reporting using Business Intelligence on risk/issues, Trend / Predictive Analytics, monthly reports, source systems, etc. and architecting solutions using onsite/offshore resources
- Managed Data Quality, Data Architecture, Data Governance, Data Analysis/Integration, Data Migration/Integration of program data from diverse source systems, Change Management and Release Management
- Identified opportunities within data domains for highlighting trends, risks, and issues enhancing business intelligence for PMO
- Developed client relationship to meet SLA for existing programs/projects, and explore business development opportunities
Confidential
Enterprise Architect & Program Manager
Responsibilities:
- Develop Current State Architecture, Target State Architecture, and Road Map keeping Technology and Business strategies aligned
- Develop architecture patterns to leverage sharing, standardization across organization, deliver business value/efficiency Confidential low cost
- Guide and Manage projects, providing architectural governance towards Target State, providing direction towards adoption of standards, methodologies and improved processes., designing Service Oriented Architecture (SOA)
- Perform Architectural Review of technology spending/budget and processes/projects/products to ensure alignment with Target State and Road Maps, and driving resolution of conflicting views / priorities towards optimal solutions
- Evaluate & develop technical architecture with Storage-NetApps/EMC, Servers-Windows/Solaris/AIX/HP-UX, etc.
- Optimize IT tools and processes supporting Management of Application Development (SDLC), Programs/Projects (PMO), Change Management, Release Management, Incident Management, Problem Management, DR/BCP, etc.
- Manage Project and Architecture for VSAM to DB2 Migration from legacy system involving Data Quality/Cleansing, Data Architecture Governance, Data Migration, Business Rules Management, and all aspects of Data Management
- Develop and implement IT Policies for SDLC, Project Management, Security, Patch Management, Change Management/Control
- Communicate technical approaches/solutions to management, business and technical audiences; facilitate buy-in by stakeholders
- Provide IT management on technology projects, ensuring compliance with established architecture principals using TOGAF
Confidential
Technical Program Manager / Architect, New York, NY
Responsibilities:
- Project Management and Data Management of nine technical streams including development of Operational Data Store (ODS) and Data Warehouse, Master Data / Reference Data Management, Data Architecture, Data Governance, Customization of a Document Management product (Laserfische), Configuration Management, System Integration, Infrastructure procurement and Data Center setup (primary and fail over), Alignment of application security model with Enterprise Security Model, Product Development/Enhancement, Manual Data Cleansing, etc.
- Perform Business Analysis - identify Subject Matter Experts (SME), schedule Business Process Review (BPR) / Joint Application Development (JAD) sessions, Document business requirements as Functional Specifications, Get sign-off on Functional Specifications from users, etc.
- Apply best practices related to SDLC standards for managing system development project from Business Analysis through Design/Development/QA, and UAT/Implementation, including evolving and implementing procedures for Release Management, Change Management, Communications, Application Development, Security, etc.
- Responsibilities include creating project schedule from Work Breakdown Structure, managing project teams, task allocation/prioritization, interaction / contract negotiations with client and sub-contractors/vendors, evaluating project risks, and managing project scope.
- Technical responsibilities focus on strategic solution to technical/architectural issues, providing stable, efficient and scalable architecture environment, development of efficient data architecture/models, managing various sub-project teams and their inter-dependencies, etc.
- Security related responsibilities include implementing measures to protect privacy of educational data from system administrators, potential hackers, developers and unauthorized business users using Data Masking and Data Encryption products
- Provide architectural oversight, data center setup, creating procedures (change and release management), hiring, mentoring, client presentations, and driving collaborative efforts with diverse teams to meet set objectives
Confidential Management
Enterprise Data Architect Manager, New York, NY
Responsibilities:
- Provide technical leadership in developing strategy for Data Architecture and Infrastructure Architecture for Enterprise Systems/Applications/Databases, BCP/DR, Data Warehouse and related +25 Data Marts (15 man year project), for Migration of existing Data Warehouse, and for loading data from existing Data Stores.
- Perform Business Analysis to gather requirements and create functional specifications and architecture plans for:
- Enterprise Data Warehouse, Master Data Management / Reference Data Management / ACCORD Model
- Customer-facing insurance application (MyTMM) and its back-end Data Mart,
- Building Compliance Application Architecture (AML/OFAC, ITIL, SOX)
- Work with business community to identify SLA, information needs and opportunities to provide efficient solutions using Data Management technologies (Databases, Business Intelligence, ETL, Middleware) and Application development tools to meet business information requirements related to P&C, Worker’s Comp, Ocean Marine, Auto and GL insurance.
- Responsible for IT Audit, Risk and Security Management; develop risk models for monitoring IT risk levels; monitor and report progress on implementation of ITIL, SOX, and JSOX compliance standards in IT covering all IT operations.
- Support management functions like Budgeting, Licensing, Resource Management, Resource Vendors / Suppliers, Hardware/Software Procurement and Change Management (Member CAB).
- Manage multiple projects, functional teams leads, matrix teams, consultants, multiple locations and provide management and hands-on leadership to Data Management team - Team Building, Planning (Tactical and Strategic), Skill Development, Hiring/Firing, Performance Reviews
- Ensure Data Governance, adherence of, and establishment of Data Management standards, procedures, controls, etc. to align with business SLA and information requirements; Create Enterprise Data Models (CDM / LDM / PDM) using Erwin
- Maintain high availability of database infrastructure including distributed database connectivity, software/application upgrades and conversions, disaster recovery site, etc.
- Implement ITIL Processes (Change, Release, Incident, Problem, Security & Configuration) and meet SOX compliance objectives.
- Performed Vendor and Product selection, and proof-of-concept (POC) for Data Masking and Data Encryption solutions
Confidential
Vice President - Data Management, New York, NY
Responsibilities:
- Provided IT Data Management for Americas on behalf of Credit Suisse TIS (Technology Infrastructure Services) - Data Management, Data Warehouse, Business Intelligence, Master Data Management, Reference Data Management, Data Architecture, Data Governance, Security, Design/Modeling, Architecture, Performance Tuning in Global distributed environments
- Conducted Business Process Review sessions with business users to create functional specifications for development of business solutions & enhancements - Assets under Management (AUM), Portfolio Management System, Corporate Actions System, etc.
- Created standards and procedures for quality of services, optimized processes to enhance process maturity,
- Provided high availability and performance of IT Infrastructure, participating in Disaster Recovery and BCP strategies
- Manage infrastructure projects, and adherence to compliance standards like SOX, and to internal security standards
- Participation in Global IT Committees (APAC and EMEA) and Change Advisory Boards/Forums
- Mentor IT team-members, review performance of all staff, and plan training requirements of staff
- Instrumental in achieving SOX compliance, Technology Audits and implemented Change/Release Management processes.
- Accomplished major global integration, hardware upgrade, and database migration of Portfolio Management systems of USA and UK for Credit Suisse, involving international locations and global diverse teams.
- Managed and supported IT projects related to merging of Asset Management Division with Alternative Investments
- Performed Project Management of Database Migration (MS SQL, Oracle, and Sybase) as part of multi-Data Center relocation project including primary and DR sites, with zero impact on business
- Managed a team of Data Management professionals in a direct and matrix reporting structure for Americas.
Confidential
Enterprise Data Architect and Project Manager, NJ
Responsibilities:
- Project resource requirements for DBA Group, mentor/guide team members and developers, manage/administer database support activities in a production and development environment, and support up to 45 Oracle, SQL Server, DB2, and Sybase databases
- Confidential - Private Wealth Group - Manage projects to define Enterprise Architecture and to separate Infrastructure, Database, Business Intelligence and ETL components from Confidential centralized infrastructure into dedicated Private Wealth Group environment
- Project Management using cross-functional resources to meet requirements in financial (Asset Management Applications) and non-financial computing environments, including preparing project plans and prioritizing tasks on concurrent projects
- Managed business analysis function as part of project management responsibilities to create functional requirements for development of business solutions
- Manage post-merger activities of IT teams of various group companies, including database migrations, alignment of all systems and Data Governance guidelines to Enterprise Security Model, implementing standards, etc.
- Managed projects using Informatica, data warehouse, COGNOS technologies
- Performance tuning, monitoring and 24x7 support of OLTP, VLDB, distributed database, data warehouse and mission-critical financial environment using Data Guard, Data Stage, and OEM
Confidential
Database Manager, New York, NY
Responsibilities:
- Responsible for global Oracle databases in production and development environments, designing databases, evolving database architectures, data governance, monitoring & tuning database performance, managing change control, etc.
- Provided leadership to DBA group in planning capacity, mentoring, scheduling, and training needs
- Provided project management, enterprise database administration, security management, and supported complex distributed and replicated database architectures for transactional and ERP based applications (Oracle).
- Ensured database infrastructure is current - Oracle upgrades, and patches, and migration/conversion
- Architected and managed project to develop Change Data Capture (CDC) procedure
- Researched & prepared business proposals for Oracle upgrades from Oracle 8i to Oracle 9i, or to Oracle 10g, including RAC
- Create/Maintain data models using data modeling tools like Power Builder, Visio, Erwin, etc., developing stored procedures, triggers, packages and functions using PL/SQL with a focus on data integrity, quality of data feeds, and database architecture
- Architected and managed development of database architecture for MHHE.COM web site for Confidential Companies (Higher Education) including implementation and alignment to Enterprise Security Model.
- Consolidation/Migration/Merging of IT environments of newly acquired subsidiary Companies
Confidential
Project Manager/Data Administration Manager
Responsibilities:
- Manage Enterprise-level Database Administration, providing Data Architecture, Modeling, Quality and Governance support
- Provide Database Operations support - backup management, storage management, performance tuning, user security, etc. for medium to VLDB, complex and mission-critical system.
- Develop and design databases to support business requirements in Data Warehouse, Data Mart and Operational Data Store environments building Dimensional Models and Star/Snowflake Schemas
- Provide Database Architecture support in implementing advance database features (replication, fail over, high availability, etc.), capacity planning, integrating Business Intelligence and ETL technologies
- Supported Enterprise Resource Planning (ERP) Systems like Oracle Applications, BAAN, PeopleSoft and J. D. Edwards-One World managing back-end databases
- Mentored DBA teams, providing strategic direction and implementing policies and procedures for efficiency
- Performed most challenging disaster recovery, preventing MBM CO. of Chicago from going out of business as a result of hacking
- Involved in merging IT systems of Ace H/ware and True Value, including Data Warehouse, ERP and BI Environments
Confidential
Group Lead
Responsibilities:
- Led Confidential Oracle Group in providing technical support to Oracle Business Development/Marketing, software development projects and various industries - finance, manufacturing, defense, R&D, etc. for North India region.
- Actively involved in Public presentations and demonstrations, Capacity Planning, System Configuration / Architecture, Oracle Installation, Benchmarking, Database Administration & Performance Tuning
- Acquired awareness of products like SAS, Sybase, SQL Server, Informix, Ingres, etc.
- Managed internal Training programs in various technologies
