SUMMARY:

• Over 9+ years of IT experience with 7 + years US based experience as Mid to Senior Business Analyst/ Business System Analyst/ Data Analyst in leading sectors like Financial services, Banking, Investment & Wealth Management, Retirement services, Service provider and Insurance domain. Possess strong experience in capturing/analyzing requirements related to the business processes reengineering, Object - Oriented Design/ Modeling, Service Oriented Architecture, New Development and enhancement of existing application, Legacy platform Conversion, new Database or Data warehouse implementation or Re-structuring and Project Management.
• Exceptional skill set mixtures which includes Business Analysis, Data Analysis, Project artifacts creation skills like Business Requirement Document (BRD), Functional Requirement Documents (FRD),Requirement Traceability Matrix (RTM), User Stories (Define, Grooming ceremonies, prioritization, acceptance criteria, ready to work on, POC acceptance), Planning artifacts(Sprint and Product Backlog), Data Mapping, UX/UI Design, Report Mock up, Application Wireframe and Testing skills like Manual, Automation QA testing (Application, Report and database),User Acceptance Testing (UAT).
• Great working knowledge of Financial regulatory and operational reporting, Financial and Capital Market products, FX rates and transactions, Portfolio Accounting Management including a combination of trading securities such as Fixed Income instruments, various Bonds, Stocks, Mutual Funds, Derivatives products like Swaps, Options, Futures, Forwards FX and other instruments, transfer agency operations and trading life cycle.
• Familiarity with Anti-Money Laundry (AML) process, Know Your Customer( KYC) process/Lifecycle and risk-based capital adequacy under BASEL III framework
• Proficiency for working in traditional Waterfall, Lean Agile (Scrum, Kanban) and Hybrid Approach with hand on experience for Software Development Life Cycle (SDLC) methodology transition for any new project intiative or ongoing project work.
• Excellent working knowledge for Requirement capturing/elicitation by using various techniques like Stakeholder Interviews, JAD Session, Group and individual audio and video Meetings, Requirement workshop, User stories creation and refinement session, agile grooming ceremonies, cross functional team working strategy, process flow diagram and another communication channel
• In Depth understanding of Data Modeling concepts with great working knowledge of Relational and Dimensional data model with conceptual understanding for Star & Snow-Flake Schemas, FACT and Dimensions Tables with Key constraints, Physical and Logical Data Modeling and overall ETL process with the Data flow from source to target and various transformation processes.
• Great working knowledge with various financial reporting related to Operational and Regulatory which include Plan and portfolio investment, transaction and holdings reports, Corporate Action reports, Investment Compliance and Legal reporting, Portfolio Performance while familiarity with Risk management based reporting includes Credit Risk, Market risk, Liquidity, Value at Risk (VaR), stress testing and Regulatory reporting like Comprehensive Capital Analysis and Review ( CCAR ), MiFID II post trading reporting.
• Excellent oral and written communication skill with the great combination of other must have skill set includes business analysis, data analysis, cross-functional team working irrespective of any geographic location constraint, organizational, multi-tasking, Root-cause analysis, problem-solving, interpersonal, relationship building, and management skills.
• Well verse in creating various UML diagrams like Use case diagram, Activity Diagram, Sequence Diagram, Wireframes, prototypes and Screen Mockups .
• Ability to work with cross- functional teams with irrespective of their geographic location to meet project task deadlines on time and ensure to achieve specific project milestone.
• In depth understanding with process of Data Analysis, Data extraction, Transformation and Loading for incoming data from different data source system into Target Data system
• Experience with intermediate to advance level of SQL query analyzing for data analysis, data profiling, and data extraction and validation purpose.
• Very good conceptual understanding for salesforce.com(SFDC) Standard and custom object customization for sales cloud and service cloud implementation, case management and Security model configuration with the role, profile, object level, a record level, page layouts or OWD and workflow, approval, dependencies, data loader, and triggers.
• Ability to design and implement highly effective online marketing programs, outstanding project, excellent ability to identify strategic opportunities and solutions, proactively manage a complex budget, with quarterly roll-ups to ensure spending matches to budget.

TECHNICAL SKILLS:

