Description
SUMMARY Experienced IT Software professional specialized in working with clients to understand and implement requirements and applications/systems to provide business analytics and strategic solutions in various roles as a Senior Business Analyst, Senior Project Manager, Senior SFDC Architect, Senior Program Manager/Product Manager and Senior Product Owner. Collaborate with product management, engineering and other cross-functional teams to construct solutions from software inception, implementation and development lifecycle in platform and project development. Experienced working in a regulated environment, with Director level and above to define and prioritize risk management approaches and scope project roadmaps. Excellent knowledge of the System Development Life Cycle (SDLC), Saleforce.com (SFDC) CRM, Software Validation, Data Modeling, Excellent communication, analytical, programming, interpersonal, and presentation skills expert at managing multiple projects simultaneously. Summary: Product Manger reporting to Sr. Director Business Operations, responsible for End to End Data Reconciliation Product Owner across Ecommerce Comcast/Xfinity Salesportal Web UI. Acted as liaison /Data knowledge expert to support business units such as Marketing, Finance and Accounting for reporting and data migration/ integration. . Data Product Owner for all commission based sales orders from Verizon, BestBuy, All Connect and other indirect partners selling Comcast products (Xfinity home, Internet and Cable TV Services).. Work with development teams to deploy patches and integrations from several database sources IE: Salesforce, VZW order management system. Design database data flow diagrams to support Business Units. Manage UAT testing for OBIEE analytics reporting engine. Development of PL/SQL based mock reports to support sales, marketing, and business strategic units then coordinate deployment with developers to deploy reports into production. Lead all database changes and integration from business roadmap prospective. * Gather requirements for user access data from Xfinity My Account web interface to provide reporting user login features with SSN, Drivers licenses ID's and My Account ID's. * Coordinate data requirements across multiple teams, business users, solution architects and product owners.. Create data mapping from multiple system architecture. Create ad hoc reports for senior level business management. Primary Data owner for deployment of Comcast Web UI. * Develop detailed project and communication plans (initiation through release) based on all database changes and configurations with in Comcast E-Commerce Xfinity Salesportal Web UI. * Provide business plan and analysis for Archiving of Biller and account management data. * Business owner of all data reconciliation ETL processes across Sales portal Web UI from SCMS (Sales channel management) to Business Finance Commissioning for indirect affiliates. * Troubleshoot data integration errors and job failures. * Assess the data impact of every feature & user story across multiple platforms SFDC, iComp (commissioning system), and NDW Reporting OBIEE reporting system. * Manage team of 20 developers and engineers * Engage with Architects to develop strategy for deployment of requirements * Provide final QA sign offs for stage to production pushes of requirements * Preform financial analysis on customer debit and house debit for customer amnesty business logic. * Define financial reporting requirements and execute risk/gap analysis between databases. * SFDC subject matter expert for Reconciliation Team. * Define business rules for data integration and reporting to support several business units (Marketing, Sales - direct and indirect affiliates and Finance). * Manage relationship and development timelines and expectations between business finance and DevOps. * Create Technical User Stories for API and ETL Development for Salesforce integration configuration from Salesforce to ETL. * Oversea and Facilitate User Acceptance Testing of all user stories for OBIEE business intelligence development and ETL commission engine. * Coordinate business requirements for data commissioning ETL system to support affiliate sales for VZW, Best Buy and Allconnect who sell Xfinity products and must be provided with a commission. * Manage Data Reconciliation development team for sales commissioning system engine. * Develop user stories and acceptance for commissioning ETL engine team and OBIEE reporting teams. * Prioritize sprints items for development teams for reporting and ETL commissioning system in Rally project management tool. * Agile Scrum Master facilitate daily Agile scrum meetings, sprint planning, sprint reviews, and sprint retrospective for Commission ETL and OBIEE business intelligence teams. * Gather requirements and Translate new offers for Internet/Cable bundles from Marketing into technical and functional user stories. * Produce Sprint tracking reports for senior management from Rally Project Management Tracking. * Manage and create defect priorities with the project roadmap team. * Work with Project Managers to provide project updates based on project roadmap dependencies. * Set release schedules based on project roadmap dependencies from several development business groups (sales channel management, account management channel. Chevron - San Ramon, CA Senior System Engineer/Senior Business Analyst January 2013 - May 2013 Summary: IT liaison to Cost Engineer Analysts and Business Finance supporting groups from Gulf of Mexico to Latin America. Support users with Data Extracts from SAP Business warehouse and other systems. Design Portfolio level reports in SQL Server Reporting Studios. Administrator for Project Server 2010 SharePoint interface. Coordinate with IT Stratus SQL Development Team to end users using Pilot Project Server System. Provided administration and help desk support for MS Project 2010 Server for EMC projects. Coordinate with team leads act as liaison between the business and ITS served as liaison between Cost Engineering and IT support groups relative to the deployment and maintenance of approximately 200 projects (~$500MM). * Provided problem solving technical support to cost and engineering analyst such as importing of large data extracts from SAP financials Project Server SQL Based project management system. * Provided ad hoc reporting models through direct connection to SQL Server using Excel Power Pivot. * Designed OLAP cubes for Financial Dashboard Reporting. * Provided feedback/lessons learned from pilot deployment of MS Project 2010 Server (ERP) to the STRATA Sequel team (designing the EMC project management system using MS Project 2010 as platform) to help shape the optimal project management user interface. With direction from business stakeholders design import application from access databases for cost engineering to Project Server. Writing and document stored procedures in SQL for Reporting Development. Agile Scrum environment. Document issues with pilot program to increase efficiency in strata 2.0 system deployment. Reporting functionality documentation I.E. (currency exchange rates from US to Local foreign exchange). Critical Mention -New York, NY- Online Media Tracking Start-Up Lead SFDC Technical Architect/ Product Manager January 2012 January 2013 Summary: Project Lead for deployment of Business Intelligence System connected Salesforce CRM. Design, programming and budget of Business Intelligence System integrated with SFDC using SAS programing to provide business finance reporting, forecasting, accounting and Sales marketing strategy data analysis. Redesign salesforce contract module to provide revenue recognition via customer workflow for contract approval to generate invoices also provide reporting views to supply Cash on Hand and deferred revenue for Media Analytics contracts such as (Southwest Airlines, McDonalds and Marketing firms). Achieved operational objectives by contributing information and recommendations to strategic plans and reviews preparing and completing action plans implementing production, productivity, quality, and resolving problems completing audits identifying trends determining system improvements implementing change. Managed and mentored group of 5 Salesforce, Java developers and ETL engineers. * Designed and configured Salesforce (CRM) integration with Internal Admin MySQL for deployment of reporting MSSQL server 2012 based Business Intelligence (BI) system for finance reporting and invoice billing. * Designed Salesforce (CRM) business process from Sales to billing to contract renewals. * Gathered requirements from business stakeholders. * Developed and managed project plans, including user/client requirements and deployed systems on time and within budget. * Developed integration plan with existing Salesforce (CRM) interface. * Programmed Salesforce REST API's to connect to DBSYNC/DBAMP data extraction to SSRS. * Defined business rules around sales data to approval of contract. * Provided Users with comprehensive test plan and business process documentation regarding data entry though Salesforce (CRM) to SQL server data warehouse accounting system. * Created three design specifications, including scope and budget managed deployment strategy and deliverable schedules. * Lead and run Agile Scrum Daily stand ups meetings. * Drive sprint deliverables and project roadmap. * Provided marketing team with data extracts from salesforce through SQL Server Stored Procedures. * Designed (SSIS) SQL Server integration Asp.Net packages for data transfer from MySQL to SQL Server 2012. * Configured and created data warehouse from Salesforce cloud based URL to SQL Server 2012 Financial Business Intelligence system. * Worked extensively with the end users team in understanding the business rules and writing requirement specs, technical specs and mapping documents (UML) from staging to data mart, cubes and reporting needs to the end user community. Summary: IT liaison to Project Governance, Business finance during deployment of Project Management system, Support Reporting requirements from SAP Business warehouse to SQL Server Project Management system with SAS programing supporting Project Managers for Cost and Engineering of gas and electric transmission. Provided business finance reporting for forecast data models for budget and Scope of project plans. Acted as MS Project Server 2010 SME to PM's and IT Administrators * Defined business requirements in regard to database structures and document availability of data. * Managed group of three business analysts. * Created use cases for data mining and data processing time improvements to ETL. * Created documentation for data security workflow for project governance department. * Worked with project governance department defining business process documents. * Setup SAP automation jobs for data extracts to Project Management System. * Designed business process for finance reporting analysis and financial reports to support maintenance and engineering project managers. * Authored written procedure for business process for reporting requirements. * Assessed need for and designed detailed dashboard reports for Upper Management. * Responsible for reporting and analysis at the portfolio level project reporting schedules to support business finance and project governance teams * Worked with the enterprise systems architects and databases leads to fine tune requirements into portfolio level reports to support leadership and analytics teams. Agile Scrum environment. Bank of America/Merrill Lynch - Hopewell, NJ Sr. Data Analyst May 2010 - September 2010 Summary: Design and maintain reporting requirements to Support finance advisors for global wealth management. Gather requirements based on business need and objectives such as targeting new customer growth for annuities and trust. * Created complex reports using SQL Server 2008 reporting services (SSRS) and VB with excel backend programming creating links from excel tables using Pivot method to SQL server. * Provided product sales data with adhoc SQL queries from several different data sources SQL and Midas Data Teradata DB2 oracle warehouse. * Managed UAT efforts with in Users and developers. * Worked with ETL developers to implement requirements. * Trained business users on how to use reports. Summary: Forecast Analysis wholesale data for generic pharma products from customers such as Walgreens, Walmart and CVS. Design and gather requirements to produce reporting to support various teams based on Regional market strategy within the US. * Generated the 18-month Demand Forecast in the APO system and the Global Five-Year Demand Planning System. Identified and executed corrective actions to reduce sales forecast error. Conducted marketing analysis and support at the SKU Level reported and trended using Excel macros. * Developed automated triggered reports to provide changes in forecast based on supply chain and inventory levels. * Performed customer order analysis provided updates on status of customer order trends revised customer forecasts based on trend analysis. Provided insight and interpretation into historical and future anomalies in actual volumes. Responsible for analyzing customer historical ordering patterns and inventory levels and reviewing/analyzing customer orders in Demand planning module of SAP. Acted as a liaison to development teams to support customers using Salesforce for order management data, gather information in support of order and inventory analysis and provided reports/updates on product requirements and holdings. Thermo Fisher (Clinical Trial Division/ Pharmaceutical/Biotech) - Allentown, PA, United Kingdom and Singapore Senior Lead Product Manager /Technical Architect/ Fisher Clinical Services September 2008 - January 2010 Summary: Lead Project Manager designing and ensuring successful deployment and implementation of key clinical systems related to project/study management, document collection and archive, and data collection/transfer. Operated autonomously to deliver systems globally, on-time, and within regulatory and user required specifications. Partnered closely with Quality Assurance, Compliance, key stakeholders and vendors/suppliers to drive on-time project delivery, within budget. Directly worked with developers, provided training and oversaw development process in the UK. * Developed project plan with global team, including user specification requirements, technical roadmap, and deployment plan for clinical project management system. System designed to interface with clinical document management system (eTMF) and providing reporting on project timeline/deliverable compliance rate (e.g., number outstanding documents not uploaded to eTMF, missed milestones such as First Patient First Visit, etc.). * Worked collaboratively with stakeholders form Compliance, QA, Manufacturing, Legal, Contracting, Clinical, Regulatory, Data Management, etc. to ensure functional area requirements were met and included within project specifications. Variabilities in Vendor Service Level Agreement potentially impacting project scope were also considered. * Performed retrospective review of prior projects to identify lessons learned and best practices to implement into project plan performed risk assessment and included risk based approach on project and deployment plan. Continued to assess risk throughout project lifecycle. * Designed project vision and roadmap with stakeholders created measurable and quantifiable efficiency/performance/reliability metrics for the software systems. * Responsible for creating project proposal with initial product requirement specifications and presenting to Executive Management to secure funding for the high-profile project (due to high budget) following project approval, trended and analyzed performance and financial data, and presented routine status reports to management from initiation through deployment. * Ensured timely project execution through weekly meeting with global IT Project Management Leads. * Managed project budget and software license distribution globally in the US, UK and Singapore. * Designed global test plans to roll out to all users within clinical trial division US and UK offices. * Designed maintenance schedules for system backup and maintenance for server updates in both US and UK offices. * Developed and managed electronic dashboard of project status and provided regular communication of performance to project team, in order to ensure adherence to timelines and deliverables. * Preformed data analysis for KPI dashboard reporting based on client contracts. * Designed UAT Test Plan and test cases, with QA input, for User Acceptance Testing (UAT). Test plan encompassed complex scenarios and designed to test global functionality. * Performed GAP analysis of business rules and system process flows, user administration, and requirements. Ensured GXP with QA and regulatory compliance. * Defined requirements, and authored associated SOPs, to assure data integrity and protection for patient data from blinded and unblinded clinical trials with input on parameters from Clinical Operations, QA Compliance, and vendors/collaborators. * Defined and proceduralized the current end-to-end business processes and identified tooling solutions to aid with future streamlining and scaling. * Worked with the various engineering and data teams to design and develop a scalable solution that meets their goals and objectives. Oversaw the development process oversaw testing (pilots, user-acceptance etc.). * Managed deployment tasks (tactical cut over activities) with End Users and IT Administrators provided training for relevant personnel. * Managed junior Business Analyst and Project Manager' in the US, UK and Asia offices on functionality and Technical Use Cases. * Created data management SOP documentation for comprehensive system rollout for client services. * Created Production Migration Playbook for deployment from Stage to Production Environments. * Managed changes to the project scope, project schedule, and project costs using appropriate verification techniques. * Established and maintained relationships with third parties/vendor such as C# developers and .Net developers, ensuring vendors met the requirements of their contracts, on-time. * Created and maintained comprehensive project documentation, according to applicable Health Authority regulations and ICH-GCP. * Tracked and provided communication plans for deployment of MS Project server for both technical and functional team members. * Defined database business rules for user interfaces. Provided user login process for Citrix web interface with MS Project for Project Managers working off site. Configured Network to allow connection to Server. * Coordinated cross-functional development of project plans interfacing with team to fulfill project contract obligations with Merck, Lilly and Gilead. * Lead, managed and published project meeting results, action items, and milestones for multiple MS projects. * Analyzed weekly project completion trends, producing forecast reports of gains/declines for financial trending and maintaining records and data for multiple projects and programs.
Accomplishments
Highlights:
Companies I like:
program mgnt
Keywords
