SUMMARY

• Over 7 years of experience as aBusiness Analyst and Data analyst with the ability to understand and analyze complex business requirements. Have a detailed and thorough understanding of various domains such as Banking, Financial Services, Cyber Security (Identity Management, Single Sign - on, Encryption, and Risk Management).
• Experience in full Software Development Life Cycle (Waterfall, Agile Scrum, and RUP).
• Extensive knowledge in Requirement Gathering Analysis through user interviews, workshops and existing systems documentation and procedures.
• Excellent facilitation skills and adept at managing the interaction between end-users, stakeholders, developers and testers during the different phases of SDLC.
• Prepared and monitored credit risk reports on a monthly and quarterly basis for $5.3 billion dollar portfolio, substantially improving prior methods by writing advanced macros in Excel to automate and streamline existing processes.
• Proficient in interacting with business users to identify information needs and initiating process changes and creating Use Cases, Use Case Diagrams, Activity Diagrams, based on UML methodology using tools like Rational Rose and MS Visio.
• Experience in conducting Joint Application Development (JAD) sessions for requirements gathering, analysis and design.
• Experience in Data Analysis, Data Profiling, Data Migration and Data Integration.
• Proficient in developing transact-SQL DDL, DML commands including complex queries, views, functions, stored procedures and triggers.
• Extensive experience in developing Stored Procedures, Triggers, Tables, Indexes, SQL joins and statements, Sub queries.
• Experience in using Microsoft Excel features pivot tables, V-lookup, formulas, and filters for data integrity analysis.
• Excellent experience in coding, analyzing and implementingSQLcommands using various relational database management systems (RDBMS).
• Creating Work Breakdown Structures (WBS), Project Schedules and Project Timelines.
• Well versed in documentation of Product Definition Document (PDD), Business Requirements Document (BRD) and System Requirement Specifications (SRS).
• Strong understanding of fundamental business processes, excellent Communication and inter-personal skills with ability to work well in a dynamic team environment.
• Effective Project Scope Change Management and Configuration Change Management.
• Ability to coordinate multiple projects and meet deadlines under pressure in different environments like Agile/Scrum and Waterfall model. Versatile team player with excellent analytical and presentation skills.

TECHNICAL SKILLS

Project Methodologies: Agile SCRUM, Waterfall, RUP.

Business Modeling Tools: MS Visio, MS Project, Rational rose

Defect Tracking Tools: Jira, Bugzilla, SharePoint Defect Tracking Tool, Quality Centre

Operating Systems: Windows 2007, XP, Vista, Windows 7, Windows8, Windows 10.

Databases: MySQL, MS-Access

Business Applications: Microsoft Office Suite, MS Outlook, MS Excel VBA.

Others: Big Data, Web Security, Oracle

Programming Languages: SQL, Python, JAVA, Scala, HTML, XML

CRM Tools: CRM, M-soft

Other Tools: Rational Requisite pro, Clear Quest, SharePoint, Erwin, Balsamiq.

PROFESSIONAL EXPERIENCE

Confidential, San Mateo, CA

Business Analyst / Data Analyst

Responsibilities:

• Worked as an Interface between the users and the development team for better understanding of the business and IT processes.
• Provide technical support for varied technologies, architectures and related projects.
• Collected and documented business processes as well as business rules.
• Wrote stored procedures or functions or packages and call them from Informatica
• Participated in the identification, understanding, and documentation of business requirements, including the applications capable of supporting those requirements.
• Performed continuous process improvement on internal project management methodologies.
• Involved in development of User Requirements Document (URD) and Functional Requirements Document (FRD) using Rational Requisite Pro.
• Reviewed and analyzed the business requirements document to derive the functional specifications document and assisted in the preparation of System Requirement Specifications.
• Facilitated business requirements gathering sessions with the client, and overlooked the creation of Use Cases/Activity Diagrams, Functional Specifications using UML/Visio.
• Applied RUP for software development.
• Participated and facilitated different levels of discussions through JAD sessions, conference calls and business workshops.
• Created, modified and ran reports for external clients usingSQLServer and MySQL and distributed these reports using Microsoft Excel 2013.
• Prepared external clientdatafor initial insertion and inserteddatainto proprietary systems using MicrosoftSQLServer and MySQL
• Facilitated weekly change request meetings and documented changes to be implemented in the project.
• Prepared Business Process Models that included modeling of all the activities of the business from the conceptual to procedural level.
• Check the Informaticamappings, transformations, sessions and workflows inInformatica.
• Conducted UAT (User Acceptance Testing). Provide end user training and extensive go-live assistance.
• Apply technology to business issues to increase revenue, avoid cost, improve service and achieve goals. The Business Systems job family includes all functions supporting applications systems including applications development, business analysis, research and development, and systems integration for business systems.
• Provided solutions to users via phone/email by providing them with shots of the different screens, which helped them in understanding the process at a much faster pace.
• Provide technical analysis and solutions to issues; sets technical direction. Ensure compliance, operational risk controls in accordance with HSBC or regulatory standards and policies; and optimize relations with regulators by addressing any issues.

Environment: RUP, UML with MS Visio, Rational rose, Rational Requisite Pro, HTML, Oracle, Crystal reports, Test Director, Share point.

Confidential, Thousand Oaks, CA

Business Analyst / Data Analyst

Responsibilities:

