Business Systems Analyst Resume
3.00/5 (Submit Your Rating)
SUMMARY
- 5+ years of solid technical and functional experience in BPC (MS 7 and NW 7, 7.5, 10)
- Completed 4 full life cycle BPC implementations in large scale global FP&A projects
- Strong noledge of financial planning and consolidation business processes
- Expert in gathering business requirements, leading workshops, creating functional and technical specifications and use cases
- Excellent communication skills to work TEMPeffectively wif management, clients and peers
TECHNICAL SKILLS
ETL/EPM: SAP Business Planning and Consolidation (MS and NW 7.0, 7.5 & 10), Business Objects XI, SAP BW
Reporting: Cognos Report Studio, Business Objects Xcelsius, Crystal Reports, Spotfire
Databases: MS Access, SQL Server 2005
Others: UML, IBM WebSphere, MS Excel, MS Visio, MS Project, MS PowerPoint
PROFESSIONAL EXPERIENCE
Business Systems Analyst
Confidential
Responsibilities:
- Led BPC projects as a technical expert, designed solutions, setup project timelines and managed external consultants
- Implemented Sales and Cost Center Planning focused on simplified and standardized reporting for 150+ global users
- Implemented Intercompany eliminations application to improve teh monthly close process by saving 2 days
- Created interactive management reporting dashboards for analyzing sales forecast and cost center expenses using Spotfire
- Provided ability to iteratively plan and adjust multiple forecast scenarios
- Strong experience in data modeling and master data/dimension setup and maintenance
- Developed ETL rules and transformations to load transaction data, rates and master data in both BW and BPC
- Designed retraction programs to send plan data entered in BPC to ECC
- Created validation reports for master data and transaction data validation between ECC, BW and BPC
- Led teh BPC upgrade project to upgrade four application sets from NW 7.5 to 10
- Created proof of concepts for new projects in BPC to halp business users understand teh system capabilities
Senior Consultant
Confidential
Responsibilities:
- Lead Planning and Consolidation threads on FP&A projects from start to finish
- Took complete ownership of deliverables, set and managed expectations around timing, quality standards and delivery
- Managed local and offshore teams and liaised between them and client counterparts
- Led development of demo applications/noledge base that halped drive client proposals and new hire training
- Reduced teh time taken to complete P&L planning by 50% by implementing driver based models that eliminate teh need for manual calculations and validations
- Developed complex reports, input templates, business process flows, custom menus, script logic and security models in BPC
- Led design workshops wif clients to understand business requirements, created mockups and presented solution proposals
- Configured planning applications to enable “what - if” scenarios for planning sales, expenses, headcount and allocations
- Configured consolidation applications for intercompany eliminations, currency conversions and setup work status
- Trained business users globally on redesigned planning solution, supported simulations, go-live and enhancement phases
- Developed technical documentation and training manuals on using financial planning system features TEMPeffectively
- Analyzed process flows, designed use cases using Visio, UML and Business Process Modeling (BPMN)
- Conducted vendor research in consumer lending division for Customer Relationship Management (CRM) software
- Worked directly wif teh Product Pricing Director to develop comprehensive reports using Business Objects XI
- Analyzed product sales data and presented information in various report forms including charts, graphs that sliced and diced data to halp understand pricing trends