We provide IT Staff Augmentation Services!

Program Manager Resume

SUMMARY

  • Seasoned professional with 22 years of experience on various Business Intelligence (BI) and Data Warehouse (DW) implementations; implementing BI packaged solution, Custom Warehouse and Near Real Time Analytics. Managed large teams and revenue exceeding $25 Mn
  • Strong expertise in enabling BI Applications across Customer Relationship Management (CRM) and ERP Analytics such as Retail Merchandise Analytics, Human Resource Analytics, and Financial Analytics
  • Experience in Big Data and Advanced Analytics
  • Managed cross - functional teams up to 200 people in on shore and off-shore model
  • Strong experience in Designing and Data Architecture with expertise in Data Modeling, Designing Framework for Data Profiling, Cleansing & Migration, Data analysis, Data archive & retention solutions, change data capture architecture, and ETL / ELT Architecture
  • Delivery-focused skills while collaborating with business partners, customers, and multiple vendors to effectively plan, communicate and execute business objectives
  • Strong experience and knowledge across all phases of implementation - requirement gathering and analysis, design, development, testing, implementation and support of BI/DW
  • Strong experience in Project Management, Project Planning, Project Estimation and Project Execution
  • Experience in pre-sales activities, responding to RFP/RFI, conducting POC, tool evaluations
  • Proficient problem-solver and motivated achiever who guides business units in applying evolving technology to business settings, while bridging the gap between the technical and non-technical entities

TECHNICAL SKILLS

Project Tools: MS Office Suite, MS Project, JIRA, Visio, Clarity, HP Quality Center, SharePoint, PVCS, GitHub

Managerial: IT Strategy, Proposals & Presentations, Project Management, Application Architecture, Quality and Risk Management, Budget & Resource Planning, Process Improvements, Business Workflow Analysis, Scope and Change Management, Product Evaluation, Team Building & Leadership, Client and Vendor Relationships

Technical: Oracle 10g/11g/12c, Teradata, Netezza, SQL Server, DB2, MS Access, Informatica Power Center, Informatica Power Exchange, Informatica Lifecycle Management, DataStage, Oracle Warehouse Builder, Oracle Golden Gate, Oracle Data Integrator (ODI), SQL Server Integration Services, SQL Server Analysis Services, Spark, Sqoop, JScape, Flume, Business Object, OBIEE, Actuate, Microstrategy, Crystal Reports, Tableau, SQL Server Reporting Services, C, C ++, Java, Pro*C, SQL, PL/SQL, Shell Script, XML, Oracle Forms, Websphere MQ, CSS, JavaScript, Erwin, Sybase power designer, DAC, Control-M, ESP, Autosys, SQL Toad, SQL Developer, Python, Putty, Amazon cloud, Hadoop HDFS, Sqoop, Kafka, Spark, HBASE, Hive, Pig, Flume, Oozie, Amazon Redshift

Oracle Retail: ORMS, ORPM, OSIM, OReSA, OReIM, ORTM, OMFP, ORPAS, OWMS, ORDF, ORDM, ORMA, JDA

PROFESSIONAL EXPERIENCE

Confidential

Program Manager

Responsibilities:

  • Managing the team to deliver the projects using Agile delivery methodology for US and India based Business Intelligence, Data Warehouse, Retail and Analytics team
  • Managing the development and implementation of next generation Enterprise Purchase Order, Allocations BI and Analytics reports. Managing the team to provide the Merchandise, Sales and Inventory data for self-service analytics and reporting
  • Leading the multi-year program for implementation of RMS at Confidential focused on the delivery of the Enterprise Purchase Order and Allocation processes. Leading a global team of associates and consulting partners to deliver the capabilities into the supply chain and merchandising businesses
  • Managed the retail analytics team on-premises to cloud migration. Guide team to load master data like merchandise hierarchy, organization hierarchy, stores data from Oracle Retail Merchandising system to Amazon S3 using Sqoop. Daily data like product, pricing, planning, sales, purchase order are migrated using Spark and weekly inventory, stock ledger data are migrated using Kafka. Data is then loaded from Amazon S3 to snowflake and created cubes at merchandise, organization and time dimension levels.
  • Guide team to develop Supplier scorecard, supply chain, inventory dashboard reports using Tableau
  • Managing multiple projects scope, change requests, timelines, milestones, budget, forecast and risk/mitigation plan

Confidential

Senior Principal Consultant

Responsibilities:

  • Worked with CXO to define the key KPI’s that would help executive to track the company progress and worked with business to define the solution for the overall company growth
  • Defined roadmap, data load architecture, self-service BI and dashboard
  • Worked to load social media data and analyze the customer buying pattern
  • Developed Self Service BI repository for business users using Tableau
  • Managed multiple data sources, identify gaps in the data capture process and make suggestions on improvements/enhancements for data hygiene

