Vamshi Krishna Kompelli

330-***-****

ac4mij@r.postjobfree.com

Summary:

●4 years of Professional experience as a Business Analyst and Reporting Analyst for enhancing Financial Software Systems.

●Expertise in developing and evaluating Business Process Flow and Gap Analysis using techniques for Process Automation, Improvement and Re-engineering.

●Strong knowledge of financial industry with extensive expertise in Wealth Management, Back Office processes and Investments.

●Possess strong knowledge of the Capital markets and Capital markets instruments such as Equities, Fixed Income, Derivatives and Mutual Funds.

●Proficiency in Trade life cycle, Trade settlement process and Reconciliation. Sound knowledge of Mortgage loan processing Lifecycle.

●Advanced knowledge in Banking, Portfolio management, Financial risk and Compliances issued by Regulatory authorities like FINRA, CCAR, CFPB, OCC, SEC, FRB, CFTC.

●Expertise in dealing with Software Development Life Cycle using the Waterfall Model, Agile Scrum and Hybrid methodologies.

●Skilled ability to elicit, analyze, document and prioritize requirements. Proficient in gathering requirements from stakeholders by conducting various elicitation techniques like Brainstorming, One on One Interviews, Surveys & Questionnaire, Document Analysis and Interface Analysis.

●Excellent in performing Gap analysis to check the compatibility of existing system infrastructure with the new business requirements and proficient in documenting As-Is and To-Be business processes.

●Proficiency in drafting the Business Requirements Documents(BRD), Functional Requirements Documents(FRD), Data Dictionary Documentation, Requirements Traceability Matrix(RTM).

●Proficient in conducting walkthroughs and creating Unified-Modeling language (UML) diagrams for business process modeling like Use Case Diagrams, Sequence Diagrams, State Chart Diagrams, Logical Data Modelling, Activity Diagrams and Class Diagrams.

●Well versed in handling organizational Change Management and conducted assessments in the event of change request effectively performing both Business and Technical impact analysis on the triple constraints of the project, baselining documents endorsed by Change Control Board.

●Functional expertise in crafting Work flow, business process flow, data flow, creating UI mock-ups, and wireframes.

●Possess strong knowledge of C# programming knowledge and .net framework.

●Frequently used DDL, DML in SQL to perform CRUD operations on database including joins.

●Hands-on experience with ER Modelling, Data Modelling, Data Indexing, Data Validation and Data Integration.

●Certified Scrum Master and have proficiency in Scrum framework and can facilitate ceremonies like Sprint Planning, Daily Scrum, Sprint Review, Backlog Grooming & Sprint Retrospective while enforcing timeboxing and maintaining consistency in teams.

●Preparing Test Strategies, Test Scripts and maintaining Defect Logs for defect tracking during the different phases of the STLC process.

●Involved in various kinds of testing including User Acceptance Testing (UAT), Black Box testing, Regression testing, Smoke Test, Sanity Testing, White Box Testing, Stress Testing, System Integration testing (SIT).

●Experience of working with XML, WSDL, SOA and created Web Service Document.

Technical Skills

SDLC Methodologies

Waterfall, Agile Scrum, Scrum-Waterfall hybrid

Requirement Management Tools

JIRA, Rally, SharePoint

Design Tools

MS Visio, Rational Rhapsody

Testing Tools

Jenkins (Continuous Integration), HPQC

Statistical Tools

MS Excel, R-Programming, SAS

Databases

MySQL database, Oracle

Reporting Tools

Tableau

Programming languages

C#, .net, Python

EDUCATION

●Master of Science(MS) in Management Information Systems(MIS) at The University of Akron.

●Post Graduate Diploma in Financial Management from London Management Academy, Hyderabad.

●Bachelors in Technology(B.tech) from Jawaharlal Nehru Technological University (JNTU), Hyderabad.

PROFESSIONAL EXPERENCE

Vuesol Technologies Atlanta, GA

Business Analyst Intern May 2017 – Jan 2018

Description:

Vuesol delivers applications and infrastructure fundamentally designed for mobile users, empowering your company with the ability to interact and perform business communications and transactions across a variety of devices and platforms, delivering a more convenient and elegant user experience.

The objective of the project is to build a system which provides alerts to the customers about the actions which were performed and alerts about the activities which needs actions to be performed for a local bank.

Responsibilities:

●Extensively worked in Water Scrum Fall methodology which is a hybrid model of Scrum and Waterfall methodologies within Mobile/Tablet/Mobile Web application ecosystem.

●Conducted requirement walk-throughs with key stakeholders using various methods like team demos, workshops during sprint planning and backlog refinement sessions.

●Assisted Project Manager in creating Project deliverables, KPI’s, Milestones, Resource Estimation and Work Breakdown Structure using MS Project.

●Worked closely with the Android and iOS development teams and acted as the go to person regarding the banking compliances.

●Helped in breaking down the BRD into user stories by conducting workshops with the team and defined the acceptance criteria for the user stories and creation of the product backlog on issue tracking tool JIRA.

●Drafted Use case documents for all the functionalities and developed Use case diagrams and got it reviewed.

