Business Analyst Resume Profile
5.00/5 (Submit Your Rating)
OH
IT Professional Summary:
- Highly skilled IT Professional with over nine years of senior level experience with supporting end-user
- application development needs is seeking an opportunity to utilize the full breadth and depth of current
- business and technical abilities. Current and past responsibilities include gathering business
- requirements, system design and development, data modeling, system testing, and technical training.
Professional Strengths:
| Team Collaboration | Technical Training |
| Customer Engagement | Hardware/Software Support |
| Data Scorecard Analysis | Network Help Desk Support |
| Requirements Gathering | Strong Diagnostic Capabilities |
Skill Summary:
- Programming languages: AJAX, Java, JavaScript, J Query, HTML, SQL, PL/SQL, Shell Script, SAS
- Frameworks: DB2, Oracle, UNIX, Linux
- Software: Microsoft Office, Toad, Monarch, Apex, Oracle Forms
Career Accomplishments:
CONFIDENTIAL
Senior Developer, IT Applications
- Partner with the business in preparing custom applications using Oracle Forms.
- Work in an agile environment which includes paired programming, test driven environment, daily stand-ups and open workspace.
- Deliver quality solutions through coding, testing and analyzing.
- Development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions.
- Strong knowledge in Oracle cursor management and exception handling
- Works with the testers to support their testing efforts
- Provides accurate estimates and consistently produces quality deliverables in a timely manner.
- Developed and maintained batch programs using UNIX shell scripting
Results from Nationwide Insurance:
- Update existent Oracle Forms applications to accommodate new products and functionality. This allows business to assist customers with new products the Nationwide has to offer.
- Create new data feeds for the business using Unix Shell Scripting. This allows business to have up to date reports on new products that Nationwide has to offer.
CONFIDENTIAL
Application Developer
- Collaborated with the business units in preparing custom applications using Oracle Apex.
- Developed PL/SQL Procedures, Functions, triggers and Packages and used SQL loader to load data into the database.
- Designed application software systems to meet the departmental business requirements.
- Developed and tested the application software systems using the existing Oracle database framework and extended the functionality of existing applications.
- Designed, analyzed, developed, debugged and unit test code for APEX workflow applications
- Provided training to staff in the maintenance and supported the developed application software systems.
- Gathered requirements for upcoming applications.
- Troubleshoot production issues
- Used Control M for building, changing, scheduling, and monitoring complex batch services
- Tune SQL queries, triggers and Stored Procedures in Oracle
- Address data quality issues work with business partners to build business understanding of data issues.
- Met regularly on a weekly basis with the business units to examine outcomes of tasks outlined in a project plan established by the business.
- Provided periodic and as needed status reports on the progress of application software
- Ability to drive technical direction, assess business requirements, and develop reporting and database specifications.
Results from JP Morgan Chase
- Created a time tracking system using Apex, that enables Team Managers to track actual hours worked compared to time on the dialer. This system allows managers to review and assess resource allocations. The application also allows managers to view real-time work activity. Information is used for scorecard for purposes.
- Developed and maintained an Apex Quality Application which helps Quality analysts track call metrics to ensure that associates are providing excellent customer service over the phone.
- Developed several Apex applications that capture data for scorecard analysis. These applications are critical in helping to determine which associates are eligible for bonuses.
CONFIDENTIAL
Business Analyst
- Used Oracle databases to develop and maintain mortgage delinquency and productivity reports, which the data was pulled from MSP.
- Created VB Script in order to input large amounts of data into MSP.
- Designed custom Collections reports using SQL stored procedures and Microsoft Excel.
- Collaborated with the business units in preparing custom applications using Oracle Apex.
- Designed, analyzed, developed, debugged and unit test code for APEX workflow applications
- Utilized ad hoc query tools and SQL skills on multiple platforms for data analysis.
- Participated in all phases of data warehouse and report development cycle.
- Used data from Microsoft Excel spreadsheet reports to create analysis that were trended over time.
- Worked closely with management and all levels of staff to provide reliable data, reports and analysis upon which decisions were made.
- Migrated data across various database platforms.
- Used SQL to develop and maintain Microsoft Excel spreadsheets that captured collectors' monthly incentive information in a pivot table format.
- Partnered with the business community to identify and document business requirements for data needs.
- Proactively identified processes and procedures within the Collections area that can be streamlined and automated.
Results from Huntington
- Created and maintain reports for the Collections department which gave senior management the opportunity to see a snap shot of the number of delinquent accounts. The reports provided management with a detailed analysis of accounts that allowed them to review and make account charge-off decisions.
- Created productivity reports that compared time worked with the dollars collected. Report allowed managers to rank employee collection rates and determine bonuses.