Software Development Life Cycle(SDLC), Agile(Scrum, Kanban, hybrid), Waterfall, Unified Modeling Language(UML),Joint Application Development(JAD) Sessions, Business Analysis, Data Analysis, CRM, GAP Analysis, Source to target end to end mapping, Data Migration, Data structure analysis and mastering, Data extraction, Data mapping, Data manipulation, Data validation, Dimensional Modeling, relational database, Interpersonal and organizational Skill, Cross-functional team working, Coordinating meetings with off-shore and on-site Module,, BI and Reporting tools like SAP Business Objects XI Infoview, Microstrategy, SSRS, Qliksense, QlikView, Salesforce.com ETL tool like Informatica Power center 9.0, Abinitio, SSIS CRM system like Salespage Financial CRM, Satuit CRM System V12.1,Salesforce.com(SFDC), Project management tool like CA Rally, JIRA, MS Office Suits, HP ALM and other tools like Data Modeling tools like MS Visio and Erwin, Prototyping and wireframe tools for UI/ UX design and screen Mock up, CA Workload Automation, BMC Remedy mid-tier 7.5,Content management system(CMS), Sharepoint 2010 and Database tools and techniques like SQL,PL/SQL, Apex, Visual Force, JavaScript, Data Visualization tool like DBVisualizer, and Database like SQL Server, Oracle 10g, DB2, MS access.

PROFESSIONAL EXPERIENCE:

Confidential, Owings Mill, MD

Sr.Business Analyst/Data Analyst

Responsibilities:

• Responsible for creation of project artifacts as functional requirement document, RTM and user stories.
• Gathered requirements from technical and non-technical users and documented them as per client defined format with necessary level of detail require by development team and testing team to achieve specific project deliverables.
• Performed GAP Analysis to identify missing data elements for each business contexts before initiating on each report re-platforming effort.
• Created data mapping document which contain source to target mapping with other intermediate system connections to load data for ADM with Data Validation before and after Loading.
• Responsible to Analyze complex Sybase Store Procedure for legacy report to extract and document Business rule and Business logic and also responsible to validate them with business users to implement correctly for reporting platform project for each assigned report.
• Performed analysis of Various operational (Transaction and Holdings) and regulatory (DOL, MiFID) requirements and User Requirements: assigned priorities and translated the requirements to Functional Specifications, worked on reports like Open FX Transaction, Corporate actions, Account Trading Activity, Fixed income Securities, Non-Income Producing Securities and derivative transactions.
• Excellent experience for working with cross-functional team during product backlog grooming sessions to refine project high level requirements, roll outs process with deliverables and prioritization of each of them to achieve continuous project development with require MBI achievements.
• Continuous involvement and Interaction with agile project team members via agile ceremonies and extensively worked with cross functional agile team during Sprint Planning, Sprint Reviews, Sprint Retrospectives, and Daily scrum meeting with status updates for each assign task.
• Performed gap analysis on source system data to understand data flow from source to target system.
• Responsible to perform data analysis on source and target system data set to understand re-usability and complexity of multiple business logic across different report to use standardize logic at new BI platform.
• Proficiently helped development teams to break down large user stories for execution with responsible to make sure user story has enough require detail to be marked as done and ready to work on by other team members.
• Performed analysis on legacy document and created specification document with require current state and future state screen mock up for intended solution.

Tools: & Technologies: Eagle PACE, HIQ, HINET, Dimensional and relational database, DBVisualizer, HiNet 7.0, CA Rally, Microstrategy, Qliksense, SAP Business Object, CA Workload Automation, MS Visio 2010,HP ALM, ADM, SQL server 2008,Oracle 11g,Share point 2010

Confidential, Philadelphia, PA

Sr.Business Analyst/ BSA

Responsibilities:

• Identified needs for the project and perform structural analysis on existing structure to implement the reliable solution.
• Responsible for performing a Gap analysis to identify project as-is and to be phased .
• Communicate with geographic distance business users and BI Development team to gather report requirement for reports like Plan Holding, plan total, holding by region, country sector etc using various requirement gathering techniques.
• Extensive experience to communicate with external client to request new additional data elements needed for various business needs/ projects and worked with multiple teams across the organization to successful transmission of data to the client and coordinated with the development team to load them in appropriates database instances.
• Responsible for creating Business Requirement Document (BRD) and Requirement Traceability Matrix (RTM) to bring additional 1600 new data elements with their SOP, Transmission Layouts and FTP server connection detail.
• Extensively worked on creating source to target mapping for the Flat File (Interface file Layouts) to the Operational data store (ODS) and the ODS to the Data Warehouse (DW) and vice versa.
• Performed existing structural analysis for Data Warehouse and provided recommendation to implement changes necessary to improve usability and functionality of Data Warehouse as per successful industrial practice.
• Responsible for gathering requirement and document them in a standard format with approval process followed by Client Lincoln.
• Performed various Requirement gathering, data analysis and data validation for incoming data elements. Also, extensive involvement for database design changes and data loading from initial data source to final target with intermittent ETL process to load appropriate data loading at the right place for the ODS and the Data Warehouse.
• Closely worked with the business team of End users, customers, project stakeholders, program manager, project sponsors and the technical team of application developers, DBA, data and application architect and ETL developers for various project needs and helped them in require documentation, mapping, and clarification.
• Worked as a liaison between different business and technical team to make sure project deliverables will meet on time.
• Hand on experience with Creation of static and dynamic parameterized based reports mock up and require mapping specification for each report to extract correct data from the multiple database and data source .
• Responsible for performing data analysis and data profiling on extracted data from the data warehouse for verification and validation purpose.
• Involved with production support team to resolve an issue related to day to day incoming data loading process and few ongoing data discrepancies.
• Responsible for creating and updating data dictionary for internal users upon each successful release completion.
• Worked with the development team to identify the project issue and escalated the critical issue to the decision-making team to solve the issue on a priority basis .
• Responsible to communicating with the technical team and the off-shore team for project progress, status, any hurdles and co-ordination with UAT testing effort for the newly implemented feature into the application and reported to Project Management committe E-PMO .
• Coordinated with the various onsite cross functional team and openly communicated with them to make sure deliverables are meet on time.

Tools: & Technologies: SAP Business Object Universe, Crystal Reports, XNET, Relational and dimensional Modeling, Database re-architecture, UI/ UX Designing by Wireframe and Screen Mockups, Erwin, MS Visio 2010, HP Quality Center 10.1, JIRA, SQL server 2008, Oracle 11g, Share point 2010, Windows 7/vista, SQL, XML, HTML

Confidential, San Antonio, TX

Business System Analyst/ BA

Responsibilities:

• Responsible for designing new tables which aligns with existing database for marketing users to make certain new data set available in report format for them.
• Extensively worked with sales and marketing users to handle specific request coming from them and analyze them to build the desired solution.
• Performed requirement gathering for the entity and attributes identification for new database designing effort.
• Created Business requirement document and data definition document for a new database design effort.
• Involved in integration of multiple systems in order to receive the data from different marketing system.
• Created ER diagram using Erwin data modeling tool for a new database marketing views.
• Performed analysis on incoming data from the various sources and which utilize by the marketing team to identify specific information related to the product or service sold by the client Confidential .
• Involved for integration effort for transmitting live data feed into the multiple databases in order to make them available for management reporting.
• Experience in communicating with the development team and off-shore team for project progress and UAT testing effort for the newly implemented feature into the application .
• Involve into daily project progress meeting to assist PMO to updates on specific ongoing task progress status and review for any challenges.
• Coordinate with the various onsite cross functional team and openly communicated with them to make sure deliverables are meet on time.

Tools: & Technologies: Dimensional and relational database, Salesforce CRM (SFDC), Proposal Manager, CA Workload Automation, Erwin, MS Visio 2010,HP Quality Center 10.1, Marketo, QlikView, SQL server 2008,Oracle 11g, Core metrics, Share point 2010, Windows 7/vista, SQL, XML,HTML

Confidential, Boston, MA

Business Analyst

Responsibilities:

• Effectively communicate to gather requirements from the business and the technical users to get the desired level of detail for assigned business Process re-engineering, application enhancement and a new client set up projects.
• Interacted with the business users to get a better understanding of critical business processes and gather business requirements and business process Analysis to understand their need for the system .
• Performed GAP analysis as integration effort for legacy business process conversion project.
• Interacted with Scrum project team members via grooming sessions to discuss project roll out process and deliverables listed for sprint and product backlogs.
• Participated in Sprint Planning, Scrums, Sprint Reviews, Sprint Retrospectives, and other agile ceremonies.
• Derived As-Is and To-Be Scenarios and performed Gap Analysis and prepare business process document as per standard documentation process followed by EV.
• Created business process workflow diagram and documented them in detailed as per require.
• Reviewed and execute test cases with detail emphasis on critical business functionality during User acceptance testing and help Senior BA to document them in the desired format.
• Created various user profiles and configured the appropriate access permissions for various application based on the organizational hierarchy requirements.
• Customized application functionality related to sales and marketing users, portfolio managers, Fund accounting users and enabled different layouts suitable for each business users groups based on their job function and access level.
• Performed application support activities to resolve system issue/problems in a timely manner .
• Worked with development group during the technical specifications documentation-answer all questions from the development team relating to the business/functional requirement
• Responsible to review and update project status by conducting meeting with the development team, testing team and business team on an off-shore and on-site basis.

