Sr. It Consultant Resume
SUMMARY:
- Over 8+ years of progressive experience as a Business Analyst & Assistant QA Developer in Banking, Healthcare, Financial services, Loan origination and E commerce domains with solid understanding of requirement gathering, evaluating data sources, translating requirements into specifications and application design.
- Experience with COTS (Commercial off - the-shelf) and ERP (Enterprise Resource Planning) such as PeopleSoft.
- Worked with SMEs to collect Business process requirements, documented them in Business Requirement Document (BRD) and performed Business Process Re-engineering, product support.
- Facilitated Change Management across the project from Project conceptualization to Testing through project delivery, software development and implementation management in diverse business and technical environments.
- Built resource planning and managed relationship with internal teams, cross-functionality teams, business partners, etc. Agile & related skill set-ability to write stories, support release/sprint planning.
- Assessed the flaws in the existing AS-IS system and made clear recommendations of business process improvements and BPR and incorporated them in the TO-BE system design.
- Gathered business requirements, creating Business Requirement Documents (BRD), Project Plans, Timelines, Workbooks, and other project design requirements.
- Used agile methodology for managing the SDLC for project.
- Skilled in interacting with the business users to identify business and information needs to initiate process changes and creating use case document including use case diagrams, use case scenarios, activity diagrams, sequence diagrams based on UML methodology using MS Visio.
- Comprehensive understanding and experience of SDLC and project life cycle methodologies such as Water fall, Agile, Rapid Application Development (RAD), and Rational Unified Process (RUP).
- Experience in Automation tools like Rational Requisite Pro and Quick Test Professional.
- Hands-on experience in conducting cost-benefit analysis, risk analysis, Return of Interest (ROI) analysis, Requirement Traceability Matrix (RTM), GAP analysis, SWOT analysis and user acceptance testing (UAT).
- Excellent understanding of Software Quality Assurance Techniques, CMM, Six Sigma and ISO standards
- Experienced as User Interface/Front End Developer in developing applications using HTML, HTML5, CSS, CSS3, JavaScript, DHTML, DOM, XHTML, jQuery, Ajax and JSON.
- Experience with Firebug for Mozilla, Developer Toolbar for Chrome, IE Developer Toolbar for Internet Explorer, and Safari Web Developer.
- Actively facilitated Joint Application Development (JAD) or Joint Requirement Planning (JRP) and Rapid Application Development (RAD) sessions for requirements gathering and brainstorming ideas.
- Expert noledge in with various capital market instruments and securities including Equities, Fixed Income Instruments, Risk Management (Credit and Market Risk).
- Certified SAP FICO & Oracle Fusion Consultant.
TECHNICAL SKILLS:
Methodologies: Agile Scrum, Rational Unified Process (RUP) and Waterfall
Business Analysis: Gap analysis, Risk analysis, ROI, SWOT analysis, Cost/benefit analysis
Software tools: MS Visio, MS Teams, Oracle Fusion, SAPFICO, SAP Simple Finance, MS Project, MS PowerPoint, MS Outlook, MS Access, MS Excel, MS Word, PowerPoint, SharePoint, Documentum, Atlassian Confluence and JIRA, Rationale Requisite Pro, Rational ClearQuest, Balsamiq, Tableau, Devops, PowerBI, SAP BOBJ, SAP Hana, SAP FICO, Oracle Fusion
Databases & Tools: SQL Server, DB2, Access, Microsoft Azure
Quality Assurance Tools: Quick Test Pro (QTP), Quality Center, Load Runner
Web Development: HTML 5, Cascading StyleSheets, JavaScript, XML, HTML, JSON, AJAX, jQuery
Operating Systems: Windows, MAC
PROFESSIONAL EXPERIENCE:
Confidential
Sr. IT Consultant
Responsibilities:
- Lead on High level Data Mapping Documents of entire integration between Legacy System, Data Lake and SAP systems.
- Detailed data analytics and definitions documentation by facilitating meetings amongst Business, FP&A, Accounting & IT Teams.
- Lead Designer of templates and documentation of BRDs for all companies Management & Transactional Reports and Dashboards.
- High level Finance and Revenue Data Analytics between different legacy system, Data Lake and SAP systems.
- Involved in Unit and Integration Testing.
- Lead Analyst on UAT Testing
- Checking for the core area of the Ticket logged in and assigning to the correct process.
- Reporting the deviations in resolving the Tickets. Taking the correct action to satisfy both user and onsite coordinator.
- Coordinate with onshore team in day-to-day trouble shooting tickets.
- Communicated status, issues, and pending status of the tickets with the offshore coordinator.
- Providing suggestions to the team in reducing backlogs.
- Responsible for solving tickets in GL, AP, AR, & AA.
- Solution provided for various change requests on the priority bases.
- Performed unit testing and integration testing for Asset Accounting, AP, AR and CCA. Batch jobs scheduling / monitoring.
- Resolving incidents within SLA’s.
- Providing support for Automatic Payment Program and dunning transaction.
- Analyzing and providing solutions on the issues raised by the client.
- Coordinating with the customers and Business Integrators in resolving the Trouble Tickets within SLA's.
- Involved in noledge transfer session from our senior consultants and lead.
- Worked as a Data Lake QA with Data Lake team in Microsoft Azure & SQL(SSMS) data base.
- QA of BOBJ new reports with SAP BOBJ developers
- Have been a key consultant analytics on data base construction for SAP Hana from Old to New entity and elements construction, to all logic creation and implementation, QA and UAT testing.
Confidential
Sr. Business Analyst
Responsibilities:
- Started with preparing Dashboard for all company's active project and status report.
- Have prepared a simulation report to identify GAPS in the process and address necessary solutions followed by mandatory meetings and discussion.
- Document and improved EH's annual project planning and funding process.
- Coordinated EH engagement and readiness in Oracle ERP project.
- Facilitated teams, lead process improvement sessions, create or oversee creation of process and project documentation, visualizations, and dashboards.
- Have worked and documented on several different project and still managed to deliver quality documentation.
- Worked on senior executive presentations to receive funding for projects.
- Worked with PMO team in defining project delivery methodology and templates.
- Enhanced business data visualization using Planview PPM Pro & MS PowerPoint for the weekly director's presentation.
- Served as lead and facilitated series of Functional Specification Document.
- Help organized all the documents related to One Fusion Projects using Naming Convention TEMPPrincipals.
- Analyzed unstructured data to build customers behavior model.
- Recognized by PPMO manager and EM Director as fast and exceptional contributor for organizing & presenting project-related documents.
- Have performed GAP analysis at several stages of the process cycle and offer reasonable and practical solutions.
- Have served lead in providing Job Aids and Used Cases throughout the Project period.
- Help improve MBR (Monthly Business Review) presentation and organize the finance and identifier of the active projects.
- Translated business user concepts and ideas into comprehensive business requirements and design documents.
- Served to provide better data analysis results by performing Cost/Benefit Analysis & coordinated engagement progress "actual to forecast" profits.
- Served to identify Value to Business on each active project by MS Excel data analysis formulas using project Budget spend values.
- Developed and implemented an interim solution dat increased both the functionality and usability of the existing financial model.
- Identified significant GAP of work communication between JIRA and PPM Pro and suggested a solution to have a Lean Kit attached with JIRA and PPM Pro to automate the project task, action, and epic assignments. Lean Kit halps link work assigned Jira to link it with PPM Pro users assigned directly.
Confidential
Business Analyst-(Contract)
Responsibilities:
- Gathered business requirements, creating Business Requirement Documents (BRD), Project Plans, Timelines, Workbooks, and other project design requirements.
- Documented as-is and to-be process flows.
- Competed mortgage loans by monitoring collection, verification, and preparation of mortgage loan documentation; scheduling and completing mortgage loan closing.
- Managed User Acceptance Testing (UAT) and defect remediation through Quality Center (HPQC), ensuring dat approved code is implemented and validated on schedule.
- Reviewed loans according to RESPA, GSE, FHA, and VA guidelines.
- Researched and summarized new rules and regulations and document applicable controls and potential gaps, specifically related to regulatory reform including liquidity and capital rules and various SOX, Dodd Frank Act, Basel III, RESPA and HMDA requirements, as well as new Finance business initiatives.
- Resource planning built and managed relationship with internal teams, cross-functionality teams, business partners, etc. Agile & related skill set-ability to write stories, support release/sprint planning.
- Handled and worked with mortgage Loan officer for increasing mortgage loan portfolio by developing business contacts, attracting mortgage customers, completing mortgage loan processing, and closing, supervising staff.
- Identified and documented trade process’ steps dat results an electronic record to support SOX compliance
- Meet mortgage loan financial standards by providing annual budget information; monitoring expenditures; identifying variances; implementing corrective actions.
- Scheduled SSIS packages to run at different intervals to load data into SQL Server. Designed screen mockups for changes in system functionality.
- Prepare/Review KYC profiles in accordance with sign off in accordance with Group Policy, KYC ID Matrix, local regulatory requirements and Sign Off Authority.
- Interacting with the business users to gather requirements based on the CCAR Regulation for Financial Statements, Interest Rate, Credit Ratings, FRY9C and Investment Securities.
- Attracted new mortgage loan applications by developing relationships within community, specifically with real estate community, making sales calls to prospective customers.
- Documented the elicited software requirements into enhanced Business Requirement Documents (BRDs) for BASEL III and its Addendum.
- Approved mortgage loans by examining application and supporting documentation; estimating creditworthiness; calculating repayment risk.
- Assisted with client on boarding and client roll out, including Trade Operations and Reconciliation, NAV calculations and Investor Services. Coordinator of team efforts in Agile environment and Production.
- Implementing FATCA methodology for Capital Markets business (Equities, Fixed Income, Derivatives) - Understand implications of FATCA and Conduct current state analysis.
- Dealt with Society for Worldwide Interbank Financial Telecommunication (SWIFT) in creating criteria for auditing of TQR and Q-Gate review processes.
Environment: SQL, Agile, MS office, Rational Rose, Rational Requisite Pro, ClearCase, UML, Rational Suite, MS Visio, MS Project
Confidential, New York, NY
Business Analyst-(Contract)
Responsibilities:
- Elicited and documented application specifications by reviewing existing artifacts and interacting with Stakeholders including Asset Managers, Portfolio Managers, Traders, Risk Managers and Compliance Team.
- Interviewed Traders and Analysts and created a list of Functional Specifications and Business Rules based on it.
- Coordinated with risk compliance team for multiple products in the analysis of alerts and investigation of transactional activities to detect any suspicions of fraudulent money laundering or terrorist financing activity.
- Reviewing AML Cases by doing extensive research on high-risk clients via KYC.
- Analyzed Credit Risk (CCR) exposure measures using Nice Actimization.
- Documented the detailed Business Requirement Documents (BRDs) and translated into Functional Requirement Documents (FRDs) and Use Case Documents (UCD's).
- Collaborated with data modeling team to build ER Diagrams by identifying data objects and constraints.
- Performed SQL Queries to retrieve and validate data, prepared data mapping document.
- Involved in defining the source to target data mappings, business rules and data definitions.
- Involved in Data Extraction, Transformation and Loading (ETL Process) from Source to Target Systems using Informatica Power Center.
- Worked closely with QA team to create Test Plans, Test Objectives, Test Cases and executed Smoke Testing, Performance Testing and UAT.
- Used JIRA to track defects, report defects and maintain log for the system.
Confidential
Business Analyst-(Contract)
Responsibilities:
- Supported the re-design of the loan origination system.
- Conducted interviews with key business users to collect requirement and business process information for the loan process including set-up account information, new loan set-up, escrow analysis, appraisal, credit, income and title functionalities
- Worked with mortgage originations, servicing, loss mitigations and loan modifications
- Worked closely with data administrators and project design team and acted as the liaison between the business (Fixed Income- General Ledger) and the technology area to implement software upgrades, create new reports, document business use cases, conduct user acceptance testing, and design future enhancements.
- Responsible for development of Budget upload and download interface between third party Budget System and United Financial Ban corp accounting system, as well as the General Ledger Budgets.
- Performed SWOT analysis and Cost benefit Analysis to halp the organization.
- Used agile methodology for managing the SDLC for project.
- Developed use cases to depict business module changes and created use case documentation.
- Maintained all system changes in the SharePoint document library.
- Organized and provide to loan officers on ‘how to use automated system’
- Helped to form a BA team offshore, prepared transition plan and trained new BAs.
- Coordinated and supported a group of BA team offshore.
Environment: Microsoft Visio, SharePoint, SQL, UML, LoadRunner, Rational Requisite Pro, MS Office Suite
Confidential
Jr. Business Admin Analyst-(Contract)
Responsibilities:
- Gathered business requirements, creating Business Requirement Documents (BRD), Project Plans, Timelines, Workbooks, and other project design requirements.
- Documented as-is and to-be process flows.
- Competed mortgage loans by monitoring collection, verification, and preparation of mortgage loan documentation; scheduling and completing mortgage loan closing.
- Managed User Acceptance Testing (UAT) and defect remediation through Quality Center (HPQC), ensuring dat approved code is implemented and validated on schedule.
- Reviewed loans according to RESPA, GSE, FHA, and VA guidelines.
- Researched and summarized new rules and regulations and document applicable controls and potential gaps, specifically related to regulatory reform including liquidity and capital rules and various SOX, Dodd Frank Act, Basel III, RESPA and HMDA requirements, as well as new Finance business initiatives.
- Resource planning built and managed relationship with internal teams, cross-functionality teams, business partners, etc. Agile & related skill set-ability to write stories, support release/sprint planning.
- Handled and worked with mortgage Loan officer for increasing mortgage loan portfolio by developing business contacts, attracting mortgage customers, completing mortgage loan processing, and closing, supervising staff.
- Identified and documented trade process’ steps dat results an electronic record to support SOX compliance
- Meet mortgage loan financial standards by providing annual budget information; monitoring expenditures; identifying variances; implementing corrective actions.
- Scheduled SSIS packages to run at different intervals to load data into SQL Server. Designed screen mockups for changes in system functionality.
- Prepare/Review KYC profiles in accordance with sign off in accordance with Group Policy, KYC ID Matrix, local regulatory requirements and Sign Off Authority.
- Interacting with the business users to gather requirements based on the CCAR Regulation for Financial Statements, Interest Rate, Credit Ratings, FRY9C and Investment Securities.
- Attracted new mortgage loan applications by developing relationships within community, specifically with real estate community, making sales calls to prospective customers.
- Documented the elicited software requirements into enhanced Business Requirement Documents (BRDs) for BASEL III and its Addendum.
- Approved mortgage loans by examining application and supporting documentation; estimating creditworthiness; calculating repayment risk.
- Assisted with client on boarding and client roll out, including Trade Operations and Reconciliation, NAV calculations and Investor Services. Coordinator of team efforts in Agile environment and Production.
- Implementing FATCA methodology for Capital Markets business (Equities, Fixed Income, Derivatives) - Understand implications of FATCA and Conduct current state analysis.
- Dealt with Society for Worldwide Interbank Financial Telecommunication (SWIFT) in creating criteria for auditing of TQR and Q-Gate review processes.
