We provide IT Staff Augmentation Services!

Business System Analyst Resume

SUMMARY

  • Over 9+ years of experience as a Business Analyst in various sectors of business with thorough understanding and knowledge of Software Development Life Cycle methodologies (Waterfall Model, Iterative, Agile SCRUM)
  • Experienced in performing Business Process Reengineering/Gap Analysis to ensure the compatibility of the existing system infrastructure with the new developments
  • Excellent knowledge in Core Banking, Regulatory Reporting, Commodities, Market Risk, Credit Risk, FX, Treasury, and Consumer Credit
  • Served as the primary interface with customers, users, and stakeholders on high - risk projects and lead Agile/Scrum projects
  • Highly proficient in preparing Business requirement documents (BRD) and supported in preparing Systems requirement Documents (SRD), and Technical requirement Documents (TRD).
  • Worked extensively on Master Data Management (MDM) concepts, methodologies and ability to apply knowledge in defining solutions
  • Defined scalable Cloud data solutions using MPP Data Warehouses (Snowflake, Azure Data Warehouse), data storage (Azure Blob Storage) and analytics platforms (Databricks)
  • Focused teams on meeting Business objectives and tracked progress to ensure project milestones are completed on time, on budget and with the desired results
  • Experienced in data analysis, validation, cleansing, and collection and reporting from various sources including databases, manual flat files, and external websites
  • Demonstrated advanced understanding for data warehouse discipline, data lakes, defined enhanced data mapping, reviewed and solved data dependencies for structured, unstructured data, SQL, and ETL
  • Expert communicator and involved in interaction with variety of audiences (PMs, technical specialists, developers, architects, SMEs)
  • Experienced in preparing Use Case Specifications, Functional Specifications and well acquainted with workflows and UML (Unified Modeling Language).
  • Translate business objectives into prioritized technical features, evaluate various implementation strategies, and identify measurable metrics
  • Excellent working knowledge and understanding of web-based and middleware technologies (.Net, J2EE, XML, Webmethods)
  • Developed /maintained all project communication deliverables including roadmap, planning list, change request, timeline, budget, scope and requirements.
  • Supported with testing effort and involved in preparing the functional test plans, test coordination, escalation, prioritizing the bugs and user acceptance testing.
  • Capable of forming and maintaining positive and productive working relationships in internal, external, independent, team environments, creative and aggressive self-starter with integrative thinking skills.

TECHNICAL SKILLS

Cloud Technologies: Azure, Azure SQL, Talend, Blob Storage, Snowflake, Databricks

Database: SQL Server (T-SQL), Oracle 10g/9i (PL/SQL), MySQL, PostgreSQL, Informatica MDM

Testing Tools: HP Quick Test Professional (QTP), HP Quality Center, Load Runner, HP ALM

Reporting Tools: Business Objects, Microstrategy, Crystal Reports, Cognos, PowerBI, Qlickview

Business Tools: Microsoft Office Suite (Word, Excel, PowerPoint, Access, Visio, MS Project)

Languages: C, C++, HTML, DHML, Java Script, XML, Python, Spark

Other Tools: Rational Requisite Pro, Balsamiq, Atlassian Suite (JIRA, Confluence, Bamboo, Crowd).

PROFESSIONAL EXPERIENCE

Confidential

Business System Analyst

Responsibilities:

  • Deliver data solutions which aid in distributing input (i.e. Cash Flow, Historical Actuals, Cohort Model, Discount Rates, Flow Timings) and output data pipes linked to actuarial vendor solutions (i.e. Milliman Integrate)
  • Interact with actuaries, claims associates, underwriting, product management, accounting, IT to expand the analytics capabilities for financial and regulatory reporting
  • Design and implement solutions in Azure SQL Data Warehouse by migrating data from traditional database systems (such as Teradata) to Azure and leveraging Data Lake Analytics
  • Introduce preventive and detective controls for creating reconciliation processes to ensure data is bypassed across varied layers and had been reconciled end to end through the process
  • Defined strategic roadmaps based on data engineering findings and further navigate data solutions/fixes for business team to receive maximum value
  • Created solutions based on enterprise data governance framework which promotes row and column-based security, error handling and logging processes across multiple layers
  • Performed Gap analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements Involved in the creation and maintenance of the Workflow plans and artifacts
  • Manage Sprint activities by creating User Stories, re-visiting Acceptance Criteria, communicate sprint progress with Stakeholders and playing key role in managing Scrum/Kanban Board
  • Work with Product Owners to understand functional requirements and interact with other cross-functional teams to design, develop, test, and release features
  • Identify, design, and implement internal process improvements: automating manual data processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
  • Define reporting solutions in PowerBI, based on key performance indicators which requires extensive quantitative and quantitative analysis for internal operations and improve overall decision making
  • Liaise with onsite/offsite development team on daily basis to monitor project progress by tracking activity, resolving problems, publishing progress reports and recommending actions

Environment: MS Office Suite, Azure SQL, Talend, Azure Blob Storage, Snowflake, Databricks, Teradata, Atlassian Suite, PowerBI, Spark

Confidential, Livingston, NJ

Business System Analyst

