Summary

• Project Management including Agile/SCRUM and Waterfall methodologies as well as work with business/stakeholder owners and IT to create appropriate implementation plans and leverage PMP based best practices within various vertical industries including Healthcare, Retail, Real Estate (including being a licensed broker in Florida), Utilities, Manufacturing, Corporate Financial, Government as well as other business sectors. In - depth Business Analysis in both Agile and Waterfall SDLC environments. Corporate and Facilities Management experience. QA/Testing planning, management, and execution with all testing cycles.
• Experience in both business functional and technical roles with a variety of large scale applications and ERP products including but not limited to Oracle Retail(Retek) Versions 14, 13, 12, 11, 10.1, 9.0 and 8.03 RMS, RA(Allocations), RPM, ReIM, ReSA, BPEL, SIM, MFP, IP, RWMS, RDW/AIP/RPAS, Replenishment, RIB, etc. HBOC HealthQuest, Metagon CSP, Plus 2000, FIS2000, D&B/GEAC financials, Arthur Planning, EDI, HIPAA, Oracle MDM(Meter Data Management) and CCB(Customer Care and Billing).
• Experience with SDLC/Full Life Cycle Analysis, Data Warehousing/Data Architect, Application Designer/Developer, Business Architect, Business Analysis and Process Review, JAD Sessions, Data Modeling, Functional Modeling, Process Modeling, Confidential Analysis, Data Mart design, Project software implementation, Business intelligence KPI, Metrics and Reporting solutions.

TECHNICAL SKILLS

Languages: PL/SQL, ANSI SQL, SQL*Plus, Pro*C, PL/1, UNIX shell, Crystal Reports, REXX,(BAL)Assembler AcuCobol, AcuScreens, COBOL(Micro Focus, MBP, RM, IBM), RPG, IBM Assembler, PL/1, CICS/VS command & macro level, IMS/DB/DC, DL/1, C++, PCS/ADS, DMS, CANDE, SQL including T-SQL, HTML, JAVA, Power Builder, EJB, Oxford Systems UFO, Python, AWK, Perl, Datamerge, Progress, DCL, Solis, Dylakor DYL280(Now CA VISION Results), Quikjob II & III, FOCUS,, Access, Paradox, Visual basic versions 5 & 6, ISAM, VSAM, DB/2,, Cross Access CSP, Metagon ODBC middleware and ETL product, HL7 interface products such as Hublink, Datagate, CAI, and Cloverleaf, SAS, Easytrieve, Mark IV, Imagine, ASAP as well as other report writer 4GL tools, MUMPS, DATABUS, Medi-Tech menu system and conversion data formats.

Applications/Tools: SeeBeyond E*Gate, IBM WBI/MQ Series, Together J(RUP) Test Case Tool, Clarity, Primavera, Autosys, Inprise App Server, ANT, J2EE, PL/SQL/Oracle developer tools, Service Now, SFTP, TCP/IP, TIVOLI, TOAD, SQL Developer, Microsoft SSIS ETL and Administrator Console, SSRS, TFS(Team Foundation Server), PVCS, Subversion, Crystal Enterprise, MSA Payroll, GEAC financials including payroll, Microsoft Office, One Note, MS-Project, Word, PowerPoint, Excel, Front Page, Lotus 123, JBuilder, Remedy, Visio Professional, VI Editor, TSO, SPUFI Utilities, Informatica, JES, X-EDIT, K-EDIT, Multi-Edit, UltraEdit, IMRA, FTTSO, & INDFILE, JOBTRAC, Datastage, Endeavor, Panvalet, Librarian, Power, CA-Zeke, CA-7, Appworx, MQ Series, Intertest, Smart Test, SharePoint, BPEL, Teradata SQL assistant, Business Objects WEBI 3 and DESKI 6, Microsoft BI/SSRS/SSIS, SQL Server Management Studio, Oracle OBIEE, BI Xpress, HP Quality Center/ALM, Service Center, Control M version 9, Service Core, Cognos, Qlikview, and various other applications and tools.

Databases: Oracle RDBMS (7.3-12c), SQL Server including through version 2014, Essbase, DB/2, MS-Access, Infos II, Informix, Vision ISAM, IMS, Teradata, Progress, IDMS, MySQL

