Summary

• Proven Project Management, Data Warehouse, Business Analysis and wide variety of Technical Software Development as well as Excellent Communication Skills in the Healthcare and Retail sectors as well as other business sectors utilizing Agile and SCRUM methodologies. Have firsthand experience in Manufacturing, Warehousing, Mortgage, Real Estate and Financial Products industries. Currently hold a Mortgage Broker's License and Real Estate Broker license.
• Proven Corporate and Facilities Management experience.
• Proven QA/Testing planning, management, and execution experience including Unit Testing, Conversion Testing, Vendor Testing, System and Integration Testing, Parallel and Performance Testing.
• Proven skills with a variety of large scale applications and ERP products including but not limited to Oracle Retail Retek Versions 13, 12, 11, 10.1. Including Pre 11 release 9.0 and 8.03 RMS, SIM, RA Allocations , ReIM, ReSA, MFP, AIP, RTM Trade Management , BPEL, Replenishment, RIB, RDW, RDM/RWMS, RDF, SeeBeyond E Gate, Oracle Financials 11i, HBOC HealthQuest, Medipac/Clinipac Clinical Results, Plus 2000 including clinical care order management, Metagon CSP, Plus 2000, FIS2000, D B/GEAC financials, Arthur Planning, EDI, HIPAA.
• Oracle Designer/Developer expertise, Design Technical and Functional , Business Analysis and Process Review including AS IS and TO BE, JAD Sessions, Analysis, Business Requirements, RUP Use Case, Systems Analysis, Data Modeling, Functional Modeling, Data-Flow Diagramming, Process Modeling, GAP Analysis, Project Planning, Data warehouse enterprise design, Sox compliance reporting and business reporting design including tools such as SAP Business Objects WEBI, Microstrategy, Oracle OBIEE, Microsoft BI /SSRS, BI Express and Crystal Reports.
• Healthcare facilities expertise including hospital, nursing home, and physician office POMIS/EHR environments as well as physician office systems. Involved in all facets of applications including EMR Electronic Medical Records , ADT Patient Admissions , Census, Patient Accounting including Billing and Collections, Lab Results, Case Mix, DRG and ICD coding. EDI and HL7 transmission formats as well as specialized point to point interfaces between specialty systems including but not limited to lab results, radiology results, order management, etc.
• Oracle RDBMS, PL/SQL, SQL, 'C', Pro C, Data Review/ Design, Data Mart and Data Warehousing, Teradata Datastage, Metagon , ETL, RDBMS / PL/SQL / SQL / Application tuning, Application Development, Project implementation.
• Microsoft RDBMS/Development, MS/SQL, ACCESS, MS SQL SERVER 2003,2008 , Management Studio, SSIS, SSRS, Visual Basic, Office Products, Crystal Reports and Enterprise Development, NT Network Operating System Installation and Administration, Application Development, Project implementation.
• Full Life Cycle Analysis, Design, Development, and Implementation of Information Systems for various Healthcare facilities, Government Agencies, Manufacturing, Distribution, Retail Supply Chain organizations, Construction Management, Financial applications.

Computer Skills

• Languages: PL/SQL, ANSI SQL, SQL Plus, Pro C, PL/1, UNIX shell, Crystal Reports, REXX, BAL Assembler AcuCobol, AcuScreens, Micro Focus Cobol, MBP Cobol, RM Cobol, IBM Cobol, Cobol-II, RPG, IBM Assembler, PL/1, Basic, CICS/VS command macro level, IMS/DB/DC, DL/1, C , PCS/ADS, DMS, CANDE, SQL server, Oracle Development Tools, , HTML, JAVA, Javabeans, J2EE, JDK1.2.2, Power Builder, EJB, Oxford Systems UFO, NETWARE, TCP/IP FTP, Python, APS Cobol generator, 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, Inprise App Server ,ANT, PL/SQL developer, TIVOLI, TOAD, Microsoft SSIS and Administrator Console, PVCS, Crystal Enterprise, Microsoft Office, MS-Project, Word, PowerPoint, Excel, Front Page, Lotus 123, JBuilder, Visio Professional, VI Editor, TSO, SPUFI Utilities, JES, X-EDIT, K-EDIT, Multi-Edit, UltraEdit, IMRA, FTTSO, INDFILE, JOBTRAC, Datastage, Endeavor, Panvalet, Librarian, Power, CA-Zeke, CA-7, Autosys, Appworx, MQ Series, Intertest, Smart Test, SharePoint, BPEL, Teradata SQL assistant, OBIEE, Business Objects WEBI 3 and DESKI 6, Microsoft BI/SSRS/SSIS, SQL Server Management Studio, Oracle OBIEE, BI Xpress, Quality Center, Service Center, and various other applications and tools. .
• Databases: Oracle RDBMS 7.3-11i , SQL Server including through 2008/R2, DB/2, MS-Access, Infos II, Informix, Vision ISAM, IMS, Teradata, Progress
• Case Tools: Oracle Designer, Metagon, ETL, Microstrategy, QMF, WBI/MQ, DataStage Director, Dataflux dfPower Studio 7.1 and 8.0, Embarcadero ER suite, etc.
• Operating Systems: Windows including 95, 98, NT, 2000, 2003 Server. 2008 Server/R2, XP, Vista and Windows 7, 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.

