We provide IT Staff Augmentation Services!

Sr. Business/data Analyst Resume

Charlotte, NC

SUMMARY

  • Over 8+ years experience as Business/Data Analyst with Project Management in directing cross - functional teams of technical experts to analyze systems & processes and implement infrastructure improvements.
  • Extensive working experience in Retail, Investment Banking, Credit Cards and Commercial bank industries. Hands-on experience with Bloomberg Portfolio Order Management System (POMS).
  • Fully understanding of Straight through Processing from Front Office to Downstream Systems and Custodian.
  • Exposure to ERISA, SMAC, GSMAC and SWIFT and other batch files.
  • Working knowledge of consumer lending, credit/debit card operations (Origination, Maintenance, Embossing, Batch Processing, ATM Transactions).
  • Experience with trading (OMS), Market Data, Fund accounting, Portfolio Management, Compliance, portfolio risk and back office systems.
  • Extensive exposure on Front to Back processing of financesthrough Financial Service Providers(FSP) tools like:miRevenue, Finacle &FlexCube.
  • Have considerable expertise in Metadata Management, Data Analysis, Data Profiling & Quality, Data Governance and Master Data management (MDM).
  • Well versed with Data Migration, Data Conversions, Data Mapping, Data Extraction/ Transformation/Loading (ETL) using DTS, PL\SQL Scripts.
  • Experienced in Data Warehouses and data marts for Business Intelligence reporting and data mining along with developing and documenting process flows for business processes.
  • Experienced in the design of table structure and table relationship in dataset. General understanding of Database Management System and Data Warehouse including their functional and technical architecture. Experienced in creating query language in SQL Advantage.
  • Broad knowledge in Automated Clearing House (ACH), Bank Clearing System, Electronic Funds Transfer (EFL), and SWIFT. General understanding of Accounting process including general ledger and account reconciliation.
  • Customer and end-user focused. Skilled at analyzing business needs, transforming them into technical designs and applying technical skills and business knowledge to achieve sound results.
  • Strong Knowledge of SDLC methodology and project life cycle, UML, RUP and Rational Suite including Rational ClearQuest, ClearCase and RequisitePro. Experienced in full life cycle of system development.
  • Experienced in conducting GAP Analysis, System Integration Testing (SIT), User Acceptance Testing (UAT). Proficient in developing test scenario and test cases and verifying test results.
  • Able to work independently and as part of a team.

TECHNICAL SKILLS

Operating Systems: UNIX, Windows 95/98/NT/2000/XP/7/8/10, Linux.

Databases: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase

Application Servers: IBM Websphere, ATG Dynamo, BEA WebLogic.

Internet: HTML, XML, VB Script, ASP, JavaScript, JSP, J2EE.

Automation Tools: MS Visio, Rational Rose, Rational ClearCase, Rational RequisiteProDocumentum

Bug Tracking Tools: Mercury TestDirector, Rational ClearQuest

Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS)

Data warehousing Tools: Informatica, Business Objects, Cognos, Erwin

Testing Tools: Quick TestPro (QTP), TestDirector, WinRunner, LoadRunner

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Business/Data Analyst