Case/ETL Tools: Oracle Designer, Metagon, ETL, Microstrategy, QMF, SPUFI WBI/MQ, DataStage Director, Dataflux dfPower Studio 7.1 and 8.0, Embarcadero ER suite, etc.

Operating Systems: Windows including older desktop versions through versions 7, 8.1, 10, Server versions NT through 2016, X-Windows, HP-UX, DG-UX, UNIX, AIX, OS/2, AOS/VS DVS, DOS/VSE/ESA, MVS/XA/ESA, OS/390, NCR IMOS/V, Convergent Technology, CTOS, BTOS, Netware, XENIX, RPS, VM, AS400, LINUX.

Hardware: Intel, Compaq,Hitachi, IBM, HP, Data General, Unisys(Burroughs), Convergent Technologies, Datapoint., IBM Risc 6000, IBM AIX systems, HP-UX, DG-UX, Dell.

PROFESSIONAL EXPERIENCE

Oracle MDM CC&B Test Senior Project Specialist/Analyst

Confidential, Orlando, FL

Responsibilities:

• Contract senior project analyst and support specialist responsible for operational testing and troubleshooting software implementation of Oracle Utilities Customer Care & Billing (CC&B) Linux based application including monitoring and problem resolution with applications and tools including but not limited to, BMC Control M, WebLogic, Perl, Shell and Windows scripting, Oracle MDM and CCB batch control software, SQL Server 2014, Oracle Databases, Cognos reporting suite, etc. Responsible for coordinating directly with key business and application implementation partners. Responsible for detail operation/functional testing of batch system including (SIT, SYSTEM, UAT, PERFORMANCE, PRODUCTION/E2E Simulation). This includes use of HP ALM/Quality Center for defect management and testing execution facilitation. Also provided job scheduling enhancements, data base analysis, performance execution statistical reporting including generation of export files and Qlikview web reporting, and building of batch processing alerts and notification email rules, Provided project liaison efforts with cross functional application, project management, and business teams.

Oracle Retail Version Lead/SME/PM

Confidential .Pleasanton, CA

Responsibilities:

• Provided Agile framework based business owner and IT stakeholders/directors with project planning, management and strategy including MS project plan updates associated with milestones, schedule and budget. Used Clarity project tracking tools.
• Provide test functional and technical direction for full integrated Confidential footprint and Oracle Retail V14 upgrade validation including conversion data, supply chain orderings, inventory management, store inventory application, store real estate setup, pricing, stock ledger/financials, including integration to Oracle EBS G/L, A/P, pricing and promotions processing, sales (including Ecommerce XML sales integration), sales audit posting, POS transaction integration, foundation data (items, sku, hierarchies, locations, etc.) for the Europe as well as China/ASIA specific store and supply chain divisions of Confidential . Coordinated and provided direction and expertise to onshore and offshore Infosys technical and testing support teams on test validation requirements and performed detail data result validation. This included direct involvement with testing automation including point to point controls utilizing various tools such as DataStage, Load Runner/HP ALM, and Oracle SQL automation tools.
• Responsible for validation and requirements on key SOX IT controls for interfaces and intersystem connectivity.
• Also developed business analysis BRD/user story documentation and process documentation, provided business teams with presentation material on both the Europe application changes from V12 to V14 and Asia V14 release level changes and participated with in house IT team and business teams with detail UAT testing criteria as well as business with testing executions status and information for strategic signoff.
• Also performed technical validation on LDAP based security attribute changes to support specifically Oracle Retail SIM V14 single sign on including review of V12 existing user attributes to V14 required enhancements as well as detail testing/validation of custom built UI maintenance web based solution provide to Confidential by PWC. Coordinated between PWC external resources and Confidential internal resources validation efforts and defect issue resolution. Participated in management leadership team status and planning update session. Also coordinated data testing validation and review of EDW data from Oracle Retail to internal Teradata solution.

Oracle Retail Technical Director/PM

Confidential, New York, NY

Responsibilities:

