We provide IT Staff Augmentation Services!

Business Systems Analyst Resume

Wilkes Barres, PA

SUMMARY:

  • A Business Analyst with over nine years of combined IT experience, possessing "advance knowledge" of MS Office applications such as Visio, ACCESS, EXCEL, WORD, POWERPOINT (VBA, Macros). Areas of expertise include;
  • Developing UML, Screen flow, activity, use case diagrams using Visio
  • Worked with offshore developers to implement global projects
  • Documenting functional requirements utilizing Use Case approach
  • Gathering Data Requirements, Data Dictionary development, performing UAT, regression, testing
  • Advanced knowledge of Microsoft Excel, including vlookups, if statements, macro creation, and the ability to combine these tools to create comprehensive models
  • Ability to establish strong partnership with the business, operations and cross - functional technology teams
  • Experience with CRM (Microsoft dynamics CRM), Ecommerce application (Business Catalyst) and various data base systems (Oracle, SQL Server, Data Ware Houses)
  • Strong leadership ability to improve data management procedures in all departments

TECHNICAL SKILLS:

Business Experience: Data Analysis, ETL (extract, transform and load)CRM, Data Modeling, Gap analysis, UML Modeling and RUP Methodology, Finance, MIS, Project Management and Leadership, Managed care, Medicare, CPT and ICD Coding, Load testing, Business Analysis, Software Development Lifecycle (SDLC). CMS, Team site, ETL data mapping Postal Security Clearance

Technical/Financial Applications: Informatica, Business objects, SAP, Bloomberg, Interactive data, SQL queries, CMS, Team site, ACCESS AND EXCEL development (VBA), Rapid SQL, Business objects, Hyperion, Visio, Microsoft project, Crystal Reports, Oracle, Sybase, SQL Server, T-SQL, stored procedures, VB, UNIX, Windows NT, Novel, Windows 2000, AS 400, remedy, Caliber

PROFESSIONAL EXPERIENCE:

Business Systems Analyst

Confidential, Wilkes Barres, PA

Responsibilities:

  • Acquired Postal Security Clearance
  • Worked with offshore developers and mgmt. to implement a global project and maintain
  • Facilitated joint planning, application, and functional design sessions to support cross- team alignment,
  • Worked with SME’s and IT to develop Informatica data mappings for ETL’s
  • Involved in the upgrading of current legacy system to Hyperion
  • Worked with reference data, performed data validation
  • Worked with developers to developed wireframes for the templates and components for content management software
  • Worked with IT management and users to resolve trouble tickets and clarify system requirements
  • Improved reporting system by converting Business Objects Reports
  • Worked with the system architects for Technical Architecture diagrams (TAD)
  • Development of Business, Function and technical requirements used Caliber, a requirement management system, to manage requirements
  • Implemented, Teamsite content management system
  • UAT, Cat, Sit and Load testing
  • Provide accurate updates to Material Master Data for MRP, Purchasing, Inventory and Vendor Master Data for procurement of production process materials.

Confidential, New York, NY

Business Analyst

Responsibilities:

  • Maintained a Project Plan, Timelines and Workflow
  • Improved reporting system by upgrading to Business Objects Reports
  • Performed Gap analysis, performed Data Modeling
  • Used Business Rules to develop test cases for UAT
  • Developed Activity diagrams and screen flows
  • Developed UML diagrams using Visio
  • Performed requirements gathering
  • Reversed engineered and documented Actuarial Forecasting models using the use case and business rules approach
  • Worked with reference data, and performed ETL’s
  • Worked with IT, system architects and users to Implement, Teamsite content management system
  • Wrote Use Cases and Business Rules to capture the process for: “incurred losses”, “paid losses”, “large loss data”, “loss retention”, loss projections, bases “incurred” and “paid”, claim count projections, loss projection frequencies, “outstanding reserves” and valuation months etc.
  • Served as the bridge between the business community and Technology group.

Confidential, White Plains NY,

Business Analyst

Responsibilities:

  • Developed various UML diagrams using Visio
  • Improved reporting system by upgrading to Business Objects Reports
  • Gathered data requirements, performed Data Modeling
  • Implemented insurance/ broker services platform the of Microsoft dynamics CRM,
  • Implemented Advisor platform/ wealth management module of the Microsoft dynamics CRM
  • Involved in the upgrading of current legacy system to Hyperion
  • Wrote use cases, business rules and functional specs to run legacy applications, in a Java, Web-enable environment
  • Worked with IT to turn functional specs into web- enabled solutions such as dashboards using web sphere portal
  • Developed the business rules and use cases for .net’s web services technology
  • Worked with reference data and performed ETL’s, performed data validation and analysis
  • Collected and documented functional requirements utilizing Use Case approach
  • Created and maintained Business Rules catalog
  • Served as the bridge between the business community and Technology
  • Actively solicited, analyzed and negotiated customer requirements
  • Responsible ERP R/3 Material Management Portal analysis, testing, training, system development, and production support for Internet web visibility tools.
  • Minimized requirement defects, established and maintained agreements between the customer and project team on requirements
  • Solved complex business problems and addressed technical issues and assessed possible project impacts
  • Documented and identified downstream processing dependencies
  • Problem analysis and resolution of “shares outstanding”,” pricing” exception reports.
  • Setup tools to assist in the pricing of equities and the capturing of corporate actions
  • Worked with teams physically distributed in other countries (India and across USA)
  • Supervised and coordinated system and UAT testing, regression testing of equities
  • Used Bloomberg, Interactive data to ensure the accuracy and integrity of Alliance’s Securities market data
  • Reconciled exception reports for correct pricing, missing shares outstanding, Tickers, and Sedol Numbers etc.
  • Performed data analysis between current and legacy systems, using Excel and access
  • Held JAD sessions with executive sponsors, end-user representatives, developers, scribe, and subject matter specialists and produced meeting minutes
  • Created: VLOOKUPS, PIVOT TABLES, wrote VBA
  • Created automated spreadsheets to research ISINS, SEDOLS, CUSIPS across multiple exchanges, using Bloomberg EXCEL
  • Prototyped systems requirements into applications using Excel and Access

