Senior Business Analyst Project Lead Resume Profile
4.00/5 (Submit Your Rating)
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
Confidential
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
Confidential
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
Confidential
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
Confidential
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
Confidential
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