SUMMARY

• Over 15 years of experience as an accomplished Project Professional in Business Analytics, Migration,Data conversion Development and Implementation, Testing and Operations.
• Expert in preparing Business Requirement Documents and Functional and Technical Specification Documents, Use Cases.
• Highly skilled in liaising with various client teams for end - to-end project delivery SMEs, architects, development, testing & implementation
• Possess in depth ability to understand business requirements, articulate design, evaluate and highlight risks.
• Hands on experience in gathering requirements from business users located at various geographic locations globally.
• Experience in regulatory reporting, Asset Liability, Income expenditure (ALM) requirement analysis.
• Experience working with onsite, offshore and near shore development teams.
• Knowledgeable in ETL processes, SQL, PL/SQL, Oracle Flexcube, Temenos T24 and interfacing with SWIFT systems.
• Good communication and interpersonal skills with enthusiasm to continuously learn and execute.
• Strong Banking (Retail and Commercial), Wealth management products ( Money Market, Certificate, Bonds, Shares, Equities, Mutual funds, Structure products, FIX metals, Securities), Financial and Construction domain knowledge.
• Well versed with SWIFT message standards. MT103, MT202, MT300, MT320, MT540, MT541, MT542, MT700, MT710,MT940, MT950 etc…
• Highly Proficient with SDLC using Agile and Waterfall Methodologies.

TECHNICAL SKILLS

Methodologies: Agile, SDLC, Waterfall, SWOT

Modeling & Design Tools: UML, MS-Visio 2007/2010

Requirement Management Tools: Rally, JIRA, Wireframes, mockups

Defect Tracking Tool: Rational Clear Quest

Version Control Tool: Visual Source Safe, Rational Clear Case

Operating Systems: Windows XP/Net/2000/2003, MS DOS, Unix

Languages & Other Tools: SQL, PL/SQL, INFO BASIC, SQL Loader, TOAD, Tivoli

DBMS: MS SQL Server 2005/2008/2012 , Oracle 11g, Universe, JBase,DB2

MS-Suite: MS-Office, MS-Excel, MS-Visio, MS-Access, MS Outlook, MS Power-point, MS- Project, Magic Draw.

Testing Tools: HP ALM (QC), Test Director

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. Business Analyst

Responsibilities:

• SME and Lead BA for Migration, UAT, FSR Review, Operational Readiness, Go-Live support and end user training.
• Coordinated JAD sessions with multiple business and technical groups across the 6 branches.
• Developed a deep understanding of the clients’ needs and transformed them into user stories with acceptance criteria in Rally.
• Assisted the development team, business operations team and the testing team to analyze, fix, test and transmit EDI (interface) files on a daily basis for transaction processing.
• Used Visio, wireframes and mockups to create screen requirements
• Worked on retail products ( Checking and Saving Accounts, Certificate of Deposits, Mortgage Loans, Car loans, Cards) and Corporate products ( Trade finance, Treasury, Securities, Discounting Loans)
• Worked on Wealth management products (Money Market, Certificate, Bonds, Shares, Equities, Mutual funds, Structure products) and interfaced with consolidated reporting system call Orchestrate.
• Worked on Treasury related products for securities settlement SWIFT messages MT540, MT541,MT54X
• Worked on SWIFT message standard upgrade.
• Created reports using SSRS for data reconciliation and control reporting during data migration
• Worked on Anti Money Laundering (AML) - SAS, OFAC filtering systems implementations for Newyork
• Worked on post-production and change management process including release processes.
• System Testing(End-to-End) which include creating the MT format messages and their corresponding cover, uploading the messages using ftp, sending the SWIFT messages by running automated jobs,
• Validating the User Interface (Hold for Cover) application for the settlement processed.
• Data Setup for SWIFT Messages which include validating the message for headers, message content, and a trailer. Data Setup was done for different types of Message formats which include for settlement SWIFT massage of MT54X.
• Coordinated with the stakeholders and business users in order to update the business process.
• Followed SDLC and Agile methodologies in implementation process for each of the sprints and releases.
• Created the to-be process flow chart by comparing with the as-is process in Visio.
• During the migration process owner of the data governance through quality control by assessing, managing and protecting customer NPI data.
• Managing the files on SharePoint and troubleshooting and encrypting the files as required to share with third party vendors.
• During the migration process the collected information is accurate and unambiguous
• Monitor policies and procedures are in place
• Share the existing IT landscape is known to the architects
• Follow the organisation's requirements are translated unambiguously to partners to ensure trustworthy relationships.
• Liaison between the developers, testing team, upstream/downstream systems, reporting team and the UAT teams.
• Created mapping documents for SWIFT and automated Nostro reconciliation process.
• Created mappings for regulatory report requirements for Newyork,India, Hongkong, UAE.
• GAP and IAS reporting requirements for New York.
• Regulatory reporting for New York branch Liquidity Coverage report (LCR), CCAR reports.
• Helped to update the Agile Scrum board in Rally to plan, deliver and report the status of the project for all the 5 sites.
• Provided training to all the new joiners and also monitored the activities performed by the teams’ offsite.
• Created presentations, scenario narratives and regulatory forms that analyze and summarize capital projections for senior management, internal risk governance committees and regulators.
• Travelled to various countries as an SME to ensure smooth implementation.
• Worked with the technical teams for migration of code into pre-deployment and simulation environment.
• Responsible for data collection, creation of control reports for reconciliation and detailed Go-Live and Rollback Plan.
• Worked with FIS systems for AML systems and interface with Core banking system.
• Worked in Financial System Review (FSR) with stakeholders and ensured sign-off by the agreed date.
• Performed General Ledger implementation readiness activities.
• Documented Standard operating procedure (SOP)s for new products and user guides for transactions processing.
• Worked with the end users and the Project and IT teams to provide Go-Live support.
• Integral part of the team that was responsible for Operational Readiness.
• Managed the overall task list for the Go-Live support and worked with the Command Center teams during the cutover and Go-Live phases.
• Prepared end user training material/help documentation and conducted training sessions for the users.

