Sr. Business System Analyst Resume
PA
SUMMARY
- Around 20 years of professional experience in Information Systems, Finance operations, Policy & Procedure development, Statutory/Tax audits, ERP system implementations and Project Management
- An experienced Project Manager, Financial Consultant, Business Systems Analyst and developer with combination of functional and technical knowledge
- Good understanding of information systems, web - based systems, ERP Systems and their relationship to business functions.
- Professional experience encompasses complete Life-Cycle implementations, in scoping, strategic planning, project management, business requirements, gap analysis, solution design, systems configuration, methodology deployment, delivery of numerous training programs, roll-out of production systems and post-implementation support.
- Led successful large global teams through complex program and project tasks. Project Management focus areas include project planning, financial management, staffing, communication and scope management. Delivery-focused and able to motivate teams.
- Hands on experience in project reports, documentation that includes requirement specifications, design process, testing efforts, data mapping, ETL execution plan, test cases and test scripts on varying size projects
- Good knowledge in Projects Preparations including BR30 (Business Requirements), MD50 (Functional Design), MD80 (Technical specifications), CV40 (Conversion mapping) & WBS (Work Break-down Structure)
- Experience in preparation and maintaining project schedules and regularly communicate project status to key stakeholders
- Experience in IT Vendor Management
- Has an extensive background in business processes and process re-engineering
- Ability to engage in multiple initiatives simultaneously and work independently with users to define concepts.
- Good knowledge in analysis and creation of Logical and Physical Data Models
- Excellent Knowledge in SOX and ISO procedures
- Good Knowledge in Best Practices, Standards, AIM, Waterfall & Agile Methodologies, and Mercury Tools in system design, development and deployment
- Has excellent interpersonal skills
- Ability to lead the team and work individually
TECHNICAL SKILLS
ERP: SAP R/3 & R/4 - Accounts Receivables, Accounts Payables, General Ledger, Cash Management modules & CRM. Oracle Financials - Versions 10.6, 10.7, and 11.x, Account Receivables, Account Payables, General Ledger, Purchasing, Order Entry, Cash Management modules.
GroupWare: Lotus Notes & Lotus Domino
Languages: C, JAVA, Lotus Script, HTML, XML, Java Script, VB Script, SQL, PL/SQL
RDBMS: MS-Access, Oracle
Other Tools: MS-Office, MS-Project, Visio, Team Studio Analyzer, AJAX, Dojo, Quality Center, PPM, Starteam, Adobe PhotoShop, SnagIT.
Environment: s: Unix, Windows 95/98/2000, Windows NT, Windows XP, Windows Vista, Windows7.
PROFESSIONAL EXPERIENCE:
Confidential, PA
Sr. Business System Analyst
Responsibilities:
- Conducted user interviews to determine business requirements, consolidated and documented the requirements.
- Organize and facilitate release planning, daily stand-up meetings, sprint planning and Scrum related meetings.
- Schedule and prepare meetings minutes, actions, issues and status
- Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements.
- Preparing Current and Future State Process diagrams for re-engineering the existing systems
- Preparing the Functional and Technical Specification Documents.
- Document the architecture and workflow process for existing trading systems.
- Design Data Flow Diagrams, Sequence and Use Cases using UML.
- Lead the development team.
- Prepare project schedules and weekly / daily status reports regularly to communicate project status to project stakeholders.
- Coordinate and provided guidance to QA team
Confidential, Wayne, PA
Project Manager
Responsibilities:
- Create and manage the work plan and resources for the implementation of Recovery Automation System.
- Manage team to determine requirements, identify gaps, offer mitigation strategies and deliver implementation options for replacement of decentralized Customer Portal.
- Preparing the Functional and Technical Specification Documents.
- Design and document the architecture of Recovery Automation System.
- Reviewed SOW (Statement of Work) for project preparation phase.
- Liaison with the corporate level Project Management Office (PMO) for issue resolution, scope definition and deployment activities.
- Develop and implement the Agile / Scrum procedures
- Facilitate project planning, daily stand-up meetings, reviews, sprint and release planning, demos and other Scrum related meetings.
- Maintain product and development team artifacts including product backlogs, sprint backlog, sprint tasks, etc.
- Provide weekly status reports regularly to communicate project status to project stakeholders.
- Develop interface requirements and performed system testing.
- Client responsibilities included supporting project-planning activities, budgeting, resource planning, and managing project issues.
- Coordinate cutover activities and provided guidance to QA team.
- Change Control Management and Deployment.
Confidential, Baltimore, MD
Project Manager
Responsibilities:
- Managed the planning and oversaw execution of the technical environments, process readiness, user setup, configuration dependency, backups, trainings, site readiness and organizational change activities.
- Determined and recommended optimal solutions to address business requirements with consideration of company profitability objectives.
- Prepared and maintain project schedules and weekly status reports regularly to communicate project status to key stakeholders.
- Prepared and reviewed test plans and facilitate test execution to ensure the system meets requirements.
- Develop and implement the Agile / Scrum procedures
- Facilitate project planning, daily stand-up meetings, reviews, sprint and release planning, demos and other Scrum related meetings.
- Data Conversion of Cash Notification System.
- Developed business case with emphasis on NPV, IRR and ROI.
- Reviewed and developed Interfaces to various systems.
- Lead the DR Team for DR Testing.
- Prepared project report for up-gradation of lotus domino migration from 7 to 8.5.2 and leading the lotus migration team.
- Risk Analysis before up-gradation.
- Play instrumental role in DMG up-gradation project and Window 7 project.
- Managed Vendor Management Systems.
- Managed a team of 8 internal members to deliver the projects.
- Implement Best Practices Guidelines.
- Change Control Management, Deployment and Cutover activities.
Confidential, Wayne, PA
Sr. Technical System Analyst / Project Manager
Responsibilities:
- Managed team to determine requirements, identify gaps, offer strategic solutions and implementation options.
- Managed assembly, integration and user acceptance testing with timely defect resolution and retesting for timely completion of each test cycle.
- Led release of products through entire life cycle of the project.
- Prepared and maintain project schedules and weekly status reports regularly to communicate project status to key stakeholders.
- Assisted executives with selection of systems integrator together with program sponsor and steering committee.
- Managed cost budget to allocate overall cost estimate to individual tasks.
- Developed work breakdown structures and manage project plan with PMO resources.
- Responsible for application architecture implementation best practices.
- Prepared and review test plans and facilitate test execution to ensure the system meets requirements.
- Interfaced with executives and business owners to identify, develop and document business requirements.
- Prepared Project Reports that include BR30, MD50, MD80 and CV40 documents for many systems.
- Prepared Microsoft Project and WBS to assign the tasks to other team members.
- Leverage Agile and Scrum methodologies to lead project teams as both a scrum master and project manager
- Develop and implement the Agile / Scrum procedures
- Facilitate project planning, daily stand-up meetings, reviews, sprint and release planning, demos and other Scrum related meetings.
- Determined and recommend optimal solutions to address business requirements with consideration of company profitability objectives.
- Conducted user interviews to determine business requirements, consolidated and documented the requirements.
- Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements.
- Documented JAD sessions in a format that can be reviewed and understood by both business and technical teams.
- Used UML to produce use case models and sequence diagrams as part of the detailed design of interfaces.
- Designed Data Flow Diagrams (DFW), Entity Relationship Diagrams (ERD) and web page mock ups using Microsoft Visio.
- Worked with Vendor Management Team.
- Prepared and presented Power Point presentations to Business Stake Holders / End Users.
- Prepared and documented the Test Scripts and User Training documents.
- Designed and documented the entire solution architecture for many machine critical applications.
- Developed a detailed knowledge of existing systems and technologies within the company to understand how they should be appropriately leveraged to enhance business process and company scalability.
- Liaised between the business units, technology teams and support teams.
- Engaged successfully in multiple initiatives simultaneously and worked independently with users to define concepts.
- Performed an instrumental role in conversion of Lotus Notes applications into Oracle.
- Provided solutions in Execution, Transmission and Loading of Master Data into Oracle database.
- Involved in conversion of Oracle data warehouse to Terada.
- Participated in analysis and creation of Logical and Physical Data Models.
- Prepared and reviewed Data Interface Mapping.
- Participated and supervised in creating and tuning physical database objects (tables, views, indexes) to support normalized and dimensional models.
- Coordinated and provided guidance to QA team.
- Designed and developed many web-enabled Domino forms using domino design elements, HTML tables, Programmable Tabbed Tables, sub forms, pass thru HTML, DHTML, XML, Web Services, JavaScript, AJAX and Dojo.
- Worked individually on most of the applications and also participated as a team member in other applications in a team of 5 or more.
- Designed and developed many agents in the combination of Lotus Script and JavaScript.
- Generated reports to validate user input using Workflow and business related Notes and Web agents.
- Designed and developed a dynamic security profile maintenance database that allows for multiple levels of access to various external (web) users of the system.
- Implemented the SSL 3.0 protocol to ensure that users access and submit information in a highly secure environment.
- Played instrumental role in migration of Notes databases from version 6.5 to R7 and 7.0.3 to 8.5
Confidential, Wilmington, DE
Business / Technical Analyst
Responsibilities:
- Involved in gathering requirements, analysis, designing and implementation.
- Prepared business workflow charts.
- Prepared and documented design definition document.
- Prepared project schedules and weekly status reports regularly to communicate project status to project stakeholders.
- Prepared and documented the Test Scripts and User Training documents.
- Worked extensively with domino, HTML and Java script.
- Used Team Studio Analyzer to analyze the databases and to fix problems
- Documented the entire system design, procedures.
- Involved in Preparation of Test Scripts, Testing databases functionality and fixing the problems found in the migration process
- Prepared BR30, MD50, MD80 and CV40 documents.
Confidential, Wilmington, DE
Business Consultant
Responsibilities:
- Gathered requirements from the client and configuring the systems based on the requirements.
- Configured Enterprise Structure, Financial Accounting Global Settings, General Ledger Accounting, Accounts Payable and Accounts Receivable.
- Configured Master Data settings in GL and Sub Ledgers, GL-Bank Account Integration, House Banks Settings, Electronic Bank Statement, Lockbox, Bank Reconciliation, Bank Calculation.
- Configured settings for Company code, Fiscal year variant, Chart of accounts, posting period variant, field status variant and field status groups.
- Set up Lockbox and House Banks.
- Configured Account groups and retained earning accounts to create GL Master.
- Created Bank Master data, House banks, G/L accounts for each bank account.
- Created reconciliation accounts for vendors and customers.
- Customized screen layouts for document entry at account/document levels, settings for clearing, for posting in foreign currencies, for exchange rate differences and gains and losses on valuation.
- Configured Automatic Payment Program for out-going payments in Accounts payable.
- Configured trading partners for vendor/customers.
- Configured internal orders, order types and settlement profiles.
- Created Master record, house bank creation, automatic payment program configuration, Interest Calculation Configuration in Accounts Payable.
Confidential, Philadelphia, PA
Technical Consultant
Responsibilities:
- Designed and documented the entire solution architecture for many machine critical applications.
- Developed a detailed knowledge of existing systems and technologies within the company to understand how they should be appropriately leveraged to enhance business process and company scalability.
- Conducted user interviews to determine business requirements, consolidated and documented the requirements.
- Liaised between the business units, technology teams and support teams.
- Engaged successfully in multiple initiatives simultaneously and worked independently with users to define concepts.
- Coordinated and provided guidance to QA team.
- Designed and developed many web-enabled Domino forms using domino design elements, HTML tables, Programmable Tabbed Tables, sub forms, pass thru HTML, JavaScript.
- Generated reports with Workflow and business related Notes and Web agents to validate user input through the web & notes.
- Performed an instrumental role in migration of Notes databases from version 5.x to R6.
- Prepared and documented the Test Scripts and User Training documents.
Environment: Lotus Domino 8.5.2, 7.x,6.x, Lotus script, HTML, XML, Web Services, JavaScript, SSL, CSS, Microsoft Project, Microsoft Office, Starteam, Visio, Photoshop, Team Studio, Analyzer, SnagIT, Windows NT 4.0, 2000/XP.
Confidential
ERP Consultant
Responsibilities:
- Gathered and analyzed business requirements
- Prepared the BRD(Business Requirements document) and Functional documents
- Prepared weekly status reports
- Defined specifications analyzed business requirements, studied and analyzed the GL, AR, AP, OE, and PO.
- Created a set of Books, Chart of Accounts with Accounting Flex fields
- Included setups such as Multi Language, Multi Reporting Currency, Multi Organization
- Consolidated, revaluated, translated different set of books.
- Customized and generated Financial Statement Generator (FSG) Reports
- Created Auto Accounting Rules as per Customer Requirements.
- Involved in Customization and testing of the Oracle applications system in GL.
- Developed various reports like detail payment reports with reference to Branch level Customers outstanding report etc.
- Defined Locations, Buyers, Approval Groups, and Purchasing Options in Purchasing.
- Assigned Employees’ Approval Groups.
- Set up Document Approval and Security.
- Created Requisition Templates.
- Created and update Descriptive Flex Fields.
- Customized lockbox transmission formats.
- Customized forms and reports in AR,
- Created Auto Cash Rules sets as Customer Requirements.
- Loaded sales tax records from user sales tax feeder system.
- Defined user auto Invoice grouping rules, user lock boxes.
- Transferred order details to oracle Receivables for Invoice creation
- Involved in Customization and testing of the Oracle applications system in AR
- Entered and process different transactions like Invoice, Debit Memo, credit Memo, Deposit.
Confidential, Philadelphia, PA
Senior Developer
Responsibilities:
- Designed and documented the entire solution architecture for many machine critical applications.
- Developed a detailed knowledge of existing systems and technologies within the company to understand how they should be appropriately leveraged to enhance business process and company scalability.
- Conducted user interviews to determine business requirements, consolidated and documented the requirements.
- Worked individually on most of the applications and also participated as a team member in other applications in a team of 5 or more.
- Designed and developed many agents in the combination of Lotus Formula Language, Lotus Script and JavaScript.
- Generated reports using Workflow and business related Notes and Web agents to validate user input through the web & notes.
- Designed and developed a dynamic security profile maintenance database.
- Performed an instrumental role in migration of Notes databases from version 4.6 to R5.0.
- Prepared and documented the Test Scripts and User Training documents.
Environment: Lotus Domino 4.6, 5.0, Lotus Formula Language, Lotus script, HTML, JavaScript, Microsoft Project, Microsoft Office, Starteam, Visio, Photoshop, Team Studio, Windows NT 4.0, Windows 98.
Confidential
Developer
Responsibilities:
- Developed web-enabled application using different formatting standards and security implementations supported by DOMINO.
- Studied the business process of the company, prepared system requirements specification document.
- Involved in designing the system using the Notes features such as navigators, actions and sub-forms.
- Designed views for presenting the information as per the client requirement.
- Generated reports in MS-Word using Lotus Script and VBA Scripting.
- Used MS Word for Documentation and for End user Training Support.
- Analyzed the business requirements and translating them into data modules.
- Handled approval system and necessary forms were designed to maintain the leave details, advance for travel expenses.
- Designed views to present the leave details & advance for travel expenses.
- Created agents to automatically update the leave details & advance for travel expenses.
- Involved in designing & developing the specification requirements of the clients.
- Coded, tested & debugged for the proper functionality of the work flow.
- Designed Forms and Views to maintain and presenting the personnel information.
- Created Agents to archiving the outdated personnel information.
Environment: Lotus Notes 4.6, 4.5, Domino, Windows 95/98 and Windows NT Notes features used: Lotus notes 4.6, Domino, Lotus Script, Formula language, Actions, Forms and Views, Frames, HTML, Java Script, lotus java beans, VBA Script.
Confidential
ERP Consultant
Responsibilities:
- Defined specifications, analyzed business requirements, studied and analyzed the GL, AR, AP, OE, PO, INV.
- Created a set of Books, Chart of Accounts with Accounting Flex fields.
- Setup Multi Language, Multi Reporting Currency, Multi Organization.
- Consolidated, revaluated, and translated different set of books.
- Customized and generated Financial Statement Generator (FSG) Reports.
- Created Auto Accounting Rules as per Customer Requirements.
- Involved in Customization and testing of the Oracle applications system in GL.
- Defined Locations, Buyers, Approval Groups, and Purchasing Options in Purchasing.
- Created and update Descriptive Flex Fields.
- Customized lockbox transmission formats.
- Customized forms and reports in AR.
- Migrated data from legacy system to Oracle Applications Open Interface tables using SQL*Loader.
- Transferred data to RA Interface linesall, RA Customer tables.
- Created Auto Cash Rules sets as Customer Requirements.
- Loaded sales tax records from user sales tax feeder system.
- Transferred order details to oracle Receivables for Invoice creation.
- Involved in Customization and testing of the Oracle applications system in AR.
- Customized Receipt Forms to query Customer wise Disputed Open items and Transaction Forms to query customer wise Aging Information.
- Entered and processed different transactions like Invoice, Debit Memo, credit Memo, Deposit.
Confidential
Audit Assistant / Financial Consultant
Responsibilities:
- Conducted and finalized Statutory, Internal & ABC Audits, including preparation of Statutory Financial Statements. Taxation & Certification work and Staff supervision & training.
- Prepared Trial Balance, Profit & Loss Account, Balance Sheet, Cash Flow, Funds Flow projections and project reports for working capital.
- Developed operating procedures manual for the company, incorporating there-in Internal Control Measures of Stock, Cash & Bank, Fixed Assets and other areas.