Work History

Confidential

IT Consultant

• providing a wide range of services including project management, development, data analysis/architecture, business analysis, design, full business reporting solutions, data conversions and more. Detail client projects are listed as follows: Oracle Retail Version 13.1.54 Data Warehouse Architecture/Analysis and Design On Oracle Retail Data Into a Microsoft SQL Server 2008/R2 Solution, Lead Data Architect, Business Confidential Data Architect/SME Subject Matter Expert Transforming Oracle Retail Data For Modules ORMS, OSIM, OMFP, OA, ORPM, ORESA, OREIM to Microsoft 2008 SQL Server Enterprise Data Warehouse. Also provide business and data analysis for corporate BI based operational and analytical reporting.
• Provide SME Subject Matter Expertise on Oracle Retail suite applications for version 13.1 and data architecture design 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. Also provided direction and design information on creation of additional needed information for long term future EDW reporting needs. As a part of design activities created data translation/mapping documentation with required metadata for EDW technical team to create new structures in the EDW and to also build necessarily ETL processes to pull in required information into the EDW. Also included evaluation of using Oracle OBIEE prototyping and Oracle Retail reporting solution versus expansion of Microsoft based EDW solution. Also worked with various business key stake holders, business analyst and BI analyst on operational and analytical reporting requirements. Directed activities of other data analyst who provided specific mapping and metadata activities for EDW and operational reporting design and development. Aided in the direction and strategy on providing operational BI Xpress and MS SSRS reporting leveraging the Oracle Retail Suite application data in key business areas including purchase orders, merchandising, sales including sales auditing, supply chain distribution tracking of shipment/receipts, inventory control, financial transaction and stock ledger accounting for general ledger/financial tracking. Also was involved with SCRUM project status tracking 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. Was directly involved with reviewing data results in EDW applications as well as data required for BI report validation. In addition, was directly involved with working with PM, management, and BI analyst team on data validation and testing needs to verify results prior to application implementation. Directly involved with operational report testing and validation. Also worked with the in-house data architect on providing key direction on data points to provide necessarily Microstrategy analytical reports. Created business report data element definition online reference documentation and created primary data dimension and metric data dictionary online SharePoint based information for overall data team use. 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. Worked directly with senior management on key project issues. Provided data source BI reporting documentation as well as created EDW data model documentation incorporating the new Oracle Retail source additions and existing EDW tables. 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, BiXpress, MicroStrategy, OBIEE, SQL Developer, Office 2010 suite, AS/400 DB2 table tools.
• Healthcare physicians practice management demographic, clinical/ electronic medical record EMR documents/imaging, and financial conversions Into a Windows Progress database software application called Intergy. Confidential Senior Business/Data Conversion Analyst Extraction/Transformation of a variety of healthcare POMIS applications to Progress based Intergy POMIS application.
• 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. This includes analyzing third party applications with various data structures from other vendor third party applications like McKesson C-tree based Practice Partner application, Cerner practice management/HER 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. This is done with various tools some of which include Python, AWK, Perl, Access 2003,2007 , SQL, and Unix related standard tools. The platforms where the data resides are various including SCO Unix, AIX, Windows Servers, LINUX. Also as part of normal duties, apply conversion progress code hot fixes to the client Intergy applications, physically execute the conversions through several test phases, perform code mapping between the old system and the new Intergy system, analyze the client conversion requirements and perform in depth test validation of the data as well as troubleshoot any detail data specific issues from internal testing and/or client testing. This also includes using data search utilities within Progress to compare specific values as well as raw data transformed for the conversion process. Other duties include performing actual go-live conversions, detail documentation of third party application analysis, coordinating with management team on status, issues, project documentation, business rules analysis, and issue resolution.
• Oracle Retail Version 12.10 Data Warehouse Analysis and Design On Oracle Retail Data Into a Teradata Solution, Lead Business/Data Analyst/SME Confidential Lead Business/Data Analyst/SME/Project Coordination Transforming Oracle Retail Data For Modules ORMS, OSIM, ORWMS, ORPM, OA, ORDW to Teradata Enterprise Data Warehouse. Also for conversion of historical data from IBM MVS DB2 Cobol platform Provide SME Subject Matter Expertise on Oracle Retail suite applications including RMS, RWMS, SIM, RPM, and Allocation for data/business rules analysis and design to determine critical data within the respective Oracle Retail data models and provided mapping, data modeling, and design information on field level data to transform and load into the existing Disney D3 Disney Data Difference Teradata enterprise data warehouse solution in order to support the mission critical business operational and analytical reporting. Coordinated and provided information and direction to Disney analyst team and data architecture team. Participated in detail field level mapping design, business usage rules, reporting design, business design, and data modeling support for the enterprise warehouse solution. As a part of the initial review and business requirement and solution possibilities, analyzed potential business reporting solutions utilizing ORDW and Oracle OBIEE reporting tools but client decided to continue with in-house large scale EDW solution. Also coordinated key deliverables for the project with the project management team including aiding with timeline management and providing information on project scope change estimates. Used Disney standard LCM documentation for creation of required designs and project documentation as well as provide additional mapping standards through the course of the project. Coordinated activities with vendor contract resource across the data warehouse team and the Oracle Retail implementation team members. Provided liaison communications between the teams on key deliverables as well as project coordination efforts between business, IT, and strategic management. Used a wide variety of technology and tool sets including Oracle Retail application GUI, TOAD, Teradata SQL assistant tools, Datastage ETL, Dataflux dfPower Studio data analysis tools, Office software tools, SharePoint, Office Communicator, Oracle 10g forms and reports, Embarcadero ER suite, Business Objects WEBI 3.1. Used the Dataflux tool in particular to build analysis routines to do initial ORMS and OSIM conversion data validation and data quality checks from the ETL loaded data to insure data being sent to the data warehouse wouldn't provide any integrity issues. Also involved with the data conversion efforts for historical information into the new model with relation to modeling with the new future ORMS data being brought in to facilitate overall reporting. Involved in primary product change request enhancement designs to facilitate the proper modeling of information for the data warehouse and future world reporting using a combination of Business Objects WEBI and Crystal Reports. Participated in the overall reporting design efforts including design review sessions and reporting template logical mapping and working with the team of efforts to map to physical data elements. Acted as a subject matter expert for the Oracle retail suite to facilitate the development and validation of mission critical business reporting. Also designed and developed key information SQL and reports as well as maintained reporting data mapping metadata information for the reporting project. Acted as a lead on in-house custom Sales transaction Log TLOG migration from existing Informix platform over to Teradata platform. Tasks included providing development team with requirements and direction on the translation of the existing table structures to the modified structures in the new data warehouse environment to take data from new RTP transaction sales system data and integrate with connections to the Oracle Retail data included in the data warehouse in Teradata. Specifically performed analysis on existing production data to facilitate a reverse engineering of requirements against the new RTP and Oracle Retail data sources and built detail field mapping requirements. Also performed Gap analysis and worked with business partners to determine additional requirements and to bridge gaps. Worked with the development and business team during testing of existing reports ported over and modified in Business Objects Deski to confirm results and to aid in the triage of issues and defects. 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 fit into the Teradata data warehouse formats for historical reporting information.

