Business Analyst Intern (sql, Agile) Resume
4.00/5 (Submit Your Rating)
TexaS
SUMMARY:
- Business Analyst with over 4 years of experience in analyzing business operations, specialized in finding patterns, fraudulent activities, campaign analysis, decision making and developing user stories by digging into big, complex data.
- Good at logical and critical thinking analysis - analyst by title and subject matter expert by role, smart & hard worker by nature, flexible & out-going personality with strong technical knowledge from software development background.
- Experience in managing projects using software development lifecycle (SDLC) methodologies such as Agile and waterfalls.
- Flexible working in team and as an individual, handled projects from the scratch, also dealt with live projects in sync with the existing members and implemented enhancements as well. Never ending enthusiasm in learning new tools and technologies made me a quick learner and adaptable to any work environment.
SKILLS:
Programming Languages: C++, Python, Java, Shell scripting, R programming.
Database: RDBMS, MySQL, SQL Server
Development Tools: Eclipse, MS Visual Studio, NetBeans, Tableau, Cloudera
Cloud Platforms: Microsoft Azure, AWS
Operating System: Windows, Linux, CentOS
Methodologies: Agile/Scrum, Waterfall
Servers: Apache, Tomcat
Devops Tools: GIT, JIRA, Jenkins
WORK EXPERIENCE:
Business Analyst Intern (SQL, Agile)
Confidential, Texas
Responsibilities:
- Performing requirements analysis by extracting data and updating data using SQL queries.
- Serving as a liaison between stakeholders and users.
- Allocating resources and maintaining cost efficiency.
- Managing projects, developing project plans and monitoring performance.
- Documenting and communicating the results of the analysis.
- Conducted gap analysis by coming up with As-Is and To-Be process flows on the processes & systems.
- Maintaining repository of suggestions and came up with prospective requirements for the enhancements to be done on the project for the upcoming releases.
Graduate Research Assistant (Java, SQL)
Confidential
Responsibilities:
- Graded programming languages and created grade reports in MS Excel.
- Keystroke Identification application using java to identify an individual based on their keystroke values and calculated distance using algorithms like Scaled Manhattan, Euclidean, Relative and Absolute. Developed UI to give text inputs and to display the identified profiles.
- Developed an application to store projects of every class using SQL Server.
- Tutored Mathematics, C++ and SQL to undergraduates and graduates and held office hours.
Business Integrity Analyst (SQL, Tableau, JIRA)
Confidential
Responsibilities:
- Partner with product and engineering Trans to solve problems at scale. Inform, influence and execute new strategies and tactics for enforcement.
- Identify trends to enhance the support and detection processes and improve team efficiency.
- Coordinated with manager and worked with limited supervision in policy enforcement projects.
- On-boarding gambling partners by coordinating with legal teams across the globe.
- Developing the standard operating procedure to automize the regular patterns and conduct in-depth investigations leveraging volumes of data.
- Worked in 2-week sprints and assisted in managing the resources during development, testing and documented the process and updates of the project as well.
- Created data reports and visualizations in Tableau and forecasted the beneficial project contracts.
- Tracked defects/issues and escalated them from time to time on JIRA.
- Conducted Data Analysis and trend analysis on the customer issues and behavior based on the historical data provided and data extracted from the wall board.
- Worked with Scrum Master and PO in prioritizing the PBI and putting them out to the Scrum teams.
- Captured the business rules and converted them to user stories for the process enhancements.
- Been a part of knowledge capture meetings with the SMEs to extract the knowledge of applications.
Risk Analyst (MS Office, SQL, Agile methodology)
Confidential
Responsibilities:
- Analyses large transactional date, history data and stream data for the knowledge of business development and problem solving.
- Gathered requirements through meetings, surveys and got them approved by the product manager.
- Predict future trends from the current developments in the market and recommend management accordingly to plan the strategies.
- Prepared Business and Functional Requirements Documents (BRDs and FRDs) and Standard Operating Procedure (SOPs)
- Analyze and determine risks in the portfolio decisions, forecasting potential losses.
- Maintained SLA/TAT (service level agreement/turnaround time) within one hour for critical queues. Determine solutions to eliminate the risk and to minimize the baddebts to the organization in the initial stages.
- Trained two batches, submitted reports on assigned tasks to the management using MS Office and SQL.
- Proposed rules to detect fraudulent behavior in the first touch of the investigation which created a huge impact to the organization and the team as well.
- Worked on a Kaizen project to develop changes in tools and monitor implementation of new tools to reduce poor customer experience.
- Been as an SME and worked with other SMEs to take feedback on the gathered requirements and updated them accordingly.
- Utilized Agile/Scrum and PMI methodologies to monitor steer and develop project objectives.
- Wrote and tuned SQL scripts to test the flow of online quotations to the database and verify the data.
- Facilitated User Acceptance Testing with business stakeholders to ensure all requirements have been met.
- Helped Confidential (Customer Support Associate) in addressing the customer requests post deployment.
- Acted as a bridge between account managers, sales and legal team across the countries to acquire required data and regular patterns/ behaviors to improve the client’s performance.