SUMMARY:

My objective is to continuously deliver valued contributions to an outstanding team and organization. I want to keep challenged, learning and growing in my professional career. I apply a self - accountable work ethic, along with strong analytical skills as a data analyst. I have a responsibility to have an impact, be a great team member, and achieve prominent results for any organization.

SKILL:

• Business Intelligence (Microsoft BI Stack: SSIS,SSRS,SSAS,Power BI)
• Microsoft SQL Server (All Versions)
• Oracle SQL Developer (All Versions)
• Query Language (Non-Vendor Specific)
• Microsoft Excel (Pivot Tables,Functions)
• Knowledge Base Applications (SharePoint, Wiki)
• JIRA/Cherwell (Bug Tracking Applications)
• IBM Tealeaf (Customer Experience Management Tool)
• Symantec NetBackup Administration Console
• BMC Software Control-M / Enterprise Manager (Batch Processing)
• SolarWinds (Network Performance Monitoring Tool)
• IBM iSeries/AS400 systems (Island Pacific,PKMS)
• Splunk (Big Data Analytics Tool)
• NewRelic Application (Performance Monitoring Tool)
• Incident Management
• Strong Communication Skills
• Business Impact Analysis
• Requirement Analysis
• Attention to Detail Oriented
• Problem Analysis and Resolution
• Adaptability/Accountable/Analytical/Flexible

EXPERIENCE:

Confidential, Warrandale, PA

Network Operations Center Analyst/Operator

Responsibilities:

• Monitored critical batch processing jobs and workflows that delivered crucial metrics with reporting of digital and brick and mortar daily sales to stakeholders. Following the Service Level Agreement (SLA) for each individual job. Provided job data and facts on job failures to the on call representative of the cross sectional IT team, to help us triage the job in a timely manner inside Control-M Workload Automation.
• Guided and managed the conversion and migration of existing jobs and schedules into BMC Control-M prior to production turnover with cross sectional teams. Created and tested converted jobs in Control-M development database, submitted by cross sectional teams and made sure the job was ready for production database by their deadline.
• Problem-solved and analyzed issues to commands, schedules, executed and confirmed successful completion of complex adhoc production job requests with cross sectional teams.
• Followed established procedures to ensure that enterprise backups and restores were completed in a timely and efficient manner using Symantec NetBackup. Reported and escalated backup errors and problems to the appropriate support groups.
• Performed iSeries and Teradata tape management daily through third party Disaster Recovery Site Iron Mountain. Also conducted and managed multiple open calls from end users. Providing remote technical support for off hour business times.
• Coordinated and Managed schedule IT outages for the enterprise. Provided periodic updates and notifications of production turnovers status during the outage window to the top hierarchy of the company. Acted as a liaison between the server admins and application validators when patching was performed to make sure applications were accessible after a change event occurred.
• Prepared and maintained documentation for end users for training and knowledge base. Participated in training and cross training for application upgrades and also for new hires.
• Actively oversaw critical applications, server health, network connectivity and environmental conditions inside the Data Center using Solar Winds and Site Scan application. Responded to SNMP Trap alerts with triaging with third party business sponsors to prioritize the incident at hand.

Confidential, Pittsburgh, PA

Systems Analyst- SME

Responsibilities:

• Incident Management - Troubleshooted and resolved web application incidents both external and internal to AEO. Create tickets and stories using JIRA (Bug Tracking Application) for hand off to AEO engineering teams internally.
• Business Impact Analysis - Perform business impact analysis on production issues to measure and accurately set priority and severity for issues to AE.com (Ecommerce Site).
• Collaboration - Work with Quality Assurance teams of AEO and technical business partners to fully understand business needs, set requirements, tested and performed replications steps on any production issue to ensure AEO Digital is fully functional.
• Data - Utilized Tealeaf(CEM Software), Splunk(Big Data Analytics Tool), New Relic(Application Performance Monitoring and Management Tool) and other technical data tools to measure, understand and accurately classify production issues using Query Language.
• Order Processing - Monitored and worked on order processing efforts for the Digital Organization using ATG, CSR, and Sterling applications to ensure orders made it through their operations Omni channel pipeline. Used Oracle SQL Developer to query their database to find missing and stuck orders, that needed reprocessed in a timely manner.
• Documentation - Attended daily standup meetings after production releases to the e Commerce platform (AE.com), to document and call out any issues that the Production Support Team found or got reported externally by a customer. To make sure that this issue was being prioritized by the cross sectional team to triage based off how impactful it was to business.

Confidential, Carnegie, PA

Business Intelligence Consultant/Intern

Responsibilities:

• Contract role helping to build custom data warehousing, reporting, and analytic solutions internally, utilizing the Microsoft Business Intelligence stack (Data Tools).
• Data Management - Created tables, analyzed data, developed procedures, and managed data using Transact-SQL in multiple versions of SQL Server Management Studio.
• Data Warehousing: Develop ETL packages and custom warehouse projects in SSIS based on client business requirements.
• Reporting and Analytics - Learned and practiced analytic modeling and custom reporting using SSRS, SSAS, and PowerBI.

Confidential, Cranberry Twp, PA

Data Analyst

Responsibilities:

• Process, control, and troubleshoot EDI process to ensure efficient day to day operations, and used Pivot Tables to analyze the EDI pipeline for all customers. Passed these reports to PLS management for a proper understanding of organizational needs.
• Review and analyze incoming electronic sales orders for accuracy and ensure prompt delivery of all orders, by verifying automatic process of all inbound and outbound EDI transactions.
• Communicate with trading partners to resolve issues, and retransmit missing documents, to ensure customer's successfully receive resolutions in a timely manner.
• Created and Tested EDI files on their online management tool, and dropped the files in their FTP Directory for further testing for their new EDI solution (IBM Sterling B2Bi).