- Featured in:
Additional Inventory Management Resume Samples
Data Warehouse Manager Resume Samples
No results found
0-5 years of experience
Managed maintenance and day to day operations of the Data Warehouse System, the Archive and Purge Process, data changes in DB2, and the reconciliation of daily reports. These actions helped to facilitate improvement in system performance, security, customer satisfaction, and the accuracy of the customer's data.
- Executed, maintained, and created SAS jobs for the Change Data Capture Process and the Order History Archive and Purge Process.
- Preserved data integrity in DB2 Tables, performed problem determination, corrected data, and created SAS jobs to monitor data.
- Created and maintained the documentation for data integrity processes.
- Generated documentation for all of the Data Integrity Issues.
- Worked with both the customer and IBM Employees to resolve data issues, saved IBM over $200K in contract deviation expenses.
0-5 years of experience
Directed the Data Warehouse and Infrastructure/ Support Groups within the Enterprise Systems Division and became the first to utilize the internet to deploy data marts with OLAP functionality.
- Led cross functional team of 6 and budget of $1.5MM.
- Reduced telecommunications costs by 20% for Sales force automation application.
- Successfully re-engineered every application within data warehouse to comply with Y2K changes.
0-5 years of experience
Supervise Business Intelligence and Data Warehousing employees and contractors, ensure availability of business intelligence systems, monitor BIDW budget, ensure data quality, provide timely delivery of all BIDW projects, create work breakdown schedules and allocate resources using MS Project, manage vendor relationships, gather requirements, create use cases and traceability matrix, create work and data flow diagrams in Visio, write test scripts, maximize SWHP's BI investment by engaging user community.
- Eliminated a two year backlog of work by implementing project management methodologies and MS Project
- Resolved mission-critical licensing issues for BI assets through cultivation of effective relationships with vendors
- Produced models of multiple undocumented data sources to support traceability/impact analysis for BI projects using Embarcadero
- Created RFP and managed proposal evaluation process for Phase 2 of SWHP's Data Warehouse implementation
0-5 years of experience
Planetout, Business Intelligence/Data Warehousing
- Led a team effort of four to consolidate entire data repositories across enterprise as part of the merger and acquisition. This includes merging 37 new data sources into conform star schemas from different types of DBMS.
- Took the sole responsibility of building data warehouse ground up, worked on architecting, ETL, administering data warehouse constituting click stream, financial and various business data marts.
- Performed application side DBA role of user management, data access control, system setup and physical/logical storage management and application tunings.
- Modeled database and designed architecture of OLAP layer of BI system and automated the visualization of diverse data sources into customized business reports.
- Hand coded all the backend working scripts that refresh the entire warehouse.
- Involved extensively in business reporting, data mining, ad hoc analysis and business/financial forecasting across various departments.
0-5 years of experience
Manage a team of 13 full time and contract staff in the development and support of TVA's enterprise data warehouse.
- Deliver new data warehouse solutions. Sponsor development projects, including an effort to implement Oracle's business intelligence suite and a reporting software standardization project.
- Maintain support for multiple applications including Cognos Business Intelligence and Cognos Planning. Led the support staff through a lean transformation effort that improved incident and product backlog management, and instituted a process for continuous improvement.
- Develop strategic plans. Collaborated with software vendors, industry experts, and TVA strategists in the development of a 4-year investment management plan.
- Facilitated IT-business collaboration through the management of governance activities for selected enterprise applications. Developed a new governance model that focused on business process improvements and technology optimization.
- Increased awareness of the total cost of ownership for software through the development of new financial planning processes. Improved budget management transparency for application enhancements through the implementation of a new estimating and budget management process.
- Improved communication through the management of a business oriented monthly technology informational session. These sessions provided status updates for enterprise projects and a forum for introducing new concepts.
0-5 years of experience
Masterminded the 3-year BI and corporate reporting strategy
- Executed a successful executive road show and campaign for a multi-year, multi-million
- Principle architect for all data warehouse, ETL, Cognos, E.piphany, and source reporting
- Managed a multi-million dollar BI and corporate reporting budget
0-5 years of experience
Responsible for leading the data warehouse and business intelligence efforts of 4 IT professionals
- Highly technical role requiring significant DBA, T-SQL, and ETL knowledge and effort
- Identify, capture, and analyze billions of records for retail clients all while maintaining strict confidentiality. Analysis includes piecing together disparate datasets, identifying trends, and developing algorithms to determine relevancy and isolate data abnormalities.
- Role includes technical architecture and design, prioritization and planning, and coordinated execution. My DBA responsibility includes maintenance, deployment, and optimization of dozens of databases representing terabytes of data.
- Implemented a new structure to standardize, log, and automate various SQL functions. The result has been significantly cleaner data, fewer issues when building datasets, and significant performance gains when querying the data.
- Streamlined data gathering which greatly improved speed (over 300% improvement) and reliability.
- Improved analysis and reporting of one of the most difficult segments of retail sales, namely special orders. Actively consulted with a major retailer to show them how to improve their reporting of this segment of sales.
- Implemented a thin client architecture greatly improving the speed and reliability of transactions.
0-5 years of experience
Drove BI strategy, projects execution, operations and developing/maintaining relationships with leaders of several business functions within the company. Provide technical leadership in the definition and expansion of the DW and BI strategy and operations.
- Constantly monitored performance issues and taking appropriate actions whenever necessary.
- Managed global (Off-shore Development) project team, resources, documentation, deliverables, time lines, scheduling meetings and JAD sessions etc.
- Developed presentations for finance, marketing and sales groups, maintaining in-depth knowledge of the related banking products and acting as a liaison between business & BI group.
0-5 years of experience
Led effort in Knowledge Warehouse development for SAP integration (Project Viking).
- Managed Data Warehouse Team - responsible for deadlines and milestones along with managing a team of 5full-time database developers.
- Participate in technical working sessions such as requirements definition, functional walkthroughs, technical design reviews, change control sessions and stakeholder meetings.
- Contribute to the solution to expand the functionality in existing designs, and possible new ones while exploring any limitations of the SAP Business Warehouse framework.
- Led project ($10M our component) that reduced nightly SAP HRDW processing time by 100%+ (three and a half hour process down to 14 minutes). Managed project team of 50+ rotating staff and international consultants
- Provided metrics, statistics, scope of work estimates, project plans that facilitated decision making for corporate initiatives.
- Led team in the SAP / HRDW integration, support, and testing for the conversion of Human Resources data from legacy systems to allow online (web) access for all IP personnel.
- Developed SAP help desk support plan and training procedures for My-IP online system.
- Supervised eight employees (exempt and contractors).
- Managed the Xpedx payroll online integration project.
0-5 years of experience
Manage, plan, direct and coordinate the activities of the development team that provides the foundation for CDW's data warehousing, business intelligence and corporate reporting infrastructure.
- More than doubled the size of the team, from 5 direct reports to 10+
- Managed the building of the Customer Segmentation Engine for Marketing and Sales
- Managed the creation and support of the data foundation for CDW's CRM systems
- Hands on data warehouse development using Microsoft Technologies
6-10 years of experience
- Led a team of 12 developers to build SAP Business Objects and Hyperion Financial reports, which automated the manual offline Excel workbooks for business end users and executives including the CEO and CFO.
- Provided comprehensive reporting, analytical, and advisory services to Finance, Human Resources, and Global
- Gathered, rationalized, and prioritized requirements to enable customers to make valuable business decisions
- Performed source system analysis and back end data investigation to determine the development level of effort
- Designed metadata layers and reports to facilitate ad hoc reporting the scalable ever changing business needs
- Tested reporting solutions and conducted User Acceptance testing and training sessions for customers
- Supported Finance, Sales, and Human Resources business areas by implementing bug fixes and enhancements
0-5 years of experience
Established an Enterprise Data Warehouse (EDW), utilizing an Oracle database environment on an HP-Unix platform, for 150+ users at division's 6+ North American production facilities. Collected and documented business requirements prior to developing divisional business intelligence (BI) environment using Cognos suite of tools (including PowerPlay cubes, Impromptu reports, and ReportStudio reports).
- Led 2-year effort, based on a $250K budget, to upgrade EDW to extract data from an Oracle Applications 10.7 to 11i environment. ETL logic included Oracle modules Accounts Receivable (AR), Bills of Materials (BOM), Inventory (INV), Order Entry (OE), and Purchasing (PO).
- Managed ETL and development life cycle of approximately 35 EDW business domains, sourcing data from the Oracle Applications (ERP), with a staff of 6 people. Responsible for the design, definition, and modification of 100+ data models used to define star schema domains in EDW.
- Developed, tuned, and validated Oracle Application (ERP) ETL logic. Defined Cognos Impromptu catalog and ReportNet package data models sourcing data from the Oracle Applications.
- Established IT internship program with WMU which led to eventual hiring of 2 people. Supervised EDW and BI development efforts of 3+ consultants.
- Defined EDW and Cognos BI security models in accordance to Sarbanes-Oxley requirements. Included the development of web-based access request forms utilizing HTML and ASP development.
0-5 years of experience
Built and managed the ETL and reporting teams (three to seven individuals).
- Managed data warehouse enhancements and defects (requirements, estimation, prioritization, development, testing, and implementation).
- Responsible for data warehouse and report release management.
- Ensured that reporting was accurate and met the business requirements.
- Established consistent processes for code reviews and quality assurance.
0-5 years of experience
Designed first-ever data warehouse for the company.
- Created project plan, established and monitored milestones, identified and mitigated risks and issues, managed performance of resources
- Evaluated and recommended Extract Transform Load (ETL) and Business Intelligence (BI) vendors
- Mapped On-Line Transaction Processing (OLTP) sources to data warehouse tables
0-5 years of experience
Responsible for leading the design, development and maintenance efforts of the company's insurance related data warehouse of 5 million dollars. Responsible for Enterprise Architecture.
- Created and managed project budget vs. actual expenditures (capital and expense). Managed the team's day to day activities to ensure on budget and on time delivery of all applications. Reported progress to the steering committee.
- Prepare project plans, milestones, and resource allocation. Execute projects with resources On-Site as well as Off-Shore. Interact with business users; gather requirements; develop ETL design; prepare mapping documents, develop high level and detail ETL designs.
- Defined areas of improvement to optimize data flows. Conducted root cause analysis and resolved production related problems and data issues. Implemented industries best practices for software development.
- Monitored performance of production Extract, Transformation and Load (ETL) processes and responded to errors and emergency problems.
0-5 years of experience
Assumed management responsibility for an 18-terabyte data warehouse of customer, account and transaction information for use in key operational processes within Risk Management, Finance, Marketing, Customer Service and Originations functional areas; oversaw ETL development that transformed and loaded data into data warehouse and extracted and transformed data coming out of data warehouse; provided business intelligence solutions to meet analytical needs across the enterprise; collaborated with Technical Operations organization for tech refreshes of server, database and software to support data warehouse maintenance and expansion.
- Developed customer data interchange process and supporting system with Retail Bank to facilitate credit card utilization for overdraft protection, customer cross-sell and customer privacy regulations
- Managed relationship with prior card processor vendor, FDR, for all incoming extracts; rationalized incoming data extracts to remove redundant data and lower vendor costs by 65%
- Managed conversion of historical data in data warehouse from FDR to TSYS card processor platforms to support $500M enterprise effort to change processors
0-5 years of experience
- Responsible for the establishment of a Global Information Exploitation team in the US to support the strategic enterprise information needs of the L&H business unit globally. This included transitioning work and knowledge from London to Armonk and developing the new team of 15 developers
- Set-up and implemented fully outsourced offshore development model while continuing to successfully deliver major releases of the Global L&H Information Exploitation Data Warehouse and downstream interfaces. This resulted in reduced costs and the ability to plan each release based on a flexible resourcing.
- Successfully lead the project work-stream to deliver the Global Enterprise Information Exploitation system (consisting of 110 globally standardized reports) to the US business unit thus aligning the UK & US business processes allowing for consistent global management reporting. The project team consisted of 20 people spread across 3 different countries and 3 different vendors.
- Defined and implemented new software development processes and procedures such as causal analysis, code versioning, change management and integration testing which resulted in improved quality of deliverables and reliable timelines
- Re-defined quality assurance testing approach for DWH and Reporting resulting in substantially increased coverage and effectiveness of independent testing
0-5 years of experience
Manages data quality standards of the Heart and Vascular Institute data warehouse for clinical outcomes research.
- Integrates data from legacy systems
- Maps data from source electronic systems
- Standardizes data utilizing standard nomenclatures
- Creates logic for Statistical Analysis
- Analyzes data integrity and implements process improvements
- Remediate impact of ICD-10 implementation on The Heart and Vascular Institute's Quality, Reporting and Research
0-5 years of experience
- Responsible for leading the data warehouse and business intelligence efforts of 4 IT professionals
- Highly technical role requiring significant DBA, T-SQL, and ETL knowledge and effort
- Identify, capture, and analyze billions of records for retail clients all while maintaining strict confidentiality. Analysis includes piecing together disparate datasets, identifying trends, and developing algorithms to determine relevancy and isolate data abnormalities.
- Role includes technical architecture and design, prioritization and planning, and coordinated execution. My DBA responsibility includes maintenance, deployment, and optimization of dozens of databases representing terabytes of data.
- Implemented a new structure to standardize, log, and automate various SQL functions. The result has been significantly cleaner data, fewer issues when building datasets, and significant performance gains when querying the data.
- Streamlined data gathering which greatly improved speed (over 300% improvement) and reliability.
- Improved analysis and reporting of one of the most difficult segments of retail sales, namely special orders. Actively consulted with a major retailer to show them how to improve their reporting of this segment of sales.
- Implemented a thin client architecture greatly improving the speed and reliability of transactions.
0-5 years of experience
Enterprise Information Management (EIM)
- Led development of multiple, concurrent Business Intelligence projects, creating SQL datamarts, ETL applications, querying/reporting semantic layers and cubes for various business units and business processes, i.e., Medical Claims, Pharmacy, Dental and Enrollment
- Managed successful Pharmacy Benefits Manager (PBM) conversion from Express Scripts (ESI) to Caremark
- Performed Gap Analysis of Caremark Pharmacy Claim feeds and worked closely with Pharmacy and Finance Analysis Departments to mitigate any risks
- Designed CDC application with goal to reduce weekly processing window for SAS Data Warehouse by 80%
- Led teams of up to 4 onsite and 3 offshore ETL/BI developers
- Led successful project to upgrade the BI architecture from a SQL Server 2008 dual server to quad server SQL Server 2008 R2 environment
- Responsible for maintaining BI Applications installed on 4 servers
- Technical owner of Business Intelligence initiative, responsible for reporting state of Business Intelligence projects to Sponsors, Senior Executive Staff
0-5 years of experience
Primary responsibilities include analysis, design, deployment and management of data warehouse
- Utilized SQL Server 2000 and SSRS 2000 to deploy data warehouse and associated reporting
- Support applications, such as ETL, written in C# and ASP.NET
- Led team of 2 - 3 members
0-5 years of experience
- Designed and implemented an operational data storage (ODS) and a data mart containing time-sensitive commercial loans and their risk status for the Risk Management Department to study bank's risks
- Designed and implemented a Consumer Assets Management data mart used for BankCard cardholders behavioral study to help prevent bankcard frauds
- Designed and implemented a Loan Portfolio Management data mart used to report loan balances
- Designed and implemented a Customer Profitability data mart used to retain profitable customers and products and to support MS4B database, a Sales Force Automation product by KPMG consulting group
- Designed and implemented a Customers Y2K Compliance Tracking data mart used to track Y2K compliances
- Analyzed and managed the extract process to support OFSA, a financial management product by Oracle
- Analyzed and managed a Global Management data mart to collect international trade finance data
10+ years of experience
- Develop reporting and analytical tools that allow stakeholders to more effectively run their business units.
- Determine the best approach to successfully maintaining and preparing reports.
- Scheduled and maintained the automatic generation of tables and reports using the Hyperion BI reporting tool.
- Work with users to analyze current business processes and procedures to help identify gaps and areas for process improvement.
- Oversee data integrity in all reporting applications and coordinate with teams to ensure processes or policies are addressed as issues are identified.
- Systems administrator for the Salesforce CRM and Hyperion BI systems. Manage users, roles, jobs schedules, data integrity, data imports/exports, design page layouts and manage vendor relationships.
0-5 years of experience
Mainframe Environment: IBM MVS/TSO/ISPF/MVS/DB2/Focus, IBMVM/CMS/ISPF/Focus, NCR Teradata
PC Environment: Windows NT workstation, MS Office, Netscape, Internet Explorer, Queryman, Brio
- Year 2000 conversion on VM and MVS platforms with fixes on failure
- SQL Assistant/Queryman access to Teradata for LOCS reporting
- Supplier Compliance extracts, ad hoc reports and problem investigation and research
- Sole maintenance and development for VM/MVS Logistics Legacy systems involving DISP, FLASH, WIPR
- Internal JCPenney conversion from VM/Focus to MVS/Focus on Legacy systems
- ETL from MVS or VM data into Excel or Access DBs
- ETL from Excel extracts into MVS or VM files
6-10 years of experience
Merge budget data (format spreadsheets, apply formulas, link spreadsheets, pivot tables, charts.) collected from multiple source into a single coherent workbook using MS Excel.
- Develop, maintain and support application programs such as VB .Net, advanced Excel and Access VBA
- Develop database using Oracle and Access.
- Responsible for overseeing the inventory management process, defining departmental strategies for appropriate inventory levels
- Plan or implement material flow management systems to meet production requirements.
- Understanding of the whole supply chain to co-ordinate it effectively & liaise with suppliers of raw materials, manufacturers, retailers & consumers
0-5 years of experience
Planning, Scoping in-sourcing from IBM to bring all IT, Servers, FTE's, Support, Servers, from Unix to Linux Vblock environment.
- Planning budgeting resources to build new EDW environment due to In-Sourcing of all 5 [company name] projects to centralized EDW on Vblock using Oracle 11g and Informatica Power Exchange and Power Center.
- Planning and scoping future Enterprise Data Warehouse Architecture for Operational environment for near real-time dashboard and score card reporting status of cars and trains locations, events and cargo.
- Planning and scoping Enterprise Data Warehouse future Architecture of Operational and Analytical processing and integration of enterprise subject area data to provide business with answers to their data following Inmon and Kimball methodologies.
- Crating resource training plan as well resource plans for 2013 and 2014 for EDW future support and development.
- Designing and developing EDW roadmap as well planning, analysis and design methodology to follow.
- Working towards building Enterprise Data Warehouse Data Architecture using Sybase Power Designer and building enterprise data standards, best practices, principles, policies and procedures.
6-10 years of experience
Responsible for the planning and implementation of a data warehouse utilizing the Informix Online Dynamic Server and HP Information Access on an HP9000 server with Windows 95 clients
- Responsible for designing and implementing a comprehensive sales reporting system and developing ETL processes to supply data from a Sequoia source to a Visual Basic EIS application.
- Responsible for defining and populating multidimensional hyper cubes using Cognos PowerPlay to support sales and marketing analysis activities.
- Responsible for the definition and implementation of an isolated software development environment and participated in the development of supporting change management procedures.
0-5 years of experience
Lead BI Developer with 4 direct reports responsible for SQL Data Warehouse maintenance and ongoing development.
- Duties included leading projects, creating RFP's, creating SOW's, managing near shore and off-shore resources, performance reviews, tool selection, project closure.
- Day to day oversight of data loads from source systems to global data warehouse as well as ongoing development of infrastructure to support reporting. All ETL work including maintaining legacy DTS packages and conversion to SAP Data Integrator. Creation of star schema data marts to facilitate faster more integrated reporting from multiple source systems.
- [company name] environment. Including Data Integrator servers for ETL work, Business Objects Enterprise Premium release 2 servers, test and development environments, and Crystal Reports XI user support.
- Creating views, stored procedures, star schema's, business views, universes, summary tables, and OLAP cubes to support reporting.
10+ years of experience
Manager for all enterprise data warehousing, BI information architecture, and corporate reporting functions within Information Technology's Applications Development unit.
- Manage the corporate data warehouse (DW) including ETL, data architecture, data integration, and database administration. DW includes customer sales, marketing and inventory information for direct and catalogue sales, web store, event sales, and field representative sales.
- Responsible for project management, project scoping, resource planning, and resource allocation for all data warehouse projects.
- Work in conjunction with other IT and functional areas on project scoping, resource planning, and resource allocation for enterprise wide projects that involve data warehousing and BI.
- Analyze the needs of different departments and determines ways to meet the information and business intelligence needs to assist them in meeting their business objectives.
- Responsible for all user views into the database by in house application, reporting tool, query tool and other third party application.
- Responsible for data migration between the DW and Salesforce.com
- Responsible for conceptual and logical design of the data warehouse.
- Responsible for the design and development of all reporting, BI, and other analytics off of the data warehouse including sales analysis, cost analysis, inventory, customer segmentation, predictive modeling, and data mining.
- Directly supervise team of business analysts/developers assisting in these responsibilities.
- Work closely with company controller, internal auditing, and marketing departments.
0-5 years of experience
I was promoted to this business role that reported directly to the global business champion. This role was led/participant of a global cross functional team responsible for the deployment and governance of the data warehouse, data mart, master data, associated ETL streams and the analytic applications. I was led/participant responsible for creation and implementation of the project's master data (MDM) and product data integration (PDI) strategies.
- As the projects data quality assurance lead I was liaison with both vendor's (IBM and EDS) development and productions teams while responsible for production data validation audits, design of data campaigns (fixes), data profiling and analysis for new data warehouse feeds.
- Led/participant of the data governance, change control and global data steward councils.
- Hands on use of SQL (DB2 UDB), SAS EG, MS Access, SQL Server 2005, InfoSphere ProfileStage to perform data profiling and to audit and valid data and the data streams transformations processes.