SUMMARY:

• Accomplished technology savvy Senior Business/Data Analyst with 10+ years of cross functional work experience helping my clients leverage technology to drive sustainable business solutions.
• Have led several large projects and global teams working with senior stakeholders, managing relationships and delivering value.
• Experienced in Analytics, Business Intelligence (BI) solutions, Legacy Modernization, ERP implementations, Process and Data modelling, Report Design, SDLC processes, workshop facilitation .
• Innovative problem solver & Successful Team Player providing Solution design & validation, building productive working relationships with clients and technical team members and relaying accurate information to decision makers.
• Trained Business Mangers/SMEs on BI tools and analytics solutions.
• Seasoned Project management and Agile skills while working with Cross Functional and Diverse geographical teams.
• Provided advisory services for risk management and mitigation, management of stakeholder expectations, development of project plan, project scope adherence, and tracking of timelines, milestones, and deliverables.
• Facilitated and deliver business process workshops, knowledge transition, and training sessions.
• Key liaison with the R&D team for the creation of business - focused, performance-rich analytics and SaaS applications.
• Outcome oriented, highly analytical with attention to details, excellent data analysis skills.
• MBA in Business Consulting and Marketing Strategy with 100% tuition waiver from a top ranked US B-School .

TECHNICAL SKILLS:

Business Process Modelers: MS Project, MS Visio, VersionOne, Blueworks Live, BPMN, BRD, Fit-Gap Analysis and & Rational Unified Process (RUP) methodologies

Analytics Solutions: IBM Cognos 10, Tableau, SQL, MS Report Builder, MS Excel, SharePoint, PowerBI

ERP: Banner Student, PeopleSoft (Campus Solution, HR, Finance), Workday Finance

PROFESSIONAL EXPERIENCE:

Confidential , McLean, Virginia.

Senior Analyst

• Currently working for the Financial Advisory Analytics practice that provides services to Fortune 500 companies utilize data to make effective decisions, mitigate and identify emerging risks through the use of various tools and analytics.
• Provide advisory services for risk management and mitigation, management of stakeholder expectations, development of project plan, project scope adherence, and tracking of timelines, milestones, and deliverables.
• Participated in stakeholder meetings to understand and document business requirements, create use cases and class diagrams to clearly depict the information flow and team responsibility.
• Designed and deployed a solution to provide data completeness and accuracy to supports lease contract analysis and evaluate the financial statement implications.
• Design advanced analytics solutions using SQL Server, excel and Tableau.

Confidential, Hanover, Maryland.

Business Analyst

• Led key project activities such as requirements gathering and analysis, gap-fit analysis, process mapping, for AAW, an enterprise data mart designed to combine the applicant tracking system and lifetime journey analytics system.
• Worked directly with the Product Owner team to define requirement and assist the SCRUM team in solution design.
• Facilitated scrum ceremonies (sprint planning, daily scrums, reviews, retrospectives).
• Analyzed the data from the Cisco Information System (CIS) views and legacy systems to understand the current state process.
• Led discussions with Key SMEs of transactional systems like Salesforce and PeopleSoft to understand the current business operation.

Lead Analyst,

• Key liaison driving project activities such as requirements gathering and analysis, gap-fit analysis, data modeling, process mapping.
• Led system integration, testing and change management activities during Lyterati implementation and system upgrade.
• Created functional specifications and requirements documents for the operational reports for each business area.
• Worked directly with university business stakeholders during onboarding of the application and any post product feature upgrades.
• Analyzed information gathered from multiple sources, developed user stories with detailed acceptance criteria using BDD approach, reviewed acceptance tests while working closely with the Product Owners and Development Team.
• Facilitated scrum ceremonies (sprint planning, daily scrums, reviews, retrospectives).
• Facilitated backlog refinement sessions to ensure stories are clear, concise, accurate & relevant.
• Showcased report features to stakeholders after sprint closing to get feedback.
• Led acceptance testing of the application and designed mock-ups and final reports in Tableau BI for new releases.
• Validated data loads & operational BI analytics.
• Liaised with off shore team on R&D and support issues post release.

Lead Business Intelligence (BI) & Data Analyst Georgetown University

• Developed a new BI platform for student and financial data to assist client in the transition from a suite of legacy applications to new ERPs such as Workday Finance and Ellucian Banner.
• Gathered business &system requirements for legacy financial, CRM and student domains and used an “affinity matrix” to collate like requirements to address them with the fewest number of BI deliverables.
• Designed key process maps for the “Student Life Cycle” while working closely with stakeholders.
• Led system integration, testing and change management activities during critical ERP implementation and system upgrade.
• Created functional specifications and requirements documents for the operational reports for each business area.
• Led creation of complex multidimensional data models and cross-functional IBM Cognos deliverables and designed mock-ups and final reports that sourced data from multiple facts and different levels of granularity.
• Helped set up Master Data Management and create a Single Version of truth.
• Managed multiple off-shore resources to design and deploy complex IBM Cognos.
• Validated reports using complex SQL scripts against the transactional system and the data warehouse in MySQL.
• Conducted knowledge transfer sessions with client’s SMEs and managers on the IBM Cognos suite.
• Led weekly project status meetings for the Office of the Director Project Management.

Lead Business Intelligence (BI) & Data Analyst