Tools: & Technologies: Salespage Financial System, Satuit CRM System V12.1, CA Workload Automation, BMC Remedy mid-tier 7.5 UI/ UX Designing by Prototype and Wireframes, JIRA, Content Management system, Enterprise Data Manager (EDM), mWholesaler, Oracle 11g, Share point 2010, Windows 7/vista, SQL, XML, HTML

Confidential, Owings Mill, MD

Business Analyst/ SFDC BA/ CRM BA

Responsibilities:

• Responsible for creating the Business/ Functional Requirement Specs, High-Level Design Documents, Detailed Design Documents
• Performed data analysis, data extraction and data migration related task for the particular business unit.
• Created custom fields, Workflows, approval process for Accounts, Contacts, Temporary Contacts, Sales Cycle and Policy in SFDC
• Understanding of business requirement documents and use case diagram of customize SFDC.
• Worked with QA team and UAT users for Preparations of test cases and test execute in various environment with logging detail in Mercury Quality Center (QC).
• Responsible for qualitative Migration of more than 3000 policy holders account for each geographic regions of data verification and validation testing throughout project phases.
• Hand on experience with sales and service cloud functionality implementation to the customized SFDC application.
• Tracking a defect in application and logged them in HP Quality Center (QC) with all detail description
• Responsible for creating various customized Dashboard report for various business and technical users.
• Participated actively in daily project roll out meeting with other project Core business team, IT Local and global team and project rollout team members.
• Performed in requirement analysis, implementation and building of SFDC for particular Operational Entity business requirements.
• Involved in overall project progress meeting with onsite at the client location and remote offshore team irrespective of time zone differences.
• Responsible to create role based and profile based security level access set up for SFDC CRM application.

Tools: & Technologies: MS Visio, SQL, SalesForce.com CRM Application Platform, Apex Language, Visual Force, HTML, CMS, JavaScript, Custom Objects, Tabs, Page Layouts, Workflows, Approval Processes, Email, Messaging, Dashboards, Reports, Sandbox, Production environment.

Confidential, Oklahoma City, OK

Business system analyst

Responsibilities:

• Translates project requirements into project objectives and tasks, managing task assignment to project resources and reporting on and managing project scope throughout the project lifecycle.
• Closely interacted with the Infrastructure team for product evaluations, prototyping, development, and support for reusable components, review on application design and support Integrated Environments, Development and Configuration Management.
• Assisted the PM in setting realistic project expectations and in evaluating the impact of changes in the organization and plans accordingly and conducted the project-related presentations.
• Understanding and analyzing the requirements of Clients to manage Business Process.
• Used Loan IQ to cover the entire Lifecycle of Loan.
• Prepared interview questionnaires for the users and gathered requirements and managed structured requirements.
• Analyzed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• Performed Functional and GUI testing to ensure that the user acceptance criteria are met.
• Assisted in developing the Test Plan, Test Cases, and Test Scenarios to be used in testing based on business requirements, technical specifications, and product knowledge .
• Identified Use cases from the Functional requirements and wrote Use Case Specifications and created business process workflow diagrams (Activity diagrams, Sequence diagrams, Collaboration diagrams) in MS Visio.
• Participated in Business Modeling by understanding the needs of the business, and also documenting Business use cases(initial) as well as System Use cases

Tools: & Technologies: IBM OS/390 Mainframes, DB2, SQL, MS Office, FTP, VSS, XML, Test Director, MS SharePoint, Quick Test Pro, MS Visio, UML Methodology, Java, Oracle 8.

Confidential

Business Analyst

Responsibilities:

• Involved in the requirements and design walkthroughs with designers, developers, and management staff
• Involved in Creation of UML Diagrams including Use Cases Diagrams, Activity Diagrams/Flow Chart Diagrams, and Sequence Diagrams etc .
• Analyzed the business and functional requirements and the master test plan. Created Test Cases for various forms of the application manually. Involved in executing and designing test cases manually. Performed Integration, Functional and Regression Testing of the UAT.
• Involved in various financial calculations and manual validation of the results produced by the application. Involved in booking different types of bonds and calculating the Present values of the bonds.
• Extensively used Test Director Bug Tracker to keep track of bugs. Involved in the submission of bugs through modification reports and frequent review of MR by conducting meetings during the development phase.

Tools: & Technologies: UML Diagram, MS Project, IBM Mainframes, DB2, COBOL, JCL, CICS, Test Director 7.0