PROFESSIONAL SUMMARY:

• Over 6 years of IT, Finance, Healthcare & Software Project Management experience working as Business Analyst/Process Analyst, IT Consultant
• 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.
• Good knowledge on EDI HIPAA transactions, ANSI X12 data files, Inbound and Outbound 83 Claims, transactions focused on were 270,271, 834, 835, and mainly on 837.
• Capable of writing complex SQL queries FACETS support systems were used to enable inbound/outbound HIPAA EDI transaction in support of HIPAA 834 transactions
• 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

TECHNICAL SKILLS:

Project Management/Software Development & Maintenance: Build and re-engineer procedure and processes Coordination with Customers for requirement analysis, testing Requirement Analysis, Functional/Technical Documentation Effort estimation for enhancement and new development requests Co-ordination with external vendor teams for support requests Day-to-day co-ordination with Customers as functional issues Request/Effort distribution to Team members and project delivery

Business Areas: Finance, HR, Commercial Banking, Investment Management, e-Commerce

Functional Areas/Applications: HR and Finance, Reconciliations, Payroll, Financial Accounting, Travel & Living Finances

Languages, Software and Tools: Concur - Business Travel & Expense Management Tool, PL/SQL querying & stored procedures - SQL Developer, Sharepoint, Toad, Kintana, JIRA project management/defect tracking tools, Microsoft Office, Project, Visio, Excel & VBA development, Balsamiq - UI prototype & wire framing tool

R - Programming language: Agile Software development, Six-Sigma, Kaizen events and Lean process improvement, Supply chain

Operating Systems: Windows 2000/XP/7/8, Unix, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Salt Lake City, UT

Business Analyst

Responsibilities:

• Identified the key areas of data gathering for the fixed income portfolio of Confidential .
• 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 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 Bank of America’s Fixed Income portfolio

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

Confidential, TX

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.
• Validated EDI transaction sets as HIPAA 4010; 837, 835, 270/271
• 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.
• Tested HIPAA EDI Transactions and Code Sets Standards such as 837/835 and 834 transactions.
• 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

Confidential

Business System Analyst

Responsibilities:

• Involved in various meetings with business user and SME to define Business Worked as the communication line in between the technical groups and the business group Strong visual modeling and business process modeling skills in Rational Unified Process (RUP) and Agile Modeling with tools like MS Visio Worked with team leaders and supervisors to ensure project and organizational deadlines are met Coordinated updates with client's staff and implement efficiencies in documentation maintenance.
• Conducted JAD sessions to complete the prerequisite for the Business Requirement Created Use Case, Sequence, Activity and Entity - Relation Diagrams to illustrate for testing effort Responsible for doing the gap analysis for the interfacing system.
• Extensively worked with HIPAA Privacy Facets application groups.
• Documented the Business Requirements Document (BRD) and the Functional Specification Document(FSD).
• For testing purposes, manipulated members information in the QA environment through Facets front-end application Used SQL queries for Data Validation and Verification Resolved/tracked production issues with Reports in Cognos and Mainframe.
• Facilitated requirements gathering activities, including meeting with users to discuss System Task Requests (STRs), Enhancements, and Project Assessment Quotations (PAQs) requirements.
• Conducted requirement feasibility analysis with the developers to ensure the project was in scope with the timeline defined in the project plan Created test plan, test data and conducted manual testing to validate functionality and performed regression testing Documented issues and resolutions, and wrote specific requirements for system changes.

Environment: MMIS,Microsoft Outlook, Share Point, Microsoft Office, Microsoft Visio, Facets and Windows XP Professional