SUMMARY

• Managed corporate financial statements, Tax returns, operating statements, loan underwriting; complying with credit policy standards
• Experienced in Banking, Government, Healthcare, and Financial industries
• Experienced in preparation of abi - annual financial budget, month end closing process
• Knowledge of US GAAP (Generally Accepted Accounting Principles) and general accounting
• Actively managed the investment portfolio of stocks, bonds, and options through value analysis and technical analysis
• Extensive experience in documenting Business Requirements Documents (BRD) and Functional Requirements Documents (FRD)
• Strong Knowledge of PeopleSoft GL, EPIC (patient billing system) in the health care industry
• Performeddata validationtests, identify potentialdataissues, recommend and implement issue resolution measures.
• Strong Knowledge on Capital Markets, Regulatory Reporting, AML, Liquidity Reporting, Trading Order Management Systems
• Strong background in business analysis, quality assurance, testing, documentation, accounting, A/R, A/P, and auditing
• Experienced in conducting Joint Application Development(JAD) sessions to develop and agree upon a system that focuses on thebusinessrequirements
• Strong working knowledge Waterfall and Agile Methodology with financial and healthcare domains
• Strong knowledge ofPeopleSoftdata management and transactional processing, data audit and analysis, interpret policy, employee relations, programs and procedures and monitor compliance
• Worked withFixed Income, Bonds and BondTradingCycle, Equities and Equity Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Wealth Management, and Sales and Marketing
• Experienced with Extraction, Transforming and Loading (ETL) data flows using SSIS, creating Mapping/workflows to extract data from SQL
• Providetradingadvices on options, individual stocks, alternative investments andbonds
• CreatedSQL queries and stored procedures for ad hoc extractions and data management
• Experienced with variousdatabaseobjects to write SQL queries on multiple databases like MS SQL Server, MS Access andOracledatabases.
• Strong working knowledge of payments domain related to financial services
• Highly proficient in working with users to gather requirements, analyze them and subsequently use the Rational project and design tools to model the requirements
• Background expertise includes projects involving variousMicrosoft Dynamics AX modules including Financials (GL/AP/AR), Trade and Logistics (Purchasing, Sales, and Inventory & Warehouse Management), Procurement, Project, and support of related modules
• Strong Knowledge on risk management and SOX audit risks with banking
• Conducted JAD sessions, created Use Cases, workflows, screenshots and PowerPoint presentations for the Web Applications
• Strong Knowledge in Cost Accounting and Oracle based databases
• Extensive experience in creating use cases, functional design specifications, activity diagrams, logical, component and deployment views to extractbusinessprocess flow
• Responsible for the evaluation of financial data to determine the level of default risk, and preparation of reports for both the client and the lender
• Extensivefinancialmodeling and report building in Excel and Hyperion Essbase to support the Brokerage and Manage Accounts lines of business, to include Actual Reporting, Forecast Reporting, and other reporting as needed
• Strong Knowledge in preparing cash flow analysis and calculations of debt service
• Gained experience in analyzing financial statements and assessment of credit requests
• Experience in establishing new internal control rules in compliance with the Sarbanes-Oxley Act
• Well versed in the usage of Microsoft Word, Excel, PowerPoint, Visio, Project Plan,SharePointand other Project Management and Business Analysis tools.

TECHNICAL SKILLS:

• Microsoft Office
• Microsoft Visio
• JIRA
• Outlook
• Excel
• Tally.ERP9
• SQL
• VLOOKUP
• QuickBooks

PROFESSIONAL EXPERIENCE

Confidential, OH

Business Analyst

Responsibilities:

