Vandana Arora

847-***-**** ac0fl0@r.postjobfree.com

Business Systems Analyst

Business Intelligence Mobility e-Commerce

Excellent business acumen, analytical, and communication skills

Experienced in BA, Project Management, Testing, and Scrum methodology

Technology – MDSL Telecom Expense Management, Qlikview, Tableau, Power BI, Excel, Access, SaaS/Cloud, SQL, HP Quality Center, Requisite Pro, Visio, MS TFS, Project, Scripting, Business Intelligence/Reporting, Sharepoint, Social Media, e-Commerce

Business Processes – Sales, Marketing, Order Management, Supply Chain, Financial Reporting

Education

Master’s Degree in Accounting (Commerce), Major in Business Administration – MD University, 1995

Bachelor’s Degree in Accounting (Commerce) with Mathematics - MD University, 1993

Experience Highlights

ABBVIE, March 2015 - Current

Business Systems Analyst

Innovation & Technology Adoption - BSA to bring Androgel patient mobile app and Google Analytics in-house from Urban Airship and Digitas Health (lift and shift). The mobile app provides features such as benefit verification, prescription reorder reminder, and pill reminder. Performed root cause analysis for issues with push notification. Worked with business to validate Google Analytics data including downloads, active users, benefit verification, and technical changes. Supported PM with decision log, meeting minutes, action items.

Mobility - Lead BA and SME for global rollout of Telecom Expense Management (TEM) in 75 countries. Liaison between vendor (MDSL) and Abbvie teams (contracts, SAP, Tibco, global affiliates). Designed and developed MS Access app to performed bi-weekly HR and telecom data uploads for new & existing users in TEM from OIM, AD, and static tables. Reduced weekly ticket volume from 300 to 3. Coordinated with SAP and Finance teams to resolve issue with underpayment of taxes worth $1 million; avoided legal issue and contract termination with AT&T. Closed issue within 1 month that was open for 10 months. Performed data cleanup in MDSL to enhance data quality and reduce helpdesk ticket volume. Performed root cause analysis for invoicing issues in SAP. Automated integration between Mobile Iron and MDSL to enable enhanced security. Identified and fixed data quality issues in OIM and AD to resolution. Enabled cost allocation to departments by mapping of cost center between Field glass, Oracle Identity Management (OIM), and MDSL. Identified personal devices in MobileIron for cost savings and to meet compliance requirements for data security. Prepared training material (user guides & playbook) to onboard global affiliates. Trained and supported global teams. Performed SIT and UAT for version upgrades and rollouts to new countries.

Mobility – Increased Sales Force productivity by eliminating extraneous authentication prompts for Sharepoint Apps. BA for Single Sign On (SSO) implementation working with cross-functional team including HP, Sharepoint, Infrastructure, and Mobility. Coordinated testing across 20 Sharepoint Apps including HR, Finance, and Portal in North America and EMEA. Supported PM with action log and status reports.

IT Infrastructure – Performed data analysis, user quarantine, deployment management, and problem management to support enterprise-wide IT infrastructure and release management initiatives including Internet Explorer 11, Google Chrome, and Windows 10. Authored release management procedure documentation and deployment management user guide.

Leveraged Power BI, Access, Excel, Visio, Powerpoint, Word, Sharepoint. Excel power user including pivot tables.

GIFTVIFT, 2009 – 2015 Chicago IL

Business Analyst

Business-IT liaison to gather & document business requirements, lead process improvement workshops, conduct root cause analysis, project planning, testing, and manage stakeholders. Improved operational visibility and business decision making by leading implementation of business intelligence, data visualization, and management reporting. Implemented multiple executive dashboards, metrics, and KPIs for financial reporting, customer intelligence, and sales. Hands-on experience with Qlikview features like ETL SQL scripting to load data from/to database and files, data transformation, data modeling, joins, concat, charts, lists, drill down groups, cyclic groups, expressions, dual functions, conditional functions, variables, include, set analysis, point in time reporting, aggr, mapping, inline tables, and subroutines.

Responsibilities – vendor/tool selection, user stories/business requirements definition, stakeholder management, UI design & mockups, project management, testing, and tier 3 support.

Reduced business loss from write-offs due to fraud by 82%. Automated business rules to identify high-risk customers/orders and implemented proactive controls to minimize exposure. Further optimized process by ensuring timely response to financial disputes from customers and commercial card processor. Responsibilities included business analysis, project management, and testing.

Conducted data analysis, voice of customer (VoC) workshops/surveys, and SWOT analysis to define business strategy. Identified new product lines, pricing & social media strategy, and customer support improvement resulting in increased customer satisfaction/retention and 20% top-line growth.

Used DMAIC process to reduce misrouting of customer packages by 98%. Worked as a BA and project lead with business and IT development teams to implement solution (automated integration between Order Entry and Fulfillment) resulting in increased customer satisfaction/retention and improved margins.

Worked as a liaison with external and internal customers to conduct root cause analysis (RCA) for product pricing discrepancies and improved average order processing time from 3 days to 1 day.

Business Analyst for implementation of corporate e-Commerce system. Involved in complete lifecycle including requirements definition, vendor/tool selection, implementation & testing, integration, post-production support, and enhancements.

Conducted JAD and individual sessions with internal customers to elicit user requirements and goals. Documented user stories & functional specifications. Developed use cases and conducted specification reviews & walkthroughs with the stakeholders. Familiar with waterfall and agile SDLC.

Prepared source to target system mapping based on the business and functional requirements.

Developed test plans and worked with business to validate and execute the test cases during UAT. Validated data on application screens with SQL query results.

Worked on multiple simultaneous projects including enhancements, urgent bug fix, process improvement, new technology implementation.

Worked directly with executive sponsors, end users, and IT developers.

AAA, 2008 – 2009 Wilmington DE

Business Analyst

Worked as a liaison between Business and IT for automation of Accounts Payable (A/P) process. Responsibilities included requirements gathering, analysis, documentation, and UAT.

Met with client groups through JAD sessions and individual elicitation sessions to determine user requirements and goals. Documented user stories & functional specifications. Developed use cases and conducted specification reviews & walkthroughs with the designers, developers and stakeholders.

Developed test plans and worked with business for UAT. Validated data between SQL query results and application screens.

Technology included MS Sharepoint, MS Visio, HP quality center, SQL Server 2000, Windows 2000, MS Reporting Services, Requisite Pro, UML, MS Office

Contact this candidate