Business Data Analyst Intern Resume
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.