• Served as a liaison between specialists and the project team
• Responsible for gathering user requirements and specifications for designing a new system and documenting the same
• Extensively involved in maintaining requirements traceability and communicating any changes to these requirements to different businessgroups and programmers
• Strong experience in documenting Business Requirements Documents (BRD), Functional Requirements Documents (FRD) and Non Functional requirements
• Worked in conjunction with development team and senior management in development ofdatamapping andvalidationreport
• Strong knowledge of executing QA plans and scripts while applying business and technical knowledge to resolve issues
• Conduct JAD sessions to analyze RESTful web service interfaces and create requirement with the help of tools like SOAPUI (XML& JSON)
• Led and conducted JAD sessions for requirements gathering, analysis, and design of the system.
• Knowledge onIntegration, Regression, Functional,System Performance and User Acceptance Testing (UAT)
• Created context and workflow models, information andbusinessrule models, Use Case and Object Models during the analysis using Rational tools
• Knowledge of projects dealing with systems integration, web services, API, andXMLdata transfer
• Strong knowledge in participating dailyscrummeetings, sprint planning, sprint review and sprint retrospective
• Strong working knowledge with all phases of the Software Development Lifecycle (SDLC), including system analysis, and documentation
• Knowledge on Agile project planning, daily stand-up meetings (scrums), reviews, sprint, release planning and other Scrum-related meetings
• Actively interacted with differentbusiness groups to perform a Gap analysis to identify the deficiencies in the system by comparing the actual objectives with the system objectives desired
• Strong Knowledge on approval and submission system on COTS application forpharmaceutical regulatory submission system
• Worked with the SME's from various business units to document thedata mappingvalues and descriptions for all current state and future state fields
• Strong Knowledge of Agile software development with Scrum
• Performed UAT, end-user and maintainedSharePointsite
• Used MS Visio for Process modeling andBusinessProcess flow diagrams
• Extensively involved in regression testing during various phases of the application
• Managed workload, schedules and coordinated status review meetings with project managers,businessmanagers, and team members
• Experienced in creation and maintenance of SharePoint-based applications for data collection, reporting and analysis
• Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project

Confidential

Finance Specialist

Responsibilities:

• Proficient in the filing of the UCC Liens and managing the local, federal and state tax payments.
• Assisted in the preparation of financial reporting, monthly budgeting, and variance analysis
• Completed daily, weekly and month end accrual journal entries inPeopleSoftand month end activities.
• Worked with Tax Collector to generate tax billing, filing tax liens and foreclosure accounts
• Attained knowledge of procedures in a County Tax Office, such as local tax, laws & procedures
• Experienced inPeopleSoftCRM (Service Management, Customer Accounts, CRM helpdesk andPeopleSoft Security)
• Knowledge in Configuring GL/AP Business Unit and setup security for implementation of new business integration
• Performed variance analysis when preparing financial statements usingPeopleSoftqueries
• Experienced with Oracle Hyperion Financial Management for financial reporting and analysis
• Strong working knowledge on Security data such as Counterparty Reporting, GDPR Compliance, Trading Order Management System
• Strong experience working with creation of relational database management system
• Worked with the local tax laws and procedures in a County Tax Office meeting government requirements
• Managed cash and treasurysettlements (Investments and Redemptions) totalling $10 billion in aggregate on a regular basis
• Experienced in working with Financial statement reviews,GLposting, fixed assets, prepaid entries
• Experience working in PTP areas such as Accounts Payable, Procurement Operations, Internal Control, and Accounting
• Created interactive visuals usingPower BIdisplaying current financial data and progress of internal projects
• Prepared individual, corporate, partnership and not-for-profit tax returns to meet government requirements and deadlines and client expectations
• Strong Knowledge on Back office functions such as settlements, regulatory compliance
• Experienced withdata mappingin Excel workbooks using advanced formulas, VLOOKUPs, and pivot tables
• Assisted firm market makers & firm institutional desk in handling,tradingand executing orders
• Managed clerical work associated with the maintenance of confidential tax collection records
• Assisted financial controller in preparing a bi-annual financial budget, month end closing process and trend analysis
• Experienced with pricing of bonds, mutual funds and liquidity based investments
• Participated in monthly accounting processes to ensure accuracy and completeness of financial records
• Advanced level skill in using Microsoft Excel such as V-Lookup, Pivot table, Money.net

Confidential

Financial Analyst/Business Analyst

