Lead Data Analyst Resume
Bloomington, IllinoiS
SUMMARY:
Results - driven Information Technology Analyst with proven success in leadership, test environment analysis, problem resolution and root cause analysis. Excels in understanding of computing architectures, strategies, and integration technologies.
AREAS OF EXPERTISE:
- Data Integrity
- Cost Benefits Analysis
- Software Testing
- Customer Focused
- Analytical Thinking
- Tool Administrator
- Software Development Life Cycle
- Requirements & Traceability
- Team Leader
- Resource Allocations
- Metrics & Reporting
- Software Quality Assurance
TECHNICAL PROFICIENCIES:
Platforms : Windows 9x/NT/2000/XP,7,10, ZOS, IMS Transa ction Manager (DC), Unix, Linux, Hadoop, Android, IOS, HDFS, DB2, PostgreSQL, Private Cloud
Language s: Batch file Scripting, Rexx, SQL, ISPF D ialog Man ager, JCL, Cobol, PL/I
Computer Software and Tools: SPUFI, ISPF, DB2 Expert, IMS expert, BMC Apptune, BMC Catalog Manager, Silk Test, Silk Performer, QALoad, QARun, Hiperstation, Rat ional DOORS, EJES, S AVRS, Control M, Lotus/IBM Notes, WinSCP, Microsoft Office Suite, (Word, Excel, PowerPoint, Publisher, Access, Project, Outlook), SharePoint, PgAdmin, Hbase, HIVE, Test Link, Trac, HP Service Manager, RMS, Jenkins, Putty
PROFESSIONAL EXPERIENCE:
Confidential, Bloomington, Illinois
Lead Data Analyst
Responsibilities:
- Managed group of 8 Infrastructure Analysts. Defined team and data movement strategy.
- Managed the implementation of yearly team goals.
- Worked with various IT Security teams to ensure each member of our team had the proper rights to perform their duties.
- Gathered metrics, and generated reports on team performance for management review.
- Created bi-annual team barometer report for management. Coordinated and socialized team responsibilities and assignments within the enterprise.
- Maintained agreements and communication regarding service level objectives and dependency agreements.
- Ensured proper documentation was in place relating to training and lesson learned documents. Led bi-weekly huddle with team and management.
- Initiated a new process to implement Agile backlog framework to ensure greater accountability for annual service team goals. Agile has now been rolled out as a best practice enterprise wide.
- Created monthly reports using HP Service Manager to identify & track work flow trends to provide management with knowledge to better utilize resources and influencing decisions around forecasting and budgets.
- Performed ongoing audits of team’s security access across the multiple platforms and systems utilized to ensure security compliance.
- Provided work around to data validation process using SQL that mitigates risk to enable system loads to complete in a timely manner.
- Performed scheduling, planning and executed team related activities on simprod system. This enabled a new process of loading scrubbed data to be completed on time. Recognized with System Achievement Award for outstanding effort for keeping the effort on schedule.
Technical Analyst
Confidential
Responsibilities:
- Provided mainframe testing tool support for in house testing tool products. Support selective data reset process using IBM OPTIM tool. Perform routine tool maintenance as required based on system changes as well as business partner specifications.
- Performed acceptance testing for required changes.
- Successfully created reset process in JCL using the IBM OPTIM tool. This resulted in the ability to restore complex data using mapped relationships.
- Ultimately this allowed Database designers freedom from test reset constraints when designing shared datastores.
- This simplified code, simplified data designs, and reduced complexity.
- Added functionality to in house tool to use BMC image copies for DB2 database backups.
- This resulted in the ability for faster and easier backups and restores for D B2 databases using BLOB’s, CLOB’s, and XML data.
Test Analyst Environment - Test Lead
Confidential
Responsibilities:
- Performed system testing activities for software quality assurance to test data transformations.
- Led system testing for cloud based data aggregation services.
- Created test cases based off high level requirements and other negative testing scenarios using the Test Link requirements tool.
- Executed test cases, track ed test data through Hadoop test systems using HDFS, Hive, Hbase, XML, JSON, and PostgreSQL.
- Documented and presented results ensuring software met the appropriate quality standards.
- Recorded project defects and created technical documentation as needed using the Trac tool.
- Additionally created Test Plans, Test Strategy, and Test Summary reports.
- Key member of cross functional project team to coordinate extensive testing with Android mobile app using Bluetooth. Worked with Android testing team to manually test the Android mobile app.
- Successfully led system testing of cloud based data aggregation services allowing project to be delivered on time and on budget. Recognized with System Achievement Award for outstanding effort .
Test Analyst Environment
Confidential
Responsibilities:
- Representative for host based system testing on project teams. Collaborated with teams to understand business and environment requirements and effectively planned and supported testing activities.
- Troubleshot and debugged test environment defects and assisted the Software Development team with defect analysis.
- Communicated test environment failures and downtimes. Designed and provisioned test environments.
- Created topology diagrams, performed test environment planning and setup as well as test environment configuration management.
- Performed environment shakedown that ensured stable test environments prior to project testing.
- Using trend analysis o f defects logged, created automated solutions or changed testing procedures to reduce defect counts, and enabled more stable test environments.
- Instrumental in supporting test environments which aided in the implementation of an automobile VIN inquiry system used by the Department of Motor Vehicles in several states.
- Performed, documented and presented cost benefit analysis to influence change to the environment shakedown process and reduce storage cost.
- Created and Implemented several automated processes using Rexx code, and JCL.
Technical Analyst
Confidential
Responsibilities:
- Liaison between internal business partners and product vendors.
- Administrator and support for automated testing tools.
- Audited user accounts by working with team leads to ensure proper access was given to team members.
- Maintained license server, applied product related patches, and zap updates.
- Collaborated with issuance deployment teams to enable the delivery of automated test tools with proper configuration to enterprise workstations.
- Validated all automated product installs and un-installs to ensure workstation stability.
- Handled vendor related agreements for licensing and purchasing of automated testing tools.
- Spearheaded creation of Windows OU Security Groups to allow users access without administrator rights.
- Supported ongoing daily operations of testing tools and ensured proper configuration .
Mainframe Developer
Confidential
Responsibilities:
- Created and supported enterprise-wide in-house mainframe tools to meet business partner requirements.
- Designed and developed tools using various technologies including PL/I, Rexx, JCL, SQL, ISPF skeletons, DMS tables, and panels.
- Serviced, and supported customer needs, and met end users service level agreements (SLA).
- Created Host based report generating tools for IMS online systems using DB2 and tied it to MS Access using ODBC.
- Created ISPF panel driven tool for process improvement to aid in testing for the life insurance line of business. Tool replaced manual process, reducing defect s, improving efficiency, and stability of test systems.
