SUMMARY

• 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, Sharepoint, Social Media, e-Commerce
• Business Processes - Sales, Marketing, Order Management, Supply Chain, Financial Reporting

PROFESSIONAL EXPERIENCE

Confidential, Chicago IL

Business Systems Analyst

Responsibilities:

• Liaison between vendor (MDSL) and Confidential teams (contracts, SAP, Tibco, global affiliates)
• Performed data quality analysis and reporting/analytics in Power BI to disable unauthorized corporate data access for audit requirements.
• 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
• Leveraged Power BI, Access, Excel, Visio, Powerpoint, Word, Sharepoint. Excel power user including pivot tables.

Confidential, Chicago IL

Business Analyst

Responsibilities:

• 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.
• 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.

Confidential, Wilmington DE

Business Analyst

Responsibilities:

• 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

Confidential,Columbus, OH

Business Analyst

Responsibilities:

• Primary liaison between business and IT to implement DW and various BI reports for finance, operations, and decision support. The project involved creating a data warehouse (DW) for mortgage industry data by grouping the data by subject area and building data models for collections, recoveries, and bankruptcy. Involved in complete SDLC including planning, implementation, testing, support, and enhancements.
• Prepared Source to Target Mapping Documents for Collection and Recoveries module and BI development teams based on the business and functional requirements.
• Conducted JAD sessions and gap analysis on existing reports and DW objects. Reviewed system test plans and worked with business to validate and execute the test cases.
• Technology included MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), MS-Project, Windows 2000, Clear Case, Clear Quest.