Resume
3.00/5 (Submit Your Rating)
Business Analyst Senior Atlanta, GeorgiA
SUMMARY
- Business Analyst professional with expertise in data analysis, reporting and project management.
- Known for an ability to conduct complex data analysis and design customized, user - friendly business and reporting solutions.
- Advanced level of knowledge in Excel and script writing. Project manager experienced in evaluating new technologies, playing a key role in software implementation/planning and ensuring successful project execution.
- An effective business partner with a track record of quickly learning new technologies and adapting to changing environments.
- Direct all aspects of acquisitions and existing credit card member portfolio management, affirmed as the Subject Matter Expert (SME) on credit bureau data stream processes, to include company's monthly refresh process, and Confidential, Confidential, Confidential, and Confidential procedural requirements.
- Project manager coordinating the execution and delivery of credit bureau deliverables for ongoing Single Stream marketing campaigns.
- Project manager and liaison between technical services and various client groups (both internal and external) for electronic data transmissions.
- Managed the SFTP, FTP and Connect Direct setup process with large customers such as Confidential, BB&T and SunTrust. Reviewed, created and approved Change Management requests using Maximo.
- Maintained weekly and monthly Excel reports informing senior leadership of electronic data transmission statistics.
TECHNICAL SKILLS
Office Programs: Microsoft (Word, Excel, PowerPoint, Access, Outlook, Visio), Lotus Notes
Languages: Python, JAVA, HTML, SAS, ASP, SQL, Visual Basic
Protocols: FTP, SFTP
Database Tools: Oracle Developer Suite (Report Builder, Designer), Oracle Enterprise Manager
Reporting Tools: Crystal Reports
PROFESSIONAL EXPERIENCE
Confidential, Atlanta, Georgia
Business Analyst Senior
Responsibilities:
- Direct all aspects of acquisitions and existing credit card member portfolio management, affirmed as the Subject Matter Expert (SME) on credit bureau data stream processes, to include company's monthly refresh process, and Confidential, Confidential, Confidential, and Confidential procedural requirements.
- Project manager coordinating the execution and delivery of credit bureau deliverables for ongoing Single Stream marketing campaigns.
- Review all campaign materials to identify and resolve any discrepancies in the data sent and received.
- Assist downstream users with inquiries regarding the details of credit bureau attributes.
- Analyzed attribute re-engineering to ensure the business is receiving the highest quality credit bureau data.
- Manage the end-to-end execution and weekly delivery of multiple Triggers projects.
- Designed and coded a process to cross analyze more than a thousand attributes using Python, between the three credit bureaus to identify and investigate those that fall outside of tolerance on a monthly basis.
Confidential, Alpharetta, Georgia
IT Project Manager
Responsibilities:
- Project manager and liaison between technical services and various client groups (both internal and external) for electronic data transmissions.
- Managed the SFTP, FTP and Connect Direct setup process with large customers such as Confidential, BB&T and SunTrust. Reviewed, created and approved Change Management requests using Maximo.
- Maintained weekly and monthly Excel reports informing senior leadership of electronic data transmission statistics.
- Led conference calls for SFTP, FTP or Connect Direct projects.
- Designed user-friendly business resources (The Center of Excellence) for the Global Platform Services Division to enable any internal employee to effectively create an electronic transfer of data inside or outside the organization.
- These easily accessible resources ensured compliance with company and regulatory guidelines for privacy protection and security, effectively mitigating company risk.
- As SME, provided internal Change Management process and Maximo training to ensure compliance with company guidelines around the change management control process.
- Ensured maximum system performance by updating/upgrading electronic data transmission software and licenses.
- Resolved electronic data transmission problems to ensure business continuity.
Technical Customer Support Analyst
Responsibilities:
- Maintained the Authentication Database using Microsoft Access and Oracle SQL*Plus 8.0. Researched and corrected transactions that were suspended due to errors or invalid data.
- Created Excel reports daily for Confidential Daily Status and Daily Balancing. Updated monthly Excel reports for the Technology and Finance groups.
- Automated manual process for updating pricing. Created scripts using Visual Basic coding to perform massive pricing updates for increased efficiency, saving 500 man hours with each update. Achieved 100% accuracy of data input, significantly improving the accuracy rate of previous manual entries.
- Researched issues with customer invoices to identify revenue not posting properly. This ensured accuracy of general ledger data and recovery of potential unclaimed revenue.
Production Project Manager
Responsibilities:
- Responded to customer requests for complex ad hoc and customized reporting and data requests.
- Managed 4 to 7 weekly projects that queried up to 200 million records.
- Analyzed new projects to ensure proper set up through the EPSS software.
- Set up processes for each project and performed quality control checks.
- Ran project status reports and updated project information in an Oracle database. Modified existing JCL or SAS code.
- Partnered with large national banks (like Confidential and Confidential ) to extract current credit reporting data for making strategic business decisions such as credit card/loan offers and customer reviews.
- Customized data views in line with customer requests.
- Created flow charts to run each project with greater efficiency enabling customers to have accurate timelines for project completion.
- Ensured accuracy by establishing process for data validation prior to running projects.
- Reviewed co-worker’s processes before they were run and performed final quality checks on projects before customer receipt.
Confidential, Atlanta, GA
Staff Accountant
Responsibilities:
- Reviewed and reconciled general ledger accounts. Performed the duties of a Billing Administrator for over 500 customers.
- Created BPCS queries to aid in researching customer accounts.
- Performed analysis to identify program logic errors related to invoicing in the BPCS software.
- Audited customer rebates of up to $130,000 per month to ensure accuracy.
- Through reconciliation, recovered a $200,000 outage in the cash lockbox account.