PROFESSIONAL SUMMARY:

• 4 years of experience - Project/Business Analyst

TECHNICAL SKILLS:

ERP: Oracle E-Business Suite (11g)

Technical Skills: Power BI, UAT,SDLC, MS Sales SQL, VBA, ETL via SSAS, Cubes, Relational Databases, Advanced Excel (Pivot table, V-lookup, Macro)

Tools: SharePoint, MS PowerPoint, MS Outlook, CRM, Visio, PL/SQL Server, SSAS, Advanced MS Access Database, MS Visual Studio,, Salesforce, Confluence, JIRA, AX Dynamics

SDLC Methodologies: Agile, Scrum

Project Management Tools: JIRA, Confluence, Atlassian

CRM Tools: SalesForce

PROFESSIONAL EXPERIENCE:

Business Reporting Analyst

Confidential

• Enhancing of the existing project management methodologies and practices and propose an effective model
• Translate stakeholders’ requirements into reporting deliverables
• Participate in evaluating new technologies so as to ensure the advancement of technology architecture and data within organization Business Intelligence needs
• Acquire data from primary or secondary data sources and maintain databases/data systems
• Work closely with management to prioritize business and information needs
• Track the efficacy of various initiatives and help implement the appropriate reporting and metrics to ensure desired results are being achieved
• Data analysis using Excel and SQL to analyze large datasets, Power BI and PowerPivots
• Demonstrated success with change management and leading cross functional teams to drive organizational process improvements

Project/Business Analyst

Confidential, Seattle

• Partnered with system integration teams and technical implementation partners to develop, define and trace technical requirements to support processes and system changes
• Operated on Agile SDLC methodology
• Assisted business heads with conducting business research by gathering data, identifying options, performing cost-benefits analyses, and creating non-routine reports with detailed analyses and/or proposals to create or revise management policies, business processes and services provided to customers.
• Conducted production-oriented activities by entering and extracting information from various applications and systems, manipulating data in spreadsheets; identifying and researching anomalies; and making corrections as needed.
• Lead efforts to construct workflow charts and diagrams, document system capabilities and writing specifications.
• Worked with business customers to analyze, troubleshoot and escalate business system needs.
• Anticipated the needs of technical and business stakeholders affected by process change
• Partnered with the Confidential IT team through the system development lifecycle process.
• Facilitated scheduling and conducting interviews with subject matter experts and end users for project team.
• Identified and documented business and technical requirements on Confluence, Jira - project Management software
• Determined, documented and communicated the impact of proposed system enhancements and changes to current business processes.
• Assisted team in planning and installing enhancement or new development in production.
• Assisted with the development and maintenance of user guides, job aids and other materials for application users.

Business Analyst (Sales)

Confidential, Redmond, WA

• Part of the Worldwide Incentive Compensation (WWIC) payroll team.
• Bi-monthly US payroll reconciliation of all compensation payments issued to US and international employees
• Partner with WWIC organization in conjunction with the Plan Design Managers and implementation team, with Finance, Business Groups/ Segments in the development (IT) and implementation of incentive plan designs.
• Liaise between Financial Analysts and Payroll Compensation team.
• Perform quarterly testing of effectiveness of internal controls and prepare quarterly compliance scorecard.
• Established process guidelines and improvements.
• Develop metrics and reports to assess effectiveness of incentive designs, quality and effectiveness of quotas. Partner with managed service to operationalize reporting.
• Produce reconciliation reports for payment analysis using MS-Excel, SQL Server.
• Documentation and gathering requirements across different teams like Payroll, Finance, and Sales teams.
• Develop and create Macros.
• Effective email communications using MS-Outlook.

Data Analyst (Salesforce - CRM)

Confidential, Seattle, WA

• Contributed in implementation of Sales Force - CRM Software by solidifying the excel data and processing into Sales Force - an enterprise or SaaS application (Web Based Application).
• The data in excel was prepared and transformed by using V-Lookup, Pivot tables, and Macros.
• Excel data segregation, analysis and processing of raw data.
• Worked in providing a wide range of excel, database, research, administrative general support to development Manager.

Business Consultant

Confidential

• Analyzed Medium & Low Risk Clients/ performing New Client Adoptions on Private, Regulated, Listed etc.
• Successfully processed around 50,000 new clients using KYC policies and New Client Adoption standards.
• Queried databases through SQL queries to get the right analytical & statistical data.
• Liaised with Sales, IT Department & Business Managers to ensure relevant KYC documentation is extracted and processed- ensuring effective communication of requirements.
• Conducted Preventive Crime Research, Factiva Confidential Bank databases to know the background of client.
• Prepared MIS Reports Weekly & Monthly using Excel.

Business Analyst (Accounting)

Confidential

• Managed and updated account trees and allocation tables. Continuously streamlined work process by modifying and automating the reports.
• Processed accounts receivable, communicated with vendor, and reconciled payment advice to accounts receivable journal entry.
• Reviewed accuracy of weekly expenses against corporate statement of account descriptions.
• Monitored daily cash activities including disbursement and receipt of funds.
• Assisted in preparation of quarterly financial statements as well as financial statement for audit.
• Developed ad hoc reports for management decision-making.