SUMMARY

• Over 15 years of IT experience in Software development lifecycle SDLC doing systems analysis, design, development, testing and implementation of projects. Lead Technical Design Analyst and Lead Data Modeler on several projects. Familiar with Agile and Waterfall methodologies.
• Experienced Business Analyst in full systems life cycle development within multiple industries: Manufacturing, Engineering, Commercial Lines Insurance, Life and Annuity Insurance, State and Federal Government, Commercial Printing, Telecommunications and Healthcare.
• 7 years focusing specifically on Business and Data Analysis using OLAP and data mining to meet business intelligence needs. Extensively used reporting tools Crystal Reports in generating reports to the business users.
• Experience in creating test plans and developing test cases to performing different types of testing and validation using several methodologies. This included UAT and Pilot testing. Responsible for designing and developing both Manual Automated tests.
• Able to assist the business user to understand complex business process. Strong understanding of SDLC guidelines when gathering business requirements. Performs effective communications and expectation setting.
• Experience at preparing business documents UML such as Business Requirements Documentation, Technical Requirement Documentation, Entity/Relationship Documentation as well as preparing training documentation, operator's and user's documentation. Coordinated work between business units and technical staff to create, interpret, and implement business requirements into technical specifications. This has involved internal IT staff, contract/consultant 3rd party vendor staff, and off-shore teams.
• Experience in conducting meetings like Joint Application Development JAD , one on one meeting with Business Users, brainstorming session and conducting walkthrough session efficiently.
• Experienced in writing SQL queries and strong knowledge of databases. Proficiency using query tools such as Spufi, QMF, Toad, and SQL Query Analyzer. Primary Databases used: DB2, Oracle, SQL Server. Proficient in Visio, Office, PowerPoint, Excel.
• Planning, organizational, interpersonal, and written communicational skills and experience in documenting conceptual and detail designs.
• Team-oriented and focused on delivering exactly what the client needs to succeed in a timely and efficient manner, with excellent communication skills and a strong desire to exceed customer expectations.

Professional Experience Business Data Analyst

Confidential

Working with Overpayment Validation and Recovery team on implementation of new overpayment tracking system for a major healthcare provider. Performed pilot test verification of standard and non-standard recovery letters. Completed computer based training for Business Objects Web Intelligence. Data Analyst

Confidential

• Developed complex SQL statements to create reports and data files for Operations Finance, Account Management and the Customer in order to satisfy the needs associated with Billing, Forecasting, and Outcomes Reporting, Account Statuses, Disease ID Algorithm Testing and Problem Resolution. Designed processes and reporting associated with auditing the validity and downloading of the eligibility, medical and pharmacy claims data received from customer. Responsible for processing and downloading the eligibility, medical and pharmacy claims data imported from customer. Resolve data issues by working with clinicians in the call centers and various levels of the customer's organization by analyzing the eligibility and claims data received from the health plan. Worked closely with programmer to maintain customer specific package used to perform disease identification. Member of data analyst leadership team that ran a monthly data analyst team meeting. Annual HIPPA certification required in order to ensure the proper handling of the member and claims data.
• Major Accomplishment: Working with team made up of members across organization to redesign one of the programs offered to members. Developed business requirements based on identified issues that needed to be resolved, worked with account team to prioritize issues, and worked with various organizations within corporation to get needed resolution. This involved heavy analysis of claims lag timing, the use of ICD-9, CPT-4 and various NDC codes as part of the Disease ID algorithms.

Business Systems Analyst

Confidential

• Implemented a third party ERP software solution to automate print processes throughout 9 print plants. Assisted subject matter experts SME in to completing gap analysis of ERP package, developing business requirements for package customizations and creation of appropriate test plans/test cases. Worked with development teams both in-house and with the vendor off-shore . Developed detailed business and technical requirements for ETL process to receive advance shipping notes via EDI interfaces of the ERP package. Part of team to develop and implement user add/change request policy and procedures to be implemented corporate-wide in order to comply with Sarbanes-Oxley.
• Responsible for system administration and user support of the ERP package. Worked with users to define business intelligence requirements and developed necessary reports using Crystal Reports, creating customized SQL Queries within Crystal reports for more complex reporting needs.
• Major Accomplishment: The vendor software restricted the ability for material managers to see materials corporate wide. I developed a complex set of drill down reports using Crystal Reports in order to allow managers to see inventory corporate wide.
• Senior Systems Analyst