Responsibilities:

  • Performed requirements gathering from the business users of the system while adhering to SDLC (Software Development Life Cycle) industry best practices.
  • Developed excel models to derive the amortization schedule for Whole loan products and Mortgage Backed Securities
  • Interacted with Software development team and Business users as a liaison in helping developers to understand the business requirements thereby ensuring the proposed applications comply with the business specifications.
  • Assisted in the automation of the mortgage portal with the Loan IQ system for the conditional approval
  • Analysed information and requirements and documented them. Reviewed the Business Requirement document and detailed the Systems Requirement document.
  • Build a data model which integrates Loan IQ Application to centralized Data Warehouse with PeopleSoft integration. Worked in the process of upgrading the PeopleSoft version from 8.9 to 9.1.
  • Designed different document templates to gather Business Requirements, Change Requests, gap analysis and UAT.
  • Experience in data governance/ data stewardship business/systems analyst needed to work as part of a team on data governance and writing SQL queries.
  • Implemented the entire Rational Unified Process (RUP) methodology of application development with its various workflows and activities.
  • Analysed the system to be implemented for production to ensure that it handles incomplete and accurate data and performs default method of calculations for various mortgage products like Mortgage Backed Securities, and Asset Backed Securities.
  • Extensive use of SWIFT messaging for secure financial transactions.
  • Extensive knowledge of Trade data accounting, multi firm processing capabilities. Straight through Business processing with integration through SWIFT messaging with counter parties through the complete settlement process.
  • Translated high level business / data requirements into Process, Workflow, and Data Flow Diagrams using Rational Rose / MS Visio / BPMN towards facilitating clear understanding of the business process.
  • Mapped all as-is business processes using BPMN standards on MS Visio.
  • Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
  • Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
  • Involved in the analysis of the existing data mapping phase according to functionality and data conversion procedure.
  • Interacted with the business and technical team to create front-end and back-end FSD’s and communicated these to the stakeholders while co-coordinating approvals.
  • Prepared project plan and defined different milestones.
  • Documented and assisted in the implementation of ITIL business processes: CMDB, Service Desk, Incident Management, and Problem Management. CreatedProcess Flow diagrams, Use case diagrams (UML) using MS-Visio.
  • Transferred the business requirements BRD into technical requirements FSD.
  • Discussed different functional requirements and defined high level design and Use Cases.
  • Used MS Excel and MS Word to create a field-to-field data map that was used as a main specification document for the conversion program.
  • Developed traceability matrix for maintaining/updating system requirements using MS Excel.
  • Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met. Identified and participated in resolution of business system issues.
  • Lead Validation/Verification, SIT (System Integration Testing), mock conversion on the system to ensure data accuracy and Bank’s business needs.
  • Wrote User Acceptance Test Plan based on business users requirements and reviewed Test Plan templates.
  • Delivered and maintained extensive documentation for future extendibility of the system
  • Involved in review and Gap Analysis of Functional Requirement documents and the creation of technical documents and related test case documents
  • Worked on the Microsoft SQL query to extract the data required for data validation.
  • Provided the management with Test metrics, Reports, and Schedules as necessary using MS Project and participated in the design walkthroughs and meetings
  • Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle)

Environment: Windows 10/8, Mainframe, Agile/Scrum, IBM DB2, JIRA, Informatica, UML, Oracle 12c/11i, SQL Server, PL/SQL, HP Quality Centre, QTP, SOAP, RESTful, MS-Office.

Confidential

BusinessSystem Analyst

Responsibilities:

  • Participated in project management, design, requirements definition, specification, budgeting, control, and restructuring of organizations
  • Prepare Use Case Models based on Business Requirement documentation gathered through interaction with users. Studied existing business application and processes, collected end user requirements and suggested the improvised Business Process Model.
  • Utilized corporation developed Agile SDLC methodology. Assigned tasks among development team monitored and tracked progress of project following agile methodology.
  • Facilitated Joint Requirement Planning (JRP) sessions with SME’s in understanding the Requirements pertaining to Loan Origination to Loan Processing.
  • Gap Analysis of client requirements generated Workflow Process, flow charts and relevant artifacts
  • Defined and documented the Vision and Scope of the project. Conducted one on one interviews with high level management team and participated in the JAD session with the SME’s.
  • Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
  • Configured the Data mapping between Oracle and SQL Server 2012.
  • Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams.
  • Led the development of a training program to train users on a custom web application and a Cognos ad-hoc reporting environment.
  • Involved in Business Process Management (BPM) activities like Process Design, Process Monitoring and Process Execution. Worked as a liaison between the business and technical side to convey the business needs to the system architects.
  • Developed EXCEL sheets for portfolio Risk and return Analysis, as a basis for complex trading packages designed by programmers. Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
  • Dealt with the change management of applications and Infrastructure using the Remedy tool.
  • Worked with business analyst to design weekly reports using Cognos Report Net.
  • Designed Use Cases using UML and managed the entire Functional requirements life cycle using RUP.
  • Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
  • Extensive knowledge of Trade data accounting, multi firm processing capabilities. Straight through Business processing with integration through SWIFT messaging with counter parties through the complete settlement process.
  • Conducting Requirement Analysis, Use Case Design, Designing Test Plans and developed database schemas based on the logical models. Conducted the final user-acceptance testing (UAT) and usability testing
  • Involved in review and Gap Analysis of Functional Requirement documents and the creation of technical documents and related test case documents
  • Worked on the Microsoft SQL query to extract the data required for data validation.
  • Involved in Cross-functional teams, developing new ways to boost efficiency and delivering results in a fast changing environment to achieve company goals
  • Provided the management with Test metrics, Reports, and Schedules as necessary using MS Project and participated in the design walkthroughs and meetings
  • Analyzed Business Requirements andFunctional Requirements documentation to ensure application was in sync with Flex Cube
  • Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle)

