SUMMARY

• Seasoned IT Professional with 7 years of experience in Business Analysis, Financial Data Analysis, Data Modeling, Business Function specifications, developing Business process modeling flow diagrams, Project Management, Risk Management, and performing GAP analysis
• Experienced in all phases of System Development Life Cycle starting from planning, analyzing, requirements gathering, use case development, designing, testing, deployment and maintenance.
• Experienced in Mainframe and client server financial accounting systems, Wealth management services, Global custody, Domestic and global trust administration, Home mortgage applications, Treasury management and consolidation, General ledger, reference data and DDA systems posting and interfaces.
• Experienced in analysis of Equities, Fixed Income, Derivatives and Alternate Wealth Investment partnerships-Leveraged buyouts, Private Equity, Venture Capital, Growth Capital, Mezzanine, Distressed capital.
• Strong knowledge in Trade life cycle, Order management System OMS and Execution Management System EMS .
• Excellent knowledge of industry standard methodologies like System Development Life Cycle SDLC , Iterative Development Life Cycle Processes such as Rational Unified Process RUP , XP and Agile methodologies.
• Facilitated and participated in Joint Application Development JAD sessions for requirements gathering, resolving open issues and change requests.
• Strong proven expertise on User Stories, Use case Diagrams, Activity Diagrams, Sequence Diagrams and Class Diagrams.
• Expertise in using Data Modeling Tools for creating Logical and Physical Data Models
• Extensive experience in RDBMS implementation and development using SQL, PL/SQL stored procedures and query optimization.
• Strong knowledge of SQL and extraction/ transformation/ loading ETL process.
• Sound Knowledge and experience in Data Mapping and Data Analysis. Experience in dealing with different data sources ranging from Flat files, XML, SQL server, Oracle, DB2, MS Access and Excel
• Extensively worked on all phases of Data Warehousing project like Data mining, Data Cleansing, Data modeling for data staging Data Mart, ETL, Indexing, Quality Assurance, Data updating plan, and Data presentation to business users.
• Proficient in Rational enterprise suit including Rational Rose, Rational Soda, Rational requisite Pro, Rational Clear Quest, Rational Clear Case and MS Visio.
• Solid knowledge of usability engineering, user interface design and development.
• Extensively used technologies such as Rational Rose, UML, MS Visio, MS Project, MS Excel, MS Access. Ability to work effectively in a team environment as well as independently.
• Team handling experience, which includes work planning, allocation, tracking and execution. Relationship driven, Result driven and Creative out of the box thinking
• Proven analytical skills- Worked on large data management and process automation projects. Financial competency- Strong Understanding of SOX, CapEx, AR/AP and Compliances.
• Expertise in leveraging and implementing best PMBOK, SDLC, ITIL techniques and concepts.

TECHNICAL SKILLS:

• Programming Languages : C, C , C ,VC ,VB,VB.NET,C .NET, ASP.NET, Java, SQL, PLSQ
• Development Methodologies : RUP, AGILE, Waterfall, ESDM, STV
• Databases : MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase
• Application Servers : IBM Websphere, ATG Dynamo, BEA WebLogic.
• Internet : HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE.
• Automation Tools : MS Visio, Rational Rose, Rational ClearCase, Rational RequisitePro,
• Documentum
• 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,Niku Project WorkBench

WORK EXPERIENCE :

Sr. Business Analyst

Confidential

• Operational Excellence project involved enhancement of their Account Onboarding system and workflow management system - PCS NAO, to accommodate and integrate new Limited Purpose and 529 saving Account types. Performed pilot study and created presentation for Senior IT and Business managers explaining the ROI and scenario analysis, for their project buy-in. Conducted intensive business requirement gathering sessions with the stakeholders for scoping the project requirements. Analyzed research on operational procedures, methods and recommended changes for improvement, with an emphasis on automation and efficiency. Elicited, analyzed, detailed, documented and worked for achieving a sign-off on the project requirements. Managed expectations successfully in a dynamic and high-pressure environment.
• Created work breakdown structure and implementation schedule for the project deliverables.
• Elicited and gathered user and business requirements through JAD session, one-to-one walkthrough, open ended discussions, brainstorming and prototyping.
• Developed the current state vs. the future state diagrams for the project.
• Coordinated with Legal, Compliance and AML to make sure the audited workflows are created and all the required pertinence for the Account opening are captured.
• Created comprehensive user stories and use cases for the project.
• Created more than 150 wireframes as a method of the graphical representation for the development using Visio.
• Analyzed the requirements and created Test Strategies and Test plans in Excel to provide a head start for SIT and QA.
• Conducted sessions with architects, business and development teams to communicate the requirements and effects caused on the systems by the requirements.
• Interacted and coordinated with the third party product vendor Pershing Net X to ascertain the data mapping and XML specifications.
• Conducted walkthroughs with the developers for the development process to begin. Updated, tracked and shared task in SharePoint through event tracker.
• Interfaced with 4 onsite/offshore team members to keep the project development in sync. Conducted knowledge transfer sessions for the project.
• Compiled weekly project reports on the project health and schedules for Senior Management.

