We provide IT Staff Augmentation Services!

Business Systems Analyst Resume

CA

PROFESSIONAL SUMMARY:

  • A talented professional with 6 years of experience and outstanding knowledge of Project Management, strong attention to detail, proficiency in Excel, Quick Book in addition to great problem solving, analytical, and critical thinking skills.
  • Experienced in writing SQL queries and executing the queries in SQL Server.
  • Extensive knowledge in MS office, including spreadsheets, Access, Power Point, Adobe and Google docs.
  • Proficient in gathering business requirements, creating UML diagrams and Mockups in Banking and Mortgage domain to manage and implement user interaction.
  • Strong Analytical and Problem - Solving skills, and Multi-Tasking abilities, with proven experience in collaborating with people and process knowledge to assist enterprises in making critical decisions and strong Technical Writing skills.
  • Experience in Business Analysis, Financial Analysis, Project Management and Agile/Scrum Software Development Life Cycle methodology.
  • Well versed with Funding, Corporate Finance, Capital Markets Regression Analysis, Monte Carlo Simulation, Value at Risk for financial risk management.
  • Experience in Product Development, Rate Implementation and Pricing Strategy for commercial business loans and mortgages.
  • Developing and maintaining project plans for all business analysis efforts and selected software deployments.
  • Experience in Business Analysis, Project Management and Agile/Scrum Software Development Life Cycle methodology.
  • Hands on Experience with Mortgage Service Package to automate loan servicing, accounting and federal regulatory reporting.
  • Expertise in interest rate derivatives and fixed income markets, commercial banking and business loans.
  • Experience in writing complex SQL queries, fair understanding about OLTP and OLAP systems
  • Excellent understanding of the various stages of the Software Development Life Cycle, Software Testing Life Cycle and Defect Life Cycles.
  • Proficient in writing and running SQL queries to validate the database and performing analysis responsibilities.
  • Expertise in Microsoft Office Suite including Word, PowerPoint, Excel, Access, and Visio
  • Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases.
  • Hands on experience in writing SQL queries for data manipulation and validation.
  • Experienced in designing Use Case Diagrams, Activity Diagrams, wireframes and mockups.

TECHNICAL SKILLS:

OPERATING SYSTEMS: Windows 08/8.1/10, UNIX

DATABASE SCRIPTS: SQL SERVER, ORACLE, MYSQL

BI AND MANAGEMENT TOOLS: TABLEAU, POWER BI, ADVANCED EXCEL

DESIGN/MANAGEMENT TOOLS: MS VISIO, BALSAMIQ, JIRA

DATABASE: MS ACCESS

CLOUD AND SOFTWARE: OFFICE 365

METHODOLOGIES: RUP, AGILE, WATERFALL

PROFESSIONAL EXPERIENCE:

Confidential - CA

Business Systems Analyst

Responsibilities:

  • Responsible for providing functional knowledge as well as manage client relationships within context.
  • Participated in interviewing area expert and asking detailed questions for project planning and deadlines.
  • Worked with project teams to analyze high and low-level requirements.
  • Utilized Agile Methodology to configure and develop process, standards and procedures.
  • Interacted with Financial specialists, Originators, Retail banking team and end-users of the application and systems of to understand the existing business processes and gather business requirements.
  • Gathered system requirements on Mortgage Service Package (MSP) such as fixed-rate, adjustable rates, credit lines, secured and unsecured loans.
  • Planned and analyzed AS-IS Business Process Workflow Models to create TO-BE Business Process.
  • Facilitated Joint Application Discussion (JAD) sessions for communicating and managing expectations by allowing different stakeholders view their perspectives, resolving any issues and final agreement.
  • Defined the middle layer architecture, Build and load the data from Data ware housing tables by using SQL procedures and packages.
  • Coordinated with Development and reporting teams to Build Reports.
  • Reviewed SQL procedures to load the data into middle layer tables and identify performance Bottle necks.
  • Optimized SQL queries to give better performance by analyzing Execution plan and AWR reports.
  • Reviewed, verified, examined, loan documents to submit to underwriting timely and efficiently by multitasking, utilizing all the tools available to me including Outlook, Excel, Phones, Email, supporting my department while managing an average pipeline of 30 files per month.
  • Evaluated debt ratios and loan to value ratios, credit scores and property appraisals, insured the qualification and justification for all the loans in my department.
  • Applied underwriting knowledge of guidelines while underwriting all types of loans including Conventional, VA, FHA, Residential and Commercial mortgage loans.
  • Researched real property records and completed complex chains of title
  • Performed in-depth reviews of tax returns, bankruptcies, and credit reports
  • Interviewed borrowers about their loan origination and loan servicing experience
  • Determined documentation required and recorded decisions.
  • Reviewed mortgage documentation on the UniFi Pro and Loan Origination Mortgage system and gave feedback to QA testers on any challenges of the system.
  • Performed quality control reviews ensuring regulatory compliance standards in relation to Dodd- Frank Act, fair lending and determined if the system in place was effective in capturing the information required for my reporting.
  • Worked closely with the team to ensure common goal and make collective decisions on critical issues.
  • Identified and evaluated the impact of system changes by conducting Impact Analysis.
  • Conducted user acceptance testing (UAT) as the final phase of applications development ensuring systems satisfied the business needs of the internal reserves escrow team.

