We provide IT Staff Augmentation Services!

Business Data Analyst Intern Resume

4.00/5 (Submit Your Rating)

Fort-worth, TX

SUMMARY:

  • Business analyst with over 5 years of experience delivering cost effective, high performance technology solutions to meet challenging business demands.
  • M.S graduate specializing in business analytics.
  • Possess in - depth knowledge and interest towards business analysis, data analysis, business intelligence, database systems and big data systems.

SKILL:

Languages: Python, R, Spark, PL/SQL, C, C++, HTML, VB Scripting.

Statistical Packages: Minitab, SAS, SPSS, STATA.

Databases: Oracle, SQL, MSSQL, Mongo DB, MS Access, SAP DW.

Packages: MS Excel, MS Visio, MS PowerPoint, VBA, Tableau, MS Project, SQL Developer, Service Now, SCCM, MDT, Power-Bi, Crystal Reports, SAP for advanced excel analysis, Statistical data analysis, SharePoint server, Salesforce.

Other Skills: Agile project management, SDLC, UML, Process mapping, GAP Analysis, Capacity Planning, Google Cloud Monitoring, Google Apps Support, Qlik View, Google Analytics, WEKA, Confluence, SLA.

EXPERIENCE:

Business Data Analyst Intern

Confidential, Fort-worth, TX

Responsibilities:

  • Migrated Confidential to ServiceNow tool and helped team to manage all projects in ServiceNow.
  • Developed report leveraging data from ServiceNow Incident, change & service request fields to determine project resource availability and automated resource management.
  • Created a new project change management process using process flows, swim lanes and PMBOK guidelines for process improvements.
  • Analyzed metrics, created, automated and published dashboards for various Confidential reports & KPI’s in tableau and ServiceNow.
  • Designed, prepared and automated (daily, weekly, monthly) project status report and project tracker reports in service now that helped reduce manual effort by 30%.
  • Participated in sprint planning, daily scrum-stand Up, sprint retrospective meetings and grooming of project backlog stories with business and technology partners.
  • Assisted Confidential team in entering and updating Issues (Epics, Stories, and Tasks) into JIRA Agile application.

Business Systems Analyst Intern

Confidential, Arlington, TX

Responsibilities:

  • Used various stock and Inventory management tools for updating and maintaining the stocks.
  • Queried the MS SQL software to retrieve information on total number of stocks available.
  • Assisted the Bookstore Team in setting up a new software system that triggers alert when an item stock out.
  • Managed security levels and Created 100 plus reports using Macros VB, Microsoft Access and Crystal.
  • Directed biweekly forms update meeting, created reports, provided follow-up on outstanding requests.
  • Generated monthly and ad-hoc reports using Business Objects to ensure compliance with company’s regulations.

Business Analyst

Confidential

Responsibilities:

  • Analyzed business and planned Google migration project which helped entire project to migrate from legacy to cloud environment that enabled business to save USD 3 million spend on infrastructure maintenance cost.
  • Headed the team involved in migration activity and acted as SPOC between google teams and migration team.
  • Mentored a team of ten junior engineers and made them business ready for subsequent migration activities.
  • Interfaced with business users to develop business requirements document (BRD), Technical documentation, Functional documentation, Non- functional documentation, UML, Gap Analysis and managed the entire software development cycle for software development projects till UAT.
  • Generated use cases, activity, sequence diagrams and logical views using MS Visio to provide clear concept of the requirements to the development team.
  • Reviewed business requirements, IT design documents and prepared test Plans which involved various Test Cases for all assigned module/projects.
  • Effectively managed the off-shore team and provided weekly status updates showing the progress of the automation testing effort and open issues to be resolved.

Capacity Data Analyst

Confidential

Responsibilities:

  • Used Microsoft Excel to generate server utilization reports.
  • Executed complex SQL queries to fetch historical capacity data and did analysis for capacity planning.
  • Designed and built capacity management models and metrics for demand forecasting and capacity planning.
  • Produced capacity health report for entire IT infrastructure which enabled smooth Christmas sales.
  • Analyzed, Developed and maintained Capacity Planning dashboard that sends automatic alerts.
  • Verified and validated the deliverables for meeting the customer requirement specifications for capacity planning.

We'd love your feedback!