Data Warehousing Resume Profile
Summary of Qualifications
Solid background providing innovations in start-up and turnaround cases leveraging information technology, the last 17 years providing management consulting in complex, high value engagements, of varying complexity, from telecommunications and logistics to financial systems management, from Middle East and Europe, from the Commercial sector to the Federal Government and the District of Columbia. In-depth knowledge of project management emphasis on Risk, Earned Value and PPM , Business Process Re-engineering, Data Warehousing/Data Mining and Supply Chain Management. Extensive knowledge of top tier business applications acquired through leadership of numerous mission-critical, full life cycle deployment of applications from mainframe to web platforms. Expert in the strategic management of technology, process improvement Six Sigma certification , Software Development CMMI-2, 3 , management consulting and engineering/manufacturing environments. Expert in analytics: linear regression, logistic regression, trees, text analytics, clustering, visualization and optimization. Excellent problem solving, verbal, written, interpersonal/teamwork skills. M.S., Engineering, MBA PMP and Six-Sigma certified. Secret Clearance.
Summary of Accomplishments
- Managed a web-enabled telecommunications implementation serving 380 users and 90 agencies for ordering telecommunications services, managing agencies' budgets and for reconciliation of 30 M annual telecommunications aggregate vendor invoicing. Discoveries from system of fraud, waste and abuse demonstrated greater than 3 M annual savings payback of 1.9 years and ROI of 300 .
- Managed entire IT service delivery platform implementation for a 35 M Managed Services telecommunications outsourcing contract between Ameritech and a major chemical corporation, supplying global help desk capabilities and full managed services, including CDR collection from 44 PBX and 2 Centrex sites across the U.S. and Canada.
- Have contributed to successful implementation of products having overall impact of 100 M in long distance preparation for Ameritech: discovered revenue opportunity of 45 M from MI zone usage for inclusion in intra-LATA toll product.
- Established EDI with key suppliers for purchasing/drawing information exchange, resulting in 47 reduction in unit cost of structural components for Rockwell Goss printing press manufacturing.
- Developed plan for re-engineering of core business design-manufacturing systems, consisting of cross-functional teaming, 3-D CAD/CAM software implementation, client-server from mainframe migration, and prototype development: funding was facilitated via short-term success of European automated drilling software implementation in U.S. plants, saving more than 1 M annually in each plant.
- Designed multi-parameter search software for commercial parts database, providing online results in fractions of a second instead of weeks.
- Produced computer system regression analysis reporting system supporting 3.8 M upgrade in CAD/CAM environment, offsetting 7 M productivity loss.
- Redesigned manufacturing orders management system for B-1B Bomber production, resulting in annual savings of 1.1 M.
- Implemented Iraq enterprise application for project portfolio management that enabled capture of 4 M in withheld billings
Technical Skills
- Office Integration, Operating Systems, Project Management, Telecommunications Landline and Mobile and Fixed Wireless CDMA EVDO Rev A, GSM/EDGE/WiFi, WiMAX , ERP Oracle E-Business Suite , CRM, Web Development Linux, Apache, MySQL, PHP Languages: HTML, XHTML Client-side coding: JavaScript Server-side: ASP, ColdFusion, Java, Java J2EE PythonDatabase Technologies: DB2, Oracle , Data Warehousing ETL processes, ERWin modeling Oracle ERP, Oracle 11i, MS SQL Server databases . Logistics Supply Chain MS Office Suite, XP Professional, Windows 7, PowerPoint, Visio, MS Access, Excel, MS SQL, IBM MVS, VM, Lotus Notes, UNIX MS Project 2003/2007/2010, Primavera 6.2, BIMTM , and PMBOK, EVM ANSI/EIA-748 COMIT, MSPS, Clarity, Remedy PeopleSoft HRMS 8.01, AMAPS/Q ACS/IQ Visual Studio.net, FrontPage Sybase, Oracle 8i/9i, 10, 11i, DB2 VB, UML, RUP Embedded software C, C
- , Crystal Reports Manugistics CADAM, CATIA, SDRC, EDS Unigraphics Interwoven, Maximo Asset Management, Momentum Financials, HP/Mercury Project Portfolio Management PPM Center 7.1, 7.5, SharePoint Performance Based Logistics PBL ITIL v3, Six Sigma Certification SharePoint, dot.Net MS Project Enterprise Server Informatics Data Analyzer, Oracle Hyperion, UML, GAP Analysis, JAD Sessions Lead, Data Entity/Modeling, Decomposition. SAS Enterprise BI Server, Popkin System Architect Oracle Fusion Middleware platform comprising WebLogic Servers, Oracle Service Bus, SOA Suite and OBPM IBM WebSphere MQ and WebSphere DataPower XML appliances to ensure secure integration with external third parties., SaaS, Cloud Computing, VMware, Epicor, Agile, Scrum, Scrum Master Statistical application, R.
Professional Experience
Confidential
Working on 1. SBIR development of S-band plasma limiter to protect RF electronics, specifically within radars, in particular, Differential Reflectivity Radar, in order to mitigate the disruptive, high-power, short pulse electromagnetic interference EMI and high power microwaves HPM 2. The health effects of pervasive electronic device electromagnetic transmission.
Confidential
Provide tutoring to Northern Virginia in all Math subjects through Calculus and Differential Equations AP Physics, Statistics, Computer Science, Chemistry, Biology and all SAT subjects. This work was taken on during recuperation from MRSA April 2013 . WyzAnt, Inc., works with over 500,000 tutors and serves over one million students, the company has amassing more than 100 million in gross sales to date
Confidential
Manager, Business Process Analyst, August 2011 August 2012 BPA and September/2012 May 2013 as PM
- Hired as Business Process Analyst Level 3, have provided business process analysis within team of SW engineers, business analysts, data/enterprise architects, DBAs, data modelers for capturing interfaces and data modeling, standardization for the software development use of standard SDLC as well as Agile methodology of a Case Management Application for managing subsidized child care for 15,000 families in the DC region, encompassing case, finance, and provider management. Software and business process standards were analyzed and selected. Extensive JAD sessions held with the Business Unit The typical sessions combined techniques from data modeling entity relationship diagrams , business modeling work flows , object modeling, and component modeling. Use Cases were employed in the creation of the Financial Requirements. Meta data, data dictionaries employed for data conversion. Extensive sessions held on data architecture in ETL design. This detailed business process standards work consisted of further decomposing and defining business process and data standards for select core financial management functions. Responsible for Normalized and fully attributed logical data model showing kernel entities, associative entities, characteristic entities, cardinality, unique identifiers and all attributes 2. Business Meta Data data names, data definitions, data relationships, unique identifiers, data types, data lengths, domains, business rules, policies and data ownership 3. Data-cleansing specifications and consequent pilot development of SQL queries for transformation of source to target data 4. Expanded enterprise logical data model.
- Provided consulting on Data Warehouse for capturing student data, from infancy through college and into career: particular contributions focused on Project Schedule/Plan which did not adhere to my plan which entailed Business Case Assessment, Enterprise Infrastructure Evaluation, Project Planning, Project Requirements Definition, Data Analysis, Application Prototyping, Meta Data Repository Analysis, Database Design, ETL Design, Meta Data Repository Design, ETL Development, Application Development, Data Mining, Meta Data Repository Development and Implementation this provided a continual battle for change and adherence to logic consulted on interfaces/authentication of users from different entities and data format to capture significant fields. Historical data from DHS agency had to be thoroughly reworked. All requirements were housed in SharePoint as well as Quality Center, used for developing extensive test scenarios. Rigorous Change Management employed. The new Case Management system had captured the as-is process models and made radical to-be process model changes as the paper flow had evolved to a completely electronic flow., eliminating physical hand-offs to agencies
- As PM, have worked within PMO, having served as SME for the implementation of Microsoft Project Server Enterprise for all OSSE Managers and Project Managers, which has included standardization of status reporting, risk and issues management as well as resource allocation, enabling optimal resource utilization across the OSSE enterprise. Implemented deliverables tracking and project artifacts per phase check off, as well as customer ticket through charter process. Business Performance improvement was the objective.
Confidential
- Managed multiple projects 5-7 routinely as part of a dedicated, Real Time Messaging Platform Team as Capital One was in the process of moving its legacy systems onto the Enterprise Service Bus ESB to take more advantage of Service Oriented Architecture to oversee the engineering and management of new technologies.comprising new credit card applications for credit card customers. When defining FMSB, the over arching concept was to use ESB to orchestrate all services and reuse them as needed. All development consisted of standard SDLC as well as Agile sessions held daily typical 15 minute Scrum sessions for critical product development schedules. Requirements, schedules, issues, status reports maintained within Clarity Project Portfolio Management application, in order to standardize reporting and metrics across the enterprise.
- My role in this team was as a Technical Project Manager for the production systems, managing the testing conducted by the offshore support team Infosys , overseeing the transition of new services into the live environment and holding responsibility for the strategic technologic direction of the platform. Team matrix consisted of 100 individuals
Confidential
- Provided program management for Total Life Cycle Management TLCM, MCO 4000.57A Program for USMC as part of CSC's Defense Division as Senior PM . Commenced engagement by completing Action Officers' School in Quantico. Served as Senior Project Manager for TLCM process, establishing PMO for managing TLCM, and contributing to the development of effective ground based war-fighting capability and translating needs to the requirements process through identification of capability gaps, requirements generation, acquisition, fielding, sustainment, and disposal of materiel solutions . Mission requirements met through use of Six Sigma methodology integrated value stream. The 4 goals listed in the order include: Ensure unity of effort maximize equipment operational availability institute data quality which included use of Informatics Data Analyzer as part of baseline determination optimize total operating costs for ground weapon systems, equipment and material. Governance set by an Executive Board TEB, including General Officers and SESers and the Corporate Board TCB, including Colonel and GS-15, in which I acted . Managed seven Integrated Project Teams IPTs: Data Quality Equipment Visibility Sustainment Planning, etc. represented from each major Marine Corps organization, e.g., Systems Command MARCORSYSCOM , PEO Land Systems, Marine Corps Logistics Command MARCORLOGCOM , etc. Employed Business Intelligence reports, Business Objects, Informix for the Data Quality IPT in data mining and analysis. Developed SQL scripts for multiple data feeds. Provided team leadership for USMC GCSS for Logistics management of retail supply, wholesale supply, equipment maintenance, and repair functions , in, consulted on the development of the data warehouse, ERP, use of VMware/Epicor solution, the MDR, comprising a blend of existing legacy data legacy mainframe supply SASSY and maintenance MIMMS systems to the Oracle based GCSS-MC alongside new information from GCSS, filtered via data discrepancy reporting to cleanse legacy system data prior to the migration to the new system. Contributed to establishment of data governance to improve data quality, establishing data standardization, business rules and calculations and extending this to the data verification and validation in the ETL Process, enabling data discrepancy reporting and communications of metrics of data cleansing efforts back to users. In summary, developed reports using a variety of business intelligence tools. Additional work was performed in developing SQL queries used in dashboard report generation function.
- Also conducted research in supply chain cyber security. Produced 100 page white paper as deliverable.
Confidential
- subcontractor to SAIC in Iraq, i.e., save contract, which was accomplished. Provided program management to DoD/BTA/The Task Force for Business Stability Operations TFBSO performing program/project management work for Mid-East Iraq economic revitalization, in which the State Owned Enterprise model was being converted to one of privatization. This Secret Clearance work encompassed establishing PMO, implementing Project Management standards, assessing plant operation requirements, providing plant production capacity assessments, determining machinery and raw materials, establishing Cooperative Agreements with Directors General/Ministries for providing companies with funding. In addition, led the implementation of a Project Portfolio Management application HP PPM Center and its interfaces to SharePoint and Financial Systems, e.g., Momentum Financials for managing and providing a single repository for complex contractual and project documentation and for enabling full collaboration between users engineers, PMs, Finance personnel, etc. . The implementation included extensive business analysis to establish exact requirements in a classified environment , market research, system design, team development from Israel to Reston, VA integrator to California establishment of full business and technical specifications, data architecture/modeling proposal development and negotiations with HP, Air Force and other Pentagon personnel for selection of HP. Also worked on blue-force tracking which relies on advanced voice and data location-position reporting radio systems, as part of the Force XXI Battle Command Brigade and Below FBCB2 System. Applications included establishment of risk in scheduling plant visits. Additional work was performed in full encryption of data, particularly sensitive data such as Director's General names. Work included providing Pentagon with 24X7 information on 70 projects 100 Million : via Dashboard providing Gantt progress, issues, risks, e.g., for conducting site visits money in action through disbursement and all project documents/artifacts Customization of the dashboard required development of SQL queries. Provided training in use of HP PPM Center to general officers, executives, management, engineers, PMs and Finance personnel on site and in Pentagon.
- Site visits entailed flying in helicopter or C-130 and Humvee to plant under armed escort to meet with Directors General and Principal engineers, from Basra Petro-Chemical in Basra at the southern point of Iraq to Fallujah Cement and Ramadi Ceramics noted high insurgent activity areas and many other areas in Iraq,. Managed 10 projects directly and oversaw 70.
Confidential
- Directly responsible for the implementation of HP/Mercury Governance System HP Project Portfolio Management Center 7.1 for project portfolio management for MPD OCIO and other agencies for the District of Columbia. Working within the PMO, provided project management and technical consulting for the 100-Day Wireless MDC Upgrade and Laptop Deployment pilot, providing Officers' remote processing of arrest/incident forms and access to NCIC/WALES, Additionally, provided management consulting for MPD Application Server Consolidation, Data Warehouse Planning, in which a network of regional data exchange, interoperability initiatives, and data warehouses would assist MPD in solving crimes . Criminal History Background Check Automation, Online Arrest Record Search Engine prototype developed for scanning and providing online, two million pages of arrest/incident history , Scheduling SW Optimization and PKI-Paperless Approval Process for chain of command routing and approval, affecting potentially 4,000 officers. Public Safety Radios programming management experience gained through 100-Days initiative.
- Contributed to the data warehouse development, the primary purpose being the use of predictive analytics to predict and map crime to understand that if criminal behavior follows an identifiable pattern time, place, past histories, circumstances , it can use those factors that characterize the criminal act to predict its occurrence and improve the safety of its citizens. The intent was to produce every day a map of where its officers ought to be, based on the history of crime, adjusted for seasonality, events such as concerts and allows cops not to patrol randomly but to be where it matters. Map generation entailed developing SQL queries used for the dashboard/map application. My additional contribution entailed working with data architects to determine relationships, if any, between data types, superimpose a logical structure, present an ER diagram, divide into tables/fields, determine primary keys, apply normalization, estimate frequencies of operations to determine optimal performance and pilot different schemas. Additionally, experimented with applied regression analysis to justify correlations between different factors, such as crime vs ambient temperature, day of week, time of day, and events drawing attention away from crime areas.
Confidential
- management consulting and Program Management for OMB, FSIO/GSA Office of Government-wide Policy, Office of Technology Strategy for Financial Management Line of Business FMLoB , a Federal Government-wide E-Government initiative, chartered to streamline the delivery of Financial Management Services, employ standardized Federal Enterprise Architecture FEA , in support of four 4 OMB-sanctioned work-streams: Migration Planning Guidance for agency migration guidance to one of four Shared Service Providers SSPs , Performance Metrics, Business Process Standardization BPS and Common Government-wide Accounting Code, supporting the reengineering for financial systems of 24 federal agencies. Managed teams to contribute to 3 of the four work streams, the common government accounting code being managed by in-house GSA group. Hired The Hackett Group for defining Performance Metrics - promoting benchmarking for SSPs and agencies for best practice implementation planning enabling convergence of the work-streams, performing benchmarking for DOC as a pilot. Assumed the role of a Business Analyst function as full understanding of requirements was necessary in order to accurately determine the detailed requirements for Business Process Standardization: this encompassed the base lining of the as-is process model to the to-be process model to standardize business process such as accounts receivable or payables, to the optimal processes. Software and business process standards were analyzed and selected. Extensive JAD sessions held with a majority of Federal agencies,typical sessions combining techniques from data modeling entity relationship diagrams , business modeling work flows , object modeling, and component modeling. Hackett provided an assessment of GSA as compared to world class metrics the BPS Team created all the process flows for major accounting functions of Receivables, Payables and Reports. Agencies were to have been expected to adopt the business process standards and to have standardized their processes as part of their migration once the detailed business process standards were completed. This detailed business process standards work consisted of further decomposing and defining business process and data standards for select core financial management functions. As Managing Principal, the deliverables I was responsible for were 1. Normalized and fully attributed logical data model 2. Business Meta Data data names, data definitions, data relationships, unique identifiers, data types, data lengths, domains, business rules, policies and data ownership 3. Data-cleansing specifications 4. Expanded enterprise logical data model. Additional contributions entailed working with data architects to determine relationships between data types, superimpose a logical structure, present an ER diagram, divide into tables/fields, determine primary keys, apply normalization, estimate frequencies of operations to determine optimal performance and pilot different schemas. This was done for the objective of providing a data warehouse, fed by the 4 Shared Service Providers, acting as Data Marts.
- Experience developing reports using a variety of business intelligence tools became a fundamental to the Reports functional area, in association with A/R and Payables.
Confidential
|
Confidential
- Implemented key telecommunication/financial management systems to support all DC government's major agencies and manage fifty thousand stations and associated circuits and equipment, producing 3 million in telecommunications savings annually to the government through technology tools and audit procedures built within the application. SW application developed to process raw telephone data from 8 Verizon Central Offices and various cellular phone data, in order to provide true billing reconciliation. Provided entire Business Analysis effort for the billing reconciliation requirements, based on prior managed services PBX and CENTREX national network of Dow Chemical and United Airlines models. Managed 35 personnel from prime and sub-contractors and interfaced vertically from CTO/CFO to SW engineers, reporting to deputy-CTO. Provided agency-level technical direction and management for the OCTO Telecommunications/Information Technology assets and infrastructure support systems, as well as having reviewed, written, and enforced numerous policies. Including advising on current policies, procedures and laws from various agencies. Have engaged in the analysis of emerging technologies and how the District might best utilize them. Have assisted in the development of strategic plans/charters, business cases and Statements of Work have conducted research and evaluation of untested IT services and solutions proposed by District agencies related to IT innovations. Specifically, I have implemented a large-scale web-enabled telecommunications management system accomplished via managing a SW/Web Development effort involving standard SDLC
|
- Employed PMs, Task Order PMs, SW engineers, DBAs, Web developers, Testers, Technical Writers, etc. that serves 90 agencies and 500 users, and is still used today 2013 implemented software to comply with CFO-mandated anti-deficiency ruling provided law enforcement agencies with vital raw call data . All SW development entailed conducting and leading design sessions for customizations applied to, MSPS, how data was to be used, WEB application standards, options, i.e. Apache, IIS extensive testing to ensure security of each agency's telecommunications data, etc. Also provided all infrastructure capture for DC Net and migration to VoIP. Additional consultation in initial stages of wireless interoperability program 700 MHz , as well as consulted with Public Safety for CAD 911. Specifically worked on interoperability between formerly incompatible Land Mobile Radio LMR and broadband systems, as cellular networks were used as secondary systems,, to produce/collaborate on plans for concept of Radio Over Wireless Broadband later named ROW-B extending the capabilities of existing public safety communication systems to enable seamless voice communications between LMR and broadband systems, thus demonstrating public safety integration of new technologies with existing emergency response communications systems. Finally, worked on, under direction of CTO, feasibility of traffic signal camera placement for license plate image capture during red-light violation episodes.
Confidential
Initial role consisted of performing function of Business Analyst, to gather requirements associated with collecting appropriate data from 14,000 stores. Provided recommendations for the Product Mix Re-engineering effort, in order to optimize, primarily, the distribution of Self-liquidating premiums, under a new marketing effort that increased and decreased the durations of promotionals . This entailed employment of Manugistics Supply Chain management application. Data warehousing management included profiling self-liquidating premiums sales/distribution data with demographic and promotional timing data. .Additional contributions entailed working with data architects to determine relationships between data types, superimpose a logical structure, present an ER diagram, divide into tables/fields, determine primary keys, apply normalization, estimate frequencies of operations to determine optimal performance and pilot different schemas. In the end, distribution centers became data marts of the main data warehouse.
Confidential
Defined, developed and managed the implementation of information technology solutions for Managed Telecommunications Service contracts for Dow Chemical and United Airlines. Developed pre-sale support function for IT project management, defining the processes for feasibility analysis, due diligence, outsourcing analysis, service delivery platforms and project budget development. Acted as primary liaison with customer for IT/network design, including data warehousing for outsourcing management of major accounts comprising national program, providing technical solutions to complex business and telecommunications issues, Contributed to the implementation effort for global departmental chargeback by conducting a series of working sessions at Dow Chemical, Ternuzen, Netherlands, with representatives from MCI, British Telecom and Ameritech.
Confidential
Performed strategic planning for the utilization of the company's software highly regarded for its tapered beam steel optimization for its competitive advantage in this metal buildings manufacturing arena. I have worked with the president to determine the potential for continued use of proprietary CAD/CAM software in the customers' building packages, versus the use of commercially developed software.
Confidential
Performed Client-Server and mid-range assessment for meeting Year 2000 compliance.
Confidential
Defined, developed and managed the implementation of information technology solutions for Change Management, devoted to providing billing capability for products in intra-LATA toll, Advanced Intelligent Network, and in Long Distance preparation. With the telecommunications act of 1996 and consequent breakup into Baby Bells, Ameritech was now provided an opportunity to enter long distance. I helped developed new products by reviewing the new policies, that would ensure customer retention and yet offer packages that bundled local and long distance. Provided consultation for the migration from IMS to DB2, for Custom and Enhanced Business accounts. This role was predominantly a Marketing support role for providing customer retention in intra-LATA toll for migration into Long Distance.
Confidential
Performed successful business and systems integration of sanitary supplies business into Grainger mainstream. Led the effort for business and systems integration for Greenfield startup sanitary supplies business. Additionally, served in the project management of the migration from BOP/ICS to distributed Sybase - RS/6000 solution for 350 sites. Managed SW development in integration and interface development.
Confidential
- As part of a President-appointed swat team, managed mission critical engineering/manufacturing/information systems impacting printing press manufacturing for U.S. and England plants. Press manufacturing provided innovations in introducing color to high production offset printing 70 K papers per hour , large motor drives, PLC control systems and others. Responsibilities included conducting full post installation audits, field investigations, development of supplier support systems, and leading of major systems integration effort, which included re-engineering of core business design-manufacturing systems: this consisted of cross-functional teaming, 3-D CAD/CAM software evaluation, Electrical and Mechanical Engineering principles and practices. Role encompassed meeting with executives all over the country at N.Y. Times LA Times Boston Globe, Ft. Lauderdale Sentinel, etc.
- Managed SW development for inventory production control when taking over production of RTP manufacturing in Cleveland, OH, managing code development in C .Also, provided consultation in embedded SW development, having specifically written code for part of inking control, SW written in C .
- Earlier, had made process improvements to Engineering Standards by eliminating commercial parts books publications via electronic multi-parameter search algorithm, written in IBM Assembler, that enabled a multi-parameter search in a fraction of a second, compared to is taking up to two weeks. This feature was implemented in all plants, saving 1 million per plant.
Confidential
Led IT systems/telecommunications support for Columbus plant 6 plants, 7,000 employees that provided manufacturing for B-1B Bomber production forward intermediate fuselage and right/left nacelle sections . Managed the design and development of system innovations resulting in substantial operating cost reduction. Interfaced with Seal Beach IT headquarters, and other divisions Rocketdyne, Palmdale .
Confidential
Performed competitive analyses of the security systems market to determine product strategies for the IBM mainframe market segment, developing software in IBM assembler language.
Confidential
Managed Computer Aided Architectural Design software group for IBM systems division in a collaborative effort with Carnegie Mellon, to develop state-of-the art software for architectural design. Developed innovations in 3-D solids modeling.
Confidential
Reviewed daily NWS facsimile charts, text forecast information. Worked on and created own local forecast. Presented on-air 3-minute broadcast of national maps/forecast and local maps/forecast, describing frontal zones, highs and low pressure, climatic data and forecast for today/tomorrow, 3-day, week and long term outlook.