Confidential, Coral Gables, FL

Business Analyst

Responsibilities:

  • Analyzed and interpreted financial data and recommends changes to improve systems and financial performance.
  • Provided financial transparency and analysis internally to the ITSC domains and functions assigned, enabling superior cost and management control effectiveness and promoting high-quality decision-making processes.
  • Created Access Database to manipulated large volume of data that allowed CFO and CIO quick view of Revenue and Cost by project.
  • Created functional documentation, reports training material and provide training to staff within their area of expertise.
  • Implemented various applications in Client/Server environments using Hyperion Essbase, Hyperion Planning, Essbase Integration Server (EIS), Hyperion Financial Reports, Hyperion Analyzer, DRM, Essbase Spreadsheet Add-in, Essbase Query Designer. Hyperion Data Integration management (DIM)
  • Prepared SQL loader control files based on informatica work flows.
  • Interacted with stakeholders to get a better understanding of client's business processes and gathered business requirements.
  • Written Control files to load the data from flat files to oracle as part of data loading by using SQL loader.
  • Performed GAP analysis of "as is" system and assessed benefits of the proposed functionalities of CWB and COA.
  • Worked on various Dashboards enabling a high-level view of performance success for the business units using Hyperion Web Analysis.
  • Prepared AS-IS and TO-BE write up for auditing system.
  • Produced financial analysis, recommendations on accounting practices and treatments, produce and review standard ad-hoc reports.
  • Supported the Project Manager in the development of Business Case Applications. Performs BCA project controlling, monitoring actual vs. planned expenses.
  • Reviewed monthly ITS charging documents together with Account Management. Reviews and approves debit/credit notes and chargebacks.
  • Prepared internal & external financial statements and automated the monthly Board Package Reports (BOD).
  • Power user in data manipulation using Excel pivot tables, V-lookups, formulas and macros.
  • Transferred the entire financial statement portfolio from the old company to the new company, and again due to a system conversion.
  • Created, coordinated, documented and trained 20 employees to the new budget and forecast process for 2012.
  • Created payback analysis reports and project tracking for new R&D projects.
  • Prepared monthly Sales Mix variance analysis report to identify shortfalls in Industrial Margin.
  • Prepared and review monthly variance analysis report with Domain Leaders.
  • Prepared capital tracking report for actual, budget and forecasting.
  • Prepared Cash flow analysis report weekly to CFO.
  • Trained 5 employees on new financial reporting tool GL Wand
  • Created HR salary compensation plan used for budget and forecast projections by month.

Confidential, Minneapolis, MN

Business Systems Analyst

