Sr Infrastructure Capacity & Data Reporting Analyst Resume
Chicago, IL
SUMMARY
Highly detailed Big Data & Capacity Analyst with over 9 years experience in planning, analyzing, testing, executing and reporting data with strong analytical, problem - solving, capacity planning, performance testing, reporting, communication and presentation skills. Strategic thinker with the ability to analyze data and create new insights to improve business processes and maximize use of technology. Effective collaborator who builds and maintains relationships across IT and Business areas.
TECHNICAL SKILLS:
SQL, SAS, MS Office suite - Excel (advanced pivot tables, formulas, and charts), Access, PowerPoint, SharePoint. Business intelligence tools - Tableau, Spotfire, Keynote and Business Objects. Software testing solutions - HP Loadrunner, JMeter, Quality Center. Enterprise monitoring solutions - Sitescope, Geneos, TeamQuest.
PROFESSIONAL EXPERIENCE:
Sr Infrastructure Capacity & Data Reporting Analyst
Confidential, Chicago, IL
Responsibilities:
- Developed a robust capacity management plan for HPE’s Digital Safe.
- Collaborated with Deployment team to deploy and configure Sitescope for capacity data collection
- Performed routine trend analysis and capacity-related health checks and activities to ensure capacity thresholds are not breached
- Performed monthly capacity review meetings with senior management
- Developed capacity dashboards and reports with predictive analytics using Tableau
- Collaborated and provided input to the business on infrastructure budget for capacity expansion and Hardware Reshresh .
Data Analyst Lead
Confidential, Chicago, IL
Responsibilities:
- Collaborated with business partners to define, analyze and document reporting needs.
- Collected and maintained marketing and financial data related to clients to be used for benchmarking, performance ranking, monitoring & planning activities.
- Extracted, Cleaned, Validated and Analyzed marketing data from SalesForce using Excel, SAS and Tableau.
- Performed data accuracy, validation and statistical analysis.
- Developed metrics, scorecards, dashboards and key performance indicators (KPIs) for reporting.
- Prepared ad-hoc and scheduled reports.
- Responsible for on-going maintenance of SalesForce production database.
- Assisted the Project Manager in ongoing project initiatives and deliverables from a data analytical perspective.
Capacity Management Lead
Confidential, Chicago, IL
Responsibilities:
- Performed capacity management and monitoring of applications and distributed servers.
- Developed ad-hoc, monthly and quarterly capacity planning reports for the multiple environments and presented reports to senior management.
- Developed strategic capacity plans, conducted trend and root cause analysis, evaluated options and made recommendations for hardware, software and network resources.
- Interpreted data and analyzed results using Excel and Tableau.
- Created custom dashboards and reports for various stakeholders using Tableau
- Maintained the capacity Oracle database that supported analysis and reporting.
- Collaborated with the various Infrastructure teams to ensure appropriate allocation and prioritization of resources to meet the capacity demands, as per the set goals and plans
- Designed and implemented various capacity management models and metrics in respect of demand forecasting and capacity planning (CPU, Memory, Disk)
- Responsible for capacity and performance tuning to ensure the most efficient utilization of existing infrastructure.
Performance Tester/Analyst
Confidential
Responsibilities:
- Planned, created, and executed software test cases and plans for integration, system and regression testing
- Developed automated test scripts for defined scenarios
- Setup all necessary test data for comprehensive testing and performed detailed data verification by comparing data from the source to the destination.
- Executed various tests (baseline, load, endurance, capacity and scalability) for each enterprise release cycle.
- Gathered testing data and performed analysis using Excel.
- Analyzed performance test results and recommended optimizations to hardware/software configurations.
- Identified and logged bugs and maintained all bug tracking metrics