• Provide technical/project management and leadership as the interim application director over global domain based RPAS (MFP,IP) application, Arthur planning application, JDA Manugistics and in-house developed ETL SQL Server based translation database/application. Manage technical team of both onshore and a pool of offshore resources with 10+members. Responsible for creation and maintaining of global planning initiative projects including master and metric data conversion and supply chain planning inventory demand application enhancements multi-million dollar projects. Also provided day to day production support and management. Worked with technical team on RPAS version upgrade from 13.2 to 13.4 using classic client.
• Coordinated with business functional teams and business stake holders to drive international channel realignment and excess inventory projects including doing detail business functional analysis and create as well as review and approve BRD documentation for the technical team to use for detail technical design.
• Also coordinated with outside offshore contract vendor to schedule and manage technical resources and provide key project status reporting. Functioned as primary single point of contact for cross functional teams, vendors and technical teams. Performed hands on technical tasks including UNIX scripting troubleshooting/modifications, RPAS utilities execution, database/SQL query activities, client installs, disaster recovery failover, RPAS configuration tool changes for existing domains, rules, hierarchies, etc. Utilized project management/dashboard status tools including Microsoft Project, DAPTIV, and Rational as well as Service Now for IS service request/change request. Coordinated SOX compliant software release number assignments and software change requests. Also provided assistance with business requirement documentation/review and technical documentation/review.
• Developed Agile MS project plan and Excel supporting project metrics on .NET development web UI specific in-house developed front end tools for inventory and supply chain demand and allocation based upon Confidential Agile SDLC policy and practices. Facilitated business and It stakeholder status and planning work sessions, posted and track project plan updates on SharePoint, reviewed and maintained project and requirements documentation, planned hours and multi-million dollar budget for total development staff including onshore and offshore resources of 10 resources. Maintained relationships with downstream and IT leadership team for the overall day-to-day management of the project. Was responsible for overall project and to keep project objectives and tasks on track and worked to mitigate any project scope creep, required scope change with change management reporting. Held daily development and test team status meetings. Held periodic leadership team meeting status and issue/risk identification and mitigation sessions as well as executive level project presentations and executive level project status power point presentations. Created test plans and coordinated test activities including, unit/system testing, integration testing, and UAT testing. Responsible for application enhancement production planning/roll out. Technical environment included SQL/Server 2012, Visual Studio 2010 including TFS source code management, Oracle 11i,, Oracle 10g, IBM AIX Unix servers. Windows 7.

Confidential, FL

Lead Data Architect

Responsibilities:

• Provide SME(Subject Matter Expertise) on Oracle Retail(Retek) suite applications design including store operations, real estate, and back office for version 13.1 and data architecture, Agile project management and translation direction on Oracle Retail suite primary operational data into format of existing EDW structure that is being converted from an AS/400 - DB2 based Evolution/Intrepid based application including ERP implementation full SDLC EDW integration project plan and resource coordination. Also involved with evaluation/pilot of leveraging OBIEE reporting tools against Oracle Retail suite as potential EDW reporting solution. Also provided direction and design of additional business required information as a result of the integration of the existing EDW and the Oracle Retail ERP implementation for long term future EDW reporting need including development of overall project plans and business reporting requirements documentation including heavy use of MS Project, Excel, and Word, Primavera including use of Primavera for change management tracking and documentation.
• Provided business and technical design for long term strategic future EDW reporting needs including business analysis, functional designs, data translation/mapping documentation, alignment/design of master data management dimensional data with required metadata for EDW technical team to create new structures in the EDW leveraging SQL Server ETL SSIS to build required information into the EDW. Also provided business analysis, and direction on the integration of additional Ecommerce and warehouse distribution ERP data to support business functionality and reporting. Jointly worked with various business key stake holders, business analyst and BI analyst on operational and analytical reporting requirements including adherence to SOX compliancy and controls. Worked directly with senior and executive management on key project issues and was directly involved with working with PM program management. Provided a primary liaison communication role between the data services/bi team and the primary Oracle Retail integrator, OLR Retail. Provided strategic direction on key technical system interfaces related to the follow of data between POS based systems, supply chain applications, Oracle Retail suite and EDW data integration including data architectural design and recommendations for the enterprise data warehouse data enhancements necessary to leverage business needs from additional Oracle Retail based information not originally carried in the EDW.
• Also facilitated SCRUM project status tracking and daily sprint meetings and cross team assistance with developers on resolving issues as well as working with the business various resources to clarify and aide with the creation of proper requirements to facilitate development and testing activities. Provided production implementation project planning, budget, resource and timeline planning.
• Directed activities of other data analyst and technical staff of 11 team members who provided specific mapping and metadata activities for EDW and operational reporting design and development. Coordinated change management project related activities.
• Directly involved with reviewing data results in EDW applications as well as data required for BI report validation. Specifically created the QA testing data validation plans, test cases and detail test scripts for the unit, system, UAT and performance, and production validation as well as the incorporation of Unix and Windows based test automation scripts and tools including Oracle Retail utilities and HP tools. Coordinated with the in-house QA team providing validation results and technical details for development issue resolution using Microsoft Excel for test cases, result, defect, and metrics reporting. Directly responsible for operational report testing and validation. Also worked with the in-house data architect on providing key direction on data points on existing Microstrategy analytical reports.
• Created project level business report data element definition online reference documentation and created primary data dimension and metric data dictionary online SharePoint based information as well as created EDW data model documentation.
• Key applications and databases integration into the EDW included planning Essbase data structures, translation of Oracle Retail information and integration between it and EDW. Jointly worked with and facilitated key design and project activities with various business key stake holders, business analyst and BI analyst to drive the strategic direction on operational and analytical reporting requirements including BI key metrics, BI tool options and overall BI integration including SharePoint report publishing strategy with Oracle Retail ERP solution specifically the direction and strategy on providing operational BI Xpress and MS SSRS reporting leveraging the Oracle Retail Suite application data in key business and financial areas.
• Provided technical set up an installation of MS SQL Server Oracle OLE client in SQL Server 2008/2012 environments including production EDW server using Oracle 11i based 32 and 64 bit clients. Technology working environment includes Oracle 11i, HPUX, Windows based operating systems including 2008/R2 servers, SQL Server 2008 & 2012 including Management Studio, SSIS, SSRS,OBIEE, BiXpress, MicroStrategy, SQL Developer, Office 2010 suite, AS/400 DB2 table tools, Appworx scheduler.

Confidential

SW Michigan Project Lead - Overlapping Remote Project

Responsibilities:

• Performed SDLC project planning including resource requirements to meet budget constraints, business functional and and data design/planning for interface/ETL transformation of Healthquest mainframe application data including patient electronic medical record, patient demographic, visit and encounter information, ICD10 diagnostic information, account billing and insurance information, basic clinical visit information.
• Lead and coordinated team of 5 consultants for data translation and conversion between Healthquest platform, Unix Cloverleaf interface engine ETL layer and AS/400 Iseries HBOC Series 2000 platform including responsibility for HIPAA data translation compliancy and EHR data translation.
• Created overall point to point system integration testing and UAT testing plans as well as drove coordination of defect tracking and resolution.
• Worked with business stakeholders on identifying key data elements for translation between systems as well as testing requirements and production implementation plan/requirements.
• Performed direct Cloverleaf development tasks on interface ETL layer including building all data transformation processes and translation tables.
• Healthcare physicians practice management demographic, clinical/ electronic medical record (EMR)/ electronic health record(EHR) documents/imaging, and financial conversions into a Windows Progress database software application called Intergy.

Confidential, Tampa, Fl

Senior Business/Data Conversion Project Lead

Responsibilities:

• Provide analysis of third party POMIS applications based upon HIPAA compliant business rules and application data definitions to facilitate extraction into a standard conversion file format and then import the information into the Progress database based Intergy physicians practice management software for standard patient demographic, billing, visit encounter data, ICD10 and clinical diagnostic, and EHR data including clinical imaging information. This includes analyzing third party applications with various data structures from other vendor third party applications like Eclinicalworks(ECW), McKesson C-tree based Practice Partner application, Cerner practice management/EHR Oracle based data, Cerner office EHR MySQL based data to determine approach to extract, transform into a proper format for conversion into the Intergy application. In addition, also perform conversion extract and corrections efforts on a number of in-house company POMIS applications such as Medical Manager, MENDS, Medware, etc. into the conversion formats required by Intergy. Also develop the actual custom data manipulation code to transform the data into the proper formats and/or to correct issues with standard data extracts on data that causes issues during the conversion load process. Various tools and languages were used including Python, AWK, Perl, Access (2003,2007), SQL, and Unix related standard tools. The platforms where combination of Unix, AIX, Windows Servers, LINUX.
• Developed full SDLC strategic system conversion process and detail task waterfall methodology MS project plans with overall integration timelines in conjunction with primary product implementation project manager and also ensured that HIPAA requirements were followed as a part of planning efforts. These efforts included the specific test plan development for initial unit and system testing of profile level data testing and UAT validation as well as mock go-live QA testing activities. Also performed final production implementation execution of data conversions and monitored user production acceptance of conversion data.