Confidential, Neptune, New Jersey

Business Analyst

Responsibilities:

  • Elicited and documented user requirements, into an integrated set of use cases and associated business rules Implemented XP product rollout
  • Worked with reference data
  • Automated spreadsheets and created custom databases in ACCESS using VBA Application testing, configuration planning
  • Submitted timely status reports to client and management

Confidential, Stamford Connecticut,

Business Analyst

Responsibilities:

  • Performed Business Analysis, Data Analysis, Reporting Analysis
  • Performed data validation and analysis
  • Analyzed embedded SQL Queries and stored procedures in VBA Worked with SQL, Sybase, SQL Server, T-SQL
  • Involved in the upgrading of current legacy system to Hyperion
  • Automated spreadsheets and created custom databases in ACCESS using VBA
  • Created customized reporting and analysis tools using VBA EXCEL / ACCESS macros
  • Used Bloomberg, to ensure the accuracy and integrity of Securities market data
  • Served as a liaison across Front Office, Middle Office, management and technology
  • Documented and identified downstream equities processing dependencies
  • Reconciled equity exception reports such as share outstanding and pricing
  • Setup tools to assist in the pricing of equities and the capturing of corporate actions
  • Supervised and coordinated system and UAT testing, regression testing of equities
  • Im very good in interaction with highly technical resources to execute appropriate measures and controls for production processes.

Confidential, New York, NY

Business Analyst

Responsibilities:

  • Conducted data quality assurance, designed and implemented improvements
  • Tracked statistics and created corrective actions for error reports
  • Used Bloomberg, to ensure the accuracy and integrity of Securities market data
  • Problem analysis and resolution of error reports
  • Enhanced productivity by creating a system which fed/connected to other internal system, written in Excel VBA using Access as a repository
  • Portfolio Management System (Mystic) and corrective action plans database
  • Acquired working knowledge of the Sarbanes Oxley principles
  • Improved and enhanced the ability to track compliance to software version releases for Mortgage Based Securities and Asset Based Securities Derivatives
  • Uploaded awaiting Securities prices to system
  • Built relationships by identifying and communicating new developments and opportunities to management/business
  • Submitted timely status reports to client and management
  • Tracked IT security training and awareness requirements

Confidential, NY

Business Analyst

Responsibilities:

  • Involved in the documentation of functional requirements, data conversion, analysis, reporting and presentations
  • Maintenance and support
  • Improved reporting system by converting Business Objects Reports, to new format and implementing report Alerts
  • Built relationships by liaising with technical counterparts to ensure correct technical and functional flow/design
  • Programming (Visual Basic, Access and Excel VBA, relational databases)
  • Enhanced Business Objects reports sold on company web portal
  • Acquired knowledge of MasterCard International’s transactional processes, authorization, terminals, debit transactions, chargeback, and processes
  • Improved quality by performing User Acceptance Testing. (UAT)
  • Enhanced productivity by creating a system was written in Excel VBA with an Access back-end. The system includes various feeds from other internal systems
  • Increased Customer satisfaction and retention by lowering MasterCard’s Data warehouse report processing from 18hrs to 15 minutes resulting in huge potential savings.

Confidential

Business Systems Analyst

Responsibilities:

  • Created customized reporting and analysis tools using VBA EXCEL / ACCESS macros
  • Saved 1 million plus dollars per year by eliminating data entry errors
  • Documentation of functional requirements
  • Re-engineered business processes for core business applications by holding JAD sessions
  • Used access to extract information from AS/400 system, SYBASE, ORACLE, SQL SERVER database systems
  • Manipulated Oracle Financials to extract and distribute reports
  • Used VBA to develop Access databases and Excel Spreadsheets
  • Proactively improved computer systems and procedures
  • Used Business Objects, Crystal Reports, wrote and modified complex SQL for AHOC reports.
  • Defined, communicated the project team’s responsibilities, priorities and goals
  • Performed PERT Analysis and Critical Path Method, developed Gant charts
  • Managed a development team of internal and external resources, matrixes
  • Developed and managed Project Plans
  • Researched and worked with Compliance to ensure adherence to NYS medical billing laws Raised systems and systems and operations to peak performance through creative hands on leadership.

Hire Now