515 Shakespeare Dr. Donald L. Ramage _(Home)-(610)-454 …



Experience Summary:3385820118173500IT Professional working in the following domains; Insurance(2), Engineering(8), Pharmaceutical(12), Health Care(2), Finance(6), Marketing(2), Telecommunications(1), Gaming(6), Defense (DoD)(2) . Expertise in Marketing, Proposal Development, Studies and Training. Strategic and tactical business intelligence thinker who has people and business skills; and can work effectively with all parts of the organization in applying technology and business strategy to derive intelligent and effective business solutions. Have developed BI tools for tracking and visibility of progress of program initiatives such as delivery dates, resource management, financial resources, generate, update and improve project strategies and methodologies in addition to reviewing, maintaining and highlighting the changes in project plans across all program verticals. Experienced with large, medium and small scale program initiatives and the fiscal systems for the purpose of recording, forecasting, monitoring and budgeting project expenditures. Experienced with handling program levels issues, change request and risks management.Education: Villanova University, Villanova, Pennsylvania (1991-1995)Major: MBABachelor of Science August, 1985Temple University, Philadelphia, PennsylvaniaMajor: Electrical Engineering Temple University, Philadelphia, Pennsylvania (1979-1985)Major: Architectural EngineeringExperience Profile:? Ten years of experience in developing business intelligence solutions. Offering a variety of custom platform technologies solutions and expertise in COT(Commercial Off The shelf) reporting tools (ie. Business Objects, Crystal Reports, Reporting services SSRS and SSAS).? Six years of experience with Enterprise Content Management Systems for future 50,100, 500 companies, engaged full life cycle in a broad range of roles. Five years of experience with SharePoint recently release 2013, and six years with Documentum. Experience with SharePoint designer.? Extensive experience in Enterprise Web Server and Class Client Server Application Architecture, design. development in both Data Processing and Engineering environments.? Expertise in software development methodologies or Use Cases, CASE tools, encompassing product development life cycle (SDLC) and maintenance of software.? Excellent Business and Technical Communication and Writing Skills.? Experience in communication software development and management of protocols, (Ethernet TCP/IP, Novell, RS232/422/485) Proprietary Digital, Wifi communication protocols..? Database designs for Relational DBMS (MOSS 2007, ERwin 2.0 -4.1, Access 2000-2003, SQL Server 2000-2005, Oracle 7.3-9.0i,10g, 11i, FoxPro 2.5, FileMaker Pro 2.1-5.0, MySQL).? Skilled at translating business needs to end product solutions utilizing System Development Life Cycle(SDLC) experience.? Skilled at system architectural Hardware and Software Systems design applications.? Experienced in providing c-level management (BI) business intelligence solutions.? Experienced in implementing traceability and data integrity based systems.? Experienced at designing, building, testing, refining and deploying Web sites, with applying the proper blend of art and technology in the areas of content design, visual design (UI), information design, interaction design, compatibility design, and performance design.? Experienced at mapping business capabilities and services to IT solutions, and plan IT solutions for tactical and strategic business opportunities.? Experienced at performing technical evaluations (ie IV&V Independent Verification and Validation) studies and definitions of technical requirements based on the needs of the project or business.? Experienced at developing enterprise wide solutions that are leverage-able for future re-use and actively seek opportunities to leverage existing IT solutions for new business offerings and services.? Excellent soft skills enabling the ability to partner with strategic business units, ie (Research, c-Level teams), where appropriate, to facilitate in the designing of IT solutions that match the needs of the business.? Continuously look to improve processes, technologies, applications to provide best value to business. ? Assist development teams in developing and enhancing detailed application designs and interfaces as well as prototype or proof of concept and wherever possible the leverage and reuse of components. ? Assess and formulate go forward architecture and technology direction for IT solutions.? Aggressively identify enterprise IT application solution/technology initiatives that are of value. Collaborate with other architects and teams in execution of the initiatives. ? Facilitate cross team and cross component collaboration, solutions and technologies across teams and projects. ? Review and approve project deliverables to ensure that they are architecturally sound and achieve as great a degree of fit with the desired architectures as possible. ? Experienced at performing responsibilities like maintaining existing PMO departmental and the policies and procedures of project office, including the following; update and improve project strategies and methodologies; reviewing, maintaining and highlighting the changes in project plan; prepare and maintain weekly and monthly project status reports; maintain fiscal systems for the purpose of recording, forecasting, monitoring and budgeting project expenditure; prepares status reports and updates the same to the c-level Management team; create the fully integrated master program; preparing ad hoc presentations and other essential task as required; provide support and guidance to Business Analyst and Project Managers; advance knowledge of building projects and supporting infrastructure; critical thinking skills and ability to work under pressure; strong time management and organizational skills; Multi-tasking skills and ability to meet deadlines.Capabilities:? Soft skills ability to Influence c-level business strategists and thus translate business strategy and technical vision from business intelligence.? Ability to understand and transcend business domains, customer and market trends and capture customer, organizational and business requirements on architecture. ? Self Starting and goal oriented in order to meet the objective of the business in a productive manner.? Systems Engineering Skills to work with a business requirement and to translate the needs into technology.? Works well in a team environment or in a Project Management role.? Experienced in Systems and Application Software Development.? Business Intelligence Marketing and Sales Support Skills.? Business Intelligence Financial Transaction Processing Systems.? Mentor to be available to build as a "trusted advisor", relationships with business executives stake holder, IT teams.Experience:73550372700Otsuka Pharmaceutical Development & Commercialization, Inc.Princeton, New JerseyTitle: Business Systems Analyst/Project/Program Manager(February 2019-Current)Accomplishments and Responsibilities:1358901968500Primary Role acting as liaison between business and technical teams within a regulated GxP SDLC environment. Developed the user requirement specification(URS), functional requirements(FRS), IQ, OQ, PQ, Configuration Specification(CS), Technical Functional Risk Assessment(TFRA), and Traceability Matrix(RTM) artifacts to support the Otsuka and affiliate’s next generation document management system CREDO and COT DocShifter used for submissions to regulatory agencies globally. Working with vendor suppliers globally lead functional and technical discussions and user acceptance testing. Working within Otsuka’s regulated environment validated artifacts were approved with the aid of ALM/Documentum FirstDocs/GQS. Working autonomously developed and managed a program designed to address 10 CAPA projects supporting the CREDO system; aiding project managers and team SME within respective business areas successfully closed all critical CAPAs managing deliverables with trackwise and the auditing team to ensure timely and quality delivery. Managed and supported WEB based sharepoint application development and delivery to the business, designed to support resource management of internal/external medical writer SMEs. 254001333500TD BankMount Laurel, New JerseyTitle: Project Manager/Business Systems Analyst/Solution Architect(October 2016 –November 2018)Accomplishments and Responsibilities:786309398000Managed a 30 million dollar software program upgrade for TD's treasury department. Responsibilities include waterfall/agile/sprint planning both tactical an3d strategic, solution architecture, business systems analyst, PMO, resource management, interface partner and vendor management, leadership reporting, and financials across multiple work streams. In addition, engaged another program, "Consolidated Receivables", similar to Citi Group’s Program in 2011, but TD's program is regional to US markets. My responsibilities are IT Receivables SME, Waterfall/Agile planning, interface management, business system analysis, solution architecture, and leadership reporting. Also, performing PM/BA functions across multiple program and project initiatives. Developed custom tactical treasury portfolio BI reports, providing senior leadership visibility into TD IT portfolio for North America.-18097510033000ABS/Genesis SolutionsHouston, TexasTitle: Project Manager(September 2015 –October 2016)Accomplishments and Responsibilities:Managed a group of 25-30 Functional and Technical resources which are both on the ground at the client location as well as remote. The project supports the full SDLC software life cycle of a Maximo deployment. The annual budget of 7.2 million is currently approved. Built an innovative custom interface between SharePoint 2013 and Excel to provide BI reporting visibility to tracking requirements progress, resource tracking, issues and risks, and performance monitoring KPIs. Involved with every aspect of the project functional and technical work streams. Report via power point presentation to executive management the progress and risks and issues.-318414953000Celgene/Genesis SolutionsSummit, New JerseyTitle: Project Manager(June 2015 –September 2015)Accomplishments and Responsibilities:2581429781500The project involves extremely high visibility and a very fast paced implementation of an IBM Maximo System, with 25 team members. The project effort involves a migration from the legacy systems Datastream and PRO/CAL, supporting the acquisition and control of a life science research GxP campus with the potential capacity of 5000 resources. Developed detailed working Project Plan. Analyzed financials against actuals, and forecasted project deliverables. Coordinated meetings between the business stakeholders, technical teams and vendors. Harmonizing all activities meeting critical path dependencies and exceeding client expectations with a project budgetary surplus.-1974851397000Sanofi PasteurSwiftwater, PennsylvaniaTitle: PMO Project Manager/ Business Analyst(September 2013 –May 2015)Accomplishments and Responsibilities:The project involves the implementation of a Global Vaccine Manufacturing Process Data Warehouse(PDW) encompassing over 20 manufacturing facilities located in Canada, France, and US designed to consolidate, analyze and share scientific results resulting from research, clinical and manufacturing real time. The PDW interfaces to the systems SAP ECC 6.0, LWLIMS 5.0 and 6.0, Shop Floor Data (SFD), Statistica, SAS, Werum MES, SCADA, and Data Historian Collection solutions as well as Data Analytics and visualization tools for reporting. Worked closely with the Sanofi Pasteur cross functional business users, manufacturing engineers and development teams to identify the requirements and provide a functional design. Developed and contributed to the development of all required documentation (user requirements specifications, functional specifications, design specifications, etc.). Required activities included requirements gathering, process design, analyzed and documented AS IS and TO BE business processes, and workflow modeling, system documentation, testing, and validation. Prepared use case and ER model diagrams.Developed and contributed to the development of all required validation and testing documentation (system related IS procedures; unit, integration and user acceptance test scripts, installation qualification test scripts, operational qualification test scripts, traceability matrix, etc.) Developed and executed the newly generated test scripts in ALM, recorded the deviations and drove their resolution and closures with the global development teams. Contributed to the creation and update of all business and IS related standard operating procedures (SOPs), standard work instructions (SWIs), training materials, etc. as needed for implementation of the new functionality PDW. Developed the overall traunch plan for assessment, review, development, testing, training and implementation of enhancements. Performed Knowledge transfer training with the Sanofi Pasteur resource(s). Trained in LWLIMS 5/6, SAP ECC 6.0, ALM 11, GMP, GxP, PROMISE, eDoc, Geodis, CITRIX, PUMA. Responsible for tracking and monitoring progress of project office as well as coordinating delivery dates.-1809751270000McNeil PharmaceuticalFort Washington, PennsylvaniaTitle: Program Manager/BI Business Analyst(June 2012 –September 2013)Accomplishments and Responsibilities:Mentor and provide guidance and governance within the PMO on a Consent Decree(CD), issued by the FDA. Coordinate and track deliverables with project managers for 19 work streams. Communicate progress, risks, issues, system updates and outages and provide reporting visibility and transparency to the Consent Decree Management Office(CDMO). Track the initiation of all IT/Non IT resource demand as they relate to new requirements and identify potential risks and communicate these risks and issues in a report layer presentation by providing business intelligence(BI) using tools such as Excel/Cognos/Share Point/Share Point Designer 2007. Work with HR in translating demand for all IT related FT and contracting resources. In addition, provide assistance for all project tracking deliverables through Clarity and MS Project. Provide Quality Assurance and Management analysis on the impact assessment and risk through business intelligence and report back risks identified to business and IT stake holders. Received training in cGMP, GLP, GxP, SDLC, IAPP, Adverse Events, Data Security, and Records Management. Performed an internal audit on the document management system, in response to a warning letter issued by the FDA. Designed a prototype Erwin database design and a Share point GUI supporting a global QA initiative on document SDLC compliance. -1809755397500SEI InvestmentsOaks, PennsylvaniaTitle: Project Manager/Business Analyst/Architect/Technical Lead(August 2011-June 2012)Accomplishments and Responsibilities:Manage on shore and off development teams to support the on boarding of all new clients. Utilized Waterfall, Agile and SCRUM methodologies to enhance the SDLC delivery cycle. Responsible for developing and maintaining relationships in a complex matrix environment across several business units, stakeholders, executives, liaisons and vendors. Worked with the business to ensure the on boarding of all new customers statements and all financial planning assets were assimilated into the new product offering. Assisted in identifying UI gaps through back end processing. Develop and incorporate a business architecture approach, vision and structure into the organization for it to operate as a complete cohesive entity. Evaluate current to desired business and technology states to establish a roadmap for addressing gaps, issues, impacts and opportunities for improvement. Instituted best practice technology specific coding methods for the development teams on and off shore aligned with the organization. Define and align enterprise level processes, procedures, business rules, capabilities, requirements, goals and systems are coordinated vertically within business areas as well as horizontally across the entire enterprise to ensure the needed expectations, dependencies, handoffs and interactions are met. Trace requirements throughout the complete project effort to ensure successful development and delivery. Conduct requirements elicitation workshops and joint application design (JAD) sessions for collaboration of detailed requirements and solution design from key subject matter experts and technology specialists. Oversee the analysis and development Informatica with the UI interface and wire frame development of new products. Develop technical design documents for new product initiatives. Oversee the data migration teams to ensure the on boarding of new clients on to the Data Warehouse and Data Marts is seamless. -44452857500Citi GroupWilmington, DelawareTitle: Strategic Business Analyst/Project Manager/Release Manager(January 2010-August 2011)Accomplishments and Responsibilities:Managed a team of 10 developers. Utilized Waterfall, Agile and SCRUM methodologies to successfully manage the delivery of over 100 new product releases. Work with the business stakeholders and business liaison SMEs to develop business and system requirements and then translate the business requirements into technical requirements. Direct the SME development team in ETL, Data Modeling and Micro Strategy BI to define system design specifications for a new Data Ware house and common Data Marts to support a global BI OLAP for Receivable Operations. Assisted with the mentoring and coaching of team members. Assisted to ensure technology aligns with business needs, making sure technology investments fit strategically and tactically. Assisted in the development and completeness of requests including detailed business case development. Facilitated discussions related to future needs and opportunities and identify solutions. Lead the definition of detailed business rules for validating and transforming data and create layouts and specifications for dashboards and KPI monitoring reports. Worked with the business side technical leads, project managers, and business liaison subject matter experts to understand receivable data quality ETL product processors. Managed pilot production releases. Developed and maintained Business and Functional Requirements; as well as, specification system documentation, such as; business process models, entity-relationship diagrams, flow charts, data flow diagrams. Interviewed and evaluated the on boarding of new resources to the team.381004000500SAP AmericaNewtown Square, PennsylvaniaTitle: Strategic Business Analyst/Project Manager(October 2009-January 2010)Accomplishments and Responsibilities:Work with users to develop business and system requirements with the development team to define system design specifications for all new product launch initiatives. Assist to ensure technology aligns with business needs, making sure technology investments fit strategically and tactically. Assist in the development and completeness of requests including detailed business case development, value definition, cost assessment, benefits, risk analysis and resourcing. Define, gather and document requirements from which IT solutions are needed. Translate business requirements into detailed functional (logical) specifications for development. Facilitate discussions related to data quality requirements, anticipate future needs and opportunities and identify solutions. Lead the definition of detailed business rules for validating and transforming data and create layouts and specifications for end-user data quality and monitoring reports. Work with data analysts and subject matter experts to understand data quality issues and drive the resolution of discrepancies. Develop and maintain system documentation, such as; business process models, entity-relationship diagrams, flow charts, data flow diagrams, use case, ‘as is’ and ‘to be’ models, system narratives, design specifications, test cases, training manuals, and user documentation.04826000Teva Neurosciences/DSSHatboro, PennsylvaniaTitle: Business Intelligence Architect/ Developer(April 2009-October 2009)Accomplishments and Responsibilities:Responsible for the analysis and development of a Clinical Business Intelligence solution associated with clinical Adverse Events DWH from a SIEBEL CRM MDM, ETL to a validated and regulated Oracle MDS DWH. Reports are rendered in Cognos and Excel in an effort to support clinical follow-up reviewed by clinical professional medical staff. Technologies utilized are; SAS, 2.0, 3.5, Visual Studio 2005, Oracle 10g, Oracle 11g, TOAD, Oracle SQL Developer, PL/SQL, stored procedures, Oracle Client, Visual Source Safe, VISIO, Excel. Regulatory and compliances are HIPPA, 21 CRF Part11.95250-190500GE Water Technologies, Inc.Trevose, PennsylvaniaTitle: Business Intelligence Data Architect(March 2009- April 2009)Accomplishments and Responsibilities:Responsible for the analysis and data mapping of a Timberline ERP to a SAP ERP DWH data transparency conversion, for c-level management. The reports were rendered in Business Objects and Excel. The initial goal of the project was to generate total (operating margin) reporting from the SAP ECCS DWH. Additional layers of P&L OM reporting are also generated for detailed financial analysis. I was part of an information delivery team and worked alongside the finance team to generate OM reporting from the ECCS and to digitize it. Responsible for developing a prototype and presented to c-level finance for review. This project was run under Agile PM methodologies and as an iterative process, delivered under tight time lines. I coordinated activities and collaboration with resources in the USA West Coast (Business side); as well as, SAP development resources in India (SAP Developers). Technologies utilized were; Sage Timberline, SAP, Oracle 10g, VISIO, ODBC, Excel, Access, ERwin.-768355334000Accenture/Gestalt-DoD/KForceKing of Prussia, PennsylvaniaTitle: IT Auditor(January 2009- March 2009)Accomplishments and Responsibilities:Responsible for the analysis and development of BI Business Intelligence data mine reports for a Solomon IV accounting repository; which the outputs were rendered in Crystal Reports XI r2 and Excel in an effort to support a government audit where the reports are being reviewed by a legal and CPA professionals.Allied Control ServicesWest Point, PennsylvaniaTitle: Project Manager(September 2008-January2009)Accomplishments and Responsibilities:Responsible for providing tactical and strategic IT and financial reporting concepts, utilizing ERP Sage Timberline. Provide project management agile methodology and job costing estimation for a 1.5 million dollar project for water municipality industry. Integrated job costing analysis from excel to timberline utilizing Access 2003. Established a baseline for the job costing module in Timberline, utilizing technologies such as; Crystal Reports XI r2 MS Project 2007, Excel, Access.-857252159000The Loomis CompanyReading, PennsylvaniaTitle: Lead System Integrator/Architect(August 2008-September 2008)Accomplishments and Responsibilities:Responsible for architecting the software integration of a COT(Commercial Off The shelf), IBM Group Web, and an in house custom application. Developed system requirements by interviewing c-level management to the level of coding insurance requirements and developed and deployed the new system built on Visual Studio 2005/2008 3.5, utilizing technologies such as SQL Server 2000-2005, 2.0, 2008, and Classic ASP 1.0, 2.0.190501270000Resolutions Consulting/Brokerage ConceptsWayne, PennsylvaniaTitle: Business Intelligence Architect(December 2007- August 2008)Accomplishments and Responsibilities: Responsible for the providing tactical and strategic BI(Business Intelligence) reporting solutions to the Financial and Marketing groups, mid to upper management, utilizing Crystal Reports version XI r2 and SQL Server 2005 Repository. Designed and built a Business Intelligence report user interface utilizing Visual Studio 2003 C# 2.0 technology to support Crystal Reports 10/11 Reports.38100000Dale and Thomas PopcornEnglewood, New JerseyTitle: Business Intelligence Architect(September 2007-December 2007)Accomplishments and Responsibilities:Responsible for the providing tactical Business Intelligence reporting for new product launches to the Manufacturing, Marketing and Sales groups, upper management, utilizing Crystal Reports versions 10 and XI r2 while Interfacing to financial accounting software, SAGE MAS 500 and a CRM Sales Logix 7.1 SQL Server 2005 Repository.Intellidyne Business SystemsCollegeville, Pennsylvania270446512001500Title: Founder/Designer “The Automatic Recruiter” (Part time as needed)(July 2005- September 2007)Accomplishments and Responsibilities: Responsible for full SDLC(Software Development Life Cycle) of an enterprise class solution designed to provide BI(business intelligence) for recruiters. The product is patented and copy write as; “The Automatic Recruiter”. The “Automatic Recruiter”, manages a resume content data warehouse of 500,000 resumes within a SQL Server 2005 and MOSS 2007 environment. Extensive ETL Technologies encompass the back-end of the product handling data mining, data scrubbing and integrity. The client facing business intelligence aspects of the tool provide tactical and strategic information concerning the resources available in the market. Dynamic and interactive BI reports are rendered in Excel. The Technologies utilized to create “The Automatic Recruiter” are Visual Studio 2003/2005 2.0 , VBA, Reporting Services SSRS, SSIS, SSAS, MOSS 2007, SQL Server 2005, Server 2003, Windows XP/2000. Utilizing Business Intelligence Development Studio.-1504954826000Pennsylvania department of Labor and Industry/DDS/MaximusHarrisburg, PennsylvaniaTitle: DBA/Architect Oversight Role(March 2006-September 2006)Responsibilities:Member of an IV&V oversight committee responsible for reviewing the State of Pennsylvania department of Labor and Industry next generation Comprehensive Workforce Development System(CWDS), a 150 million 5 year project, design to maintain a continual tax base for the state of Pennsylvania. Responsible for reviewing all database designs concerning Data Conversions and Product design. Wrote monthly executive c-level reports providing Comments, Recommendations, Questions and Deficiency’s associated with CWDS database development effort. Utilizing tools such as Erwin 4.1, Visio, and MS Word, MS Excel, Business Objects and Crystal Reports XI r2.-45085-762000AstraZeneca/DSSWilmington, Delaware270510012001500Title: BI Architect/Technical Lead/Project Manager(July 2005-September 2007)Accomplishments and Responsibilities:Responsible for providing clinical business stake holders business intelligence information necessary to collectively make informative decisions upon their next generation Content Management System(CMS) for eCRF (electronic case report form). Contributed towards the URS and developed the RFI/RFP as part of the planning phase for the next generation CMS COTS (Commercial Off The shelf) eCRF System. Responded to Stakeholders request to compare utilizing internal vs. offshore resource solutions for the CMS. Responsible for the planning and implementation including all documentation necessary for decommissioning a legacy system in production as part of a global initiative to reduce application services by 10%. Designed and developed a prototype business intelligence tool which provided detailed skill level analysis of c-level management, in an effort to reduce drug project development risk associated with their clinical SLC. Upper Management relied on the tool to schedule JIT training for tactical management. The tool read a wide variety of questionnaires and interfaced with multiple repositories to analyze the strengths and weaknesses of each resource. The skill assessment tool was derived from 1.1 and VBA, while utilizing ETL Files, TOAD, SAS, Oracle 10g, Oracle 11g, SQL Server 2000, Access 2000, and PL/SQL, stored procedures. Supported in house custom ERP System with SQL Server 2000, Visual Basic, VB Script, WEB, and . Provided Developer Level III support and development towards a user community of 4000, for 15 production product encompassing 2 enterprising wide systems. Designed business intelligence reports utilizing Business Objects 6.0/Universe XI r2 for the CMS. -123825889000Novartis/AecioRoseland, New Jersey271399012509500Title: Project Manager/Strategic Business Intelligence Architect(April 2005-June 2005)Accomplishments and Responsibilities:Responsible for the project management of a new product launch, business intelligence analysis, design, development, quality assurance, and production deployment and support concerning the executive financial and marketing/sales dash board reports. Also responsible for the design of a front end UI Interface(Excel VBA) to the Oracle DB related to the the Novartis Eye Care Division. Utilizing ETL data conversions from a Access/Excel to a Windows platform with Oracle 9i, IIS, MS Report Services, developed within a .NET framework, Excel VBA.-95251460500Haverford Trust Company/RHIRadnor, PennsylvaniaTitle: Business Intelligence Architect/Developer(January 2005-April 2005)Accomplishments and Responsibilities:Responsible for the business analysis, design, development and production deployment and support concerning the legacy conversion of all client holding and financial reporting, and ETL data conversion from a UNIX to a Windows platform utilizing Windows Server 2003, IIS, SQL Server 2000, MS Report Services, developed within a .NET framework.285752095500Comcast CommunicationsMt. Laurel, New Jersey265366511811000Title: Business Intelligence Architect/Developer(October 2004-December 2004)Accomplishments and Responsibilities:Developed an automated BI(business intelligence)Billing and Market Capacity Planning business analysis process/report utilizing Excel VBA designed to collect information from multiple data source types including; Excel and Text Files, SQL Server, MS Access, and Oracle. The Billing analysis report saves Comcast approximately one million dollars a month. The billing analysis and report validates AT&T billing charges associated with contractual service charges and subscriber usage.2952751460500Merck and Co./Info. TechnologiesWest Point, PennsylvaniaTitle: Lead Architect/Business Analyst(June 2004-September 2004)Accomplishments and Responsibilities:Involved with the strategic planning and architecture of the next generation sales system which supported a sales force community of 10000 users and all new product launches. Wrote the User Functional Requirements Specification; as wells as, the Functional Requirements Specification which was derived on written Use Cases. Assisted in the recommendation of technologies to senior management.-28575127000Deloitte Consulting/RHIGlenn Mills, Pennsylvania264922012065000Title: Business Intelligence Architect/Developer(March 2004-June 2004)Accomplishments and Responsibilities: Designed and built a customized (BI)business intelligence dictionary/dictionary management tool(DMT) for MS Word and Power Point applications. The dictionary was designed to identify suspect words and phrases which would place the firm at questionable liability and risk, thus over committing the firm in contractual written agreements and correspondents with clients. The dictionary can be formatted as multilingual so that all Deloitte Touche Tomasu firms throughout the world can utilize this utility. The tool utilized Excel VBA and Word VBA, XML, Access 2000, SQL Server 2000, Wise Install 9.0381002095500BOI/RHIWest Chester, PennsylvaniaTitle: Acting CFO(June 2003-December 2003)Accomplishments and Responsibilities:Report and advisement to executive management the state and wellbeing of the corporation concerning financial and operation matters. Advised and Managed coporate downsize to ensure positive cash flow. Streamlined operational and financial reporting inefficientcys. Reduced risk to Billing and AR business processes. 95253302000Comcast Communications IP ServicesCherry Hill, New Jersey265366511684000Title: System Engineer/ Business Intelligence Architect/Developer(February 2003-March 2004)Accomplishments and Responsibilities:As part of the Strategic Capacity Planning Group analyzed existing national IP services architecture. Created a fully automated data gathering and business intelligence system representing the current state of the IP Services architecture utilizing the following technologies: VBA, Excel, Access SQL Server 2000, and Outlook. The automated system utilizes lean principles when considering performance and accuracy minimizing chance for error within time, was dramatically reduced. After the analysis is completed and stored, reports are created and automatically emailed to field engineers with suggested action items based on the analysis. Email responses from the field are automatically tracked and recorded. Currently expanding system design and capabilities to other strategic business areas impacting engineering, marketing and sales, field service, executive management.85725571500ISIDevon, PennsylvaniaTitle: Strategic Business DBA/Analyst/Developer(June 2002 April 2003)Accomplishments and Responsibilities:Working closely with corporate executives, analyze, recommend and apply information technology and information science solutions to a wide range of strategic business areas, operating in the Health Care industry. Converted legacy Human Resources DB to new RDBMS and utilizing intranet WEB enabled technology. Saving ISI millions of dollars analyzing employee PR expenditures real time utilizing current technologies and business techniques. Integrating corporate wide an automated time tracking system, saving ISI millions. Technologies utilized are MS Access 2000, Filemaker Pro, ERwin, Excel VBA, CITRIX, MS Server 2000, Mac OSx, UNIX, Time Trak/PBX/Voice Mail, Administrating and deploying Windows 2000 Server/CITRIX VPN corporate wide to 400 employees over LAN/WAN, connecting via T1, sDSL, and ISDN, NETOPIA Routers.Business FirmsTitle: WEB Consultant(March 1998-June2002)2649220127000Accomplishments and Responsibilities:Designed and deployed Web applications and business ecommerce sites utilizing the following technology’s XML, HTML, Active Server Pages (ASP), Microsoft database/ADO/ODBC VBscript, Visual Interdev Suite, Visual Studio, COM-DCOM, FrontPage, and various graphical software tools. ie 219075825500MFN, Inc./RHIWilmington, DelawareTitle: Strategic Business Analyst/Lead Developer(February 2002-April 2002)Accomplishments and Responsibilities:Utilizing the following; VBA, Access 97/2000, Excel, design and develop automated financial and non-financial business processes. Responsibilities included working with financial owners and users to ensure that stated objectives are consistent with business requirements, and that projects fulfill business needs. Assist business area users in developing detailed business requirements, e.g. reports, data, processes, procedures.127635-127000State of Delaware/Illuminova./RHIWilmington, DelawareTitle: Business Analyst/Developer (Part time as needed)(February 2002 May 2002)Accomplishments and Responsibilities:Utilizing Visual Basic 6, Access 2000, FileMaker Pro 5 and SQL 7 Server providing a custom legacy conversation application to convert a Btreive database source report formatted data output an to a SQL Server 7 schema target.57153873500JP Morgan Chase Manhattan./RHIWilmington, Delaware265874512128500Title: Strategic Business Analyst/Lead Developer(June 2001-February 2002)Accomplishments and Responsibilities:Aided IT Management by providing strategic technological information needed by the business to make decisions quickly in implementing a cost saving strategy or ROI, in developing a scaleable Advanced Data Management System designed to scan initially 100,000 documents per day. Involved in the design, development, integration, test and production aspects of the overall document management system. System IS and IT technologies utilized Server 2000, NT 4.0, Erwin, Oracle 8.0I, SQL Server 7.0, Access 97/2000, Visual Basic 5.0-6.0, Kofax Images Tools(VRS), Sterling Connect Direct (NDM), Cerrasoft (OCR) engine, Informix; AS400,UNIX, Bell and Howell 8000, Kodak 2000-3500 series scanners, and Fujitsu 4000 series scanners.2286001651000Merck and Co./Nobel ConsultingWest Point, PennsylvaniaTitle: Project Manager/Business Analyst/Lead Developer/BI(March 1998-April 2001)2668270-127000Accomplishments and Responsibilities:Utilizing a solid understanding of computer technologies, including development methodologies, programming languages, operating systems in desktop, client server, and WEB enabled environments, networking technologies and database tools; analyzed, designed and successfully completed the full product development life cycle of a high visibility, high throughput screening(HTS), Laboratory Information Management System (LIMS). Performed detailed systems analysis and trade-off studies. Utilized negotiation and arbitration skills in order to operate effectively across the different functional areas of basic research and chemistry, each having different goals and requirements. The implementation of the newly proposed system offers a strategic technological competitive advantage and viewed as a model LIMS System for a research lab, with the potential to re-utilize technology into many other existing and future lab environments. The System offers a unique opportunity to provide business intelligence drug discovery information accessible to areas of the organization World Wide real time that rely upon the results to make decisions on whether certain drug compounds are worthy of continued exploratory R&D. The advantage of the System has provided an automated data closed loop, thus providing performance to the overall product development process, thus speeding product to market. Assay results, which previously took months to become available, now are available within a day. The data link to the entire organization translates to a justifiable return on investment(ROI). The LIMS System development comprised of technologies such as; ERwin 3.5, Visual Basic 5.0-6.0, VISIO 5.0, Sheridan Components Suite 2.0, VB Assist, Visual Components Studio 5.1, True Grid Pro 5.0, Power TCP, Crystal Reports 7.0, Access 7.0 , Oracle 7.3-8.0, PL/SQL, Filemaker Pro 5.0, 4D, True Track/True Change, SQL Net, SQL, SAS. The entire Assay Data Management System is distributed physically throughout 6 labs supporting 20 workstations, and a Server. Each lab workstation is connected to a Biotek Optical Density reader via RS232 designed to download raw result data performed at the time of the experiment within the lab. Data is then reformatted, analyzed, archived and reported on. The new System follows and adheres to FDA 21 CRF Part11 compliance, cGMP, and GLP guide lines for software and system product development for use in biological and clinical research development. The architecture of the system is offered as a 2 tier system and based upon the latest client server and WEB technology. Researched and specified all Workstations and Laboratory instruments. Responsible for all documentation including PAS, FRS, SDS, UTS, UAT, SPT, STS, and SOPs. Responsible for all unit, system, integration testing and overseeing validation technically. Liaison between Biology and Chemistry Research Departments. Since the system’s release into production in 1999 and at a cost of 3.5 million dollars, the system has aided in the discovery of two new drugs that potentially may earn Merck and Company billions of dollars revenue annually.1905001905000SEPTA/Total Systems Design/RAI/TKLPExton, PennsylvaniaTitle: Architect/Designer/Developer(September 1996-October 1998)2689860952500Accomplishments and Responsibilities:Responsibilities included the full product development life cycle of a high visibility security application labeled and know as the Emergency Call Box (ECB) System for South Eastern Transportation Authority (SEPTA). The overall intent of the ECB System is to increase the visibility and response of the SEPTA’s police to emergency calls thus directly increasing ridership and revenues. The EBC System is a symbol of SEPTA’s new strategic direction proposed and currently being implemented by SEPTA’s new CEO. Utilizing rapid proto-typing techniques concurrently designing and developing 8 unique software products represented by over 3.5 million lines of code and encompassing over 250 screens, by applying cutting edge client/server and networked distributive control architecture technology. In addition; also designed and developed an innovative PC based hardware/software product known as a Remote Terminal Unit(RTU) presently distributed to 100% of all SEPTA’s underground rail stations as part of the initial phase of this 8.5 million dollar project. Developing all products with Visual Basic 4.0 Enterprise Edition for Windows 3.11/95 and Windows NT 3.51/4.0 operating systems in conjunction with supporting relational databases SQL Server 6.5 and Access 7.0 platforms. The Server is NT based uniquely designed to communicate to all 60 RTU’s within one second in addition to 4 uniquely designed client workstations on the LAN/WAN. As part of the overall system designed and developed a PBX to handle multiple simultaneous telephony communications from the Client workstations to the RTU’s utilizing software provided from Diologic and Artisoft for Visual Basic 4.0. Designed all reports and reporting functions utilizing Crystal Reports Pro 5.0. Supporting manufacturing and the field with a fully designed MMI VB software simulator designed to speed RTU hardware production testing and debugging; in addition, to field implementation support and testing. Wrote all system specifications, factory acceptance test procedures, training, user, and maintenance manuals. Responsible for providing training to a wide range of SEPTA personnel, from maintenance engineers to SEPTA Police.22739351333500257175-6604000Wells Fargo Alarm ServicesKing of Prussia, PennsylvaniaTitle: Business Analyst/Developer(Part time as needed)(February 1997-September 1998)127003746500FIRST USAWilmington, Delaware270319513204800Title: Business Analyst(September 1996-October 1996)Accomplishments and Responsibilities:Designed and implemented a relational database model with ERwin/Access representing the business core foundation of First USA's financial forecasting of securitizations. Utilizing synergy’s from current Excel financial models redesigned new models providing links to an Access relational database.2190752603500Blood Bank of Delaware/Intercontinental TechnologyWilmington, Delaware268732012065000Title: Business Analyst/Designer(February 1996-September 1996)Accomplishments and Responsibilities:Automated the daily business functions and LIMS clinical lab testing system performed at the Blood Bank of Delaware utilizing numerous client server software development tools; such as, Windows NT 3.51, SQL Server 6.0, Visual Basic, Access, SP Assist, ERwin, Solomon IV for Windows NT, Data Junction. The system was designed to adhere to 21 CFR Part 11 Compliance. Converted accounting and billing legacy Wang and UNISYS systems to a Windows platform and Solomon IV. Utilizing current flat file database design, redesigned and implemented business models utilizing relational database methodologies. Through modular innovative design techniques constructed flexible client design models to be universally implemented nationally to other blood bank facilities.Marketing Technologies InternationalTrevose, PennsylvaniaTitle: System Architect(December 1995-February 1996)20955-254000Smith Kline Beecham(SKB)/Judge Technical Services, Inc.King of Prussia, Pennsylvania269684512255500Title: Project Manager/Systems Integrator(February 1995-December 1995)Accomplishments and Responsibilities: Managed, designed, and implemented, the first (hold patents) fully automated LIMS Hepatitis and AIDS Blood Analysis System for Smith Kline Beecham utilizing multiple interleaved hardware and software platforms, at a cost of 2.5 million dollars. Through successful project management and contingency planning championed project to meet deliverables. Directed Internal and External Strategic Business Units(SBU) to meet challenges and found ways to capture synergy’s among the teams turning them into a competitive advantage. Using advanced and intelligent software tools developed intuitive GUIs setting innovative precedence in the clinical industry. The System consisted of the following subsystems a Hewlett Packard ORCA (Optimized Robot for Chemical Analysis) , Abbott Laboratories PPC (Parallel Processing Unit) and prototype DI (Dynamic Incubator) subsystem, Tecan Genesis Pipette subsystem, Prototype Cover Seal Applicator, Removal, Hotel, and Bead Dispenser subsystem. The software architecture is developed under the following platforms MS Windows and NT, Winclara, MDS(Methods Development Software), Visual Basic Pro 3.0, Integrator, Logic, Process Control OPTO-22. The automated LIMS Hepatitis System will provide significant reduction in variable costs, un-interuptable analytical clinical flow, economies of scale, in addition to other automation benefits.-76200-127000Interdigital Communications, Inc.King of Prussia, Pennsylvania28689301333500Title: Test Engineer (Part time as needed)(June 1995- September 1995) .Decision Arts/Tekmark Computer Services, Inc.Wayne, PennsylvaniaTitle: System Analyst(December 1994-February 1995)-381001841500General Instrument /Judge Technical Services, Inc.Hatboro, Pennsylvania2564130698500Title: System Design Engineer(June 1994-December 1994)-190501460500DECO Automation, Inc.King of Prussia, Pennsylvania30653111079500Title: Project Manager/Product Manager(June 1993-June 1994) Peripheral Dynamics Inc.Plymouth Meeting, PennsylvaniaTitle: Sr. Design/Firmware Engineer(January 1988-June 1993)Aydin Vector DivisionNewtown, PennsylvaniaTitle: Project Engineer(October 1986-January 1988)Heinemann Electric CompanyLawrenceville, New JerseyTitle: Design Engineer(November 1985-June 1986) ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download