Lead Business/Data Analyst/SME/Project Management

Confidential, FL

Responsibilities:

• Provide SME(Subject Matter Expertise) on Oracle Retail(Retek) suite applications including RMS, RWMS, SIM, RPM, RDF/RPAS and Allocation for data/business rules analysis and design on Oracle Retail critical data. Provided mapping, data modeling, and design information on field level data to transform and load into the existing Confidential D3( Confidential Data Difference) Teradata third normal form type 2 enterprise data warehouse solution to support mission critical business reporting. Coordinated activities and provided direction to Confidential analyst team and data architecture team. Participated in detail field level mapping design, business usage rules, SOX data and integration controls, reporting design, business design, master data management, and data modeling support for the enterprise warehouse solution.
• Also created key deliverables for the full SDLC project plans with the project management team including aiding with timeline management and project scope change estimates. Used Confidential standard LCM documentation for creation of required designs and project documentation and stakeholder specific project documentation as well as provide additional mapping standards through the course of the project. Provided liaison communications between the teams on key deliverables as well as project coordination efforts between business, IT, and strategic management.
• Deeply involved in Business Objects WEBI universe design and Crystal Report design/utilization. Participated in the overall reporting design efforts with key IT directors and facilitated design joint application development review sessions and designed the project level reporting template logical mapping and working with the business ownership team on efforts to map to physical data elements.
• Developed EDW data validation and user report validation test plans using HP Quality Center application and also HP test utilities for automation as well as Dataflux tools for automation of data testing and validation including execution and alerts with record counts and data pattern and sampling validation. This included test case and test scripts as well as posting and monitoring of execution associated defects.
• Acted as a subject matter expert for the Oracle retail suite to facilitate the development and validation of mission critical business reporting. Performed analysis on some existing ETL processes for the data warehouse for integration of Oracle Retail data. Also designed and developed key information SQL and reports as well as maintained reporting data mapping metadata information for the reporting project.
• Was the project implementation manager on in-house custom Sales transaction Log (TLOG) migration from existing Informix platform over to Teradata platform responsible for the overall MS project timeline and resource planning and associated change management tracking.
• Also for all project related activities above, Also was a part of the final roll out and go-live implementation activities and post go-live support including providing both functional and technical assistance in issue incident resolution. Utilized Service Center tool as the primary tracking of production issued.
• Provided analysis and conversion translation assistance with existing Merlin mainframe COBOL based application data in a DB2 database environment including transforming the DB2 data structures and reviewing Cobol code to determine data extraction formats to translate into the Teradata. Also provided conversion translation analysis and assistance as well mapping/design from Essbase department level planning application.
• Used a wide variety of technology and tool sets including Oracle Retail application GUI, TOAD, Teradata SQL assistant tools, Datastage ETL, Dataflux dfPower, Informatica, Studio data analysis tools, Office software tools, SharePoint, Office Communicator, Oracle 10g forms and reports, Embarcadero ER suite, Business Objects WEBI 3.1.Provided systematic data validation tools for test result validation between source Oracle Retail data and target Teradata warehouse repository.

Senior Business Analysis/Project Planning

Confidential, Clearwater, FL

Responsibilities:

• Provide senior business analysis and project management assistance utilizing Agile methodologies on the Confidential Oracle Financials 11i clerk implementation project.
• Specifically held JAD sessions for county wide departments capture information on the “AS IS” current state business process documentation and analysis on the “TO BE” future state process model as well as Confidential analysis. Directly responsible for process flow and RUP based use case documentation creation on the Fixed Assets, Accounts Payable areas within Procurement and General Ledger financials. Analysis included determining the transition requirements from the existing various operation areas use a wide variety of systems and technology including such financial systems as GEAC, Oracle, APPX, and Maximo.
• Provided the client with direct assistance with long term project plan, change management, and documentation standards. This included overall budget allocation to business process and resource time planning with IT stakeholders, B/A resources as well as integration of business stakeholder and direct report team member time allocation for the numerous working sessions required to review internal existing business processes and to identify opportunities to realign processes for the Oracle EBS ERP implementation.
• Provided direction planning with the internal senior project management team. Planning included providing testing approach and plan documentation.
• Provided direction, recommendations and process documentation for CM Oracle Retail code migration procedures, project environment footprint documentation and associated change management processes for ERP code implementation. Coordinated and provided direction on initial build of RMS base code build into PVCS source management system. Design full application environment migration strategy and process. Also worked with migration and integration of code roll out into Autosys scheduling solution.
• Partnered with Integration firm with CRP review and finalization. Developed project resource estimates, statements of work, budgetary estimates, and technical design/development project plan for Confidential legacy transition. Also created development standards documentation. Created high level technical approach on conversion execution. Oracle Retail applications involved were RMS, WMS, ReSA, OPOS, RPAS/AIP.
• Directed and designed key business processes and jointly developed overall business process documents on Allocations, Inventory Optimization and Replenishment. Worked with both internal resources as well as Accenture and Oracle integration partner resources to build a collective business process to support the organization and make best use of Oracle Retail software related to IO, RA, AIP and RMS, replenishment.

Confidential San Bruno, CA

Test Phase Lead/Project Management Planning/Planner

Responsibilities:

• Directed/Aided with Planning on several phases of RMS/RIB/Integration Layer and DB2 based Legacy Retail application for Confidential in an Agile methodology project environment. This included test case development test scripting planning, project sub/process planning/resource planning, test execution, coordination of development problems with software implementation and defect bug corrections and code delivery.
• Main responsibilities are in the areas of full testing including test automation and implementation on the Legacy/MQ/WBI/RIB, Tivoli Alerts and SOC integration application controls for Conversion and Integrated testing areas of the RMS product implementation as well as primary resource for the conversion roll out testing and planning.
• Responsible for all aspects of conversion strategy project planning and roll out. Also provided complete support on testing/design activities with Oracle based ODS (Operational Data Store) for corporate reporting repository using Crystal Enterprise for web based reporting including code review and defect assessment on reporting and repository issues. Performed Phase Lead activities on Conversion, Parallel, and Mock Conversion testing phases, Infrastructure failover and business continuity planning testing as well as Execution and Configuration/Defect QA management duties on Integration Phase. Lead/Project Management responsibilities included high level management activities as well including daily and weekly status reporting to executive leadership team, project and milestone review and forecast, test team resource day to day activity direction, etc. which included the financial retail stock ledger integration/development into the Oracle 11i financial platform.
• Provided development team management on phase 2 implementation project of Oracle Retail stock ledger financials to Oracle financials(AP/GL) interface development project implementation.
• In all management roles led teams of various sizes up to 30 team members. Responsible for project budgets between 5 and 8 million dollars on different phases of testing as well as full development/implementation and was responsible for all risk trend reporting, issue resolution and executive level project status reporting and IT SOX compliance.
• Also responsible for the development of environment shakeout testing execution plans. Drove the data to day resource execution and MS SharePoint based project planning activities. Also controlled all of the environment specific issues including code control and migration of code related to defects. In addition responsible for management of all open defects and driving defects to resolution, reporting of phase defects in daily cross team review status meeting, working on definition of defect processes, etc.
• In addition worked in a lead capacity with the Retek RMS and Crystal reports training environment set up and logistics. These tasks included but were not limited to, Project Implementation Plan development and presentation to key stakeholders, IT and executive management, requirements development, technical environment set up and facilitation, database set up issues for Training use including mining, modeling, back up/recovery planning, data preparation to support the Training technical courseware being developed. Also assisted courseware resources on requirements from data and software application standpoint to aid with the development of the training courses.
• Supply Chain areas encompass, Foundation(Hierarchy, Items, Orders), Inventory Movement, including DC transaction EDI processes primarily 947, 861, 856, ZPT format handling, Sales, Allocations, Shipments, etc.
• Provided technical break/fix support, RMS and RIB technical implementation assistance, troubleshooting both Retek and Legacy code problems which included a combination of COBOL, Mainframe JCL, SQL, PL/SQL, Pro*C, Unix Script, Oracle Forms, Crystal Reports, Datastage ETL and ESP batch scheduling tools. . Testing phases included Conversion, Systems and Integration, Mock/Roll Out Conversions, Parallel Test, Production Roll Out, and Unit Testing.
• The technical environment is a combination of Oracle/RMS/RIB Retek version 10.1.1(Pre 11 release), Oracle Financials 11i, Legacy MVS/TSO, COBOL/II, DB/2, IMS, CICS, MQ Series, WBI middleware Interface Integration Layer, DataStage ETL, SEE Beyond E*Gate JMS, Retek RIB, Tivoli Alerts, ESP. Use a wide variety of technical tools in providing the services for this client.

