Business Data Analyst Resume
St Charles, IllinoiS
TECHNICAL SKILLS
Programming Languages: Java, ASP.NET, and ADO.NET.
Networking: LAN, WAN, OSI, Switch and Router, TCP/IP, DHCP, F5 Load Balancer, DNS.
Operating Systems: Windows, Mac, LINUX, iOS, Android.
Frameworks: BABOK, PMBOK, ITIL, ISO 27001, ISO 27002, COBIT,PCI/DSS.
Software: Microsoft Office (MS Word, Excel, PowerPoint, MS Project, MS Outlook, MS SharePoint), Eclipse, NetBeans, VMware, Virtual Box.
Database Languages: SQL, PL/SQL, T - SQL.
Data Analysis tools: SAS Studio, SPSS, Tableau, MS Access, Power BI, QlikSense, Yellowfin, MicroStrategy, Sisense, Excel, Board, Halo.
Databases: Oracle 12g, SQL Developer, MY SQL, SQL Server, Windows Servers .
Ticketing Tool: osTicket, EasyVista, Jira and Salesforce.
Business Analysis Tools: MS Visio, Rational Rose, Smart Draw, JIRA, Salesforce CRM.
Monitoring Tools: HP Operation Manager, PRTG Network Monitor, Application Manager.
Project Management Tools: Smart sheet, MS project, ProjectManager.com.
PROFESSIONAL EXPERIENCE
Business Data Analyst
Confidential - St Charles, Illinois
Responsibilities:
- Performed data analytics using Excel, Access, and SQL ad hoc queries to develop sophisticated reporting to assist other departments.
- Developed and maintained reporting dashboards to support Order Management requirements using access and SQL queries.
- Developed and Refined SQL queries to extract data from existing databases and to integrate that data with data from other sources.
- Identify opportunities for improvement and increased efficiency and formulate and implement process improvements in consultation with internal team.
- Automated existing business tools to provide a more user-friendly output using VBA, MACROS.
- Analyze and Audit business data for inconsistencies on daily basis to ensure accuracy and relevancy of data output.
- Troubleshoot any issues using logical problem-solving techniques.Performed other project as assigned.
IT Operations Analyst
Confidential - Downers Grove, Illinois
Responsibilities:
- Monitor, Configure, test, and maintain LAN / WAN Network connectivity of over 60 sites across 23 countries across 23 countries.
- Responsible for analyzing and troubleshooting network incidents and service request.
- Implementing IP addressing scheme and keeping IP database up-to-date.
- Maintaining online asset database and updating at regular interval.
- Get involved with skype/ polycom client meetings and internal team meetings.
- Evaluate analytical and systematic problems with work flows and network usage; organize, plan and develop appropriate corrective action.
- Work within the defined Incident, Request, Asset, and Change Management processes.
- Monitoring all network devices and servers through HP operations Manager and NNMI.
Project Data Coordinator
Confidential - Geneva, Illinois
Responsibilities:
- Assisted with data migration from older systems into Salesforce.com. Manage duplicate records.
- Developed reports, dashboards, charts and business processes to continuously monitor data quality, and ensure data security and integrity. Ensuring Data Quality Using Validation Rules
- Project management responsibilities planning, scheduling and organizing project activities.
- Attended client meetings and internal team meetings. Develop a detailed project work breakdown structure and Gnat chart to track progress of project.
- Updated the project plan. Assisted in information collection and validation. Provided input to project research information. Performed risk analyses to identify and resolve critical path issues.
- Used modeling tools to document the current state of business processes as well as future state
- Prepared Project Management documents like project charter, project request for implementation of new BI solution for Global Supply Chain & Manufacturing.
- Scheduling and facilitating meetings with various Business Intelligence vendors to review BI tool. Measure project performance using appropriate systems, tools and techniques.
- Assisted in preparing and maintaining customer reports, project spreadsheets, presentations, and other documentation in a timely and accurate manner.
- Used appropriate verification techniques to manage changes in project scope, schedule and costs.
Business Analyst Intern
Confidential - Atlanta, Georgia
Responsibilities:
- Worked with the Business users and IT teams for elicitation of business requirements.
- Conducted requirement elicitation using interviews, document analysis, requirements workshops, surveys, business process descriptions, use cases, scenarios, business analysis and task and workflow analysis. Communicate and confirmed elicitation results with users.
- Traced, analyzed, prioritized, validated, verified and documented various functional and non-functional of requirements. Create specific business process documentation.
- Attend workshops and document As Is and To Be work process flows.
- Developed user stories in JIRA. Develop simple user or training documentation. Develop use cases to articulate new functional software needs and the roles of each class of application user.
- Maintained business cases, change requests, test plans and issue/action tracking while making recommendations for improvement. Analyze the impact of change requests.
- Perform risk management to identify and minimize project risks.
Network Support Engineer
Confidential
Responsibilities:
- Configuring Cisco routers 1800, 1900 series and catalyst switches (2960).Troubleshooting network failures & routing issues. Monitoring Network of 300 branches of Bank.
- Coordinating with field engineers for new VSAT installation, for router and switch configurations. Communicating project status and escalating issues as needed.
- Provide telephone support related to networking or connectivity issues. Also provided support for computers, printers, and scanner.
- Work independently or with senior team members to support internal and external activities.
- Create or update technical documentation for network installations or changes to existing installations.
- Incident and Project Management.