SUMMARY

• Over 7.6 years of IT, Finance, Software Project Management experience working as Business Analyst/Process Analyst, IT Consultant for very large clients’ viz., Confidential Bank, Confidential Financial, Confidential, Capital Group, Confidential .
• In - depth knowledge and experience in IT, Commercial Banking, Investment Management, HR - Retail and E-Commerce sectors.
• Experience in analyzing company SEC filings, financial reporting and analysis, Budgeting forecasting, building financial models, using valuation methods viz., discounted cash flow, etc.
• Highly experienced in Re-Engineering Procedures, Business Requirement Elicitation, Documentation and Project Management & Change Management
• Excellent experience in acting as a liaison with development teams and translating business requirements to technical specifications
• Proven knowledge of leading development efforts using Waterfall and Scrum/Agile Software Development Lifecycle methodologies
• Expertise in creating UI Mockups, wireframes, ER diagrams, Use Case Models and creating coherent user interfaces to realize business requirements
• Strong experience in GAP and risk analysis, cost-benefit analysis, financial analysis and financial reporting.
• Capable of writing complex SQL queries FACETS support systems.
• Comprehensive experience in creating gap analysis from “As-Is” to “To-Be” process
• Actively involved in developing, executing and managing User Acceptance Testing (UAT)
• Comprehensive experience in writing Unit Test Plans, Test Cases, Integration test scenarios
• Professional expertise in Structured Query Language (SQL) queries, PL/SQL development, VBA
• Highly skilled in using Microsoft Excel data analysis techniques viz., V-Lookup, Pivot Tables, VBA macro development

PROFESSIONAL EXPERIENCE

Confidential, Pittsburg, Pennsylvania

Business Analyst

Responsibilities:

• Identified the key areas of data gathering for the fixed income portfolio of Confidential Bank.
• Responsibilities include identifying, gathering and documenting project requirements into Business Requirement Documents and Functional Requirement Documents
• Worked on several different data source systems like Bloomberg, IBIS, Capital IQ, Economist, Yahoo finance, Zack’s, Morning Star etc., for data assimilation
• Created functional and design specifications for the data assimilation and mining application
• Collaborated with Confidential Bank fixed income portfolio team in fine tuning the data gathering requirements, field identification, data profiling and validation. Documented all the above and presented in weekly milestone meetings
• Worked with DBA group to accurately design the database
• Created pilot dashboard using Excel/VBA and presented to the business team with rapid tuning and enhancement of the dashboard.
• Developed complex SQL queries and stored procedures for created data feed into the dashboard application.
• Responsible for maintaining Project Requirements deliverables and artifacts on project SharePoint site
• Responsible for conducting User Acceptance Testing (UAT) and provide Training as needed.
• Made buy, sell and hold recommendations which led to the generation of 20bps positive alpha.
• Assisted the investment team by conducting credit analysis and VAR analysis on all investment grade debt securities for Confidential Bank’s Fixed Income portfolio

Environment: Java/J2EE, SharePoint, MySQL, Excel, VBA, Balsamic (For wireframe/UI), Apache Tomcat, Eclipse, Windows 7

Confidential, NJ

Business Analyst

Responsibilities:

• Performed critical analysis of GIR data to discover and catalog anomalies, trends and metrics. Also performed validation runs on the identified metrics to ensure relevance of the metrics to the business
• Identified various development areas in the existing data feed infrastructure, new source inclusion, automatic load and extract to database etc.
• Worked with the research analyst team in using R for extracting metrics from financial data.
• Created business use cases and functional requirements documents for the enhancements in data feed jobs.
• Liaised with the user acceptance team for testing new features in workflow systems
• Performed unit and integration testing

Environment: Excel, VBA, Java, Eclipse, R programing language, MySQL, Windows 7

Confidential, San Jose, CA

Business Process Analyst

Responsibilities:

• Generated $250K revenue by planning and implementing new Payment Vendor Partnership Program
• Recommended monetization strategy with revenue generation potential up to $100M per year in Magento appstore
• Interacted with all the stakeholders - PayPal, X.Commerce and vendor teams and created Functional, Design and Architecture specs for the appstore
• Incorporated the requirement of internationalization by working with PayPal managers across the globe
• Handled the functional, technical reviews by the Confidential retail Architecture team ensuring that best practices are followed by the development team
• Coordinated with different country retail service providers/vendors to integrate their services with X.commerce appstore
• Designed and presented the business model & user interface of “ Confidential home furnishing” app in PayPal hackathon

Environment: Oracle 10g, PL/SQL, Excel & VBA, HTML, CSS, Six Sigma, Microsoft Project, Visio, JIRA, Windows 7

Confidential, Irvine, CA

Business Analyst

Responsibilities:

• Worked on several different data source systems like Bloomberg, IBIS, Capital IQ, Economist, Yahoo finance, Zack’s, Morning Star etc., for data assimilation
• Created functional and design specifications for the data assimilation and mining application
• Collaborated with Bank of America fixed income portfolio team in fine tuning the data gathering requirements, field identification, data profiling and validation. Documented all the above and presented in weekly milestone meetings
• Worked with DBA group to accurately design the database & process mapping.
• Created pilot dashboard using Excel/VBA and presented to the business team with rapid tuning and enhancement of the dashboard.
• Developed complex SQL queries and stored procedures for created data feed into the dashboard application
• Worked with the Java development team in converting the pilot application to a full-fledged J2EE application.
• Made buy, sell and hold recommendations which led to the generation of 20bps positive alpha.
• Assisted the investment team by conducting credit analysis and VAR analysis on all investment grade debt securities for Bank of America’s Fixed Income portfolio

Environment: Java/J2EE, MySQL, Excel, VBA, Balsamiq (For wireframe/UI), Apache Tomcat, Eclipse, Windows 7, Linux

Confidential

Systems Analyst

Responsibilities:

• Gathered functional system requirements from process owners and developed functional specifications for application enhancements.
• Worked with development / technical team members to ensure that the enhancements would meet the defined business requirements.
• Conferred with Business Users to Gather Requirements for the design and development teams.
• Involved in exporting data from the database to flat files.
• Facilitated Joint Application Development (JAD) sessions, as well as conducted interviews with appropriate business/technical stakeholders.
• Analyzed Business Requirements to produce System Requirements for the technical team
• Identified and documented UML Use Cases with Use Case diagrams.
• Worked with business users to define Business, Process, and Data Models to understand the overall business.
• Wrote high level and low level system requirements for the project.
• Conducted meeting with the EDI team and other stakeholders team members to discuss the requirements
• Worked closely with the business team, development team and the quality assurance team to ensure that requirements are understood as intended in order to achieve the desired output.
• Facilitated Joint Application Development (JAD) Sessions for communication and managed Net Meetings.
• Analyzed “AS IS” and “TO BE” scenarios, designed new process flows and documented the business process and various business scenarios.
• Wrote use cases and relevant UML diagrams such as Use Cases, Activity and Sequence diagrams
• Participating in all facets of the standard project life cycle and ensured smooth transition of projects to production support
• Maintained clear understanding of project goals by conducting walkthroughs and meetings involving various leads from BA, Development, QA and Technical Support teams.
• Worked with developers to test the iterations of the system under development (SUD) to ensure it met the user’s needs.
• Interacted and assisted the entire team on the testing tools and processes.
• Wrote and executed Test cases for the application when in UAT Environment.
• Involved in evaluation of the user request for new or modified program to determine feasibility, cost and compatibility with current system, and computer capabilities.

Environment: MS Office, Visio, RequisitePro, Quality Center, QDQ (Quality Development tool),MMIS