●Helped the Product Owner in prioritizing the ad hoc releases by conducting Business impact analysis and Technical impact analysis of the release on the system and to know whether it has any dependencies.

●Used Test Driven Development (TDD) and Acceptance Test Driven Development (ATDD) technique for building the components and used Jenkins for Continuous integration.

●Assisted the Scrum Master in facilitating the Daily Scrum, Sprint Planning, Sprint grooming, Sprint Review and Retrospective meetings.

●Prepared Requirement Traceability Matrix (RTM) report to ensure that every Business requirement is adhered to achieve the expected performance.

●Wrote Test Cases and developed strategies with Quality Assurance group to implement them.

●Involved with the Software Quality Assurance (SQA) Team to develop Test plans, execution of Test Cases and logged the defects for failed test cases and assisted in User Acceptance Testing.

Environment: Agile/Water-Scrum-fall Hybrid, SQL, MS-Visio, MS Office suite, JIRA, Process Improvement, Data Mapping

FactSet Systems India Pvt. Ltd Hyderabad, India

Business Analyst/Research Analyst Jan 2014 – Nov 2015

Description:

The scope of the project is to build a Mutual Fund processing system to automate the method of processing the mutual funds to reduce the lead time and increase the efficiency of the process. As a Business Research Analyst, I was responsible for gathering the functional and nonfunctional requirements from the business users and create Functional Requirements Documents.

Responsibilities:

●Gathering requirements from the business users using various elicitation techniques such as Interviewing, Brainstorming and Focus groups.

●Created Business Requirement Documents(BRD) and Functional Requirements Documents(FRD) capturing all the functional and the non-functional requirements.

●Created prototypes using mockup screens to explain the UI of the functionality.

●Aided the developers by providing them with the documentation of the entire process and acted as the SME.

●Handled changes efficiently by conducting Business Impact Analysis and Technical Impact Analysis. Managed scope and implemented the changes after base-lining the requirements

●Wrote the Test cases in an end user’s perspective and was also involved in Alpha testing to verify the system has all the functionalities.

Operational Responsibilities

●Primary workflow involves checking the accuracy of the portfolio of holdings with internally prescribed parameters & updating the processed Mutual funds to the database.

●Review, interpret and input complex quantitative regulated information contained in various sources including Securities and Exchange Commission filings.

●Dealing with the portfolio of holdings which comprise of Equity, Fixed Income and Derivative securities and segregating securities as per their asset classes.

●Verified Corporate Actions such as Stock Split, Spin-off for huge price variances.

●Exploring data from BLOOMBERG, THOMSON REUTERS, Securities Exchange Commission & SEDAR.

●Comparing the Mutual Funds Monthly, Quarterly, Semi-Annual and Annual performances based on the Total Assets, rate of return, risk, asset class and the value of uninvested funds.

●Providing complete details of the fund such as Investment Objective, recent NAV and rate of allocation of Total Assets to different asset classes.

●Maintaining of Portfolio Manager Tenure Project to give the accurate date of Managers managing the Mutual fund.

Environment: Waterfall, MS Office Suite, MS Visio, RDBMS

Arkin Software Technologies, India Hyderabad, India

Reporting Analyst Aug 2012 – May 2014

Responsibilities:

●Served as the primary point of contact with the client, performed requirements gathering and analysis to eliminate redundancy.

●Developed reports and visualizations using SSRS and Tableau that assisted in making key business decisions.

●Collaborated with several business stakeholders to define data and reporting requirements for the technical implementation.

●Utilized SQL to fulfill ad-hoc data procurement requests in a timely manner to accelerate seamless delivery of results to the client.

●Automated the ETL of data from different data sources to a data warehouse which optimized the output efficiency manifold.

●Employed SQL Profiler to analyze & capture the stored procedures under different GUIs reducing the defect rate.

Environment: SQL, MS Office Suite, Tableau, Data warehousing

Academic Projects at The University of Akron

OGON Lighting company – A report on the Pricing strategy of the company.

●A report on the pricing strategy of OGON lighting company which would save one million dollars with the standardized pricing strategy.

●Generated Dashboards of Box and Whisker charts representing the discounts offered to various customers.

●Suggested that the company would save One million dollars with an invariable discounting strategy.

Good Year – Analysis of the performance in different tire categories.

●Used Tableau for MS Access dataset of half a million records to generate visualizations.

●Generated Visualizations using Level of Detail and developed Waterfall charts.

●Identified the low performing categories and the reasons for it.

●Suggested the best possible solutions to overcome the situation.

North East Ohio Real estate market data

●A report on North East Ohio’s Real estate data to suggest the suitable house for a couple.

●Used SAS JMP tool to find the outliers and inconsistent data and to perform data cleansing.

●Applied exploratory data analysis techniques to understand and summarize data of house prices across the cities of North East Ohio.

●Performed correlation analyses to recognize the relationships among the variables and constructed linear regression model to estimate the variations in prices based on influential variables.

●Created K-Means clustering model to categorize the cities into ‘Rich’, ‘Affordable’ and ‘Cheaper’ categories based on affordability of houses from the dataset.

Contact this candidate