SUMMARY Senior Level Consultant with over 14 years experience in the IT industry. Flexible and adaptable, I have worked on both the business side and technical side of large corporate programs in the Federal Government and Pharmaceutical Industry. Areas of expertise include Requirements Analysis, Project and Program Management, Master Data Management, Data Warehousing, Data Governance, Technology Platform, Change Management, Use Cases and SDLC. Excellent technical and communication skills.

PROFESSIONAL EXPERIENCE Confidential Senior Consultant Confidential Performed a Risk Assessment for a Global Pharmaceutical company looking to integrate a new data source into their commercial applications. Provided recommendations around scope, timing and execution of the work. Identified mitigation strategies for the integration across the Commercial system. Outlined the scope and parameters of the impacted systems and identified the areas to update to their Business Requirements and Data Integration Documentation. Assisted the client in mapping out a two-year roadmap for their Commercial Systems Architecture. Created a slide deck, outlining a phased approach, beginning with integrating a new data source provider, to the future where the client would use a federated/virtualized data environment. Confidential Management Consultant Conducted requirements elicitation sessions for a global clinical trial portal for a large pharmaceutical company. Facilitated several workshops with global stakeholders to identify, prioritize requirements for the portal. Converted existing requirements specifications in Word to BluePrint Requirements Center. Created Business Process Flows and use cases in BluePrint to support this effort. Served as the Lead Business Analyst on a BI project for a Manufacturing Division of a large pharmaceutical client. Agile environment, worked from analysis through deployment and stabilization. Authored five requirements documents, quality assurance plans, release plans and SOPs. Facilitated elicitation workshops and supported the business throughout UAT. Maintained and drove the risks, actions, decisions log. Conducted a Risk Assessment for a multi-million dollar enterprise platform initiative involving Clinical Data Management at a large pharmaceutical client. Conducted surveys, interviewed business users, technical team and key stakeholders. Identified levels of risk to the program. Reviewed their technical platforms and advised for successful implementation Mentored business analysts in creating requirements specifications across a multi-application, multi-million dollar platform. Facilitated Requirements alignment meetings between business workstream analysts, technical analysts, and key stakeholders. Building out a strategy for implementing a Program Framework. Developed Best Practices for Requirements Elicitation and capture for implementation by Merck BAs Analyzed Help Desk practices across entire Pharmaceutical client. Evaluated their effectiveness, created heat maps to illustrate areas of attention. Provided recommendations for program improvements Confidential Developed Requirements Specification for a data interchange between two SAP systems at a large pharmaceutical client. Facilitated elicitation sessions with the business and technical team. Created Use Cases and Business Process Flow diagrams with RAVEN. Confidential Service Delivery Lead Master Data Management Launched a new team as part of an Accenture Outsourcing agreement with a large pharmaceutical client. This team provides Master Data Management solutions to the client for the Customer Master CDI and Financial SAP Data Governance space. Started with a staff of 3 and built the team to 18. System was fed by a variety of data sources, including IMS, WK and internal sources Conducted demand planning and worked with the client to ensure that projects were staffed with the correct resources. Created an onshore/offshore model to provide better service to the client at a reduced price. Performed Project Manager role for the Customer MDM team, Service Oriented Architecture SOA and WebMethods team Provided technical leadership to the team, developing operational improvements to reduce the number of support issues and bug fixes across the Master Data domain. Provided Estimates and Work Plans for IT project work across the SDLC. These estimates served as baselines for getting funding for IT investment from the client. Provided day-to-day leadership and management of an onshore/offshore team in the U.S. and India. Motivated the team to perform at a high level. Served as the single liason between the client and Accenture's Delivery team. Senior Consultant/Team Lead Confidential ETL Team Lead in an onshore/offshore model for a large pharmaceutical corporation. Responsible for reviewing resumes, hiring of new team members, periodic reviews and professional development of the ETL team, up to 5 members on the U.S. team. Data Warehouse specifically supported Sales and Marketing functions and was loaded with IMS, WK, and Internal Sales data Develop and implement an outsourcing strategy of the group. Worked closely with client directors to implement. Coordinated a top-level view of the team's operations and took advantage of off-hours work to create a more efficient, cost-effective model Responsible for the design, implementation and development of ETL processes using Oracle SQL, PL/SQL, Shell scripting, Autosys, Informatica. Created design documents for offshore team to develop ETL processes, including Data Flow diagrams, data models, and development specifications. Develop QA/QC strategy and implement QA/QC plan for issues with the offshore team. Serve as a liaison between the offshore team and onshore business and technical client. Responsible for creating KT plans for the offshore team. KT plans include process flow diagrams, logical and physical data models, work instructions and troubleshooting guides. Built template documentation to serve as a standard for the team's future development and operations. Tracks the operational effectiveness and capacity of the Operations team. Projected future capacities and development of the team. Worked with the client to define metrics to expand the responsibilities of the team. Developed metrics to drive the workload balance of the team. Confidential IT Consulting Senior Data Analyst/Consultant Performed Logical and physical modeling of Law Enforcement Databases serving the U.S. Drug Enforcement Administration. Developed Business Rules through elicitation with the client and wrote PL/SQL packages to capture the logic for the data loads. Evaluation of new data sources. Data is evaluated for its strategic value to the client, integrated into the current system or a new model is designed. Erwin and Toad are used in the Design process. Developed processes and algorithms to facilitate the Extraction, Transformation, and Loading ETL of various data sources into the Data Warehouse. Oracle PL SQL, Shell scripting, Perl. Developed the Database Architecture for Intelligence, Search and Discovery datasets. Transformed free form data and loaded it into the database All work performed on-site at the U.S. Drug Enforcement Administration headquarters. Project requires Secret Clearance. Confidential Internet Service Provider Systems Analyst/Team Lead Team Lead for a team of 5 responsible for the Billing System for a medium-sized Internet Service Provider. The enterprise-level system serviced approximately 750,000 customers. Programmed processes to diagnose problems within the Oracle database and Arbor Billing System. Used Programming tools like Perl, Awk, Shell, SQL, PL/SQL to write my processes. Authored System Process documentation Developed ETL scripts to convert legacy ISP customer data to load into Earthlink's System Confidential IT Staffing Firm Programmer Analyst/Consultant Client/Server Software Development Developed Enterprise Procurement Solutions for clients using PowerBuilder and Oracle Database Systems. Web Base Software Development Wrote Java based web application to complement our Client/Server Product for a client.