Confidential Columbia, SC

DB2/EDI Claims system analyst

Responsibilities:

• Providing Design/Specification, Development and Project Lead on HIPAA claims EDI DB2 and IMS based enterprise server system using various formats 835, 837, 821, X.12, etc. and various types of data including insurance and billing, patient demographic, HER, visit and encounters, diagnostic/ICD9 information.
• Provided business requirements gathering, functional, and technical design on operation reports utilizing Retek version 8.03 RMS,RPM,ReSA applications as bundled in old version. Co-founder and designer of in-house custom reporting data mart. Worked directly with business users and stakeholders on critical reporting needs and development/testing issues. Acted as a development lead and project coordinator as well as functional testing lead providing test planning support and documentation. Worked with various products including Oracle Forms, Oracle Reports, Autosys scheduler, TOAD, Cobol/II, JCL, AIX/Unix Shell Script.
• Provided direction, development, and support on Surgical Suture testing and tracking system for both the Texas and New Jersey processing centers. This included full system testing and QA review. The company is FDA regulated which required strict QA and security were included in the efforts which accounted for HIPAA compliancy.
• Provided project management on development project including timelines, deliverables and coordination with in-house technical staff working on the project of cross systems CSP between Mainframe platform and Oracle HP-UX based system. Also included integration of other in-house Oracle financials and LIMS manufacturing systems design and development.

Confidential, Charlotte, NC

Report Team Project Lead/Analyst

Responsibilities:

• Provided data mining and modeling On Retek RMS and RDF version 9.0 for reporting system development and mainframe data conversions. Provided business analysis and gather requirements and created design specifications. Provided both retail Retek RMS reporting systems design and Oracle application design, development, and data modeling support for various Business units. Provided QA and development assistance on initial joint FDS and Retek project to create the initial Allocations product.
• Data Mining and Modeling On Retek RMS and RDF version 9.0 for reporting system development and mainframe data conversions.
• Design key reporting summary tables to support major reporting for transactional-based data system tables with as much as one billion rows of data over hundreds of tables.
• Business Analysis resulting in efficient requirements and design specifications, providing both retail Retek RMS reporting systems design and Oracle application design, development, and data modeling support for various Business units.
• Providing direction, supervision, to contract developers, data mining and programming support to the Reports Development Teams.
• Performed Project Management duties including organized team meetings, team building, training, project planning, tasking, and reporting status as well as detail activities to key senior IT management, business team management, and outside consulting company management members on a regular basis.
• Developed reports in both Oracle Reports and Active Reports(VB 6.0 based application) using Visual Studio and SourceSafe. Also, did some Crystal Report before migrating to Active Reports.
• Business requirements gathering and coordination with key business unit directors, associates and executive management.
• Production reporting team implementation, support and tuning.
• Developed Full Project management status tracking database with full estimated time remaining on development tasks by each report and budget reporting in Microsoft Access. This included about 20 different summary and detail tracking reports for management use.
• Joint development and QA with Retek vendor on new web based Java EJB based Allocation system including Together J(RUP) Rose base test case design processes.
• The System environment includes Unix, Oracle 8i RDBMS, Oracle Reports 3.0, SQL, PL/SQL, Visual Studio/Visual Basic, Access, X-windows, Windows NT, Appworx, Java, EJB, Inprise App Server.