Responsibilities:

  • Responsible for planning and managing the operational activities of helpdesk team to ensure that the customer service is in line with the customer requirements.
  • Developed the Business Requirement Document (BRD) and translated requirements into Software Requirement Specifications (SRS).
  • I was responsible for reviews requests for new and replacement personnel to ensure compliance to Budget and governance policies. Utilized technology and analytical tools to analyze and report on key metrics and trends in all areas of human resources.
  • Responsible for supervising personnel in accounts payable.
  • Utilized Agile Methodology to configure and develop process, standards and procedures.
  • Treasury management including maintaining the company expense reporting system, 580 credit cards and travel accounts.
  • Created technical Specifications for change management, continuous process improvement, business transformation modeling, and vendor, trading and customer relationship management.
  • Investment accounting activities with LIBOR accounts
  • Preparing financial reports and disclosures
  • Assisting with management reporting and budget processes
  • Assisting with the coordination of external audits as well as maintaining internal audit compliance.
  • Served as an internal resource to train company's leaders regarding the use of workforce data and analytics via existing technology and self-service tools. Recommended, develop and implements metrics and reporting to measure HR program effectiveness etc.,
  • Architectures, Change Control Management, Budgeting & Planning, Cost & Resource Estimates, Project Risk & Scope.
  • I balanced the company's accounts and budget, Financial reports and disclosure.
  • Managed all the requirements in MS Word templates, making requirements available to all team members.
  • Participated in testing and implementation activities to ensure attainment of desired Business-Systems outcomes (in accordance with established requirements).
  • Assisted team members in preparing Test Data for UAT Testing when requested.
  • Conducted meetings with UAT team for the discussion of issues encountered by them during their testing.
  • Management reporting and analysis, sector analysis, stress test and forecasting. Analyze, reconcile, and interpret large amount of data.
  • Managed multiples priorities and multitask, and took care of business payroll accounts, as well as IT computers, SAP
  • SQL Knowledge, Data Analyst and Modeling, Communication, CFA, Time Management, SAP Accounting, Finance, Expert in MS Office, MS Word, Outlook, Power Point, Risk Management, Operational Management, also take care the payroll as well as IT computers.
  • Identified refinancing options and foreclosures or credit reports and FICO scores.

Confidential, Wayzata, MN

Business Systems Analyst

Responsibilities:

  • Implemented a new streamlined Project Management process based on best practice governance standards and the Unified Process methodology
  • Interviewed business area experts, asked detailed questions and carefully recorded the requirements in a format that can be reviewed and understood by both business people and technical people.
  • Utilized Agile Methodology to configure and develop process, standards and procedures.
  • Actively involved in conducting reviews, walkthroughs and facilitating in requirement definition workshops (JAD) to get consensus on business requirements for the project.
  • Analyzed and assessed client requests to create professional, presentation quality deliverables in the form of dashboards and reports to provide additional insight to any critical indicators.
  • Developed UML models using MS Visio.
  • Presented the business process workflows to business stakeholders.
  • Tasked with coordinating, tracking and updating project issues, risks and change controls that impacted the business unit.
  • Run Ad-hoc reports for management, as well as writing SQL queries on MS SQL server and upload reports on SharePoint site.
  • Worked with Management to create and communicate mission-critical information to user community through emails and Web Portal postings.
  • Conducted JADs with the development team, testing team and business team to fasten the project definition process.
  • Documented API, XML file transfer process requirements to maintain information.
  • Assisted QC team to ensure requirements are translated into executable Test plans and strategies.
  • Alignment of scope, processes, skills set and KPI with market expectations.
  • Development of account data (Financial/metrics) benchmark tools.

Confidential - Newark, DE

Junior Business Analyst

Responsibilities:

  • Identified, assessed, and documented business requirements, recommending business priorities, and advising business on options, risks, and costs.
  • Conducted research to determine if solutions to business requirements currently exist within or outside the business unit, and if not, whether new solutions are feasible.
  • Created BRDs and FRDs with elaborate Use Cases and process flows
  • Reviewed TRDs with the help of developers and compared it against the BRD.
  • Created data mapping sheets and worked on understanding the XML responses to map data and populate fields in CLM LOS and POS systems.
  • Analyzed impact of proposed solution across the business, developed use cases to demonstrate business requirements/specifications to IT team, and contributed the business perspective during design reviews.
  • Used Rational Rose to create Use Case diagrams
  • Assisted Quality Management team to ensure that requirements documentation can be easily translated into test plans and ensure that the proper testing plans have been completed. Provided relevant test scenarios for the testing team.
  • Worked with the test team to develop system integration test scripts and ensure the testing results correspond to the business expectations.
  • Used Quality Center for test cases, test execution and defect tracking.
  • Used SQL for firing SQL queries to perform data analysis and comparisons
  • Involved in relationship building with business clients, team members, colleagues, and peers across multiple sites.
  • Understood the company's business practices and familiarized myself with the company's products and services especially in the Mortgage Banking industry pertaining to loan origination

Hire Now