Sr.business System Analyst Resume
Washington, DC
Summary
- Extensive knowledge drawn out of Eight years of experience as Business Analyst in State agencies, Banking, Retail and Healthcare industries
- In depth knowledge in the analysis, design, and re-engineering of system applications and business processes, using structured system analysis methodologies, placement of business controls, diagramming data and process mapping, applying Unified Modeling Language (UML), and implementation of performance measures.
- Extensive knowledge of Object Oriented Analysis and Design using Unified Modeling Language (UML), Rational Unified Process (RUP), Rational RequisitePro, Rational Rose, Rational Clear Quest and Rational Clear Case.
- Experience in conducting quality review sessions Joint Application Development (JAD) sessions for requirements gathering, analysis and design; and Rapid Application Development (RAD) sessions to converge early toward a design acceptable to the customer and feasible for the developers within budget and time constraints.
- Knowledge of Data warehousing, Business objects and ETL tools like informatica.
- Experience working in design phase, also worked with the development team to ensure testability, reliability, usability, maintainability and performance by documentingwebsite processes and workflow, identifying cross functional and organizational process improvement opportunities.
- Experienced on Requirements management tools such as Borland Caliber RM.
- In-depth knowledge of creating Use case, activity, and sequence diagrams to extract business process flows and workflows, thereby helping developers and quality assurance in understating the requirements.
- Generate and document detailed Siebel application component level design for functional, performance and security requirements as defined by Business users.
- Analyzed Siebel system requirements and all aspects of Siebel system application and functional design, configuration, and customization.
- Managed SOX and Security Program while monitoring multiple projects and established strong client's relationship
- Experience reviewing Test plans, Testcases and Test case execution with Test Director.
- Understand business requirement document and functional spec and write test cases using Quality Center.
- Experienced working with client/server and web-based application architectures.
- Exhibits confidence and an extensive knowledge of emerging industry practices when solving business problems.
- Excellent Skills in Content Analysis, Page flow and navigation requirements, Technical Specification, Performance Requirements, Vendor Contracts, and User Guides and improve customer service.
- Excellent Analytical and Documentation skills. Hands on experience in preparing system specifications, functionality and testing documents also Extensive experience in Manual Testing and automated testing.
- Skilled in Feasibility studies, Scope Documents, Requests for Proposal and preparing end-user support documentation and training materials.
- Comprehensive knowledge of the testing lifecycle within client/server & Mainframe environment.
- Experienced in conducting GAP analysis, User Acceptance Testing (UAT), Cost Benefit and ROI analysis.
- Working closely with VP operations, PM, Subject Matter expert (SME) and to develop business strategy for financial planning, budgeting, and strategic planning.
- Creative and aggressive self-starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent and team environments
CORE COMPENTENCIES
- Design Methodologies
- Server Side Applications
- Quality Assurance
- Object Oriented Systems
- Operating Systems
- Protocols
- User Interfaces
- Distributed Systems
- Software Processes
- Project Management
- Software Construction
- Data Structures
BUSINESS SKILLS:
- Business Definition Requirements
- Business Process Analysis & Research
- Use Case Modeling & Analysis
- Technical Requirements Development
- JAD/RAD Sessions
- Requirements Gathering
- Change management (CCR)
- ER Diagrams
- Gap Analysis and Impact analysis
TECHNICAL SKILLS
Analysis Methodologies
RUP, UML, Six Sigma, Agile methodology, Cost-Benefit Analysis, Risk Analysis, Gap Analysis.
Operating Systems
Win 95/98/NT/2000/XP, Linux, UNIX
Dataware housing
Informatica, Oracle Data warehouse Builder
Application Server
Microsoft Exchange Server, Microsoft SharePoint
Defect Tracking Tools
Rational Clear Quest, Test Director 7.6
Business Modeling Tools
Rational Rose, Microsoft Visio.
Requirement analysis and Management
Rational Requisite Pro, Test Director, iRise simulator, Borland Caliber
Version Control Systems
Rational Clear Case
Reporting
Crystal Reports, MS Project
Project Management
Microsoft Project, Microsoft Office Suite.
Programming Language
C++, HTML, SQL, ORACLE, XML, .net, cobol.
Testing Tools
Mercury Quality Center Rational Enterprise Suite, Test Director, Quick Test Pro
Quality Management:
Quality Criteria, HIPAA, SOX.
Other Tools / skills
MS Office (Word, Excel, Access, PowerPoint), Publisher Photoshop, Dream Weaver, Outlook, Load Runner, Visual Studio, Cognos,SAP4.7 Enterprise,LDAP
PROFESSIONAL EXPERIENCE:
Client: Confidential
Location: Washington, DC
Role: Sr.Business System Analyst
Period: JAN'10- Present
Department of Employment Services is a federally funded agency which comes directly under DC Government. DOES is empowering and sustaining a diverse workforce, which enables all sectors of the community to achieve economic and social stability to plan, develop and administer employment-related services to all segments of the Washington, DC metropolitan population. It is the prime agency which deals with providing Unemployment Benefits to the claimants and collecting Tax from the employers operating in District of Columbia. Working for OIT (Office of Information Technology) of the agency, I am involved in the Tax and Benefits Systems and Web portal for each of the system.
Responsibilities:
- Serve as the Senior Business Analyst on multiple projects to gather requirements, document existing business processes, and make recommendations on how to improve existing business work flows and processes
- Planed and developed feasibility study, requirements and risk analysis for stored procedures system and developed local, temporary, and extended stored procedures for authentication, input validation, and business rule enforcement.
- Responsible for the Mainframe technical infrastructure support to include leading the definition, design and documentation of technical environments at detailed level as well as deploying solution architectures, conducting analysis of alternative architectures, creating architectural standards, defining processes to ensure conformance to standards, instituting solution-testing criteria.
- Identify and define technical requirements associated with needed improvements in production and development operations, as well as the support of annual system updates.
- Critically evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding, and distinguish user requests from the underlying true needs.
- Proactively communicate and collaborate with external and internal customers to analyze the client needs and generate the user requirements in accordance with functional and technical specifications and created function requirement document.
- Manage and prioritize system requirements to ensure that scope is consistent with stated needs and that the project deliverables remain synchronized as a result of agreed changes.
- Manage and prioritize system requirements to ensure that scope is consistent with stated needs and that project deliverables remain synchronized as a result of agreed changes.
- Work independently with users to define concepts and under direction of project managers and application developers to create a data dictionary.
- Analyze the requirement and create the test case for each of functional requirement.
- Monitor data synchronization between Mainframe and SQL Server DB.
- Serves as the conduit between the customer community (internal and external customers) and the software development team through which requirements flow.
- Collaborate with developers and subject matter experts to establish the technical vision and analyze tradeoffs between usability and performance needs. Make recommendations based on best practices and industry standards.
- Documented all the existing UI Tax/ Benefit production jobs and processes in the Mainframe System.
- Monitor the batch process jobs in Mainframe Production Environment in real time and also document the Issues behind the failure of each Production jobs and the Resolutions for the respective jobs
- Document all the changes being done in the UI Tax and Benefits System and update the documentations and templates related with the changes.
- Collaborates with Developers and Subject Matter Experts to establish the technical vision and analyze tradeoffs between usability and performance needs.
- Communicate effectively with different departments in an effective manner and track and document the enhancements in the UI Tax and UI Benefit Mainframe and Web application.
Environment: IBM Mainframe System, DUTAS, ISPF, JCL, VSAM, COBOL, SQL Server Utility Programs, Application Programs. .NET, MS Visio
Client: Confidential
Location: Washington, DC
Role: Sr. Business / Requirement Analyst
Period: MAY'08 - DEC'09
The Office of the Chief Technology Officer (OCTO)is the central information technology (IT) and telecommunications state agency in the District of Columbia government. The Human Services Modernization Program (HSMP) is the OCTO initiative that manages the citywide enterprise solution effort. This initiative will encompass, but not be limited to, business process engineering, system replacements, system enhancements, new systems selection, custom enhancements of existing applications, system integration, and IT oversight, affecting the health and human services and related District agencies.
Responsibilities:
- Employed RUP methods for requirements and object oriented analysis tasks; written a comprehensive business requirements document communicating the needs of the business to users and the technical team.
- Involved in analysis of the functional, technical specifications, data mapping document and conceptual diagrams.
- Interacted with a variety of business users as a cross-functional liaison to understand client issues and produce business specifications and plan system changes to meet client needs.
- Captured and documented technical requirements and specifications, based on business analysis.
- Worked under multiple projects [CHARI (Child At Risk) - Office of the Deputy Mayor of Education, HEPRA (Health Emergency Preparedness and Response Administration) - Department of Health and PIFB (Preliminary Interview for Benefits) - Department of Human Services] simultaneously.
- Requirements gathering/Documentation Designed and documented detailed business requirements, functional requirements utilizing PMO & Governance approved templates.
- Business goals and processes are fully documented and incorporated into requirements, design and implementation of technology solutions.
- Involved in the full lifecycle from analysis and planning to development and deployment and also responsible for defining and managing adherence to overall requirements methodology.
- Gathered/coordinated in gathering of requirements from Agencies and created use cases, devises graphical depictions of process flows, technical diagrams.
- Conducted JOINT APPLICATIONS DEVELOPMENT (JAD) sessions with the participation of the users and the stakeholders to gather requirements.
- Worked with Cognos developer in developing templates for reporting, as well as standards for report outputs by analyzing data elements.
- Identified business problems and recognize opportunities for efficiency improvement business solutions with project management.
- Used Rational Clear Case to manage all the changes and change requests in the projects.
- Worked with QA team with the aid of Clear Quest for the bug tracking and developed scenarios for validation and testing, and resolved issues related to requirements during System testing and UAT.
- Worked closely with project teams that include Programme manager, Project Manager and Design Architecture to develop strategic approach to meet client goals.
- Produced formal technical requirements specifications and use cases.
- Experienced in data modeling and mapping, exposure to the development of common schemas integrating complex, multi-application data models.
- Experienced in analyzing complex technical methods and solutions.
- Created the Directory Interoperability Forum and represented Novell in both the Desktop Management Forum and Directory Enabled Network (DEN) initiatives.
- Exceptional interview and documentation skills. Direct experienced in making public presentations, participating in technical requirements sessions and guiding stakeholders in these efforts.
- Demonstrable skills in graphical design and presentation of complex technical systems to technical and end-user/stakeholder audiences.
- Participated in risk analysis, develop mitigation strategies; compensate for changing priorities and short deadlines.
- Initiated and validated changes and facilitated new user training and ongoing training and support of project systems, upgrades and modifications in system rules.
Environment: Rational Rose, Rational Clear Case, Rational Clear Quest, MS Office, Cognos,UML, MS Visio, Ms Access SQL server.
Client: Confidential
Location: NY
Role: Business / Facets Analyst
Period: FEB'07- APR'08
Confidential, is a full service healthcare management and information services company working with public sector government programs across New York State. Health Care Information system is a transaction processing based on customer relationship management System. The application has the ability to track the entire business and to automatically generate the relevant reports. It is developed to automate the entire Process of treatment tracking based on Treatment status, it automatically generates health reports, appointment notifications, Billing letters and letters to clients and work orders to concerned crew members. This system is integrated with the OLAP to facilitate the high level decision making processes.
Responsibilities:
- Worked on Claims, Customer services, Members, Billing-Enrolment interfaces and extensions for FACETS as a part of FACETS implementation team.
- Worked on Facet implementation team and involved in process modeling, prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level.
- Worked on 837 institution and professional, 834, EDI Gateway and EDI standards ANSI ASC X12N Health Care Claim (837).
- Created MMS, CDH, XFS crosswalk documents.
- Analyzed data architecture, documented and delivered data mapping, performed risk analysis.
- Analyzed existing XML, COBOL files to write logics.
- Involved in gathering business requirements and collaborated on creation of documents such as the Vision, business requirements (BR) and business with systems design (BSD) documents.
- Analyzed and documented the System specifications, Business requirements and detail design of the software for full understanding of the business and used Requisite Pro for the requirement tracking and analyzing.
- Written business rules for identity management according to job competency, authority, and responsibility within the enterprise.
- Experienced with ICD (International Classification of Diseases) codes to develop procedure classification and skills that are necessary to assign valid codes for causes of the death.
- Experienced with ICD codes which is required by third party payers for reporting the clinical diagnosis associated with the claiming procedure to report diagnoses and diseases.
- Analyzed, researched and created report on EDI functionality as a strong contributor on the EDI team. Coordinated and program acceptance of EDI transactions with new trading partner relationships.
- Experienced in data standards, metadata management, information strategies, and business intelligence full life cycle tools and technologies.
- CIA (Confidentiality, Integrity, and Availability) matrix was developed and IPP (Information Protection Plan) rating was introduced to segregate the high risk application from the medium and low risk ones so that the audit can be performed for high risk applications.
- Used ANSI ASC X12N XML schema to develop message standards for submission into the database.
- Captured the functional requirements and mapped those with Siebel's functionalities, made use cases and designed all the necessary applets and views.
- Responsibilities include managing Siebel CRM program releases through all phases of the SDLC.
- Mainly responsible to analyze, design, and implementation of the systems requirements and network infrastructure needed to support all aspects of the Siebel development, testing, and production environmental requirements.
- Wrote SQL queries using Query Analyzer and Oracle for data manipulations.
- Performing business support responsibilities to include production monitoring, file maintenance, ad hoc reporting and consultation with internal and external users
- Worked on relational data base, ETL tables, staging processes, XML/COBOL files.
- Worked with other business analyst to design, and document needs assessments, HIPAA gap analysis, workflow, data maps, business requirements, functional & reporting specifications, business rules, policies and procedures.
- Manipulated data files containing accrual rates, and allows the user to choose various options to test if pension plans pass the non-discrimination requirements.
- Experienced in using LDAP and enterprise identity management as a centralized data store for cross-platform administration and development and also involved in a test environment for Novell Access Manager.
- Prepared appeals for Pension, Welfare, for Trustee meetings; administered decisions.
- Experienced consumer driven health care that allow members to use personal Health Savings Accounts (HSAs), Health Reimbursement Arrangements (HRAs).
- Manage traceability matrix to trace Business Requirements, Functional requirements and System test scripts using requisite pro, clear case and clear quest.
- Used Rational Rose to model the process using the Unified Modeling Language (UML) to create use case diagrams, activity diagrams, sequence diagrams and collaboration diagrams.
- Worked with CEO, VP Operations, VP Marketing and subject matter expert (SME) to develop business strategy, mission and guiding principles.
- Monitored LDAP and Site minder logs to create automated solutions/steps to resolve errors or outages.
- Assisting in integrating the TPS with the OLAP data warehousing system for generating the reports periodically using Cognos reporting tool for Decision Support Processes.
- Interacted with the developers to resolve the technical and implementing issues. Involved in User Acceptance testing with the users.
Environment: MS Visio, MS Project, Requisite Pro, Siebel, RBAC, GAP Analysis, Novell eDirectory, .net, LDAP UML,OLAP, Use Case Analysis, RUP, Unix.
Client: Confidential
Location: New York, NY
Role: Business Analyst (Cash management)
Period: DEC'05- JAN'07
Confidential, is one of the largest banking and financial services organizations in the world. Worked as a Senior Business Analyst for online banking and cash management service applications. This application allowed viewing transaction history, paying bills online and transferring funds from one account to other.
Responsibilities:
- Involved in requirement gathering, analysis of the requirements from the user.
- Interacted with users for verifying user requirements, managing change control process, updating existing documentation.
- Supported weekly revenue forecast model and communicate key metrics and business trends to Senior Management.
- Used UML notations for Object Oriented Design and converted used case scenarios to detailed test cases and executed them.
- Created Work flow diagrams and Activity diagrams by using Rational Rose. Created work flow diagram for various modules pertaining to the web application liked online bill pay, transaction summary, fund transfer, automated bill payment etc.
- Managed and supported an advance team of designers and junior engineers as well as financial planning, budgeting, forecasting and cost analysis functions as well as technical design reviews including quality control and also analyzed budget and forecast information for trending and reasonableness..
- Reviewed and interpreted revenue analyses on a monthly and quarterly basis, reviewed trends on activity levels, revenue mix and gross margins/profitability. .
- Responsible for the daily cash management, including transactions, forecasting and Account Reconcilement Services.
- Gathered Requirements to designed LDAP based authentication and Role based authorization modules for an automated investment software for stocks and options
- Designed, developed and implemented predictive models using data mining tools, analyze test results and be able to discover segments in data
- Responsible for Novell adopting LDAP support and promoting development and support using UNIX.
- Contributed to developing new business templates to bring new clients into billing system.
- Responsible for correcting functional requirements as per Siebel Product restrictions.
- Experienced on Requirements management tools such as Borland Caliber RM which is used for reporting to measure, track, and analyze the efficiency and effectiveness of the requirements management process.
- Managed three successful relational database conversions to integrate new clients from existing relational billing databases into Carrier Access Billing System database.
- Responsible for analysis of derivatives, futures & options, foreign exchange and securities risk management.
- Managed the successful implementation and support of Cognos Applications.
- Experienced with iRise which also allows capturing scenarios, use cases, and narration to guide UML diagrams/models to gain familiarity with code design.
- Managed SOX and Security Program while monitoring multiple projects and established strong client's relationship. Played a key role in the Company's SOX compliance efforts including process documentation.
- Performed defect tracking, documentation and change requests using Test Director.
- Played supporting roles in investment banking application development for ETD and FX application.
Environment: Rational Tools, UML, Cognos, XML, Siebel, Oracle 10g (10.1.3.1.0),Unix.
Client: Confidential
Location: Chicago, IL
Role: Business System Analyst
Period: OCT'04- NOV'05
Confidential, restaurant is the biggest food chain in the world and serves nearly 54 million customers each day. The purpose of project was adding features to standardize development of computerized POS systems and simplify interconnecting POS devices.
Responsibilities:
- Worked closely with internal business partners and internal IT teams and billing teams on all phases of system lifecycle to deliver improvements to POS systems.
- Studied and analyzed the existing processes and brainstormed to gather Requirements for a quality product.
- Worked with IT and functional leads on researching solutions, investigating capabilities, developing requirements, use cases and functional specifications and assisting with system implementation.
- Communicated status of efforts to management and business partners on a regular basis and ensured that all stakeholders have accurate and current information throughout the process.
- Acted as a liaison between business staff and technical staff to articulate needs, issues and concerns.
- Used MS-Visio for flow-charting, process model and architectural design of the application.
- Supported implementation and deployment of new business functionality through the software development lifecycle.
- Build and maintain close relationships with internal customers (Market sales, retail operations, customer care, finance ) and retail systems vendor to ensure efficient development processes are being followed and that business priorities are met, and that projects/development are on schedule
- Conducted JOINT APPLICATIONS DEVELOPMENT (JAD) sessions with the participation of the stake holders and Sales team to gather requirements.
- Rational Clear Case was used to manage all the changes and change requests in the projects.
- Employed RUP methods for requirements and object oriented analysis tasks; written a comprehensive business requirements document communicating the needs of the business to users and the technical team.
- Analyzed Siebel system requirements and all aspects of Siebel system application and functional design, configuration, and customization.
- Analyzed relational tables to identify the source of required data elements, created data mapping document, wrote mapping/business rules for successful data migration.
- Assisted with the system testing/user acceptance testing of the functional enhancements as needed.
- Defined appropriate analytic approach for various client needs including pre and post-campaign analysis, measuring and analyzing response to marketing offers and making appropriate recommendations on enhancements to campaign strategy.
- Responsible for ensuring that the applications meet user requirements, and provided the change management support.
- Interacted with client user teams at various associate levels to analyze and model current business processes using Rational Rose (UML), and documented process flow diagrams using MS Visio.
- Experience reviewing Test plans, Test cases and Test case execution with Test Director .
- Facilitated the documenting of test cases and recorded them for the functionality testing in Test Director based on test requirements.
- Developed project delivery schedule, managed projects and identified resources to successful completion.
Environment: SQL Server, Ms Office Suite, Rational Rose, MS Visio, MS office suite, Requisite Pro, Siebel. MS Visio.
Client: Confidential
LOACATION: JERSEY CITY, NJ
Role: Business Analyst
PERIOD: JUN'03-SEP'04
Confidential, world leaders in insurance and financial services, is the leading international insurance organization with operations in more than 130 countries and jurisdictions. The project purpose was to assist the company in the integration of an Enrollment web portal (Care first Connect) that would provide employers with a customized Human Resources portal that would enable them to set up employee profiles and gain access to eligibility management tools, Carrier data exchange, Online billing tools, and Real-time enrollment statistics.
Responsibilities:
- Gathered and documented business requirements for existing and future business systems.
- Acted as a liaison between business staff and technical staff to articulate needs, issues and concerns.
- Analyzed business process flows to develop workflow specifications for migration to a new operating model utilizing Centers of Excellence.
- Analyzed trading partner specifications and created EDI mapping guidelines.
- Played key role in data mart design and prototyping and are involved in developing/validating source target mappings and transformation logic required to support information requirements.
- Used MS-Visio for flow-charting, process model and architectural design of the application.
- Determined pension earnings based on numerous definitions, and calculate multiple sets of benefits, based on provisions of pension plan document. Interfaces with Microsoft Excel spreadsheet to determine Social Security benefits. Produces summary displays of all calculations, and prints detailed reports of calculations.
- Managed, migrated and documented the development environment of pension administration package.
- Worked closely with the data warehouse development team to ensure user requirements and issues are being addressed while controlling scope.
- Experienced with ETL processing methods, underlying data warehouse data models, security, and capabilities of the front-end delivery products vertical
- Responsible for database design & development using PL/ SQL including conceptual, logical, and physical data modeling and an understanding of core database structures.
- Worked with ETL tools like informatica, data analysis and data mapping.
- Implemented RUP recommended visual models to draft business requirements by using Use Cases.
Environment: Data warehousing, MS Visio, MS Project, UML, Informatica, PL/SQL, Clear Case.
EDUCATIONBachelor of Engineering in Electronics and Communications