Confidential, Atlanta, GA

Sr. Business Analyst

Responsibilities:

• Worked with clients to design and implement consumer facing mobile/Web self-service solutions and CRM applications
• Worked with Confidential Visual IVR products to implement various projects for Microsoft such as Office 365, Xbox, product activation and retail stores
• Experience working with Confidential workspace to gather the detailed business requirements
• Experience working on Confidential Hostfuse products that facilitate real-time data access from back-end and legacy applications running on mainframes to the front-end users
• Conducted JAD sessions and created use cases, process flows, screenshots and Power Point presentations for the Web applications
• Partnered with the clients and various IT teams to identify, analyze, recommend and implement technical solutions to the business challenges
• Translated the business specifications into technical terms and promoted the business objectives within the technical teams
• Experience developing mobile interactions, user stories, scopes and design
• Developed artifacts that provided the ability to validate requirements and expectations proactively
• Participated in proposals, feasibility studies, implementations and new business development
• Designed and developed using Web/Mobile Web enterprise technologies
• Experience in developing using modern backend and frontend technologies such as ExtJS
• Used SOAP UI to test the request-response web services
• Experience in supporting the development teams with sprint planning and testing
• Experience using defect tracking tools such as JIRA
• Effectively interfaced with various levels and skills within the organization to derive solutions
• Interfaced with and managed the external partner agencies working development teams
• Worked with the PMO teams in defining the project delivery methodology and templates
• Facilitated the project status meetings and provided weekly status reports to the customers
• Developed test scripts, assisted in system and user acceptance testing to ensure functionality of the system

Environment: Confidential Visual IVR, Confidential Interact, Confidential Workspace Agent Desktop, Microsoft Word, Microsoft Visio, Microsoft SharePoint, JIRA, SOAP UI, JavaScript, ExtJS, JQuery, HTML, CSS, XML, Java, Confidential HostFuse and JIS ( Confidential Interface Server)

Confidential, Dallas, TX

Sr. Business Analyst

Responsibilities:

• Involved in all phases of software development life cycle for this project, Agile Methodology.
• Interacted with the Business Users to analyze the business process and gathered the requirements, made necessary changes to existing process objects to fulfill their business needs.
• Conducted daily stand up meetings in the role of a scrum master
• Assisted the manager on product backlog by documenting the user stories.
• Created Data Flow Diagrams and Process flow diagrams by using MS-Visio.
• Worked extensively with MS-Visio to present processes graphically; created the AS-IS and TO-BE process flows.
• Managed and prioritized release backlog.
• Assisted in providing with cross-functional knowledge to developers and business users.
• Tracking and managing requirements changes using Spreadsheets.
• Participated with QA Team by executing Functional, Integration and System level test cases.
• Acted as User Acceptance Testing coordinator and monitored business testing and interfaced with the development team regarding defect status and fixes on daily basis.
• Also actively participated in UAT testing for the application.
• Ensuring the test cases run met with user need regarding the aspect of the functional, User Interface, Performance, Usability and Security requirements.
• Formulated Excel spreadsheets and charts for analyzing the reports.
• Extensively worked on Product Information Management by managing the information required to market through distributed channels.
• Prepared training documents for Oracle SCM/Finance and assisted in user training in WIP, OM & PO modules.
• My Deliverables were Business Requirement Documentation, Functional Requirement Documentation, Test Plan, Requirement Traceability Matrix (RTM)
• Developed end user training modules for training the user about the new system.
• Monitored the performance of the application and collecting feedback from users.

Environment: JAVA, MS Word, MS Excel, Oracle 8.0, MS Access

Confidential

Sr. Business Analyst

Responsibilities:

• Conducted user interviews, gathered requirements, analyzed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
• Responsible for identifying, documenting and testing the data mapping feeds from several reference data systems, to risk applications
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Captured and tracked Business and Functional requirements including 401(k) and 403(b) data flows, developed Use Cases, wireframes, Process Flows, Data Modeling and Flow Diagrams, and documented Systems Specifications using RUP methodology.
• Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams (DFD).
• Performed GAP analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.
• Develop and maintain Portal leveraging WebLogic Portal Design, C, C++, Java and JavaScript.
• Created DataStage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Use Cases and other Process Flow Models were designed using MS Visio and Rational Rose.
• Coordinated JAD session with system analysts, development team, project manager for application development and Pre-validation specifications.
• Created wireframes Mockup and storyboards
• Coordinated various kinds of User Acceptance Testing (UAT) including regression testing, system testing, integration testing, functional testing, alpha & beta testing.
• Authored test plans, test cases for various test scenarios and helped testing team to better understand the test scripts.
• Used Test Director which is a Mercury tool to help manage defects and issues log during the testing phase.
• Managed Content using Shareoint content management server
• Involved in the creating the User Interface Specification Document and User Training Manual as per project specification with the help of development team
• Configured the Data mapping between Oracle and SQL Server 2005.
• Worked as a User/Customer advocate and negotiated with user as well as the technical team and management staff to resolve any outstanding requirement conflict during the whole SDLC process.

Environment: Rational Suite (Rose, Requisite Pro), Windows XP/2000, SQL, XML, HTTP, MS-Project, MS-Office Suite, SharePoint, MS Visio, Win Runner, Load Runner, JavaScript, Test Director (Mercury Interactive), Java, Oracle

Confidential

Business Analyst

Responsibilities:

• Gathered business requirements and documented the business processing by interacting with Clients and operations teams
• Created Business requirement documents, Use cases, system documentation, functional specs, dataflow diagrams and screen designs
• Reviewed and approved test plans and scripts
• Analyzed the existing system and created mapping documents.
• Used SDLC process for project implementations.
• Extracted data from Oracle databases, utilizing SQL scripts and Microsoft Access queries, to analyze data, research and resolve inquiries, ensure data integrity and mapping, and create reports for management, business users and for testing purposes
• Business requirement analysis and Gap analysis of existing system vis-à-vis’ new functionalities
• Co-ordinated with the Accounts Payable team to ensure all the transactions were recorded in the books of account.
• Co-ordinated with Internal Audit and Compliance departments for reporting requirements and resolving issues.
• Visio, wireframes and mockups are used to create screen requirements

Confidential

Developer and Production Support

Responsibilities:

• Estimate the effort and resource requirements to successfully implement product
• Assisted Tech Lead in resource assignments to complete project tasks according to plan; establish criteria concerning deliverability performance maintenance design and costs
• Conduct status checks with clients and team to assess progress against plan; perform re-forecast of project variables as necessary
• Implemented Asset Liability Management system with Maturity analysis reporting.
• Used SDLC methods implementations.
• Act as liaison between company and client; coordinate internal and vendor technical teams
• Help research and develop documentation materials for education and training users; ensure documentation is technically accurate and conforms to company's policy
• Assist with research design scheduling and implementing education and training documentation projects; develop project plan for creating/updating courseware
• Modules implemented: Customer, Account, Loans, Deposits, Money Market, Reporting, Funds transfer, Forex, securities across geographies
• Design and implement Customer statement generation based on Retail and Commercial transactions.
• Implemented Tools for automated data quality checks auto reconciliation for balancing of Assets and Liabilities to Finance department
• Developed, Planned and Implemented Roll-Out Strategy for the new solution involving 0.5 million accounts across 6 countries
• Managed post implementation and maintenance support
• Followed change and release management process for new user requests, design and implementation to production

Confidential

Business Analyst/Data Analyst

Responsibilities:

• Business requirement, data analysis and gap analysis of existing system vis-à-vis’ new functionalities/new products.
• Managing the Release-on-release application testing delivery across different phases
• Assigning resources for Functional testing, Automation, Non-functional, Data Centric and System testing.
• Day-to-day interface with the technical, data operations, program management, research teams involved in product development.
• Conducting kickoff meetings/PowerPoint presentations with the key Stakeholders.
• People Management - Performing appraisals, Career planning and development for the team and managing talent retention.
• Exploring better methods / processes to improve productivity and efficiency. Project Lifecycle Management and Stakeholder Management.
• Review of reconciliation reports of Balance sheet and Income expenditure reports
• Created technical requirement to generate average balance sheet and customer product profitability

Confidential

Developer and supported data center operations

Responsibilities:

• Provided support, maintenance and enhancement to new and existing systems.
• Developed and testing solutions.
• Ensured accuracy of output on business critical systems.
• To support customers and operational staff in issue resolution.
• Analyzed user requirements & then developed systems that meet their requirements.