Oracle Financial Version 11i Re-implementation, Senior Business Analysis/Project Planning

Confidential

Senior Business Analyst/Project Management Procurement and Financials

Provide senior business analysis and project management assistance utilizing Agile methodologies on the Pinellas county Oracle Financials 11i clerk implementation project. Specifically held JAD sessions for county wide departments and the primary finance organization of the Clerk of Court to capture information on the AS IS current state business process documentation and analysis on the TO BE future state process model as well as Gap analysis. Directly responsible for process flow and RUP based use case documentation creation on the Fixed Assets, Accounts Payable areas within Procurement as well as the General Ledger financials Period End Closing processes. Currently the various operation areas use a wide variety of systems and technology including such financial systems as GEAC, Oracle, APPX, and Maximo. In addition the analysis includes numerous manual and Excel spreadsheet based current functionality with an overall goal to re-implement the Oracle Financial 11i application as the single source system. The goal is to expand the current functionality with all core applications for the public sector as the primary system of record to eliminate current duplication of effort, and redundant systems/applications. Directly involved with analysis to facilitate the plan creation on best approaches to the business and application consolidation across the numerous departments and process functions. Provided direct assistance with long term project plan and documentation standards, and direction planning with the internal senior project management team.

Oracle Retail Suite Version 11 Change Management, Implementation

