Program Manager / Data Architect Resume
Pleasanton, CA
PROFESSIONAL SUMMARY:
- Accomplished, innovative and results - driven project manager, architect and business analyst with over 20 years of wide-ranging experience encompassing I.T Infra-structure design, planning and implementation of highly integrated systems that included Database Administration, Business Re-engineering, Asset & Data management (using Arc GIS / ServiceNow), Data Integration, Disaster Recovery and ERP Database /Application cloning projects.
- Possess rich exposure to High Performance Computing (HPC) from concept to business realization comprising of very large Data Warehouses (5-20 Terabytes) supporting massively parallel ETL processes & high volume ERP applications running on clustered SAN storage (CLOUD) and high-end servers (EMC2 storage arrays, Hitachi Unified Storage, HP Superdomes, IBM AIX, Sun Containers and Sun Enterprise state-of-the-art servers)
- As PMI certified Project Management Professional (PMP) and Certified Scrum Master (CSM), excel in communication, partnership, project vision development and team management skills, driving the business & service delivery in line with the corporate objectives. An ardent practitioner of PMI’s Agile Project Management and Six Sigma Quality Assurance methodologies. As results driven scrum master have delivered incremental quality products in multiple sprints.
- Earned Total Quality Management (TQM) for continuous process improvement resulting in improved Information System processes at FMC Corporation. Utilized ITIL V3 foundation principles to improve Change Management and Delivery of I.T systems at H.P, Wells Fargo Bank, Confidential and Confidential - Confidential .
CORE COMPETENCIES:
Enterprise Data Architecture/Design I.T Project Management (Scrum / Waterfall)
Data Warehousing/Data IntegrationSystems Integration
Data SecurityBusiness Intelligence Client Relationship ManagementPerformance Tuning
Capital Framework Planning for Banks Database AdministrationHigh Availability / Transparent Failover
TECHNICAL SUMMARY:
Databases: Oracle / Exadata, Oracle 9i/10g RAC, MS SQL Server, Mongo, Greenplum (Hadoop), Vertica, Hive
Project and Portfolio Management: MS Project, Clarity, HP Project and Portfolio Management Center, STAMP
IT Service Management/Change Control: Pac2000, Remedy, Vantiv, HP IT Service Management, ServiceNow
Analytic Reporting: Oracle Reports, Oracle Express, OBIEE Dashboards, Cognos Powerhouse, Business Objects, Crystal, Federal Reserve Bank’s Comprehensive Capital Analysis & Review (CCAR)
Data Security: Secured Shell, LDAP(Unix/Linux), Active Directory(Mac Devices), Kerberos, Oracle Data Vault
Data replication Software: Confidential SnapMirror, Hitachi Universal Replicator, and EMC2 SRDF
Data Integration/ETL: IBM DataStage, IBM MQ Series Manager, Informatica, Oracle Data Integrator
Platforms/OS: Windows 2000/NT, HP-UX, Solaris, AIX, LinuxSystem Monitoring: Oracle Enterprise Manager, Compuware ServerVantage, TOAD, Patrol OpenVision, GlancePlus, Oracle Application Manager, TIVOLI, HP Openview
Languages: JAVA, MapReduce, Perl, C, COBOL, PL/1, FORTRAN, Korn Shell, PL/SQL, SQL, NoSQL
Documentation / Technical White Papers: JIRA, Sharepoint, Confluence, MS PowerPoint, Visio, MS Excel, MS Word
PROFESSIONAL EXPERIENCE:
Confidential, Pleasanton, CA
Program Manager / Data Architect
Responsibilities:
- Worked with multiple vendors to develop data integration plan of Albertsons and Confidential functional areas
- Developed data analytics on pricing for all grocery items (warehouse or direct store delivery)
- Defined retail pricing areas by geography and national jurisdictions
- Utilized Version 1 tool for Agile SCRUM Project Management of Development and Infrastructure teams
Confidential, Palo Alto, CA
Program Manager
Responsibilities:
- Implemented H.P Split Management Office (SMO) initiatives for business owned customer focused marketing applications (such as SFDC, ELOQUA and ACXIOM) - 2015
- Integrated Omniture click-stream data with Second Sight application using Vertica (Hadoop) databases which in turn was integrated with Frank data-mart - 2015
- Worked with multiple vendors on concurrent sprints to implement the SMO initiatives to the tune of $30 million combined budget - 2015
- Added new technology direction by successfully driving applications in local data centers to HP IT Cloud, Hadoop Clusters and Vertica Databases to set up High Performance Computing (HPC) environment for faster and improved decision making. This great effort was carried out using H.P’s I.T Software and Hardware Asset Management tool, APATE, H.P’s Service Management tool, ITSM and H.P’s Configuration Management Data Base, CMDB - 2015
- Configured H.P Password application for single sign-on (SSO) user access - 2015
- As Scrum Master, coached sprint teams on Global IT operations to ensure proper network governance, efficient and quality sprint implementation - 2015
- Transitioned to Cloud computing that required setting up of large network compartments with fully qualified DNS names defined as per Network Governance rules. Worked with Global Telecommunication team - 2015
- Monitored Sprint backlog in JIRA, conducted daily stand-up meetings and provided daily status report to I.T management - 2015
- Conducted checkpoint reviews and provided weekly status on outstanding issues to the SMO office related to System Integration Testing (SIT), User Acceptance Testing (UAT) and Move to Production (MTP) - 2015
Confidential, Cupertino, CA
Senior Project Manager (Business Intelligence)
Responsibilities:
- As Scrum Master facilitated sprint reviews with the business sponsor and key stake-holders to assess implementation of Commercial Off The Shelf software and escalate any issues related to quality
- As Scrum Master, coached sprint teams on Global IT operations to ensure proper network governance, efficient and quality sprint implementation
- Installed / configured virtual Linux servers. Managed I.T Infra-structure delivery projects globally such as Data Center Consolidation, Asset & Data Management using ServiceNow / Informatica - 2014
- Utilized OBIEE 11g User Access methodology to implement IT Infrastructure Governance principles for single sign-on user access on both Microsoft (Active Directory) and UNIX/LINUX servers
- To facilitate fast failover, migrated B.I Application to run on Confidential S3 Cloud storage using Vertica Database / Hadoop Distributed File System - 2014
- As part of Data Center migration from Cupertino to Sunnyvale, configured and Implemented Tier1, Tier2 and Tier3 platforms for DevOPS to set up High Performance Computing (HPC) environment with emphasis on high availability and scalability
- Utilized HP Project and Portfolio Management Center, ServiceNow Change/Asset Management tool, Microsoft Project, Microsoft Excel (Pivot tables / Pivot charts) and Microsoft Power Point tools ( )
Confidential, Foster City, CA
Senior Project Manager
Responsibilities:
- Managed analysis phase of $2.7MM CMLS Upgrade and Consolidation Confidential 13 project related to new software development, Ab Initio (ETL) version upgrade to 3.1 and other infra-structure process improvement initiatives. The project teams (both on and off-shore) comprised of Project Manager, Database Administrator, ETL/Data Administrator, Solutions Architect, Business Analyst, Technical Writer, UNIX Administrator and Network Administrator. The team size ranged from 8 to 10 professionals. - 2013
Confidential, San Jose, CA
Senior Project Manager
Responsibilities:
- Performed Agile Project Management of I.T infrastructure delivery project (Data Center Consolidation) related to $5 billion merger of Confidential with Confidential .
- The project teams (both on and off-shore) comprised of Project Manager, Database Administrator, Application Administrator, Test Analyst, AIX Administrator, Storage Administrator and Network Administrator.
- Managed I.T Infra-structure delivery projects globally such as Data Center Consolidation, Asset & Data Management using ServiceNow and Arc GIS.
- As Scrum Master coached geographically dispersed sprint teams on Global IT operations to ensure efficient and quality sprint implementation
- Performed Quality Assurance / Testing of Sprint deliverables and released
- Utilized HP Project and Portfolio Management Center, Microsoft Project, ServiceNow Change/Asset Management tool, Microsoft Excel (Pivot tables / Pivot charts), DB2, SQL and Microsoft Power Point for above activities
Confidential, Sunnyvale, CA
Senior Project Manager / Solutions Architect (Business Intelligence)
Responsibilities:
- Managed Data Quality Improvement projects for Customer Sales Booking, Customer Shipment, Backlog, Invoicing, Customer Opportunity, Installed Products, and Service Contracts & Warranties subject areas in Enterprise Data Warehouse (EDW) and developed the ETL software for extracting source data from Oracle Financials (Account Payable, Account Receivable, General Ledger and Order Entry), Product Master Data Model, Siebel CRM, SAP CRM applications and Supply Chain Management modules.
- The project teams (both on and off-shore) comprised of Project Manager, Database Administrator, ETL/Data Administrator, Cognos, Solutions Architect, Data Modeler, Business Analyst, Technical Writer, Software Developer, Test Analyst, Operations Manager, Storage Administrator, UNIX Administrator and Network Administrator.
- The team size ranged from 12 to 19 professionals.
- As Scrum Master, coached sprint teams on Global IT operations to ensure proper network governance, efficient and quality sprint implementation ( )
- Developed Quality Plan for multiple sprints to ensure quality of data feeds into the EDW database
- Exercised project control by validating quality of sprint deliverables and monitoring time and cost variance
- Led RFP/RFI process, performed vendor management, developed and executed cutover plans for Production Releases ( )
- Utilized Clarity Project & Portfolio Management, Microsoft Project, ServiceNow Change/Asset Management tool, Microsoft Excel (Pivot tables / Pivot charts) and Microsoft Power Point for above activities
- Distributed Load and Query work loads by placing ETL (IBM DataStage) data structures & Data Warehouse facts and dimension tables on separate nodes - 2009
- Implemented IT Infrastructure Governance principles for user access on both Microsoft (Active Directory) and UNIX/LINUX servers (LDAP). Configured user access for single sign-on (SSO) - 2009
- Managed I.T Infra-structure delivery projects globally such as Data Center Consolidation and Asset & Data Management using ServiceNow Change/Asset Management tool
- Automated cloning of Customer Management & Assessment (CMAT) Application from production to staging, test and development environments using Confidential Snap Mirror & SAN technology
- Configured and Implemented Tier1, Tier2 and Tier3 platforms for DevOPS to set up High Performance Computing (HPC) environment with emphasis on high availability and scalability - ( )
- Transitioned to cloud computing for SFDC. & performed data integration of SAP CRM with SFDC - 2011
Confidential, Menlo Park, CA
Senior Project Manager
Responsibilities:
- Developed the project plan & project schedule to build highly available, scalable & secure intra-net applications using Oracle Real Application Clusters, Data Guard
- Executed the project plan to implement a system which scaled the business application
- Utilized HP Project and Portfolio Management Center to conduct project management activities