Confidential

Senior Solution Architect, Program Manager

Responsibilities:

  • Managed the EDW Development team through the software development lifecycle of major functionality releases of Retail Merchandise Analytics, Human Resource Analytics and Finance Analytics
  • Partnered with Senior Business and IT Executives to define the strategic roadmap for all corporate reporting, data warehousing, analytics, and overall data governance
  • Prepared enterprise dashboard solution to have cross channel reports, store and eComm channel in one reporting environment. This helped to sunset multiple legacy application, reduce 1200 legacy reports to 42 dashboards
  • Delivered solution architecture across multiple projects, responsible for data and integration architecture
  • Delivered self-service report capability for business users, this helped business to create their own reports and cost effective for IT
  • Led the delivery of a new, consolidated reporting solution for 1000 store locations
  • Managed IT Analytics team supporting Big Data initiatives. Led the Enterprise Analytics team responsible for continued development of data governance, staffing, and technology for Data Lake
  • Implemented compression, parallel processing and star transformation on Exadata
  • Analysis of Retail Merchandise Analytics for ORMS data load of Merchandising & Organization Hierarchy, Store, Product, Supplier, Inventory, Supply chain, Planning, Assortment Plan, Buy Plan, Financial Plan, Sales, Supply Chain, Stock Ledger, Inventory positions, Customer, Demand, Marketing
  • Analysis of HR Analytics for Workforce profile, compensation, Recruitment, Learning, Leave and Absence
  • Worked with team to load data from PeopleSoft to HR Analytics using informatica
  • Analysis of Financial Analytics for General Ledger, Accounts Payable, Accounts Receivable
  • Worked on Mater Data Management tool evaluation
  • Worked with team to load CRM Rewards Program data to data warehouse and create dashboards
  • Worked on near real time data load architecture using Golden Gate, worked on real time data load using TIBCO
  • Managed multiple projects scope, change requests, timelines, milestones, budget, forecast and risk/mitigation plan
  • Guide the Data lake team to load customer profile, rewards profile, customer contact, audited sales, product, pricing, inventory data from multiple applications to Amazon S3 using Sqoop / Spark / Kafka. Data is accessed through a Datameer for analysis and data is summarized in Hive for further analysis.
  • Guide team to create Deformalized sales tables in Amazon Redshift
  • Developed Self Service BI repository and worked with team to create Tableau dashboard reports

Confidential

Senior Solution Architect, Program Manager

Responsibilities:

  • Worked with business and IT management team to define the BI strategy, Road Map, Blue Print, Business Architecture, Annual Operation Plan
  • Worked with business stake holders to understand the business requirements and convert into functional and technical architecture
  • Delivered solution architecture across multiple projects and responsible for business, technical and data architecture
  • Head of Architectural Review Board and reviewed the architecture of all projects to make sure the team has followed architecture process and strategy
  • Defined checklist, standards for Data Modeling, ODI mapping and OBIEE reports.
  • Prepared BI Architecture, Integration Architecture, Physical Architecture, Security Architecture
  • Analysis of ODI mappings, ProC Batch process, report KPI to identify the requirement gaps
  • Worked with team to resolve Performance issues on ODI mappings and OBIEE reports
  • Guide team for the SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services development
  • Managed multiple projects scope, change requests, timelines, milestones, budget, forecast, risk/mitigation plan

Confidential

Senior Solution Architect

Responsibilities:

  • Design the overall Data Migration Architecture and Data Cleansing Architecture
  • Analysis of Oracle Retail Data Warehouse (ORDW) model, RETL scripts, ProC Batch process, KPI metrics, reports to identify the business user requirement gaps
  • Worked with business users and prepared business process flow using UML
  • Lead team for data mapping and technical design
  • Prepared the canonical message schema model for the real-time transaction data
  • Involved in the analysis of Master Data Model tool evaluation, Database tool evaluation and Customer Analytics tool evaluation
  • Prepared standards for Data modeling and data mapping
  • Prepared logical and physical data model using ERWin

Confidential

Senior Solution Architect

Responsibilities:

  • Analysis of Oracle Retail Data Warehouse (ORDW) model, RETL scripts, ProC Batch process
  • Led the analysis and developed EDW data model for the areas of Merchandising, Organization, Supplier, Purchase Order, Allocation, Retail Sales and Pricing & Promotion
  • Prepared the EDW logical and physical data model using ERWin
  • Worked on Near real time integration and batch process using DataStage
  • Designed Data Migration Architecture and Lead the team for the DataStage ETL development
  • Worked with team to develop Netezza stored procedures
  • Worked with team to create Enterprise Service Bus using TIBCO
  • Prepared the mapping to load the data from the Retail Modules to EDW data model

Hire Now