Environment:- BRD and FRS, Gap Analysis, Pershing Net X, Presentation, Future state documentation, Business Process Modeling, Workflow creation, Screen mock-ups/Wireframes, business rules, Data mapping, Data analysis, SQL, Functional and Regression testing, JIRA, SharePoint, Project Status reporting.

Business Data Analyst

Confidential

• Enterprise Data warehouse that was capable of integrating data from the primary transaction system, rules engine, entitlement system and all other data sources that WFHM uses. The EDW was meant to provide opportunities for development of data marts that can be tailored for operational and management needs. Essentially, involved in working on MIDE database update for their e-disclosure and e-signature solution implementation. Involved in identification and analyses of Business Data requirements and converting them into conceptual logical data models.
• Created, maintained and updated Data Requirements Document DRD and Metadata repository based on the change requests.
• Identification of data conversion and translation strategies i.e. review, interpretation, and translation of requirements and use cases - Define, maintain and enforce the use of standardized enterprise data element names, abbreviations, definitions, characteristics, and domains.
• Mapping artifacts to a data architecture framework and managing data/message requirements in an Enterprise Application Integration environment.
• Assisted with business naming standards, developing and maintaining consistent data definitions, determining data aliases, documenting standard calculations and derivations, and documenting the business rules of the enterprise.
• Completion of logical data designs/models and then review with Business stewards.
• Conducted walkthroughs with the DBA to convey the changes to be made to the data models. Conducted DRD and FRS reviews and walkthroughs with the designers, developers and testers.
• Provided project estimations, this included review and forecasting of estimations in the data realm.

Sr. Business Analyst

Confidential

• Project: - TAPR Conversation project to Migrate from AMTRUST ATS system to Global Plus SunGard Asset management system. The project essentially involved requirements management. Represented the Asset Receipt Distribution team through the project. Coordinating the development of custom code and in-house built application. Managing the task plans, conversion runbook and Project Scorecards. Performed data analysis, data mapping and custom reporting. Organized the Test coordination and execution of the Test script by the users through the various testing phases. Analyzed research on operational procedures, methods and recommended changes for improvement, with an emphasis on automation and efficiency.
• Worked for the development and testing of workflow management system - Global Office, for the Asset collection workflows in collaboration with the NAO - New Account Onboarding workflows.
• Delegated incoming workflows to the appropriate analysts and audit completed workflows, making sure they stay in compliance with both bank and government regulations.
• Coordinated and managed the development of Genic Interface GI process for automated asset transaction updates to the Asset Management system for Asset receipts, Distributions and Adjustment to Cost Basis information.
• Represented as key resource for the Automated Customer Account Transfer Service ACATS automation set-up from the Work Flow Management system GO and STP settlements of various assets through the depositories - DTC, FED and NSCC Mutual Funds.
• Created report packages for Global Plus Asset Management system for the automated delivery of the reports as per the DTC, FED and NSCC Funds daily settlements.
• Created Master-testing spreadsheets for updating and keeping track of DTC and FED automated settlement process testing from multiple brokers, while considering numerous Trade day and the Settlement day scenarios.
• Created Future state process documentation AS-IS and TO-BE for the Senior Management sign-off and OCC review.
• Analyzed, Designed, tested, documented and maintained customized financial reports created using Congo's reports.
• Coordinated with developer for the development of efficient, effective and long-term customizable application based on the requirements gathered from the stakeholders, which included LOB Business Users, Clients, Junior Analysts and Senior Analysts.
• Conducted Business Reviews, User Interviews, weekly/ Monthly meetings with Business Users and SME's.
• Created comprehensive task plan for the iterative GUAT Global Plus Acceptance testing within the project cycles for the team.
• Performed functional testing of the application and helped the users to do the GUAT Global Plus User Acceptance Testing and logged the defects identified by the Ops Specialist.
• Coordinated the running of scripts in HP Quality center and Application Lifecycle Management ALM through the project life cycle.
• Conducted testing of the automated Asset set-up from Bloomberg through the workflow. Managed the creation of Quick Reference Guides QRG's for the Operations Specialists.
• Trained the users on the G Asset management, Generic interfaces and Global Office GO through the group training sessions, one-to-one sessions and delivery of operational guides.
• Developed and managed the conversion validation plans for the project team to estimate the man-hours required and resources to be allocated for the validation.
• Designed and Created the Access databases for the conversion validation of Reg-Loc/Disposition restrictions and Taxlots managed in the Asset management system.
• Maintained project conversion runbooks, project scorecards, change request/escalation list, defect tracking reports and management reports.
• Updated, tracked and shared task in Sharepoint for the Ops Specialists.
• Compiled weekly reporting for C-level managers and partners on the project health and schedules.

