Business Ananlyst
no image
Business Ananlyst

Balachandra Shashikumar
------------ **Nagarbhavi, Banaglore**------------
EDUCATION
Master’s in Business Administration (Marketing) May 2017
Indiana University of Pennsylvania, Indiana, PA, United States
Key Courses – Marketing Research, Marketing Analytics, Logistics, Strategy, Financial Management, International Business
Bachelor of Engineering (Computer Science) May 2015
Global Academy of Technology, Visvesvaraya Technological University, India

WORK EXPERIENCE
Business Analyst Feb 2019 – Current
Societe Genrale Global Soloution Center,Bangalore
? Developed a excel dashboard using Microsoft excel Power BI tool for the alert validation of Shares, Bonds, Ratings, CWS called the Early Warning System.
? Gathered requiements fot the development team to work on a automated target system for the Early Warning System.
? Developed Excel VBA Macros to format reports from Data provided using automated click-and-run process . Excel VBA could bring down the 30mins of manual work on the data to 5min.
? Analyzed and visualized data trends of team's effort utilization using MS Excel and PowerBI tool which helped the executives to make strategic decisions for the organization.
? Designed the dashboards with the most user-friendly colors, charts and placements to make the data retrieval easily accessible to all kinds of users.
? Helped the team to generate more ideas and ask new questions about the dataset to improve our accuracies and gain more insights
? High level knowledge in handling errors and validating user data using VBA.
? Expert experience in the areas of Design, Analysis and Development of Software Applications using Access and Excel VBA.
? Provide presentations and reports to stake holders of Early Warning System involved using Excel, PowerPoint.
Business Analyst Apr 2018 – Jan 2019
IKON Software Services,Bangalore
? Gathered requierments for various clients in the US working offshore.
? Worked closely with business domain to gain full knowledge of the flow of business.
? High visibility as liaison between the business line, users and development teams throughout the project cycle.
? Skilled at Presentations, Joint Application, Joint Application Development (JAD) Sessions, Prototyping, Training, Gap Analysis, Business Application Support and Use Case Development.
? Strong ability to facilitate meetings with individuals and groups to gather, understand, and articulate their business needs.
? Collaborated with Stakeholders on Business Requirements Document
? Prepared and analyzed the existing architecture and performed Gap Analysis. Created workflow scenarios, designed new process flows and documented the Business Process and various Business scenarios and activities of the Business from the conceptual to procedural level.
? Developed test scenarios and implemented test plans.
? Responsible for effectively communicating project requirements to 3rd party vendors and monitoring progress and quality of work
? Provide presentations and reports to stake holders of each project involved using Word, Excel, PowerPoint, Visio.
Business Analyst Aug 2017 – Dec 2017
MetLife, NewJersey, United States(IKON Software Services)
? Gathered requirements and assembled Project Initiation Plan including identified project goals and critical success factors from Business Cases, Terms of Reference, Project Tolerances, and the Project Plan.
? Developed Requirements Traceability Matrix to record the requirements through each stage of requirements gathering process.
? Worked with project manager to identify best approach for gathering requirements and estimated project size using UCP analysis.
? Created Functional Requirements Document (FRD) and analyzed data/workflows; defined the scope, financial projections and cost/benefit analysis; progressed from problem statement to well-documented designs.
? Conducted sprint planning with development & QA team.
? Used MS Word and Visio to document data flow of the AS-IS process and TO-BE process.
? Conducted JAD sessions & JRP sessions to get SME’s input on how to implement the application for Group Disability Claims.
? Conducted standup calls, daily touch base, and weekly review meetings with onsite and offshore teams to coordinate and identify the bottle necks.
? Involved in Build to Run Knowledge transition workshops and documented the training materials required for the business
? Assisted the Project Manager in creating daily reports using Excel spreadsheet and develop presentations using PowerPoint to present to the business stakeholders and steering committees.
? Identified data issues and provided recommendations for resolution to ensure optimal performance.
? Prepared the Requirement Traceability matrix for both Business and technical requirements.
Business Analyst / Consultant Oracle Cloud Internship Jan 2017 – Jun 2017
GowraInfosys, United States
? Involved in Oracle HCM cloud implementation. Interacted with client and involved in Requirement gathering, preparing process requirement documents, Business requirement documents, understanding current business process and mapping with Oracle Cloud HCM.
? Good leadership and commination skills, on time deliveries, multi-tasking and assisting clients in the selection, implementation planning, fit/gap (As Is - To Be analysis) with alterative solutions for product limitations., Testing (test scripts, validations and POC's) post-implementation support in mass updates, data loading and design changes of Oracle Fusion HCM cloud/SaaS solutions at various customer sites.
? Gathered Business requirements for Integration points and mapped them with Functional requirements.
? Assisted the organization in learning the agile process and implementing agile within their Application Development environment
? Gathered client/customer requirements, business needs and project objectives, via feedback sessions and client/customer meetings in collaboration with all stakeholders.
? Gathered business requirements and prepared Change Requests by working with the client/customer IT team and coordinated with onsite and offshore implementation teams to build and execute.
? Gathered and documented supporting manuals, standard operational procedures, and technical system information to ensure that all materials are available to support customer requirements and enhancements.
? Analyzed and validated the operational and transactional data in database using SQL queries and Excel spreadsheets and developed visualizations to review with the management teams.
? Supported the Project Manager in balancing project goals and business needs and documented various workflow diagrams like AS-IS and TO-BE processes.
? Gather supporting technical and system information to ensure that all materials are available to support customer requirements and enhancements.
? Work closely with production systems and business operations teams to optimize the information exchange and to keep documentation current and relevant.
Graduate Assistant Aug 2016 -Dec 2016
Associate Dean, Indiana University of Pennsylvania
? Assisted the Associate Dean with data analysis and research work
? Prepared presentations and marketing material for the program.
Project Management and Sales Intern Mar 2016 - April 2016
SunEdison
? Assisted the Director, India regarding the solar projects paperwork to be submitted to the Government.
? Executed a project on “Implementing Small Scale Solar Power Plant” and submitted report to Indiana University of Pennsylvania
? Attended meetings on the sale of Solar Power to commercial clients with senior associate. Created a data model using data from multiple sources; which was then used to create a dashboard that provided insights into critical sales parameters

Key Skills:VBA Macros, MS Office, MS Project Management, Marketing Research, Social Media Marketing, Marketing Strategy, Marketing Logistics, MS Excel, SQL, User Acceptance Testing, BUSINESS REQUIREMENTS, Software Deployment, Requirements Gathering, Windows OS, Marketing Analystics, Mangment Consulting , Microsoft Visio,JIRA

References Provided on Request. ------------/in/balachandrashashikumar/