Cloud Data Warehouse / Etl Architect Resume
3.00/5 (Submit Your Rating)
SUMMARY
- Confidential has 16 plus years’ IT & Managerial / PMP certified project manager / Certified Scrum Master and Senior Business Analyst professional experience in operating and consulting organizations implementingIT Solutions, Designing, Architecting, requirement gathering and managing project timelines.
- Confidential played roles of Project Manager, Senior Business Analyst, Product owner, SCRUM master managing Project timelines deploying Agile (SCRUM, LeSS, ES, SAFe) or Waterfall methodology lead full SDLC cycle for building applications and mobility applications on Android and iOS platform.
- Confidential is experienced in gathering business requirements through workshops wif stake holders, designing, architecting large IT Dot Net Application Development Projects, migrating client from third party tools / packaged application like i2, Manugistics, SAS, SAP and/ or integrating wif third party tools and SAS forecasting procedures.
- Played role ofSubject Matter expert SCM architect for CRMBig 4 consulting experiencewif Confidential as employee and as subcontractor wif Deloitte
- Worked as Project / Delivery/ Program Manager, Product Owner, SCRUM master, Application Architect, Technical Lead, onsite - offshore coordinator, client liaison, developer
- Applied both managerial and technical capabilities - Business Intelligence expertise across gamut’s of tools like Cognos, SSRS, SAP Business Objects, Oracle OBI / BICS besides ETL tools like Oracle Data Integrator, Informatica and strong data modelling experience building datawarehouses using OLTP systems for TEMPeffective OLAP reporting.
- Performed Project/Program management building SaaS / Cloud ERP / CRM/ HRMS Application
- Experience in end to end project execution and delivery (SDLC)
- Experienced in Project Planning, capacity planning, resource planning, resource allocation, resource utilization, budget and cost estimation, scheduling and monitoring
- WBD, PERT, FP estimation techniques
- EV metrics and project management
- Practical Change management, Risk management, Status reporting, Stack holders reporting, Schedules tracking
- Implemented IT projects based on Agile (SCRUM, XP), Waterfall methodologies
- Having good experience in using tools RALLY, JIRA, TFS, MSProject, MSPS, SVN, VSS, PVCS (Polytron Version Control System), Microsoft visual studio Static code analysis, Resharper, Visio.
- Having good experience in managing multiple projects and accounts simultaneously
- Having good experience in resource management, performance monitoring, performance review and appraisals
- Having hands on experience in applications architecture, database/data model design and development
- Having Good experience in Application Architecture Design, Solution architecture design and building High Level Design (HLD) and Low-Level Design (LLD), Wireframes, Process Flow diagrams, Functional flow diagrams, Flow charts, Technical Requirements Specification (TRS) documents
- 5 Major Product development Projects as Program manager for CRM, HRMS, Finance & Accounting, Logistics/ Warehousing and L
- 5 Full SAP SCM ERP Global Business Analyst Lead
- Implementation leads wif Designing of overall Global ERP integration wif logistics module.
- 9 full life SDLC cycle implementations as Business Analyst leadimplementing 3 full lifecycles asDemandPlanningmanagement DP lead
- Integration Lead wif Manugistics DP, SAS and forecasting - Projects
TECHNICAL SKILLS
- SQL
- SAS Programming
- J2EE
- Oracle 8i
- MS Project /Access/Excel/Office suite
- UNIX
- CSM
PROFESSIONAL EXPERIENCE
Confidential
CLOUD DATA WAREHOUSE / ETL ARCHITECT
Responsibilities:
- Gather Business Requirements and Plan deliverables and dates / timeline.
- Design and requirement gathering workshops for integrated Oracle Business Intelligence Cloud Services and integration wif Taleo Cloud SaaS ATS software.
- Data Modeling and ETL/ ELT using from Taleo wif Design and creation of data warehouse.
- Design and architect Oracle Data Integrator and BICS for cloud base Business Intelligence and migration of Oracle BI to Cloud.
- Design and execute Workday and Microstrategy integration for HRIS reports.
- Data model RPD Logical model design Star schema creation of dimensions and fact tables.
- Project Management - Initiation, Scope management, Project Control and Monitoring / Closing.
Confidential
Program Manager/Senior business Ananlyst /SCRUM MASTER/ PRoduct owner / Project manager
Responsibilities:
- Project objective to build teh Cloud ERP application, building of teh Project charter of teh program to build CRM, HRMS, Logistics and Inventory modules. me participated in building business case for teh cloud ERP.
- Based on project requirement gathering was performed by me managing a team of business analyst documenting teh requirements.
- Built teh application wif developers and testing teh application modules using SCRUM / Agile methodology in majority cases while monitoring, controlling, and closing teh project. Manage program as Program Manager wif multiple OLTP and OLAP product backlogs for CRM, HRMS, Finance, Production Planning, Inventory Planning, and Logistics Software. Developed ETL tools and integrated Business Intelligence applications.
- Business Intelligence expertise across gamut’s of tools like Cognos, SSRS, SAP Business Objects, Oracle OBI / BICS besides ETL tools like Oracle Data Integrator, Infomatica and strong data modelling experience building data warehouse’s using OLTP systems for TEMPeffective OLAP reporting.
- Manage Agile release train for Program increment.
- Work wif Product owners and facilitate Design and requirement gathering workshops for integrated Cloud (SaaS) ERP application for Supply Chain management, Planning & Execution. Lead and architect HRMS ATS / CRM products and processes based on SOA architecture using web service API and rustful services. Enterprise SCRUM and Kanban techniques on multiple.
- Applied deploying Agile (SCRUM, LeSS, ES, SAFe) depending product size and Story - EPIC, features and user stories.
- Create CRM Product Backlog, Business requirements for CRM Contact management, Lead Management, Accounts Management wif CRM Analytics / reports & Integration wif outlook.
- HRMS Product Backlog, BRD’s for Human Resource Management System for Workforce Management, Performance Management, benefits administration, and payroll.
- Data modelling teh SQL schema for 1000 plus tables of Cloud SaaS ERP.
- Financial & Accounting module product backlog, Sprint backlog maintenance. Facilitate increments to add functionality related to accounting, journal entries, banking transactions and generation of financial statements - trial balance, balance sheet, and income statement.
- As Product Owner define product road map and Manage Supply Chain Planning & Execution SaaS application development of dot net applications. Architect Supply Network Planning, Demand Planning, Production Planning applications, bench marking against applications like SAP SCM, ATS like Taleo, brass ring, iCiMS, HRMS Workday, SAP Success factors, PeopleSoft HRMS, CRM systems like Salesforce.com SAP CRM, and many others.
- Manage Agile and Waterfall based Development of mobility apps and integration HRMS, CRM & ERP Application as Product owner wif onshore and offshore teams of 40 plus developers, DBA and IT Infrastructure professionals.
- Lead team to Build Rustful web services API’s, and Services oriented architecture.
- Define Project deliverables, timelines & Product Management of Global Application on Dot Net and Mobility applications on Android & iOS platforms.
- Build interfaces for many different customers’ existing applications, ERP, CRM, Business Intelligence suite integration or other home grown Legacy systems.
- Conduct SCRUM, manage agile based application development. Conduct sprints and daily SCRUMS. Software testing wif Testing tools like Mercury Test Director, Rational and other tools.
- Conduct workshops, meetings wif CXO’s, Directors and VP’s / stake holders to build business cases.
- Manage IT infrastructure architect and team to support. Leading CAPEX and OPEX based decisions along wif Cost of Ownership analysis for application selection.
- Manage Data Center maintenance of internal and external customers.
- Manage Virtualization infrastructure and VMware application implementation and maintenance projects.
- Manage Cisco Networking infrastructure project and team resources.
Confidential
Information Systems Manager / Senior Business Analyst /IT Director / SCRUM master / Product Owner
Responsibilities:
- Worked on Projects wif Fortune Companies using Waterfall and Agile / SCRUM implementations.
- Manage product timelines, budget and implementation methodology.
- Reporting, Dashboard and Analysis using advanced Business Intelligence expertise across gamut’s of tools like Cognos, SSRS, SAP Business Objects, Oracle OBI / BICS besides ETL tools like Oracle Data Integrator, Infomatica and strong data modelling experience building data warehouses using OLTP systems for TEMPeffective OLAP reporting. Building Kimbell Matrices and data modelling.
- Built or implement Enterprise applications following multiple methodology from Agile SCRUM Master to Waterfall or Vendor specific methodology.
- Architect and lead teams to build interfaces to integrate applications like ERP, CRM and Business Intelligence
- Lead and Manage IT Infrastructure, IT Applications Implementation and Support related to VMware installs ESX, Cisco networking strategies.
- Finance module integration.
- Manage multiple projects wif Fortune Companies for ERP and Custom Application Developments.
- Meet Decision makers CXO’s / VP’s/ Director and other key stake holders for workshops, business cases and financial budgeting.
- Conducted requirement gathering workshops wif strong experience and Background in ERP, Infrastructure, and Reporting Business Applications configuration for purchasing, MRP, Consumption Based Planning, purchase orders, purchase requisitions, movement types, Vendor master, Purchase info records, ASN's (Advance Shipping Notifications) from Vendors. He has been involved in ERP, CRM and Business Intelligence applications like Cognos, Hyperion, Microstrategy and Cloud Application like salesforce.com, workday, Confidential / Mobility application development and implementations to perform various business functionalities like Production Planning and Materials/ Inventory Management using SNP. Master data Management Applications and ensuring synchronizing master data like employee, customers, BOM, recipe/routings, resources /work centers, operations, production versions, demand management, flexible planning, MRP, capacity leveling/CRP, Facilitate SOP (Sales and Operational Planning) and scheduling.
- Conduct meetings, workshops and business case development wif CXO’s, VP, Directors and other stake holders. Attend and speak at various IT and Industry / Solution conferences.
- Multiyear IT Services projects ranging from IT applications to Infrastructure, business process, Application development/ Package deployment experience for examples - Advance Planning and Scheduling (APS) - Production Planning (Batch & Continuous processing) - Demand Planning - Statistical Forecasting - Order management - Inventory planning - CPFR - Logistics - Sales and Distribution - Lean manufacturing - HRMS - CRM - Financial Analysis- ROI/IRR/NPV analysis.
Confidential
Information Systems Manager
Responsibilities:
- Worked on SAP ECC / SAP SCM & SAP CRM applications Projects wif Fortune Companies.
- Gather business requirement understand business process of teh Business Owners.
- Implementation and integration of existing implementation and interfaces using waterfall methodology.
- Manage and handle Infrastructure VMware, Cisco Networking, and Application Maintenance.
- Customer Accounts handling.
- Corporate Presentation on IT capabilities of company to boost branding.
Confidential
Associate Consultant
Responsibilities:
- Worked on Projects wif Fortune Companies
- Gather business requirement understand business process of teh Sales and Marketing Department.
- Implement IT Projects for Fortune companies.
- Testing, Training, cutovers and deployment.
- SAP ECC / SAP SCM & SAP CRM applications implementations
Confidential
Associate Consultant
Responsibilities:
- Worked on multiple ERP Projects wif Fortune Companies
- Implemented Trade compliance product
- Implementation and integration of enterprise applications, business requirement understand business process and implement projects.
Confidential
Associate Consultant
Responsibilities:
- Worked on Projects wif Fortune Companies
- Conduct Workshops, business requirement understands business process of teh Sales and Marketing Department.
- Configure SD Module to perform availability/ATP check by ATP quantity and Product allocation during order creation.
- Mapped Special business process like Consignment Orders, Third Party Orders and Rush Order in SAP.
- Configured SD Pricing Output Taxes Credit Management, Account Determination and Output Determination.
Confidential
SAP Functional Consultant-R/3 4.0B SD modul
Responsibilities:
- Gather business requirement understand business process of teh Sales and Marketing Department.
- Configure SD Module to perform availability/ATP check by ATP quantity and Product allocation during order creation.
- Mapped Special business process like Consignment Orders, Third Party Orders and Rush Order in SAP.
- Configured SD Pricing Output Taxes Credit Management, Account Determination and Output Determination.