Responsibilities:

• Analyzed P&L, Balance Sheet, and Cash Flow statements for Business Units to forecast expenses & income
• Performed analysis on profitability of channel mixes as well as produce financial P&L statements for the channels
• Created and managed budgets, prepared and reviewed business plans and regularly monitorfinanceand performance and allocate resources where they are needed
• Extensive knowledge ofMicrosoft Dynamics AX 2012 core financial modules Performs position requirements using AP, AR, GL, FA, ST accounting functions
• Assisted with customer setup inMicrosoft Dynamics CRM/SharePoint
• Prepared monthly account reconciliations for balance sheet support, as well as internal and external auditors
• Hands on experience withMicrosoft Dynamics AX 2012 R3 Enterprise Resource Planning system
• Implemented software and hardware components forMicrosoft Dynamics CRM and XRM applications
• Analyzed the banking principles, services and assisted reconciliation of bank statements
• Developed knowledge of financial statements and the created reports providing various business operations
• Handled billing transactions and process daily banking transactions
• Prepared & analyzed monthly operating expenses, comparing budget and forecast information utilizing data systems and analysis tools such as Excel, SQL, and QuickBooks.
• Assist with month end closing financial close responsibilities with required GAAP adjustments
• Developed comprehensive reports and spreadsheets to present data to senior management using analysis and data management tools (excel, power point, and ERP system)
• Reconciled monthly expenses to general ledger entries and
• Assisted in payroll preparation by providing relevant data (absences, bonus, leaves, etc)
• Responsible for monitoring and managing thecreditquality and data integrity of assignedcreditrelationships
• Communicated withcreditcard customer base, which improved customer satisfaction.
• Resolvedcreditcard disputes and over-authorizations errors with our merchants and customers.
• Requested and reviewed personal financial documentation forcreditlending inquiries

Confidential

Financial Analyst/Business Analyst

Responsibilities:

• Created and maintained various applications to facilitate commercial credit analysis, underwriting, and loan closing processes
• Executed Business-to-Business collections of assigned accounts and performed regular maintenance with assisting company’s client audits
• Assists theRetail BankingOfficer andRetailOperations Manager by compiling and monitoring information relating to the operation of each location
• Provides administrative support to theRetail BankingOfficer of theRetail BankingUnit
• Assessed the creditworthiness of applicants based on investigative findings
• Prepared cash flow analysis and calculations of debt service and debt coverage ratios
• Reviews and analysesSAP transactions (AR, AP, GL, Reconciliations) using advanced excel and business analytic tools.
• LeadRetail Bankingstrategic directions by bringing Member experience to best
• Ensure commercialbankingrelationships are fully developed, including specific efforts to serve theretail bankingneeds of the management by partnering with Private Bankers, Branch Personnel and Commercial Relationship Managers
• Improved financialstatus by analyzing results; monitoring variances; identifying trends; recommending actions to management.
• Strong experience working with credit risk management process with banking and financial institutions
• Monitored quarterly audit testing for SOX compliance, addressed and enforced deficiencies found after audits were performed
• Assembled the reports to summarize the financial performance, banking relationship and its principles
• Established and monitored the credit lines for customers by performing financial statement analysis and by analyzing reports
• Experienced in working with Credit management to maintain efficient cash flow with financial institutions
• Assisted in the collection, analyzing and organization of data for internal SOX billing audit
• Proficient in using QuickBooks, SAP
• Analyzed financial statements to assess companies credit risks to the Bank
• Researched and prepared evaluations on a variety of projects/problems (financial, statistical, operational, and cost/benefit analyses)
• Strong Knowledge on Vision Plus relating to credit card payments with banking
• Experienced in working with loan originating system, mortgage loans and credit risk management
• Investigated current and hypothetical scenarios to control, review, or predict the profitability of loans
• Provided customer service to field personnel relating to loan pricing
• Presented results of ad hoc analyses requested by senior management and prepared monthly, quarterly, and yearly close reporting
• Collaborated with team members to recommend financial solutions for clients