We provide IT Staff Augmentation Services!

Business System Analyst Resume

Tarrytown, NY

SUMMARY

  • 8+ years of technical expertise in complete software development life cycle (SDLC) process which includes Requirements gathering, Analysis, Design, Development, Testing and Implementation.
  • Experience with Commercial Lending, Personal Lending, Equipment Finance, Lending Tools, Syndicate Loans, Retirement Loans, Law Suit Funding
  • Good experience in Loan Origination Systems like Confidential, PRISM, Encompass, EncompassCRM, Loan Tools, Misys Loan IQ, nCino, CRM.
  • Extensively worked on Analyzing data, Analyze Reference Data, Data Mapping, Applying business rules, designing the data warehouse, creating data mart/ schemas, partitioning the data, creating easy/quickest ETL process to load the data and automating the ETL process.
  • Complete formal Design process from initial specifications and requirement, technical design documentation, user acceptance test case documentation.
  • Extensive working experience in the areas of analysis, design and development of BI - Business Intelligence solution using Tableau Desktop, Tableau Server, Admin and Business Objects reporting tools. Capable of multi-tasking and willingness and ability to quickly adapt and learn.
  • Experience in creating workbooks and dashboards using Data Visualization tool Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 8 and Tableau 8.1, Data Mapping, Data Cleansing, Data Analysis, Data Translation and Governance.
  • Developed dash boards with rich Graphic visualizations/ virtualization, Drill Down and Drop down menu options, Parameterized using Tableau.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, Groups, hierarchies, Sets to create detail level summary reports and dashboards using KPI
  • Experience in Business rules for AML, Commercial Lending, Compliance Docs, Regulatory Docs, Consumer Protection (CFPB), and FRB Regulations.
  • Excellent analytical skills to understand the business process, functionality and requirements; and translate them to system requirement specifications.
  • Experience in deriving business requirements that are representative of standards, both technical and theoretical as set by multi-disciplinary teams.
  • Interacted regularly with development team, database designer, system administrator and the senior management to meet the deadlines of project.
  • High level of technical proficiency in writing business documentation, ERD Documents.
  • Proficient in writing use cases, developing test cases, test case writing, coordinating with service team, and working with QA teams during testing.
  • Experience in Financial Systems Analysis within a fast moving global project environment.
  • Good experience in XML, XSLT, Xpath XHTML, Schema, DOM, JAXB, SQL, PL/SQL.
  • Experience in installation and config of WebLogic, WebSphere, Tomcat, Adobe Dreamweaver and Cpanel tools like Softaculous, RVSitebuilder etc.
  • Expertise with using the JUnit, HTTP Unit for testing the applications, JQuery validations and using other JQuery validation plugins.
  • Extensively worked on n-tier architecture systems with application system development using Java, JDBC, Servlets, JSP, Web services, WSDL, SOAP, XML, SAX, DOM; Implemented Rich User Interfaces using JSF, JSP, JSTL, HTML, CSS, and JavaScript.
  • Possess good communication, interpersonal, leadership, team building skills and the ability to work both as a team player and an individual.

TECHNICAL SKILLS

Operating Systems: Windows NT/98, XP, 2000,7, UNIX, LINUX,SOLARIS

Application Software: MS Office - MS Word, MS Excel, MS PowerPoint, MS Access OPEN OFFICE

Databases: SQL Server, Oracle, DB2

Web Technologies: HTML, XML, JSP, Ruby Weblogic, Apache Tomcat, Apache Camel, Apache CXF, WebSphere, GIT ECLIPSE, NetBeans, NodeJS, SOA

Methodologies: RUP, Waterfall, SCRUM, AGILE, Liquidity, Risk management, KYC

Requirements Management Tools: Rational Requisite Pro, MS Visio and MS Office, JIRA, Confluence

Testing Tools: Quality Center, Test Director, Win Runner, Load Runner, Mercury Quality Center

Process Modeling: MS Visio, Balsamiq Mockup and Rational Rose

Documents & Processes: SRS, BRD, Use Cases, UML diagrams, FRS, UAT, Test plans & cases, Business Process Modeling, Project Planning & tracking, Version One

Reporting Tools: MS SQL Server Mgmt Studio, ETL. Tableau, Informatica, Springbok, Alteryx

