SUMMARY 

• 15 years of experience in IT Analyst roles with a strong business and information systems background.
• Extensive history in working with clients, designers, and programmers to identify requirements, provide cost analysis, assist with creating user interfaces, and develop implementation timelines.
• In - depth understanding of project lifecycle, including all phases of system and software development.
• Proven track record in testing, quality assurance, and networking.
• Superior communication, presentation, and interpersonal skills.

TECHNICAL SKILLS

Programming: SQL, PL/SQL, Java, XML, SAS, C, UNIX

Applications: Microsoft Office Suite, Visio, MS Project, SAP, COBOL, TOAD, Data Mapping; Data Modeling, Remedy, HP ALM, Quality Center

Databases: Access, Oracle, SQL, DB2, Oracle SQL Loader

Platforms: Microsoft OS 7/8.1/10, Linux, Solaris, UNIX/AIX

Networking: Ethernet, TCP/IP, VPN, LAN/WAN

Methodology: Agile, Waterfall, RSA (Requirements and Solution Analysis)Detailed understanding of system development lifecycle (SDLC)

ETL Tools: Business Objects Data Services, Informatica Power Center, Oracle Warehouse Builder, SQL Server Integration Services (SSIS), IBM InfoSphere Information Server

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

Business Systems Analyst

Responsibilities:

• Project Improvement to Medicare/Medicaid Provider Directory data quality.
• Executed SQL queries and created test cases to obtain accurate data for both manual and automation testing to improve Commercial Provider Directory data quality.
• Directed efforts to improve Operational Efficiency and Reduce Administrative, Manual Efforts.
• Responsible for translating the requirements of the clients into highly technical specifications for our IT Developers and preparing mapping documents.

Confidential, Hartford, CT

Systems Analyst

Responsibilities:

• Solid experience writing and executing Business Owner test scripts, creating and delivering internal training, documenting process flows, writing report specs for data to support conversion activities.
• Agile team environment of System Analyst, Business owner, 3 Developers 3 QA resources, Scrum Master and Manager Lead for integration of Medicare Business.
• Performed business analysis activities and facilitated Joint Application Design (JAD) sessions to elicit business and functional requirements, data integration of Medicare/Medicaid Business.
• Executed SQL queries to obtain accurate data for both manual and automation testing for the Data Warehouse.
• Based on initiatives at the Portfolio level, wrote detailed User Stories, using Rally software, based on Epics with Business Owner approval.
• Some exposure to Hadoop processing, primarily for Medicare Business.

Confidential, Farmington, CT

Business/Data Analyst Specialist

Responsibilities:

• Worked with Business owners to determine data requirements specific to each business process related to Medicare Business and to identify the data requirements for the Data Integration effort and Data Warehouse strategy.
• Responsible for gathering functional requirement for EDI 834 Enrollment and 837 (Institutional & Professional) claims, encounters and adjudication.
• Performed business analysis activities and facilitated Joint Application Design (JAD) sessions to elicit business and functional requirements for data integration of Medicare/Medicaid Business.
• Activities included Data Analysis and mapping of all new data feeds, Data mining and data pattern recognition, Reviewed requirements and design documentation and checked gaps across various artifacts.
• Queried Enterprise Data Warehouse and Data Mart tables and views to pull together relevant data for various business groups.
• Executed SQL queries and created test cases to obtain accurate data for both manual and automation testing for the Data Warehouse.

Confidential, Bloomfield, CT

Business Analyst Specialist

Responsibilities:

• Specialist in requirements gathering, analysis, detailed requirements design (Cases, User Interfaces, Report Specifications, System Interfaces), workflow design, functional (Application) testing, creation of test conditions and test scripts.
• Strong analytical and documentation skills accompanied by problem solving skills.
• Involved in transformation of data, input data in outside applications and complete analysis of data.
• An eye for detail accompanied by vendor/client interaction skills and evaluating that offering with the needs of the end users.
• Team player with strong communication skills.
• Project activities included individual retiree medical and dental benefits using Agile methodology with Rally software.
• Scrum Master with team of Business owner, 5 developers and 2 QA resources.
• Gathered requirements from Business Owners allowing creation of User Stories from Epics.