• Developed a new BI platform for student and financial data to assist client in the transition from a suite of legacy applications to new Ellucian Banner ERP.
• Gathered business &system requirements for legacy CRM and student domains and used an “affinity matrix” to collate like requirements to address them with the fewest number of BI deliverables.
• Led design sessions with key business users to identify a set of reports that are critical for supporting the university’s operations.
• Gathered business requirements for the Academic, Admissions Institutional Research, Financial Aid, Student Finance business areas.
• Designed key process maps for the “Student Life Cycle” while working closely with stakeholders.
• Led system integration, testing and change management activities during critical ERP implementation and system upgrade.
• Created functional specifications and requirements documents for the operational reports for each business area.
• Led creation of complex multidimensional data models and cross-functional IBM Cognos deliverables and designed mock-ups and final reports that sourced data from multiple facts and different levels of granularity.
• Validated reports using complex SQL scripts & Excel data validation against the transactional system and the data warehouse in Oracle SQL Developer.
• Worked with DBAs towards performance tuning in IBM Congos and Data Warehouse environment using cache management, aggregate tables, and indexes.
• Analysed information gathered from multiple sources, developed user stories with detailed acceptance criteria using BDD approach, reviewed acceptance tests.
• Facilitated scrum ceremonies (sprint planning, daily scrums, reviews, retrospectives).
• Facilitated backlog refinement sessions to ensure stories are clear, concise, accurate & relevant.
• Showcased report features to stakeholders after sprint closing to get feedback.
• Managed multiple off-shore resources to design and deploy complex IBM Cognos reports.
• Led weekly project status meetings for the Office of the Director Project Management.

Lead Business Process Analyst

• Developed process flow diagrams that provide a clear set of measurable steps for each process.
• Reviewed the core AS-IS processes for Registrar, Clinical Clerkship & Office of Student Professional Development (OSPD) departments with the Subject Matter Expert (SME) & key teams to design the Responsibility Assignment Matrix & RACI charts.
• Prepared process maps with required documentation around start & end events (boundaries), roles (swim lanes) and key gateways (decision points) and ensured that maps conformed to BPMN standards using Microsoft Visio.
• Developed process flow diagrams that provide a clear set of measurable steps for each process.
• Led design review session of process maps with SMEs & Department Heads.
• Presented the final maps to the Department Heads and SMEs to get their approvals & sign-offs.
• Identified process timings, volumes and manual interventions for follow-on analysis of process improvement and Data Quality improvement.
• Collaborated with Project Managers & SME on scope, solutions, constraints, and risks for the processes.
• Developed weekly project status report for the Director Project Management Office.

Confidential, Herndon, VA

Business Intelligence ConsultantStrayer University

• Led design sessions with key business users to identify a set of reports that are critical for supporting the university’s operations.
• Gathered business requirements for the Marketing Analytics, Student Registration, Financial Aid, Student Finance business areas.
• Work closely with stakeholders to elicit & document system requirements and key process maps for the “Student Life Cycle”.
• Designed report mock-ups for marketing analytics for out-reach, lead generation and conversion processes to maximize marketing ROI.
• Developed 50+ complex operational reports sourced from different facts and dimensions using IBM Cognos ReportStudio.
• Reviewed functional specifications and created test cases during system Go Live launch.
• Wrote SQL scripts to validate the reports against the transactional system and the data warehouse in Oracle SQL Developer .
• Worked directly with the senior managers to provide project Go Live support on IBM Cognos Suite.
• Developed the weekly project status report for the Director Project Management Office (PMO) and participated in weekly PMO meetings.
• Worked directly with the business users to provide live support on CognosReport Studio & Query Studio during Project Go Live.

Performance Measurement Analyst

• Developed a Metrics Management Framework & Enterprise BI analytics solution that measured Key Performance Indicators (KPIs) for all critical operational processes of the core departments under the COO office.
• Facilitated business process mapping workshops, requirements gathering and managed key stakeholder expectations.
• Conducted gap analysis, mapped requirements to Business Intelligence solutions to develop high-level designs for enterprise reporting tool.
• Collaborated with Project Managers & SME on scope, solutions, constraints, and risks for the current BI processes.
• Led the development of reporting & metrics management for student enrollment, financial, talent, sourcing, and grants management areas.
• Created and maintained project timelines, identified dependencies and risks/mitigation plans, and provided weekly project status reports to the Director Project Management Office.

Business Intelligence Consultant & Data AnalystDistrict of Columbia Government

• Acquired strong functional understanding of capital and operating budgeting formulation for the Office of Budget and Planning (OBP), DC Government.
• Conducted requirements modeling and end-to-end implementation for detailed financial reports for the Office of Budget and Planning (OBP) and other business users.
• Coordinated with the development and product teams to implement business analytics solutions and application services for budgeting, planning & reporting applications.
• Successfully managed the conversion of the financial data warehouse.
• Designed and developed over 70 operating and capital reports for OBP using Cognos 8.4. Wrote SQL scripts to validate the reports against the transactional system and the data warehouse.
• Developed training materials and delivered training for the OBP staff.
• Created and maintained project timelines, identified dependencies and risks/mitigation plans, and provided weekly project status reports to Project Director.
• Validated large data sets using complex SQL scripts & Excel against the transactional system and the data warehouse.
• Worked directly with the senior managers to provide project Go Live support on IBM Cognos Suite.

Marketing Strategy / Passenger Amenities Specialist DFW Airport

• Worked closely with AVP Airport Concessions team to develop and implement the below passenger amenities programs to increase concession revenue and lead generation:
• Identified locations on secure and non-secure side of the terminals with potential to increase revenue more than 100% from cross purchasing of products, while ensuring minimized cannibalization of existing concessions.
• Analyzed entertainment options for waiting area passengers and assisted planning departments with design and layout.

Executive, Management Solutions

• Managed a team of 28 personnel in the engineering systems, event management, housekeeping, and transportation departments.
• Prepared and delivered monthly management reports to client Head of Administration with accomplishments, operation cost reduction and vendor performance improvements.