Confidential

Circuit City Change Management Lead/Data Transition Lead

Reviewed code migration procedures and created process and recommended procedures to load initial base code components into PVCS and coordinated with CM staff to build initial version of code base as well as process for developers to follow on code enhancements and process for build and release management groups to utilize to control environment promotions of software from development up through production release. Assisted staff with the development of training documentation for ongoing code processes being implemented. Coordinated with key team members, users, as well as system owners and team mangers to gather requirements for environments and provided processes and recommendations for CM controls and worked with various teams to gain acceptance for new processes. This included impacts with existing IBM legacy Cobol and RPG based applications under DB2 and Oracle Retail Retek Oracle based client server application integration and code control as well as PC based stand alone RM Cobol code applications. As a part of the code impacts and code migration efforts, performed detail code review and triage of modifications.

Oracle Retail Suite Version 11 Conversion, Interfaces, CRP, Implementation

Confidential

DFA Client Development/Implementation Manager, Technical Specialist

Partnered with Integration firm with CRP review and finalization including technical approach to system conversions and remaining systems interface methodology. Created resource estimates, statements of work, budgetary estimates, and technical design/development project plan for DFA legacy resource tasks as well as conversion and interface tasks for new Oracle Retail system on the DFA MOM project. Maintained adjustments to project plan, designed overall scope of conversion and interface tasks, aided in workspace planning and set up for additional resources, created development standards documentation and new design documentation templates for functional and technical designs. Designed detail conversion and interfaces. Managed development/design resources and task milestones for conversions, interfaces, and legacy efforts. Coordinated with senior IT management on issues and overall task efforts. Created high level technical approach on conversion execution and documentation for recommendations for Gold copy key points. Developed portions of the new components required.

Business Process Design

Confidential

Senior Oracle Retail Allocation and Replenishment Business Analyst.

Directed and designed key business processes and jointly developed overall business process documents for every key functional department of the organization. Processes were engineered with the Oracle Retail base product for version 10.1. on Allocations and Replenishment. Process review included handling areas such as Allocations, one time merchandise push to stores, regular stock item and like item replenishment, P.O. creation from Allocation projection on one time buys What If Allocation , store grade, One time and discontinued merchandise Allocations. 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. Also reviewed proposed modifications to support gaps in the business functionality not provided by the base product. Received security clearance to work on these military related systems via the SF86 form process.

Implementation/Testing/Infrastructure/Training Services

Confidential

Test Phase Lead

Project Management Planning/Planner/Development Liaison Directed/Aided with Planning on several phases of RMS/RIB/Integration Layer and DB2 based Legacy Retail application for GAP 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. 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. Main responsibilities are in the areas of full testing and implementation on the Legacy/MQ/WBI/RIB, Tivoli Alerts 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 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 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 leadership team, project and milestone review and forecast, test team resource day to day activity direction, etc. which included the financial retail stockl edger integration/development into the Oracle 11i financial platform. Also responsible for the development of environment shakeout testing execution plans. Drove the data to day resource execution and 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 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. 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. Use a wide variety of technical tools in providing the services for this client. 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.