Senior Business Systems Analyst Resume Profile
VA
Senior IT Professional
Recognized as highly analytical and performance-driven professional with comprehensive experience in leading corporate technology initiatives combined with in-depth knowledge of business and information technology. Possess well-honed expertise in diverse areas encompassing software development, infrastructure design, and production operations. Adept at providing strategic leadership and direction on all aspects of systems development, resulting in effective and efficient system utilization necessary in delivering functional projects. Well-accomplished IT professional equipped with exceptional procedural skills and passion for resolving complex problems through innovative technical solutions. Experienced overseeing and directing junior BSAs t deliver peak performance and achieve overall corporate objectives. Successfully provided strong leadership in managing all resources proficient in full spectrum of project management from initiation t implementation. Exhibit exceptional ability in defining goals and coordinating specific projects aimed at producing beneficial results for the company. Conversant in English, French, and Bambara.
| Areas of Strength |
|
|
|
|
|
|
|
|
|
|
| Technical Summary |
| Languages | C, C , Visual C , Visual Basic 6.0, and VBA |
| Databases and Tools | PL/SQL, SQL, SQL Plus Designer 6i, Developer 2000, Oracle Forms and Reports, Oracle Project Builder SQL Server 2000, DB2, CICS, CHIPS, ITS and Amisys |
| Operating Systems | Macintosh OS, UNIX and Windows, ME, MS-DOS, Requisite Professional Reqpro |
| Software Applications | Microsoft Word, Access, Excel and PowerPoint Microsoft Project and Visio, Test Director, On Demand, Query Analyzer, SQL Reporting services |
| Miscellaneous | LEAD Business Systems Analyst, Project Management, Business Analyst, and Systems Analyst |
| Professional Experience |
CONFIDENTIAL
| Director |
- Planned a tutoring center where children k-12 could refine their skills in Math, Science, Language Arts, and philosophy
- Developed 3 business plans with one obvious solution and tw alternative solutions including:
- Online tutoring center where each child must have his or her own laptop, headphone, and webcam.
- Onsite tutoring center in the West End similar t Kumon
- Consultants training center where they will refresh their skills on Ms Project, Excel, Visi etc
- Conducted a complete feasibility analysis for all three solutions including a complete cost and benefit analysis.
- Guided the development of Hikari online tutoring website with developers in India t develop an integrated website with a database, and a white board.
CONFIDENTIAL
| Senior Business Systems Analyst |
Online Acct Opening Integration Merger Project Acct Mgt Core Services
- Functioned as a key contributor in the Wells Fargo/Wachovia integration project that will address modifications t the Wells East Account Management suite of applications t support the Wells Farg Brokerage Online account opening process.
- The Wells East New Account Opening application will be modified t interface with the Wells Farg Apps2k and CHAMP applications t preserve the WellsTrade automated internet application, account fulfillment, and lead generation processes.
- Delivered a comprehensive Training Plan for our various users t communicate timelines, constraints, resource requirements, and risks that will impact training associated with this project.
- Collaborated with BSG, DFS, and BIT t ensure that Account Services, Contact Center, and Operation Support team members can d their job without disruption on day one of conversion, and provide strong support structure pre and post conversion.
- Contributed t the development of a thorough Business Requirement Document that details the business solution for the OA Integration Merger project including the documentation of customer needs and expectations.
- Worked collaboratively with other BSAs t develop a detailed Functional System Design spanning multiple systems including NAO, Wisdom, Smart Station, Apps2k, HOGAN and BETA.
- Actively participated in the Unit Integration Testing by developing test scenarios, test cases, and test scripts in QC. Manually executed positive and negative GUI, Functional Integration Test, Entitlements Test, and End t End Test.
CONFIDENTIAL
| Senior Business Systems Analyst / Project Manager |
Pyramid Network Strategy
- Functioned as a key contributor in the development of a robust and scalable enterprise technology infrastructure developed a highly efficient IT infrastructure t ensure achievement of Capital One's business objectives and realize future growth plans
- Worked closely with the IT Risk Office, Audit, Quality Assurance, and network engineers t develop Regulatory Requirement for the entire Network Strategy work stream.
- Managed the conversion of 150 federal standards int 150 recommended controls t match COF corporate standards
- Collaborated with ITR and Audit t consolidate the 150 recommended controls int 50 regulatory requirements that were network specific
- Organized the regulatory requirements int subcategories, provided a succinct requirement description, identified the responsible party, and defined the validation process.
- Provided testers with the testability levels and implementation risks associated with each regulatory requirements t facilitate risk based testing
- Uploaded and mapped the regulatory requirements t individual Network Strategy projects in quality center.
- All requirements including BRs, SRs, and RRs were subject t Pyramid approval and change control processes.
Enterprise Online Servicing EOS
- Contributed in all functional areas of EOS phase 1 and 2 for all 12 work streams played a key role in the entire system development life cycle from initiation, analysis, design, development, through implementation
- Completed system requirements from various work streams including Yodlee and Kana response system t create the system requirement specification for each work stream
- Prepared high level design and technical design documents including network diagrams and data flow diagrams produced the traceability matrix from Business Requirements -> System Requirements-> Architecture Decisions -> Design Decision -> Test Cases for all 12 work streams
- Created business case for ECM Infrastructure and developed scope statement as well as project charter for the infrastructure
- Devised a scope statement , project charter, and project management plan t reduce costs and increase revenue growth based on increasing customer self-serving, higher customer retention, platforms consolidation, risks reduction caused by aging systems, and enterprise cross-selling
- Successfully completed the Automated Security Action Plan Questionnaire
CONFIDENTIAL - Radar
- Assisted the head of UK IT Risk, Compliance, and Data Risk Management in leading Ockham and Radar t a successful Alpha Releases.
- Developed project plan and ensured compliance with established criteria and metrics for budgets, resources, and issues management and change control
- Provided primary leadership in overseeing work performance and activities of employees and contractors assigned t projects Ockham and Radar
- Utilized MS Project and created integrated project schedule, WBS, Gantt chart, and Pert diagram organized agenda for client, project team, and design review meetings
- Ensured data compliance by converting IT Risk Office policies int specific standards standards were stored in an excel database and socialize with the designated ITR Point of contact in each work stream
CONFIDENTIAL - Event III
- Worked collaboratively with other BSAs t assist Canada in converting their entire portfoli and enable new booking for balance transfer and credit balance refund requests
- Provided efficient performance in masking Canadian customers' accounts number t non-compliant third party vendors and ensured timely disbursement of BT and CBR within a 2-3 business days timeframe in support of key operational and compliance requirements
- Led testing effort including systems and integration testing for both streams worked closely with third party vendors including FDR, Telpay, and TSYS
- Completed system requirements including FSR and NFSR for PS Payment Disbursement and Electronic Direct Mail eDM generated high level design document for PS Payment Disbursement strategic plan and established constraints
- Identified minute-by-minute schedule recording of all pre implementation and implementation activities and timelines
- Created the Release Management Plan involving personal monitoring plan for each POC at designated control point, a weekly communication plan, and escalation procedure
- CONFIDENTIAL Served as lead BSA / PM and contributed t all functional areas related t technical, operational, and business process implementation
- Played a pivotal role in the deployment of SBL infrastructure, migration weekend activities and post migration system validation created and validated user acceptance test case for SBA and SBIL accounts
- Functioned as SBL Charger point of contact and efficiently handled and resolved post migration issues designated SBL team key roles and coordinated workload throughout the implementation process
- Developed SBL communication plan for communication lead, project manager, and project sponsors defined communication types such as weekly newsletter and status reports t major stakeholders
- Created a mitigation plan for RE-Arm by mapping all SBA accounts in Unisys, Capstone, and Catapult prepared a mitigation plan for 1502 reports while ensuring SBA accounts will cycle on the third of June 2006 as scheduled, and operationally feasible post migration of manual resolution
- Submitted all SBL accounts for pre-and post-financial validation created contingency plan where all business accounts will be retested post migration at PNCCS Bank
- CONFIDENTIAL Efficiently performed various tasks as the Lead BSA/PM in an agile environment oversaw and directed 15 software engineers t ensure technical and business alignment
- Maintained effective working relationships with agile coach, business owner, and fellow team members t coordinate project activities t meet aggressive deadlines
- Conducted numerous customer reviews with technical leads, developers, testers, systems architect, and SME
- Led the negotiation with external vendors including PNCCS Bank and FIRST payment regarding engagement date, resource allocations, systems functionalities, and project cost for SBIL check fulfillment
- Completed thorough business analysis and presented four alternative solutions t cut and print check and letter comb prior t 07 developed matrix comparison of alternative solution, and presented the business with a final recommendation
CONFIDENTIAL
| Senior Business Analyst |
No-Current Pay Lot Option
- Developed The Software Requirements Specification and defined the functional and non-functional product requirements for the Non-Current Pay Lot Option system
- Performed analysis of three main applications including CTS, TCL, and MHFL that housed The Lot Option Program
- Created systems design including High Level Functional Model, High Level Integration Model, and the High Level Process Flow Model with Microsoft Visio
- Provided four alternative solutions t major stakeholders involving a Manual Documentation System-Spreadsheet, an Access Database-MHFLO, an Oracle Database- TCL CTS, and a WEB Application-LAMS
CONFIDENTIAL
| Senior Business Systems Analyst |
Chips LODO
- Coordinated with managers, users, and application developers t develop systems solutions t satisfy business needs for Medicaid and Commercial accounts on CHIPS mainframe negotiated schedule constraint with both business and technical group while ensuring timely resolution of problems
- Prepared and presented detailed requirements definitions and specification for proposed systems created business and system requirements as well as performed process analysis and architecture
- Proactively involved in overall aspects of System Development Life Cycle
- CONFIDENTIAL Developed technical requirements and created plans along with test cases for Amisys in Test Director web-based completed unit testing, regression testing, and user acceptance testing
- CONFIDENTIAL
- Conducted system testing t ensure data integrity of the Amysis Advance project developed radi buttons t perform queries on Amisys
- Compared daily claims receipts for commercial claims, Peninsula Healthkeeper Medicaid, Priority Medicaid, and Central Virginia Medicaid claims through extracted data SAR and Amisys
- Organized Inaccurate Paid Flag Report for both commercial and Medicaid claims conducted RCRS analysis t ensure proper generation of reports through CSA
CONFIDENTIAL
| Product Support Technician |
- Employed proficiency in English and French languages as a bilingual Product Support Technician provided advanced support t various routing applications on Access, Oracle, and SQL Server in a client-server environment
- Administered complex databases containing millions of records and utilized SQL t access customers' database and provided viable solutions t complex technical issues
CONFIDENTIAL
| Systems Analyst |
Equipment Documentation Interface
- Evaluated malfunctioning equipment-documentation process that resulted in loss of productivity through the ineffective utilization of inaccurate, outdated information
- Developed a baseline project plan including organizational environment, scope statement, system description of obvious solution and alternatives, and recommendation t stakeholders
- Executed technical, operational, legal and contractual, political, schedule, and economic feasibility analyses as well as cost / benefit analysis involving extensive ROI and break/even analysis for numerous projects
Sales Tracking Database
- Conducted assessment of outdated database documentation systems and designed centralized database t manage customer and sales information for a major chemical company
- Utilized Oracle Project Builder, SQL, PL/SQL, and SQL Plus that resulted in improvement of overall efficiency of information systems
- Proactively involved in the development of the design, coding, and implementation of a new Oracle Database created tables including Customer, Customer Order, Item, Inventory, and Shipping utilizing knowledge of SQL
CONFIDENTIAL
| Systems Analyst |
- Successfully developed and implemented a user-friendly decision support system in VBA t enable customers t enter a set of search parameters and view information on available vehicles that resulted in significant increase in productivity without relying on workforce expansion
- Completed cost / benefit analysis involving extensive ROI and break / even analysis for multiple projects performed testing and drafted documentation t JTF's technical support staff t implement the new system