Languages: C/C++/C#, Java, Sql Server 2008, Oracle, RDBMS, UNIX, Web (PHP, Laravel, Html, MySQL, Java Script, AngularJS, emberJS), ASP.NET, Python, XML, XPATH, JQuery, BackboneJS, MarionetteJS, HandlebarsJS, Mocha, Karma

Multimedia Software: Photoshop, Flash, PageMaker, Corel Draw, Maya, 3dsMax, Fusion, After Effects, Shake, Nuke, Combustion, Adobe Dreamweaver

Certifications: Sun Certified Java Programmer 5.0 (SCJP 5.0), Microsoft Certified Technology Specialist (MCTS), Appin Certified Ethical Hacker, Diploma Animation & VFX.

Tools: Eclipse, SharePoint, MS Project, Adobe Dreamweaver, Fantaculous, RVSiteBuilder, Cpanel, WHM panel, GIT Hub for eclipse, Drupal, Loan IQ, Encompass360, MortgageReturns CRM, TD Ameritrade, Capital IQ, AutoSys, InforEAM, Asset, Tableau, Tableau Server, TOAD, nCino. Confluence, ETL, Tableau, XML Spy

PROFESSIONAL EXPERIENCE

Confidential, Tarrytown, NY

Business System Analyst

Responsibilities:

  • Assist with Data Migration CRM, Conversion, Cleansing, Test; Perform Refresh Data, Extract, Extra Database, Initial Load onto Ellie Mae CRM.
  • Documented EPICS, Designed User Cases, User Stories for Encompass Next Gen; Encompass Settings, Alerts and Messaging etc. on JIRA.
  • Utilized existing data scripts to capture deltas for Data Migration, Data cleansing, Data Virtualization for dashboards on CRM
  • Configured Encompass/Encompass Server on Client Servers, Tested Customer information with in encompass in terms of users, access etc.
  • Managed SOP’s for each client, Client’s Project Plan. Trained Clients on using Encompass and Mortgage Returns by EllieMae.
  • Analyzed CFPB laws, Regulation documents as well, some being Consumer Leasing, FACTA, FCRA, Fair credit reporting, HMDA, HELOC etc.
  • Provided TRID Document a new proposed rule which combines the TILA and RESPA called as TRID TILA-RESPA Integrated Disclosure
  • Adding Disclosure Docs, Loan Setup, Closing Docs, Consumer Leasing, Forms, Loan Program docs to Encompass Administration/ Confluence.
  • Adding and checking AML (Anti Money Laundering) Documents like Gift letters, Sources of Income Docs, OFAC Checks, and Identity Docs.
  • Executed data migration in coordination with management and technical services personnel, Liaison between the Client and backend Team.
  • Performed 3rd party integrations like mortgage bot, Confidential, Freddie Mac etc. to communicate with the encompass SDK
  • Gathered/Translated Requirements for DM, Analyze their system configuration. Oversaw data migration process and notified client on its status.
  • Manage Client calls, GoToMeetings, Offshore Team, WebEx sessions, Stakeholders, JAD Sessions, Record Sessions, Team Decision, Test, SME
  • Perform and plan data migration (Salesforce Portal) based on client needs if they need full migration, then a database backup would be done.
  • Manage projects on salesforce automation services. Checked SOP Requirements, Tracking requirements changes, delivering the Product.
  • Train clients on how to use their new hosted system. Tested and Provide documentation, user guide and manual to clients. Train internally as well.
  • Supported/Tested for issues during post migration. Provided Status updates. Updated SharePoint Sites/Confluence. Managed QA and Test Team

Confidential, Parsippany, NJ

Technical Analyst/Business System Analyst

Responsibilities:

  • Designed High Level User guide, Req Docs, SOP’s. Used Confidential to map data from XML to Schema into Loan IQ business rule via Xpath.
  • Involved in business meetings with PM for understanding Loan origination, JAD sessions, Stakeholders, Business Users, System Users, SME.
  • Prepared exercises for all the levels of analysts to configure the Confidential Platform to Integrate with API’s provided by Loan IQ and nCino.
  • Trained new employees on Confidential Platform, Admin Server and Repository Console.
  • Used MS Project to gather the requirements and update them over each Scrum Meeting. Analysed Requirements for various vendors.
  • Handling all the service requests that include bug fixes, investigation, and enhancement.
  • Created OFAC/KYC, Check business rule to be accommodated in the web service call via Confidential Platform and Integrated to Prism.
  • Prepared requirements document based on Section 508 and WCAG 2.0 for the new web pages that were yet to be built.
  • Created dashboards according to user specifications and prepared stories to provide an understandable visions by performing data visualization
  • Created views in Tableau Desktop that were published to internal team, further data analysis, customization using filters and actions.

