Sr Data Analyst Resume
Charlotte, NC
SUMMARY:
- Around 10+ years of experience in Requirements Gathering, Business Analysis, Testing, Implementation, Product & Domain Training and Post Implementation onsite - support
- Excellent knowledge of SDLC methodologies: Agile (scrum) & Waterfall.
- Experience in root cause analysis, gap analysis, troubleshooting, problem resolution and change management, as well as possessing extensive experience of identifying potential solutions and presenting the proposals to the client/management team.
- Collecting, understanding, and transmitting the business requirements for the project, and translating these into functional specifications along with customization of telecom software products.
- Part of technical leadership team managing the overall end to end implementation of OSS/BSS from system integration to COTS product deployment & to liaise between the customer, development team and system integrator regarding software functionality throughout the software development lifecycle.
- Extensive experience with software testing that includes Impact assessment, Requirement analysis, test scenarios and test case design, system testing, system integration testing, production verification testing, Test summary reports, defect management.
- Model driven development by capturing business requirements for process & data modeling in the form of Business Process Models (BPMs) using Websphere Business Modeler 7 (WBM)
- Utilized “As-is” & “To-be” Business Process Models at Program Level, Service specific
- Subject Matter Expert with In-depth knowledge in Fraud Management, Revenue Assurance, Service Fulfillment & Service Assurance.
- Gathered business requirements through interviews, surveys and observing from account managers and conducted controlled brain-storming sessions with project focus groups and documented them in the Business requirement Document.
- Planned and defined system requirements to Use Cases, Use Case Scenarios and Use Case Narratives using the UML methodologies.
- Created Use Case Diagrams, Activity Diagrams, and Sequence Diagrams using MS Visio.
- Coordinated with QA team to create the test approach and determine test needs, test environment, test data, resources and limitations.
- Created various Data Mapping Repository documents as part of Metadata services (EMR).
- Provided inputs to development team in performing extraction, transformation and load for data marts and data warehouses.
- Provided support in developing and maintaining ETL processes that extract data from multiple SOR's residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses.
- Helped to develop test strategies, test cases, test plans, defect reports, traceability matrices and test environments and managed the testing process, bug reporting and analysis of test results.
- Instrumental in ensuring a successful UAT with the customer.
TECHNICAL SKILLS:
Development Languages: ASP, VBScript, JavaScript, HTML, PL/SQL, C and UML
Database: Oracle 7.1, MS Access, Sybase, DB2, MS SQL Server
Operating Systems: Windows NT/9x, MS-DOS, UNIX
Application Tools: Visual Interdev, VisualBasic4.0/5.0/6.0, Developer 2000, Power Builder 4.0, Cognos
Others: DHTML, COM/DCOM, MTS, IIS 4.0, Macromedia Generator, Ad Server, Netscape, Internet Explorer, CDO NTS, Microsoft SMTP, Site Server Commerce Edition, Intelliden 4.7, Web Focus, Info Vista RequisitePro, Visio, I-grafix, HP Quality Center,Share Point, SOA, eTOM, TOM, NGOSS and Process mapping
Hardware : IBM PC Compatibles and SUN Workstations
Functional Skills: Order to Activate, Service Fulfillment, Revenue Assurance and Service Management Business Analysis/Project/Program Management Office 2007 including Visio, Microsoft Projects and UML
PROFESSIONAL EXPERIENCE:
Confidential, Charlotte, NC
Sr Data Analyst
Resposibilities:
- Interacted as a liaison between Users and the different teams.
- Involved in the application development for better understanding of the business and IT processes.
- Worked closely with SME’s to undersand the existing process and up stream departments
- Worked on the Glimmer tool to update the changes and track the traceability.
- Worked on SQL developer to validate the database tables
- Written various BRD’s for three phases and successfully completed the migration of 17 SOR’s to the new System
- Worked with Developers and tested the applications and tracked the bigs in ALM and JIRA
- Worked on Microsoft Word, Access and Excel
- All the changes were updated in JIRa for the tracking Purposes,
Environment: HP ALM, SharePoint, MS Visio, MS Project, MS Office. And Jira.
Confidential, Richmond, VA
Sr Business Analyst
Resposibilities:
- Interacted as a liaison between Users and the different teams.
- Involved in the application development for better understanding of the business and IT processes.
- Responsible for analysis and functional specifications of “As-Is” and “To-Be” business model to conduct GAP analysis in comparison to the proposed system to enhance the functionality of the application.
- Gathered business requirements through interviews, surveys and observing from account managers and conducted controlled brain-storming sessions with project focus groups and documented them in the Business requirement Document.
- Planned and defined system requirements to Use Cases, Use Case Scenarios and Use Case Narratives using the UML methodologies.
- Created Use Case Diagrams, Activity Diagrams, and Sequence Diagrams using MS Visio.
- Coordinated with QA team to create the test approach and determine test needs, test environment, test data, resources and limitations.
- Created various Data Mapping Repository documents as part of Metadata services (EMR).
- Provided inputs to development team in performing extraction, transformation and load for data marts and data warehouses.
- Provided support in developing and maintaining ETL processes that extract data from multiple SOR's residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses.
- Helped to develop test strategies, test cases, test plans, defect reports, traceability matrices and test environments and managed the testing process, bug reporting and analysis of test results.
- Worked on Microsoft Word, Access and Excel
- Tracked the progress of system testing, and provided a daily status report to the Test Manager.
- Used Test Director to house all test documentation and report/track all issues and defects.
Environment: HP Quality Center, SharePoint, MS Visio, MS Project, MS Office. Test Director and Microsoft Project,.
Confidential, New York, NY
Business Analyst
Responsibilities:
- Developed Business Flow Diagrams, Activity/State Diagrams and Sequence Diagrams using MS Visio so that developers and other stakeholders can understand the business process.
- Gathered and documented the requirements that were critical to the business mission and converted those requirements to Use Case Models.
- Interacted with the Users by interviewing them, by preparing questionnaire and getting feedback.
- Performed feasibility, adaptability study and risk analysis to identify the business critical areas from USER perspective.
- Associated change requests with requirements using Change Request Log, logged all change requests in Clear Quest and tracked and managed changes.
- Created RTM (Requirements Traceability Matrix) in MS Excel to trace requirements to Use Cases and Test Cases.
- Developed prototype for the navigation of the new interface using MS Visio.
- Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
- Documented business workflows textually as well as in UML diagrams (Activity diagrams) according to for the stakeholder review.
- Conducted requirements and Use Case reviews and walkthroughs with the designers, developers and stakeholders.
- Wrote test cases and test scripts for the User Acceptance testing.
- Worked on Microsoft Word, Access and Excel
- Designed and developed Use case, Activity diagrams and Sequence Diagrams using UML tools with MS Visio.
Environment: MS Office Suite (Word, Excel, Access, PowerPoint, and Outlook), MS-Project, MS Visio
Confidential, Chicago
Sr Business Analyst
Responsibilities:
- Conducted Joint Requirements planning sessions (JRP) as a facilitator to gather requirements from the Business User and conducted many Joint Application Development (JAD) sessions.
- Worked closely with the UI/front end design team to model the screens, and wire frames which met user, defined requirements and also company standards.
- Extensively interacted with the QA Team in executing the Test Plans, Providing Test Data, Creating Test Cases, and Issuing MR upon detection of bugs and collecting the Test Metrics.
- Defined validations to be built into application in line with the functional requirements.
- Participated in meetings with Developers, Project Managers and Quality Analysts to discuss business requirements, test planning, resource utilization, and defect tracking.
- Developed flow diagrams fro as-is to to-be
- Documented Sytem Requirement Specifications
- Document Traceability Matrix
- Conducted requirements and Use Case reviews and walkthroughs with the designers, developers and stakeholders.
Environment: MS Office Suite (Word, Excel, Access, PowerPoint, and Outlook), MS-Project, Share Point, Visio, Oracle.
Confidential, Chicago
Sr Business Analyst
Responsibilities:
- Conducted GAP analysis to regulate the gaps in the requirements and conveyed to various modules of the project.
- Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level.
- Prepared Workflow diagrams to analyze AS IS and TO BE scenarios, designed new process flows (re engineering) using MS Visio and documented the business process and various business scenarios.
- Facilitated collection of business requirements from business users and preparation of business requirement documents using MS Visio.
- Documenting detailed description of user needs, steps required to develop program and also to modify relevant program.
- Worked as an Interface between the end users and the different teams involved in the application development for the better understanding of the business and IT processes.
- Prepared training manual for application user and conducted power point presentation for trainers.
- Defined validations to be built into application in line with the functional requirements.
Environment: Oracle 10g, PL/SQL, SQL*PLUS, Jira, Sub Version, UNIX.and MS Visio
Confidential, Austin, TX
Sr Business Analyst
Responsibilities:
- Performed business process study of existing application and standards used in legacy system Amisys.
- Worked directly with the end clients to understand business processes, data compliance, current gaps and desired improvements.
- Performed Scope identification and prioritization for the project to migrate to HealthRules.
- Facilitated sessions with IT development team to understand HealthRules capabilities and how to effectively document requirements for migrating data from legacy application.
- Created current state and future state business process diagrams.
- Create process diagrams, data flows, mappings and business rules to depict the exchange of data between the two systems.
- Perform UAT to ensure all the requested functionality has been met in accordance with the documented requirements.
- Understanding HIX benefit plans (On-exchanges & Off exchanges), requirements and the format in which the data needs to be exchanged with the Client
- Compile business rules and mapping criteria between ESI and FirstCare.
- Assisted in creating test data files for the HIPAA 837/835 (Claims Processing/Claims Payment) transactions based on X12 standards.
- Documented and maintained product backlogs and sprint backlogs based on prioritization of requirements from business leads.
- Documented a list of required User Stories along with detailed acceptance criteria.
- Assisted testing team in developing end to end test scenarios and documenting test cases.
- Monitor testing activities, defect tracking and fixing.
Environment: HealthRules, Amisys, HP Quality Center, JIRA, MS Visio, MS Project, SharePoint, UML, Agile Methodology.
Confidential
Business Analyst
Responsibilities:
- Obtained business requirements with the responsible Technology & Operations departments.
- Took proactive steps to ensure Confidential Network ran efficiently and had no outages
- Documented system requirement specifications
- Developed a report for Operations, which identified the load on each SIP card resulting in increased Confidential network stability and cost effective use of current Technology.
- Worked with Amdocs Biling and Finacial Suite for biling changes and Implimentations.
- Worked with project team to gather business and functional requirements to define how Operations end-users should interact with each component and how business units must support the workflows; used functional specification to develop user interactions and end-to-end workflow in UML (Unified Modeling Language) tools.
- Documented system requirements, and performed traceability of system requirements against business requirements, test plan and test requirements.
- Designed user interface and process flow templates.
- Developed reports according to user requirements.
- The result of this project increase in the quality management of change/configuration on the IP Network that will result in savings from a reduction of re-work.
- Documented system requirement specifications.
- Developed and analyzed reports to determine case handling, escalation and resolution.
- The result was Confidential Canada enhanced/efficient the use of the N525 stand alone devices, which resulted in savings due to the reduced need for additional equipment and a streamlined the process.
Environment: Requisite Pro, MS Visio, MS Project, SharePoint, UML., MS Office, i-grafix, Oracle EDW,Data Marts and Intelliden
Confidential
Sr. Programmer Analyst
Responsibilities:
- Designed, Developed and Administered ASP (Active Server Pages) for registration of customers
- Developed ASP pages to track the # of greeting cards sent by each registered customers and to offer them free gifts once they sent 25 cards to 25 different customers.
- This design resulted in increased customer satisfaction along with additional project work for the Spanish card line.
- Created, designed and developed ASP Pages for store front, personalization and membership.
- Worked on SQL Database back end to verify the logic and ADserver for advertisements on websites.
Environment: Asp,Site Server,Visual Source Safe,SQL Server, Visual Basic and AD Server
Confidential
Programmer Analyst
Responsibilities:
- Developed on-line advertisements using Ad Server resulting in client satisfaction and increased revenue through the website.
- Participated in projects with a variety of applications such as disbursements, drafts, balance reporting, direct deposit and EFTPS.
- Specifically, developed solutions that operated in eight time zones in North America, supported the application 24/7 for any customer issues with E-Banking, developed on line security application for customers.
- Worked on real-time electronic stop payments and wire transfer requests.
- The result of this development was the ability to support the system 24/7 which reduced calls to the Customer Service department and increased the efficiency of the system for the customers.
- Backend was SQL database is used and verification is done for all the transactions.
Environment: Asp,Site Server,Visual Source Safe,SQL Server, Visual Basic, AD Server and HTML
Confidential
Software Engineer
Responsibilities:
- Coding, Testing, Maintenance and enhancement of HRIS and COPS
- Involved running the code with Signature 2000 tool for marking Y2K changes
- Developed Y2K compliance standards for all the COBOL programs and used Signature 2000 testing tool for date compliance.
- The result was that all the applications were compliant which saved considerable amount of money, resources and time for the company.
- Coding, Testing, of various Mainframe applications for GE-Air Crafts
- Involved running the code for marking Y2K changes
- Developed Y2K compliance standards for all the COBOL programs and used testing tool for date compliance.
Environment: IBM Mainframes, IDMS. Cobol, DB2,CICS and ADSO.