Confidential, Hartford, CT

Business Systems Analyst

Responsibilities:

• Responsible for translating the requirements of the clients into highly technical specifications for our IT Developers and preparing mapping documents.
• Skillful in leading projects and project sub teams
• Worked closely with management team to achieve business goals.
• Handled the tasks of presenting proposals to clients, identifying training needs, create training materials and prepare supporting job aid documents.
• Experience with writing and executing user acceptance test scripts, writing business requirements documents, creating and delivering internal training documenting process flows, writing report specs for data to support conversion activities.
• Responsible for overseeing the system testing, quality assurance, Sarbanes - Oxley compliance and implementation of various projects.
• Presentation of logical solutions to client based on business requirements that would solve complex problems.
• Maintained, researched, modified, designed Web based Broker and Employer portals.
• Interfaced with rules engine for our Web based portals
• Designed Web based Broker Portal specifically for mobile devices - smartphones.
• Highly skilled in the Waterfall RSA methodology utilizing impact estimation table (IET), solution summary document (SSD) and administering numerous agile inspections.
• Experience with Defect Management Tool HP ALM.
• Trained in identifying new and changed procedures, creating/modifying procedure documents and assisting with crafting communications for internal and external customer communications needs.
• Solid Experience in Agile software development methodology with several Health Care Reform projects under PPACA.

Confidential, Hartford, CT

Business Systems Analyst

Responsibilities:

• Created procedures to process data, understand relational databases, maintain/update system tables, and define milestone deliverables.
• Developed, analyzed, and documented business requirements, system requirements, and testing requirements.
• Analyzed functional problems and determine techniques and requirements most feasible for addressing business problems.
• Provided group and individual training to end user for new systems and enhancements.
• Participated in various levels of testing as needed, such as Acceptance Tests, Business Analyst verification, and Quality Control for deliverables.
• Researched, designed, modified, tested and implemented UNIX shell scripts, Oracle PL/SQL procedures and functions for Oracle database.
• Maintained, researched, modified, designed Autosys scheduler boxes and jobs used for scheduling all production jobs.
• Designed, tested, implemented and maintained workflows, maps, sessions and mapplets for our Operation Data Store, Data Warehouse systems.
• Developed and implemented business object reports to track investments.
• Utilized Request Tracking System to control workflow of assigned tasks, Remedy for tracking scheduled jobs and problem tickets and Sharepoint web-based site for document retrieval.
• Handled crisis situations utilizing a message center beeper performing 24-hour on-call support.

Confidential, Hartford, CT

Senior Systems Analyst

Responsibilities:

• Wrote system specifications and produced detailed specifications for systems architects.
• Evaluated Business Requirements and prepared detailed Technical Specifications required for Technical Design.
• Secured sign off from Business Sponsor on final documentation of system requirements and supporting QA staff.
• Coordinated and conducted system analysis specification walkthroughs with Business Owners and Design/Development Team.
• Participated and supported technical application design process to ensure accurate translation of analysis specifications into technical design specifications.

Confidential, Hartford, CT

Business Data Analyst

Responsibilities:

• Defined, gathered, analyzed and effectively documented business requirements.
• Consulted with project team to identify system improvement opportunities and ensure that all solutions are adequately documented in procedures and work-flow.
• Accountable for providing technical guidance and business process expertise through all phases of the business solution development process.

Confidential, Hartford, CT

Oracle Certified Professional DBA

Responsibilities:

• Researched and analyzed business requirements to produce test plans and programming specifications for our Application developers.
• Gathered business specifications from end users and documented requirements in appropriate Use Cases.
• Created Data Mappings and Transformation (ETL) for our offshore team.
• Developed activities to ensure testing tasks were identified, estimated, tracked and completed.
• Wrote detailed specifications and developed extensive test plans using Microsoft Office Suite for a diversity of on-line and batch modules used in the development of the CT ITAS system.
• Researched, designed, programmed, tested and implemented programs/scripts written in Oracle SQL, PL/SQL, Forms, Reports on a Sun Solaris Server.
• Maintained documentation of each module on the server with Web-based file links.
• Coded, tested, implemented and maintained SAS reporting programs.