Confidential

• Financial Systems Support: Implemented Vendor software using DB2 Database to support Crystal Reports Front End Reporting system by creating a data model of the data base, working with the user to evaluate the data, developed business requirements in order to modify the system to comply with corporate data standards. Designed required functionality absent from vendor package, and provided production support for various VSAM and DB2-based financial applications. Developed code required to pull data from VSAM files into format that could be loaded into DB2 Database using LOAD and DDL functions. Worked with Financial Analysts to develop necessary SQL queries for reporting purposes.
• Enhancement Coordinator: Performed testing and enhancements on a purchased software package used to process local office checks through the home office. Worked with user community to design and develop business requirements for requested system enhancements, resulting in cost savings from eliminating legacy systems and equipment.
• Release Manager: Performed project management tasks for periodic software upgrades to client-server Point-of-Service POS system, distributing mainframe customer data to agents hand-held devices. Assisted customer support in problem resolution by evaluating data contained in customer databases. Coordinated Model Office testing that involved bug fixes, enhancements and new product Implementations. Created simple and complex SQL queries necessary to research issues and to validate test results, to build test data for UAT testing, and queries to be implemented within application.
• Major Accomplishment: By implementing vendor software project for financial analysts, report turnaround decreased from several months to one day avoiding large federal and regulatory compliance fines.

Associate Managing Consultant / Supervisor

Confidential

• State of Ohio: Created data model for state welfare system enhancement. Worked with Y2K project management to audit contractor results to ensure that contractual obligations were met.
• Commercial Advantage Project Motorist Mutual Insurance : Full system life cycle development for a rule based commercial lines administration system using COBOL II, Telon CICS, and DB2 in an IBM MVS environment. Technical team leader providing database design orientation and technical training to new team members. Developed detailed business and technical requirements documentation as well as documented test plans and expected results. Developed complex SQL queries used within application to determine current and future state of policy based in date parameter.
• Major accomplishment: Worked with project management on Commercial Advantage Project to limit scope changes from user group and still meet requirements using features of rule-based system to drive user-interface rather than attempting to retro-fit existing user-interface. Project was delivered on time and close to budget.
• Mentor Supervisor : Prepared and conducted Associate performance reviews. Served as liaison between the firm, the associate and the client.

Systems Engineer/Team Leader

Confidential

• Broad exposure developing a variety of applications within numerous industry verticals such as Federal, Automotive, Insurance, Communications and Systems Integrators.
• Developed business requirements and technical specifications, including a detailed data model for a plant floor scheduling system for Navistar Cab Drilling Project. Provided consulting services to Cellular One determining improvements in system efficiency and restart capabilities for their billing system and subsequently developed program specifications for these enhancements. Maintained and enhanced data management facility/data warehouse for General Motors Engineering. These projects involved the development of both simple and complex SQL queries in order to support development and testing efforts, including but not limited to the development of prototypes and test case applications.
• Conducted classes for EDS Quality Education System for EDS Eastern Region Headquarters. Designed contract life-cycle management system to support Federal Government accounts, acting as lead on data modeling team. Developed a data and process modeling class to the entire project team.
• Designed, Documented and Implemented software release system, establishing a corporation-wide standard for system development and implementation. Provided technical training and consulting to various organizations within corporation. Designed and Developed Base Level Systems for Plant floor system in VAX/VMS platform. Provided extensive documentation that included Application Developer's Guide, User's Guides, and Operator's guides.
• Promoted to Project Leader and then Team Leader. Responsible for project management and scheduling software releases. Responded to RPF requests with manpower estimates for product customization.
• Major accomplishment: Established user group to review scheduled releases and prioritize service requests and enhancements. Documentation provided regarding VAX Release Standards was published as part of corporate wide standards.

Software and Tools used:

• DATABASES: DB2, Oracle, Ingres, Progress, Access
• LANGUAGES: COBOL, COBOL 370, COBOL II, PL/1, VSAM, JCL, DCL, VAX PL/1, VAX COBOL, VAX Macro
• TOOLS: Toad, VAX MMS, VAX CMS, VAX RMS, VAX FMS, VAX Instal, Easytrieve, Telon, FileAid, FileAid for DB2, QMF, SPUFI, TSO/ISPF, Roscoe, Intertest, Excel, Visio, Word, Powerpoint, MS Project, Crystal Reports