Confidential

Senior Consultant and Project Management

Responsibilities:

• Provide full life cycle project management and coordination on a number of proprietary and vendor system Y2K upgrades as well as system conversion on both Unix and Mainframe systems. A wide variety of applications were used including HealthQuest MediPaq, Clinipaq, IBAX Series 5000, Medi-Tech, IBM PM/PA, Series 2000, HealthQuest 2000, FIS2000, and other database healthcare applications on a variety of database and file systems including VSAM, IMS/DB/DC, IDMS, DB2, Oracle, INFOS/II, RDMBS, Infomix, Btreve, early versions of clinical document EHR applications, etc. Also performed Y2K upgrade and retrofit on in-house developed mainframe SAS reporting and data extraction processes.
• Performed project management, analysis, design, and development with a variety of EMR(Electronic Medical Record) applications including interfaces between various applications including Invision, HealthQuest, Plus 2000, Code - 3, ECLIPSIS, IDX, Medi- Tech, FIS2000, PM/PA, IBAX/HBOC Pharmacy Application, Clinical Care Order Processing and Results application.. (IBAX/HBOC Company now part of McKesson).
• Provided many systems and application development and design tasks both on a full and part time basis for numerous clients across several different platforms including full integrated healthcare systems as well as financial systems that included (Payroll/HR, A/P, G/L, Fixed Assets, Inventory, Material Management).
• Provided project planning and project management for a number of clients including for new system implementation and conversion/development projects. Major healthcare system conversion and redesign from DG/Cobol to Unix based AccuCobol system using Informix DBMS.
• Performed technical software internals conversion to allow application product upgrades on mainframe systems.
• Provided full design, development and implementation services for system integration interfaces and conversions using a wide variety of protocols, tools, middleware including but not limited to CAI Datagate, Hublink, Cloverleaf, IBM MQ Series messaging integration system, TCP/IP, serial ASCII/EBCDIC protocol black box converters, SNA, point to point, terminal interfaces, printer slaves, AS400 platforms using both Cobol and RPG, etc.
• Responsible for regulatory requirements review, implementation, design, team planning, etc. in various areas such as EDI 831, 835, 837, etc., Electronic billing, HIPAA, Medicare, DRG, APC's, HFCA requirements, state and local demographic and patient information reporting to governmental and private agencies, welfare agencies, etc.
• Analyzed, Designed, and Developed custom applications and software upgrades on several application areas including patient billing, all payers, Medicare, Medicaid, private insurance, HMO, workers comp, etc. Also areas such as medical records patient registration/ADT, Case Mix, DRG,Plan Reimbursement, electronic processing, financials including accounts payable, payroll/hr, inventory, general ledger,etc.
• Responsible for installing and implementing new vendor software applications.
• Responsible for planning, managing, designing, developing, and performing numerous system data conversions and data interfaces across platforms using a wide variety of file systems
• Responsible on various process re-engineering efforts to coordinate changes in business practices in concert with system designs and enhancements to provide optimal staff efficiency.
• The development platform included DG-UX, Windows NT, Oracle RDBMS, Access, PL/SQL, Medi-Tech, IDMS, Mainframe SAS, IDX Mumps, MVS/ESA, Cobol II, RPG, DCL, SOLIS, CICS/VS, IMS/DB/DC, DB2, Informix, Unix, RM-Cobol, AcuCobol, JCL, Script, Proprietary interface languages, EDI, HL7, Paradox, Visual Basic, DG-Cobol, PL/1, Assembler language, BMS/SDF, VSAM, AS400's, DG ECLIPS systems, DEC, PC’s, Windows, etc.
• Some major clients were Spectrum Health Systems, Tallahassee Memorial Hospital, Manchester Memorial Hospital, Kings Highway Hospital, Loma Linda Medical Center, South Hills Medical Center, ORMC(Orlando Regional Medical Center), Boston University Hospital, IBAX(a partnership of IBM and Baxter Intl.), HBOC, Medical College of Virginia, Iowa Health Systems, Global Software, Centra Healthcare, Beth Israel Hospital.