Confidential

Technical Analyst/Business System Analyst

Responsibilities:

  • Assisted During Development via Providing Validations, Credit Bureau Mappings, DU Workflows, JAD Sessions, Resolving Issues etc.
  • Reviewed new screens developed by UI Team, Validated, and Written User Stories to develop the new screens for LO Connect.
  • Designed front end screens using Balsamiq based on which the front end was built.
  • Mapped User Roles to their respective roles, security roles. Mapped via WebLogic. Analyzed KYC guidelines before mapping User roles.
  • Used Infor EAM to track the assets and collaterals, Create Dashboard of open items, Auto parts, Engine swap etc. (Equipment Finance).
  • Followed ITIL Processes for commercial auto lending workflow design, cal. Calculated Loan Term based on expected life of equipment.
  • Used AssetWise to get Asset information, Equipment collateral information and manage the change over the process workflow.
  • Performed Field level, required field validation using JQuery and JavaScript to validate Ratio Cals, DTI, LTV and other Loan formulas.
  • Used JavaScript, jQuery, HTML, JSF and CSS to enhance website functionality, JavaScript and jQuery for form and data validation.
  • Gathered Requirements for various Business Rules in their Loan Origination workflow, Calculated the formulas for Business Rules as well.
  • Defined Business rules using LoanIQ for Loan origination based on rules provided by Confidential . Rules were implemented on the Xpath values
  • Used Oracle Weblogic (Oracle Weblogic Portal), and Apache Webserver as static container.
  • Created Requirements document. User Guides and Manuals for internal use, Created user experience work flows, process flows.
  • Used to GIT to fetch and Merge code using GIT for eclipse plugin, extensively used Git and GitHub for content management.
  • Tested all application controllers extensively with angular.js built-in testing facilities. Assisted During UAT
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately by performing data virtualization.

Confidential, Irvine, CA

Technical Analyst/Business System Analyst

Responsibilities:

  • Scoring, Bureau Pull Workflow (Business Process Modeling Notation ) using JavaScript, XML Mapping, DB Mappers in Confidential Platform
  • Designed an Interaction manager page using JSP builds, Performed Ratio Cals using Confidential Dimensional Analysis.
  • Included JavaScript Ratio Cals for interaction manager web page using ruby on rails to include all the calculations.
  • Documented User Guide, ERD, Data definition doc, Requirements doc and various documents using Visio. Updated Documents on SharePoint
  • Tested Scoring decision engine based on KYC clearance, Tested STP Web service. Tested with Loan Runner and Mercury Quality center
  • Pulled Credit reports from those Bureaus based on Fair Credit Reporting Regulation.
  • Involved in creation of Reports, Formatting reports, generation of charts; also involved in approving and troubleshooting Change Orders.
  • Interfaced their Front end created by Misys Loan IQ with the STP Service created on Confidential Platform.
  • Made changes to Confidential TRN file the backend code to accommodate this frame work to read the data from any source like text format, XLS format, XML file, Web services etc. XSLT to transform Reference data from XML and other sources and using Xpath to retrieve the values.
  • Used Misys Loan IQ to create business rules on the client end and then translated it via Confidential Studio
  • Added Angular custom elements using the add-on library from GITHUB Angular custom element.
  • Developed workbooks and dashboards using Tableau Visualizations like Heat maps, Pie Charts, Dual Axis workbooks and Charts, Bar Graphs, Scatter Plots, Trending and Forecast dashboards, Waterfall Charts, Geographic maps using local and global filters.
  • Imported Data to Tableau from Informatica’s tool called Springbok to join data from its Data warehouse and Process Mapping.

Confidential, Parsippany, NJ

Technical Analyst/Business System Analyst