• Managed business, system, and functional requirements by conducting detailed interviews with business users, stakeholders, and Subject Matter Experts (SME’s).
• Scheduled and facilitated daily stand up meeting at same time and same location each day in accordance with the scrum fundamentals.
• Facilitated the team’s ability to meet team commitment, enables close cooperation across all roles and functions with the goal of removing barriers.
• Conducteddataprofiling and createddataquality rules usingInformaticadataquality (IDQ) tool for analysts.
• Developed and managed the project management plan, established risk management process and metrics for the deliverables.
• Understood the User Requirements and test-objectives to develop Use Case Scenarios, Test plans, Test cases.
• Performed ETLoperations with excel or flat files.
• Overall coordination for a geographically dispersed team working in multiple states.
• Involved in cross-functional, multi-level team focused on improving company-wide internal communication.
• Managed monthly customer satisfaction index reports using Business Objects.
• Delegated and mentored Business Analysts in tasks specifics regarding the project
• Extensively used SQL for accessing and manipulating database systems.
• Created and maintain Application Reports for internal purpose and for business client with the help ofSQLQueries and reporting tool.
• Interacted with the end users in analysis of the test cases and test conditions to create automated test scripts using automated testing tools.
• Ensured delivery of program(s) and project(s) within the portfolio on time, to budget and to highest quality possible.
• Ensured programs and projects are meeting key metrics, budgets, timelines and defined SDLC deliverables
• Effectively incorporated the ETL tool (Informatics) to extract, transfer and load data.
• Used Teradata RDBMS tools (Fast Export) for exporting large quantities of data.
• Conducted weekly status meetings after collecting status of development progress.
• Created and managed data source library-using SharePoint.
• Created wire frames and prototypes for online banking screens using MS Visio.
• Negotiated Triple Constraints wrote RFP and evaluated proposals.

Environment: Rational Rose, CRM, Requisite Pro, MS-Visio, .NET, MS-Excel, MS-Access, Microsoft Project, and Mercury Quality Center, SQL.

Confidential, San Jose

Business Finance Analyst

Responsibilities:

• Analysis of client’s financial documents to provide micro-loan for their businesses
• Review client’s business plan to check Business feasibility.
• Assist client’s in their business plans through help with research and writing,
• Assist client for creating Business Projection and Cash flow.
• Work with all Confidential brands to explore and identify ways to integrate social media into business strategies and marketing campaigns.
• Provide coaching for existing clients in matters like Business Entities, Business Insurance, Business Leasing, etc.
• Tax filing for Low Income Group. (VITA Certification).

Environment: MS Word, MS Excel, MS Power Point.

Confidential

Business Analyst

Responsibilities:

• The SDLC Methodology used in the project was Waterfall Methodology to configure and develop process, standards, and procedures.
• Interviewed Subject Matter experts and carefully recorded theBusinessrequirements in a format that can be reviewed and understood by bothbusinessteam and technical team.
• Prepared Functional Design Specifications employing User Stories,Usecasescenarios, Sequence diagramsand Classdiagrams.
• Maintained the Requirements Traceability Matrix across the deliverables of the project.
• Designed screen mockups and wireframes for mobile applications using MS Visio.
• Implemented change management after analyzing if it was relevant change or a scope creep during the development phase. This included analyzing the impact of the change, getting approval from concerned departments and updating the documents accordingly.
• Wrote automation code with Excel VBA to generate graphical reports like bar chart, pie chart reports for themutualfundportfolio. Created data entry forms and formula for manipulating data fields and data types like numeric, date type etc.
• Assisted the operations and portfolio managers with creating financial models and individual spreadsheets
• Advised the line ofbusinessand management on the development of policy, procedures, systems, controls and training to address the AML and sanctions risks associated with the project.
• Enhanced communications through walkthroughs and defect report meetings periodically and directly interacting with the clients to meetbusinessrequirements.
• Worked extensively on Data-Integration,Data Mapping, DataWarehouse access using SQL, MS Excel
• Worked with QA team to perform different phases of testing as Regression testing, functional testing, UAT testing using Mercury tools such as Test Director and Quick Test Pro.
• Created process and reporting specification templates, training material and slideshow presentations to ensure smooth onboarding process for end user and senior management.

Environment: Windows XP, MS Office Suite, MS Visio QTP, Test Director, Excel VBA COSMOS, CRM, KBOLT.

Confidential

Business Analyst

Responsibilities:

• Worked closely with business team in gathering requirements, showing demos, getting new inputs and managing their needs.
• Agile Development Methodology was followed for the implementation.
• Maintained the requirement traceability matrix(RTM)and ensured that the requirements were consistent after changes.
• Worked closely with the Director for all the future enhancements and workflow changes to be executed in the future.
• Analyzed customer's needs, and determined requirements to anticipate and resolve issues and find solutions by means of automated systems.
• Developed ananalysismodel that includesUseCasediagrams, and Activitydiagramsusing UML methodologies in Rational Rose, which provided the development team a view of the requirements for design and construction phases.
• Conductedgapanalysisfor different product bundles and created reports to track the profitability of differentbusinesslines.
• Supported IT unit for creating functional specification documents for the design, development and implementation of project
• Involved in Data Analysis & Mapping to track all data elements used in the application from the user interface to the target databases in which they are stored.
• Helped facilitate the solution selection in the decision making process and provided the necessary information to enable thebusinessto make an informed decision.
• Managed and maintained all projects artifacts.
• Documented Test Plans that contains test scripts, test cases, test data and expected results for the User Acceptance testing.
• Validating data in different format and preparing layout charts for the data transports.
• Provided reports on the project schedule to the project manager, as well as supported other team members to ensure success

Environment: Windows XP, M-Soft, MS Office Suite, MS Visio, UML, Microsoft Project, SQL, Business Objects.