We provide IT Staff Augmentation Services!

Senior Business Analyst Project Lead Resume Profile

Columbus, OH

Experience Summary

  • Over 8 years experience in Business Analysis, Data Warehousing and Business Intelligence. Provided delivery and consulting services to clients in multiple industry verticals financial services, Insurance, Retail and Energy
  • Certified Scrum Master with experience in Lean Agile methodologies
  • Proficient in building solutions for Data Management Business Intelligence
  • Extensive experience on Requirements Analysis, Solution Design, Data Analysis, Gap Analysis, Preparing Functional design specifications, Test Case preparation, Functional Testing, Risk Management
  • Extensive experience in Retail Banking, , Business Analysis knowledge areas and in large complex Data Warehousing projects
  • Extensive experience in Retail Banking, Finance change management, Insurance, Credit Cards, Securities and Capital Markets, Fixed Income Change management life cycle
  • Proficient in Project Management and SDLC methodologies Agile/Waterfall
  • Quick learner in adopting new Tools and work out solutions independently and in leading teams

Functional Technical Skills

  • Expert in Business Analysis, Data Warehousing and Business Intelligence
  • Excellent knowledge of ETL Tools Informatica and Ab Initio
  • Proficient in writing complex SQL queries and in using query tools and performance tuning solutions with SQL queries
  • Expert working with Teradata, SQL Server, DB2 and Oracle databases
  • Experience in Banking Operations Online and mobile banking, Payments, Assets Liabilities, Risk Management and Regulatory Reporting
  • Retail Banking and Online and Mobile Banking
  • Extensive experience in MS Office Excel Visio and in creating data flow charts and slicing and dicing of data
  • Quality Center, JIRA and Clearcase Testing Tools

Work Summary


Role: Senior Business Analyst Project Lead

Key Responsibilities:

  • Drive Scope definition of the Online and mobile banking Projects
  • Creating Functional design documents, Requirement Specifications, Process flow, Data modeling for Solution Implementation and Testing approach documents
  • Drive Project estimations, Requirement Gathering, Elicitation, Analysis and Documentation as Functional Design
  • Review Requirements and Functional Design with Project stake holders
  • Building comprehensive solutions for Data Marts for Data Management and Business Intelligence
  • Managing stakeholder meetings and driving Development QA teams for the Design, coding and Testing activities
  • Leading ETL QA team in Build, Designing, Reviews and Executing Testing
  • Managing and facilitating teams in IST and UAT Validations
  • Liaise with business users for requirements, design and UAT sign off
  • Occasional Production Support for complex/critical issues
  • Maintenance of Transaction data feeds like Alerts, Payments and Transfers
  • Domain trainings to the ETL, QA and BA teams
  • Perform logical analysis, gap analysis suggest recommendations about performance and process improvements
  • Contribute in project planning and Participate in the prioritization process


Role: Senior Business Analyst GGL Finance Change management

Key Responsibilities handled:

  • Participating in Scope definition of the Finance Change Requests and build business cases to communicate revenue impacts for prioritization of product enhancements
  • Quickly understand business issues and challenges and translating them to specific Business and software requirements
  • Preparing Business Requirement Specifications, Process flow, High level Design and Implementation and Testing approach documents
  • Requirement Gathering, Elicitation, Analysis and Documentation as Functional Specs
  • Preparation and Maintenance of Functional specifications and formally communicating to development team through written documents and joint design meetings
  • Validating the Accounting entries, Business Rules, Functionality and change request objectives to Financial Design Database using the account posting generator rules
  • Building comprehensive Risk Management filters for exchange Traded Instruments.
  • Managing stakeholder meetings and driving consensus to fit in with planned timescales and Coordinating with Development team for the Design and coding activities
  • Developing comprehensive and robust test cases plans and execution of these tests to ensure successful delivery of regular global technology releases
  • Designing, Review and Executing Test Cases.
  • Performing Unit Functional Testing, Regression, Zero Impact and Integration testing.
  • Change request Functionality Testing Providing BA's Development signoff
  • Liaise with business users for sign off in the Testing/UAT layers of the code
  • UAT and Production Support
  • Domain trainings to the technical and BA team
  • Perform logical analysis suggest recommendations about enhancement and fixes to business users
  • Provide object based cost estimations for the enhancements and new build
  • Assist in project planning and Participate in the prioritization process

Key Achievements in GGL - CAL Project:

  • Delivered solutions forExecutive Lean Agile implementation in the LOB
  • Received Feather in My Cap award from Wipro for outstanding contribution towards Re-designation of Assets project
  • Received Shining Star Nomination from Wipro for outstanding contribution towards Strategic Common Data Sourcing Project
  • Acknowledged as the one of Best Resources in the practice and commendation cited by Delivery managers in Wipro practice magazine for 4 quarters
  • Received UBS Senior Management Appreciations for contributions in CSI Repos, Re-designation of Assets, Strategic Common Data Sourcing Projects
  • Received appreciation from Client for preparing the Global Functional Specification implementation for across feeds, it's a huge cost saving in long term for UBS IB
  • Automated effort estimations by creating an Estimation calculation engine 20 improvement in providing effort estimation for customer
  • Documented Managed services Documents in record time and received sign off from client
  • Contributed towards Functional Specifications maintenance on Share Point
  • Articulated Process Documents and Functional and Business Analysis Training materials
  • Provided the knowledge transition on Project to all new BAs 8 members team


Role: Business Analyst Teradata Data Modeler

Responsibilities Handled:

  • Requirement Gathering, Elicitation, Analysis and Data Modeling
  • Conducted workshops for various banking products with Business Users, Source team and client IT teams and achieves end objectives
  • To analyze and document complex business processes/information requirements
  • Involved in extensive client interaction for requirement gathering and developments
  • Organized meetings with Business users, Source and Client IT teams to discuss pending issues to resolve and close the issues to get the signoffs for the individual products
  • Reviews and edits S2T, T2S mappings business reporting requirements specifications, business processes and recommends processes related to proposed solution
  • Translating analysis and reconcile requirements into functional specifications.
  • Documenting workflows and results of business analysis and obtain sign-off from client on the specifications.
  • Understand Business issues and data challenges of the client's organization


Designation : Relationship Manager CITI Business

Responsibilities handled as CITI Business Relationship Manager:

  • Wealth Management services for SMEs and HNIs
  • Acquisition of SME and large corporate clients for the CITI Gold relationship
  • Transaction Banking and Forex services for HNIs, SME and large corporate clients

Responsibilities handled as CITI Business Credit Manager:

  • Channel management for Premium Credit cards and Business loans
  • Risk assessment and Credit appraisal of Salaried, Self Employed Professionals for Premium credit cards and Business loans
  • Risk Management and Credit management for the alternate channels
  • Budgeting and costing for the DSA business sourcing
  • Training the DSA channels for Products and Regulatory Reporting


Designation : Associate Manager Personal Banking

Major Responsibilities:

  • Acquisition of HNIs for Wealth Management and Transaction Banking
  • Customer risk profiling Asset allocation, Product scheme selection Portfolio monitoring, review restructuring
  • Enhanced services across Mutual funds, Direct equities, Insurance
  • Strong client engagement by providing portfolio information market dynamics through active interaction with the Research desk
  • Responsible to take care of liabilities operations sales for personal banking segment
  • Handled Bundle Accounts channel for the personal banking department
  • Coordinating with assets team for cross selling liabilities

Hire Now