Solution Architect/ Lead Business Analyst Resume
SUMMARY:
- He has 20 years of work experience which includes 15 years in Confidential Project & IT experience, worked on 9 Full Cycle Implementations across Industry verticals like Hi - Tech, CPG/FMCG, Retail (POS), Manufacturing, Utilities, Oil &Gas, Petrochemicals, Pharmaceuticals and Media;
- Proficient in transforming business need/requirements into technical solutions/design; Worked on POS DM (Point of Sale) Analytics, Sales & Operations Planning Reporting project, Financial Planning, Operational Planning and Analytical/ Executive Reporting projects.
- Excellent Interpersonal skills, conducted workshop and gather business reporting requirements from Business uses/ Stake holders like CFO, Finance Manager, Business/Line Managers, Functional Managers
CORE COMPETENCIES:
- Stakeholder management & communication
- Business & Technology consulting
- Project management & methodologies
- Integrated Business Planning
- Organizational skills, Interpersonal skills
- Business Analysis, Data Analysis /
- Technology know - how
- Project, Quality and people management skills
- Business Process and Business Domain
- Budget and Cost Analysis, Cost-Benefit Analysis
- Strategic analysis, SWOT analysis
- Enterprise systems/application/ Upgrade
- Deep dive analysis & solution strategy
- Implementation/ Cutover activities
- Requirement gathering and analysis
- Data Migration /Data Quality /Legacy application transition
- Technical Root-cause analysis /Data validation /Data Governance
- Post Go-Live and Application Support
- Identify alternatives, intuitive, perceive
- Change request /Operations maintenance
- Business transformation /Change management
- User training & training documentation
- Technology Strategy / Roadmap
ERP Data warehouse: Confidential Net Weaver BW 7.0, 7.1, 7.3 & 7.4 on HANA, BW 2.1C, 3.0B, 3.1, 3.5
Planning & Consolidation: BPC 7.5, BW-IP, BW 10.1/10.1 on HANA, EPM Ad-In
Integrated Business Planning: S&OP (RDS), S/4 HANA IBPF, SCM SCM 7.0 APO-DP, SNP, PP/DS, CRM CRM 2007 (CRM 6.0), ERP Confidential -R/3 4.5, 4.6c, ECC 5.0 & ECC 6.0
Memory: Confidential HANA, Confidential BW on HANA, and S/4 HANA, BOBJ tools BOBJ 4.0 & 4.1, Crystal Reports, Universe Designer, IDT, WebI, xCelsius (Dashboard Design), QaaWs, InfoView/ Launchpad, BODS, Analysis for OLAP, Analysis for Office edition 1.2/2.1, Confidential Front-end tools BEx Query Designer/Analyzer, WAD and ABAP Query, Confidential Fiori
Languages: known JAVA, HTML, ABAP/4 and FOX Formula Extension
Other Tools: Lotus Notes R4, Erwin 4.0, Remedy, HP Service Center, HP Quality Center/Test director, Share point, Quickr, Vistex 6.0D, OBIEE 11.1, Tableau, ANCILE uPerform.
Process Flow Tool: MS-Visio and BPwin 4.0
Project Management: MS-Projects
PROFESSIONAL EXPERIENCE:Confidential
Solution Architect/ Lead Business Analyst
Responsibilities:
-
Transform business need/requirements into technical solution/design
- Provide guidance/recommendations in building IT strategy/ roadmap
- Proficient in fit/gap analysis, business process mapping & configuration
- Collaborate with integrated ECC modules, technologies and infrastructure team.
- Provide solutions for Cross functional reporting needs, review change request
- Lead functional reviews, test planning, and support test execution/break fix
- Well versed with Budget, Forecast and Planning.
- Worked on full cycle APO-BW/BI implementations, APO-Demand Planning (DP), APO-Supply Planning (SNP), APO-PP/DS; SCM Analytics
- Data migration, legacy application transition
- Worked on Business process like RTR, MTO, OTC, FTP and P2P
- Worked on various planning scenarios, which includes S&OP
- Worked on Budget vs Actual, Forecast vs Actual, Resource Utilization Reports
Confidential
Integrated Business Planning
Responsibilities:
-
Integrated Business Planning, Sales Planning, Financial Planning (P&L), Revenue Planning (Profit Center), HR/Workforce Planning, CAPEX, OPEX, SPEND, Cost Center Planning
- Worked on consolidation - Statutory (Legal) & Management/ Inter Company eliminations scenarios, and ECCS
- Good experience with Design/Build/Configuration/Maintenance of BPC Environment
- Good experience with ECC, HANA, BW, BoBJ & BPC integration scenarios/ objects build, transports, etc.,
- BW - IP/IBPF Planning Area, HANA View, Planning Info providers (Embedded BW), Aggregation Levels, Planning Functions, Filters, Planning Sequence, user exits, BADIs, Data slices, HTML UI5/ web client/admin, Prompts/Variables, Input schedule/layouts, Analysis for Office Workbooks, Commentary reports using DSO, work status, locking/unlocking, BPFs, Retraction and Extraction, FOX Formula Extension
- BPC NW Environment, Dimensions, Properties, Members/Master data, Conversion/Transformations, Data Load, Data manager, Logics (worksheet, member formula, logic script, business rules) Security setup, System admin tasks, EPM BPC reporting using EPM add-in, EPM Input schedules, EPM workbooks, multi-sheet reports, commentary reports, work status, currency translation, Drill through, BPFs and Confidential BoBJ Advance Analysis - Office Edition BPC Reporting.
- BI skills include Managerial, Architectural, Business/Functional, Technical, Reporting, Extraction, Securities and System upgrade
- Worked on various integrated ECC modules- IS-Retail, ECCS, FICO, SD, MM, SM, QM, PP/LE, PM, WHM, HR, integration modules such as SEM-BPS, CRM, EP, SCM (APO-DP/SNP/PPDS), SRM, Integrated Planning (IP), BPC and S/4 HANA IBPF.
- Worked on Full Cycle Implementations, Module specific Enhancements and as well as application development support projects.
- Have Strong Confidential -BI/ BW configuration (Source System, DSO, Infocubes etc.,), Backend skills (ECC extractors activation & enhancements) and Front-end Tools
- Worked on specific Functional area and Cross-Functional Reports.
- Worked on Confidential and Non- Confidential source system projects
- Worked on BW Archiving project using Confidential 3rd party PBS Software.
- Worked on BW 3.x to BI 7.0 (NW2004s) upgrade/migration project
- BW-ABAP skills includes Logic flow, code review, debugging.
- Worked on Vistex 60D ( Confidential 3rd party solution for Incentive and Payback module)
- Worked on BW and BOBJ Integration projects, experienced with Confidential -BOBJ tools, Crystal, BOBJ-Universe, WebI, xcelsius, SBOP Analysis for Office and OLAP edition.
- Worked on Confidential -BWA (Accelerator), Confidential HANA and BW on HANA
Confidential
Project management
Responsibilities:
-
Involved in preparation of Quality Process & templates.
- Have Project, Quality and people management skills
- Review/define/audit standards and process, Introduced Best Practices
- Worked on end-to-end SDLC, full life cycle projects and upgrade projects
- Worked on ASAP Methodologies, Agile Methodology, Customer Specific, RAD methodology, check points, gate process, etc.,
- Proficient in establishing Support Management Process/Execution/ Deliverables
- Pre Go-Live, Cut over activities/ task assignment, Post Go-Live, Warranty/ Support
- Lead functional teams through design, build, test, and deploy phases
- Develop project plans, task assignment and manage program issues
- Collaborate with infrastructure team (Basis team) and dependent application owners
- Conduct workshops/meetings for requirements, design review and business sign-off
- Worked on Delivery Models likes: Onsite, Offsite, Onshore/Offshore, Offshore projects
- Proficient in Stakeholder management & communication.
Confidential
Technical lead
Responsibilities:
-
As a Lead Confidential BPC - BW-BoBJ Reporting Consultant, worked on FPL BPC Planning (SPEND and HCTS) Project.
- Reviewed business/reporting requirements of Spend, Head Count and Time Sheet reporting, performed gap analysis, designed, build, and delivered BPC Analysis Office edition reports, consists of Comparative A/Fc/Pl/Bud, Variance, Trend, Monthly Operative reports.
- Worked with BPC consultant during Model (SPEND, HCTS and Driver Based Planning) design and build.
- Worked with EPM Input form development team, and defined a strategy to Plan data via Input Form and Reporting via Advance Analysis.
- Worked on custom development for Commentary Reporting requirements
- Worked with BPC security team and defined security Roles and authorization setup.
- Worked with train the trainer, and prepared end-user training documents using ANCILE uPerform
- Created Input Form using EPM Add-In, and Build 40+ Reports using AO
Confidential
Responsibilities:
-
As a Lead Business Analyst/Solution Architect worked on M&S ‘eSAP Reporting’ Project.
- Reviewed multiple Confidential landscape (UK, Asia) Master data, performed gap analysis, designed, build, key master data BW objects, data flow etc.,
- Reviewed Finance (Actual vs Plan), Sales, Stock, Forecast (Sales/Stock), POS reporting requirements, and listed deliverables by phase.
- Provide technical advice, recommendations, solution strategy, and directions to BW infrastructure etc.,
- Worked on PoC project, for BU Visualization project, using native HANA models and Tableau tool
- Phase 1 Reports, Design (FS), build (BW Infrastructure/reports), transports, testing (Functional and Technical), handover documents, review with business users and sign-off.
Confidential
NetWeaver
Responsibilities:
-
As a Technical-PM/Solution Architect worked on CUP BI & BPC Project.
- Reviewed requirements, re-design the existing data model, data flow, BW infrastructure etc.,
- Provide technical advice, recommendations, solution strategy, and directions to development team.
- Prepared project plan, assign development task, milestone, daily status check, resolve issues.
- Worked with BoDS developer reviewed SQL script, filed mapping, data flow, data cleansing strategy, data scheduling etc
- Prepared test strategy, test plan, functional/unit test, plan for UAT and cut-over.
- Create OSS message, work with Confidential support team on product errors, issues
- Worked on BPC Consolidation Projects, define, review, update, monitor Project Plan and assign tasks to Project team.
- Managed Internal and External resources, status updates to Stakeholders.
- Identify alternatives, reviewed options, cost benefits, impact analysis
- Collaborate with Infrastructure team, reviewed, resolved issues
- Created EPM Input Form and EPM Reports using EPM Add-In