Environment:- BRD and FRS, Gap Analysis, RCA Root cause analysis , Future state documentation, Requirement traceability matrix RTM , Trade and FRD Assets settlement procedure, Asset collection and distribution, QRG's, Congo's reporting, Data mapping, Data analysis, Data analysis, SQL, Functional and Regression testing, HP Quality Center, Application Lifecycle Management ALM , Sharepoint, Change management, Conversion scorecard, Project runbook, Project Status reporting.

Business Analyst

Confidential

• Project1: - Building of automated Generic Interface process for Internal asset transfers for SunGard AMS. Project2: - Multi-currency buy and sell script automation for various trade orders and settlements for In-trader. Project3: - Trade fail reason harmonization.
• Project4: - Enhancement of KYC/BSA Compliance System
• Project5: - Treasury Liquidity reporting platform enhancement.

RESPONSIBILITIES:

• Elicited and gathered user and business requirements through open ended discussions, brainstorming and prototyping
• Reviewed and assessed information gathered, defined key facts and issues, identified potential problems and facilitated problem resolution. Analyzed research on operational procedures and methods and recommended changes for improvement, with an emphasis on automation and efficiency. Performed Requirement, Data analysis and Gap analysis.
• Worked as an liaison between the users and the different teams involved in the application development for better understanding of the business and IT processes.
• Designing, programming, testing, documenting and maintenance of company-wide Vision report modules SunGard Reporting tool and financial reports.
• Participated in report and extract design, database modeling, architecting systems and components. Performed unit and integration testing, and assist in system and user acceptance testing.
• Played a major role in database design with the help of FSD Functional Specification Document and BRD Business Requirements Definition documents.
• Providing project-planning reports, scheduling reports, issues and defect reports to management. Interfaced with the user to gather requirements, assessing the efforts and scheduling the delivery.
• Conducted Business Reviews, User Interviews, weekly/ Monthly meetings with Business Users and SME's Performed System Design, User Interface UI Analysis, GUI Screen Design, and Data Analysis.
• Helped in Data-Mapping of large number of application interactions. Documented the best practices and trained team members on Data Mapping process and tools.
• Followed the UML based methods by using Visio to create Use Cases and Activity Diagrams. Supported Fixed income instruments Treasury Bills, Notes, IPS, Municipal Bonds, CDO, MBS Implement functionality to keep track of cash flows from MBS and calculate performance of the FI.
• Jaspersoft server and Ireports 4.0 architecture implementation. Creating the Executive reports and dashboard for management.
• Delivered production support, monitoring and escalation for the company-wide Intranet Web-application and Web-servers Weblogic, JBoss and Weblogic .
• Involved with knowledge transfer and learning new aspects of the .NET framework by being involved with a wide variety of development activities.
• Developed and maintained QTP scripts for Multi-currency buy and Sell automation Import Excel data and other process automation scripts for web-based application Excel Automation .
• Tested and verified various transaction types across trading, income, corporate actions, sec lending
• Assisted in development of training materials for new technology and process improvements. Coordinated the setting up of test cases with QA team in Global Plus SunGard Asset Management System , for testing the interactions with the peripheral systems like Sec lending application, Securities Income Claim, Middle office reporting, Tax reclaim application and web customer reporting.
• Conducted deployment and testing of MT950 SWIFT format messaging for production enhancement CSDA/ ASDA .
• Functional and Regression Testing of the trade settlement and asset transfer using HP quality center and Bad boy scripts.
• Analyzed the requirements and created Test Strategies and Test plans in Excel to provide a head start to the QA team
• Maintained version control using Urban turtle and TFS Team foundation Server .
• Designed and implemented a production change management process from ground up that was user friendly and addressed all SOX and audit controls using OTRS and Rational ClearQuest.
• Drafted top-level diagrams for the Functional and Physical data view for Global Plus interfaces by data gathering sessions. The project intends to update the SLA's and create a run book for the supporting interfaces. Provided support on technical platforms such as OTRS, Microsoft Access, Excel, Jasper reports, Bancs Corporate Action system and QTP.
• Interfaced with 20 onsite/offshore team members to keep the development process in sync. Provided user training and mentoring other junior business analysts.
• Implemented the bank's design standards and System Development Methodology.
• Assisted in leveraging the best of PMBOK, SDLC, CMMI, ITIL techniques and concepts.