Environment: Agile, Windows 7/8, Microsoft Project, MS Access, Remedy, Business Objects, Cognos, MS Visio, SQL, MS Excel, Oracle 10g/11i, MS Visio, MS PowerPoint.

Confidential, Boston, MA

Data Analyst

Responsibilities:

  • Involved in the analysis of the existing credit card processing system, mapping phase according to functionality and data conversion procedure.
  • Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
  • Followed solely RUP methodologies during the course of the project.
  • Accumulated system requirements from various departments through surveys and interviews.
  • Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
  • Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
  • Used Data Driven Testing methodology to test the application with multiple sets of data. Integration of ITIL Processes with other Operational functions.
  • Utilized ITIL methodologies to assist accounts in SLA management including incident /change management.
  • Conducted evaluation of bank’s data governance structure and identified gaps in structure, data and systems.
  • Developed and managed creation of product documentation to communicate features, benefits, positioning and impacts to different audiences and ensured that documentation deliverables from various groups are produced as needed.
  • Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing
  • Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
  • Involved with multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, DataStage, Data Warehousing, Websphere and Cognos.
  • Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
  • Involved in reviewing test plans and test cases and ensuring test cases reflect user needs. Also responsible for conducting user training and user acceptance testing to ensure and verify system is designed according to user needs.
  • Conducted review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting.
  • Suggested measures and recommendations to improve the current application performance.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), Casewise modeller, IBM Websphere, XML, Oracle, DB2, Sybase, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro

Confidential, Boston, MA

Business Analyst

Responsibilities:

  • Directly involved in discussions with financial engineers as well as traders on the Fixed Income Trading Desk to conceptualize their needs and was also responsible for transforming conceptual ideas into functionality
  • Designed and implemented Front End to a Fixed Income Derivatives Trading System, including trade blotter and interfaces to risk management, accounting, and middle and back office.
  • Designed and implemented Simulation Tool to price complex equity and index derivatives in combination with underlying assets for portfolio creation and hedging.
  • Redesigned the core of the Options pricing/trading system the Volatility Server.
  • Designed and implemented Portfolio Risk Management Analysis System to automate hedging of various investment portfolios.
  • Created a highly user friendly and scalable interface which aided futures/commodities traders on the trading floors.
  • Developed EXCEL sheets for portfolio Risk and return Analysis, as a basis for complex trading packages designed by programmers. Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
  • Actively involved in validating the requirements and applying the agile framework throughout the SDLC. Used MS Visio for Process modeling and Business Process flow diagrams.
  • Responsible for numerous decisions in respect to business policies, procedures, methods for implementation. Facilitated JAD Sessions with users, developers, and Database Design Team to deal with backend synchronization issues.
  • Basic understanding of Cognos and Data Warehouse environments.
  • Performed What-if analysis using Excel as per the requirements of the managers.
  • Provided walkthroughs of the Reporting feature for tracking the success of the referral program, to the Supervisors and Senior Management
  • Created Deployment Document in conjunction with the Development, Infrastructure, and Network Teams containing instructions for maintaining the Application
  • Created complete Work-flow and Training documents for users at the time of hand-off

Environment: JSP, Oracle, HTML, XML, Cognos, Rational Rose, MS Visio, RUP, MS Project, SQL, MS Access, MS Excel and MS Word.

Confidential, Carson City, NV

Data Analyst