Responsibilities:

  • PRISM documented all the static pages and static fields. Fetched Data using Oracle DB to fetch and store each field level data and then mapped on each designated Schema via Xpath as the data was provided in the form of XML. Mapped on Misys Loan IQ as well.
  • Used Visio to create workflows (BPMN), Decision, Data flow, Tree, Logic diagrams, process flows. Updated ProvenirWiki docs to Studio.
  • Creation of Reports, Change Orders, Formatting reports, generation of charts, Loan Approvals, Post Loan Approval process, Process flows.
  • Creation of other documents related to AML, Identity and ownership of properties, Trust Documents.
  • Analyzed approving, troubleshooting Lending workflow, Mortgage Backed Securities ( Confidential, Freddie Mac), Gift Letters.
  • Getting field ids for all the static fields so that they can be validated using JavaScript and JQuery
  • Tested Scoring decision engine, Tested STP Web service.

Confidential

Business Objects/BSA

Responsibilities:

  • Conducted analysis of business processes and requirements and identified technology enabled improvements.
  • Worked closely with project managers, business users and developers to formalize a business idea, define requirements using rational requisite pro.
  • Analyzed Software Development Life Cycle (SDLC) from Requirement, Functional, Built, Testing to Implementation phase using AGILE.
  • Gathered Functional Requirements for different back-end application in coordination with Business Users and created Functional Requirement doc.
  • Used JIRA to track each phase of SE Cycle, Used SCRUM to analyze each phase of the development. Understand the working of Business Objects
  • Used Rational Rose to design class diagrams, Use Case diagrams, sequence diagrams.
  • Designed Confidential ’s client web page/ wireframes using Balsamiq Mockups to create the mockup designs for each page and how it looks so that client can decide on how to proceed with this design so that can implement as per these designs..
  • Designed Database design using Oracle, Performed SQL Queries to fetch data based on various requirements. Learned about data analysis as well.
  • Handling all the service requests that include bug fixes, investigation, and enhancement. Used ETL tools like Alteryx to perform data extraction to an MS Access file to import it into Tableau. Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

Confidential

Tech Analyst/BA

Responsibilities:

  • Designed a User Guide for ILE for internal use which also contains the Walkthrough of the ILE Project with help of Visio
  • This was designed using VISUAL STUDIO 2010, and .NET4.0
  • Developed a Reconciliation application to reconcile old GCIS2 with ILE-IntraGroupLimit Application using C#, ASP.NET, SQLServer 2008.
  • Reconciliation was done with help of C# Code to compare the data in form of excel and then a cell to cell comparison was done to find what were the new changes that are yet to be found.
  • Developed a Management Information App to Generate Reports for ILE application for Limit Approval, Status using ASP.NET.
  • This is a web page that has the frames of the data that either pulls data from excel or from database directly. Often data is being cached as well.
  • Developed an app to Perform FX Rates on the limits that were entered into ILE using C#, Confidential MX API on Visual Studio 2010
  • Wrote use cases and used UML to visually model the system using Sequence diagrams, State diagrams and Activity diagrams.
  • Wrote SQL statements to retrieve and persist data. Implemented the project using Agile development methodologies.
  • Created data flow and sequence diagrams to describe how ILE fetches data and what type of data is required to be displayed
  • Used JavaScript, jQuery, HTML, JSF and CSS to enhance website functionality. Used JavaScript and jQuery for form and data validation.

Confidential

Intern/Web Developer

Responsibilities:

  • Involved in understanding specifications and requirements of the system. Performed the development/construction (front end, backend)
  • Developed website for Confidential using Adobe Dreamweaver, Drupal and Flash, Performed Testing, Used MS Access for data retrieval
  • For UI, Developed UI using JSP, HTML 5, CSS 3.0, JavaScript, Ruby on rails, Used html, JavaScript, MySQL, Oracle
  • Managed object persistence, data retrieval using Hibernate with MySQL as a database, bug fixes, investigation, and enhancement.
  • Interacted regularly with development team, database designer, system administrator and the senior management to meet the deadlines of project.
  • High level of technical proficiency in writing business documentation, ERD Documents.
  • Proficient in writing detailed use cases, developing test cases and working with employees during testing to get their feedback and what features need to be improved and how a new changes are to be made

Hire Now