Environment:-SunGard Asset Management, BRD and FRS, Gap Analysis, RCA Root cause analysis , Requirement traceability matrix RTM , Oracle developer tool, MYSQL workbench, MS SQL management studio, TOAD, Data mapping, Xnet trading system, FX desk, Vision, Corporate Actions TCS and XSP , Trade Settlement, Bloomberg, IDC, Telekurs, SWIFT, Functional and Regression testing, Quality center-QTP, Bad boy scripts, Bugzilla, Team foundation server TFS , OTRS, SLA's, Access, Visio, Word, Excel.

Private Equity- Business Analyst

Confidential

The project involved creation of Operating Matrix tracking-MS Access and Web-based extranet system application for the tracking, report generation and client data serving purpose. The automated system addressed all aspects of the lifecycle, starting from identifying the deliverable data to providing fund analysis. Performed Process Audit to provide business with the better understanding of the customer business processes. I also conducted secondary research to develop and provide better understanding of the market and customer needs. Performed financial data analysis, data mapping, data conversion, data auditing and aggregation of funds involved in Alternative Asset Investment

RESPONSIBILITIES:

• Identified, researched, investigated, analyzed, defined and documented business processes, in regards to fund management.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML and Business Process Modeling
• Conducted user interviews, JAD, JAR, RAD, DRP sessions, requirements gathering, analyzing the requirements using Rational Rose while using Agile methodology
• Coordinating with developer for the development of efficient, effective and long-term customizable application based on the requirements gathered from the stakeholders, which included Business Users, Clients, Junior Analysts and Senior Analysts.
• Logical and Physical design of database for projects on basis of user requirements using ERWIN tool.
• Generating Test Cases, Test Procedure and Test Scripts for the Alpha and Beta or User Acceptance Testing UAT of the new Operating Matrix application.
• Research the financial reports for Alternate Investment partnerships of Limited Partner's LP's and General Partner's GP's involved in Private Equity, LBO's, Venture Capital, Growth, real estate, Fund of Funds, mezzanine and distressed investments.
• In-depth analysis of balance sheets, income statements, cash flow statements, statement of schedule, capital call statements, distribution statements to abstract necessary entity performance data more than 180 performance measures and populating fund Excel sheets, for the investment partners keeping in mind US GAAP and IFRS standards.
• Using detailed knowledge of application features and functions assess scope and impact of business needs throughout analysis and completion of all enhancement specifications.
• Preformed data analysis, database design, data mapping, data mining and data gap/anomaly resolution. Operating on Spread sheets to generate pivot tables and charts for trend analysis, industry analysis, yearly investment analysis to provide Benchmarking Services to client investing in PE Private Equity etc.
• Delivering production support, monitoring and escalation manuals for the Intranet Application servers Jboss and Apache Web-App Apache 6.0 .
• Performing VBA coding in Excel to generate macros for the fund invest data gathering spreadsheets used by Analysts.
• Data organizing, cleansing and uploading of the data to Private I Informant for equity clients, to help them get a clear picture of their assets and make better informed decisions.
• Performing audit and QC Quality Control of the data using cross-fund analysis and iterative checks on quarterly basis.
• Performing fund stress-testing using scripts.
• Extensively employed Microsoft office automation tools- Excel, Access, PowerPoint and Project for the facilitation of the project needs.
• Maintaining version control using Urban turtle and TFS Team foundation Server Work with/as the project lead on specific information analysis and aggregation.

Environment:-Private I Informat Fund management system , BRD and FRD, ERWIN tool, JAD, JAR, RAD, DRP sessions, Financial Statement Analysis Balance sheet, Income, Cash flow, Distributions, Contribution , Data Analysis and mapping trend analysis, industry analysis, duration investment analysis MS SQL management studio, TOAD, VBA excel, Application and Web servers, Production support and escalation manuals, Quality control, Team foundation server TFS , UML, Access, Visio, Word, Excel.