Responsibilities:

  • Analyzed varied sources of Counterparty and Trade Input systems to streamline, clean up, and enrich the data universe by sourcing directly from the golden source systems
  • Worked with Credit and Market Risk team to deliver projects focused on automation and re-engineering of the Credit Valuation Adjustment “CVA” process and Potential Future exposure “PFE” process
  • Assess risk exposures (market, liquidity and credit) further report these findings to risk management and to key areas of the organization
  • Drove data enhancements on Enterprise Customer Master (ECM) which takes data feed from varied entities and supply to CRM and Risk Management team
  • Interacted with the business users in knowing the business views for gathering, documenting and validating requirements as user stories, translating functional requirements to technical features and identifying scalable solutions
  • Support multiple agile Scrum teams with planning, scoping and creation of technical solutions for the new product capabilities, through to continuous delivery to production
  • Handled external data enrichment by integrating with 3rd party providers for external cleansing (D&B, LexusNexus, Experian & Address Doctor) and enhancement
  • Configure and refine MDM Hub Match & Merge Rules, fuzzy logic and provide rule tuning suggestions for efficient results
  • Design workflow customizations for Data Stewards using IDD to manage BAU activities
  • Document and design Composite Business Services for real-time and near-real-time enterprise integration needs and communicate changes to technical Stakeholders
  • Collaborate with business users to assist them in defining reporting requirements, creating BI reports, responding to ad hoc queries and providing accurate business answers for complex business problems
  • Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
  • Lead in conducting UAT and QA testing by integrating HP QTP with HP ALM to increase testing productivity in every cycle.

Environment: MS Office Suite, Informatica MDM Multidomain, Atlassian Suite, XML, Dun & Bradstreet, Experian, Cucumber (Gherkin), Qlickview, Python

Confidential, White Plains, NY

Lead Business System Analyst

Responsibilities:

  • Analyzed market risks taken within a specific product area, monitoring commodity risk positions, understanding P&L attribution and drivers, and for performing quantitative and qualitative analysis on positions
  • Assess risk exposures (e.g., market, liquidity, credit, etc.), and report these findings to risk management and to key areas of the organization. Interface with the trading desk and other risk and support groups (i.e. Compliance, Finance, Operations, etc.)
  • Manage counterparty exposures on a global basis by computing daily Mark-To-Market (MTM), Potential Future Exposure (PFE) & Credit VaR
  • Reviewed existing architecture to understand the customer/vendor/item (MDM) data model and documented informatica mappings for data extraction from varied source systems to Landing tables
  • Responsible for customer and product data harmonization across multiple sources
  • Translate business requirements and define deliverables in different phases of the project life-cycle by decomposing functionality
  • Adding stories and attending grooming sessions of various scrum teams to cover application level risks identified
  • Partner with internal stakeholders to sponsor initiatives and define minimum viable products (MVPs) for the program backlog
  • Use SQL to help analyze various position, price, and economic variables for the risk department and management
  • Identify and evaluate the impact of change requests within the business application and all upstream and downstream systems
  • Lead the effort to establish, define, maintain and communicate data architecture guidelines, standards and best practices within the data integration domain
  • Provide Futures Prices details to the for the EMIR regulatory reporting in form of CSV file based on the following requirements
  • Worked with GTRs like DTCC, to support regulatory reporting for Dodd Frank, CFTC, MIFID and EMIR
  • Coordinated with DTCC for Real Time (RT) and PET (Primary Economic Terms) message formats used for Trade Reporting (Real Time and End of Day)
  • Publish data related to OTC derivative contracts to vendor systems which provides regulators globally with access to data pursuant to supervisory authority for Dodd-Frank
  • Advise on removal of features from release relative to testing completion and operational risk

Environment: MS Office Suite, Informatica MDM Multidomain, Atlassian Suite, XML, SAP, Business Objects, DTCC RDS

Confidential, Stamford, CT

Lead Business System Analyst

Responsibilities:

  • Gathered requirements through interviewing internal business users, external users who were Traders, Brokers, Back office users and Risk analysts to enhance existing systems
  • Prepare monthly analysis of global banking fees and provide recommendations for cost structure improvements (Cash Pooling clusters)
  • Responsible for the maintenance of the loan accounting and system, including the daily paydowns, cash in and out and related treasury functions
  • Designed a global Payroll processing platform which integrates payroll providers with preferred banking network over re-deigned gateway
  • Restructured legal entities to support Alstom merger and simplified SEPA payments structured over SWIFT to achieve visibility and reduce cost
  • Acted as Super-Admin on online treasury systems for various 3rd party online banking platforms (Citidirect, DB Connect, SAP) by defining clearing strategy, account hierarchy, user access management and supporting transactions
  • Maintained enterprise master data (MDM) to support SoldTo customer process in Salesforce.com for enhanced data optimization
  • Worked with developers in creating the DMD (Data Mapping Document) to specify the Data mapping from various data base sources to the target database and analyzed the database and tables.
  • Assist in the management of FX risk mitigation operations, provide trade confirmation, settlement, month-end closing activates and notify appropriate stakeholders within SLAs
  • Enhanced the banking portal services to manage all administrative and operational aspects of online banking systems and corporate banking records
  • Provided support for ETL processes that extract data from multiple sources residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses using PL/SQL
  • Work with Automation Team and other team members to utilize automation where applicable
  • Worked closely with Front, Middle and Back Office to remediate any payment issues
  • Manage quarterly SOX controls and other related compliance activities governed by corporate Treasury
  • Mange the monthly production cycle for manual file input, manual adjustments and balancing

Environment: MS Office Suite, Wallstreet Suite, Informatica MDM, .NET, PL/SQL, Java Script, Crystal Reports, Balsamiq

Hire Now