Responsibilities:

  • Prepared project plans using MS Project and coordinated timelines as guided by the Project Manager
  • Gathered requirements and prepared Use Cases (General System Design documents and Detailed System Design document) by interviewing tax agents, users and clients.
  • Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
  • Conducted joint requirements planning (JRP) sessions as a facilitator to gather requirements from the business area and to discuss different critical success factors of the project like Operational Feasibility Analysis, Technical Feasibility Analysis, Cost Benefit Analysis & etc.
  • Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
  • Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
  • Manage the product development of a proprietary EDI system enabling the integration of electronic invoicing with traffic, billing systems, and order fulfillment.
  • Prepared questionnaire based on the System Analysis Performed for all entities.
  • Conducted extensive Joint Application Development (JAD) sessions for all business related issues.
  • Provide business, functional and business rules requirements for Unemployment Insurance Modification (UI Mod) RFP (Request for Proposal)
  • Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Sybase Database Servers.
  • Prepared High Level Logical Data Models and BRD’s (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
  • Successfully analyzed the data integration issues and created appropriate crosswalks and other documentation to ensure smooth communication between systems.
  • Followed the guidelines of AGILE methodology.
  • Worked on the As Is system and develop the To Be system concept and also prepare the System Process Maps.
  • Modeled AS IS and TO BE processes using MS Visio.
  • Developed business proposals and RFP responses and trained others in this capability.
  • Helped design scope documents and the Request for Proposal (RFP) after extensive ROI analysis and coordinated with top management for the approval process.
  • Configured the Data mapping between Oracle and SQL Server 2005.
  • Helped in build releases production support solving new requests.
  • Provided data modeling support for numerous strategic application development projects.
  • Documented the meeting minutes with issues of about discussed and solutions resolved.
  • Presented the mapping document with all business logic applied for the system to Project Manager.
  • Gathered information and documented on Conceptual design and Technical design for phase III systems.
  • Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams (DFD).
  • Created the test cases for all the Use Cases using EA tool.
  • Developed XML schema for data retrieval and processing to improve system flow through metrics
  • Created test scripts for all the test cases in PL/SQL.
  • Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.

Environment: Visual Basic, Sybase, Toad, Teradata, MS Visio, Erwin, Microsoft Word, Project, Excel, PowerPoint, Visio, GIS tools, Windows NT, UNIX, Oracle, PL/SQL, MS Access.

Confidential

Business Analyst

Responsibilities:

  • Interview client to gather information on the client’s current income, estimated net worth, liquid asset, tax status, financial objectives, risk tolerance, etc. that are all needed to develop a financial plan.
  • Understanding and developing requirements and use cases for account opening maintenance and reporting for new accounts on Confidential ’s private banking and trust application, platform service, Integration and Implementation.
  • Interacted with business SMEs, enterprise architects, developers, business intelligence, and data warehouse teams regarding project requirements explanation and interpretation.
  • Liaison for Portfolio accounting Security movement and asset control (SMAC) responsible for trade processing, Free receipts and deliveries.
  • Responsible for documentation on the design, development, implementation, daily loads and process flow of the mappings.
  • Strong knowledge of Centralized data management or Knowledge Management System, scrubbing process components supporting all asset data need on the Confidential ’s GWM platform involving securities data load from multiple vendors.
  • Extensive use of SWIFT messaging for secure financial transactions.
  • Assisted in the development of Activity Diagrams to represent the business and operational workflows and Sequence Diagrams to demonstrate the timing and sequencing of events.
  • Analyze and evaluate the financial information obtained from client to devise an appropriate portfolio and investment plan to meeting the client’s financial goals.
  • Explain to client about the purposes and details of investment plans and strategies, the types of services that are to be provided, and the responsibilities that are to be taken by the Financial Consultant.
  • Implement investment planning recommendations and refer client to executives and partners of specific programs such as venture capital, 1031 property exchange etc. for further assistant on technical details, risk evaluation and tax benefits.
  • Contact client periodically to determine if there have been changes in their financial status.
  • Keep current client plans up-to-date and recruit new client on an ongoing basis.

Environment: Rational Enterprise Suite, MS Office, MS Project, MS Share Point, MS Visio, IBM Websphere, XML, Oracle, DB2, Sybase, SQL, WinRunner, LoadRunner.

Hire Now