...Data Warehouse/Data Mart Design, ETL, BI and Client/Server applications. * Certified in ICS PowerCenter Data Integration Developer Specialist 9.0 and Teradata 12 TE0-121 Certified Professional Program. * Extensively worked on Data Extraction, Transformation and Loading of data from various sources like Oracle, SQL Server, Flat files and COBOL Sources. * Worked extensively with Slowly Changing Dimensions. * Working knowledge of Teradata as a Developer with proficiencies in Teradata SQL Assistant utilities like Fastload, Multiload, BTEQ, FastExport, and Tpump. * Experience in Teradata Data Warehouse architecture. * Proficient in application development and support, for batch processes hosted on an IBM mainframe, with a core focus in COBOL, DB2, JCL and VSAM. * Hands on experience in performance tuning, resolving on-going maintenance issues and monitoring of production runs. * Data modeling using Erwin, Star Schema, Snowflake, FACT and dimension tables. * Hands on experience in UNIX shell scripting. * Excellent communication and interpersonal skills. TECHNICAL SKILLS Frameworks | Informatica Data Director (IDD), Informatica System Integration Framework (SIF), Teradata version 12, Mainframe z/OS | Application Modules | UNIX, Informatica Application Designer, Workflow Manager, Workflow Monitor, Repository Manager, Informatica B2B...
Words: 1062 - Pages: 5
...for an IBM Customer. This document is presented “As-Is” without any warranty, guarantee or assurances of any kind, either express or implied. IBM does not assume responsibility for the statements expressed herein and it reflects the opinions of the author. If you have questions about the contents of this document, please direct them to the author at rsingh@us.ibm.com. Author is not responsible for errors in this document that may result in any kind of inaccuracies. Acknowledgements Thanks to John R Hock, IBM Certified IT Specialist – System p - Advanced Technical Support Americas (ATS) for reviewing this White Paper. Thanks to the customer and IBM team for their contribution and support to this project. Trademarks The following terms are registered trademarks of International Business Machines Corporation in the United States and/or other countries: AIX, AS/400, DB2, IBM, Micro Channel, MQSeries, Netfinity, NUMAQ, OS/390, OS/400, Parallel Sysplex, PartnerLink, POWERparallel, RS/6000, S/390, Scalable POWERparallel Systems, Sequent, SP2, System/390, ThinkPad, WebSphere. The following terms are trademarks of International Business Machines Corporation in the United States and/or other countries: DB2 Universal Database, DEEP BLUE, e-business (logo), GigaProcessor, HACMP/6000, Intelligent Miner, iSeries, Network Station, NUMACenter, POWER2 Architecture, PowerPC 604,pSeries, Sequent (logo), SmoothStart, SP, xSeries, zSeries. A full list of U.S. trademarks owned by IBM may be...
Words: 6610 - Pages: 27
...SELECT e.firstName,c.CompanyName FROM Employees e JOIN Orders o ON e.employeeID=o.employeeID JOIN Customers c ON c.customerID=o.customerID ORDER BY e.firstName,c.CompanyName | | Compelling, but we see that there's many repeated entries in the list. We'd like to count up how many sales are at the intersection of each distinct customer and salesperson. To do this we'll add in a COUNT function and GROUP BY clause. SELECT e.firstName,c.CompanyName, COUNT(o.orderID) FROM Employees e JOIN Orders o ON e.employeeID=o.employeeID JOIN Customers c ON c.customerID=o.customerID GROUP BY e.firstName,c.CompanyName ORDER BY e.firstName,c.CompanyName | | Now the real fun begins as we transition this into a query that uses PIVOT. Because we're grouping by not one but two columns, this query is a good candidate for PIVOT. We'll start simple with a query that doesn't JOIN anything, but just references the Orders table. We'll choose to have Employee data put into columns since there are only 9 employees. Much more manageable. In this case the numbers 1 through 9 refer to the ID of employees: SELECT * FROM Orders PIVOT (COUNT(employeeID) FOR employeeID IN ([1],[2],[3],[4],[5],[6],[7],[8],[9])) p In the result set notice that the specific columns returned come from the result of the PIVOT clause and not directly from the Orders table! And that PIVOT clause brings up every column from the Orders table except for employeeID, which gets weeded out since it...
Words: 1353 - Pages: 6
...different databases such as the Oracle 11G, MySQL, IBM DB2, and Microsoft Sql Server 2008 which are all impressive databases, I chose to implement the IBM DB2 database system for Wildwood apartments. The key features that IBM DB2 has are table partitioning, database portioning, massively parallel processing (MPP), Continuous Ingest, Multidimensional clustering (MDC), Aggregates, Multi-Temperature Data Management, Mixed Workload Management, and Control over Workloads. DB2 has a number of performance optimization capabilities that give you the insight and ability to optimize workload execution. (DB2 for Linux, UNIX, and Windows) IBM DB2 meets the requirements for Wild Wood Apartments database so the managers can input the lease information, rent payment, maintenance request and with ease complete there quarterly reports. These capabilities can save you money and lower your risks by helping you to do more work with your existing hardware, ensure Service Level Agreements (SLAs) are met or exceeded and increase DBA productivity. (DB2 for Linux, UNIX, and Windows) The database is user friendly and the apartment managers should have no problem navigating through the system to input the information. This is essential DB2 transparently splits the database across multiple partitions and uses the power of multiple servers to satisfy requests for large amounts of information. (DB2 for Linux, UNIX, and Windows) Another reason why I chose IBM BD2 I because of...
Words: 628 - Pages: 3
...IBM DB2 Universal Database ® ™ Business Intelligence Tutorial: Extended Lessons in Data Warehousing V ersion 8 IBM DB2 Universal Database ® ™ Business Intelligence Tutorial: Extended Lessons in Data Warehousing V ersion 8 Before using this information and the product it supports, be sure to read the general information under Notices. This document contains proprietary information of IBM. It is provided under a license agreement and is protected by copyright law. The information contained in this publication does not include any product warranties, and any statements provided in this manual should not be interpreted as such. You can order IBM publications online or through your local IBM representative. v To order publications online, go to the IBM Publications Center at www.ibm.com/shop/publications/order v To find your local IBM representative, go to the IBM Directory of Worldwide Contacts at www.ibm.com/planetwide To order DB2 publications from DB2 Marketing and Sales in the United States or Canada, call 1-800-IBM-4YOU (426-4968). When you send information to IBM, you grant IBM a nonexclusive right to use or distribute the information in any way it believes appropriate without incurring any obligation to you. © Copyright International Business Machines Corporation 2000 - 2002. All rights reserved. US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. Contents About the...
Words: 7362 - Pages: 30
...Proposal – Data Warehouse Inventory What is data warehouse? It’s a simple assembling of data gathered from various sources and available to the global customers in a way they can understand to their business level. Statement of Problem: Our intention is to develop inventory application (User interface) so that client can easily track their warehouse. For creating interface we are using ETL and IBM Cognos. Methods to solve problem: * Creating Database for customer * Extract transform and loading the data * Data Mapping * Creating Package from Framework Manager using IBM Cognos * Developing Interface using IBM Cognos Report Studio Tools: IBM DB2, Informatica Power center, IBM Cognos 10.2 Resources: 3 Client: Volvo Trucks. Software Development Life Cycle 1. Requirements 2. Design 3. Development 4. Testing 5. User Signoff Requirements for data warehouse design: A. Goals: 1. To design the flexible data warehouse as per the client requirements. 2. Get the raw data into the centralized repository so that the users can access it in a flexible manner. 3. We should make sure the data cannot be edited by the users. B. Clients Requirements: 1. We need to get all the details of the client products available in their inventory. 2. We need to study the client environment and take down the end to end process. C. Business Questions: 1. Need to discuss about the design duration. 2. Number of resource required for the...
Words: 316 - Pages: 2
...correct? A. NUMTCB parameter must be set to 1 for Java stored procedures. B. NUMTCB parameter must be set to 1 for REXX stored procedures. C. NUMTCB parameter can be a value greater than 1 for native SQL stored procedures. D. NUMTCB parameter can be a value greater than 1 when a stored procedure invokes DB2 utilities. Answer: B 2.If a single row of the PLAN_TABLE has a 'Y' value in more than one of the sort composite columns, what is indicated.? A. The next sort step will perform two sorts. B. There are multiple sorts in the plan step. C. One sort in the plan step will accomplish two tasks. D. Two sorts are performed on the new table of a star join. Answer: C 3.What IBM provided stored procedure will access DB2 real time statistics tables? A. DSNAEXP B. DSNAIMS C. DSNACCOX D. DSNLEUSR Answer: C 4.The EXPLAIN STMTCACHE ALL statement provides information about SQL tuning. Which information is part of the DSN_STATEMENT_CACHE_TABLE? A. Filter factor information. B. Stage 1 and stage 2 information. C. Number of columns used in an index. D. Number of times an SQL statement is executed. Answer: D 5.Which two of the following DB2 performance features will ignore clustering in favor of faster insert performance? (Choose two.) A. Append B. Inline LOBs C. Member cluster D. Volatile table E. Include columns Answer: A,C 6.When is a merge scan join a well performing access path? A. When the number of qualifying rows of...
Words: 8187 - Pages: 33
...1 On Demand Business Volkswagen’s world-class procurement strategy produces breakthrough productivity gains. Based in Wolfsburg, Germany, Volkswagen AG (www.volkswagen.de) is Europe’s largest auto manufacturer with worldwide revenues approaching $110 billion and manufacturing facilities on every continent. While perhaps best known for its VW and Audi brands, Volkswagen is also the company behind such storied brands as Bentley, Bugatti and Lamborghini. Amid the everincreasing competition in the worldwide auto industry, Volkswagen has long set itself apart through the design and Volkswagen is the company behind such storied brands as Audi, Bentley, Bugatti and Lamborghini. Overview Challenge Faced with rising complexity within its supplier-facing processes, Volkswagen needed to make its employees more productive to stay ahead of the competition Why Become an On Demand Business? Volkswagen needed to integrate its information and processes to speed decision-making and become more responsive to a rapidly changing supplier environment Solution An On Demand Workplace that includes an enterprisewide portal for employees and suppliers whose sensing, analytic and workflow capabilities have radically streamlined the way employees access and act on information Key Benefits • 20% increase in procurement staff productivity • Expected 100% payback within one year • Significant decreases in materials purchasing and inventory costs “We need knowledgeable ...
Words: 2558 - Pages: 11
...The Journey of (IBM) International Business Machines Executive summary: The current Proposal intended to describe what IBM has faced in its journey and how it overcame those problems, which it was unprepared in the first place. To discuss the Success Story of IBM (International Business Machines) and journey through some easy and some tough winters. The focus will be on the problems. Introduction: IBM is one of the world’s largest rapid growths IT Company in terms of revenue, which listed in fortune 100 IT companies.IBM has produced different products, which related to software and hardware and produced custom designed microchips. By producing low cost products, IBM has rapid growth with long-term success, which attracted the investors and competitors. The head quarters were located in New York. In 2012, it has ranked 2 largest US firm for having highest numbers of employees nearly 433,362 by fortune. They have developed a wide range of software development tools, which helps to manage business process etc. IBM has first started its invention in 1914 called Hollerith, which was a part of computing -tabulating- recording company later the company known as IBM. (Rouse, 2006) Background: ...
Words: 1222 - Pages: 5
...Front cover Advanced Case Management with IBM Case Manager Introducing case management and IBM Case Manager Building IBM Case Manager solutions with use case example Covering customization, rules, deployment, and more Wei-Dong Zhu Brian Benoit Bob Jackson Johnson Liu Mike Marin Seema Meena Juan Felipe Ospina Guillermo Rios ibm.com/redbooks International Technical Support Organization Advanced Case Management with IBM Case Manager May 2014 SG24-7929-03 Note: Before using this information and the product it supports, read the information in “Notices” on page xiii. Fourth Edition (May 2014) This edition applies to Version 5.2.0, IBM Case Manager (product number 5725-A15). © Copyright International Business Machines Corporation 2013, 2014. All rights reserved. Note to U.S. Government Users Restricted Rights -- Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. Contents Notices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii Trademarks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiv Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv Authors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv Now you can become a published author, too! . . . . . . . . . . . . . . . . ...
Words: 95119 - Pages: 381
...IT460 Unit 4 Assignment Dwayne M Sullivan Kaplan University Context Level Diagram This context diagram shows the scope and boundaries of the Training Information Management System. In this diagram, we see that the central process, which is the TIMS, will interact with six entities, which include the corporate client, the training administrator, the instructor, the student, the course, and the accounting system. Moreover, the interaction among these entities will involve six different data flows. The corporate client will be provided a training summary. The training administrator will receive training reports and will supply schedule decisions. The instructor will supply completion data and receive a class roster and course assignments. The accounting system will receive data regarding accounting. The course will receive course data from and supplied data back to the system. The student will request courses. When their request is processed, they will receive a confirmation and an invoice. The student can then submit a payment. Level 0 Diagram The training administrator will submit schedule decisions which are processed by the manage course scheduling process. The course management scheduling process will supply information about the course offered. This information might include course times, schedules, descriptions and so forth. The manage course scheduling process will also receive information from the courses. The Manage Course Scheduling process...
Words: 694 - Pages: 3
...International Business Machines, abbreviated IBM and nicknamed "Big Blue" (for its official corporate color) was incorporated in the State of New York on June 16, 1911, is a multinational computer technology and IT consulting corporation headquartered in Armonk, New York, United States. Now, the chairman and CEO of IBM Company is Samuel J Palmisano. IBM manufactures and sells computer hardware and software, and offers infrastructure services, hosting services, and consulting services in areas ranging from mainframe computers to nanotechnology. IBM has been well known as one of the world's largest computer companies and systems integrators. With over 388,000 employees worldwide, IBM is one of the largest and most profitable information technology employers in the world. IBM holds more patents than any other U.S. based Technology Company and has eight research laboratories worldwide. The company has scientists, engineers, consultants, and sales professionals in over 170 countries. IBM employees have earned Five Nobel Prizes, four Turing Awards, five National Medals of Technology, and five National Medals of Science. IBM competitors IBM's main competitors are Hewlett-Packard Company (HPQ) and Dell (DELL) but each of these companies has a different focus area. Dell makes most of its money on PC and server hardware, while Hewlett-Packard is more diversified as the leader in PCs and Imaging & Printing as well as offering IT services. Since IBM relies heavily on its Software and Services...
Words: 4643 - Pages: 19
...IBM Global Business Services Human Capital Management Achieving success in a globally integrated world: Enabling an adaptable workforce 2 You’ve remodeled your supply chain. Optimized your IT infrastructure. Overhauled your financials. But you’re still not getting the results you expect. So what’s missing? Like many companies, you may be overlooking your most valuable asset: your people. While human capital is an organization’s single largest resource, many companies don’t utilize their workforce to its fullest — even when they’ve been successful in maximizing other strategic business areas — leaving a huge opportunity untapped. By looking to the workforce to improve enterprise adaptability, innovation and productivity, corporate leaders can differentiate their businesses and stay ahead of the competition. Yet, to achieve true differentiation, companies must develop a more responsive, flexible and resilient workforce by finding better ways to source talent, allocate resources across competing initiatives, measure performance and build vital capabilities and skills. This requires developing programs that focus on workforce performance, identifying and employing talent globally, working collaboratively to accelerate change, generating innovation and producing measurable business results — now and into the future. 3 Providing solutions based on solid research IBM’s Global Human Capital Study 2008, which reflects the insights of over 400 senior executives...
Words: 2555 - Pages: 11
...worst year in its history. A lot of people chalk that up to the recession and the “dot-com bubble.” They seem to believe that when the economies of the world recover, life in the information technology industry will get back to normal. In my view, nothing could be further from the truth. Lou Gerstner, IBM Annual Report, 2001 In 1990, IBM was the second-most-profitable company in the world, with net income of $6 billion on revenues of $69 billion, and it was completing a transformation designed to position it for success in the next decade. For the world leader in an industry that expected to keep growing spectacularly, the future looked promising. But all was not well within IBM, and its senior executives realized it. “In 1990, we were feeling pretty good because things seemed to be getting better,” one executive remarked. “But we weren’t feeling great because we knew there were deep structural problems.” Those structural problems revealed themselves sooner than anyone expected and more terribly than anyone feared. Beginning in the first quarter of 1991, IBM began posting substantial losses. Between 1991 and 1993, IBM lost a staggering $16 billion. In April 1992, John Akers, IBM CEO from 1985 to 1993, vented his frustrations during a company training program. His comment, “People don’t realize how much trouble we’re in,” made its...
Words: 13418 - Pages: 54
...IBM REINVENTING EDUCATION: Research Summary and Perspective Introduction People all over the world are obsessed with improving public education. During the last US election, Americans split historically over who would be the next president. But they were passionately united on the highest priority of the new administration: Fix education. In poll after poll, people listed poor student performance as the nation's greatest liability and its most critical need. Despite years of debate and scrutiny, worldwide comparisons like the Third International Mathematics and Science Study revealed the true extent of failing schools in the US. And while fixing public education tops our national agenda and many public and private institutions have attempted to address the challenge success stories are few and far between. Compounding the problem is a changing world with growing emphasis on highly-skilled individuals. Today's expectations for schools - that ALL children will achieve at a level much higher than required in previous eras - demands much more than a quick fix or a cosmetic approach. Poorly trained teachers, unfocused curriculum, and the inefficient use of resources inevitably result in poor student performance and the inability to compete globally. For the US, the stakes have gone up dramatically. People have also reached consensus on what public school reform looks like. It involves a radical shift from the status quo, with a new foundation built on standards, accountability, and...
Words: 5886 - Pages: 24
